//---------------------------------------------------------- private string GenerateClassBody() { StringBuilder MethodsBuilder = new StringBuilder(); MethodsBuilder.Append("\n" + CreateGetChacheKeyMethod()); MethodsBuilder.Append("\n" + CreateCreateMethod()); MethodsBuilder.Append("\n" + CreateUpdateMethod()); MethodsBuilder.Append("\n" + CreateDeleteMethod()); bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName)); //CreateGetAllMethod //---------------------- //CreateGetAllMethod MethodsBuilder.Append("\n" + CreateGetAllMethod()); //---------------------- //CreateGetCountMethod MethodsBuilder.Append("\n" + CreateGetCountMethod()); //---------------------- //GenerateReletionalGetData MethodsBuilder.Append(GenerateReletionalGetData()); if (ID != null) { MethodsBuilder.Append("\n" + CreateGetOneMethod()); } //MethodsBuilder.Append("\n" + CreatePopulateObjectMethod()); return(MethodsBuilder.ToString()); }
//---------------------------------------------------------- #endregion //---------------------------------------------------------- #region GenerateReletionalGetData private string GenerateReletionalGetData() { StringBuilder relationalMethods = new StringBuilder(); bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); foreach (SQLDMO.Column column in Fields) { //if ((ID == null || column.Name != ID.Name) && (column.Default == null || column.Default.Length != 0) && column.Name.ToLower() != ProjectBuilder.LangID) if ((ID == null || column.Name != ID.Name) && (column.Name.IndexOf("_") < 0)) { TableConstraint cnstr = SqlProvider.obj.GetParentColumn(column.Name); if (cnstr != null) { relationalMethods.Append("\n" + CreateGetAllMethod(column, false)); relationalMethods.Append("\n" + CreateGetCountMethod(column, false)); } } } return(relationalMethods.ToString()); }
//------------------------------------- public string CreateGetAllMethod(SQLDMO.Column conditionalColumn, bool isAvailableMethod) { try { string MethodName = StoredProcedureTypes.GetAll.ToString(); string sqlDataProviderMethodName2 = "GetAll"; string sqlDataProviderMethodCaller = global.SqlDataProviderClass + ".Instance." + sqlDataProviderMethodName2; string methodParameters = ""; string sqlMethodParameters = ""; string additionalPreviousBodyLines = ""; //------------------------------ bool hasPreviousMethodParameter = false; bool hasPreviousSqlMethodParameter = false; //------------------------------ bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName)); if (isMaultiLanguages) { if (!isAvailableMethod) { methodParameters += "Languages langID"; hasPreviousMethodParameter = true; } sqlMethodParameters += "langID"; hasPreviousSqlMethodParameter = true; } //------------------------------ if (conditionalColumn != null) { //Check Previous Parameters if (hasPreviousMethodParameter) { methodParameters += ", "; } if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } //----------------------- MethodName += "By" + Globals.GetProgramatlyName(conditionalColumn.Name); sqlDataProviderMethodCaller += "By" + Globals.GetProgramatlyName(conditionalColumn.Name); methodParameters += Globals.GetAliasDataType(conditionalColumn.Datatype) + " " + Globals.ConvetStringToCamelCase(Globals.GetProgramatlyName(conditionalColumn.Name)); sqlMethodParameters += Globals.ConvetStringToCamelCase(Globals.GetProgramatlyName(conditionalColumn.Name)); //----------------------- hasPreviousMethodParameter = true; hasPreviousSqlMethodParameter = true; } //------------------------------ bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); if (hasIsAvailable) { if (!isAvailableMethod) { //Check Previous Parameters if (hasPreviousMethodParameter) { methodParameters += ", "; } if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } //------------------------- methodParameters += "bool " + Globals.ConvetStringToCamelCase(ProjectBuilder.IsAvailableConditionParam); sqlMethodParameters += Globals.ConvetStringToCamelCase(ProjectBuilder.IsAvailableConditionParam); //----------------------- hasPreviousMethodParameter = true; hasPreviousSqlMethodParameter = true; } else { //Check Previous Parameter if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } sqlDataProviderMethodCaller = MethodName; //if (userType == UserType.Admin) //{ // MethodName += "ForAdmin"; // sqlMethodParameters += "false"; // additionalPreviousBodyLines = "Languages langID = (Languages) ResourceManager.GetCurrentLanguage();"; //} //else //{ // MethodName += "ForUser"; // sqlMethodParameters += "true"; // additionalPreviousBodyLines = "Languages langID = (Languages) ResourceManager.GetCurrentLanguage();"; //} ////----------------------- hasPreviousSqlMethodParameter = true; } } //------------------------------ //Check Previous Parameters if (hasPreviousMethodParameter) { methodParameters += ", "; } if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } //------------------------- methodParameters += "int pageIndex, int pageSize, out int totalRecords"; sqlMethodParameters += "pageIndex, pageSize, out totalRecords"; //XXXXXXXXXXXXXXX //XXXXXXXXXXXXXXX string MethodReturn = "List<" + global.TableEntityClass + ">"; //XML Documentaion string xmlDocumentation = "\n\t/// <summary>\n"; xmlDocumentation += "\t/// Gets All " + SqlProvider.obj.TableName + ".\n"; xmlDocumentation += "\t/// <example>[Example]" + MethodReturn + " " + global.EntityClassList + "=" + ClassName + "." + MethodName + "(" + sqlMethodParameters + ");.</example>\n"; xmlDocumentation += "\t/// </summary>\n"; xmlDocumentation += "\t/// <returns>All " + SqlProvider.obj.TableName + ".</returns>"; //Method Body StringBuilder methodBody = new StringBuilder(); methodBody.Append("\n\t#region --------------" + MethodName + "--------------"); if (ProjectBuilder.AllowXmlDocumentation) { methodBody.Append(xmlDocumentation); } methodBody.Append("\n\tpublic static " + MethodReturn + " " + MethodName + "(" + methodParameters + ")"); methodBody.Append("\n\t{"); methodBody.Append("\n\t\t" + additionalPreviousBodyLines); methodBody.Append("\n\t\treturn " + sqlDataProviderMethodCaller + "(" + sqlMethodParameters + ");"); methodBody.Append("\n\t}"); methodBody.Append("\n\t" + Globals.MetthodsSeparator); methodBody.Append("\n\t#endregion"); return(methodBody.ToString()); } catch (Exception ex) { MessageBox.Show("My Generated Code Exception:" + ex.Message); return(""); } }
// private string CreateLoadData() { StringBuilder loadData = new StringBuilder(); loadData.Append("\n\t#region --------------LoadData--------------"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\t//LoadData"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\tprivate void LoadData()"); loadData.Append("\n\t{"); loadData.Append("\n\t\tpager.PageSize = SiteSettings.Instance.AdminPageSize;"); loadData.Append("\n\t\tint totalRecords = 0;"); string methodParameters = ""; string methodName = StoredProcedureTypes.GetAllWithPager.ToString(); bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); if (hasIsAvailable) { methodName += "ForAdmin"; } bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName)); if (isMaultiLanguages) { if (!hasIsAvailable) { loadData.Append("\n\t\tLanguages langID = (Languages)ResourceManager.GetCurrentLanguage();"); methodParameters = "langID,"; } } methodParameters += "pager.CurrentPage, pager.PageSize, out totalRecords"; loadData.Append("\n\t\tList<" + global.TableEntityClass + "> " + global.EntityClassList + "= " + global.TableFactoryClass + "." + methodName + "(" + methodParameters + ");"); loadData.Append("\n\t\tif(" + global.EntityClassList + "!=null&&" + global.EntityClassList + ".Count >0)"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".DataSource= " + global.EntityClassList + ";"); if (ID != null) { loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".DataKeyField=\"" + Globals.GetProgramatlyName(ID.Name) + "\";"); } loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".AllowPaging=false;"); //-------- loadData.Append("\n\t\t\tpager.Visible = true;"); loadData.Append("\n\t\t\tpager.TotalRecords = totalRecords;"); //-------- loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".DataBind();"); loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".Visible = true;"); loadData.Append("\n\t\t}"); loadData.Append("\n\t\telse"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".Visible=false;"); loadData.Append("\n\t\t\tpager.Visible = false;"); loadData.Append("\n\t\t\tlblResult.ForeColor = Color.Red;"); loadData.Append("\n\t\t\tlblResult.Text = " + ResourcesTesxtsBuilder.AddAdminGlobalText("ThereIsNoData", TextType.Text) + ";"); loadData.Append("\n\t\t}"); loadData.Append("\n\t}"); loadData.Append("\n\t//--------------------------------------------------------"); loadData.Append("\n\t#endregion"); return(loadData.ToString()); }
//-------------------------------------- private string CreateLoadData() { StringBuilder loadData = new StringBuilder(); loadData.Append("\n\t#region --------------LoadData--------------"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\t//LoadData"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\tprivate void LoadData()"); loadData.Append("\n\t{"); loadData.Append("\n\t\tpager.PageSize = SiteSettings.Instance.DefaultPageSize;"); loadData.Append("\n\t\tint totalRecords = 0;"); string methodParameters = ""; string methodName = StoredProcedureTypes.GetAllWithPager.ToString(); bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); if (hasIsAvailable) { methodName += "ForUser"; } bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName)); if (isMaultiLanguages) { if (!hasIsAvailable) { loadData.Append("\n\t\tLanguages langID = (Languages)ResourceManager.GetCurrentLanguage();"); methodParameters = "langID,"; } } methodParameters += "pager.CurrentPage, pager.PageSize, out totalRecords"; loadData.Append("\n\t\tList<" + global.TableEntityClass + "> " + global.EntityClassList + " = " + global.TableFactoryClass + "." + methodName + "(" + methodParameters + ");"); loadData.Append("\n\t\tif(" + global.EntityClassList + "!=null&&" + global.EntityClassList + ".Count >0)"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t//Load data list design"); loadData.Append("\n\t\t\tDataList dl;"); loadData.Append("\n\t\t\tdl = LoadDataList(\"" + repeaterID + "\");"); loadData.Append("\n\t\t\t" + repeaterID + ".ItemTemplate = dl.ItemTemplate;"); loadData.Append("\n\t\t\t" + repeaterID + ".HeaderTemplate = dl.HeaderTemplate;"); loadData.Append("\n\t\t\t" + repeaterID + ".FooterTemplate = dl.FooterTemplate;"); loadData.Append("\n\t\t\t" + repeaterID + ".ShowHeader = dl.ShowHeader;"); loadData.Append("\n\t\t\t" + repeaterID + ".ShowFooter = dl.ShowFooter;"); loadData.Append("\n\t\t\t" + repeaterID + ".Width = dl.Width;"); loadData.Append("\n\t\t\t" + repeaterID + ".RepeatColumns = dl.RepeatColumns;"); loadData.Append("\n\t\t\t//-----------------------------------------"); loadData.Append("\n\t\t\t" + repeaterID + ".DataSource= " + global.EntityClassList + ";"); loadData.Append("\n\t\t\t" + repeaterID + ".DataBind();"); loadData.Append("\n\t\t\t" + repeaterID + ".Visible = true;"); //-------- loadData.Append("\n\t\t\tpager.Visible = true;"); loadData.Append("\n\t\t\tpager.TotalRecords = totalRecords;"); loadData.Append("\n\t\t\tPagerManager.PrepareUserPager(pager);"); //-------- loadData.Append("\n\t\t}"); loadData.Append("\n\t\telse"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t" + repeaterID + ".Visible=false;"); loadData.Append("\n\t\t\tpager.Visible = false;"); loadData.Append("\n\t\t}"); loadData.Append("\n\t}"); loadData.Append("\n\t//--------------------------------------------------------"); loadData.Append("\n\t#endregion"); return(loadData.ToString()); }