public void Refresh() { _TableName = ""; id = null; _Table = null; TableParentTables = null; }
public Generator() { Fields = SqlProvider.obj.Fields; //----------------------------- ID = SqlProvider.obj.ID; Table = SqlProvider.obj.TableName; global = new Globals(); }
//------------------------------------------------------------ public static bool CheckIsAddedBySql(SQLDMO.Column clmn) { if (clmn.Identity && clmn.IdentityIncrement > 0) { return(true); } else { return(false); } }
//------------------------------------------------------------ public static int GetTextBoxMaxLength(SQLDMO.Column column) { if (column.Datatype.ToLower() == SqlDbType.BigInt.ToString().ToLower()) { return(20); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Binary.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Bit.ToString().ToLower()) { return(1); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Char.ToString().ToLower()) { return(column.Length); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.DateTime.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Decimal.ToString().ToLower()) { return(40); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Float.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Image.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Int.ToString().ToLower()) { return(9); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Money.ToString().ToLower()) { return(20); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.NChar.ToString().ToLower()) { return(column.Length); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.NText.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.NVarChar.ToString().ToLower()) { return(column.Length); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Real.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.SmallDateTime.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.SmallInt.ToString().ToLower()) { return(6); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.SmallMoney.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Text.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Timestamp.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.TinyInt.ToString().ToLower()) { return(3); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.UniqueIdentifier.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.VarBinary.ToString().ToLower()) { return(0); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.VarChar.ToString().ToLower()) { return(column.Length); } //----------------------------------- else if (column.Datatype.ToLower() == SqlDbType.Variant.ToString().ToLower()) { return(0); } else { return(0); } }
//------------------------------------- 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(""); } }
//-------------------------------------- // protected string GenerateClass() { string id = Globals.GetProgramatlyName(ID.Name); id = Globals.ConvetStringToCamelCase(id); string headerProperity = ""; string boxHeader = ""; if (Fields.Count >= 2) { SQLDMO.Column headerColumn = (SQLDMO.Column)Fields.Item(1); headerProperity = Globals.GetProgramatlyName(headerColumn.Name); boxHeader = global.EntityClassObject + "." + headerProperity; } else { boxHeader = "\"\""; } StringBuilder pageCode = new StringBuilder(); pageCode.Append("using System;\n"); pageCode.Append("using System.Data;\n"); pageCode.Append("using System.Configuration;\n"); pageCode.Append("using System.Collections;\n"); pageCode.Append("using System.Web;\n"); pageCode.Append("using System.Web.Security;\n"); pageCode.Append("using System.Web.UI;\n"); pageCode.Append("using System.Web.UI.WebControls;\n"); pageCode.Append("using System.Web.UI.WebControls.WebParts;\n"); pageCode.Append("using System.Web.UI.HtmlControls;\n"); pageCode.Append("using System.Drawing;\n"); pageCode.Append("\npublic partial class Details : System.Web.UI.Page"); pageCode.Append("\n{"); pageCode.Append("\n\t#region --------------LoadData--------------"); pageCode.Append("\n\t//---------------------------------------------------------"); pageCode.Append("\n\t//Page_Load"); pageCode.Append("\n\t//---------------------------------------------------------"); pageCode.Append("\n\tprotected void Page_Load(object sender, EventArgs e)"); pageCode.Append("\n\t{"); pageCode.Append("\n\t\tif (!IsPostBack)"); pageCode.Append("\n\t\t{"); if (ProjectBuilder.HasConfiguration) { pageCode.Append("\n\t\t\tSiteOptions.CheckModuleWithHandling(Resources.SiteOptions." + SiteOptionsBuilder.GetHasPropertyString(Table) + ", ViewerType.User);"); } pageCode.Append("\n\t\t\t//Set Boxes Headers"); pageCode.Append("\n\t\t\tSetBoxesHeaders();"); pageCode.Append("\n\t\t}"); pageCode.Append("\n\t}"); pageCode.Append("\n\t//--------------------------------------------------------"); pageCode.Append("\n\t#endregion"); pageCode.Append("\n\t"); pageCode.Append("\n\t#region Set Boxes Headers"); pageCode.Append("\n\t//--------------------------------------------------------"); pageCode.Append("\n\t//Set Boxes Headers"); pageCode.Append("\n\t//--------------------------------------------------------"); pageCode.Append("\n\tprotected void SetBoxesHeaders()"); pageCode.Append("\n\t{"); SiteUrlsBuilder.AddParameter(Globals.GetProgramatlyName(ID.Name)); pageCode.Append("\n\t\tif(MoversFW.Components.UrlManager.ChechIsValidIntegerParameter(" + SiteUrlsBuilder.GetIdentifire() + Globals.GetProgramatlyName(ID.Name) + "))"); pageCode.Append("\n\t\t{"); pageCode.Append("\n\t\t\t" + Globals.GetAliasDataType(ID.Datatype) + " " + id + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(Request.QueryString[" + SiteUrlsBuilder.GetIdentifire() + Globals.GetProgramatlyName(ID.Name) + "]);"); pageCode.Append("\n\t\t\t" + global.TableEntityClass + " " + global.EntityClassObject + " =" + global.TableFactoryClass + ".Get" + global.TableProgramatlyName + "Object(" + id + ");"); pageCode.Append("\n\t\t\tif (" + global.EntityClassObject + " != null)"); pageCode.Append("\n\t\t\t{"); pageCode.Append("\n\t\t\t\t" + masterBoxID + ".Header = " + boxHeader + ";"); pageCode.Append("\n\t\t\t}"); pageCode.Append("\n\t\t\telse"); pageCode.Append("\n\t\t\t{"); pageCode.Append("\n\t\t\t\tResponse.Redirect(\"/default.aspx\");"); pageCode.Append("\n\t\t\t}"); pageCode.Append("\n\t\t}"); pageCode.Append("\n\t\telse"); pageCode.Append("\n\t\t{"); pageCode.Append("\n\t\t\tResponse.Redirect(\"/default.aspx\");"); pageCode.Append("\n\t\t}"); pageCode.Append("\n\t}"); pageCode.Append("\n\t//--------------------------------------------------------"); pageCode.Append("\n\t#endregion"); pageCode.Append("\n}"); return(pageCode.ToString()); }