private void GenBusinessObjectByTable(string table) { string boString = string.Empty; try { if (!string.IsNullOrEmpty(ProjectName) && !string.IsNullOrEmpty(table)) { ProjectParameter st = ProjectParameter.GetSettingsByProjectName(CurrentSession.UserCode, ProjectName); boString = new GetTogether.Studio.Database.CodeGenerator(st).GenerateCodeByTable(GetTogether.Studio.Database.CodeGenerator.CodeType.BLL, table, PrimaryKeyOverwrite, true); } } catch (Exception ex) { boString = ex.ToString(); } Response.Write(string.Concat(@"<div class='box-option'>Business Object (Double click on the textarea to enlarge)</div> <div class='box'><textarea rows='10' style='width:99.8%;'>", boString, "</textarea></div>")); }
private void GenDataObjectByTable(string table) { string doString = string.Empty; string primaryKeys = string.Empty; string autoIncrement = string.Empty; try { if (!string.IsNullOrEmpty(ProjectName) && !string.IsNullOrEmpty(table)) { ProjectParameter st = ProjectParameter.GetSettingsByProjectName(CurrentSession.UserCode, ProjectName); CodeGenerator cg = new GetTogether.Studio.Database.CodeGenerator(st); doString = cg.GenerateCodeByTable(GetTogether.Studio.Database.CodeGenerator.CodeType.DAL, table, PrimaryKeyOverwrite, true); ColumnMapping.ColumnInfos columnInfos = cg.GetColumnsInfo(table, ""); primaryKeys = GetTogether.Utility.StringHelper.ArrayToString(columnInfos.PrimaryKeys.ToArray(), ","); autoIncrement = GetTogether.Utility.StringHelper.ArrayToString(columnInfos.AutoIncrements.ToArray(), ","); if (string.IsNullOrEmpty(primaryKeys)) primaryKeys = "-"; if (string.IsNullOrEmpty(autoIncrement)) autoIncrement = "-"; } } catch (Exception ex) { doString = ex.ToString(); } Response.Write(string.Format(@"<div class='box-option' style='padding-left:2px;'>{0}</div> <div class='header-2 box' style='padding:2px;'> <div> Auto Increment: <span style='font-style:italic;'>{3}</span> </div> <div class='line-sub'></div> <div> Primary Key(s): <span style='font-style:italic;'>{2}</span> </div> <div class='line-sub'></div> <div> Primary Key Overwrite:<input type=""text"" style='width:50%;' id=""primary-key-overwrite"" value=""{1}"" class=""txt"" /> </div> <div class='line-sub' style='margin:3px 0px;'></div> <div style='text-align:right;'> <input class='btn6' type='button' onclick=""GenDoTableCode('{0}');"" value=""Re-Generate"" /> <input class='btn6' type='button' style='margin-left:5px;' onclick=""GenerateManagePage('{0}');"" value=""Management"" /> <input class='btn6' type='button' style='margin-left:5px;' onclick=""GenerateManagePage('{0}',true);"" value=""Download Management Pages"" /> </div> </div>", table, PrimaryKeyOverwrite, primaryKeys, autoIncrement)); Response.Write(string.Concat(@"<div class='box-option' style='margin-top:5px;'>Data Object (Double click on the textarea to enlarge) </div><div class='box'><textarea rows='10' style='width:99.8%;'>", doString, "</textarea></div>")); }
private void GetDataObjectByStoreProce(string objName, string spName, string sql, string returnObjMapping) { if (!string.IsNullOrEmpty(returnObjMapping) && returnObjMapping.Trim().StartsWith("//")) returnObjMapping = string.Empty; string doString = string.Empty; if (!string.IsNullOrEmpty(ProjectName) && !string.IsNullOrEmpty(objName) && !string.IsNullOrEmpty(spName) && !string.IsNullOrEmpty(sql)) { try { ProjectParameter pj = ProjectParameter.GetSettingsByProjectName(CurrentSession.UserCode, ProjectName); doString = new GetTogether.Studio.Database.CodeGenerator(pj).GenerateCodeByStoreProcedure(CodeGenerator.CodeType.DAL, objName, spName, sql, returnObjMapping); } catch (Exception ex) { doString = ex.ToString(); } } else { doString = string.Format("Invalid Parameters[Project Name:{0},Object Name:{1},Store Procedure:{2},SQL:{3}", ProjectName, objName, spName, sql); } Response.Write(string.Concat(@"<div class='box-option' style='margin-top:5px;'>Data Object (Double click on the textarea to enlarge)</div> <div class='box'><textarea rows='10' style='width:99.8%;'>", doString, "</textarea></div>")); }
private void GetDataObjectByQuery(string tableName, string primaryKeys, string sql) { string doString = string.Empty; if (!string.IsNullOrEmpty(ProjectName) && !string.IsNullOrEmpty(tableName) && !string.IsNullOrEmpty(primaryKeys)) { try { ProjectParameter st = ProjectParameter.GetSettingsByProjectName(CurrentSession.UserCode, ProjectName); doString = new GetTogether.Studio.Database.CodeGenerator(st).GenerateCodeByScript(GetTogether.Studio.Database.CodeGenerator.CodeType.DAL, tableName, sql, primaryKeys, true); } catch (Exception ex) { doString = ex.ToString(); } } else { doString = string.Format("Invalid Parameters[Project Name:{0},Table Name:{1},Primary Key(s):{2},SQL:{3}", ProjectName, tableName, primaryKeys, sql); } Response.Write(string.Concat(@"<div class='box-option'>Data Object (Double click on the textarea to enlarge)</div> <div class='box'><textarea rows='10' style='width:99.8%;'>", doString, "</textarea></div>")); }