public static string CreateDeleteMethod()
{
var deleteModel = PageCache.GetCmd("删除");
if (deleteModel != null)
{
StringBuilder deleteContent = new StringBuilder();
deleteContent.AppendFormat(@"string deleteSql = string.Format(""delete from {0} ", PageCache.TableName);
deleteContent.AppendFormat(" where {0} in ({{0}})\", idStr);", PageCache.KeyId);
string template = @"
public bool Delete{0}(List<string> list)
{{
var array = (from f in list
select ""'"" + f + ""'"").ToArray();
string idStr = string.Join("","", array);
{1}
using (IDbConnection sqlcn = ConnectionFactory.{2})
{{
return sqlcn.Execute(deleteSql) > 0;
}}
}}
";
return(string.Format(template,
PageCache.TableName,
deleteContent.ToString(),
PageCache.DatabaseName));
}
else
{
return(string.Empty);
}
}
private static string CreateDeleteData()
{
StringBuilder batContent = new StringBuilder();
var deleteModel = PageCache.GetCmd("删除");
if (deleteModel != null)
{
batContent.Append(" ids = HttpUtility.UrlDecode(ids);\r\n");
batContent.Append(" List<string> idList = ids.Split(new char[]{','}, StringSplitOptions.RemoveEmptyEntries).ToList();\r\n");
string template = @"
[HttpPost]
public ActionResult delete(string ids)
{{
{0}
{1} dal = new {1}();
dal.Delete{2}(idList);
return new ContentResult() {{ Content = ""0"" }};
}}
";
return(string.Format(template,
batContent.ToString(),
PageCache.TableName_DAL,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
private static string CreateDataGrid()
{
// singleselect=""true""
var showModel = PageCache.GetCmd("主显示");
if (showModel != null)
{
string template = @"
<table id=""dg"" class=""easyui-datagrid"" style=""width: 1200px; height: auto"" url="""" pagination=""true""
title=""{0}"" fitcolumns=""true"">
<thead>
<tr>
{1}
</tr>
</thead>
</table>";
StringBuilder tbodyContent = new StringBuilder();
tbodyContent.AppendFormat("\t\t\t\t<th data-options=\"field:'{0}',checkbox:true\"></th>\r\n", PageCache.KeyId); // style=\"display: none;\"
foreach (var item in showModel.AttrList)
{
string attribute = item.AttrName;
tbodyContent.AppendFormat("\t\t\t\t<th data-options=\"field:'{0}',width:120,align:'center'\">{1}</th>\r\n", attribute, item.TitleName);
}
return(string.Format(template, PageCache.TiTle, tbodyContent.ToString()));
}
else
{
return(string.Empty);
}
}
private static string CreateDeleteData()
{
StringBuilder batContent = new StringBuilder();
var deleteModel = PageCache.GetCmd("删除");
if (deleteModel != null)
{
batContent.AppendFormat(" string ids = HttpUtility.UrlDecode(Request[\"ids\"]);\r\n", PageCache.KeyId, PageCache.KeyId);
batContent.Append(" List<string> idList = ids.Split(new char[]{','}, StringSplitOptions.RemoveEmptyEntries).ToList();\r\n");
string template = @"
private void DeleteData()
{{
{0}
{1} dal = new {1}();
dal.Delete{2}(idList);
Response.Write(""0"");
}}
";
return(string.Format(template,
batContent.ToString(),
PageCache.TableName_DAL,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
private static string CreateAddData()
{
StringBuilder addContent = new StringBuilder();
StringBuilder createModel = new StringBuilder();
var addModel = PageCache.GetCmd("添加");
if (addModel != null)
{
foreach (var item in addModel.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() == "tinyint")
{
addContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtAdd{0}\"]);\r\n", attribute);
if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date")
{
addContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute);
addContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute);
}
else
{
addContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", attribute);
addContent.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(attribute, item.DbType));
}
else
{
addContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtAdd{1}\"]);\r\n", attribute, attribute);
createModel.AppendFormat("\t\t\tmodel.{0} = {1};\r\n", eval_attribute, ExtendMethod.ToStringToType(attribute, 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(), PageCache.TableName_Model, createModel.ToString(), PageCache.TableName_DAL, PageCache.TableName));
}
else
{
return(string.Empty);
}
}
public static string CreateBatEditMethod()
{
var batEditModel = PageCache.GetCmd("批量编辑");
if (batEditModel != null)
{
StringBuilder updateContent = new StringBuilder(@"string updateSql = string.Format(""update ");
updateContent.AppendFormat(" {0} set ", PageCache.TableName);
StringBuilder updateParamsContent = new StringBuilder("List<SqlParameter> listParams = new List<SqlParameter>();\r\n");
int index = 0;
foreach (var item in batEditModel.AttrList)
{
string attribute = item.ColName;
if (index == 0)
{
updateContent.AppendFormat("{0}=@{0}", attribute);
}
else
{
updateContent.AppendFormat(",{0}=@{0}", attribute);
}
updateParamsContent.AppendFormat("\t\t\tlistParams.Add(new SqlParameter(\"@{0}\", {1}) {{ Value = model.{0} }});\r\n", attribute, item.DbType.ToMsSqlDbType());
index++;
}
updateContent.Append(" where ");
updateContent.AppendFormat(" {0} in ({{0}})\", idStr);", PageCache.KeyId);
updateParamsContent.AppendFormat("\t\t\tlistParams.Add(new SqlParameter(\"@{0}\", {1}) {{ Value = model.{2} }});\r\n", PageCache.KeyId, PageCache.KeyId_DbType.ToMsSqlDbType(), PageCache.KeyId);
string template = @"
public bool BatUpdate{4}(List<string> list, {0} model)
{{
var array = (from f in list
select ""'"" + f + ""'"").ToArray();
string idStr = string.Join("","", array);
{1}
{2}
using (SqlConnection sqlcn = ConnectionFactory.{3})
{{
return SqlHelper.ExecuteNonQuery(sqlcn, CommandType.Text, updateSql, listParams.ToArray()) > 0;
}}
}}
";
return(string.Format(template,
PageCache.TableName_Model,
updateContent.ToString(),
updateParamsContent.ToString(),
PageCache.DatabaseName,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
public static string CreateAddMethod()
{
var addModel = PageCache.GetCmd("添加");
if (addModel != null)
{
StringBuilder addContent = new StringBuilder();
StringBuilder valueContent = new StringBuilder(") values (");
StringBuilder addparamsContent = new StringBuilder("List<SqlParameter> listParams = new List<SqlParameter>();\r\n");
addContent.AppendFormat("string insertSql = \"insert into {0}(", PageCache.TableName);
int index = 0;
foreach (var item in addModel.AttrList)
{
string attribute = item.ColName;
if (index == 0)
{
addContent.Append(attribute);
valueContent.Append("@" + attribute);
}
else
{
addContent.Append(" ," + attribute);
valueContent.Append(" ,@" + attribute);
}
addparamsContent.AppendFormat("\t\t\tlistParams.Add(new SqlParameter(\"@{0}\", {1}) {{ Value = model.{0} }});\r\n", attribute, item.DbType.ToMsSqlDbType());
index++;
}
addContent.Append(valueContent.ToString() + ")\";");
string template = @"
public bool Add{4}({0} model)
{{
{1}
{2}
using (SqlConnection sqlcn = ConnectionFactory.{3})
{{
return SqlHelper.ExecuteNonQuery(sqlcn, CommandType.Text, insertSql, listParams.ToArray()) > 0;
}}
}}
";
return(string.Format(template,
PageCache.TableName_Model,
addContent.ToString(),
addparamsContent.ToString(),
PageCache.DatabaseName,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
public static string CreateEditMethod()
{
var editModel = PageCache.GetCmd("编辑");
if (editModel != null)
{
StringBuilder updateContent = new StringBuilder("string updateSql = \"update ");
updateContent.AppendFormat(" {0} set ", PageCache.TableName);
StringBuilder updateParamsContent = new StringBuilder("List<MySqlParameter> listParams = new List<MySqlParameter>();\r\n");
int index = 0;
foreach (var item in editModel.AttrList)
{
string attribute = item.ColName;
if (index == 0)
{
updateContent.AppendFormat("{0}=@{0}", attribute);
}
else
{
updateContent.AppendFormat(",{0}=@{0}", attribute);
}
updateParamsContent.AppendFormat("\t\t\tlistParams.Add(new MySqlParameter(\"@{0}\", {1}) {{ Value = model.{0} }});\r\n", attribute, item.DbType.ToMySqlDbType());
index++;
}
updateContent.Append(" where ");
updateContent.AppendFormat(" {0}=@{0} \";", PageCache.KeyId);
updateParamsContent.AppendFormat("\t\t\tlistParams.Add(new MySqlParameter(\"@{0}\", {1}) {{ Value = model.{2} }});\r\n", PageCache.KeyId, PageCache.KeyId_DbType.ToMySqlDbType(), PageCache.KeyId);
string template = @"
public bool Update{4}({0} model)
{{
{1}
{2}
using (MySqlConnection sqlcn = ConnectionFactory.{3})
{{
return MySqlHelper2.ExecuteNonQuery(sqlcn, CommandType.Text, updateSql, listParams.ToArray()) > 0;
}}
}}
";
return(string.Format(template,
PageCache.TableName_Model,
updateContent.ToString(),
updateParamsContent.ToString(),
PageCache.DatabaseName,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
public static string CreateBatEditMethod()
{
var batEditModel = PageCache.GetCmd("批量编辑");
if (batEditModel != null)
{
StringBuilder updateContent = new StringBuilder(@"string updateSql = string.Format(""update ");
updateContent.AppendFormat(" {0} set ", PageCache.TableName);
int index = 0;
foreach (var item in batEditModel.AttrList)
{
string attribute = item.ColName;
if (index == 0)
{
updateContent.AppendFormat("{0}=@{0}", attribute);
}
else
{
updateContent.AppendFormat(",{0}=@{0}", attribute);
}
index++;
}
updateContent.Append(" where ");
updateContent.AppendFormat(" {0} in ({{0}})\", idStr);", PageCache.KeyId);
string template = @"
public bool BatUpdate{3}(List<string> list, {0} model)
{{
var array = (from f in list
select ""'"" + f + ""'"").ToArray();
string idStr = string.Join("","", array);
{1}
using (IDbConnection sqlcn = ConnectionFactory.{2})
{{
return sqlcn.Execute(updateSql, model) > 0;
}}
}}
";
return(string.Format(template,
PageCache.TableName_Model,
updateContent.ToString(),
PageCache.DatabaseName,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
public static string CreateAddMethod()
{
var addModel = PageCache.GetCmd("添加");
if (addModel != null)
{
StringBuilder addContent = new StringBuilder();
StringBuilder valueContent = new StringBuilder(") values (");
addContent.AppendFormat("string insertSql = \"insert into {0}(", PageCache.TableName);
int index = 0;
foreach (var item in addModel.AttrList)
{
string attribute = item.ColName;
if (index == 0)
{
addContent.Append(attribute);
valueContent.Append("@" + attribute);
}
else
{
addContent.Append(" ," + attribute);
valueContent.Append(" ,@" + attribute);
}
index++;
}
addContent.Append(valueContent.ToString() + ")\";");
string template = @"
public bool Add{3}({0} model)
{{
{1}
using (IDbConnection sqlcn = ConnectionFactory.{2})
{{
return sqlcn.Execute(insertSql, model) > 0;
}}
}}
";
return(string.Format(template,
PageCache.TableName_Model,
addContent.ToString(),
PageCache.DatabaseName,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
public static string CreateEditMethod()
{
var editModel = PageCache.GetCmd("编辑");
if (editModel != null)
{
StringBuilder updateContent = new StringBuilder("string updateSql = \"update ");
updateContent.AppendFormat(" {0} set ", PageCache.TableName);
int index = 0;
foreach (var item in editModel.AttrList)
{
string attribute = item.ColName;
if (index == 0)
{
updateContent.AppendFormat("{0}=@{0}", attribute);
}
else
{
updateContent.AppendFormat(",{0}=@{0}", attribute);
}
index++;
}
updateContent.Append(" where ");
updateContent.AppendFormat(" {0}=@{0} \";", PageCache.KeyId);
string template = @"
public bool Update{3}({0} model)
{{
{1}
using (IDbConnection sqlcn = ConnectionFactory.{2})
{{
return sqlcn.Execute(updateSql, model) > 0;
}}
}}
";
return(string.Format(template,
PageCache.TableName_Model,
updateContent.ToString(),
PageCache.DatabaseName,
PageCache.TableName));
}
else
{
return(string.Empty);
}
}
private static string CreateCmdToolBar()
{
StringBuilder toolBarContent = new StringBuilder(@"
<div id=""toolbar"">
");
if (PageCache.GetCmd("添加") != null)
{
toolBarContent.Append(@"<a href=""javascript:void(0)"" class=""easyui-linkbutton"" iconcls=""icon-add"" plain=""true"" onclick=""newModel()"">新增</a>");
}
if (PageCache.GetCmd("编辑") != null)
{
toolBarContent.Append(@"<a href=""javascript:void(0)"" class=""easyui-linkbutton"" iconcls=""icon-edit"" plain=""true"" onclick=""editModel()"">编辑</a>");
}
if (PageCache.GetCmd("批量编辑") != null)
{
toolBarContent.Append(@"<a href=""javascript:void(0)"" class=""easyui-linkbutton"" iconcls=""icon-edit"" plain=""true"" onclick=""batEditModel()"">批量编辑</a>");
}
if (PageCache.GetCmd("删除") != null)
{
toolBarContent.Append(@"<a href=""javascript:void(0)"" class=""easyui-linkbutton"" iconcls=""icon-remove"" plain=""true"" onclick=""destroyModel()"">删除</a>");
}
if (PageCache.GetCmd("批量删除") != null)
{
toolBarContent.Append(@"<a href=""javascript:void(0)"" class=""easyui-linkbutton"" iconcls=""icon-remove"" plain=""true"" onclick=""destroyBatModel()"">删除</a>");
}
if (PageCache.GetCmd("导出全部") != null)
{
toolBarContent.Append(@"<a href=""javascript:void(0)"" class=""easyui-linkbutton"" iconcls=""icon-remove"" plain=""true"" onclick=""exportAll()"">导出全部</a>");
}
if (PageCache.GetCmd("导出选中") != null)
{
toolBarContent.Append(@"<a href=""javascript:void(0)"" class=""easyui-linkbutton"" iconcls=""icon-remove"" plain=""true"" onclick=""selectExport()"">导出选中</a>");
}
toolBarContent.Append(@"
</div>");
return(toolBarContent.ToString());
}
private static string CreateSearchContent()
{
string template = @"
<div class=""demo-info"" style=""margin-bottom: 10px"">
<div class=""demo-tip icon-tip"">
</div>
<div>{0}</div>
</div>
";
StringBuilder searchContent = new StringBuilder();
var cmdInfo = PageCache.GetCmd("主显示");
if (cmdInfo != null)
{
foreach (var attr in cmdInfo.AttrList)
{
searchContent.AppendFormat(" <label for=\"txtSearch{0}\">{1}：</label><input type=\"text\" id=\"txtSearch{0}\" />", attr.AttrName, attr.TitleName);
}
searchContent.Append(" <input type=\"button\" id=\"btnsearch\" value=\"查询\" />");
}
return(string.Format(template, searchContent.ToString()));
}
private static string CreateLoadData()
{
string template = @"
private void LoadData()
{{
int page = Convert.ToInt32(Request.Form[""page""]);
int pageSize = Convert.ToInt32(Request.Form[""pageSize""]);
{0}
{1} dal = new {1}();
var list = dal.QueryList({2}page, pageSize);
{4}
int itemCount = dal.QueryListCount({3});
int pageCount = (int)Math.Ceiling((double)itemCount / (double)pageSize);
JavaScriptSerializer js = new JavaScriptSerializer();
var str = js.Serialize(new {{ PageCount = pageCount, ItemCount = itemCount, Data = list }});
Response.Write(str);
}}
";
StringBuilder searchContent = new StringBuilder();
StringBuilder searchStrContent = new StringBuilder();
var showModel = PageCache.GetCmd("主显示");
if (showModel != null)
{
foreach (var item in showModel.AttrList)
{
string attribute = item.AttrName;
if (item.DbType.ToLower() == "datetime" ||
item.DbType.ToLower() == "date" ||
item.DbType.ToLower() == "int" ||
item.DbType.ToLower() == "bigint" ||
item.DbType.ToLower() == "tinyint")
{
searchContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtSearch{0}\"]);\r\n", attribute);
if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date")
{
searchContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute);
searchContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute);
}
else
{
searchContent.AppendFormat("\t\t\tint {0} = 0;\r\n", attribute);
searchContent.AppendFormat("\t\t\tif(!int.TryParse({0}Str, out {0}))\r\n", attribute);
searchContent.Append("\t\t\t{\r\n");
searchContent.AppendFormat("\t\t\t\t{0} = -1;\r\n", attribute);
searchContent.Append("\t\t\t}\r\n");
}
}
else
{
searchContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(Request[\"txtSearch{0}\"]);\r\n", attribute);
}
searchStrContent.AppendFormat(" {0},", attribute);
}
StringBuilder encodeContent = new StringBuilder();
foreach (var item in showModel.AttrList)
{
if (item.Style.FieldName == "Html编码")
{
string attribute = item.ColName;
encodeContent.AppendLine(string.Format("\t\t\tlist.ForEach(p => p.{0} = HttpUtility.HtmlEncode(p.{0}));", attribute));
}
}
// 移除最后的逗号
string searchStrCount = searchStrContent.Length > 0 ? searchStrContent.ToString().Substring(0, searchStrContent.Length - 1) : searchStrContent.ToString();
return(string.Format(template,
searchContent.ToString(),
PageCache.TableName_DAL,
searchStrContent.ToString(),
searchStrCount,
encodeContent.ToString()));
}
else
{
return(string.Empty);
}
}
private static string CreateJsLoad()
{
StringBuilder content = new StringBuilder();
string template = @"
<script type=""text/javascript"">
$(function () {
var pager = $('#dg').datagrid('getPager');
$('#dg').datagrid('getPager').pagination({
pageSize: 10, //每页显示的记录条数，默认为10
pageList: [10, 15, 20, 25], //可以设置每页记录条数的列表
onSelectPage: function (pageNumber, pageSize) {
var opts = $('#dg').datagrid('options');
opts.pageNumber = pageNumber;
opts.pageSize = pageSize;
pager.pagination('refresh', {
pageNumber: pageNumber,
pageSize: pageSize
});
LoadData(pageNumber, pageSize); //每次更换页面时触发更改
},
onBeforeRefresh: function (pageNumber, pageSize) {
// 好像已经被执行过了，这里就不需要了
LoadData(pageNumber, pageSize); //每次更换页面时触发更改
},
displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录'
});
});
function LoadData(page_Number, page_Size) {
if (page_Number == undefined && page_Size == undefined) {
page_Number = $('#dg').datagrid('getPager').data(""pagination"").options.pageNumber; //pageNumber为datagrid的当前页码
page_Size = $('#dg').datagrid('getPager').data(""pagination"").options.pageSize; //pageSize为datagrid的每页记录条数
} else {
$('#dg').datagrid('options').pageNumber = page_Number; //pageNumber为datagrid的当前页码
$('#dg').datagrid('options').pageSize = page_Size; //pageSize为datagrid的每页记录条数
}
";
content.Append(template);
int index = 0;
StringBuilder coditionContent = new StringBuilder();
StringBuilder pagePost = new StringBuilder();
var showModel = PageCache.GetCmd("主显示");
if (showModel != null)
{
foreach (var item in showModel.AttrList)
{
string attribute = item.AttrName;
// 找到一个
coditionContent.AppendFormat("\t\t\tvar txtSearch{0} = $(\"#txtSearch{0}\").val();\r\n", attribute);
// var pagePost = "&xxx=" + xxx + "&yyy=" +yyy;
if (index == 0)
{
pagePost.AppendFormat("\t\t\tvar pageData = \"&txtSearch{0}=\" + txtSearch{0}", attribute);
}
else
{
pagePost.AppendFormat("+ \"&txtSearch{0}=\" + txtSearch{0}", attribute);
}
index++;
}
pagePost.Append(";");
content.Append(coditionContent.ToString());
content.Append(pagePost);
if (showModel.AttrList.Count == 0)
{
content.Append("\t\t\tvar pageData = \"\";\r\n");
}
template = string.Format(@"
var postData = ""page="" + page_Number + ""&pageSize="" + page_Size + pageData;
$(""#dg>tbody"").empty();
$.ajax({{
type: ""POST"",
url: ""{0}.aspx?type=load&t="" + new Date().getTime(),
data: postData,
success: function (msg) {{
var data = eval(""("" + msg + "")"");
$('#dg').datagrid('loadData', data.Data);
$('#dg').datagrid('getPager').pagination({{
//更新pagination的导航列表各参数
total: data.ItemCount, //总数
pageSize: page_Size, //行数
pageNumber: page_Number//页数
}});
}}
}});
}}
$(document).ready(function () {{
// $(""#dg"").datagrid(""hideColumn"", ""{1}"");
// 不注释会造成翻页不响应 onSelectPage
// $(""#dg"").datagrid({{ ""checkOnSelect"": true }});
// $(""#dg"").datagrid({{ ""selectOnCheck"": false }});
LoadData(1, 10);
if ($(""#btnsearch"") != null || $(""#btnsearch"") != undefined) {{
$(""#btnsearch"").click(function () {{
LoadData();
}});
}}
}});
</script>
", PageCache.TableName_UI,
PageCache.KeyId);
content.Append(template);
return(content.ToString());
}
else
{
return("");
}
}
private static string CreateJsOperation()
{
StringBuilder content = new StringBuilder(@"
<script type=""text/javascript"">");
#region edit
var editModel = PageCache.GetCmd("编辑");
if (editModel != null)
{
StringBuilder editSubmitContent = new StringBuilder();
editSubmitContent.AppendFormat("\t\t\tvar txtEdit{0} = $(\"#txtEdit{0}\").val();\r\n", PageCache.KeyId);
StringBuilder postDataContent = new StringBuilder("var postData = ");
postDataContent.AppendFormat("\"txtEdit{0}=\" + encodeURI(txtEdit{0}) ", PageCache.KeyId);
int index = 0;
StringBuilder editContent = new StringBuilder();
editContent.AppendFormat(@" $(""#txtEdit{0}"").val(row.{0});", PageCache.KeyId);
foreach (var item in editModel.AttrList)
{
string attribute = item.AttrName;
editContent.AppendFormat(@"
$(""#txtEdit{0}"").textbox(""setValue"", row.{0});", attribute);
editSubmitContent.AppendFormat("\t\t\tvar txtEdit{0} = $(\"#txtEdit{0}\").textbox(\"getValue\");\r\n", attribute);
postDataContent.AppendFormat(" + \"&txtEdit{0}=\" + encodeURI(txtEdit{0})", attribute);
index++;
}
if (postDataContent.ToString() == "var postData = ")
{
postDataContent.Append("\"\"");
}
postDataContent.Append(";");
content.AppendFormat(@"
function editModel() {{
var row = $('#dg').datagrid('getChecked');
if (row) {{
if(row.length==1)
{{
row = row[0];
$('#dlg-edit').dialog('open').dialog('setTitle', '编辑成员');
$('#fm-edit').form('load', row);
{0}
}}
else{{
alter(""编辑只能选择一个！"");
}}
}}
}}
function saveEditModel(){{
{1}
{2}
$.ajax({{
type: ""POST"",
url: ""{3}.aspx?type=edit"",
data: postData,
success: function (msg) {{
if (msg == ""0"") {{
$(""#dialog>p"").text(""修改成功！"");
LoadData();
}} else {{
$(""#dialog>p"").text(msg);
}}
$('#dlg').dialog('close'); // close the dialog
// show dialog
$(""#dialog"").dialog({{
width: 180,
height: 100,
buttons: {{
Ok: function () {{
$(this).dialog(""close"");
}}
}}
}});
}}
}});
}}
", editContent.ToString(),
editSubmitContent.ToString(),
postDataContent.ToString(),
PageCache.TableName_UI);
}
#endregion
#region add
var addModel = PageCache.GetCmd("添加");
if (addModel != null)
{
StringBuilder addContent = new StringBuilder();
StringBuilder postDataContent = new StringBuilder("var postData = ");
int index = 0;
foreach (var item in addModel.AttrList)
{
string attribute = item.AttrName;
addContent.AppendFormat("\t\t\tvar txtAdd{0} = $(\"#txtAdd{0}\").textbox(\"getValue\");\r\n", attribute);
if (index == 0)
{
postDataContent.AppendFormat("\"txtAdd{0}=\" + encodeURI(txtAdd{0}) ", attribute);
}
else
{
postDataContent.AppendFormat(" + \"&txtAdd{0}=\" + encodeURI(txtAdd{0})", attribute);
}
index++;
}
if (postDataContent.ToString() == "var postData = ")
{
postDataContent.Append("\"\"");
}
postDataContent.Append(";");
content.AppendFormat(@"
function newModel() {{
$('#dlg-add').dialog('open').dialog('setTitle', '添加成员');
}}
function saveAddModel() {{
{0}
{1}
$.ajax({{
type: ""POST"",
url: ""{2}.aspx?type=add"",
data: postData,
success: function (msg) {{
if (msg == ""0"") {{
$(""#dialog>p"").text(""添加成功！"");
LoadData();
}} else {{
$(""#dialog>p"").text(msg);
}}
$('#dlg').dialog('close'); // close the dialog
// show dialog
$(""#dialog"").dialog({{
width: 180,
height: 100,
buttons: {{
Ok: function () {{
$(this).dialog(""close"");
}}
}}
}});
}}
}});
}}", addContent.ToString(),
postDataContent.ToString(),
PageCache.TableName_UI);
}
#endregion
#region del
var deleteModel = PageCache.GetCmd("删除");
if (deleteModel != null)
{
string template = string.Format(@"
function destroyUser() {{
var row = $('#dg').datagrid('getChecked');
if (row && row.length > 0) {{
$.messager.confirm('Confirm', '确定删除该数据吗?', function (r) {{
if (r) {{
var ids = """";
for(var index=0;i<r.length;i++){{
ids+=r[i].{1}+"","";
}}
ids = ids.substring(0, ids.length-1);
$.post('{0}.aspx?type=delete', {{ ids: ids }}, function (result) {{
if (result.success) {{
$('#dg').datagrid('reload'); // reload the user data
}} else {{
$.messager.show({{ // show error message
title: 'Error',
msg: result.errorMsg
}});
}}
}}, 'json');
}}
}});
}}
}}", PageCache.TableName_UI,
PageCache.KeyId);
content.Append(template);
}
#endregion
#region bat edit
var batEditModel = PageCache.GetCmd("批量编辑");
if (batEditModel != null)
{
StringBuilder batEditContent = new StringBuilder();
batEditContent.AppendFormat("\t\t\tvar txtBatEdit{0} = $(\"#txtBatEdit{0}\").textbox(\"getValue\");\r\n", PageCache.KeyId);
StringBuilder postDataContent = new StringBuilder("var postData = ");
postDataContent.AppendFormat("\"txtBatEdit{0}=\" + encodeURI(txtBatEdit{0}) ", PageCache.KeyId);
int index = 0;
foreach (var item in batEditModel.AttrList)
{
string attribute = item.AttrName;
batEditContent.AppendFormat("\t\t\tvar txtBatEdit{0} = $(\"#txtBatEdit{0}\").textbox(\"getValue\");\r\n", attribute);
postDataContent.AppendFormat(" + \"&txtBatEdit{0}=\" + encodeURI(txtBatEdit{0})", attribute);
index++;
}
if (postDataContent.ToString() == "var postData = ")
{
postDataContent.Append("\"\"");
}
postDataContent.Append(";");
content.AppendFormat(@"
function batEditModel() {{
var row = $('#dg').datagrid('getChecked');
if (row && row.length>0) {{
$('#dlg-batedit').dialog('open').dialog('setTitle', '批量编辑成员');
var ids = """";
for(var i=0;i<row.length;i++){{
ids += row[i].{0} + "","";
}}
ids = ids.substring(0, ids.length - 1);
$(""#txtBatEdit{0}"").val(ids);
}}
}}
function saveBatEditModel() {{
{1}
{2}
$.ajax({{
type: ""POST"",
url: ""{3}.aspx?type=batedit"",
data: postData,
success: function (msg) {{
if (msg == ""0"") {{
$(""#dialog>p"").text(""批量修改成功！"");
LoadData();
}} else {{
$(""#dialog>p"").text(msg);
}}
$('#dlg').dialog('close'); // close the dialog
// show dialog
$(""#dialog"").dialog({{
width: 180,
height: 100,
buttons: {{
Ok: function () {{
$(this).dialog(""close"");
}}
}}
}});
}}
}});
}}
", PageCache.KeyId,
batEditContent.ToString(),
postDataContent.ToString(),
PageCache.TableName_UI);
}
#endregion
#region export
var exportModel = PageCache.GetCmd("导出全部");
if (exportModel != null)
{
int index = 0;
StringBuilder coditionContent = new StringBuilder();
StringBuilder pagePost = new StringBuilder();
foreach (var item in exportModel.AttrList)
{
string attribute = item.AttrName;
// 找到一个
coditionContent.AppendFormat("\t\t\tvar txtSearch{0} = $(\"#txtSearch{0}\").textbox(\"getValue\");\r\n", attribute);
// var pagePost = "&xxx=" + xxx + "&yyy=" +yyy;
if (index == 0)
{
pagePost.AppendFormat("\t\t\tvar pageData = \"&txtSearch{0}=\" + txtSearch{0}", attribute);
}
else
{
pagePost.AppendFormat("+ \"&txtSearch{0}=\" + txtSearch{0}", attribute);
}
index++;
}
if (exportModel.AttrList.Count == 0)
{
pagePost.Append("\t\t\tvar pageData = \"\";\r\n");
}
else
{
pagePost.Append(";");
}
// selectExport
content.AppendFormat(@"
function exportAll() {{
{2}
{3}
document.location=""{1}.aspx?type=downall"" + pageData;
}}", PageCache.KeyId,
PageCache.TableName_UI,
coditionContent.ToString(),
pagePost.ToString());
}
#endregion
#region select export
var selectExportModel = PageCache.GetCmd("导出选中");
if (selectExportModel != null)
{
int index = 0;
StringBuilder coditionContent = new StringBuilder();
StringBuilder pagePost = new StringBuilder();
foreach (var item in selectExportModel.AttrList)
{
string attribute = item.AttrName;
// 找到一个
coditionContent.AppendFormat("\t\t\tvar txtSearch{0} = $(\"#txtSearch{0}\").textbox(\"getValue\");\r\n", attribute);
// var pagePost = "&xxx=" + xxx + "&yyy=" +yyy;
if (index == 0)
{
pagePost.AppendFormat("\t\t\tvar pageData = \"&txtSearch{0}=\" + txtSearch{0}", attribute);
}
else
{
pagePost.AppendFormat("+ \"&txtSearch{0}=\" + txtSearch{0}", attribute);
}
index++;
}
if (selectExportModel.AttrList.Count == 0)
{
pagePost.Append("\t\t\tvar pageData = \"\";\r\n");
}
else
{
pagePost.Append(";");
}
// selectExport
content.AppendFormat(@"
function selectExport() {{
var row = $('#dg').datagrid('getChecked');
if (row && row.length>0) {{
var ids = """";
for(var i=0;i<row.length;i++){{
ids += row[i].{0} + "","";
}}
document.location=""{1}.aspx?type=down&ids="" + ids;
}}
}}", PageCache.KeyId,
PageCache.TableName_UI);
}
#endregion
content.AppendLine("\r\n\t</script>");
return(content.ToString());
}
/// <summary>
/// 创建对象
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private static string CreateDialog()
{
StringBuilder dialogContent = new StringBuilder();
#region 添加
var addModel = PageCache.GetCmd("添加");
if (addModel != null)
{
// 行数过多，分成两行
string template = @"
<div id=""dlg-add"" class=""easyui-dialog"" style=""width: 400px; height: 240px; padding: 10px 20px""
closed=""true"" buttons=""#dlg-add-buttons"">
<div class=""ftitle"">
</div>
<form id=""fm-add"" method=""post"" enctype=""multipart/form-data"" action=""{0}.aspx?type=add""
novalidate=""novalidate"">
{1}
</form>
</div>
<div id=""dlg-add-buttons"">
<a href=""javascript:void(0)"" class=""easyui-linkbutton c6"" iconcls=""icon-ok"" onclick=""saveAddModel()""
style=""width: 90px"">保 存</a> <a href=""javascript:void(0)"" class=""easyui-linkbutton""
iconcls=""icon-cancel"" onclick=""javascript:$('#dlg-add').dialog('close')"" style=""width: 90px"">
取 消</a>
</div>";
StringBuilder content = new StringBuilder();
content.AppendFormat(@" <input type=""hidden"" id=""txtAdd{0}"" value="""" />", PageCache.KeyId);
foreach (var item in addModel.AttrList)
{
string attribute = item.AttrName;
// 　 占一个中文字符
content.AppendFormat(@"
<div class=""fitem"">
<label for=""txtAdd{0}"">{1}:</label>
<input type=""text"" id=""txtAdd{0}"" name=""txtAdd{0}"" {2} />
</div>", attribute, item.TitleName.PadLeftStr(4, " "), item.DbType.ToEasyUIInputClassOptStr());
}
dialogContent.Append(string.Format(template, PageCache.TableName_UI, content.ToString()));
}
#endregion
#region 编辑
var editModel = PageCache.GetCmd("编辑");
if (editModel != null)
{
// 行数过多，分成两行
string template = @"
<div id=""dlg-edit"" class=""easyui-dialog"" style=""width: 400px; height: 240px; padding: 10px 20px""
closed=""true"" buttons=""#dlg-edit-buttons"">
<div class=""ftitle"">
</div>
<form id=""fm-edit"" method=""post"" enctype=""multipart/form-data"" action=""{0}.aspx?type=edit""
novalidate=""novalidate"">
{1}
</form>
</div>
<div id=""dlg-edit-buttons"">
<a href=""javascript:void(0)"" class=""easyui-linkbutton c6"" iconcls=""icon-ok"" onclick=""saveEditModel()""
style=""width: 90px"">保 存</a> <a href=""javascript:void(0)"" class=""easyui-linkbutton""
iconcls=""icon-cancel"" onclick=""javascript:$('#dlg-edit').dialog('close')"" style=""width: 90px"">
取 消</a>
</div>";
StringBuilder content = new StringBuilder();
content.AppendFormat(@" <input type=""hidden"" id=""txtEdit{0}"" value="""" />", PageCache.KeyId);
foreach (var item in editModel.AttrList)
{
string attribute = item.AttrName;
// 初始化form显示数据
// 　 占一个中文字符
content.AppendFormat(@"
<div class=""fitem"">
<label for=""txtEdit{0}"">{1}:</label>
<input type=""text"" id=""txtEdit{0}"" name=""txtEdit{0}"" {2} />
</div>", attribute, item.TitleName.PadLeftStr(4, " "), item.DbType.ToEasyUIInputClassOptStr());
}
dialogContent.Append(string.Format(template, PageCache.TableName_UI, content.ToString()));
}
#endregion
#region 批量编辑
var batEditModel = PageCache.GetCmd("批量编辑");
if (batEditModel != null)
{
string template = @"
<div id=""dlg-batedit"" class=""easyui-dialog"" style=""width: 400px; height: 240px; padding: 10px 20px""
closed=""true"" buttons=""#dlg-batedit-buttons"">
<div class=""ftitle"">
</div>
<form id=""fm-batedit"" method=""post"" enctype=""multipart/form-data"" action=""{0}.aspx?type=batedit""
novalidate=""novalidate"">
{1}
</form>
</div>
<div id=""dlg-batedit-buttons"">
<a href=""javascript:void(0)"" class=""easyui-linkbutton c6"" iconcls=""icon-ok"" onclick=""saveBatEditModel()""
style=""width: 90px"">保 存</a> <a href=""javascript:void(0)"" class=""easyui-linkbutton""
iconcls=""icon-cancel"" onclick=""javascript:$('#dlg-batedit').dialog('close')"" style=""width: 90px"">
取 消</a>
</div>";
StringBuilder content = new StringBuilder();
content.AppendFormat(@" <input type=""hidden"" id=""txtBatEdit{0}"" value="""" />", PageCache.KeyId);
foreach (var item in batEditModel.AttrList)
{
string attribute = item.AttrName;
// 　 占一个中文字符
content.AppendFormat(@"
<div class=""fitem"">
<label for=""txtBatEdit{0}"">{1}:</label>
<input type=""text"" id=""txtBatEdit{0}"" name=""txtBatEdit{0}"" {2} />
</div>", attribute, item.TitleName.PadLeftStr(4, " "), item.DbType.ToEasyUIInputClassOptStr());
}
dialogContent.Append(string.Format(template, PageCache.TableName_UI, content.ToString()));
}
#endregion
return(dialogContent.ToString());
}
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);
}
}
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 CreateDownAndDownAll()
{
var down_all_model = PageCache.GetCmd("导出全部");
var down_select_model = PageCache.GetCmd("导出选中");
if (down_all_model != null || down_select_model != null)
{
StringBuilder down_all_str = new StringBuilder();
#region 导出全部
if (down_all_model != null)
{
StringBuilder searchContent = new StringBuilder();
StringBuilder searchStrContent = new StringBuilder();
string template = @"
private void DownAll()
{{
{0}
{1} dal = new {1}();
List<{5}> data = dal.GetAll({4});
string content = CreateTableAll(data);
Response.Clear();
Response.Buffer = true;
Response.Charset = ""UTF-8"";
Response.AddHeader(""Content-Disposition"", ""attachment; filename={1}.xls"");
Response.ContentEncoding = System.Text.Encoding.GetEncoding(""UTF-8"");
Response.ContentType = ""application/ms-excel;charset=UTF-8"";
Response.Write(content);
Response.Flush();
Response.End();
}}
private string CreateTableAll(List<{5}> list)
{{
StringBuilder content = new StringBuilder();
// create columns header
content.Append(""{2}"");
for (int i = 0, len = list.Count; i < len; i++)
{{
content.Append(""<tr>"");
{3}
content.Append(""</tr>"");
}}
content.Append(""</tbody></table>"");
return content.ToString();
}}";
foreach (var item in down_all_model.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")
{
searchContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(Request[\"txtSearch{0}\"]);\r\n", attribute);
if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date")
{
searchContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute);
searchContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute);
}
else
{
searchContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", attribute);
searchContent.AppendFormat("\t\t\tint.TryParse({0}Str, out {0});\r\n", attribute);
}
}
else
{
searchContent.AppendFormat(" string {0} = HttpUtility.UrlDecode(Request[\"txtSearch{0}\"]);\r\n", attribute);
}
searchStrContent.AppendFormat(" {0},", attribute);
}
// 移除最后的逗号
string searchStrCount = searchStrContent.Length > 0 ? searchStrContent.ToString().Substring(0, searchStrContent.Length - 1) : searchStrContent.ToString();
StringBuilder batContent = new StringBuilder();
batContent.Append(searchContent.ToString());
StringBuilder content = new StringBuilder();
content.Append("<table border='1'><thead><tr>");
foreach (var item in down_all_model.AttrList)
{
content.AppendFormat("<th>{0}</th>", item.TitleName);
}
content.Append("</tr></thead>");
StringBuilder appendFormat = new StringBuilder();
foreach (var item in down_all_model.AttrList)
{
appendFormat.AppendFormat(@" content.AppendFormat(""<td>{{0}}</td>"", list[i].{0});{1}", item.AttrName, Environment.NewLine);
}
down_all_str.AppendFormat(template,
batContent.ToString(),
PageCache.TableName_DAL,
content.ToString(),
appendFormat.ToString(),
searchStrCount,
PageCache.TableName_Model);
}
#endregion
StringBuilder down_select_str = new StringBuilder();
#region 导出选中
if (down_select_model != null)
{
StringBuilder searchContent = new StringBuilder();
StringBuilder searchStrContent = new StringBuilder();
string template = @"
private void Down()
{{
{0}
{1} dal = new {1}();
List<{4}> data = dal.GetPartAll(idList);
string content = CreateTable(data);
Response.Clear();
Response.Buffer = true;
Response.Charset = ""UTF-8"";
Response.AddHeader(""Content-Disposition"", ""attachment; filename={1}.xls"");
Response.ContentEncoding = System.Text.Encoding.GetEncoding(""UTF-8"");
Response.ContentType = ""application/ms-excel;charset=UTF-8"";
Response.Write(content);
Response.Flush();
Response.End();
}}
private string CreateTable(List<{4}> list)
{{
StringBuilder content = new StringBuilder();
// create columns header
content.Append(""{2}"");
for (int i = 0, len = list.Count; i < len; i++)
{{
content.Append(""<tr>"");
{3}
content.Append(""</tr>"");
}}
content.Append(""</tbody></table>"");
return content.ToString();
}}";
StringBuilder batContent = new StringBuilder();
searchContent.AppendFormat(" string ids = HttpUtility.UrlDecode(Request[\"ids\"]);\r\n", PageCache.KeyId, PageCache.KeyId);
searchContent.Append(" List<string> idList = ids.Split(new char[]{','}, StringSplitOptions.RemoveEmptyEntries).ToList();\r\n");
batContent.Append(searchContent.ToString());
StringBuilder content = new StringBuilder();
content.Append("<table border='1'><thead><tr>");
foreach (var item in down_select_model.AttrList)
{
content.AppendFormat("<th>{0}</th>", item.TitleName);
}
content.Append("</tr></thead>");
StringBuilder appendFormat = new StringBuilder();
foreach (var item in down_select_model.AttrList)
{
appendFormat.AppendFormat(@" content.AppendFormat(""<td>{{0}}</td>"", list[i].{0});{1}", item.AttrName, Environment.NewLine);
}
down_select_str.AppendFormat(template,
batContent.ToString(),
PageCache.TableName_DAL,
content.ToString(),
appendFormat.ToString(),
PageCache.TableName_Model);
}
#endregion
return(down_all_str.ToString() + down_select_str.ToString());
}
return(string.Empty);
}
private static string CreateLoadData()
{
string template = @"
[HttpPost]
public ActionResult load(int page, int pageSize{0})
{{
{1}
{2} dal = new {2}();
var list = dal.QueryList({3}page, pageSize);
int itemCount = dal.QueryListCount({4});
int pageCount = (int)Math.Ceiling((double)itemCount / (double)pageSize);
{5}
return new JsonResult() {{ Data = new {{ PageCount = pageCount, ItemCount = itemCount, Data = list }} }};
}}
";
StringBuilder searchContent = new StringBuilder();
StringBuilder searchStrContent = new StringBuilder();
StringBuilder loadStrContent = new StringBuilder();
var showModel = PageCache.GetCmd("主显示");
if (showModel != null)
{
foreach (var item in showModel.AttrList)
{
string attribute = item.AttrName;
if (item.DbType.ToLower() == "datetime" ||
item.DbType.ToLower() == "date" ||
item.DbType.ToLower() == "int" ||
item.DbType.ToLower() == "bigint" ||
item.DbType.ToLower() == "tinyint")
{
searchContent.AppendFormat("\t\t\tstring {0}Str = HttpUtility.UrlDecode(txtSearch{0});\r\n", attribute);
if (item.DbType.ToLower() == "datetime" || item.DbType.ToLower() == "date")
{
searchContent.AppendFormat("\t\t\tDateTime {0} = DateTime.MinValue;\r\n", attribute);
searchContent.AppendFormat("\t\t\tDateTime.TryParse({0}Str, out {0});\r\n", attribute);
}
else
{
searchContent.AppendFormat("\t\t\tint {0} = 0;;\r\n", attribute);
searchContent.AppendFormat("\t\t\tif(!int.TryParse({0}Str, out {0}))\r\n", attribute);
searchContent.Append("\t\t\t{\r\n");
searchContent.AppendFormat("\t\t\t\t{0} = -1;\r\n", attribute);
searchContent.Append("\t\t\t}\r\n");
}
}
else
{
searchContent.AppendFormat("\t\t\tstring {0} = HttpUtility.UrlDecode(txtSearch{0});\r\n", attribute);
}
searchStrContent.AppendFormat(" {0},", attribute);
loadStrContent.AppendFormat(", string txtSearch{0}", attribute);
}
StringBuilder encodeContent = new StringBuilder();
foreach (var item in showModel.AttrList)
{
if (item.Style.FieldName == "Html编码")
{
string attribute = item.ColName;
encodeContent.AppendLine(string.Format("\t\t\tlist.ForEach(p => p.{0} = HttpUtility.HtmlEncode(p.{0}));", attribute));
}
}
// 移除最后的逗号
string searchStrCount = searchStrContent.Length > 0 ? searchStrContent.ToString().Substring(0, searchStrContent.Length - 1) : searchStrContent.ToString();
return(string.Format(template,
loadStrContent.ToString(),
searchContent.ToString(),
PageCache.TableName_DAL,
searchStrContent.ToString(),
searchStrCount,
encodeContent.ToString()));
}
else
{
return(string.Empty);
}
}
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 CreateQueryListMethod()
{
var showModel = PageCache.GetCmd("主显示");
if (showModel != null)
{
StringBuilder queryWhereContent = new StringBuilder();
StringBuilder queryListParams = new StringBuilder();
StringBuilder setInfoContent = 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);
}
}
setInfoContent.AppendFormat("\t\t\tinfo.{0} = {0};\r\n", attribute);
queryWhereContent.Append("\t\t\t{\r\n");
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");
string template = @"
public List<{0}> QueryList({1}int page, int pageSize)
{{
{0} info = new {0}();
{5}
string whereStr = string.Empty;
{2}
{7}
List<{0}> result = new List<{0}>();
using (IDbConnection sqlcn = ConnectionFactory.{3})
{{
result = sqlcn.Query<{0}>(selectSql, info).ToList();
}}
return result;
}}
public int QueryListCount({4})
{{
{0} info = new {0}();
{5}
string whereStr = string.Empty;
{2}
string selectCountSql = string.Format(""select count(0) from {6} where 1=1 {{0}} limit 1"", whereStr);
using (IDbConnection sqlcn = ConnectionFactory.{3})
{{
return sqlcn.QuerySingle<int>(selectCountSql, info);
}}
}}
";
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,
setInfoContent.ToString(),
PageCache.TableName,
selectSqlContent.ToString()));
}
else
{
return(string.Empty);
}
}
public static string CreateGetAllAndPart()
{
var down_allModel = PageCache.GetCmd("导出全部");
var down_selelctModel = PageCache.GetCmd("导出选中");
if (down_allModel != null || down_selelctModel != null)
{
StringBuilder down_allModel_Str = new StringBuilder();
#region 导出全部
if (down_allModel != null)
{
StringBuilder queryWhereContent = new StringBuilder();
StringBuilder queryListParams = new StringBuilder();
int index = 0;
foreach (var item in down_allModel.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")
{
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")
{
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(" {\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_allModel.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();
down_allModel_Str.AppendFormat(template,
PageCache.TableName_Model,
queryWhereContent.ToString(),
PageCache.DatabaseName,
queryCountParams,
assignContent.ToString(),
PageCache.TableName);
}
#endregion
StringBuilder down_selectModel_Str = new StringBuilder();
#region 导出选中
if (down_selelctModel != 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_selelctModel.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}> 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;
}}
";
down_selectModel_Str.AppendFormat(template,
PageCache.TableName_Model,
PageCache.DatabaseName,
assignContent.ToString(),
selectSqlContent.ToString());
}
#endregion
return(down_allModel_Str.ToString() + down_selectModel_Str.ToString());
}
else
{
return(string.Empty);
}
}
private static string CreatePageLoad()
{
string template = @"
protected void Page_Load(object sender, EventArgs e)
{{
if (Request.HttpMethod.ToUpper() == ""POST"")
{{
string type = Request.QueryString[""type""];
switch (type)
{{{0}
}}
Response.End();
}}{1}
}}
";
StringBuilder content = new StringBuilder();
content.Append(@"
case ""load"":
LoadData();
break;");
if (PageCache.GetCmd("添加") != null)
{
content.Append(@"
case ""add"":
AddData();
break;");
}
if (PageCache.GetCmd("编辑") != null)
{
content.Append(@"
case ""edit"":
EditData();
break;");
}
if (PageCache.GetCmd("批量编辑") != null)
{
content.Append(@"
case ""batedit"":
BatEditData();
break;");
}
if (PageCache.GetCmd("删除") != null)
{
content.Append(@"
case ""delete"":
DeleteData();
break;");
}
StringBuilder elseContent = new StringBuilder();
if (PageCache.GetCmd("导出选中") != null || PageCache.GetCmd("导出全部") != null)
{
string export_all = @"
case ""downall"":
DownAll();
break;";
string export_select = @"
case ""down"":
Down();
break;";
elseContent.AppendFormat(@"
else{{
string type = Request.QueryString[""type""];
switch (type)
{{{0}{1}
}}
}}", PageCache.GetCmd("导出选中") != null ? export_select : "",
PageCache.GetCmd("导出全部") != null ? export_all : "");
}
return(string.Format(template, content.ToString(), elseContent.ToString()));
}
public static string CreateGetAllAndPart()
{
var down_allModel = PageCache.GetCmd("导出全部");
var down_selelctModel = PageCache.GetCmd("导出选中");
if (down_allModel != null || down_selelctModel != null)
{
StringBuilder down_allModel_Str = new StringBuilder();
#region 导出全部
if (down_allModel != null)
{
StringBuilder queryWhereContent = new StringBuilder();
StringBuilder queryListParams = new StringBuilder();
StringBuilder setInfoContent = new StringBuilder();
int index = 0;
foreach (var item in down_allModel.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")
{
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")
{
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);
}
}
setInfoContent.AppendFormat("\t\t\tinfo.{0} = {0};\r\n", attribute);
queryWhereContent.Append(" {\r\n");
queryWhereContent.AppendFormat(" whereStr += \" and {0}=@{0} \";\r\n", attribute);
queryWhereContent.Append(" }\r\n");
queryWhereContent.AppendLine();
index++;
}
string template = @"
public List<{0}> GetAll({3})
{{
{0} info = new {0}();
{4}
string whereStr = string.Empty;
{1}
string selectAllSql = string.Format(""select * from {5} where 1=1 {{0}} limit 10000"", whereStr);
List<{0}> result = new List<{0}>();
using (IDbConnection sqlcn = ConnectionFactory.{2})
{{
result = sqlcn.Query<{0}>(selectAllSql, info).ToList();
}}
return result;
}}
";
string queryCountParams = queryListParams.Length > 0 ? queryListParams.ToString().Substring(0, queryListParams.Length - 1) : queryListParams.ToString();
down_allModel_Str.AppendFormat(template,
PageCache.TableName_Model,
queryWhereContent.ToString(),
PageCache.DatabaseName,
queryCountParams,
setInfoContent.ToString(),
PageCache.TableName);
}
#endregion
StringBuilder down_selectModel_Str = new StringBuilder();
#region 导出选中
if (down_selelctModel != 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} limit {2};\", whereStr, idArrayStr, idList.Count);\r\n");
string template = @"
public List<{0}> GetPartAll(List<string> idList)
{{
var idArrayStr = string.Join("","", (from f in idList
select ""'""+ f + ""'"").ToArray());
string whereStr = string.Empty;
{2}
List<{0}> result = new List<{0}>();
using (IDbConnection sqlcn = ConnectionFactory.{1})
{{
result = sqlcn.Query<{0}>(selectSql).ToList();
}}
return result;
}}
";
down_selectModel_Str.AppendFormat(template,
PageCache.TableName_Model,
PageCache.DatabaseName,
selectSqlContent.ToString());
}
#endregion
return(down_allModel_Str.ToString() + down_selectModel_Str.ToString());
}
else
{
return(string.Empty);
}
}