//取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")); }
//取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")); }
//取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")); }
//取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")); }