protected void DB_Submit_Click(object sender, EventArgs e) { StringBuilder result = new StringBuilder(); String TableName = this.DB_TableName.Text; DataTable TableList = MethodLibrary.ExecuteDIYSql("select top 0 * from " + TableName); String title = this.Entity_Title.Text + "Info"; result.Append("public class " + title + "\n"); result.Append("{\n"); for (int k = 0; k < TableList.Columns.Count; k++) { result.Append("private " + TableList.Columns[k].DataType.ToString().Replace("System.", "") + " _" + TableList.Columns[k].ColumnName + " " + TableList.Columns[k].DataType.ToString().Replace("System.", "").Replace("Int32", "= 0").Replace("Decimal", "= 0").Replace("Boolean", "= false").Replace("String", "= \"\"").Replace("DateTime", "= DateTime.Now") + ";//\n"); } result.Append("\npublic " + title + "()\n"); result.Append("{\n"); for (int k = 0; k < TableList.Columns.Count; k++) { result.Append("this._" + TableList.Columns[k].ColumnName + " = " + TableList.Columns[k].ColumnName + ";\n"); } result.Append("}\n"); for (int k = 0; k < TableList.Columns.Count; k++) { result.Append("/// <summary>\n"); result.Append("/// \n"); result.Append("/// </summary>\n"); result.Append("public " + TableList.Columns[k].DataType.ToString().Replace("System.", "") + " " + TableList.Columns[k].ColumnName + "\n"); result.Append("{\n"); result.Append("get { return this._" + TableList.Columns[k].ColumnName + "; }\n"); result.Append("set { this._" + TableList.Columns[k].ColumnName + " = value; }\n"); result.Append("}\n"); } result.Append("}\n"); this.Entity_Result.Text = result.ToString(); }
public TimeTrackerRepository(DevHubContext context, QueryMethod query, GuidMethod guid, IMapper mapper, MethodLibrary method) { _context = context; _query = query; _guid = guid; _mapper = mapper; _method = method; }
public void Library_PlaceNotation() { Assert.AreEqual("Plain Bob Minimus", MethodLibrary.GetMethodByPlaceNotation("x14x14,12", Stage.Minimus).title); Assert.AreEqual("Plain Bob Minimus", MethodLibrary.GetMethodByPlaceNotation("-1x1x4-12", Stage.Minimus).title); Assert.IsNull(MethodLibrary.GetMethodByPlaceNotation("x", Stage.Maximus)); Assert.AreEqual("Plain Bob Doubles", Method.GetMethod("5.1.5.1.5,2", Stage.Doubles).title); }
public BookLogRepository(DevHubContext context, IMapper mapper, MethodLibrary method, GuidMethod guid, QueryMethod query, EmailMethod email) { _context = context; _mapper = mapper; _method = method; _guid = guid; _query = query; _email = email; }
public AccountRepository(MethodLibrary method, SignInManager <ApplicationUser> manager, DevHubContext context, RoleManager <IdentityRole <string> > roleManager, IdentityContext identity, IMapper mapper) { _method = method; _manager = manager; _context = context; _roleManager = roleManager; _identity = identity; _mapper = mapper; }
protected void DB_Submit5_Click(object sender, EventArgs e) { StringBuilder result = new StringBuilder(); String TableName = this.DB_TableName.Text; DataTable TableList = MethodLibrary.ExecuteDIYSql("select top 0 * from " + TableName); String title = this.Entity_Title.Text + "Info"; result.Append("<table>\n"); for (int k = 0; k < TableList.Columns.Count; k++) { string _ColumnName = TableList.Columns[k].ColumnName.Split('_')[1]; if (TableList.Columns[k].ColumnName.Split('_').Length > 2) { _ColumnName = TableList.Columns[k].ColumnName.Split('_')[1] + TableList.Columns[k].ColumnName.Split('_')[2]; } result.Append(" <tr>\n"); result.Append(" <td class=\"infozuo\">" + TableList.Columns[k].ColumnName + ":</td>\n"); result.Append(" <td class=\"infoyou\"><asp:TextBox ID=\"Texx_" + _ColumnName + "\" MaxLength=\"50\" runat=\"server\" CssClass=\"class\"></asp:TextBox></td>\n"); result.Append(" </tr>\n\n"); } result.Append("</table>"); result.Append("\n\n\n\n\n"); result.Append(title + " _" + title + " = new " + title + "();\n\n"); for (int k = 0; k < TableList.Columns.Count; k++) { string _ColumnName = TableList.Columns[k].ColumnName.Split('_')[1]; if (TableList.Columns[k].ColumnName.Split('_').Length > 2) { _ColumnName = TableList.Columns[k].ColumnName.Split('_')[1] + TableList.Columns[k].ColumnName.Split('_')[2]; } result.Append("this.Texx_" + _ColumnName + ".Text = _" + title + "." + TableList.Columns[k].ColumnName + ";\n"); } result.Append("\n\n\n\n\n"); result.Append(title + " _" + title + " = new " + title + "();\n\n"); for (int k = 0; k < TableList.Columns.Count; k++) { string _ColumnName = TableList.Columns[k].ColumnName.Split('_')[1]; if (TableList.Columns[k].ColumnName.Split('_').Length > 2) { _ColumnName = _ColumnName + TableList.Columns[k].ColumnName.Split('_')[2]; } result.Append("_" + title + "." + TableList.Columns[k].ColumnName + " = this.Texx_" + _ColumnName + ".Text;\n"); } this.Entity_Result.Text = result.ToString(); }
protected void Button21_Click(object sender, EventArgs e) { StringBuilder result = new StringBuilder(); String TableName = this.DB_TableName.Text; DataTable TableList = MethodLibrary.ExecuteDIYSql("select column_name,data_type,character_maximum_length from information_schema.columns where table_name = '" + TableName + "'"); #region 添加 for (int k = 0; k < TableList.Rows.Count; k++) { if (k + 1 == TableList.Rows.Count) { result.Append(TableList.Rows[k]["column_name"].ToString() + "\n\n"); } else { result.Append(TableList.Rows[k]["Column_Name"].ToString() + ","); } } #endregion this.Entity_Result.Text = result.ToString(); }
public UserRepository(UserManager <ApplicationUser> userManager, MethodLibrary method, IMapper mapper) { _userManager = userManager; _method = method; _mapper = mapper; }
protected void Button1_Click(object sender, EventArgs e) { StringBuilder result = new StringBuilder(); String TableName = this.DB_TableName.Text; DataTable TableList = MethodLibrary.ExecuteDIYSql("select column_name,data_type,character_maximum_length from information_schema.columns where table_name = '" + TableName + "'"); #region 添加 result.Append("/*\n"); result.Append("*Name: [" + TableName + "_Add]\n"); result.Append("*Description: 添加\n"); result.Append("*Author: C#\n"); result.Append("*/\n"); result.Append("IF EXISTS (SELECT NAME FROM sysobjects WHERE id = OBJECT_ID(N'[" + TableName + "_Add]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)\n"); result.Append("DROP PROCEDURE [" + TableName + "_Add]\n"); result.Append("GO\n"); result.Append("CREATE procedure [" + TableName + "_Add]\n"); for (int k = 1; k < TableList.Rows.Count; k++) { if (k + 1 == TableList.Rows.Count) { if (TableList.Rows[k]["character_maximum_length"].ToString() == "") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "\n"); } else if (TableList.Rows[k]["character_maximum_length"].ToString() == "1073741823") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "\n"); } else { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "(" + TableList.Rows[k]["character_maximum_length"].ToString() + ")\n"); } } else { if (TableList.Rows[k]["character_maximum_length"].ToString() == "") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + ",\n"); } else if (TableList.Rows[k]["character_maximum_length"].ToString() == "1073741823") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + ",\n"); } else { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "(" + TableList.Rows[k]["character_maximum_length"].ToString() + "),\n"); } } } result.Append("AS\n"); result.Append("Insert into " + TableName + "\n"); result.Append("(\n"); for (int k = 1; k < TableList.Rows.Count; k++) { if (k + 1 == TableList.Rows.Count) { result.Append(TableList.Rows[k]["column_name"].ToString() + "\n"); } else { result.Append(TableList.Rows[k]["Column_Name"].ToString() + ",\n"); } } result.Append(")\n"); result.Append("Values\n"); result.Append("(\n"); for (int k = 1; k < TableList.Rows.Count; k++) { if (k + 1 == TableList.Rows.Count) { result.Append("@" + TableList.Rows[k]["Column_Name"].ToString() + "\n"); } else { result.Append("@" + TableList.Rows[k]["Column_Name"].ToString() + ",\n"); } } result.Append(")\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); #endregion #region 除 result.Append("/*\n"); result.Append("*Name: [" + TableName + "_Delete]\n"); result.Append("*Description: 删除\n"); result.Append("*Author: C#\n"); result.Append("*/\n"); result.Append("IF EXISTS (SELECT NAME FROM sysobjects WHERE id = OBJECT_ID(N'[" + TableName + "_Delete]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)\n"); result.Append("DROP PROCEDURE [" + TableName + "_Delete]\n"); result.Append("GO\n"); result.Append("CREATE procedure [" + TableName + "_Delete]\n"); result.Append("@" + TableList.Rows[0]["Column_Name"].ToString() + " " + TableList.Rows[0]["data_type"].ToString() + "\n"); result.Append("AS\n"); result.Append("Delete from " + TableName + " where " + TableList.Rows[0]["Column_Name"].ToString() + "=@" + TableList.Rows[0]["Column_Name"].ToString() + "\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); #endregion #region 获取 result.Append("/*\n"); result.Append("*Name: [" + TableName + "_Get]\n"); result.Append("*Description: 获取\n"); result.Append("*Author: C#\n"); result.Append("*/\n"); result.Append("IF EXISTS (SELECT NAME FROM sysobjects WHERE id = OBJECT_ID(N'[" + TableName + "_Get]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)\n"); result.Append("DROP PROCEDURE [" + TableName + "_Get]\n"); result.Append("GO\n"); result.Append("CREATE procedure [" + TableName + "_Get]\n"); result.Append("@" + TableList.Rows[0]["Column_Name"].ToString() + " " + TableList.Rows[0]["data_type"].ToString() + "\n"); result.Append("AS\n"); result.Append("select top 1 * from " + TableName + " where " + TableList.Rows[0]["Column_Name"].ToString() + "=@" + TableList.Rows[0]["Column_Name"].ToString() + "\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); #endregion #region 列表 result.Append("/*\n"); result.Append("*Name: [" + TableName + "_List]\n"); result.Append("*Description: 列表\n"); result.Append("*Author: C#\n"); result.Append("*/\n"); result.Append("IF EXISTS (SELECT NAME FROM sysobjects WHERE id = OBJECT_ID(N'[" + TableName + "_List]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)\n"); result.Append("DROP PROCEDURE [" + TableName + "_List]\n"); result.Append("GO\n"); result.Append("CREATE procedure [" + TableName + "_List]\n"); result.Append("AS\n"); result.Append("select * from " + TableName + "\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); result.Append("\n"); #endregion #region 设置 result.Append("/*\n"); result.Append("*Name: [" + TableName + "_Set]\n"); result.Append("*Description: 设置\n"); result.Append("*Author: C#\n"); result.Append("*/\n"); result.Append("IF EXISTS (SELECT NAME FROM sysobjects WHERE id = OBJECT_ID(N'[" + TableName + "_Set]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)\n"); result.Append("DROP PROCEDURE [" + TableName + "_Set]\n"); result.Append("GO\n"); result.Append("CREATE procedure [" + TableName + "_Set]\n"); for (int k = 0; k < TableList.Rows.Count; k++) { if (k + 1 == TableList.Rows.Count) { if (TableList.Rows[k]["character_maximum_length"].ToString() == "") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "\n"); } else if (TableList.Rows[k]["character_maximum_length"].ToString() == "1073741823") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "\n"); } else { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "(" + TableList.Rows[k]["character_maximum_length"].ToString() + ")\n"); } } else { if (TableList.Rows[k]["character_maximum_length"].ToString() == "") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + ",\n"); } else if (TableList.Rows[k]["character_maximum_length"].ToString() == "1073741823") { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + ",\n"); } else { result.Append("@" + TableList.Rows[k]["column_name"].ToString() + " " + TableList.Rows[k]["data_type"].ToString() + "(" + TableList.Rows[k]["character_maximum_length"].ToString() + "),\n"); } } } result.Append("AS\n"); result.Append("update " + TableName + " Set\n"); for (int k = 1; k < TableList.Rows.Count; k++) { if (k + 1 == TableList.Rows.Count) { result.Append(TableList.Rows[k]["column_name"].ToString() + "=@" + TableList.Rows[k]["column_name"].ToString() + "\n"); } else { result.Append(TableList.Rows[k]["column_name"].ToString() + "=@" + TableList.Rows[k]["column_name"].ToString() + ",\n"); } } result.Append("where " + TableList.Rows[0]["column_name"].ToString() + "=@" + TableList.Rows[0]["column_name"].ToString() + "\n"); #endregion this.Entity_Result.Text = result.ToString(); }
protected void Button2_Click(object sender, EventArgs e) { StringBuilder result = new StringBuilder(); String TableName = this.DB_TableName.Text; DataTable TableList = MethodLibrary.ExecuteDIYSql("select top 0 * from " + TableName); String title = "My" + this.Entity_Title.Text; result.Append("public class " + title + "\n"); result.Append("{\n"); result.Append("#region 添加\n"); result.Append("/// <summary>\n"); result.Append("/// 添加\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_UserInfo\">实体类</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static Boolean Add(" + this.Entity_Title.Text + "Info _" + this.Entity_Title.Text + "Info)\n"); result.Append("{\n"); result.Append("return " + this.Entity_Title.Text + "Data.Add(_" + this.Entity_Title.Text + "Info);\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 删除\n"); result.Append("/// <summary>\n"); result.Append("/// 删除\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_" + TableList.Columns[0].ColumnName + "\">SN</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static Boolean Delete(" + TableList.Columns[0].DataType.ToString().Replace("System.", "") + " _" + TableList.Columns[0].ColumnName + ")\n"); result.Append("{\n"); result.Append("return " + this.Entity_Title.Text + "Data.Delete(_" + TableList.Columns[0].ColumnName + ");\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 获取\n"); result.Append("/// <summary>\n"); result.Append("/// 获取\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_" + TableList.Columns[0].ColumnName + "\">SN</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static " + this.Entity_Title.Text + "Info Get(" + TableList.Columns[0].DataType.ToString().Replace("System.", "") + " _" + TableList.Columns[0].ColumnName + ")\n"); result.Append("{\n"); result.Append("return " + this.Entity_Title.Text + "Data.Get(_" + TableList.Columns[0].ColumnName + ");\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 列表\n"); result.Append("/// <summary>\n"); result.Append("/// \n"); result.Append("/// </summary>\n"); result.Append("public static DataTable List()\n"); result.Append("{\n"); result.Append("return " + this.Entity_Title.Text + "Data.List();\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 设置\n"); result.Append("/// <summary>\n"); result.Append("/// 设置\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_UserInfo\">实体类</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static Boolean Set(" + this.Entity_Title.Text + "Info _" + this.Entity_Title.Text + "Info)\n"); result.Append("{\n"); result.Append("return " + this.Entity_Title.Text + "Data.Set(_" + this.Entity_Title.Text + "Info);\n"); result.Append("}\n"); result.Append("#endregion\n"); result.Append("}\n"); this.Entity_Result.Text = result.ToString(); }
protected void Entity_Data_Click(object sender, EventArgs e) { StringBuilder result = new StringBuilder(); String TableName = this.DB_TableName.Text; DataTable TableList = MethodLibrary.ExecuteDIYSql("select top 0 * from " + TableName); String title = this.Entity_Title.Text + "Data"; result.Append("public class " + title + "\n"); result.Append("{\n"); result.Append("#region 添加\n"); result.Append("/// <summary>\n"); result.Append("/// 添加\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_UserInfo\">实体类</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static Boolean Add(" + this.Entity_Title.Text + "Info _" + this.Entity_Title.Text + "Info)\n"); result.Append("{\n"); result.Append("SqlParameter[] parm ={\n"); for (int t = 1; t < TableList.Columns.Count; t++) { result.Append(" new SqlParameter(\"" + TableList.Columns[t].ColumnName + "\",_" + this.Entity_Title.Text + "Info." + TableList.Columns[t].ColumnName + "),\n"); } result.Append(" };\n"); result.Append("SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, \"" + TableName + "_Add\", parm);\n"); result.Append("return true;\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 删除\n"); result.Append("/// <summary>\n"); result.Append("/// 删除\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_" + TableList.Columns[0].ColumnName + "\">SN</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static Boolean Delete(" + TableList.Columns[0].DataType.ToString().Replace("System.", "") + " _" + TableList.Columns[0].ColumnName + ")\n"); result.Append("{\n"); result.Append("SqlParameter[] parm ={"); result.Append("new SqlParameter(\"" + TableList.Columns[0].ColumnName + "\",_" + TableList.Columns[0].ColumnName + "),"); result.Append("};\n"); result.Append("SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, \"" + TableName + "_Delete\", parm);\n"); result.Append("return true;\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 获取\n"); result.Append("/// <summary>\n"); result.Append("/// 获取\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_" + TableList.Columns[0].ColumnName + "\">SN</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static " + this.Entity_Title.Text + "Info Get(" + TableList.Columns[0].DataType.ToString().Replace("System.", "") + " _" + TableList.Columns[0].ColumnName + ")\n"); result.Append("{\n"); result.Append(this.Entity_Title.Text + "Info _" + this.Entity_Title.Text + "Info = new " + this.Entity_Title.Text + "Info();\n"); result.Append("SqlParameter[] parm ={"); result.Append("new SqlParameter(\"" + TableList.Columns[0].ColumnName + "\",_" + TableList.Columns[0].ColumnName + "),"); result.Append("};\n"); result.Append("using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, \"" + TableName + "_Get\", parm))\n"); result.Append("{\n"); result.Append("if (_SDR.Read())\n"); result.Append("{\n"); for (int t = 0; t < TableList.Columns.Count; t++) { result.Append("_" + this.Entity_Title.Text + "Info." + TableList.Columns[t].ColumnName + " = Convert.To" + TableList.Columns[t].DataType.ToString().Replace("System.", "") + "(_SDR[\"" + TableList.Columns[t].ColumnName + "\"]);\n"); } result.Append("}\n"); result.Append("_SDR.Close();\n"); result.Append("_SDR.Dispose();\n"); result.Append("}\n"); result.Append("return _" + this.Entity_Title.Text + "Info;\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 列表\n"); result.Append("/// <summary>\n"); result.Append("/// \n"); result.Append("/// </summary>\n"); result.Append("public static DataTable List()\n"); result.Append("{\n"); result.Append("DataSet _DataSet = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionString2, CommandType.StoredProcedure, \"" + TableName + "_List\", null);\n"); result.Append("return _DataSet.Tables[0];\n"); result.Append("}\n"); result.Append("#endregion\n\n"); result.Append("#region 设置\n"); result.Append("/// <summary>\n"); result.Append("/// 设置\n"); result.Append("/// </summary>\n"); result.Append("/// <param name=\"_UserInfo\">实体类</param>\n"); result.Append("/// <returns></returns>\n"); result.Append("public static Boolean Set(" + this.Entity_Title.Text + "Info _" + this.Entity_Title.Text + "Info)\n"); result.Append("{\n"); result.Append("SqlParameter[] parm ={\n"); for (int t = 0; t < TableList.Columns.Count; t++) { result.Append(" new SqlParameter(\"" + TableList.Columns[t].ColumnName + "\",_" + this.Entity_Title.Text + "Info." + TableList.Columns[t].ColumnName + "),\n"); } result.Append(" };\n"); result.Append("SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, \"" + TableName + "_Set\", parm);\n"); result.Append("return true;\n"); result.Append("}\n"); result.Append("#endregion\n"); result.Append("}\n"); this.Entity_Result.Text = result.ToString(); }