private static string CreateBatEditData() { StringBuilder batEditContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); var batEditModel = PageCache.GetCmd("批量编辑"); if (batEditModel != null) { batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtBatEdit{1}\"]);\r\n", PageCache.KeyId, PageCache.KeyId); batEditContent.AppendFormat(@" List<string> idList = {0}.Split(new char[]{{','}}, StringSplitOptions.RemoveEmptyEntries).ToList();{1}", PageCache.KeyId, Environment.NewLine); foreach (var item in batEditModel.AttrList) { string attribute = item.AttrName; string eval_attribute = item.ColName; if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "tinyint") { batEditContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtBatEdit{0}\"]);\r\n", attribute); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { batEditContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute); batEditContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute); } else { batEditContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", attribute); batEditContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", attribute); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } else { batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtBatEdit{1}\"]);\r\n", attribute, attribute); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } } string template = @" private void BatEditData() {{ {0} {1} model = new {1}(); {2} {3} dal = new {3}(); dal.BatUpdate{4}(idList, model); Response.Write(""0""); }} "; return(string.Format(template, batEditContent.ToString(), PageCache.TableName_Model, createModel.ToString(), PageCache.TableName_DAL, PageCache.TableName)); } else { return(string.Empty); } }
public static string CreateGetAllAndPart(int action, string table_name, List <SqlColumnInfo> colList, string model_name, string db_name) { var down_allModel = (action | (int)action_type.export_all) == (int)action_type.export_all; var down_selelctModel = (action | (int)action_type.export_select) == (int)action_type.export_select; if (down_allModel || down_selelctModel) { StringBuilder down_allModel_Str = new StringBuilder(); #region 导出全部 if (down_allModel) { StringBuilder queryWhereContent = new StringBuilder(); StringBuilder queryListParams = new StringBuilder(); int index = 0; foreach (var item in colList.ToNotMainIdList()) { queryListParams.AppendFormat("{0} {1},", item.DbType.ToMsSqlClassType(), item.Name); if (index == 0) { if (item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint") { queryWhereContent.AppendFormat("if ({0} > 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat("if ({0} >= 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { queryWhereContent.AppendFormat("if ({0} != DateTime.MinValue)\r\n", item.Name); } else { queryWhereContent.AppendFormat("if (!string.IsNullOrEmpty({0}))\r\n", item.Name); } } else { if (item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint") { queryWhereContent.AppendFormat("\t\t\tif ({0} > 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat("\t\t\tif ({0} >= 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { queryWhereContent.AppendFormat("\t\t\tif ({0} != DateTime.MinValue)\r\n", item.Name); } else { queryWhereContent.AppendFormat("\t\t\tif (!string.IsNullOrEmpty({0}))\r\n", item.Name); } } queryWhereContent.Append(" {\r\n"); queryWhereContent.AppendFormat(" listParams.Add(new MySqlParameter(\"@{0}\", {1}) {{ Value = {0} }});\r\n", item.Name, item.DbType.ToMySqlDbType()); queryWhereContent.AppendFormat(" whereStr += \" and {0}=@{0} \";\r\n", item.Name); queryWhereContent.Append(" }\r\n"); queryWhereContent.AppendLine(); index++; } var assignContent = new StringBuilder(); foreach (var item in colList) { assignContent.AppendFormat(" model.{0} = sqldr[\"{0}\"] == DBNull.Value ? {1} : {2};\r\n", item.Name, ExtendMethod.ToDefaultValue(item.DbType), ExtendMethod.ToDefaultDBValue(item.DbType, item.Name)); } string template = @" public List<{0}> GetAll({3}) {{ string whereStr = string.Empty; List<MySqlParameter> listParams = new List<MySqlParameter>(); {1} string selectAllSql = string.Format(""select * from {5} where 1=1 {{0}}"", whereStr); List<{0}> result = new List<{0}>(); using (MySqlConnection sqlcn = ConnectionFactory.{2}) {{ using(MySqlDataReader sqldr = MySqlHelper2.ExecuteDataReader(sqlcn, CommandType.Text, selectAllSql, listParams.ToArray())) {{ while(sqldr.Read()) {{ {0} model = new {0}(); {4} result.Add(model); }} }} }} return result; }} "; string queryCountParams = queryListParams.Length > 0 ? queryListParams.ToString().Substring(0, queryListParams.Length - 1) : queryListParams.ToString(); down_allModel_Str.AppendFormat(template, model_name, queryWhereContent.ToString(), db_name, queryCountParams, assignContent.ToString(), table_name); } #endregion StringBuilder down_selectModel_Str = new StringBuilder(); #region 导出选中 if (down_selelctModel) { StringBuilder selectSqlContent = new StringBuilder(); selectSqlContent.Append(" string selectSql = string.Format(@\"select * from\r\n"); selectSqlContent.Append(" " + table_name + " where " + colList.ToKeyId() + " in ({1})\r\n"); selectSqlContent.Append(" {0};\", whereStr, idArrayStr);\r\n"); var assignContent = new StringBuilder(); foreach (var item in colList) { assignContent.AppendFormat(" model.{0} = sqldr[\"{0}\"] == DBNull.Value ? {1} : {2};\r\n", item.Name, ExtendMethod.ToDefaultValue(item.DbType), ExtendMethod.ToDefaultDBValue(item.DbType, item.Name)); } string template = @" public List<{0}> GetPartAll(List<string> idList) {{ var idArrayStr = string.Join("","", (from f in idList select ""'""+ f + ""'"").ToArray()); string whereStr = string.Empty; List<MySqlParameter> listParams = new List<MySqlParameter>(); {3} List<{0}> result = new List<{0}>(); using (MySqlConnection sqlcn = ConnectionFactory.{1}) {{ using(MySqlDataReader sqldr = MySqlHelper2.ExecuteDataReader(sqlcn, CommandType.Text, selectSql, listParams.ToArray())) {{ while(sqldr.Read()) {{ {0} model = new {0}(); {2} result.Add(model); }} }} }} return result; }} "; down_selectModel_Str.AppendFormat(template, model_name, db_name, assignContent.ToString(), selectSqlContent.ToString()); } #endregion return(down_allModel_Str.ToString() + down_selectModel_Str.ToString()); } else { return(string.Empty); } }
private static string CreateEditData() { StringBuilder editContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); var editModel = PageCache.GetCmd("编辑"); if (editModel != null) { editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtEdit{1}\"]);\r\n", PageCache.KeyId, PageCache.KeyId); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", PageCache.KeyId, ExtendMethod.ToStringToType(PageCache.KeyId, PageCache.KeyId_DbType)); foreach (var item in editModel.AttrList) { string attribute = item.AttrName; string eval_attribute = item.ColName; if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "tinyint") { editContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtEdit{0}\"]);\r\n", attribute); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { editContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute); editContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute); } else { editContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", attribute); editContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", attribute); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } else { editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtEdit{1}\"]);\r\n", attribute, attribute); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } } string template = @" private void EditData() {{ {0} {1} model = new {1}(); {2} {3} dal = new {3}(); dal.Update{4}(model); Response.Write(""0""); }} "; return(string.Format(template, editContent.ToString(), PageCache.TableName_Model, createModel.ToString(), PageCache.TableName_DAL, PageCache.TableName)); } else { return(string.Empty); } }
private static string CreateEditData(int action, List <SqlColumnInfo> colList, string table_name, string model_name, string dal_name) { StringBuilder editContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtEdit{0}\"]);\r\n", colList.ToKeyId()); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", colList.ToKeyId(), ExtendMethod.ToStringToType(colList.ToKeyId(), colList.ToKeyIdDbType())); if ((action & (int)action_type.edit) == (int)action_type.edit) { var editList = Cache_VMData.GetVMList(table_name, VMType.Edit, colList.ToNotMainIdList()); foreach (var item in editList) { if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "tinyint") { editContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtEdit{0}\"]);\r\n", item.Name); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { editContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", item.Name); editContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", item.Name); } else { editContent.AppendFormat("\t\t\tint {0} = 0;\r\n", item.Name); editContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", item.Name); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType(item.Name, item.DbType)); } else { editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtEdit{1}\"]);\r\n", item.Name, item.Name); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType(item.Name, item.DbType)); } } string template = @" private void EditData() {{ {0} {1} model = new {1}(); {2} {3} dal = new {3}(); dal.Update{4}(model); Response.Write(""0""); }} "; return(string.Format(template, editContent.ToString(), model_name, createModel.ToString(), dal_name, table_name)); } else { return(string.Empty); } }
public static string CreateQueryListMethod(int action, string table_name, List <SqlColumnInfo> colList, string model_name, string db_name) { if ((action & (int)action_type.query_list) == (int)action_type.query_list) { StringBuilder queryWhereContent = new StringBuilder(); StringBuilder queryListParams = new StringBuilder(); int index = 0; foreach (var item in colList.ToNotMainIdList()) { queryListParams.AppendFormat("{0} {1},", item.DbType.ToMsSqlClassType(), item.Name); if (index == 0) { if (item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "decimal" || item.DbType.ToLower() == "float" || item.DbType.ToLower() == "double") { queryWhereContent.AppendFormat("if ({0} >= 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat("if ({0} >= 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { queryWhereContent.AppendFormat("if ({0} != DateTime.MinValue)\r\n", item.Name); } else { queryWhereContent.AppendFormat("if (!string.IsNullOrEmpty({0}))\r\n", item.Name); } } else { if (item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "decimal" || item.DbType.ToLower() == "float" || item.DbType.ToLower() == "double") { queryWhereContent.AppendFormat("\t\t\tif ({0} >= 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat("\t\t\tif ({0} >= 0)\r\n", item.Name); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { queryWhereContent.AppendFormat("\t\t\tif ({0} != DateTime.MinValue)\r\n", item.Name); } else { queryWhereContent.AppendFormat("\t\t\tif (!string.IsNullOrEmpty({0}))\r\n", item.Name); } } queryWhereContent.Append("\t\t\t{\r\n"); queryWhereContent.AppendFormat("\t\t\t\tlistParams.Add(new MySqlParameter(\"@{0}\", {1}) {{ Value = {0} }});\r\n", item.Name, item.DbType.ToMySqlDbType()); queryWhereContent.AppendFormat("\t\t\t\twhereStr += \" and {0}=@{0} \";\r\n", item.Name); queryWhereContent.Append("\t\t\t}\r\n"); queryWhereContent.AppendLine(); index++; } StringBuilder selectSqlContent = new StringBuilder(); selectSqlContent.Append("\tstring selectSql = string.Format(@\"select * from " + table_name + " where 1=1 {0} limit {1},{2};\", whereStr, ((page - 1) * pageSize), pageSize);\r\n"); var assignContent = new StringBuilder(); foreach (var item in colList) { assignContent.AppendFormat(" model.{0} = sqldr[\"{0}\"] == DBNull.Value ? {1} : {2};\r\n", item.Name, ExtendMethod.ToDefaultValue(item.DbType), ExtendMethod.ToDefaultDBValue(item.DbType, item.Name)); } string template = @" public List<{0}> QueryList({1}int page, int pageSize) {{ string whereStr = string.Empty; List<MySqlParameter> listParams = new List<MySqlParameter>(); {2} {7} List<{0}> result = new List<{0}>(); using (MySqlConnection sqlcn = ConnectionFactory.{3}) {{ using(MySqlDataReader sqldr = MySqlHelper2.ExecuteDataReader(sqlcn, CommandType.Text, selectSql, listParams.ToArray())) {{ while(sqldr.Read()) {{ {0} model = new {0}(); {5} result.Add(model); }} }} }} return result; }} public int QueryListCount({4}) {{ string whereStr = string.Empty; List<MySqlParameter> listParams = new List<MySqlParameter>(); {2} string selectCountSql = string.Format(""select count(0) from {6} where 1=1 {{0}}"", whereStr); using (MySqlConnection sqlcn = ConnectionFactory.{3}) {{ return Convert.ToInt32(MySqlHelper2.ExecuteScalar(sqlcn, CommandType.Text, selectCountSql, listParams.ToArray())); }} }} "; string queryCountParams = queryListParams.Length > 0 ? queryListParams.ToString().Substring(0, queryListParams.Length - 1) : queryListParams.ToString(); return(string.Format(template, model_name, queryListParams.ToString(), queryWhereContent.ToString(), db_name, queryCountParams, assignContent.ToString(), table_name, selectSqlContent.ToString())); } else { return(string.Empty); } }
private static string CreateEditData(int action, List <SqlColumnInfo> colList, string table_name, string dal_name) { StringBuilder editContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); StringBuilder editStrContent = new StringBuilder(); if ((action & (int)action_type.edit) == (int)action_type.edit) { editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtEdit{1});\r\n", colList.ToKeyId(), colList.ToKeyId()); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", colList.ToKeyId(), ExtendMethod.ToStringToType(colList.ToKeyId(), colList.ToKeyIdDbType())); editStrContent.AppendFormat("string txtEdit{0},", colList.ToKeyId()); foreach (var item in colList.ToNotMainIdList()) { if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "tinyint") { editContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(txtEdit{0});\r\n", item.Name); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { editContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", item.Name); editContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", item.Name); } else { editContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", item.Name); editContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", item.Name); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType_ExceptIntDate(item.Name, item.DbType)); } else { editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtEdit{1});\r\n", item.Name, item.Name); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType_ExceptIntDate(item.Name, item.DbType)); } editStrContent.AppendFormat("string txtEdit{0},", item.Name); } if (editStrContent.Length > 0) { editStrContent.Remove(editStrContent.Length - 1, 1); } string template = @" [HttpPost] public ActionResult edit({0}) {{ {1} {2} model = new {2}(); {3} {4} dal = new {4}(); dal.Update{5}(model); return new ContentResult() {{ Content = ""0"" }}; }} "; return(string.Format(template, editStrContent.ToString(), editContent.ToString(), table_name, createModel.ToString(), dal_name, table_name)); } else { return(string.Empty); } }
private static string CreateBatEditData(int action, List <SqlColumnInfo> colList, string table_name, string dal_name) { StringBuilder batEditContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); StringBuilder batEditStrContent = new StringBuilder(); if ((action & (int)action_type.bat_edit) == (int)action_type.bat_edit) { batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtBatEdit{1});\r\n", colList.ToKeyId(), colList.ToKeyId()); batEditContent.AppendFormat(@" List<string> idList = {0}.Split(new char[]{{','}}, StringSplitOptions.RemoveEmptyEntries).ToList();{1}", colList.ToKeyId(), Environment.NewLine); batEditStrContent.AppendFormat("string txtBatEdit{0},", colList.ToKeyId()); foreach (var item in colList.ToNotMainIdList()) { if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "tinyint") { batEditContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(txtBatEdit{0});\r\n", item.Name); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { batEditContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", item.Name); batEditContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", item.Name); } else { batEditContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", item.Name); batEditContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", item.Name); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType_ExceptIntDate(item.Name, item.DbType)); } else { batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtBatEdit{1});\r\n", item.Name, item.Name); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType_ExceptIntDate(item.Name, item.DbType)); } batEditStrContent.AppendFormat("string txtBatEdit{0},", item.Name); } if (batEditStrContent.Length > 0) { batEditStrContent.Remove(batEditStrContent.Length - 1, 1); } string template = @" [HttpPost] public ActionResult batedit({0}) {{ {1} {2} model = new {2}(); {3} dal = new {3}(); dal.Update{4}(model); return new ContentResult() {{ Content = ""0"" }}; }} "; return(string.Format(template, batEditStrContent.ToString(), batEditContent.ToString(), table_name, createModel.ToString(), dal_name, table_name)); } else { return(string.Empty); } }
private static string CreateAddData(int action, List <SqlColumnInfo> colList, string table_name, string model_name, string dal_name) { StringBuilder addContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); if ((action & (int)action_type.add) == (int)action_type.add) { foreach (var item in colList.ToNotMainIdList()) { if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "tinyint") { addContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtAdd{0}\"]);\r\n", item.Name); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { addContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", item.Name); addContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", item.Name); } else { addContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", item.Name); addContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", item.Name); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType(item.Name, item.DbType)); } else { addContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtAdd{1}\"]);\r\n", item.Name, item.Name); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType(item.Name, item.DbType)); } } string template = @" private void AddData() {{ {0} {1} model = new {1}(); {2} {3} dal = new {3}(); dal.Add{4}(model); Response.Write(""0""); }} "; return(string.Format(template, addContent.ToString(), model_name, createModel.ToString(), dal_name, table_name)); } else { return(string.Empty); } }
private static string CreateBatEditData(int action, List <SqlColumnInfo> colList, string table_name, string model_name, string dal_name) { StringBuilder batEditContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtBatEdit{0}\"]);\r\n", colList.ToKeyId()); batEditContent.AppendFormat(@" List<string> idList = {0}.Split(new char[]{{','}}, StringSplitOptions.RemoveEmptyEntries).ToList();{1}", colList.ToKeyId(), Environment.NewLine); if ((action & (int)action_type.bat_edit) == (int)action_type.bat_edit) { foreach (var item in colList.ToNotMainIdList()) { if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "tinyint") { batEditContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtBatEdit{0}\"]);\r\n", item.Name); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { batEditContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", item.Name); batEditContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", item.Name); } else { batEditContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", item.Name); batEditContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", item.Name); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType(item.Name, item.DbType)); } else { batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtBatEdit{0}\"]);\r\n", item.Name); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType(item.Name, item.DbType)); } } string template = @" private void BatEditData() {{ {0} {1} model = new {1}(); {2} {3} dal = new {3}(); dal.BatUpdate{4}(idList, model); Response.Write(""0""); }} "; return(string.Format(template, batEditContent.ToString(), model_name, createModel.ToString(), dal_name, table_name)); } else { return(string.Empty); } }
public static string CreateQueryListMethod() { var showModel = PageCache.GetCmd("主显示"); if (showModel != null) { StringBuilder queryWhereContent = new StringBuilder(); StringBuilder queryListParams = new StringBuilder(); int index = 0; foreach (var item in showModel.AttrList) { string attribute = item.ColName; queryListParams.AppendFormat("{0} {1},", item.DbType.ToMsSqlClassType(), attribute); if (index == 0) { if (item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "decimal" || item.DbType.ToLower() == "float" || item.DbType.ToLower() == "double") { queryWhereContent.AppendFormat("if ({0} >= 0)\r\n", attribute); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat("if ({0} >= 0)\r\n", attribute); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { queryWhereContent.AppendFormat("if ({0} != DateTime.MinValue)\r\n", attribute); } else { queryWhereContent.AppendFormat("if (!string.IsNullOrEmpty({0}))\r\n", attribute); } } else { if (item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "decimal" || item.DbType.ToLower() == "float" || item.DbType.ToLower() == "double") { queryWhereContent.AppendFormat("\t\t\tif ({0} >= 0)\r\n", attribute); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat("\t\t\tif ({0} >= 0)\r\n", attribute); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { queryWhereContent.AppendFormat("\t\t\tif ({0} != DateTime.MinValue)\r\n", attribute); } else { queryWhereContent.AppendFormat("\t\t\tif (!string.IsNullOrEmpty({0}))\r\n", attribute); } } queryWhereContent.Append("\t\t\t{\r\n"); queryWhereContent.AppendFormat("\t\t\t\tlistParams.Add(new SqlParameter(\"@{0}\", {1}) {{ Value = {0} }});\r\n", attribute, item.DbType.ToMsSqlDbType()); queryWhereContent.AppendFormat("\t\t\t\twhereStr += \" and {0}=@{0} \";\r\n", attribute); queryWhereContent.Append("\t\t\t}\r\n"); queryWhereContent.AppendLine(); index++; } StringBuilder selectSqlContent = new StringBuilder(); selectSqlContent.Append("\tstring selectSql = string.Format(@\"select * from " + PageCache.TableName + " where 1=1 {0} limit {1},{2};\", whereStr, ((page - 1) * pageSize), pageSize);\r\n"); var assignContent = new StringBuilder(); if (!showModel.AttrList.Exists(p => p.ColName == PageCache.KeyId)) { assignContent.AppendFormat(" model.{0} = sqldr[\"{0}\"] == DBNull.Value ? {1} : {2};\r\n", PageCache.KeyId, ExtendMethod.ToDefaultValue(PageCache.KeyId_DbType), ExtendMethod.ToDefaultDBValue(PageCache.KeyId_DbType, PageCache.KeyId)); } foreach (var item in showModel.AttrList) { string attribute = item.ColName; assignContent.AppendFormat(" model.{0} = sqldr[\"{0}\"] == DBNull.Value ? {1} : {2};\r\n", attribute, ExtendMethod.ToDefaultValue(item.DbType), ExtendMethod.ToDefaultDBValue(item.DbType, attribute)); } string template = @" public List<{0}> QueryList({1}int page, int pageSize) {{ string whereStr = string.Empty; List<SqlParameter> listParams = new List<SqlParameter>(); {2} {7} List<{0}> result = new List<{0}>(); using (SqlConnection sqlcn = ConnectionFactory.{3}) {{ using(SqlDataReader sqldr = SqlHelper.ExecuteDataReader(sqlcn, CommandType.Text, selectSql, listParams.ToArray())) {{ while(sqldr.Read()) {{ {0} model = new {0}(); {5} result.Add(model); }} }} }} return result; }} public int QueryListCount({4}) {{ string whereStr = string.Empty; List<SqlParameter> listParams = new List<SqlParameter>(); {2} string selectCountSql = string.Format(""select count(0) from {6} where 1=1 {{0}}"", whereStr); using (SqlConnection sqlcn = ConnectionFactory.{3}) {{ return Convert.ToInt32(SqlHelper.ExecuteScalar(sqlcn, CommandType.Text, selectCountSql, listParams.ToArray())); }} }} "; string queryCountParams = queryListParams.Length > 0 ? queryListParams.ToString().Substring(0, queryListParams.Length - 1) : queryListParams.ToString(); return(string.Format(template, PageCache.TableName_Model, queryListParams.ToString(), queryWhereContent.ToString(), PageCache.DatabaseName, queryCountParams, assignContent.ToString(), PageCache.TableName, selectSqlContent.ToString())); } else { return(string.Empty); } }
private static string CreateBatEditData() { StringBuilder batEditContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); StringBuilder batEditStrContent = new StringBuilder(); var batEditModel = PageCache.GetCmd("批量编辑"); if (batEditModel != null) { batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtBatEdit{1});\r\n", PageCache.KeyId, PageCache.KeyId); batEditContent.AppendFormat(@" List<string> idList = {0}.Split(new char[]{{','}}, StringSplitOptions.RemoveEmptyEntries).ToList();{1}", PageCache.KeyId, Environment.NewLine); batEditStrContent.AppendFormat("string txtBatEdit{0},", PageCache.KeyId); foreach (var item in batEditModel.AttrList) { string attribute = item.AttrName; string eval_attribute = item.ColName; if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "tinyint") { batEditContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(txtBatEdit{0});\r\n", attribute); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { batEditContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute); batEditContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute); } else { batEditContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", attribute); batEditContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", attribute); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } else { batEditContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtBatEdit{1});\r\n", attribute, attribute); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } batEditStrContent.AppendFormat("string txtBatEdit{0},", attribute); } if (batEditStrContent.Length > 0) { batEditStrContent.Remove(batEditStrContent.Length - 1, 1); } string template = @" [HttpPost] public ActionResult batedit({0}) {{ {1} {2} model = new {2}(); {3} dal = new {3}(); dal.Update{4}(model); return new ContentResult() {{ Content = ""0"" }}; }} "; return(string.Format(template, batEditStrContent.ToString(), batEditContent.ToString(), PageCache.TableName_Model, createModel.ToString(), PageCache.TableName_DAL, PageCache.TableName)); } else { return(string.Empty); } }
private static string CreateEditData() { StringBuilder editContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); StringBuilder editStrContent = new StringBuilder(); var editModel = PageCache.GetCmd("编辑"); if (editModel != null) { editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtEdit{1});\r\n", PageCache.KeyId, PageCache.KeyId); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", PageCache.KeyId, ExtendMethod.ToStringToType(PageCache.KeyId, PageCache.KeyId_DbType)); editStrContent.AppendFormat("string txtEdit{0},", PageCache.KeyId); foreach (var item in editModel.AttrList) { string attribute = item.AttrName; string eval_attribute = item.ColName; if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "tinyint") { editContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(txtEdit{0});\r\n", attribute); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { editContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute); editContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute); } else { editContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", attribute); editContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", attribute); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } else { editContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtEdit{1});\r\n", attribute, attribute); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType_ExceptIntDate(attribute, item.DbType)); } editStrContent.AppendFormat("string txtEdit{0},", attribute); } if (editStrContent.Length > 0) { editStrContent.Remove(editStrContent.Length - 1, 1); } string template = @" [HttpPost] public ActionResult edit({0}) {{ {1} {2} model = new {2}(); {3} {4} dal = new {4}(); dal.Update{5}(model); return new ContentResult() {{ Content = ""0"" }}; }} "; return(string.Format(template, editStrContent.ToString(), editContent.ToString(), PageCache.TableName_Model, createModel.ToString(), PageCache.TableName_DAL, PageCache.TableName)); } else { return(string.Empty); } }
private static string CreateAddData(int action, List <SqlColumnInfo> colList, string table_name, string dal_name) { StringBuilder addContent = new StringBuilder(); StringBuilder createModel = new StringBuilder(); StringBuilder addStrContent = new StringBuilder(); if ((action & (int)action_type.add) == (int)action_type.add) { var addList = Cache_VMData.GetVMList(table_name, VMType.Add, colList.ToNotMainIdList()); foreach (var item in addList) { if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date" || item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint" || item.DbType.ToLower() == "tinyint") { addContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(txtAdd{0});\r\n", item.Name); if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date") { addContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", item.Name); addContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", item.Name); } else { addContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", item.Name); addContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", item.Name); } createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType_ExceptIntDate(item.Name, item.DbType)); } else { addContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtAdd{0});\r\n", item.Name); createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", item.Name, ExtendMethod.ToStringToType_ExceptIntDate(item.Name, item.DbType)); } addStrContent.AppendFormat("string txtAdd{0},", item.Name); } if (addStrContent.Length > 0) { addStrContent.Remove(addStrContent.Length - 1, 1); } string template = @" [HttpPost] public ActionResult add({0}) {{ {1} {2} model = new {2}(); {3} {4} dal = new {4}(); dal.Add{5}(model); return new ContentResult() {{ Content = ""0"" }}; }} "; return(string.Format(template, addStrContent.ToString(), addContent.ToString(), table_name, createModel.ToString(), dal_name, table_name)); } else { return(""); } }
public static string CreateGetAllAndPart() { int index = 0; var down_all_Model = PageCache.GetCmd("导出全部"); var down_selelct_Model = PageCache.GetCmd("导出选中"); if (down_all_Model != null || down_selelct_Model != null) { StringBuilder resultContent = new StringBuilder(); #region 导出全部 if (down_all_Model != null) { StringBuilder queryWhereContent = new StringBuilder(); StringBuilder queryListParams = new StringBuilder(); foreach (var item in down_all_Model.AttrList) { string attribute = item.ColName; queryListParams.AppendFormat("{0} {1},", item.DbType.ToMsSqlClassType(), attribute); if (index == 0) { if (item.DbType.ToLower() == "int") { queryWhereContent.AppendFormat(" if ({0} > 0)\r\n", attribute); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat(" if ({0} >= 0)\r\n", attribute); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "datetime") { queryWhereContent.AppendFormat(" if ({0} != DateTime.MinValue)\r\n", attribute); } else { queryWhereContent.AppendFormat(" if (!string.IsNullOrEmpty({0}))\r\n", attribute); } } else { if (item.DbType.ToLower() == "int" || item.DbType.ToLower() == "bigint") { queryWhereContent.AppendFormat(" if ({0} > 0)\r\n", attribute); } else if (item.DbType.ToLower() == "tinyint") { queryWhereContent.AppendFormat(" if ({0} >= 0)\r\n", attribute); } else if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "datetime") { queryWhereContent.AppendFormat(" if ({0} != DateTime.MinValue)\r\n", attribute); } else { queryWhereContent.AppendFormat(" if (!string.IsNullOrEmpty({0}))\r\n", attribute); } } queryWhereContent.Append(" {\r\n"); queryWhereContent.AppendFormat(" listParams.Add(new SqlParameter(\"@{0}\", {1}) {{ Value = {0} }});\r\n", attribute, item.DbType.ToMsSqlDbType()); queryWhereContent.AppendFormat(" whereStr += \" and {0}=@{0} \";\r\n", attribute); queryWhereContent.Append(" }\r\n"); queryWhereContent.AppendLine(); index++; } var assignContent = new StringBuilder(); foreach (var item in down_all_Model.AttrList) { string attribute = item.ColName; assignContent.AppendFormat(" model.{0} = sqldr[\"{0}\"] == DBNull.Value ? {1} : {2};\r\n", attribute, ExtendMethod.ToDefaultValue(item.DbType), ExtendMethod.ToDefaultDBValue(item.DbType, attribute)); } string template = @" public List<{0}> GetAll({3}) {{ string whereStr = string.Empty; List<SqlParameter> listParams = new List<SqlParameter>(); {1} string selectAllSql = string.Format(""select * from {5} where 1=1 {{0}}"", whereStr); List<{0}> result = new List<{0}>(); using (SqlConnection sqlcn = ConnectionFactory.{2}) {{ using(SqlDataReader sqldr = SqlHelper.ExecuteDataReader(sqlcn, CommandType.Text, selectAllSql, listParams.ToArray())) {{ while(sqldr.Read()) {{ {0} model = new {0}(); {4} result.Add(model); }} }} }} return result; }} "; string queryCountParams = queryListParams.Length > 0 ? queryListParams.ToString().Substring(0, queryListParams.Length - 1) : queryListParams.ToString(); resultContent.AppendFormat(template, PageCache.TableName_Model, queryWhereContent.ToString(), PageCache.DatabaseName, queryCountParams, assignContent.ToString(), PageCache.TableName); } #endregion #region 导出选中 if (down_selelct_Model != null) { StringBuilder selectSqlContent = new StringBuilder(); selectSqlContent.Append(" string selectSql = string.Format(@\"select * from\r\n"); selectSqlContent.Append(" " + PageCache.TableName + " where " + PageCache.KeyId + " in ({1})\r\n"); selectSqlContent.Append(" {0};\", whereStr, idArrayStr);\r\n"); var assignContent = new StringBuilder(); foreach (var item in down_selelct_Model.AttrList) { string colName = item.ColName; assignContent.AppendFormat(" model.{0} = sqldr[\"{0}\"] == DBNull.Value ? {1} : {2};\r\n", colName, ExtendMethod.ToDefaultValue(item.DbType), ExtendMethod.ToDefaultDBValue(item.DbType, colName)); } string template = @" public List<{0}> GetPartAll(List<string> idList) {{ var idArrayStr = string.Join("","", (from f in idList select ""'""+ f + ""'"").ToArray()); string whereStr = string.Empty; List<SqlParameter> listParams = new List<SqlParameter>(); {3} List<{0}> result = new List<{0}>(); using (SqlConnection sqlcn = ConnectionFactory.{1}) {{ using(SqlDataReader sqldr = SqlHelper.ExecuteDataReader(sqlcn, CommandType.Text, selectSql, listParams.ToArray())) {{ while(sqldr.Read()) {{ {0} model = new {0}(); {2} result.Add(model); }} }} }} return result; }} "; resultContent.AppendFormat(template, PageCache.TableName_Model, PageCache.DatabaseName, assignContent.ToString(), selectSqlContent.ToString()); } #endregion return(resultContent.ToString()); } else { return(string.Empty); } }