addfreeone.asp

后台目录:qwbAdmin/Login.asp 登陆用户名:admin 登陆密码:admin

	var Sql_End_Str = '';
	var Sql_Split_Arr = '';
	var Replace_Sql_Str = '';
	var split_order_str = '';
	var split_order_Arr = '';
	var Where_No_And = '';
	var Order_End_Str = '';
	var R_Str_Arr = '';
	var R_Str_Str = '';
	var R_Str_End = '';
	if (Sql_Str != '')
	{
		if (str == 'left')
		{
			if (LeftRulerStr != '' && Left_Ruler != '' && Left_Ruler_Txt != '')
			{
				if (Select_Fields_right != '')
				{
					if (LeftRulerStr.indexOf('Mid') == -1 && LeftRulerStr.indexOf('SubString') == -1)
					{
						Ruler_Str = LeftTable_Name + '.' + 	LeftRulerStr;
					}
					else
					{
						R_Str_Arr = LeftRulerStr.split('(');
						R_Str_Str = R_Str_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
						R_Str_End = R_Str_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
						Ruler_Str = R_Str_Str + '(' + LeftTable_Name + '.' + R_Str_End;
					}
				}
				else
				{
					Ruler_Str = LeftRulerStr;
				}	
				if (Sql_Str.indexOf('Where') == -1)
				{
					if (Sql_Str.indexOf('Order By') == -1)
					{
						switch (Left_Ruler)
						{
							case "In":
								Where_Str = Ruler_Str + ' In(' + Left_Ruler_Txt + ')';
								break;	
							case "Like":
								Where_Str = Ruler_Str + ' Like \'%' + Left_Ruler_Txt + '%\'';
								break;
							default:
								Where_Str = Ruler_Str + ' ' + Left_Ruler + ' ' + Left_Ruler_Txt;
								break;
						}
						document.List_Form.DisSql.value = Sql_Str + ' Where ' + Where_Str;
					}
					else
					{
						Sql_Split_Arr = Sql_Str.split('Order By');
						Sql_Start_Str = Sql_Split_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
						Sql_End_Str = Sql_Split_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
						switch (Left_Ruler)
						{
							case "In":
								Where_Str = Ruler_Str + ' In(' + Left_Ruler_Txt + ')';
								break;	
							case "Like":
								Where_Str = Ruler_Str + ' Like \'%' + Left_Ruler_Txt + '%\'';
								break;
							default:
								Where_Str = Ruler_Str + ' ' + Left_Ruler + ' ' + Left_Ruler_Txt;
								break;
						}
						document.List_Form.DisSql.value = Sql_Start_Str + ' Where ' + Where_Str + ' Order By ' + Sql_End_Str;
					}
				}
				else
				{
					Sql_Split_Arr = Sql_Str.split('Where');
					Sql_Start_Str = Sql_Split_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
					Sql_End_Str = Sql_Split_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
					switch (Left_Ruler)
					{
						case "In":
							Where_No_And = Ruler_Str + ' In(' + Left_Ruler_Txt + ')';
							break;	
						case "Like":
							Where_No_And = Ruler_Str + ' Like \'%' + Left_Ruler_Txt + '%\'';
							break;
						default:
							Where_No_And = Ruler_Str + ' ' + Left_Ruler + ' ' + Left_Ruler_Txt;
							break;
					}
					if (Sql_End_Str.indexOf(Where_No_And) == -1)
					{
						Where_Str = Where_No_And + ' And ';
						document.List_Form.DisSql.value = Sql_Start_Str + ' Where ' + Where_Str + Sql_End_Str;
					}
					else
					{
						if (Sql_End_Str.indexOf('Order By') == -1)
						{
							split_order_str = Sql_End_Str
							Order_End_Str = '';
						}
						else
						{
							split_order_Arr = Sql_End_Str.split('Order By');
							split_order_str = split_order_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
							Order_End_Str = ' Order By ' + split_order_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
						}
						Replace_Sql_Str = split_order_str.replace(Where_No_And + ' And ','').replace(' And ' + Where_No_And,'').replace(Where_No_And,'').replace(/^\s+/,'').replace(/\s+$/,'');
						if (Replace_Sql_Str != '')
						{
							document.List_Form.DisSql.value = Sql_Start_Str + ' Where ' + Replace_Sql_Str + Order_End_Str;
						}
						else
						{
							document.List_Form.DisSql.value = Sql_Start_Str + Order_End_Str;
						}	
					}
				}
			}
			else
			{
				return;
			}
		}
		else if (str == 'right')
		{
			if (RightRulerStr != '' && Right_Ruler != '' && Right_Ruler_Txt != '')
			{
				if (Select_Fields_Left != '')
				{
					if (RightRulerStr.indexOf('Mid') == -1 && RightRulerStr.indexOf('SubString') == -1)
					{
						Ruler_Str = RightTable_Name + '.' + RightRulerStr;
					}
					else
					{
						R_Str_Arr = RightRulerStr.split('(');
						R_Str_Str = R_Str_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
						R_Str_End = R_Str_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
						Ruler_Str = R_Str_Str + '(' + RightTable_Name + '.' + R_Str_End;
					}
				}
				else
				{
					Ruler_Str = RightRulerStr;
				}	
				if (Sql_Str.indexOf('Where') == -1)
				{
					if (Sql_Str.indexOf('Order By') == -1)
					{
						switch (Right_Ruler)
						{
							case "In":
								Where_Str = Ruler_Str + ' In(' + Right_Ruler_Txt + ')';
								break;	
							case "Like":
								Where_Str = Ruler_Str + ' Like \'%' + Right_Ruler_Txt + '%\'';
								break;
							default:
								Where_Str = Ruler_Str + ' ' + Right_Ruler + ' ' + Right_Ruler_Txt;
								break;
						}
						document.List_Form.DisSql.value = Sql_Str + ' Where ' + Where_Str;
					}
					else
					{
						Sql_Split_Arr = Sql_Str.split('Order By');
						Sql_Start_Str = Sql_Split_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
						Sql_End_Str = Sql_Split_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
						switch (Right_Ruler)
						{
							case "In":
								Where_Str = Ruler_Str + ' In(' + Right_Ruler_Txt + ')';
								break;	
							case "Like":
								Where_Str = Ruler_Str + ' Like \'%' + Right_Ruler_Txt + '%\'';
								break;
							default:
								Where_Str = Ruler_Str + ' ' + Right_Ruler + ' ' + Right_Ruler_Txt;
								break;
						}
						document.List_Form.DisSql.value = Sql_Start_Str + ' Where ' + Where_Str + ' Order By ' + Sql_End_Str;
					}
				}
				else
				{
					Sql_Split_Arr = Sql_Str.split('Where');
					Sql_Start_Str = Sql_Split_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
					Sql_End_Str = Sql_Split_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
					switch (Right_Ruler)
					{
						case "In":
							Where_No_And = Ruler_Str + ' In(' + Right_Ruler_Txt + ')';
							break;	
						case "Like":
							Where_No_And = Ruler_Str + ' Like \'%' + Right_Ruler_Txt + '%\'';
							break;
						default:
							Where_No_And = Ruler_Str + ' ' + Right_Ruler + ' ' + Right_Ruler_Txt;
							break;
					}
					if (Sql_End_Str.indexOf(Where_No_And) == -1)
					{
						Where_Str = Where_No_And + ' And ';
						document.List_Form.DisSql.value = Sql_Start_Str + ' Where ' + Where_Str + Sql_End_Str;
					}
					else
					{
						if (Sql_End_Str.indexOf('Order By') == -1)
						{
							split_order_str = Sql_End_Str
							Order_End_Str = '';
						}
						else
						{
							split_order_Arr = Sql_End_Str.split('Order By');
							split_order_str = split_order_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
							Order_End_Str = ' Order By ' + split_order_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
						}
						Replace_Sql_Str = split_order_str.replace(Where_No_And + ' And ','').replace(' And ' + Where_No_And,'').replace(Where_No_And,'').replace(/^\s+/,'').replace(/\s+$/,'');
						if (Replace_Sql_Str != '')
						{
							document.List_Form.DisSql.value = Sql_Start_Str + ' Where ' + Replace_Sql_Str + Order_End_Str;
						}
						else
						{
							document.List_Form.DisSql.value = Sql_Start_Str + Order_End_Str;
						}	
					}
				}
			}
			else
			{
				return;
			}
		}
	}
	else
	{
		return;
	}
}

