📄 addfreeone.asp
字号:
document.List_Form.Fist_TF_All.value = V_StartStr + '(' + LeftTable_Name + '.' + V_EndStr;
}
}
else
{
if (LeftFields_Str[i].value.indexOf('Mid') == -1 && LeftFields_Str[i].value.indexOf('SubString') == -1)
{
document.List_Form.Fist_TF_All.value = document.List_Form.Fist_TF_All.value + ',' + LeftTable_Name + '.' + LeftFields_Str[i].value;
}
else
{
V_StrArr = LeftFields_Str[i].value.split('(');
V_StartStr = V_StrArr[0].replace(/^\s+/,'').replace(/\s+$/,'');
V_EndStr = V_StrArr[1].replace(/^\s+/,'').replace(/\s+$/,'');
document.List_Form.Fist_TF_All.value = document.List_Form.Fist_TF_All.value + ',' + V_StartStr + '(' + LeftTable_Name + '.' + V_EndStr;
}
}
if (RightFields_Str.value == '')
{
if (document.List_Form.DisSql.value == '')
{
document.List_Form.DisSql.value = LeftFields_Str[i].value;
}
else
{
document.List_Form.DisSql.value = document.List_Form.DisSql.value + ',' + LeftFields_Str[i].value;
}
}
else
{
if (document.List_Form.DisSql.value == '')
{
if (LeftFields_Str[i].value.indexOf('Mid') == -1 && LeftFields_Str[i].value.indexOf('SubString') == -1)
{
document.List_Form.DisSql.value = LeftTable_Name + '.' + LeftFields_Str[i].value;
}
else
{
V_StrArr = LeftFields_Str[i].value.split('(');
V_StartStr = V_StrArr[0].replace(/^\s+/,'').replace(/\s+$/,'');
V_EndStr = V_StrArr[1].replace(/^\s+/,'').replace(/\s+$/,'');
document.List_Form.DisSql.value = V_StartStr + '(' + LeftTable_Name + '.' + V_EndStr;
}
}
else
{
if (LeftFields_Str[i].value.indexOf('Mid') == -1 && LeftFields_Str[i].value.indexOf('SubString') == -1)
{
document.List_Form.DisSql.value = document.List_Form.DisSql.value + ',' + LeftTable_Name + '.' + LeftFields_Str[i].value;
}
else
{
V_StrArr = LeftFields_Str[i].value.split('(');
V_StartStr = V_StrArr[0].replace(/^\s+/,'').replace(/\s+$/,'');
V_EndStr = V_StrArr[1].replace(/^\s+/,'').replace(/\s+$/,'');
document.List_Form.DisSql.value = document.List_Form.DisSql.value + ',' + V_StartStr + '(' + LeftTable_Name + '.' + V_EndStr;
}
}
}
}
}
}
if (RightFields_Str.value != '')
{
for(i=0;i<RightFields_Str.length;i++)
{
if (RightFields_Str[i].selected == true )
{
if (document.List_Form.Sec_TF_All.value == '')
{
if (RightFields_Str[i].value.indexOf('Mid') == -1 && RightFields_Str[i].value.indexOf('SubString') == -1)
{
document.List_Form.Sec_TF_All.value = RightTable_Name + '.' + RightFields_Str[i].value;
}
else
{
V_StrArr = RightFields_Str[i].value.split('(');
V_StartStr = V_StrArr[0].replace(/^\s+/,'').replace(/\s+$/,'');
V_EndStr = V_StrArr[1].replace(/^\s+/,'').replace(/\s+$/,'');
document.List_Form.Sec_TF_All.value = V_StartStr + '(' + RightTable_Name + '.' + V_EndStr;
}
}
else
{
if (RightFields_Str[i].value.indexOf('Mid') == -1 && RightFields_Str[i].value.indexOf('SubString') == -1)
{
document.List_Form.Sec_TF_All.value = document.List_Form.Sec_TF_All.value + ',' + RightTable_Name + '.' + RightFields_Str[i].value;
}
else
{
V_StrArr = RightFields_Str[i].value.split('(');
V_StartStr = V_StrArr[0].replace(/^\s+/,'').replace(/\s+$/,'');
V_EndStr = V_StrArr[1].replace(/^\s+/,'').replace(/\s+$/,'');
document.List_Form.Sec_TF_All.value = document.List_Form.Sec_TF_All.value + ',' + V_StartStr + '(' + RightTable_Name + '.' + V_EndStr;
}
}
if (LeftFields_Str.value == '')
{
if (document.List_Form.DisSql.value == '')
{
document.List_Form.DisSql.value = RightFields_Str[i].value;
}
else
{
document.List_Form.DisSql.value = document.List_Form.DisSql.value + ',' + RightFields_Str[i].value;
}
}
else
{
if (document.List_Form.DisSql.value == '')
{
if (RightFields_Str[i].value.indexOf('Mid') == -1 && RightFields_Str[i].value.indexOf('SubString') == -1)
{
document.List_Form.DisSql.value = RightTable_Name + '.' + RightFields_Str[i].value;
}
else
{
V_StrArr = RightFields_Str[i].value.split('(');
V_StartStr = V_StrArr[0].replace(/^\s+/,'').replace(/\s+$/,'');
V_EndStr = V_StrArr[1].replace(/^\s+/,'').replace(/\s+$/,'');
document.List_Form.DisSql.value = V_StartStr + '(' + RightTable_Name + '.' + V_EndStr;
}
}
else
{
if (RightFields_Str[i].value.indexOf('Mid') == -1 && RightFields_Str[i].value.indexOf('SubString') == -1)
{
document.List_Form.DisSql.value = document.List_Form.DisSql.value + ',' + RightTable_Name + '.' + RightFields_Str[i].value;
}
else
{
V_StrArr = RightFields_Str[i].value.split('(');
V_StartStr = V_StrArr[0].replace(/^\s+/,'').replace(/\s+$/,'');
V_EndStr = V_StrArr[1].replace(/^\s+/,'').replace(/\s+$/,'');
document.List_Form.DisSql.value = document.List_Form.DisSql.value + ',' + V_StartStr + '(' + RightTable_Name + '.' + V_EndStr;
}
}
}
}
}
}
if (document.List_Form.DisSql.value != '')
{
if (RightFields_Str.value != '' && LeftFields_Str.value != '')
{
document.List_Form.DisSql.value = 'Select Top ' + SelectNum + ' ' + document.List_Form.DisSql.value + ' From ' + LeftTable_Name + ',' + RightTable_Name + ' Where ' + LeftTable_Name + '.ClassID = ' + RightTable_Name + '.ClassID';
}
else if (LeftFields_Str.value != '' && RightFields_Str.value == '')
{
document.List_Form.DisSql.value = 'Select Top ' + SelectNum + ' ' + document.List_Form.DisSql.value + ' From ' + LeftTable_Name;
}
else if (LeftFields_Str.value == '' && RightFields_Str.value != '')
{
document.List_Form.DisSql.value = 'Select Top ' + SelectNum + ' ' + document.List_Form.DisSql.value + ' From ' + RightTable_Name;
}
}
}
//添加排序
function SetOrderToSQl(Str)
{
var Sql_Str = document.List_Form.DisSql.value;
var Order_Txt_left = document.List_Form.LeftOrder.value;
var Order_Txt_right = document.List_Form.RightOrder.value;
var Order_Ruler_left = document.List_Form.LeftOrderRuler.value;
var Order_Ruler_right = document.List_Form.RightOrderRuler.value;
var Select_Fields_Left = document.List_Form.Fist_TF_All.value;
var Select_Fields_right = document.List_Form.Sec_TF_All.value;
var LeftTable_Name = document.List_Form.NTable.value;
var RightTable_Name = document.List_Form.CTable.value;
var Main_Sql_Str = '';
var Order_Str = '';
var Replace_order_Str = '';
var Sql_Str_Arr = '';
if (Sql_Str != '')
{
if (Str == 'left')
{
if (Order_Txt_left != '' && Order_Ruler_left != '')
{
if (Select_Fields_right != '')
{
if (Sql_Str.indexOf('Order By') == -1)
{
document.List_Form.DisSql.value = Sql_Str + ' Order By ' + LeftTable_Name + '.' + Order_Txt_left + ' ' + Order_Ruler_left;
}
else
{
Sql_Str_Arr = Sql_Str.split('Order By');
Main_Sql_Str = Sql_Str_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
Order_Str = Sql_Str_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
if (Order_Str.indexOf(LeftTable_Name + '.' + Order_Txt_left) == -1)
{
document.List_Form.DisSql.value = Sql_Str + ',' + LeftTable_Name + '.' + Order_Txt_left + ' ' + Order_Ruler_left;
}
else
{
Replace_order_Str = Order_Str.replace(LeftTable_Name + '.' + Order_Txt_left + ' Asc,','').replace(',' + LeftTable_Name + '.' + Order_Txt_left + ' Asc','').replace(LeftTable_Name + '.' + Order_Txt_left + ' Asc','').replace(LeftTable_Name + '.' + Order_Txt_left + ' Desc,','').replace(',' + LeftTable_Name + '.' + Order_Txt_left + ' Desc','').replace(LeftTable_Name + '.' + Order_Txt_left + ' Desc','').replace(/^\s+/,'').replace(/\s+$/,'');
if (Replace_order_Str == '')
{
document.List_Form.DisSql.value = Main_Sql_Str;
}
else
{
document.List_Form.DisSql.value = Main_Sql_Str + ' Order By ' + Replace_order_Str;
}
}
}
}
else
{
if (Sql_Str.indexOf('Order By') == -1)
{
document.List_Form.DisSql.value = Sql_Str + ' Order By ' + Order_Txt_left + ' ' + Order_Ruler_left;
}
else
{
Sql_Str_Arr = Sql_Str.split('Order By');
Main_Sql_Str = Sql_Str_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
Order_Str = Sql_Str_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
if (Order_Str.indexOf(Order_Txt_left) == -1)
{
document.List_Form.DisSql.value = Sql_Str + ',' + Order_Txt_left + ' ' + Order_Ruler_left;
}
else
{
Replace_order_Str = Order_Str.replace(Order_Txt_left + ' Asc,','').replace(',' + Order_Txt_left + ' Asc','').replace(Order_Txt_left + ' Asc','').replace(Order_Txt_left + ' Desc,','').replace(',' + Order_Txt_left + ' Desc','').replace(Order_Txt_left + ' Desc','').replace(/^\s+/,'').replace(/\s+$/,'');
if (Replace_order_Str == '')
{
document.List_Form.DisSql.value = Main_Sql_Str;
}
else
{
document.List_Form.DisSql.value = Main_Sql_Str + ' Order By ' + Replace_order_Str;
}
}
}
}
}
else
{
return;
}
}
else if (Str == 'right')
{
if (Order_Txt_right != '' && Order_Ruler_right != '')
{
if (Select_Fields_Left != '')
{
if (Sql_Str.indexOf('Order By') == -1)
{
document.List_Form.DisSql.value = Sql_Str + ' Order By ' + RightTable_Name + '.' + Order_Txt_right + ' ' + Order_Ruler_right;
}
else
{
Sql_Str_Arr = Sql_Str.split('Order By');
Main_Sql_Str = Sql_Str_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
Order_Str = Sql_Str_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
if (Order_Str.indexOf(RightTable_Name + '.' + Order_Txt_right) == -1)
{
document.List_Form.DisSql.value = Sql_Str + ',' + RightTable_Name + '.' + Order_Txt_right + ' ' + Order_Ruler_right;
}
else
{
Replace_order_Str = Order_Str.replace(RightTable_Name + '.' + Order_Txt_right + ' Asc,','').replace(',' + RightTable_Name + '.' + Order_Txt_right + ' Asc','').replace(RightTable_Name + '.' + Order_Txt_right + ' Asc','').replace(RightTable_Name + '.' + Order_Txt_right + ' Desc,','').replace(',' + RightTable_Name + '.' + Order_Txt_right + ' Desc','').replace(RightTable_Name + '.' + Order_Txt_right + ' Desc','').replace(/^\s+/,'').replace(/\s+$/,'');
if (Replace_order_Str == '')
{
document.List_Form.DisSql.value = Main_Sql_Str;
}
else
{
document.List_Form.DisSql.value = Main_Sql_Str + ' Order By ' + Replace_order_Str;
}
}
}
}
else
{
if (Sql_Str.indexOf('Order By') == -1)
{
document.List_Form.DisSql.value = Sql_Str + ' Order By ' + Order_Txt_right + ' ' + Order_Ruler_right;
}
else
{
Sql_Str_Arr = Sql_Str.split('Order By');
Main_Sql_Str = Sql_Str_Arr[0].replace(/^\s+/,'').replace(/\s+$/,'');
Order_Str = Sql_Str_Arr[1].replace(/^\s+/,'').replace(/\s+$/,'');
if (Order_Str.indexOf(Order_Txt_right) == -1)
{
document.List_Form.DisSql.value = Sql_Str + ',' + Order_Txt_right + ' ' + Order_Ruler_right;
}
else
{
Replace_order_Str = Order_Str.replace(Order_Txt_right + ' Asc,','').replace(',' + Order_Txt_right + ' Asc','').replace(Order_Txt_right + ' Asc','').replace(Order_Txt_right + ' Desc,','').replace(',' + Order_Txt_right + ' Desc','').replace(Order_Txt_right + ' Desc','').replace(/^\s+/,'').replace(/\s+$/,'');
if (Replace_order_Str == '')
{
document.List_Form.DisSql.value = Main_Sql_Str;
}
else
{
document.List_Form.DisSql.value = Main_Sql_Str + ' Order By ' + Replace_order_Str;
}
}
}
}
}
else
{
return;
}
}
}
else
{
return;
}
}
//添加查询条件到sql语句中
function AddWhereToSQL(str)
{
var Sql_Str = document.List_Form.DisSql.value;
var Select_Fields_Left = document.List_Form.Fist_TF_All.value;
var Select_Fields_right = document.List_Form.Sec_TF_All.value;
var LeftTable_Name = document.List_Form.NTable.value;
var RightTable_Name = document.List_Form.CTable.value;
var LeftRulerStr = document.List_Form.LeftRuler.value;
var RightRulerStr = document.List_Form.RightRuler.value;
var Left_Ruler = document.List_Form.LeftRulers.value;
var Right_Ruler = document.List_Form.RightRulers.value;
var Left_Ruler_Txt = document.List_Form.LeftRulerTxt.value;
var Right_Ruler_Txt = document.List_Form.RightRulerTxt.value;
var Ruler_Str = '';
var Where_Str = '';
var Sql_Start_Str = '';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -