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);
}
}