//设置查询数量
function SetNumToSql()
{
	var Sql_Str = document.List_Form.DisSql.value;
	var Num_Str = document.List_Form.SelectNum.value;
	var Sql_Arr = '';
	var Replace_Str = '';
	var Top_Str = '';
	var End_Str = '';
	if (Sql_Str == '')
	{
		return;
	}
	else
	{
		if (Num_Str == '')
		{
			alert('查询数量请为正整数');
			document.List_Form.SelectNum.focus();
			return;
		}
		Sql_Arr = Sql_Str.split(' ');
		Top_Str = Sql_Arr[0] + ' ' + Sql_Arr[1] + ' ' + Sql_Arr[2] + ' ';
		End_Str = Sql_Str.replace(Top_Str,'');
		Replace_Str = Top_Str.replace(Sql_Arr[2],Num_Str);
		document.List_Form.DisSql.value = Replace_Str + End_Str;
	}
}

//检测sql语句
function CheckSql()
{
	var Sql_Str = document.List_Form.DisSql.value.toLowerCase();
	if (Sql_Str == '')
	{
		return;
	}
	var PageUrl = 'CheckSql.asp';
	var action = '?Act=' + Sql_Str;
	var myAjax = new Ajax.Request(
		PageUrl + action,
		{method:'get',
		parameters:'',
		onComplete:Check_Recive
		}
		);
}
function Check_Recive(XmlObj)
{
	$('CheckSql_Txt').innerHTML=XmlObj.responseText;
}



//显示和隐藏栏目对照表
function Dis_Data_Table(str)
{
  if(str.style.display=="none")
  {
     str.style.display="";
  } 
  else
  {
     str.style.display="none"; 
  }
}


//提交表单
function SubmitFun()
{
	var Name_Str = document.List_Form.LabelName.value;
	if (Name_Str == '')
	{
		alert('标签名称不能为空');
		document.List_Form.LabelName.focus();
		return;
	}
	else
	{
		if (Name_Str.length > 20)
		{
			alert('标签名称不能超过20个字符');
			document.List_Form.LabelName.focus();
			return;
		}
	}
	document.List_Form.submit();
}
-->
</script>