//取ContextMenuClass表需要的字段
private static List <List <string> > GetMenuClassData(List <string> menu)
{
if (menu[0] == "")
{
return(null);
}
string[] DataArr = { "MnuClass", "DescriptionStringCode" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
string MnuClass = menu[0];
string MnuNo = menu[1];
string MnuName = menu[2];
string DescriptionStringCode = "MnuClass_" + MnuClass;
List <string> newList = new List <string>();
newList.Add(MnuClass);
newList.Add(DescriptionStringCode);
newLists.Add(newList);//添加到集合
//CF_String表
strLists.Add(SetCFStringData("Control", "Sys_ContextMenuClass", DescriptionStringCode, MnuName));
return(CreateSQLBusiness.GetAllData(newLists, "Sys_ContextMenuClass", "y"));
}
//取Tab表需要的字段
private static List <List <string> > GetTabData(List <string> main)
{
if (main[0] == "")
{
return(null);
}
string[] DataArr = { "TabNo", "TabName", "TabBseNo", "TabNameStringCode" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
string BseNo = main[0];
string BseName = main[1];
string TabNo = BseNo;
string TabName = BseName;
string TabBseNo = BseNo;
string TabNameStringCode = "Sys_Tab_Name_" + TabNo;
List <string> newList = new List <string>();
newList.Add(TabNo);
newList.Add(TabName);
newList.Add(TabBseNo);
newList.Add(TabNameStringCode);
newLists.Add(newList);//添加到集合
//CF_String表
strLists.Add(SetCFStringData("Common", "Sys_Tab", TabNameStringCode, TabName));
return(CreateSQLBusiness.GetAllData(newLists, "Sys_Tab", "n"));
}
//取要生成的SQL
private static string CreateTable(string tabName, List <List <string> > lists, string[] qryArr)
{
if (lists == null)
{
return("");
}
return(CreateSQLBusiness.CreateSQL(tabName, lists, qryArr));
}
public static string GetTable(string id, string tabName, string str1, string val1, string isFirst, string isLike)
{
string sqlStr = "";
if (isLike.ToLower() == "true")
{
sqlStr = "select * from " + tabName + " where " + str1 + " like '%" + val1 + "%'";
}
else
{
sqlStr = "select * from " + tabName + " where " + str1 + " = '" + val1 + "'";
}
StringBuilder sb = new StringBuilder();
DataTable dt = CreateSQLBusiness.GetDataFromSQL(sqlStr);
if (dt.Rows.Count > 0)
{
sb.Append("<table border=\"1\" width=\"1\" class=\"tabdata\">");
sb.Append("<tr>");
sb.Append("<td class=\"th\"><input type=\"checkbox\" onclick=\"f_checkall(this,'" + id + "')\"/></td>");
int count = 0;
foreach (DataColumn dc in dt.Columns)
{
if (count == 0 && isFirst == "n")
{
count++;
}
else
{
sb.Append("<td class=\"th\">" + dc.ColumnName + "</td>");
}
}
sb.Append("</tr>");
foreach (DataRow dr in dt.Rows)
{
sb.Append("<tr>");
sb.Append("<td><input type=\"checkbox\" onclick=\"f_check(this,'" + id + "')\"/></td>");
int num = 0;
foreach (object item in dr.ItemArray)
{
if (num == 0 && isFirst == "n")
{
num++;
}
else
{
sb.Append("<td>" + item.ToString() + "</td>");
}
}
sb.Append("</tr>");
}
sb.Append("</table>");
}
return(sb.ToString());
}
//取ListDt表需要的字段
private static List <List <string> > GetListDtData(List <List <string> > lists, List <string> main)
{
string[] DataArr = { "LdtLstNo", "LdtLstOrder", "LdtFldName", "LdtFldDesc", "LdtFldDescEN", "LdtFldDescStringCode", "LdtFldHelpStringCode",
"LdtFldMaxLen", "LdtFldWidth", "LdtFldAlign", "LdtFldType", "LdtFldEdit", "LdtFldOrder", "LdtFldDisplay" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
foreach (List <string> list in lists)
{
Dictionary <string, string> dic = GetDicForList(list);
string ListNeed = dic["ListDt"];
if (ListNeed == "0")
{
continue;
}
string BseNo = main[0];
string LdtLstNo = BseNo;
string LdtLstOrder = "1";
string LdtFldName = dic["BdtFldName"];
string LdtFldDesc = dic["BdtFldDesc"];
string LdtFldDescEN = LdtFldName;
string LdtFldDescStringCode = LdtLstNo + "_" + LdtFldName;
string LdtFldHelpStringCode = LdtFldDescStringCode;
string LdtFldMaxLen = dic["BdtFldMaxLen"];
string LdtFldWidth = dic["BdtFldWidth"];
string LdtFldAlign = "left";
string LdtFldType = dic["BdtFldType"];
string LdtFldEdit = dic["BdtLstEdit"];
string LdtFldOrder = dic["BdtFldOrder"];
string LdtFldDisplay = dic["BdtLstDisplay"];
List <string> newList = new List <string>();
newList.Add(LdtLstNo);
newList.Add(LdtLstOrder);
newList.Add(LdtFldName);
newList.Add(LdtFldDesc);
newList.Add(LdtFldDescEN);
newList.Add(LdtFldDescStringCode);
newList.Add(LdtFldHelpStringCode);
newList.Add(LdtFldMaxLen);
newList.Add(LdtFldWidth);
newList.Add(LdtFldAlign);
newList.Add(LdtFldType);
newList.Add(LdtFldEdit);
newList.Add(LdtFldOrder);
newList.Add(LdtFldDisplay);
newLists.Add(newList);//添加到集合
}
return(CreateSQLBusiness.GetAllData(newLists, "Sys_ListDt", "n"));
}
//取List表需要的字段
private static List <List <string> > GetListData(List <string> main)
{
if (main[0] == "")
{
return(null);
}
string[] DataArr = { "LstNo", "LstOrder", "LstName", "LstNameStringCode", "LstTitle", "LstTitleStringCode", "LstBseNo", "LstDefault" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
string BseNo = main[0];
string BseName = main[1];
string LstNo = BseNo;
string LstOrder = "1";
string LstName = BseName;
string LstNameStringCode = "Sys_List_Name_" + LstNo;
string LstTitle = LstName;
string LstTitleStringCode = "Sys_List_Title_" + LstNo;
string LstBseNo = BseNo;
string LstDefault = "Y";
List <string> newList = new List <string>();
newList.Add(LstNo);
newList.Add(LstOrder);
newList.Add(LstName);
newList.Add(LstNameStringCode);
newList.Add(LstTitle);
newList.Add(LstTitleStringCode);
newList.Add(LstBseNo);
newList.Add(LstDefault);
newLists.Add(newList);//添加到集合
newList = new List <string>();
newList.Add(LstNo);
newList.Add("-1");
newList.Add(LstName);
newList.Add(LstNameStringCode);
newList.Add(LstTitle);
newList.Add(LstTitleStringCode);
newList.Add(LstBseNo);
newList.Add("N");
newLists.Add(newList);//添加到集合
//CF_String表
strLists.Add(SetCFStringData("Control", "Sys_List", LstNameStringCode, LstName));
strLists.Add(SetCFStringData("Control", "Sys_List", LstTitleStringCode, LstName));
return(CreateSQLBusiness.GetAllData(newLists, "Sys_List", "n"));
}
//取ContextMenu表需要的字段
private static List <List <string> > GetMenuData(List <string> menu)
{
string[] DataArr = { "ContextMnuNo", "MnuClass", "MnuNo", "MnuStringCode", "MnuScript", "CausesValidation", "IsInDropDown", "IsNeedPrivilege", "ImageName", "SeqNo" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
for (int i = 3; i < menu.Count; i++)
{
try
{
string[] Name = menu[i].Split('|');
string ContextMnuNoCN = Name[1];
string ContextMnuNo = Name[0];
string MnuClass = menu[0];
string MnuNo = menu[1];
string MnuStringCode = MnuNo + "_" + MnuClass + "_" + ContextMnuNo;
string MnuScript = "f_" + ContextMnuNo + "()";
string CausesValidation = "1";
string IsInDropDown = "N";
string IsNeedPrivilege = "Y";
string ImageName = "btn_" + ContextMnuNo + ".gif";
string SeqNo = i.ToString();
List <string> newList = new List <string>();
newList.Add(ContextMnuNo);
newList.Add(MnuClass);
newList.Add(MnuNo);
newList.Add(MnuStringCode);
newList.Add(MnuScript);
newList.Add(CausesValidation);
newList.Add(IsInDropDown);
newList.Add(IsNeedPrivilege);
newList.Add(ImageName);
newList.Add(SeqNo);
newLists.Add(newList);//添加到集合
//CF_String表
strLists.Add(SetCFStringData("Common", "Sys_ContextMenu", MnuStringCode, ContextMnuNoCN));
}
catch { }
}
return(CreateSQLBusiness.GetAllData(newLists, "Sys_ContextMenu", "n"));
}
//取TabDt表需要的字段
private static List <List <string> > GetTabDtData(List <List <string> > lists, List <string> main)
{
string[] DataArr = { "TdtBseNo", "TdtTabNo", "TdtTcsNo", "TdtFldName", "TdtFldDesc", "TdtFldDescStringCode", "TdtFldHelpStringCode", "TdtFldEdit", "TdtFldOrder" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
foreach (List <string> list in lists)
{
Dictionary <string, string> dic = GetDicForList(list);
string TabNeed = dic["TabDt"];
if (TabNeed == "0")
{
continue;
}
string BseNo = main[0];
string TdtBseNo = BseNo;
string TdtTabNo = BseNo;
string TdtTcsNo = "01";
string TdtFldName = dic["BdtFldName"];
string TdtFldDesc = dic["BdtFldDesc"];
string TdtFldDescStringCode = TdtBseNo + "_" + TdtFldName;
string TdtFldHelpStringCode = TdtFldDescStringCode;
string TdtFldEdit = dic["TdtFldEdit"];
string TdtFldOrder = dic["BdtFldOrder"];
List <string> newList = new List <string>();
newList.Add(TdtBseNo);
newList.Add(TdtTabNo);
newList.Add(TdtTcsNo);
newList.Add(TdtFldName);
newList.Add(TdtFldDesc);
newList.Add(TdtFldDescStringCode);
newList.Add(TdtFldHelpStringCode);
newList.Add(TdtFldEdit);
newList.Add(TdtFldOrder);
newLists.Add(newList);//添加到集合
}
return(CreateSQLBusiness.GetAllData(newLists, "Sys_TabDt", "n"));
}
//取Filter表需要的字段
private static List <List <string> > GetFilterData(List <List <string> > lists, List <string> main)
{
string[] DataArr = { "FltBseNo", "FltLstNo", "FltType", "FltDisMode", "FltRange", "FltEIncNullText", "FltOrder", "FltName" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
foreach (List <string> list in lists)
{
Dictionary <string, string> dic = GetDicForList(list);
string Filter = dic["Filter"];
if (Filter == "0")
{
continue;
}
string BseNo = main[0];
string FltBseNo = BseNo;
string FltLstNo = BseNo;
string FltType = dic["BdtFldType"];
string FltDisMode = "0";
string FltRange = "0";
string FltEIncNullText = "1";
string FltOrder = dic["BdtFldOrder"];
string FltName = dic["BdtFldName"];
List <string> newList = new List <string>();
newList.Add(FltBseNo);
newList.Add(FltLstNo);
newList.Add(FltType);
newList.Add(FltDisMode);
newList.Add(FltRange);
newList.Add(FltEIncNullText);
newList.Add(FltOrder);
newList.Add(FltName);
newLists.Add(newList);//添加到集合
}
return(CreateSQLBusiness.GetAllData(newLists, "Sys_Filter", "n"));
}
//创建界面
private void CreateHtml(string id, string tabName, string[] strs, string isFirst)
{
//取表列头
DataTable dt = CreateSQLBusiness.GetTabColumn(tabName, isFirst);
StringBuilder sb = new StringBuilder();
StringBuilder sb_input = new StringBuilder();
sb.Append("<div><a href=\"javascript:void(0)\" onclick=\"f_expand('#" + id + "',this)\">+ " + id.ToUpper() + "</a></div>");
sb.Append("<div id=\"" + id + "\" class=\"main\">");
sb.Append("<fieldset>");
sb.Append("<legend>" + tabName + "</legend>");
sb.Append("<div class=\"txtdata autoscroll\">");
sb.Append("<p>" + strs[0] + " <input type=\"checkbox\" id=\"" + id + "like\" class=\"like\" style=\"width:18px;\" />Like <input id=\"" + id + "search\" type=\"input\" class=\"searchtxt\" style=\"width:100px;border:1px solid #999;\" /> ");
sb.Append("<input id=\"submit\" type=\"button\" onclick=\"f_search('#" + id + "','" + tabName + "','" + strs[0] + "','" + isFirst + "')\" value=\"查找\" class=\"btncss\" /> <img src='common/loading.gif' class='imgcss' style='vertical-align:middle;display:none;' /></p>");
sb.Append("</div>");
sb.Append("<div class=\"txtmain autoscroll\">");
sb.Append("<table border=\"1\" width=\"1\" class=\"tabadd\">");
sb.Append("<tr>");
sb_input.Append("<tr class=\"datarow\">");
foreach (DataRow dr in dt.Rows)
{
sb.Append("<td class=\"th\"><pre>" + dr["name"].ToString() + "</pre></td>");
sb_input.Append("<td><input type=\"text\" id=\"" + dr["name"].ToString() + "\" value=\"\" autocomplete=\"off\" /></td>");
}
sb.Append("</tr>");
sb_input.Append("</tr>");
sb.Append(sb_input);
sb.Append("</table>");
sb.Append("</div>");
sb.Append("<div class=\"txtsql autoscroll\"></div>");
sb.Append("<input id=\"" + id + "add\" type=\"button\" onclick=\"f_add('#" + id + "')\" value=\"加行\" class=\"btncss\" /> ");
sb.Append("<input id=\"" + id + "del\" type=\"button\" onclick=\"f_del('#" + id + "')\" value=\"减行\" class=\"btncss\" /> ");
sb.Append("<input id=\"" + id + "go\" type=\"button\" onclick=\"f_sqlgo('#" + id + "','" + tabName + "','" + String.Join(",", strs) + "')\" value=\"生成\" class=\"btncss\" /> ");
sb.Append("<input id=\"" + id + "copy\" type=\"button\" onclick=\"f_copy('#" + id + "')\" value=\"复制\" class=\"btncss\" />");
sb.Append("<input id=\"" + id + "_hidcount\" type=\"hidden\" value=\"0\" />");
sb.Append("</fieldset>");
sb.Append("</div>");
result += sb.ToString();
}
//取Bse表需要的字段
private static List <List <string> > GetBseData(List <string> main)
{
if (main[0] == "")
{
return(null);
}
string[] DataArr = { "BseNo", "BseName", "BseNameStringCode", "BseReadTable", "BseWriteTable", "BseDesc", "BseDescStringCode", "BseIdField" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
string BseNo = main[0];
string BseName = main[1];
string BseWriteTable = main[2];
string BseIdField = main[3];
string BseNameStringCode = "Sys_Base_Name_" + BseNo;
string BseReadTable = "View_" + BseWriteTable;
string BseDesc = BseName;
string BseDescStringCode = "Sys_Base_Desc_" + BseNo;
List <string> newList = new List <string>();
newList.Add(BseNo);
newList.Add(BseName);
newList.Add(BseNameStringCode);
newList.Add(BseReadTable);
newList.Add(BseWriteTable);
newList.Add(BseDesc);
newList.Add(BseDescStringCode);
newList.Add(BseIdField);
newLists.Add(newList);//添加到集合
//CF_String表
strLists.Add(SetCFStringData("Control", "Sys_Base", BseNameStringCode, BseName));
strLists.Add(SetCFStringData("Control", "Sys_Base", BseDescStringCode, BseName));
return(CreateSQLBusiness.GetAllData(newLists, "Sys_Base", "n"));
}
//取TabClass表需要的字段
private static List <List <string> > GetTabClassData(List <string> main)
{
if (main[4] == "")
{
return(null);
}
string[] DataArr = { "TcsTabNo", "TcsNo", "TcsName", "TcsNameEN", "TcsNameStringCode", "TcsListNum" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
string BseNo = main[0];
string BseName = main[1];
string TcsTabNo = BseNo;
string TcsNo = "01";
string TcsName = main[4];
string TcsNameEN = "Translate Please";
string TcsNameStringCode = "TabClass_" + TcsTabNo + "_" + TcsNo;
string TcsListNum = main[5];
List <string> newList = new List <string>();
newList.Add(TcsTabNo);
newList.Add(TcsNo);
newList.Add(TcsName);
newList.Add(TcsNameEN);
newList.Add(TcsNameStringCode);
newList.Add(TcsListNum);
newLists.Add(newList);//添加到集合
//CF_String表
strLists.Add(SetCFStringData("Field", "Sys_TabClass", TcsNameStringCode, TcsName));
return(CreateSQLBusiness.GetAllData(newLists, "Sys_TabClass", "n"));
}
//取BseDt表需要的字段
private static List <List <string> > GetBseDtData(List <List <string> > lists, List <string> main)
{
string[] DataArr = { "BdtBseNo", "BdtFldName", "BdtFldDesc", "BdtFldDescEN", "BdtFldDescStringCode", "BdtFldHelpStringCode", "BdtFldMaxLen", "BdtFldType", "BdtFldWidth",
"BdtFldAlign", "BdtLstDefault", "BdtLstEdit", "BdtLstDisplay", "BdtFldOrder", "BdtFldList", "BdtTabDisplay", "BdtFilter", "BdtTabSelect","BdtTabWidth","BdtRelationName", "BdtTabColSpan",
"BdtFldBEmpty", "BdtSelNo", "BdtWriteTable", "BdtWriteField", "BdtDecimalPlace", "BdtIsCurrentDate", "BdtIsNegativeAllow", "BdtLstIsHyperLink", "BdtMultiRow" };
List <List <string> > newLists = new List <List <string> >();
newLists.Add(GetListForArr(DataArr));
foreach (List <string> list in lists)
{
Dictionary <string, string> dic = GetDicForList(list);
if (dic["BdtFldName"] == "")
{
continue;
}
string BseNo = main[0];
string BdtBseNo = BseNo;
string BdtFldName = dic["BdtFldName"];
string BdtFldDesc = dic["BdtFldDesc"];
string BdtFldDescEN = BdtFldName;
string BdtFldDescStringCode = BseNo + "_" + BdtFldName;
string BdtFldHelpStringCode = BdtFldDescStringCode;
string BdtFldMaxLen = dic["BdtFldMaxLen"];
string BdtFldType = dic["BdtFldType"];
string BdtFldWidth = dic["BdtFldWidth"];
string BdtFldAlign = "left";
string BdtLstDefault = "1";
string BdtLstEdit = dic["BdtLstEdit"];
string BdtLstDisplay = dic["BdtLstDisplay"];
string BdtFldOrder = dic["BdtFldOrder"];
string BdtFldList = dic["BdtFldList"];
string BdtTabDisplay = dic["BdtTabDisplay"];
string BdtFilter = "0";
string BdtTabSelect = dic["BdtTabSelect"];
string BdtTabWidth = "135";
string BdtRelationName = dic["BdtRelationName"];
string BdtTabColSpan = "1";
string BdtFldBEmpty = dic["BdtFldBEmpty"];
string BdtSelNo = dic["BdtSelNo"];
string BdtWriteTable = dic["BdtWriteTable"];
string BdtWriteField = dic["BdtWriteField"];
string BdtDecimalPlace = dic["BdtDecimalPlace"];
string BdtIsCurrentDate = dic["BdtIsCurrentDate"];
string BdtIsNegativeAllow = "N";
string BdtLstIsHyperLink = dic["BdtLstIsHyperLink"];
string BdtMultiRow = dic["BdtMultiRow"];
List <string> newList = new List <string>();
newList.Add(BdtBseNo);
newList.Add(BdtFldName);
newList.Add(BdtFldDesc);
newList.Add(BdtFldDescEN);
newList.Add(BdtFldDescStringCode);
newList.Add(BdtFldHelpStringCode);
newList.Add(BdtFldMaxLen);
newList.Add(BdtFldType);
newList.Add(BdtFldWidth);
newList.Add(BdtFldAlign);
newList.Add(BdtLstDefault);
newList.Add(BdtLstEdit);
newList.Add(BdtLstDisplay);
newList.Add(BdtFldOrder);
newList.Add(BdtFldList);
newList.Add(BdtTabDisplay);
newList.Add(BdtFilter);
newList.Add(BdtTabSelect);
newList.Add(BdtTabWidth);
newList.Add(BdtRelationName);
newList.Add(BdtTabColSpan);
newList.Add(BdtFldBEmpty);
newList.Add(BdtSelNo);
newList.Add(BdtWriteTable);
newList.Add(BdtWriteField);
newList.Add(BdtDecimalPlace);
newList.Add(BdtIsCurrentDate);
newList.Add(BdtIsNegativeAllow);
newList.Add(BdtLstIsHyperLink);
newList.Add(BdtMultiRow);
newLists.Add(newList);//添加到集合
//CF_String表
strLists.Add(SetCFStringData("Field", "Sys_BaseDt", BdtFldDescStringCode, BdtFldDesc));
}
return(CreateSQLBusiness.GetAllData(newLists, "Sys_BaseDt", "n"));
}
public static string CreateSQL(string tabName, List <List <string> > lists, List <string> qryArr)
{
//调用业务类方法
return(CreateSQLBusiness.CreateSQL(tabName, lists, qryArr.ToArray()));
}
