/// <summary> /// 生成update查询语句 /// </summary> /// <param name="dbname">库名</param> /// <param name="tablename">表名</param> /// <returns></returns> public string GetSQLDelete(string dbname, string tablename) { dbobj.DbConnectStr = _dbconnectStr; DataTable dt = dbobj.GetColumnList(dbname, tablename); this.DbName = dbname; this.TableName = tablename; StringPlus strsql = new StringPlus(); strsql.AppendLine("delete from " + tablename); strsql.Append(" where <搜索条件>"); return(strsql.Value); }
/// <summary> /// 生成update查询语句 /// </summary> /// <param name="dbname">库名</param> /// <param name="tablename">表名</param> /// <returns></returns> public string GetSQLUpdate(string dbname, string tablename) { dbobj.DbConnectStr = _dbconnectStr; DataTable dt = dbobj.GetColumnList(dbname, tablename); this.DbName = dbname; this.TableName = tablename; StringPlus strsql = new StringPlus(); strsql.AppendLine("update " + tablename + " set "); if (dt != null) { foreach (DataRow row in dt.Rows) { string columnName = row["ColumnName"].ToString(); strsql.AppendLine("[" + columnName + "] = <" + columnName + ">,"); } strsql.DelLastComma(); } strsql.Append(" where <搜索条件>"); return(strsql.Value); }
public string CreatPROCGetMaxID() { StringPlus strclass = new StringPlus(); strclass.AppendLine("------------------------------------"); strclass.AppendLine("--用途:得到最大ID "); strclass.AppendLine("--项目名称:" + ProjectName); strclass.AppendLine("--说明:"); strclass.AppendLine("--时间:" + DateTime.Now.ToString()); strclass.AppendLine("------------------------------------"); strclass.AppendLine("CREATE PROCEDURE " + ProcPrefix + "" + _tablename + "_GetMaxId"); strclass.AppendLine("AS"); strclass.AppendSpaceLine(1, "DECLARE @TempID int"); strclass.AppendSpaceLine(1, "SELECT @TempID = max([" + ID + "])+1 FROM " + _tablename); strclass.AppendSpaceLine(1, "IF @TempID IS NULL"); strclass.AppendSpaceLine(2, "RETURN 1"); strclass.AppendSpaceLine(1, "ELSE"); strclass.AppendSpaceLine(2, "RETURN @TempID"); strclass.AppendLine(""); strclass.AppendLine("GO"); return(strclass.ToString()); }
public string GetSQLUpdate(string dbname, string tablename) { this.dbobj.DbConnectStr = this._dbconnectStr; List <ColumnInfo> columnList = this.dbobj.GetColumnList(dbname, tablename); this.DbName = dbname; this.TableName = tablename; StringPlus stringPlus = new StringPlus(); stringPlus.AppendLine("update " + tablename + " set "); if (columnList != null && columnList.Count > 0) { foreach (ColumnInfo current in columnList) { string columnName = current.ColumnName; stringPlus.AppendLine(columnName + " = <" + columnName + ">,"); } stringPlus.DelLastComma(); } stringPlus.Append(" where <搜索条件>"); return(stringPlus.Value); }
/// <summary> /// 生成update查询语句 /// </summary> /// <param name="dbname">库名</param> /// <param name="tablename">表名</param> /// <returns></returns> public string GetSQLUpdate(string dbname, string tablename) { dbobj.DbConnectStr = _dbconnectStr; List <ColumnInfo> collist = dbobj.GetColumnList(dbname, tablename); this.DbName = dbname; this.TableName = tablename; StringPlus strsql = new StringPlus(); strsql.AppendLine("UPDATE [" + tablename + "] set "); if ((collist != null) && (collist.Count > 0)) { foreach (ColumnInfo col in collist) { string columnName = col.ColumnName; strsql.AppendLine("[" + columnName + "] = <" + columnName + ">,"); } strsql.DelLastComma(); } strsql.AppendLine(" WHERE <搜索条件>"); return(strsql.Value); }
/// <summary> /// 得到Update()的代码 /// </summary> /// <param name="DbName"></param> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <param name="ModelName"></param> /// <returns></returns> public string CreatUpdate() { if (ModelSpace == "") { //ModelSpace = "ModelClassName"; ; } StringPlus strclass = new StringPlus(); StringPlus strclass1 = new StringPlus(); StringPlus strclass2 = new StringPlus(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 更新一条数据"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public void Update(" + ModelSpace + " model)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"update " + _tablename + " set \");"); //int n = 0; foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string Length = field.Length; bool IsIdentity = field.IsIdentity; bool isPK = field.IsPK; strclass1.AppendSpaceLine(3, "db.AddInParameter(dbCommand, \"" + columnName + "\", DbType." + CSToProcType(columnType) + ", model." + columnName + ");"); if (field.IsIdentity || field.IsPK || (Keys.Contains(field))) { continue; } strclass.AppendSpaceLine(3, "strSql.Append(\"" + columnName + "=" + preParameter + columnName + ",\");"); } //去掉最后的逗号 strclass.DelLastComma(); strclass.AppendLine("\");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + GetWhereExpression(Keys) + "\");"); strclass.AppendSpaceLine(3, "Database db = DatabaseFactory.CreateDatabase();"); strclass.AppendSpaceLine(3, "DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());"); strclass.Append(strclass1.Value); strclass.AppendSpaceLine(3, "db.ExecuteNonQuery(dbCommand);\r\n"); strclass.AppendSpaceLine(2, "}"); return(strclass.ToString()); }
public string CreatPROCGetMaxID() { StringPlus stringPlus = new StringPlus(); if (this._keys.Count > 0) { foreach (ColumnInfo current in this._keys) { if (CodeCommon.DbTypeToCS(current.TypeName) == "int") { string columnName = current.ColumnName; if (current.IsPrimaryKey) { stringPlus.AppendLine("------------------------------------"); stringPlus.AppendLine("--用途:得到主键字段最大值 "); stringPlus.AppendLine("--项目名称:" + this.ProjectName); stringPlus.AppendLine("--说明:"); stringPlus.AppendLine("--时间:" + DateTime.Now.ToString()); stringPlus.AppendLine("------------------------------------"); stringPlus.AppendLine("CREATE PROCEDURE " + this.ProcPrefix + this._tablename + "_GetMaxId"); stringPlus.AppendLine("AS"); stringPlus.AppendSpaceLine(1, "DECLARE @TempID int"); stringPlus.AppendSpaceLine(1, "SELECT @TempID = max([" + columnName + "])+1 FROM " + this._tablename); stringPlus.AppendSpaceLine(1, "IF @TempID IS NULL"); stringPlus.AppendSpaceLine(2, "RETURN 1"); stringPlus.AppendSpaceLine(1, "ELSE"); stringPlus.AppendSpaceLine(2, "RETURN @TempID"); stringPlus.AppendLine(""); stringPlus.AppendLine("GO"); break; } } } } return(stringPlus.ToString()); }
/// <summary> /// 生成INSERT查询语句 /// </summary> /// <param name="dbname">库名</param> /// <param name="tablename">表名</param> /// <returns></returns> public string GetSQLInsert(string dbname, string tablename) { dbobj.DbConnectStr = _dbconnectStr; //DataTable dt = dbobj.GetColumnList(dbname, tablename); List <ColumnInfo> collist = dbobj.GetColumnList(dbname, tablename); this.DbName = dbname; this.TableName = tablename; StringPlus strsql = new StringPlus(); StringPlus strsql2 = new StringPlus(); strsql.AppendLine("INSERT INTO [" + tablename + "] ( "); if ((collist != null) && (collist.Count > 0)) { foreach (ColumnInfo col in collist) { string columnName = col.ColumnName; string columnType = col.TypeName; strsql.AppendLine("[" + columnName + "] ,"); if (LTP.CodeHelper.CodeCommon.IsAddMark(columnType)) { strsql2.Append("'" + columnName + "',"); } else { strsql2.Append(columnName + ","); } } strsql.DelLastComma(); strsql2.DelLastComma(); } strsql.Append(") VALUES (" + strsql2.Value + ")"); return(strsql.Value); }
public string GetShowAspx() { StringPlus stringPlus = new StringPlus(); stringPlus.AppendLine(); stringPlus.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">"); foreach (ColumnInfo current in this.Fieldlist) { string columnName = current.ColumnName; string typeName = current.TypeName; string text = current.Description; text = CodeCommon.CutDescText(text, 15, columnName); stringPlus.AppendSpaceLine(1, "<tr>"); stringPlus.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">"); stringPlus.AppendSpaceLine(2, text); stringPlus.AppendSpaceLine(1, ":</td>"); stringPlus.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">"); typeName.Trim().ToLower(); stringPlus.AppendSpaceLine(2, "<asp:Label id=\"lbl" + columnName + "\" runat=\"server\"></asp:Label>"); stringPlus.AppendSpaceLine(1, "</td></tr>"); } stringPlus.AppendLine("</table>"); return(stringPlus.ToString()); }
public string CreateDBTabScript(string dbname) { this.dbobj.DbConnectStr = this.DbConnectStr; StringPlus stringPlus = new StringPlus(); List <string> tables = this.dbobj.GetTables(dbname); if (tables.Count > 0) { foreach (string current in tables) { stringPlus.AppendLine(this.CreateTabScript(dbname, current)); } } return(stringPlus.Value); }
/// <summary> /// 得到一个库下所有表的存储过程 /// </summary> /// <param name="DbName"></param> /// <returns></returns> public string GetPROCCode(string dbname) { dbobj.DbConnectStr = this.DbConnectStr; StringPlus strclass = new StringPlus(); List <string> tabNames = dbobj.GetTables(dbname); if (tabNames.Count > 0) { foreach (string tabname in tabNames) { strclass.AppendLine(GetPROCCode(dbname, tabname)); } } return(strclass.Value); }
/// <summary> /// 生成修改方法代码 /// </summary> /// <param name="tableName"></param> /// <param name="columnList"></param> /// <param name="keyColumnList"></param> /// <returns></returns> public string BuildCode_Update(string tableName, List <Column> columnList, List <Column> keyColumnList) { StringPlus sp = new StringPlus(); //注释 sp.AppendSpaceLine(1, "/// <summary>"); sp.AppendSpaceLine(1, "/// " + "修改"); sp.AppendSpaceLine(1, "/// </summary>"); //方法头 string strretu = "int"; string strFun = "\t" + "public " + strretu + " Update(" + tableName + " model)"; sp.AppendLine(strFun); //方法体 sp.AppendSpaceLine(1, "{"); sp.AppendSpaceLine(2, "StringBuilder strSql = new StringBuilder();"); sp.AppendSpaceLine(2, "strSql.Append(\"update " + tableName + " set \");"); string columnsString = BuildHelper.BuildSetString(columnList); sp.AppendSpaceLine(2, "strSql.Append(\" " + columnsString + " \");"); sp.AppendSpaceLine(2, "strSql.Append(\" where " + BuildHelper.BuildWhereStringInP(keyColumnList) + "\");"); sp.AppendSpaceLine(2, "SqlParameter[] parameters = new SqlParameter[" + (columnList.Count + keyColumnList.Count) + "];"); int i = 0; for (i = 0; i < columnList.Count; i++) { sp.AppendSpaceLine(2, "parameters[" + i + "] = new SqlParameter(\"@" + columnList[i].Name + "\", SqlDbType." + columnList[i].Type.ToSqlDbTypeString() + ");"); } for (int k = 0; k < keyColumnList.Count; k++, i++) { sp.AppendSpaceLine(2, "parameters[" + i + "] = new SqlParameter(\"@" + keyColumnList[k].Name + "\", SqlDbType." + keyColumnList[k].Type.ToSqlDbTypeString() + ");"); } int j = 0; for (j = 0; j < columnList.Count; j++) { sp.AppendSpaceLine(2, "parameters[" + j + "].Value = model." + columnList[j].Name + ";"); } for (int k = 0; k < keyColumnList.Count; k++, j++) { sp.AppendSpaceLine(2, "parameters[" + j + "].Value = model." + keyColumnList[k].Name + ";"); } sp.AppendSpaceLine(2, "return SQLHelper.ExecuteSql(strSql.ToString(), parameters);"); sp.AppendSpaceLine(1, "}"); return(sp.ToString()); }
/// <summary> /// ��������Model�� /// </summary> public string CreatModelMethodT() { StringPlus strclass = new StringPlus(); strclass.AppendLine(CreatModelMethod()); strclass.AppendSpaceLine(2, "private List<" + ModelNameSon + "> _" + ModelNameSon.ToLower() + "s;");//˽�б��� strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// ���� "); strclass.AppendSpaceLine(2, "/// </summary>"); //strclass.AppendSpaceLine(2, "[Serializable]"); strclass.AppendSpaceLine(2, "public List<" + ModelNameSon + "> " + ModelNameSon + "s");//���� strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "set{" + " _" + ModelNameSon.ToLower() + "s=value;}"); strclass.AppendSpaceLine(3, "get{return " + "_" + ModelNameSon.ToLower() + "s;}"); strclass.AppendSpaceLine(2, "}"); return strclass.ToString(); }
public string GetIDALCode(bool Maxid, bool Exists, bool Add, bool Update, bool Delete, bool GetModel, bool List) { StringPlus stringPlus = new StringPlus(); stringPlus.AppendLine("using System;"); stringPlus.AppendLine("using System.Data;"); stringPlus.AppendLine("namespace " + this.IDALpath); stringPlus.AppendLine("{"); stringPlus.AppendSpaceLine(1, "/// <summary>"); stringPlus.AppendSpaceLine(1, "/// 接口层" + this.TableDescription); stringPlus.AppendSpaceLine(1, "/// </summary>"); stringPlus.AppendSpaceLine(1, "public interface " + this.IClass); stringPlus.AppendSpaceLine(1, "{"); stringPlus.AppendSpaceLine(2, "#region 成员方法"); if (Maxid) { stringPlus.Append(this.CreatGetMaxID()); } if (Exists) { stringPlus.Append(this.CreatExists()); } if (Add) { stringPlus.Append(this.CreatAdd()); } if (Update) { stringPlus.Append(this.CreatUpdate()); } if (Delete) { stringPlus.Append(this.CreatDelete()); } if (GetModel) { stringPlus.Append(this.CreatGetModel()); } if (List) { stringPlus.Append(this.CreatGetList()); } stringPlus.AppendSpaceLine(2, "#endregion 成员方法"); stringPlus.AppendSpaceLine(2, "#region MethodEx"); stringPlus.AppendLine(""); stringPlus.AppendSpaceLine(2, "#endregion MethodEx"); stringPlus.AppendLine("\t} "); stringPlus.AppendLine("}"); return(stringPlus.ToString()); }
/// <summary> /// 得到一个库下所有表的存储过程 /// </summary> /// <param name="DbName"></param> /// <returns></returns> public string GetPROCCode(string dbname) { dbobj.DbConnectStr = _dbconnectStr; DataTable dt = dbobj.GetTabViews(dbname); StringPlus strclass = new StringPlus(); if (dt != null) { foreach (DataRow row in dt.Rows) { string tabname = row["name"].ToString(); strclass.AppendLine(GetPROCCode(dbname, tabname)); } } return(strclass.Value); }
public string GetPROCCode(string dbname) { this.dbobj.DbConnectStr = this._dbconnectStr; DataTable tabViews = this.dbobj.GetTabViews(dbname); StringPlus stringPlus = new StringPlus(); if (tabViews != null) { foreach (DataRow dataRow in tabViews.Rows) { string tablename = dataRow["name"].ToString(); stringPlus.AppendLine(this.GetPROCCode(dbname, tablename)); } } return(stringPlus.Value); }
/// <summary> /// 得到Update()的代码 /// </summary> /// <param name="DbName"></param> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <param name="ModelName"></param> /// <returns></returns> public string CreatUpdate() { //if (ModelSpace == "") //{ // ModelSpace = "ModelClassName"; ; //} StringPlus strclass = new StringPlus(); strclass.AppendLine(""); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 更新一条数据"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public void Update(" + ModelSpace + " model)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "Database db = DatabaseFactory.CreateDatabase();"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"update " + _tablename + " set \");"); foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string Length = field.Length; bool IsIdentity = field.IsIdentity; bool isPK = field.IsPK; if (field.IsIdentity || field.IsPK || (Keys.Contains(field))) { continue; } if (CodeCommon.IsAddMark(columnType.Trim())) { strclass.AppendSpaceLine(3, "strSql.Append(\"" + columnName + "='\"+model." + columnName + "+\"',\");"); } else { strclass.AppendSpaceLine(3, "strSql.Append(\"" + columnName + "=\"+model." + columnName + "+\",\");"); } } //去掉最后的逗号 strclass.Remove(strclass.Value.Length - 6, 1); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + LTP.CodeHelper.CodeCommon.GetModelWhereExpression(Keys) + "\");"); strclass.AppendSpaceLine(3, "DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());"); strclass.AppendSpaceLine(3, "db.ExecuteNonQuery(dbCommand);"); strclass.AppendSpace(2, "}"); return(strclass.ToString()); }
/// <summary> /// 生成数据库所有表的创建脚本 /// </summary> /// <returns></returns> public string CreateDBTabScript(string dbname) { dbobj.DbConnectStr = this.DbConnectStr; DataTable dt = dbobj.GetTables(dbname); StringPlus strclass = new StringPlus(); if (dt != null) { foreach (DataRow row in dt.Rows) { string tabname = row["name"].ToString(); strclass.AppendLine(CreateTabScript(dbname, tabname)); } } return(strclass.Value); }
/// <summary> /// 生成完整Model类 /// </summary> public string CreatModelMethodT() { StringPlus strclass = new StringPlus(); strclass.AppendLine(CreatModelMethod()); strclass.AppendSpaceLine(2, "private List<" + ModelNameSon + "> _" + ModelNameSon.ToLower() + "s;");//私有变量 strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 子类 "); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "[Serializable]"); strclass.AppendSpaceLine(2, "public List<" + ModelNameSon + "> " + ModelNameSon + "s");//属性 strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "set{" + " _" + ModelNameSon.ToLower() + "s=value;}"); strclass.AppendSpaceLine(3, "get{return " + "_" + ModelNameSon.ToLower() + "s;}"); strclass.AppendSpaceLine(2, "}"); return(strclass.ToString()); }
public string GetListAspx() { StringPlus stringPlus = new StringPlus(); stringPlus.AppendLine(); foreach (ColumnInfo current in this.Fieldlist) { string columnName = current.ColumnName; string typeName = current.TypeName; string text = current.Description; bool arg_43_0 = current.IsPrimaryKey; bool isIdentity = current.IsIdentity; text = CodeCommon.CutDescText(text, 15, columnName); if (!isIdentity && !this.isFilterColume(columnName)) { string a; if ((a = typeName.Trim().ToLower()) != null && (a == "bit" || a == "dateTime")) { stringPlus.AppendSpaceLine(2, string.Concat(new string[] { "<asp:BoundField DataField=\"", columnName, "\" HeaderText=\"", text, "\" SortExpression=\"", columnName, "\" ItemStyle-HorizontalAlign=\"Center\" /> " })); } else { stringPlus.AppendSpaceLine(2, string.Concat(new string[] { "<asp:BoundField DataField=\"", columnName, "\" HeaderText=\"", text, "\" SortExpression=\"", columnName, "\" ItemStyle-HorizontalAlign=\"Center\" /> " })); } } } return(stringPlus.ToString()); }
/// <summary> /// 得到方法输入参数的列表 (例如:用于Exists Delete GetModel 的参数传入) /// </summary> /// <param name="keys"></param> /// <returns></returns> public string GetInParameter(List <ColumnInfo> fieldlist, bool output) { StringPlus strclass = new StringPlus(); foreach (ColumnInfo field in fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; bool IsIdentity = field.IsIdentity; bool IsPK = field.IsPK; string Length = field.Length; string Preci = field.Preci; string Scale = field.Scale; string isout = " "; if ((IsIdentity) && (output)) { isout = " out "; } switch (columnType.ToLower()) { case "decimal": case "numeric": strclass.Append("" + columnName + "_in" + isout + columnType + "(" + Preci + "," + Scale + ")"); break; case "varchar": case "nvarchar": case "char": case "nchar": strclass.Append("" + columnName + "_in" + isout + columnType + "(" + Length + ")"); break; default: strclass.Append("" + columnName + "_in" + isout + columnType); break; } if ((IsIdentity) && (output)) { continue; } strclass.AppendLine(","); } strclass.DelLastComma(); return(strclass.Value); }
/// <summary> /// 增加窗体的html代码 /// </summary> public string GetAddDesigner() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; if (IsIdentity) { continue; } if (isFilterColume(columnName)) { continue; } if ("uniqueidentifier" == columnType.ToLower()) { continue; } switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower()) { case "datetime": case "smalldatetime": strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.TextBox txt" + columnName + ";"); break; case "bool": strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.CheckBox chk" + columnName + ";"); break; default: strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.TextBox txt" + columnName + ";"); break; } } //按钮 strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Button btnSave;"); strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Button btnCancel;"); return(strclass.ToString()); }
/// <summary> /// 得到Delete的代码 /// </summary> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <returns></returns> public string CreatDelete() { StringPlus strclass = new StringPlus(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 删除一条数据"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public void Delete(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "int rowsAffected;"); strclass.AppendLine(GetPreParameter(Keys)); strclass.AppendSpaceLine(3, "" + DbHelperName + ".RunProcedure(\"" + ProcPrefix + _tablename + "_Delete" + "\",parameters,out rowsAffected);"); strclass.AppendSpaceLine(2, "}"); return(strclass.Value); }
/// <summary> /// 得到Delete的代码 /// </summary> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <returns></returns> public string CreatDelete() { StringPlus strclass = new StringPlus(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 删除一条数据"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public void Delete(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "Database db = DatabaseFactory.CreateDatabase();"); strclass.AppendSpaceLine(3, "DbCommand dbCommand = db.GetStoredProcCommand(\"" + ProcPrefix + _tablename + "_Delete\");"); strclass.AppendLine(GetPreParameter(Keys)); strclass.AppendSpaceLine(3, "db.ExecuteNonQuery(dbCommand);"); strclass.AppendSpaceLine(2, "}"); return(strclass.Value); }
public string GetWebCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm) { StringPlus stringPlus = new StringPlus(); if (AddForm) { stringPlus.AppendLine(" /******************************增加窗体代码********************************/"); stringPlus.AppendLine(this.GetAddAspxCs()); } if (UpdateForm) { stringPlus.AppendLine(" /******************************修改窗体代码********************************/"); stringPlus.AppendLine(" /*修改代码-显示 */"); stringPlus.AppendLine(this.GetUpdateShowAspxCs()); stringPlus.AppendLine(" /*修改代码-提交更新 */"); stringPlus.AppendLine(this.GetUpdateAspxCs()); } if (ShowForm) { stringPlus.AppendLine(" /******************************显示窗体代码********************************/"); stringPlus.AppendLine(this.GetShowAspxCs()); } return(stringPlus.Value); }
/// <summary> /// 生成sql语句中的参数列表(例如:用于Add Exists Update Delete GetModel 的参数传入) /// </summary> /// <param name="keys"></param> /// <returns></returns> public string GetPreParameter(List <ColumnInfo> keys) { StringPlus strclass = new StringPlus(); StringPlus strclass2 = new StringPlus(); strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {"); int n = 0; foreach (ColumnInfo key in keys) { strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "" + key.ColumnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, key.TypeName, "") + "),"); strclass2.AppendSpaceLine(3, "parameters[" + n.ToString() + "].Value = " + key.ColumnName + ";"); n++; } strclass.DelLastComma(); strclass.AppendLine("};"); strclass.Append(strclass2.Value); return(strclass.Value); }
/// <summary> /// 得到GetModel()的代码 /// </summary> /// <param name="DbName"></param> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <param name="ModelName"></param> /// <returns></returns> public string CreatGetModel() { if (ModelSpace == "") { //ModelSpace = "ModelClassName"; ; } StringPlus strclass = new StringPlus(); strclass.AppendLine(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 得到一个对象实体"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public " + ModelSpace + " GetModel(object Id)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, ModelSpace + " model = ExecuteQueryForObject<" + ModelSpace + ">(\"SelectById\", Id);"); strclass.AppendSpaceLine(3, "return model;"); strclass.AppendSpaceLine(2, "}"); return(strclass.ToString()); }
public string CreatGetModel() { if (ModelSpace == "") { //ModelSpace = "ModelClassName"; ; } StringPlus stringPlus = new StringPlus(); stringPlus.AppendSpaceLine(2, "/// <summary>"); stringPlus.AppendSpaceLine(2, "/// " + this.Languagelist["summaryGetModel"].ToString()); stringPlus.AppendSpaceLine(2, "/// </summary>"); stringPlus.AppendSpaceLine(2, string.Concat(new string[] { "public ", this.ModelSpace, " GetModel(", CodeCommon.GetInParameter(this.Keys, true), ")" })); stringPlus.AppendSpaceLine(2, "{"); stringPlus.AppendLine(CodeCommon.GetPreParameter(this.Keys, true, this.dbobj.DbType)); stringPlus.AppendSpaceLine(3, this.ModelSpace + " model=new " + this.ModelSpace + "();"); stringPlus.AppendSpaceLine(3, string.Concat(new string[] { "DataSet ds= ", this.DbHelperName, ".RunProcedure(\"", this.ProcPrefix, this._tablename, "_GetModel\",parameters,\"ds\");" })); stringPlus.AppendSpaceLine(3, "if(ds.Tables[0].Rows.Count>0)"); stringPlus.AppendSpaceLine(3, "{"); stringPlus.AppendSpaceLine(4, "return DataRowToModel(ds.Tables[0].Rows[0]);"); stringPlus.AppendSpaceLine(3, "}"); stringPlus.AppendSpaceLine(3, "else"); stringPlus.AppendSpaceLine(3, "{"); stringPlus.AppendSpaceLine(4, "return null;"); stringPlus.AppendSpaceLine(3, "}"); stringPlus.AppendSpaceLine(2, "}"); return(stringPlus.Value); }
/// <summary> /// 得到Exists方法的代码 /// </summary> /// <param name="_tablename"></param> /// <param name="ID"></param> /// <returns></returns> public string CreatExists() { StringPlus strclass = new StringPlus(); if (_keys.Count > 0) { strclass.AppendLine(""); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 是否存在该记录"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool Exists(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"select count(1) from " + _tablename + "\");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + LTP.CodeHelper.CodeCommon.GetWhereExpression(Keys) + "\");"); strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Exists(strSql.ToString());"); strclass.AppendSpace(2, "}"); } return(strclass.ToString()); }
public string CreatGetMaxID() { StringPlus stringPlus = new StringPlus(); if (this.Keys.Count > 0) { foreach (ColumnInfo current in this.Keys) { if (CodeCommon.DbTypeToCS(current.TypeName) == "int" && current.IsPrimaryKey) { stringPlus.AppendSpaceLine(2, "/// <summary>"); stringPlus.AppendSpaceLine(2, "/// 得到最大ID"); stringPlus.AppendSpaceLine(2, "/// </summary>"); stringPlus.AppendLine("\t\tint GetMaxId();"); break; } } } return(stringPlus.ToString()); }
/// <summary> /// 得到Exists方法的代码 /// </summary> /// <param name="_tablename"></param> /// <param name="ID"></param> /// <returns></returns> public string CreatExists() { StringPlus strclass = new StringPlus(); if (_keys.Count > 0) { strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// 是否存在该记录"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool Exists(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "Database db = DatabaseFactory.CreateDatabase();"); strclass.AppendSpaceLine(3, "StringBuilder strSql = new StringBuilder();"); strclass.AppendSpace(3, "strSql.Append(\"select count(1) from " + _tablename); strclass.AppendLine(" where " + GetWhereExpression(Keys) + "\");"); strclass.AppendSpaceLine(3, "DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());"); strclass.Append(GetPreParameter(Keys)); strclass.AppendSpaceLine(3, "int cmdresult;"); strclass.AppendSpaceLine(3, "object obj = db.ExecuteScalar(dbCommand);"); strclass.AppendSpaceLine(3, "if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "cmdresult = 0;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "cmdresult = int.Parse(obj.ToString());"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "if (cmdresult == 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(2, "}"); } return(strclass.Value); }
/// <summary> /// �õ���ʾ���б�����html���� /// </summary> public string GetListAspx() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName); if (IsIdentity) { continue; } if (isFilterColume(columnName)) { continue; } switch (columnType.Trim().ToLower()) { case "bit": case "dateTime": strclass.AppendSpaceLine(2, "<asp:BoundField DataField=\"" + columnName + "\" HeaderText=\"" + deText + "\" SortExpression=\"" + columnName + "\" ItemStyle-HorizontalAlign=\"Center\" /> "); break; default: strclass.AppendSpaceLine(2, "<asp:BoundField DataField=\"" + columnName + "\" HeaderText=\"" + deText + "\" SortExpression=\"" + columnName + "\" ItemStyle-HorizontalAlign=\"Center\" /> "); break; } } return strclass.ToString(); }
/// <summary> /// �õ�Update�����Ĵ��� /// </summary> /// <param name="DbName"></param> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <param name="ModelName"></param> /// <returns></returns> public string CreatUpdate() { if (ModelSpace == "") { //ModelSpace = "ModelClassName"; ; } StringPlus strclass = new StringPlus(); strclass.AppendLine(""); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryUpdate"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool Update(" + ModelSpace + " model)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"update " + _tablename + " set \");"); if (Fieldlist.Count == 0) { Fieldlist = Keys; } foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string Length = field.Length; bool IsIdentity = field.IsIdentity; bool isPK = field.IsPrimaryKey; bool nullable = field.Nullable; if (field.IsIdentity || field.IsPrimaryKey || (Keys.Contains(field))) { continue; } if (columnType.ToLower() == "timestamp") { continue; } strclass.AppendSpaceLine(3, "if (model." + columnName + " != null)"); strclass.AppendSpaceLine(3, "{"); if ((dbobj.DbType == "Oracle") && (columnType.ToLower() == "date" || columnType.ToLower() == "datetime")) { strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "=to_date('\" + model." + columnName + ".ToString() + \"','YYYY-MM-DD HH24:MI:SS'),\");"); } else if (columnType.ToLower() == "bit") { strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "=\"+ (model." + columnName + "? 1 : 0) +\",\");"); } else if (CodeCommon.IsAddMark(columnType.Trim())) { strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "='\"+model." + columnName + "+\"',\");"); } else { strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "=\"+model." + columnName + "+\",\");"); } strclass.AppendSpaceLine(3, "}"); if (nullable) { strclass.AppendSpaceLine(3, "else");//��null����� strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "= null ,\");"); strclass.AppendSpaceLine(3, "}"); } } //ȥ�����Ķ��� strclass.AppendSpaceLine(3, "int n = strSql.ToString().LastIndexOf(\",\");"); strclass.AppendSpaceLine(3, "strSql.Remove(n, 1);"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + Maticsoft.CodeHelper.CodeCommon.GetModelWhereExpression(Keys, true) + "\");"); strclass.AppendSpaceLine(3, "int rowsAffected=" + DbHelperName + ".ExecuteSql(strSql.ToString());"); strclass.AppendSpaceLine(3, "if (rowsAffected > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpace(2, "}"); return strclass.ToString(); }
private string BuilderMethod() { StringPlus plus = new StringPlus(); plus.AppendSpaceLine(2, "#region Method"); //只读 if (IsView) { plus.AppendSpaceLine(2, "/// <summary>"); plus.AppendSpaceLine(2, "/// 是否只读"); plus.AppendSpaceLine(2, "/// </summary>"); plus.AppendSpaceLine(2, "public override bool IsReadOnly()"); plus.AppendSpaceLine(2, "{"); plus.AppendSpaceLine(3, "return true;"); plus.AppendSpaceLine(2, "}"); } Model.ColumnInfo identityColumn = Columns.Find(delegate(Model.ColumnInfo col) { return col.IsIdentity; }); if (null != identityColumn) { plus.AppendSpaceLine(2, "/// <summary>"); plus.AppendSpaceLine(2, "/// 获取实体中的标识列"); plus.AppendSpaceLine(2, "/// </summary>"); plus.AppendSpaceLine(2, "public override Field GetIdentityField()"); plus.AppendSpaceLine(2, "{"); plus.AppendSpaceLine(3, "return _." + identityColumn.ColumnName + ";"); plus.AppendSpaceLine(2, "}"); } List<Model.ColumnInfo> primarykeyColumns = Columns.FindAll(delegate(Model.ColumnInfo col) { return col.IsPK; }); if (null != primarykeyColumns && primarykeyColumns.Count > 0) { plus.AppendSpaceLine(2, "/// <summary>"); plus.AppendSpaceLine(2, "/// 获取实体中的主键列"); plus.AppendSpaceLine(2, "/// </summary>"); plus.AppendSpaceLine(2, "public override Field[] GetPrimaryKeyFields()"); plus.AppendSpaceLine(2, "{"); plus.AppendSpaceLine(3, "return new Field[] {"); StringPlus plus2 = new StringPlus(); foreach (Model.ColumnInfo col in primarykeyColumns) { plus2.AppendSpaceLine(4, "_." + col.ColumnName + ","); } plus.Append(plus2.ToString().TrimEnd().Substring(0, plus2.ToString().TrimEnd().Length - 1)); plus.AppendLine("};"); plus.AppendSpaceLine(2, "}"); } plus.AppendSpaceLine(2, "/// <summary>"); plus.AppendSpaceLine(2, "/// 获取列信息"); plus.AppendSpaceLine(2, "/// </summary>"); plus.AppendSpaceLine(2, "public override Field[] GetFields()"); plus.AppendSpaceLine(2, "{"); plus.AppendSpaceLine(3, "return new Field[] {"); StringPlus plus3 = new StringPlus(); foreach (ColumnInfo col in Columns) { plus3.AppendSpaceLine(4, "_." + col.ColumnName + ","); } plus.Append(plus3.ToString().TrimEnd().Substring(0, plus3.ToString().TrimEnd().Length - 1)); plus.AppendLine("};"); plus.AppendSpaceLine(2, "}"); plus.AppendSpaceLine(2, "/// <summary>"); plus.AppendSpaceLine(2, "/// 获取值信息"); plus.AppendSpaceLine(2, "/// </summary>"); plus.AppendSpaceLine(2, "public override object[] GetValues()"); plus.AppendSpaceLine(2, "{"); plus.AppendSpaceLine(3, "return new object[] {"); StringPlus plus4 = new StringPlus(); foreach (ColumnInfo col in Columns) { plus4.AppendSpaceLine(4, "this._" + col.ColumnName + ","); } plus.Append(plus4.ToString().TrimEnd().Substring(0, plus4.ToString().TrimEnd().Length - 1)); plus.AppendLine("};"); plus.AppendSpaceLine(2, "}"); //2015-08-10注释 //plus.AppendSpaceLine(2, "/// <summary>"); //plus.AppendSpaceLine(2, "/// 给当前实体赋值"); //plus.AppendSpaceLine(2, "/// </summary>"); //plus.AppendSpaceLine(2, "public override void SetPropertyValues(IDataReader reader)"); //plus.AppendSpaceLine(2, "{"); //foreach (ColumnInfo col in Columns) //{ // plus.AppendSpaceLine(3, "this._" + col.ColumnName + " = DataUtils.ConvertValue<" + col.TypeName + ">(reader[\"" + col.ColumnNameRealName + "\"]);"); //} //plus.AppendSpaceLine(2, "}"); //2015-08-10注释 //plus.AppendSpaceLine(2, "/// <summary>"); //plus.AppendSpaceLine(2, "/// 给当前实体赋值"); //plus.AppendSpaceLine(2, "/// </summary>"); //plus.AppendSpaceLine(2, "public override void SetPropertyValues(DataRow row)"); //plus.AppendSpaceLine(2, "{"); //foreach (ColumnInfo col in Columns) //{ // plus.AppendSpaceLine(3, "this._" + col.ColumnName + " = DataUtils.ConvertValue<" + col.TypeName + ">(row[\"" + col.ColumnNameRealName + "\"]);"); //} //plus.AppendSpaceLine(2, "}"); plus.AppendSpaceLine(2, "#endregion"); plus.AppendLine(); plus.AppendSpaceLine(2, "#region _Field"); plus.AppendSpaceLine(2, "/// <summary>"); plus.AppendSpaceLine(2, "/// 字段信息"); plus.AppendSpaceLine(2, "/// </summary>"); plus.AppendSpaceLine(2, "public class _"); plus.AppendSpaceLine(2, "{"); plus.AppendSpaceLine(3, "/// <summary>"); plus.AppendSpaceLine(3, "/// * "); plus.AppendSpaceLine(3, "/// </summary>"); plus.AppendSpaceLine(3, "public readonly static Field All = new Field(\"*\",\"" + TableName + "\");"); foreach (ColumnInfo col in Columns) { plus.AppendSpaceLine(3, "/// <summary>"); plus.AppendSpaceLine(3, "/// " + col.DeText); plus.AppendSpaceLine(3, "/// </summary>"); plus.AppendSpaceLine(3, "public readonly static Field " + col.ColumnName + " = new Field(\"" + col.ColumnNameRealName + "\",\"" + TableName + "\",\"" + (string.IsNullOrEmpty(col.DeText) ? col.ColumnNameRealName : col.DeText) + "\");"); } plus.AppendSpaceLine(2, "}"); plus.AppendSpaceLine(2, "#endregion"); plus.AppendLine(); return plus.ToString(); }
/// <summary> /// �õ�GetList()�Ĵ��� /// </summary> public string CreatGetList() { StringPlus strclass = new StringPlus(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public DataSet GetList(string strWhere)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpace(3, "strSql.Append(\"select "); strclass.AppendLine(Fieldstrlist + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" FROM " + TableNameParent + " \");"); strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());"); strclass.AppendSpaceLine(2, "}"); if ((dbobj.DbType == "SQL2000") || (dbobj.DbType == "SQL2005") || (dbobj.DbType == "SQL2008") || (dbobj.DbType == "SQL2012")) { strclass.AppendLine(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList2"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public DataSet GetList(int Top,string strWhere,string filedOrder)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"select \");"); strclass.AppendSpaceLine(3, "if(Top>0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql.Append(\" top \"+Top.ToString());"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "strSql.Append(\" " + Fieldstrlist + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" FROM " + TableNameParent + " \");"); strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "strSql.Append(\" order by \" + filedOrder);"); strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());"); strclass.AppendSpaceLine(2, "}"); } return strclass.Value; }
/// <summary> /// �õ��Ĵ���Ĵ��� /// </summary> public string GetUpdateAspxCs() { StringPlus strclass = new StringPlus(); StringPlus strclass0 = new StringPlus(); StringPlus strclass1 = new StringPlus(); StringPlus strclass2 = new StringPlus(); strclass.AppendLine(); strclass.AppendSpaceLine(3, "string strErr=\"\";"); //bool ishasuser = false; foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; //���Զ���-�����ֶδ��� //if ( // (columnName.IndexOf("_iCreator") > 0) || //ҳ�治��Ҫ��2�� // (columnName.IndexOf("_dateCreate") > 0) || // (columnName.IndexOf("_bValid") > 0) || // (columnName.IndexOf("_dateValid") > 0) || // (columnName.IndexOf("_dateExpire") > 0) // ) //{ // continue; //} //if ((!ishasuser) && (columnName.IndexOf("_iMaintainer") > 0)) //{ // strclass0.AppendSpaceLine(4, "User currentUser;"); // strclass0.AppendSpaceLine(3, "if (Session[\"UserInfo\"] != null)"); // strclass0.AppendSpaceLine(3, "{"); // strclass0.AppendSpaceLine(4, "currentUser = (User)Session[\"UserInfo\"];"); // strclass0.AppendSpaceLine(3, "}else{"); // strclass0.AppendSpaceLine(4, "return;"); // strclass0.AppendSpaceLine(3, "}"); // ishasuser = true; //} deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName); //���Զ���-�����ֶδ��� //if ((columnName.IndexOf("_cLang") > 0) && (columnType.Trim().ToLower() == "varchar"))//���Դ��� //{ // strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistLanguage1.LanguageCode;"); // continue; //} //if (columnName.IndexOf("_iAuthority") > 0)//Ȩ��ɫ���� //{ // strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistPermission1.PermissionID;"); // continue; //} //if (columnName.IndexOf("_cCurrency") > 0)//���Ҵ��� //{ // strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistCurrency1.CurrencyCode;"); // continue; //} //if (columnName.IndexOf("_cCurrencyUnit") > 0)//���Ҵ��� //{ // strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistCurrencyUnit1.CurrencyUnitID;"); // continue; //} switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower()) { case "int": case "smallint": if ((ispk) || (IsIdentity)) { strclass0.AppendSpaceLine(3, "int " + columnName + "=int.Parse(this.lbl" + columnName + ".Text);"); } else { strclass0.AppendSpaceLine(3, "int " + columnName + "=int.Parse(this.txt" + columnName + ".Text);"); strclass1.AppendSpaceLine(3, "if(!PageValidate.IsNumber(txt" + columnName + ".Text))"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); } break; case "long": if ((ispk) || (IsIdentity)) { strclass0.AppendSpaceLine(3, "long " + columnName + "=long.Parse(this.lbl" + columnName + ".Text);"); } else { strclass0.AppendSpaceLine(3, "long " + columnName + "=long.Parse(this.txt" + columnName + ".Text);"); strclass1.AppendSpaceLine(3, "if(!PageValidate.IsNumber(txt" + columnName + ".Text))"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); } break; case "float": case "numeric": case "decimal": if ((ispk) || (IsIdentity)) { strclass0.AppendSpaceLine(3, "decimal " + columnName + "=decimal.Parse(this.lbl" + columnName + ".Text);"); } else { strclass0.AppendSpaceLine(3, "decimal " + columnName + "=decimal.Parse(this.txt" + columnName + ".Text);"); strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDecimal(txt" + columnName + ".Text))"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); } break; case "datetime": case "smalldatetime": strclass0.AppendSpaceLine(3, "DateTime " + columnName + "=DateTime.Parse(this.txt" + columnName + ".Text);"); strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDateTime(txt" + columnName + ".Text))"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); break; case "bool": strclass0.AppendSpaceLine(3, "bool " + columnName + "=this.chk" + columnName + ".Checked;"); break; case "byte[]": strclass0.AppendSpaceLine(3, "byte[] " + columnName + "= new UnicodeEncoding().GetBytes(this.txt" + columnName + ".Text);"); break; case "guid": case "uniqueidentifier": strclass0.AppendSpaceLine(3, "Guid " + columnName + "= new Guid(this.lbl" + columnName + ".Text);"); break; default: if ((ispk) || (IsIdentity)) { strclass0.AppendSpaceLine(3, "string " + columnName + "=this.lbl" + columnName + ".Text;"); } else { strclass0.AppendSpaceLine(3, "string " + columnName + "=this.txt" + columnName + ".Text;"); strclass1.AppendSpaceLine(3, "if(this.txt" + columnName + ".Text.Trim().Length==0)"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "����Ϊ�գ�\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); } break; } strclass2.AppendSpaceLine(3, "model." + columnName + "=" + columnName + ";"); } strclass.AppendLine(strclass1.ToString()); strclass.AppendSpaceLine(3, "if(strErr!=\"\")"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "MessageBox.Show(this,strErr);"); strclass.AppendSpaceLine(4, "return;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendLine(strclass0.ToString()); strclass.AppendLine(); strclass.AppendSpaceLine(3, ModelSpace + " model=new " + ModelSpace + "();"); strclass.AppendLine(strclass2.ToString()); strclass.AppendSpaceLine(3, BLLSpace + " bll=new " + BLLSpace + "();"); strclass.AppendSpaceLine(3, "bll.Update(model);"); strclass.AppendSpaceLine(3, "Maticsoft.Common.MessageBox.ShowAndRedirect(this,\"����ɹ���\",\"list.aspx\");"); return strclass.ToString(); }
/// <summary> /// �õ���ʾ����ʾ����Ĵ��� /// </summary> public string GetShowAspxCs() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); string key = Key; strclass.AppendSpaceLine(1, "private void ShowInfo(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")"); strclass.AppendSpaceLine(1, "{"); strclass.AppendSpaceLine(2, BLLSpace + " bll=new " + BLLSpace + "();"); strclass.AppendSpaceLine(2, ModelSpace + " model=bll.GetModel(" + Maticsoft.CodeHelper.CodeCommon.GetFieldstrlist(Keys, true) + ");"); //bool ishasuser = false; foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; //if ((ispk) || (IsIdentity)) //{ // continue; //} #region �����ֶδ��� //���Զ���-�����ֶδ��� //if (columnName.IndexOf("_iAuthority") > 0) //{ // continue; //} //if ((columnName.IndexOf("_cLang") > 0) && (columnType.Trim().ToLower() == "varchar"))//���Դ��� //{ // strclass.AppendSpaceLine(2, "BLL.SysManage.MultiLanguage bllML = new BLL.SysManage.MultiLanguage();"); // strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text= bllML.GetLanguageNameByCache(model." + columnName + ");"); // continue; //} //if ((!ishasuser) && ((columnName.IndexOf("_iCreator") > 0) || (columnName.IndexOf("_iMaintainer") > 0))) //{ // strclass.AppendSpaceLine(2, "Maticsoft.Accounts.Bus.User user = new Maticsoft.Accounts.Bus.User();"); // ishasuser = true; //} //if ((columnName.IndexOf("_iCreator") > 0) || (columnName.IndexOf("_iMaintainer") > 0)) //{ // strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text= user.GetTrueNameByCache(model." + columnName + ");"); // ishasuser = true; // continue; //} #endregion switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower()) { case "int": case "long": case "smallint": case "float": case "numeric": case "decimal": case "datetime": case "smalldatetime": strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();"); break; case "bool": strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + "?\"��\":\"��\";"); break; case "byte[]": strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();"); break; case "guid": case "uniqueidentifier": strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();"); break; default: strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ";"); break; } } strclass.AppendLine(); strclass.AppendSpaceLine(1, "}"); return strclass.ToString(); }
/// <summary> /// �õ�GetModel()�Ĵ��� /// </summary> public string CreatGetModel() { //if (ModelSpaceParent == "") //{ // ModelSpaceParent = "ModelClassName"; ; //} StringPlus strclass = new StringPlus(); strclass.AppendLine(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetModel"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public " + ModelSpaceParent + " GetModel(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(KeysParent, true) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"select " + Fieldstrlist + " from " + _tablenameparent + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + CodeCommon.GetWhereParameterExpression(KeysParent, true, dbobj.DbType) + "\");"); strclass.AppendLine(CodeCommon.GetPreParameter(KeysParent, true, dbobj.DbType)); strclass.AppendSpaceLine(3, "" + ModelSpaceParent + " model=new " + ModelSpaceParent + "();"); strclass.AppendSpaceLine(3, "DataSet ds=" + DbHelperName + ".Query(strSql.ToString(),parameters);"); strclass.AppendSpaceLine(3, "if(ds.Tables[0].Rows.Count>0)"); strclass.AppendSpaceLine(3, "{"); //�������� strclass.AppendSpaceLine(4, "#region ������Ϣ"); foreach (ColumnInfo field in FieldlistParent) { string columnName = field.ColumnName; string columnType = field.TypeName; strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"]!=null && ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); #region �ֶ����� switch (CodeCommon.DbTypeToCS(columnType)) { case "int": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "long": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=long.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "decimal": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "float": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=float.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "DateTime": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "string": { strclass.AppendSpaceLine(5, "model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();"); } break; case "bool": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "model." + columnName + "=true;"); strclass.AppendSpaceLine(5, "}"); strclass.AppendSpaceLine(5, "else"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "model." + columnName + "=false;"); strclass.AppendSpaceLine(5, "}"); //strclass.AppendSpaceLine(4, "}"); } break; case "byte[]": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"];"); //strclass.AppendSpaceLine(4, "}"); } break; case "Guid": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=new Guid(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; default: strclass.AppendSpaceLine(5, "//model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();"); break; } #endregion strclass.AppendSpaceLine(4, "}"); } strclass.AppendSpaceLine(4, "#endregion ������Ϣend"); strclass.AppendLine(); #region �ӱ����� strclass.AppendSpaceLine(4, "#region �ӱ���Ϣ"); strclass.AppendSpaceLine(4, "StringBuilder strSql2=new StringBuilder();"); strclass.AppendSpaceLine(4, "strSql2.Append(\"select " + FieldstrlistSon + " from " + _tablenameson + " \");"); strclass.AppendSpaceLine(4, "strSql2.Append(\" where " + CodeCommon.GetWhereParameterExpression(KeysSon, true, dbobj.DbType)+ "\");"); strclass.AppendLine(GetPreParameter(KeysParent, "2")); strclass.AppendSpaceLine(4, "DataSet ds2=" + DbHelperName + ".Query(strSql2.ToString(),parameters2);"); strclass.AppendSpaceLine(4, "if(ds2.Tables[0].Rows.Count>0)"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "#region �ӱ��ֶ���Ϣ"); strclass.AppendSpaceLine(5, "int i = ds2.Tables[0].Rows.Count;"); strclass.AppendSpaceLine(5, "List<" + ModelSpaceSon + "> models = new List<" + ModelSpaceSon + ">();"); strclass.AppendSpaceLine(5, ModelSpaceSon + " modelt;"); strclass.AppendSpaceLine(5, "for (int n = 0; n < i; n++)"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "modelt = new " + ModelSpaceSon + "();"); foreach (ColumnInfo field in FieldlistSon) { string columnName = field.ColumnName; string columnType = field.TypeName; strclass.AppendSpaceLine(6, "if(ds2.Tables[0].Rows[n][\"" + columnName + "\"]!=null && ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(6, "{"); #region �ֶ����� switch (CodeCommon.DbTypeToCS(columnType)) { case "int": { //strclass.AppendSpaceLine(6, "if(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(6, "{"); strclass.AppendSpaceLine(7, "modelt." + columnName + "=int.Parse(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(6, "}"); } break; case "decimal": { //strclass.AppendSpaceLine(6, "if(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(6, "{"); strclass.AppendSpaceLine(7, "modelt." + columnName + "=decimal.Parse(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(6, "}"); } break; case "DateTime": { //strclass.AppendSpaceLine(6, "if(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(6, "{"); strclass.AppendSpaceLine(7, "modelt." + columnName + "=DateTime.Parse(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(6, "}"); } break; case "string": { strclass.AppendSpaceLine(7, "modelt." + columnName + "=ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString();"); } break; case "bool": { //strclass.AppendSpaceLine(6, "if(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(6, "{"); strclass.AppendSpaceLine(7, "if((ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()==\"1\")||(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString().ToLower()==\"true\"))"); strclass.AppendSpaceLine(7, "{"); strclass.AppendSpaceLine(8, "modelt." + columnName + "=true;"); strclass.AppendSpaceLine(7, "}"); strclass.AppendSpaceLine(7, "else"); strclass.AppendSpaceLine(7, "{"); strclass.AppendSpaceLine(8, "modelt." + columnName + "=false;"); strclass.AppendSpaceLine(7, "}"); //strclass.AppendSpaceLine(6, "}"); } break; case "byte[]": { //strclass.AppendSpaceLine(6, "if(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(6, "{"); strclass.AppendSpaceLine(7, "modelt." + columnName + "=(byte[])ds2.Tables[0].Rows[n][\"" + columnName + "\"];"); //strclass.AppendSpaceLine(6, "}"); } break; case "Guid": { //strclass.AppendSpaceLine(6, "if(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(6, "{"); strclass.AppendSpaceLine(7, "modelt." + columnName + "=new Guid(ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(6, "}"); } break; default: strclass.AppendSpaceLine(7, "modelt." + columnName + "=ds2.Tables[0].Rows[n][\"" + columnName + "\"].ToString();"); break; } #endregion strclass.AppendSpaceLine(6, "}"); } strclass.AppendSpaceLine(6, "models.Add(modelt);"); strclass.AppendSpaceLine(5, "}"); strclass.AppendSpaceLine(5, "model." + ModelNameSon + "s = models;"); strclass.AppendSpaceLine(5, "#endregion �ӱ��ֶ���Ϣend"); strclass.AppendSpaceLine(4, "}"); strclass.AppendSpaceLine(4, "#endregion �ӱ���Ϣend"); #endregion strclass.AppendLine(); strclass.AppendSpaceLine(4, "return model;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return null;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(2, "}"); return strclass.ToString(); }
/// <summary> /// �õ�ij�ֶ����ֵ�ķ�������(ֻ��������int�͵����������) /// </summary> /// <param name="TabName"></param> /// <param name="ID"></param> /// <returns></returns> public string CreatGetMaxID() { StringPlus strclass = new StringPlus(); if (_keys.Count > 0) { string keyname = ""; foreach (ColumnInfo obj in _keys) { if (CodeCommon.DbTypeToCS(obj.TypeName) == "int") { keyname = obj.ColumnName; if (obj.IsPrimaryKey) { strclass.AppendLine(""); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetMaxId"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public int GetMaxId()"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(2, "return " + DbHelperName + ".GetMaxID(\"" + keyname + "\", \"" + _tablename + "\"); "); strclass.AppendSpaceLine(2, "}"); break; } } } } return strclass.ToString(); }
/// <summary> /// �õ�GetList()�Ĵ��� /// </summary> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <returns></returns> public string CreatGetList() { StringPlus strclass = new StringPlus(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public DataSet GetList(string strWhere)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpace(3, "strSql.Append(\"select "); strclass.AppendLine(Fieldstrlist + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" FROM " + TableName + " \");"); strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());"); strclass.AppendSpaceLine(2, "}"); if ((dbobj.DbType == "SQL2000") || (dbobj.DbType == "SQL2005") || (dbobj.DbType == "SQL2008") || (dbobj.DbType == "SQL2012")) { strclass.AppendLine(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList2"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public DataSet GetList(int Top,string strWhere,string filedOrder)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"select \");"); strclass.AppendSpaceLine(3, "if(Top>0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql.Append(\" top \"+Top.ToString());"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "strSql.Append(\" " + Fieldstrlist + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" FROM " + TableName + " \");"); strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "strSql.Append(\" order by \" + filedOrder);"); strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());"); strclass.AppendSpaceLine(2, "}"); } //����List<> strclass.AppendLine(); // ���峬 2015-10-13 strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public List<" + ModelSpace + "> GetModelList(string strWhere)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "DataSet ds = GetList(strWhere);"); strclass.AppendSpaceLine(3, "return DataTableToList(ds.Tables[0]);"); strclass.AppendSpaceLine(2, "}"); //����List<> strclass.AppendLine();// ���峬 2015-10-13 strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public List<" + ModelSpace + "> DataTableToList(DataTable dt)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "List<" + ModelSpace + "> modelList = new List<" + ModelSpace + ">();"); strclass.AppendSpaceLine(3, "int rowsCount = dt.Rows.Count;"); strclass.AppendSpaceLine(3, "if (rowsCount > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, ModelSpace + " model;"); strclass.AppendSpaceLine(4, "for (int n = 0; n < rowsCount; n++)"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model = DataRowToModel(dt.Rows[n]);"); strclass.AppendSpaceLine(5, "if (model != null)"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "modelList.Add(model);"); strclass.AppendSpaceLine(5, "}"); strclass.AppendSpaceLine(4, "}"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "return modelList;"); strclass.AppendSpaceLine(2, "}"); return strclass.Value; }
/// <summary> /// �õ�Exists�����Ĵ��� /// </summary> /// <param name="_tablename"></param> /// <param name="ID"></param> /// <returns></returns> public string CreatExists() { StringPlus strclass = new StringPlus(); if (_keys.Count > 0) { string strInparam = Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, false); if (!string.IsNullOrEmpty(strInparam)) { strclass.AppendLine(""); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryExists"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool Exists(" + strInparam + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"select count(1) from " + _tablename + "\");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + Maticsoft.CodeHelper.CodeCommon.GetWhereExpression(Keys, false) + "\");"); strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Exists(strSql.ToString());"); strclass.AppendSpace(2, "}"); } } return strclass.ToString(); }
/// <summary> /// �õ�Delete�Ĵ��� /// </summary> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <returns></returns> public string CreatDelete() { StringPlus strclass = new StringPlus(); strclass.AppendLine(""); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryDelete"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool Delete(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); //if (dbobj.DbType != "OleDb") //{ // strclass.AppendSpaceLine(3, "strSql.Append(\"delete " + _tablename + " \");" ); //} //else //{ strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablename + " \");"); //} strclass.AppendSpaceLine(3, "strSql.Append(\" where " + Maticsoft.CodeHelper.CodeCommon.GetWhereExpression(Keys, true) + "\" );"); strclass.AppendSpaceLine(3, "int rowsAffected=" + DbHelperName + ".ExecuteSql(strSql.ToString());"); strclass.AppendSpaceLine(3, "if (rowsAffected > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpace(2, "}"); #region �����������ȵ�ɾ��(���б�ʶ�ֶΣ����зDZ�ʶ�����ֶ�) if ((Maticsoft.CodeHelper.CodeCommon.HasNoIdentityKey(Keys)) && (Maticsoft.CodeHelper.CodeCommon.GetIdentityKey(Keys) != null)) { strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryDelete"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool Delete(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, false) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, KeysNullTip); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablename + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + GetWhereExpression(Keys, false) + "\");"); strclass.AppendLine(GetPreParameter(Keys, false)); strclass.AppendSpaceLine(3, "int rows=" + DbHelperName + ".ExecuteSql(strSql.ToString(),parameters);"); strclass.AppendSpaceLine(3, "if (rows > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(2, "}"); } #endregion #region ����ɾ������ string keyField = ""; if (Keys.Count == 1) { keyField = Keys[0].ColumnName; } else { foreach (ColumnInfo field in Keys) { if (field.IsIdentity) { keyField = field.ColumnName; break; } } } if (keyField.Trim().Length > 0) { strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryDeletelist"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool DeleteList(string " + keyField + "list )"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablename + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + keyField + " in (\"+" + keyField + "list + \") \");"); strclass.AppendSpaceLine(3, "int rows=" + DbHelperName + ".ExecuteSql(strSql.ToString());"); strclass.AppendSpaceLine(3, "if (rows > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(2, "}"); } #endregion return strclass.ToString(); }
/// <summary> /// DataRowToModel�Ĵ��� /// </summary> public string CreatDataRowToModel() { if (ModelSpace == "") { //ModelSpace = "ModelClassName"; ; } StringPlus strclass = new StringPlus(); strclass.AppendLine(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetModel"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public " + ModelSpace + " DataRowToModel(DataRow row)"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "" + ModelSpace + " model=new " + ModelSpace + "();"); strclass.AppendSpaceLine(3, "if (row != null)"); strclass.AppendSpaceLine(3, "{"); #region �ֶθ�ֵ foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; //strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); #region switch (CodeCommon.DbTypeToCS(columnType)) { case "int": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=int.Parse(row[\"" + columnName + "\"].ToString());"); strclass.AppendSpaceLine(4, "}"); } break; case "long": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=long.Parse(row[\"" + columnName + "\"].ToString());"); strclass.AppendSpaceLine(4, "}"); } break; case "decimal": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=decimal.Parse(row[\"" + columnName + "\"].ToString());"); strclass.AppendSpaceLine(4, "}"); } break; case "float": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=float.Parse(row[\"" + columnName + "\"].ToString());"); strclass.AppendSpaceLine(4, "}"); } break; case "DateTime": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=DateTime.Parse(row[\"" + columnName + "\"].ToString());"); strclass.AppendSpaceLine(4, "}"); } break; case "string": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null)"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=row[\"" + columnName + "\"].ToString();"); strclass.AppendSpaceLine(4, "}"); } break; case "bool": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "if((row[\"" + columnName + "\"].ToString()==\"1\")||(row[\"" + columnName + "\"].ToString().ToLower()==\"true\"))"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "model." + columnName + "=true;"); strclass.AppendSpaceLine(5, "}"); strclass.AppendSpaceLine(5, "else"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "model." + columnName + "=false;"); strclass.AppendSpaceLine(5, "}"); strclass.AppendSpaceLine(4, "}"); } break; case "byte[]": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=(byte[])row[\"" + columnName + "\"];"); strclass.AppendSpaceLine(4, "}"); } break; case "uniqueidentifier": case "Guid": { strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "= new Guid(row[\"" + columnName + "\"].ToString());"); strclass.AppendSpaceLine(4, "}"); } break; default: strclass.AppendSpaceLine(5, "//model." + columnName + "=row[\"" + columnName + "\"].ToString();"); break; } #endregion //strclass.AppendSpaceLine(4, "}"); } #endregion strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "return model;"); strclass.AppendSpaceLine(2, "}"); return strclass.ToString(); }
/// <summary> /// �õ���ʾ���б����Ĵ��� /// </summary> public string GetListAspxCs() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); strclass.AppendSpace(2, BLLSpace + " bll = new " + BLLSpace + "();"); return strclass.ToString(); }
/// <summary> /// �õ���ʾ����ʾ�����html���� /// </summary> public string GetShowAspx() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); strclass.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">"); foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName); strclass.AppendSpaceLine(1, "<tr>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">"); strclass.AppendSpaceLine(2, deText); strclass.AppendSpaceLine(1, "��</td>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">"); switch (columnType.Trim().ToLower()) { //case "bit": // strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />" ); // break; default: strclass.AppendSpaceLine(2, "<asp:Label id=\"lbl" + columnName + "\" runat=\"server\"></asp:Label>"); break; } strclass.AppendSpaceLine(1, "</td></tr>"); } strclass.AppendLine("</table>"); return strclass.ToString(); }
/// <summary> /// ���ɱ�ʾ��ҳ���CS���� /// </summary> /// <param name="ExistsKey"></param> /// <param name="AddForm">�Ƿ��������Ӵ���Ĵ���</param> /// <param name="UpdateForm">�Ƿ������Ĵ���Ĵ���</param> /// <param name="ShowForm">�Ƿ�������ʾ����Ĵ���</param> /// <param name="SearchForm">�Ƿ����ɲ�ѯ����Ĵ���</param> /// <returns></returns> public string GetWebCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm) { StringPlus strclass = new StringPlus(); if (AddForm) { strclass.AppendLine(" /******************************���Ӵ������********************************/"); strclass.AppendLine(GetAddAspxCs()); } if (UpdateForm) { strclass.AppendLine(" /******************************�Ĵ������********************************/"); strclass.AppendLine(" /*�Ĵ���-��ʾ */"); strclass.AppendLine(GetUpdateShowAspxCs()); strclass.AppendLine(" /*�Ĵ���-�ύ���� */"); strclass.AppendLine(GetUpdateAspxCs()); } if (ShowForm) { strclass.AppendLine(" /******************************��ʾ�������********************************/"); strclass.AppendLine(GetShowAspxCs()); } //if (DelForm) //{ // strclass.Append(" /******************************ɾ���������********************************/"); // strclass.Append(""); // strclass.Append(CreatDeleteForm()); //} return strclass.Value; }
/// <summary> /// �õ���ʾ�����Ӵ����html���� /// </summary> public string GetUpdateAspx() { StringPlus strclass = new StringPlus(); strclass.AppendLine(""); strclass.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">"); bool hasDate = false; foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName); if (isFilterColume(columnName)) { continue; } if ((ispk) || (IsIdentity) || (columnType.Trim().ToLower() == "uniqueidentifier")) { strclass.AppendSpaceLine(1, "<tr>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">"); strclass.AppendSpaceLine(2, deText); strclass.AppendSpaceLine(1, "��</td>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">"); strclass.AppendSpaceLine(2, "<asp:label id=\"lbl" + columnName + "\" runat=\"server\"></asp:label>"); strclass.AppendSpaceLine(1, "</td></tr>"); } else { // strclass.AppendSpaceLine(1, "<tr>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">"); strclass.AppendSpaceLine(2, deText); strclass.AppendSpaceLine(1, "��</td>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">"); switch (columnType.Trim().ToLower()) { case "datetime": case "smalldatetime": //strclass.AppendSpaceLine(2, "<INPUT onselectstart=\"return false;\" onkeypress=\"return false\" id=\"txt" + columnName + "\" onfocus=\"setday(this)\""); //strclass.AppendSpaceLine(2, " readOnly type=\"text\" size=\"10\" name=\"Text1\" runat=\"server\">"); strclass.AppendSpaceLine(2, "<asp:TextBox ID=\"txt" + columnName + "\" runat=\"server\" Width=\"70px\" onfocus=\"setday(this)\"></asp:TextBox>"); hasDate = true; break; case "bit": strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />"); break; default: strclass.AppendSpaceLine(2, "<asp:TextBox id=\"txt" + columnName + "\" runat=\"server\" Width=\"200px\"></asp:TextBox>"); break; } strclass.AppendSpaceLine(1, "</td></tr>"); } } ////��ť //strclass.AppendSpaceLine(1, "<tr>"); //strclass.AppendSpaceLine(1, "<td height=\"25\" colspan=\"2\"><div align=\"center\">"); //strclass.AppendSpaceLine(2, "<asp:Button ID=\"btnSave\" runat=\"server\" Text=\"�� ���� ��\" OnClick=\"btnSave_Click\" ></asp:Button>"); ////strclass.AppendSpaceLine(2, "<asp:Button ID=\"btnCancel\" runat=\"server\" Text=\"�� ȡ�� ��\" OnClick=\"btnCancel_Click\" ></asp:Button>"); //strclass.AppendSpaceLine(1, "</div></td></tr>"); strclass.AppendLine("</table>"); if (hasDate) { strclass.AppendLine("<script src=\"/js/calendar1.js\" type=\"text/javascript\"></script>"); } return strclass.Value; }
/// <summary> /// �õ�Delete�Ĵ��� /// </summary> public string CreatDelete() { StringPlus strclass = new StringPlus(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// ɾ��һ�����ݣ����ӱ������������"); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool Delete(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(KeysParent, true) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "List<CommandInfo> sqllist = new List<CommandInfo>();"); //�� strclass.AppendSpaceLine(3, "StringBuilder strSql2=new StringBuilder();"); if (dbobj.DbType != "OleDb") { strclass.AppendSpaceLine(3, "strSql2.Append(\"delete " + _tablenameson + " \");"); } else { strclass.AppendSpaceLine(3, "strSql2.Append(\"delete from " + _tablenameson + " \");"); } strclass.AppendSpaceLine(3, "strSql2.Append(\" where " + CodeCommon.GetWhereParameterExpression(KeysSon, true, dbobj.DbType) + "\");"); strclass.AppendLine(GetPreParameter(KeysSon, "2")); strclass.AppendSpaceLine(3, "CommandInfo cmd = new CommandInfo(strSql2.ToString(), parameters2);"); strclass.AppendSpaceLine(3, "sqllist.Add(cmd);"); //�� strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); if (dbobj.DbType != "OleDb") { strclass.AppendSpaceLine(3, "strSql.Append(\"delete " + _tablenameparent + " \");"); } else { strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablenameparent + " \");"); } strclass.AppendSpaceLine(3, "strSql.Append(\" where " + CodeCommon.GetWhereParameterExpression(KeysParent, true, dbobj.DbType) + "\");"); strclass.AppendLine(CodeCommon.GetPreParameter(KeysParent, true, dbobj.DbType)); strclass.AppendSpaceLine(3, "cmd = new CommandInfo(strSql.ToString(), parameters);"); strclass.AppendSpaceLine(3, "sqllist.Add(cmd);"); strclass.AppendSpaceLine(3, "int rowsAffected=" + DbHelperName + ".ExecuteSqlTran(sqllist);"); strclass.AppendSpaceLine(3, "if (rowsAffected > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(2, "}"); #region ����ɾ������ string keyField = ""; if (KeysParent.Count == 1) { keyField = KeysParent[0].ColumnName; } else { foreach (ColumnInfo field in KeysParent) { if (field.IsIdentity) { keyField = field.ColumnName; break; } } } if (keyField.Trim().Length > 0) { strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryDelete"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public bool DeleteList(string " + keyField + "list )"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "List<string> sqllist = new List<string>();"); strclass.AppendSpaceLine(3, "StringBuilder strSql2=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql2.Append(\"delete from " + _tablenameson + " \");"); strclass.AppendSpaceLine(3, "strSql2.Append(\" where " + KeysSon[0].ColumnName + " in (\"+" + keyField + "list + \") \");"); strclass.AppendSpaceLine(3, "sqllist.Add(strSql2.ToString());"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablenameparent + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + keyField + " in (\"+" + keyField + "list + \") \");"); strclass.AppendSpaceLine(3, "sqllist.Add(strSql.ToString());"); strclass.AppendSpaceLine(3, "int rowsAffected=" + DbHelperName + ".ExecuteSqlTran(sqllist);"); strclass.AppendSpaceLine(3, "if (rowsAffected > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(2, "}"); } #endregion return strclass.Value; }
/// <summary> /// �õ��Ĵ���Ĵ��� /// </summary> public string GetUpdateShowAspxCs() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); string key = Key; strclass.AppendSpaceLine(1, "private void ShowInfo(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")"); strclass.AppendSpaceLine(1, "{"); strclass.AppendSpaceLine(2, BLLSpace + " bll=new " + BLLSpace + "();"); strclass.AppendSpaceLine(2, ModelSpace + " model=bll.GetModel(" + Maticsoft.CodeHelper.CodeCommon.GetFieldstrlist(Keys, true) + ");"); foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; if (isFilterColume(columnName)) { continue; } //���Զ���-�����ֶδ��� //if ((columnName.IndexOf("_cLang") > 0) && (columnType.Trim().ToLower() == "varchar")) //{ // strclass.AppendSpaceLine(2, "UCDroplistLanguage1.LanguageCode =model." + columnName + ";"); // continue; //} //if (columnName.IndexOf("_iAuthority") > 0) //{ // strclass.AppendSpaceLine(2, "UCDroplistPermission1.PermissionID =model." + columnName + ";"); // continue; //} //if (columnName.IndexOf("_cCurrency") > 0)//���Ҵ��� //{ // strclass.AppendSpaceLine(2, "UCDroplistCurrency1.CurrencyCode =model." + columnName + ";"); // continue; //} //if (columnName.IndexOf("_cCurrencyUnit") > 0)//���Ҵ��� //{ // strclass.AppendSpaceLine(2, "UCDroplistCurrencyUnit1.CurrencyUnitID =model." + columnName + ";"); // continue; //} switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower()) { case "int": case "long": case "smallint": case "float": case "numeric": case "decimal": case "datetime": case "smalldatetime": if ((ispk) || (IsIdentity)) { strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();"); } else { strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ".ToString();"); } break; case "bool": strclass.AppendSpaceLine(2, "this.chk" + columnName + ".Checked=model." + columnName + ";"); break; case "byte[]": strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ".ToString();"); break; case "guid": case "uniqueidentifier": strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();"); break; default: if ((ispk) || (IsIdentity)) { strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ";"); } else { strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ";"); } break; } } strclass.AppendLine(); strclass.AppendSpaceLine(1, "}"); return strclass.Value; }
///// <summary> ///// �õ�Where������� - Parameter��ʽ (���磺����Exists Delete GetModel ��where) ///// </summary> ///// <param name="keys"></param> ///// <returns></returns> //public string GetWhereExpression(List<ColumnInfo> keys) //{ // StringPlus strclass = new StringPlus(); // foreach (ColumnInfo key in keys) // { // strclass.Append(key.ColumnName + "=" + preParameter + key.ColumnName + " and "); // } // strclass.DelLastChar("and"); // return strclass.Value; //} ///// <summary> ///// ����sql����еIJ����б�(���磺����Add Exists Update Delete GetModel �IJ�������) ///// </summary> ///// <param name="keys"></param> ///// <returns></returns> //public string GetPreParameter(List<ColumnInfo> keys) //{ // StringPlus strclass = new StringPlus(); // StringPlus strclass2 = new StringPlus(); // strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {"); // int n = 0; // foreach (ColumnInfo key in keys) // { // strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "" + key.ColumnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, key.TypeName, "") + "),"); // strclass2.AppendSpaceLine(3, "parameters[" + n.ToString() + "].Value = " + key.ColumnName + ";"); // n++; // } // strclass.DelLastComma(); // strclass.AppendLine("};"); // strclass.Append(strclass2.Value); // return strclass.Value; //} /// <summary> /// ����sql����еIJ����б�(���磺����Add Exists Update Delete GetModel �IJ�������) /// </summary> /// <param name="keys"></param> /// <returns></returns> public string GetPreParameter(List<ColumnInfo> keys, string numPara) { StringPlus strclass = new StringPlus(); StringPlus strclass2 = new StringPlus(); strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters" + numPara + " = {"); int n = 0; foreach (ColumnInfo key in keys) { strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "" + key.ColumnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, key.TypeName, "") + "),"); strclass2.AppendSpaceLine(3, "parameters" + numPara + "[" + n.ToString() + "].Value = " + key.ColumnName + ";"); n++; } strclass.DelLastComma(); strclass.AppendLine("};"); strclass.Append(strclass2.Value); return strclass.Value; }
/// <summary> /// ��ɾ��3��ҳ����� /// </summary> public string GetWebHtmlCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm) { StringPlus strclass = new StringPlus(); if (AddForm) { strclass.AppendLine(" <!--******************************����ҳ�����********************************-->"); strclass.AppendLine(GetAddAspx()); } if (UpdateForm) { strclass.AppendLine(" <!--******************************��ҳ�����********************************-->"); strclass.AppendLine(GetUpdateAspx()); } if (ShowForm) { strclass.AppendLine(" <!--******************************��ʾҳ�����********************************-->"); strclass.AppendLine(GetShowAspx()); } if (SearchForm) { strclass.AppendLine(" <!--******************************�б�ҳ�����********************************-->"); strclass.AppendLine(GetListAspx()); } return strclass.ToString(); }
public string GetDALCode(bool Maxid, bool Exists, bool Add, bool Update, bool Delete, bool GetModel, bool List) { StringPlus strclass = new StringPlus(); strclass.AppendLine("using System;"); strclass.AppendLine("using System.Data;"); strclass.AppendLine("using System.Text;"); strclass.AppendLine("using System.Collections.Generic;"); switch (dbobj.DbType) { case "SQL2005": case "SQL2008": case "SQL2012": strclass.AppendLine("using System.Data.SqlClient;"); break; case "SQL2000": strclass.AppendLine("using System.Data.SqlClient;"); break; case "Oracle": strclass.AppendLine("using System.Data.OracleClient;"); break; case "MySQL": strclass.AppendLine("using MySql.Data.MySqlClient;"); break; case "OleDb": strclass.AppendLine("using System.Data.OleDb;"); break; case "SQLite": strclass.AppendLine("using System.Data.SQLite;"); break; } if (IDALpath != "") { strclass.AppendLine("using " + IDALpath + ";"); } // strclass.AppendLine("using Maticsoft.DBUtility;//Please add references"); // ���峬 2014-10-21 ��Ϊ����Ŀ���ݿ���� strclass.AppendLine("using " + NameSpace + ".DBUtility;"); strclass.AppendLine("namespace " + DALpath); strclass.AppendLine("{"); strclass.AppendSpaceLine(1, "/// <summary>"); strclass.AppendSpaceLine(1, "/// " + Languagelist["summary"].ToString() + ":" + DALName); strclass.AppendSpaceLine(1, "/// </summary>"); strclass.AppendSpace(1, "public partial class " + DALName); if (IClass != "") { strclass.Append(":" + IClass); } strclass.AppendLine(""); strclass.AppendSpaceLine(1, "{"); strclass.AppendSpaceLine(2, "public " + DALName + "()"); strclass.AppendSpaceLine(2, "{}"); strclass.AppendSpaceLine(2, "#region Method"); #region �������� if (Maxid) { strclass.AppendLine(CreatGetMaxID()); } if (Exists) { strclass.AppendLine(CreatExists()); } if (Add) { strclass.AppendLine(CreatAdd()); } if (Update) { strclass.AppendLine(CreatUpdate()); } if (Delete) { strclass.AppendLine(CreatDelete()); } if (GetModel) { strclass.AppendLine(CreatGetModel()); strclass.AppendLine(CreatDataRowToModel()); } if (List) { strclass.AppendLine(CreatGetList()); strclass.AppendLine(CreatGetListByPage()); strclass.AppendLine(CreatGetListByPageProc()); } #endregion strclass.AppendSpaceLine(2, "#endregion Method"); //strclass.AppendSpaceLine(2, "#region MethodEx"); //strclass.AppendLine(""); //strclass.AppendSpaceLine(2, "#endregion MethodEx"); strclass.AppendSpaceLine(1, "}"); strclass.AppendLine("}"); strclass.AppendLine(""); return strclass.ToString(); }
/// <summary> /// �õ�Add()�Ĵ��� /// </summary> public string CreatAdd() { StringPlus strclass = new StringPlus(); StringPlus strclass1 = new StringPlus(); StringPlus strclass2 = new StringPlus(); StringPlus strclass3 = new StringPlus(); StringPlus strclass4 = new StringPlus(); strclass.AppendLine(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// ����һ������,�����ӱ�����"); strclass.AppendSpaceLine(2, "/// </summary>"); string strretu = "void"; if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012") && (IsHasIdentity)) { strretu = "int"; } //��������ͷ string strFun = CodeCommon.Space(2) + "public " + strretu + " Add(" + ModelSpaceParent + " model)"; strclass.AppendLine(strFun); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "strSql.Append(\"insert into " + _tablenameparent + "(\");"); strclass1.AppendSpace(3, "strSql.Append(\""); int n = 0; int nkey = 0; foreach (ColumnInfo field in FieldlistParent) { string columnName = field.ColumnName; string columnType = field.TypeName; bool IsIdentity = field.IsIdentity; string Length = field.Length; if (field.IsIdentity) { //nkey = n; continue; } strclass3.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + columnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, columnType, Length) + "),"); strclass1.Append(columnName + ","); strclass2.Append(preParameter + columnName + ","); strclass4.AppendSpaceLine(3, "parameters[" + n + "].Value = model." + columnName + ";"); n++; } if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012") && (IsHasIdentity)) { nkey = n; strclass3.AppendSpaceLine(5, "new SqlParameter(\"@ReturnValue\",SqlDbType.Int),"); strclass4.AppendSpaceLine(3, "parameters[" + nkey.ToString() + "].Direction = ParameterDirection.Output;"); } //ȥ�����Ķ��� strclass1.DelLastComma(); strclass2.DelLastComma(); strclass3.DelLastComma(); strclass1.AppendLine(")\");"); strclass.Append(strclass1.ToString()); strclass.AppendSpaceLine(3, "strSql.Append(\" values (\");"); strclass.AppendSpaceLine(3, "strSql.Append(\"" + strclass2.ToString() + ")\");"); if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012") && (IsHasIdentity)) { strclass.AppendSpaceLine(3, "strSql.Append(\";set @ReturnValue= @@IDENTITY\");"); } strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {"); strclass.Append(strclass3.Value); strclass.AppendLine("};"); strclass.AppendLine(strclass4.Value); #region tran strclass.AppendSpaceLine(3, "List<CommandInfo> sqllist = new List<CommandInfo>();"); strclass.AppendSpaceLine(3, "CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);"); strclass.AppendSpaceLine(3, "sqllist.Add(cmd);"); strclass.AppendSpaceLine(3, "StringBuilder strSql2;"); strclass.AppendSpaceLine(3, "foreach (" + ModelSpaceSon + " models in model." + ModelNameSon + "s)"); strclass.AppendSpaceLine(3, "{"); StringPlus strclass11 = new StringPlus(); StringPlus strclass21 = new StringPlus(); StringPlus strclass31 = new StringPlus(); StringPlus strclass41 = new StringPlus(); //�µ����� strclass.AppendSpaceLine(4, "strSql2=new StringBuilder();"); strclass.AppendSpaceLine(4, "strSql2.Append(\"insert into " + _tablenameson + "(\");"); strclass11.AppendSpace(4, "strSql2.Append(\""); int ns = 0; foreach (ColumnInfo field in FieldlistSon) { string columnName = field.ColumnName; string columnType = field.TypeName; bool IsIdentity = field.IsIdentity; string Length = field.Length; if (field.IsIdentity) { continue; } strclass31.AppendSpaceLine(6, "new " + DbParaHead + "Parameter(\"" + preParameter + columnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, columnType, Length) + "),"); strclass11.Append(columnName + ","); strclass21.Append(preParameter + columnName + ","); strclass41.AppendSpaceLine(4, "parameters2[" + ns + "].Value = models." + columnName + ";"); ns++; } strclass11.DelLastComma(); strclass21.DelLastComma(); strclass31.DelLastComma(); strclass11.AppendLine(")\");"); strclass.Append(strclass11.ToString()); strclass.AppendSpaceLine(4, "strSql2.Append(\" values (\");"); strclass.AppendSpaceLine(4, "strSql2.Append(\"" + strclass21.ToString() + ")\");"); //if (IsHasIdentity) //{ // strclass.AppendSpaceLine(4, "strSql2.Append(\";select @@IDENTITY\");"); //} strclass.AppendSpaceLine(4, "" + DbParaHead + "Parameter[] parameters2 = {"); strclass.Append(strclass31.Value); strclass.AppendLine("};"); strclass.AppendLine(strclass41.Value); //end�µ����� strclass.AppendSpaceLine(4, "cmd = new CommandInfo(strSql2.ToString(), parameters2);"); strclass.AppendSpaceLine(4, "sqllist.Add(cmd);"); strclass.AppendSpaceLine(3, "}"); #endregion //���¶��巽��ͷ if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012") && (IsHasIdentity)) { strclass.AppendSpaceLine(3, DbHelperName + ".ExecuteSqlTranWithIndentity(sqllist);"); strclass.AppendSpaceLine(3, "return (" + _keyType + ")parameters[" + nkey + "].Value;"); } else { strclass.AppendSpaceLine(3, "" + DbHelperName + ".ExecuteSqlTran(sqllist);"); } strclass.AppendSpace(2, "}"); return strclass.ToString(); }
/// <summary> /// �õ���ʾ�����Ӵ����html���� /// </summary> public string GetAddAspx() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); strclass.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">"); bool hasDate = false; foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; if (IsIdentity) { continue; } if (isFilterColume(columnName)) { continue; } if (columnType.Trim().ToLower() == "uniqueidentifier") { continue; } deText = CodeHelper.CodeCommon.CutDescText(deText, 15, columnName); strclass.AppendSpaceLine(1, "<tr>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">"); strclass.AppendSpaceLine(2, deText); strclass.AppendSpaceLine(1, "��</td>"); strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">"); switch (columnType.Trim().ToLower()) { case "datetime": case "smalldatetime": strclass.AppendSpaceLine(2, "<asp:TextBox ID=\"txt" + columnName + "\" runat=\"server\" Width=\"70px\" onfocus=\"setday(this)\"></asp:TextBox>"); hasDate = true; break; case "bit": strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />"); break; case "uniqueidentifier": break; default: strclass.AppendSpaceLine(2, "<asp:TextBox id=\"txt" + columnName + "\" runat=\"server\" Width=\"200px\"></asp:TextBox>"); break; } strclass.AppendSpaceLine(1, "</td></tr>"); } strclass.AppendLine("</table>"); if (hasDate) { strclass.AppendLine("<script src=\"/js/calendar1.js\" type=\"text/javascript\"></script>"); } return strclass.ToString(); }
/// <summary> /// �õ���ʾ�����Ӵ���Ĵ��� /// </summary> public string GetAddAspxCs() { StringPlus strclass = new StringPlus(); StringPlus strclass0 = new StringPlus(); StringPlus strclass1 = new StringPlus(); StringPlus strclass2 = new StringPlus(); strclass.AppendLine(); strclass.AppendSpaceLine(3, "string strErr=\"\";"); //bool ishasuser = false; foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; if ((IsIdentity)) { continue; } if ("uniqueidentifier" == columnType.ToLower()) { continue; } //���Զ���-�����ֶδ��� //if ((!ishasuser) && ((columnName.IndexOf("_iCreator") > 0) || (columnName.IndexOf("_iMaintainer") > 0))) //{ // strclass0.AppendSpaceLine(3, "User currentUser;"); // strclass0.AppendSpaceLine(3, "if (Session[\"UserInfo\"] != null)"); // strclass0.AppendSpaceLine(3, "{"); // strclass0.AppendSpaceLine(4, "currentUser = (User)Session[\"UserInfo\"];"); // strclass0.AppendSpaceLine(3, "}else{"); // strclass0.AppendSpaceLine(4, "return;"); // strclass0.AppendSpaceLine(3, "}"); // ishasuser = true; //} deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName); switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower()) { case "int": case "smallint": strclass0.AppendSpaceLine(3, "int " + columnName + "=int.Parse(this.txt" + columnName + ".Text);"); strclass1.AppendSpaceLine(3, "if(!PageValidate.IsNumber(txt" + columnName + ".Text))"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); break; case "float": case "numeric": case "decimal": strclass0.AppendSpaceLine(3, "decimal " + columnName + "=decimal.Parse(this.txt" + columnName + ".Text);"); strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDecimal(txt" + columnName + ".Text))"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); break; case "datetime": case "smalldatetime": strclass0.AppendSpaceLine(3, "DateTime " + columnName + "=DateTime.Parse(this.txt" + columnName + ".Text);"); strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDateTime(txt" + columnName + ".Text))"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); break; case "bool": strclass0.AppendSpaceLine(3, "bool " + columnName + "=this.chk" + columnName + ".Checked;"); break; case "byte[]": strclass0.AppendSpaceLine(3, "byte[] " + columnName + "= new UnicodeEncoding().GetBytes(this.txt" + columnName + ".Text);"); break; case "guid": case "uniqueidentifier": break; default: strclass0.AppendSpaceLine(3, "string " + columnName + "=this.txt" + columnName + ".Text;"); strclass1.AppendSpaceLine(3, "if(this.txt" + columnName + ".Text.Trim().Length==0)"); strclass1.AppendSpaceLine(3, "{"); strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "����Ϊ�գ�\\\\n\"; "); strclass1.AppendSpaceLine(3, "}"); break; } strclass2.AppendSpaceLine(3, "model." + columnName + "=" + columnName + ";"); } strclass.AppendLine(strclass1.ToString()); strclass.AppendSpaceLine(3, "if(strErr!=\"\")"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "MessageBox.Show(this,strErr);"); strclass.AppendSpaceLine(4, "return;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendLine(strclass0.ToString()); strclass.AppendSpaceLine(3, ModelSpace + " model=new " + ModelSpace + "();"); strclass.AppendLine(strclass2.ToString()); strclass.AppendSpaceLine(3, BLLSpace + " bll=new " + BLLSpace + "();"); strclass.AppendSpaceLine(3, "bll.Add(model);"); strclass.AppendSpaceLine(3, NameSpace + ".Common.MessageBox.ShowAndRedirect(this,\"����ɹ���\",\"add.aspx\");"); return strclass.Value; }
/// <summary> /// ���Ӵ����html���� /// </summary> public string GetAddDesigner() { StringPlus strclass = new StringPlus(); strclass.AppendLine(); foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; string deText = field.Description; bool ispk = field.IsPrimaryKey; bool IsIdentity = field.IsIdentity; if (IsIdentity) { continue; } if (isFilterColume(columnName)) { continue; } if ("uniqueidentifier" == columnType.ToLower()) { continue; } switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower()) { case "datetime": case "smalldatetime": strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.TextBox txt" + columnName + ";"); break; case "bool": strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.CheckBox chk" + columnName + ";"); break; default: strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.TextBox txt" + columnName + ";"); break; } } //��ť strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Button btnSave;"); strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Button btnCancel;"); return strclass.ToString(); }
/// <summary> /// ����sql����еIJ����б�(���磺���� Exists Delete GetModel ��where������ֵ) /// </summary> /// <param name="keys"></param> /// <returns></returns> public string GetPreParameter(List<ColumnInfo> keys, bool IdentityisPrior) { StringPlus strclass = new StringPlus(); StringPlus strclass2 = new StringPlus(); strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {"); ColumnInfo field = Maticsoft.CodeHelper.CodeCommon.GetIdentityKey(keys); if ((IdentityisPrior) && (field != null)) //�б�ʶ�ֶ� { strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "" + field.ColumnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, field.TypeName, "") + ")"); strclass2.AppendSpaceLine(3, "parameters[0].Value = " + field.ColumnName + ";"); } else { int n = 0; foreach (ColumnInfo key in keys) { if (key.IsPrimaryKey) { strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "" + key.ColumnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, key.TypeName, "") + "),"); strclass2.AppendSpaceLine(3, "parameters[" + n.ToString() + "].Value = " + key.ColumnName + ";"); n++; } } strclass.DelLastComma(); } strclass.AppendLine("};"); strclass.Append(strclass2.Value); return strclass.Value; }
/// <summary> /// �õ�GetModel()�Ĵ��� /// </summary> /// <param name="DbName"></param> /// <param name="_tablename"></param> /// <param name="_key"></param> /// <param name="ModelName"></param> /// <returns></returns> public string CreatGetModel() { if (ModelSpace == "") { //ModelSpace = "ModelClassName"; ; } StringPlus strclass = new StringPlus(); strclass.AppendLine(); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetModel"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); strclass.AppendSpaceLine(2, "public " + ModelSpace + " GetModel(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")"); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpace(3, "strSql.Append(\"select "); if (dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012") { strclass.Append(" top 1 "); } strclass.AppendLine(" \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" " + Fieldstrlist + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" from " + _tablename + " \");"); strclass.AppendSpaceLine(3, "strSql.Append(\" where " + Maticsoft.CodeHelper.CodeCommon.GetWhereExpression(Keys, true) + "\" );"); strclass.AppendSpaceLine(3, ModelSpace + " model=new " + ModelSpace + "();"); strclass.AppendSpaceLine(3, "DataSet ds=" + DbHelperName + ".Query(strSql.ToString());"); strclass.AppendSpaceLine(3, "if(ds.Tables[0].Rows.Count>0)"); strclass.AppendSpaceLine(3, "{"); #region /* foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"]!=null && ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); strclass.AppendSpaceLine(4, "{"); #region switch (CodeCommon.DbTypeToCS(columnType)) { case "int": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "long": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=long.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "decimal": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "float": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=float.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "DateTime": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; case "string": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"]!=null)"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();"); //strclass.AppendSpaceLine(4, "}"); } break; case "bool": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "model." + columnName + "=true;"); strclass.AppendSpaceLine(5, "}"); strclass.AppendSpaceLine(5, "else"); strclass.AppendSpaceLine(5, "{"); strclass.AppendSpaceLine(6, "model." + columnName + "=false;"); strclass.AppendSpaceLine(5, "}"); //strclass.AppendSpaceLine(4, "}"); } break; case "byte[]": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"];"); //strclass.AppendSpaceLine(4, "}"); } break; case "uniqueidentifier": case "Guid": { //strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")"); //strclass.AppendSpaceLine(4, "{"); strclass.AppendSpaceLine(5, "model." + columnName + "=new Guid(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());"); //strclass.AppendSpaceLine(4, "}"); } break; default: strclass.AppendSpaceLine(5, "//model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();"); break; } #endregion strclass.AppendSpaceLine(4, "}"); } */ #endregion strclass.AppendSpaceLine(4, "return DataRowToModel(ds.Tables[0].Rows[0]);"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return null;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpace(2, "}"); return strclass.ToString(); }
public string Builder() { Columns = DbToCS.DbtoCSColumns(Columns); StringPlus plus = new StringPlus(); plus.AppendLine("//------------------------------------------------------------------------------"); plus.AppendLine("// <auto-generated>"); plus.AppendLine("// 此代码由工具生成。"); plus.AppendLine("// 运行时版本:" + Environment.Version.ToString()); plus.AppendLine("// Support: http://www.cnblogs.com/huxj"); plus.AppendLine("// Website: http://ITdos.com/Dos/ORM/Index.html"); plus.AppendLine("// 对此文件的更改可能会导致不正确的行为,并且如果"); plus.AppendLine("// 重新生成代码,这些更改将会丢失。"); plus.AppendLine("// </auto-generated>"); plus.AppendLine("//------------------------------------------------------------------------------"); plus.AppendLine(); plus.AppendLine(); plus.AppendLine("using System;"); plus.AppendLine("using System.Data;"); plus.AppendLine("using System.Data.Common;"); plus.AppendLine("using Dos.ORM;"); plus.AppendLine("using Dos.ORM.Common;"); plus.AppendLine(); plus.AppendLine("namespace " + NameSpace); plus.AppendLine("{"); plus.AppendLine(); plus.AppendSpaceLine(1, "/// <summary>"); plus.AppendSpaceLine(1, "/// 实体类" + ClassName + " 。(属性说明自动提取数据库字段的描述信息)"); plus.AppendSpaceLine(1, "/// </summary>"); plus.AppendSpaceLine(1, "[Serializable]"); plus.AppendSpaceLine(1, "public partial class " + ClassName + " : Entity "); plus.AppendSpaceLine(1, "{"); plus.AppendSpaceLine(2, "public " + ClassName + "():base(\"" + TableName + "\") {}"); plus.AppendLine(); plus.AppendLine(BuilderModel()); plus.AppendLine(BuilderMethod()); plus.AppendSpaceLine(1, "}"); plus.AppendLine("}"); plus.AppendLine(""); return plus.ToString(); }
/// <summary> /// �õ�Add()�Ĵ��� /// </summary> public string CreatAdd() { if (ModelSpace == "") { //ModelSpace = "ModelClassName"; ; } StringPlus strclass = new StringPlus(); strclass.AppendLine(""); strclass.AppendSpaceLine(2, "/// <summary>"); strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryadd"].ToString()); strclass.AppendSpaceLine(2, "/// </summary>"); string strretu = "bool"; if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012" || dbobj.DbType == "SQLite") && (IsHasIdentity)) { strretu = "int"; if (_IdentityKeyType != "int") { strretu = _IdentityKeyType; } } //if (dbobj.DbType == "OleDb" && IsHasIdentity) //{ // strretu = "bool"; //} //��������ͷ string strFun = CodeCommon.Space(2) + "public " + strretu + " Add(" + ModelSpace + " model)"; strclass.AppendLine(strFun); strclass.AppendSpaceLine(2, "{"); strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();"); strclass.AppendSpaceLine(3, "StringBuilder strSql1=new StringBuilder();"); strclass.AppendSpaceLine(3, "StringBuilder strSql2=new StringBuilder();"); foreach (ColumnInfo field in Fieldlist) { string columnName = field.ColumnName; string columnType = field.TypeName; bool IsIdentity = field.IsIdentity; if (IsIdentity) { continue; } strclass.AppendSpaceLine(3, "if (model." + columnName + " != null)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "strSql1.Append(\"" + columnName + ",\");"); if ((dbobj.DbType == "Oracle") && (columnType.ToLower() == "date" || columnType.ToLower() == "datetime")) { strclass.AppendSpaceLine(4, "strSql2.Append(\"to_date('\" + model." + columnName + ".ToString() + \"','YYYY-MM-DD HH24:MI:SS'),\");"); } else if (columnType.ToLower() == "bit") { strclass.AppendSpaceLine(4, "strSql2.Append(\"\"+(model." + columnName + "? 1 : 0) +\",\");"); } else if ("uniqueidentifier" == columnType.ToLower()) { strclass.AppendSpaceLine(4, "strSql2.Append(\"'\"+ Guid.NewGuid().ToString() +\"',\");"); } else if (CodeCommon.IsAddMark(columnType.Trim())) { strclass.AppendSpaceLine(4, "strSql2.Append(\"'\"+model." + columnName + "+\"',\");"); } else { strclass.AppendSpaceLine(4, "strSql2.Append(\"\"+model." + columnName + "+\",\");"); } strclass.AppendSpaceLine(3, "}"); } strclass.AppendSpaceLine(3, "strSql.Append(\"insert into " + TableName + "(\");"); strclass.AppendSpaceLine(3, "strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));"); strclass.AppendSpaceLine(3, "strSql.Append(\")\");"); strclass.AppendSpaceLine(3, "strSql.Append(\" values (\");"); strclass.AppendSpaceLine(3, "strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));"); strclass.AppendSpaceLine(3, "strSql.Append(\")\");"); if (strretu == "void") { strclass.AppendSpaceLine(3, "" + DbHelperName + ".ExecuteSql(strSql.ToString());"); } else if (strretu == "bool") { strclass.AppendSpaceLine(3, "int rows=" + DbHelperName + ".ExecuteSql(strSql.ToString());"); strclass.AppendSpaceLine(3, "if (rows > 0)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return true;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return false;"); strclass.AppendSpaceLine(3, "}"); } else//�����Զ�������ֵ { if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012") && (IsHasIdentity)) { strclass.AppendSpaceLine(3, "strSql.Append(\";select @@IDENTITY\");"); } if ((dbobj.DbType == "SQLite") && (IsHasIdentity)) { strclass.AppendSpaceLine(3, "strSql.Append(\";select LAST_INSERT_ROWID()\");"); } strclass.AppendSpaceLine(3, "object obj = " + DbHelperName + ".GetSingle(strSql.ToString());"); strclass.AppendSpaceLine(3, "if (obj == null)"); strclass.AppendSpaceLine(3, "{"); strclass.AppendSpaceLine(4, "return 0;"); strclass.AppendSpaceLine(3, "}"); strclass.AppendSpaceLine(3, "else"); strclass.AppendSpaceLine(3, "{"); switch (strretu) { case "int": strclass.AppendSpaceLine(4, "return Convert.ToInt32(obj);"); break; case "long": strclass.AppendSpaceLine(4, "return Convert.ToInt64(obj);"); break; case "decimal": strclass.AppendSpaceLine(4, "return Convert.ToDecimal(obj);"); break; } strclass.AppendSpaceLine(3, "}"); } strclass.AppendSpace(2, "}"); return strclass.ToString(); }