/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_Config_ListPage GetModel(string strCondition)
{
List<Sys_Config_ListPage> list = instance.GetListByWhere(strCondition);
Sys_Config_ListPage model = new Sys_Config_ListPage();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
// Modify BY QB
// Modify:
// Modify Date:2011-3-12
/// <summary>
/// 通用字典转换
/// </summary>
/// <param name="Module"></param>
/// <param name="dt"></param>
/// <returns></returns>
public static DataTable ConvertDict(string Module, DataTable dt)
{
QX.DAL.ADOBse_Dict dictInstance = new QX.DAL.ADOBse_Dict();
Sys_Config_ListPage M_Model = new Sys_Config_ListPage();
List<Sys_Config_Fieled> D_List = new List<Sys_Config_Fieled>();
Bll_Comm.GetListConfig(Module, out M_Model, out D_List);
if (M_Model != null && D_List.Count > 0 && dt.Rows.Count > 0)
{
List<Sys_Config_Fieled> newDList = D_List.Where(o => !string.IsNullOrEmpty(o.D_DictKey)).ToList();
for (var i = 0; i < dt.Rows.Count; i++)
{
foreach (var item in newDList)
{
var model = dictInstance.GetListByWhere(" AND Dict_Key='" + item.D_DictKey + "' AND Dict_Code='" + dt.Rows[i][item.D_Index] + "'");
if (model.Count > 0)
{
dt.Rows[i][item.D_Index] = model.First().Dict_Name;
}
}
}
}
return dt;
}
/// <summary>
/// JqGrid通用分页序列化，根据数据配置字段进行时间格式化
/// </summary>
/// <param name="dt"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static string JsonForJqgridForRpt(string Module, DataTable dt, int pageIndex, int pageSize, int totalCount)
{
StringBuilder jsonBuilder = new StringBuilder();
StringBuilder sumBuilder = new StringBuilder();
int total = 0;
int page = totalCount / pageSize;
total = totalCount > pageSize ? totalCount / pageSize : 1;
if (totalCount > pageSize)
{
if (totalCount % pageSize > 0)
{
total = total + 1;
}
}
if (totalCount == 0)
{
total = 0;
pageIndex = 0;
}
jsonBuilder.Append("{\"Page\":" + pageIndex + ",\"Total\":" + total + ",\"Records\":" + totalCount + ",\"Rows\":");
#region 对时间进行格式化
Sys_Config_ListPage M_Model = new Sys_Config_ListPage();
List<Sys_Config_Fieled> listfiled = new List<Sys_Config_Fieled>();
GetListConfig(Module, out M_Model, out listfiled);
DataTable newDt = dt.Clone();
//DataTable resultDt = dt.Clone();
//string json = JsonConvert.SerializeObject(dt, new DataTableConverter(), new JsonDateConverter("yyyy-MM-dd"));
for (var x = 0; x < newDt.Columns.Count; x++)
{
var D_Index = dt.Columns[x].ColumnName;
var tmpModel = listfiled.Where(o => o.D_Index == D_Index);
if (tmpModel.Count() > 0)
{
if (tmpModel.FirstOrDefault().D_EditType == "datetime")
{
newDt.Columns[x].DataType = typeof(string);
}
else if (tmpModel.FirstOrDefault().D_EditType == "date")
{
newDt.Columns[x].DataType = typeof(string);
}
}
}
var D_SumList = listfiled.Where(o => !string.IsNullOrEmpty(o.D_Summary));
newDt.Rows.Clear();
for (var i = 0; i < dt.Rows.Count; i++)
{
DataRow newRow = newDt.NewRow();
for (var j = 0; j < dt.Columns.Count; j++)
{
var D_Index = dt.Columns[j].ColumnName;
var tmpModel = listfiled.Where(o => o.D_Index == D_Index);
if (tmpModel.Count() > 0)
{
if (tmpModel.FirstOrDefault().D_EditType == "datetime")
{
newRow[D_Index] = dt.Rows[i][D_Index] != null && !string.IsNullOrEmpty(dt.Rows[i][D_Index].ToString())
? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][D_Index].ToString()), new JsonDateConverter("yyyy-MM-dd HH:mm:ss")).Replace("\"", " ") : "";
}
else if (tmpModel.FirstOrDefault().D_EditType == "date")
{
//newDt.Columns[j].DataType = typeof(string);
newRow[D_Index] = dt.Rows[i][D_Index] != null && !string.IsNullOrEmpty(dt.Rows[i][D_Index].ToString())
? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][D_Index].ToString()), new JsonDateConverter("yyyy-MM-dd")).Replace("\"", " ") : "";
}
else
{
newRow[D_Index] = dt.Rows[i][D_Index];
}
}
}
newDt.Rows.Add(newRow);
}
#endregion
if (D_SumList.Count() > 0 && newDt.Rows.Count > 0)
{
sumBuilder.Append(",\"UserData\":{");
StringBuilder sb = new StringBuilder();
foreach (var item in D_SumList)
{
if (newDt.Columns.Contains(item.D_Index))
{
var val = newDt.Compute(string.Format("Sum({0})", item.D_Index), "");
//var d = decimal.Parse(val.ToString());
sb.AppendFormat("\"{0}\":{1},", item.D_Index, val);
}
}
sumBuilder.Append(sb.ToString().TrimEnd(','));
sumBuilder.Append(" }");
}
else
{
sumBuilder.Append(",\"UserData\":{");
StringBuilder sb = new StringBuilder();
foreach (var item in D_SumList)
{
//if (newDt.Columns.Contains(item.D_Index))
//{
//var val = newDt.Compute(string.Format("Sum({0})", item.D_Index), "");
//var d = decimal.Parse(val.ToString());
sb.AppendFormat("\"{0}\":{1},", item.D_Index, "0");
//}
}
sumBuilder.Append(sb.ToString().TrimEnd(','));
sumBuilder.Append(" }");
}
jsonBuilder.Append(JsonConvert.SerializeObject(newDt, new DataTableConverter()));
if (!string.IsNullOrEmpty(sumBuilder.ToString()))
{
jsonBuilder.Append(sumBuilder.ToString());
}
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
/// <summary>
/// JqGrid通用分页序列化，根据数据配置字段进行时间格式化
/// </summary>
/// <param name="dt"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static string JsonForJqgrid(string Module, DataTable dt, int pageIndex, int pageSize, int totalCount)
{
StringBuilder jsonBuilder = new StringBuilder();
int total = 0;
int page = totalCount / pageSize;
total = totalCount > pageSize ? totalCount / pageSize : 1;
if (totalCount > pageSize)
{
if (totalCount % pageSize > 0)
{
total = total + 1;
}
}
if (totalCount == 0)
{
total = 0;
pageIndex = 0;
}
jsonBuilder.Append("{\"Page\":" + pageIndex + ",\"Total\":" + total + ",\"Records\":" + totalCount + ",\"Rows\":");
#region 对时间进行格式化
Sys_Config_ListPage M_Model = new Sys_Config_ListPage();
List<Sys_Config_Fieled> listfiled = new List<Sys_Config_Fieled>();
GetListConfig(Module, out M_Model, out listfiled);
DataTable newDt = dt.Clone();
//DataTable resultDt = dt.Clone();
//string json = JsonConvert.SerializeObject(dt, new DataTableConverter(), new JsonDateConverter("yyyy-MM-dd"));
for (var x = 0; x < newDt.Columns.Count; x++)
{
var D_Index = dt.Columns[x].ColumnName;
var tmpModel = listfiled.Where(o => o.D_Index == D_Index);
if (tmpModel.Count() > 0)
{
if (tmpModel.FirstOrDefault().D_EditType == "datetime")
{
newDt.Columns[x].DataType = typeof(string);
}
else if (tmpModel.FirstOrDefault().D_EditType == "date")
{
newDt.Columns[x].DataType = typeof(string);
}
}
}
newDt.Rows.Clear();
for (var i = 0; i < dt.Rows.Count; i++)
{
DataRow newRow = newDt.NewRow();
for (var j = 0; j < dt.Columns.Count; j++)
{
var D_Index = dt.Columns[j].ColumnName;
var tmpModel = listfiled.Where(o => o.D_Index == D_Index);
if (tmpModel.Count() > 0)
{
if (tmpModel.FirstOrDefault().D_EditType == "datetime")
{
newRow[D_Index] = dt.Rows[i][D_Index] != null && !string.IsNullOrEmpty(dt.Rows[i][D_Index].ToString())
? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][D_Index].ToString()), new JsonDateConverter("yyyy-MM-dd HH:mm:ss")).Replace("\"", " ") : "";
}
else if (tmpModel.FirstOrDefault().D_EditType == "date")
{
//newDt.Columns[j].DataType = typeof(string);
newRow[D_Index] = dt.Rows[i][D_Index] != null && !string.IsNullOrEmpty(dt.Rows[i][D_Index].ToString())
? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][D_Index].ToString()), new JsonDateConverter("yyyy-MM-dd")).Replace("\"", " ") : "";
}
else
{
newRow[D_Index] = dt.Rows[i][D_Index];
}
}
}
newDt.Rows.Add(newRow);
}
#endregion
jsonBuilder.Append(JsonConvert.SerializeObject(newDt, new DataTableConverter()));
//jsonBuilder.Append(" ,\"UserData\":{ \"PUD_Num\":100 } ");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
/// <summary>
/// 获取Sys_Config_ListPage,Sys_Config_Fieled配置
/// </summary>
/// <param name="moduleName"></param>
/// <param name="M_Model"></param>
/// <param name="D_List"></param>
/// <returns></returns>
public static Sys_Config_ListPage GetListConfig(string moduleName, out Sys_Config_ListPage M_Model, out List<Sys_Config_Fieled> D_List)
{
ADOSys_Config_ListPage ListInstance = new ADOSys_Config_ListPage();
ADOSys_Config_Fieled FieledInstance = new ADOSys_Config_Fieled();
M_Model = null;
D_List = null;
try
{
if (!string.IsNullOrEmpty(moduleName))
{
//第一步：根据传入模块获取Grid配置
List<Sys_Config_ListPage> _ListPage = ListInstance.GetListByWhere(" AND M_ModuleCode='" +
moduleName + "'");
if (_ListPage.Count > 0)
{
M_Model = _ListPage[0];
}
//第二步：根据模块获取所有字段
D_List = FieledInstance.GetListByWhere(" AND D_ModuleCode='" + moduleName + "'");
}
else
{
M_Model = null;
D_List = null;
}
}
catch (System.Exception ex)
{
M_Model = null;
D_List = null;
}
return M_Model;
}
public static string GenToolbarNoPermissionHelper(this HtmlHelper helper, string moduleName, string prefix, string ToolBarConfig)
{
ADOComm comInstance = new ADOComm();
bool HiddeOther = false;
Sys_Config_ListPage M_Model = new Sys_Config_ListPage();
//第一步：根据传入模块获取Grid配置
List<Sys_Config_ListPage> _ListPage = new DAL.ADOSys_Config_ListPage().GetListByWhere(" AND M_ModuleCode='" +
moduleName + "'");
if (_ListPage.Count > 0)
{
M_Model = _ListPage[0];
}
string strPrefix = "";
strPrefix = prefix;
ToolBar bar = new ToolBar();
if (!string.IsNullOrEmpty(ToolBarConfig))
{
bar = JsonConvert.DeserializeObject<ToolBar>("{" + ToolBarConfig + "}");
}
var HasAdd = 1;
var HasEdit = 1;
var HasView = 1;
var HasDel = 1;
var HasImport = 1;
var HasExport = 1;
//var IS_OPEN_PERMISSION = ConfigHelper.GetApp("IS_OPEN_PERMISSION");
//if (!string.IsNullOrEmpty(IS_OPEN_PERMISSION) && IS_OPEN_PERMISSION == "true")
//{
// var Permission = comInstance.UserPermissionList(QX.Config.SessionConfig.UserId());
// HasAdd = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_add").Count();
// HasEdit = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_edit").Count();
// HasView = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_view").Count();
// HasDel = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_delete").Count();
// HasImport = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_import").Count();
// HasExport = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_export").Count();
//}
#region 按钮Html
string Li_add = @"<li {add} id='{prefix}_toolbar_add' class='{toolbar_add}'><a class='hide' id='{prefix}_add' onclick='{prefix}ToolBar.Add()' href='#'>{addN}</a></li>";
string Li_edit = @"<li {edit} id='{prefix}_toolbar_edit' class='{toolbar_edit}'><a class='hide' id='{prefix}_edit' onclick='{prefix}ToolBar.Edit()' href='#'>{editN}</a></li>";
string Li_del = @"<li {del} id='{prefix}_toolbar_delete' class='{toolbar_delete}'><a class='hide' id='{prefix}_delete' onclick='{prefix}ToolBar.Delete()' href='#'>{delN}</a></li> ";
string Li_view = @"<li {view} id='{prefix}_toolbar_view' class='{toolbar_view}'><a class='hide' id='{prefix}_view' onclick='{prefix}ToolBar.View()' href='#'>{viewN}</a></li> ";
//string Li_import = @"<li {import} id='{prefix}_toolbar_import' class='{toolbar_import}'><a class='hide' id='{prefix}_import' onclick='{prefix}ToolBar.Import()' href='#'>{importN}</a></li>";
//string Li_export = @"<li {export} id='{prefix}_toolbar_export' class='{toolbar_export}'><a class='hide' id='{prefix}_export' onclick='{prefix}ToolBar.Export()' href='#'>{exportN}</a></li>";
string Li_search = @"<li {search} id='{prefix}_toolbar_search' class='{toolbar_search}'><input style='display:none' id='search_txt' type='text' value='' />
<a id='{prefix}_search' onclick='{prefix}ToolBar.Search()' href='#'>{searchN}</a>
</li> ";
string Li_Custom = @"<li {add} id='{prefix}_toolbar_add' class='{toolbar_add}'><a id='{prefix}_add' onclick='{prefix}ToolBar.Add()' href='#'>{addN}</a></li>";
#endregion
#region 按钮解析
bool toolbar = !string.IsNullOrEmpty(bar.toolbar) ? true : false;
string add = !string.IsNullOrEmpty(bar.add) ? "style='display:none'" : "style='display:block'";
string addN = !string.IsNullOrEmpty(bar.addN) ? bar.addN : "添加";
string addClass = !string.IsNullOrEmpty(bar.addClass) ? bar.addClass : "toolbar_add";
string edit = !string.IsNullOrEmpty(bar.edit) ? "style='display:none'" : "style='display:block'";
string editN = !string.IsNullOrEmpty(bar.editN) ? bar.editN : "修改";
string editClass = !string.IsNullOrEmpty(bar.editClass) ? bar.editClass : "toolbar_edit";
string del = !string.IsNullOrEmpty(bar.del) ? "style='display:none'" : "style='display:block'";
string delN = !string.IsNullOrEmpty(bar.delN) ? bar.delN : "删除";
string delClass = !string.IsNullOrEmpty(bar.delClass) ? bar.delClass : "toolbar_delete";
string view = !string.IsNullOrEmpty(bar.view) ? "style='display:none'" : "style='display:block'";
string viewN = !string.IsNullOrEmpty(bar.viewN) ? bar.viewN : "查看";
string viewClass = !string.IsNullOrEmpty(bar.viewClass) ? bar.viewClass : "toolbar_view";
//string import = !string.IsNullOrEmpty(bar.import) ? "style='display:none'" : "style='display:block'";
//string importN = !string.IsNullOrEmpty(bar.importN) ? bar.importN : "导入";
//string importClass = !string.IsNullOrEmpty(bar.importClass) ? bar.importClass : "toolbar_import";
//string export = !string.IsNullOrEmpty(bar.export) ? "style='display:none'" : "style='display:block'";
//string exportN = !string.IsNullOrEmpty(bar.exportN) ? bar.exportN : "导出";
//string exportClass = !string.IsNullOrEmpty(bar.exportClass) ? bar.exportClass : "toolbar_export";
string search = !string.IsNullOrEmpty(bar.search) ? "style='display:none'" : "style='display:block'";
string searchN = !string.IsNullOrEmpty(bar.searchN) ? bar.searchN : "搜索";
string searchClass = !string.IsNullOrEmpty(bar.searchClass) ? bar.searchClass : "toolbar_search";
#endregion
#region 事件定义
string validatemethod = @"
if ($.isFunction(window.{prefix}ToolBar{OpType}))
{
{prefix}ToolBar{OpType}();
}
else
{
{nameSpace}_{moduleName}ToolBar{OpType}();
}";
string addJS = !string.IsNullOrEmpty(bar.addFunJs) ? "{prefix}" + bar.addFunJs : validatemethod.Replace("{OpType}", "Add");
string editJs = !string.IsNullOrEmpty(bar.editFunJs) ? "{prefix}" + bar.editFunJs : validatemethod.Replace("{OpType}", "Edit");
string delJs = !string.IsNullOrEmpty(bar.delFunJs) ? "{prefix}" + bar.delFunJs : validatemethod.Replace("{OpType}", "Del");
string viewJs = !string.IsNullOrEmpty(bar.viewFunJs) ? "{prefix}" + bar.viewFunJs : validatemethod.Replace("{OpType}", "View");
//string importJs = !string.IsNullOrEmpty(bar.importFunJs) ? "{prefix}" + bar.importFunJs : "{prefix}ToolBarImport()";
//string exportJs = !string.IsNullOrEmpty(bar.exportFunJs) ? "{prefix}" + bar.exportFunJs : "{prefix}ToolBarExport()";
string searchJs = !string.IsNullOrEmpty(bar.searchFunJs) ? "{prefix}" + bar.searchFunJs : "{prefix}ToolBarSearch()";
#endregion
#region HTML生成
string str = @"
<div id='{prefix}toolbar' class='toolbar'>
<ul>
{Li_add}
{Li_edit}
{Li_del}
{Li_view}
{Li_search}
</ul>
</div>
<script type='text/javascript'>
var {prefix}ToolBar = {
Add: function() {
{addJs};
},
Edit: function() {
{editJs};
},
Delete: function() {
{delJs};
},
View: function() {
{viewJs};
},
Search: function() {
{searchJs};
},
Import: function() {
{importJs};
},
Export: function() {
{exportJs};
},
HideElement:function(id){
$('#id').hide();
},
ChangeElement:function(id,name){
$('#id').find('a').val(name);
}
}
//插入菜单项：文本,回调,位置(ID),样式
</script>
";
#endregion
Li_add = HasAdd > 0 ? Li_add : "";
Li_edit = HasEdit > 0 ? Li_edit : "";
Li_del = HasDel > 0 ? Li_del : "";
//Li_import = HasImport > 0 ? Li_import : "";
//Li_export = HasExport > 0 ? Li_export : "";
Li_view = HasView > 0 ? Li_view : "";
bool HasConfig = !string.IsNullOrEmpty(ToolBarConfig) ? true : false;
if (HasConfig)
{
str = str.Replace("{Li_add}", ((!string.IsNullOrEmpty(bar.addN) || !string.IsNullOrEmpty(bar.addFunJs))) ? Li_add : "");
str = str.Replace("{Li_edit}", ((!string.IsNullOrEmpty(bar.editN) || !string.IsNullOrEmpty(bar.editFunJs))) ? Li_edit : "");
str = str.Replace("{Li_del}", ((!string.IsNullOrEmpty(bar.delN) || !string.IsNullOrEmpty(bar.delFunJs))) ? Li_del : "");
str = str.Replace("{Li_view}", ((!string.IsNullOrEmpty(bar.viewN) || !string.IsNullOrEmpty(bar.viewFunJs))) ? Li_view : "");
//str = str.Replace("{Li_import}", ((!string.IsNullOrEmpty(bar.importN) || !string.IsNullOrEmpty(bar.importFunJs))) ? Li_import : "");
//str = str.Replace("{Li_export}", ((!string.IsNullOrEmpty(bar.exportN) || !string.IsNullOrEmpty(bar.exportFunJs))) ? Li_export : "");
//str = str.Replace("{Li_search}", ((!string.IsNullOrEmpty(bar.searchN) || !string.IsNullOrEmpty(bar.searchFunJs))) ? Li_search : "");
}
else//默认生成的话根据配置进行生成
{
if (M_Model.M_IsAdd == 1)
{
str = str.Replace("{Li_add}", Li_add);
}
else
{
str = str.Replace("{Li_add}", "");
}
if (M_Model.M_IsEdit == 1)
{
str = str.Replace("{Li_edit}", Li_edit);
}
else
{
str = str.Replace("{Li_edit}", "");
}
if (M_Model.M_IsDelete == 1)
{
str = str.Replace("{Li_del}", Li_del);
}
else
{
str = str.Replace("{Li_del}", "");
}
if (M_Model.M_IsView == "true")
{
str = str.Replace("{Li_view}", Li_view);
}
else
{
str = str.Replace("{Li_view}", "");
}
//str = str.Replace("{Li_import}", Li_import);
//str = str.Replace("{Li_export}", Li_export);
}
//搜索 默认输出
str = str.Replace("{Li_search}", Li_search);
if (M_Model.M_IsAdd == 1)
{
str = str.Replace("{toolbar_add}", addClass);
}
else
{
str = str.Replace("{toolbar_add}", "");
}
if (M_Model.M_IsEdit == 1)
{
str = str.Replace("{toolbar_edit}", editClass);
}
else
{
str = str.Replace("{toolbar_edit}", "");
}
str = str.Replace("{toolbar_delete}", delClass);
if (M_Model.M_IsView == "true")
{
str = str.Replace("{toolbar_view}", viewClass);
}
else
{
str = str.Replace("{toolbar_view}", "");
}
//str = str.Replace("{toolbar_import}", importClass);
//str = str.Replace("{toolbar_export}", exportClass);
str = str.Replace("{toolbar_search}", searchClass);
if (M_Model.M_IsAdd == 1)
{
str = str.Replace("{addJs}", addJS);
}
else
{
str = str.Replace("{addJs}", "");
}
if (M_Model.M_IsEdit == 1)
{
str = str.Replace("{editJs}", editJs);
}
else
{
str = str.Replace("{editJs}", "");
}
if (M_Model.M_IsDelete == 1)
{
str = str.Replace("{delJs}", delJs);
}
else
{
str = str.Replace("{delJs}", "");
}
if (M_Model.M_IsView == "true")
{
str = str.Replace("{viewJs}", viewJs);
}
else
{
str = str.Replace("{viewJs}", "");
}
//str = str.Replace("{viewJs}", viewJs);
str = str.Replace("{searchJs}", searchJs);
//str = str.Replace("{importJs}", importJs);
//str = str.Replace("{exportJs}", exportJs);
str = str.Replace("{searchJs}", searchJs);
str = str.Replace("{prefix}", strPrefix);
str = str.Replace("{newprefix}", prefix);
str = str.Replace("{add}", add);
str = str.Replace("{addN}", addN);
str = str.Replace("{edit}", edit);
str = str.Replace("{editN}", editN);
str = str.Replace("{del}", del);
str = str.Replace("{delN}", delN);
str = str.Replace("{view}", view);
str = str.Replace("{viewN}", viewN);
//str = str.Replace("{import}", import);
//str = str.Replace("{importN}", importN);
//str = str.Replace("{export}", export);
//str = str.Replace("{exportN}", exportN);
str = str.Replace("{search}", search);
str = str.Replace("{searchN}", searchN);
str = str.Replace("{moduleName}", M_Model.M_ModuleCode);
str = str.Replace("{nameSpace}", M_Model.M_NameSpace);
if (toolbar)
{
str = "";
}
return str;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Sys_Config_ListPage model,bool IsValid)
{
bool result = false;
var e = new ModelExceptions();
if(e.IsValid && IsValid){
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Sys_Config_ListPage model,bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(Sys_Config_ListPage model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
public ActionResult GridEdit(string oper, string id)
{
string ModuleCode = Request["ModuleCode"] == null ? "" : Request["ModuleCode"].ToString();
string NameSpace = Request["NameSpace"] == null ? "" : Request["NameSpace"].ToString();
string Form = Request["form"] == null ? "" : Request["form"];
string FormId = Request["btn"];
oper = !string.IsNullOrEmpty(oper) ? oper : (Request["oper"] != null ? Request["oper"] : "");
id = !string.IsNullOrEmpty(id) ? id : (Request["id"] != null ? Request["id"] : "");
string TableName = "";
string InertSQL = "";
string UpdateSQL = "";
string DeleteSQL = "";
string TableKey = "";
string filterKey = "";
bool result = false;
string strResult = "fail";
Dictionary<string, string> FormValue = new Dictionary<string, string>();
Sys_Config_ListPage model=new Sys_Config_ListPage();
List<Sys_Config_Fieled> listfiled = new List<Sys_Config_Fieled>();
StringBuilder ErrorList = new StringBuilder();
if (!string.IsNullOrEmpty(ModuleCode) && !string.IsNullOrEmpty(NameSpace))
{
// var _model = instance.GetListByCode(" AND M_ModuleCode='" + ModuleCode + "' AND M_NameSpace='" + NameSpace + "' ");
var _model = instance.GetListByCode(" AND M_ModuleCode='" + ModuleCode + "' ");
model = _model.Count > 0 ? _model[0] : null;
//var listfiled = filedInstance.GetListByCode(" AND D_ModuleCode='" + ModuleCode + "' AND D_NameSpace='" + NameSpace + "' ");
listfiled = filedInstance.GetListByCode(" AND D_ModuleCode='" + ModuleCode + "'");
TableName = model.M_TableName;
TableKey = listfiled.Where(o => o.D_IsKey == 1).FirstOrDefault().D_Index;
filterKey = string.Format("{0}='{1}'", TableKey, id);
if (!string.IsNullOrEmpty(Form))
{
FormValue = FormParse(Form);
string _key = "";
string _value = "";
string _upkey = "";
filterKey = string.Format("{0}='{1}'", TableKey, FormValue[TableKey]);
var newListFiled = listfiled.Where(o => string.IsNullOrEmpty(o.D_EditHidden)
|| o.D_EditHidden == "false"
|| !string.IsNullOrEmpty(o.D_DefaultValue)
|| o.D_EditType == "loadall");
if (!string.IsNullOrEmpty(FormId))
{
#region 扩展
if (FormId.Contains("btn1"))
{
newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF1)
&& JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF1).Show.ToLower() == "true")
.OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF1).Order).ToList();
}
else if (FormId.Contains("btn2"))
{
newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF2)
&& JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF2).Show.ToLower() == "true")
.OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF2).Order).ToList();
}
else if (FormId.Contains("btn3"))
{
newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF3)
&& JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF3).Show.ToLower() == "true")
.OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF3).Order).ToList();
}
else if (FormId.Contains("btn4"))
{
newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF4)
&& JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF4).Show.ToLower() == "true")
.OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF4).Order).ToList();
}
#endregion
}
foreach (var item in newListFiled)
{
try
{
if (!string.IsNullOrEmpty(FormValue[item.D_Index]))
{
if (!string.IsNullOrEmpty(item.D_Type) && item.D_Type.Contains("int"))
{
_value += "" + FormValue[item.D_Index] + "" + ",";
_upkey += item.D_Index + "=" + FormValue[item.D_Index] + "" + ",";
}
else
{
if (item.D_Type.Contains("datetime"))
{
FormValue[item.D_Index] = FormValue[item.D_Index].Replace("+"," ");
}
_value += "'" + FormValue[item.D_Index] + "'" + ",";
_upkey += item.D_Index + "='" + FormValue[item.D_Index] + "'" + ",";
}
_key += item.D_Index + ",";
}
else
{
if (!string.IsNullOrEmpty(item.D_Type) && (item.D_Type.Contains("int") || item.D_Type.Contains("decimal")))
{
_value += "0,";
_upkey += item.D_Index + "=0" + ",";
}
else
{
if (item.D_Type.Contains("datetime"))
{
FormValue[item.D_Index] = "1900-01-01";
}
_value += "'" + FormValue[item.D_Index] + "'" + ",";
_upkey += item.D_Index + "='" + FormValue[item.D_Index] + "'" + ",";
}
_key += item.D_Index + ",";
}
}
catch (System.Exception ex)
{
ErrorList.AppendLine(ex.ToString());
continue;
}
}
//拼接Add sql
_key = _key + " CreateTime,";
_value = _value + "'" + DateTime.Now + "',";
InertSQL = "INSERT INTO " + TableName + " (" + _key.TrimEnd(',') + ") VALUES (" + _value.TrimEnd(',') + ") ";
//拼接update sql
_upkey = _upkey + " UpdateTime='" + DateTime.Now + "',";
UpdateSQL = "UPDATE " + TableName + " SET " + _upkey.TrimEnd(',') + " WHERE " + filterKey;
}
//拼接 Delete Sql
DeleteSQL = "UPDATE " + TableName + " SET Stat=1,DeleteTime='" + DateTime.Now + "' WHERE " + filterKey;
}
switch (oper)
{
case "add":
result = instance.SaveData(InertSQL);
strResult = result ? "success" : "fail";
//功能日志
this.OpLog(model.M_ModuleCode,
"添加:" + model.M_Title + ",编码:" + FormValue[TableKey],
strResult + "," + InertSQL + "," + ErrorList.ToString());
return Content(strResult);
case "edit":
result = instance.SaveData(UpdateSQL);
strResult = result ? "success" : "fail";
//功能日志
this.OpLog(model.M_ModuleCode,
"修改:" + model.M_Title + ",编码:" + FormValue[TableKey],
strResult + "," + InertSQL + "," + ErrorList.ToString());
return Content(strResult);
case "del":
result = instance.SaveData(DeleteSQL);
strResult = result ? "success" : "fail";
//功能日志
this.OpLog(model.M_ModuleCode,
"删除:" + model.M_Title + ",编码:" + id,
strResult + "," + InertSQL + "," + ErrorList.ToString());
return Content(strResult);
case "view":
DataTable dt = instance.ListDataByCode(TableName, filterKey);
DataTable newDt = dt.Clone();
//string json = JsonConvert.SerializeObject(dt, new DataTableConverter(), new JsonDateConverter("yyyy-MM-dd"));
for (var x = 0; x < newDt.Columns.Count;x++ )
{
var D_Index = dt.Columns[x].ColumnName;
var tmpModel = listfiled.Where(o => o.D_Index == D_Index);
if (tmpModel.Count() > 0)
{
if (tmpModel.FirstOrDefault().D_EditType == "datetime")
{
newDt.Columns[x].DataType = typeof(string);
}
else if (tmpModel.FirstOrDefault().D_EditType == "date")
{
newDt.Columns[x].DataType = typeof(string);
}
}
}
newDt.Rows.Clear();
for (var i = 0; i < dt.Rows.Count;i++ )
{
DataRow newRow = newDt.NewRow();
for (var j = 0; j < dt.Columns.Count;j++ )
{
var D_Index = dt.Columns[j].ColumnName;
var tmpModel = listfiled.Where(o => o.D_Index == D_Index);
if (tmpModel.Count()>0)
{
if (tmpModel.FirstOrDefault().D_EditType == "datetime")
{
newRow[D_Index] = dt.Rows[i][j] != null && !string.IsNullOrEmpty(dt.Rows[i][j].ToString())
? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][j].ToString()), new JsonDateConverter("yyyy-MM-dd HH:mm:ss")).Replace("\"","") : "";
}
else if (tmpModel.FirstOrDefault().D_EditType == "date")
{
//newDt.Columns[j].DataType = typeof(string);
newRow[D_Index] = dt.Rows[i][j] != null && !string.IsNullOrEmpty(dt.Rows[i][j].ToString())
? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][j].ToString()), new JsonDateConverter("yyyy-MM-dd")).Replace("\"", "") : "";
}
else
{
newRow[D_Index] = dt.Rows[i][j];
}
}
}
newDt.Rows.Add(newRow);
}
string json = JsonConvert.SerializeObject(newDt, new DataTableConverter());
return JavaScript(json);
}
return Content("");
}
/// <summary>
/// 导出当前查询的Excel
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Export(string id, string data)
{
data = HttpContext.Request.QueryString.ToString();
Dictionary<string, string> form = new Dictionary<string, string>();
var newForm = new Dictionary<string, string>();
if (!string.IsNullOrEmpty(data))
{
newForm = QX.Comm.StringHelper.FormParse(data);
if (newForm.Count == 0)
{
return Content("script> alert('获取参数失败');history.go(-1); </script>");
}
}
//获取
var itemValue = "";
foreach (var item in newForm)
{
if (!string.IsNullOrEmpty(item.Value))
{
itemValue = HttpContext.Server.UrlDecode(item.Value);
form.Add(item.Key, itemValue);
}
else
{
form.Add(item.Key, "");
}
}
string Module = id;
QX.Model.Sys_Config_ListPage M_Model = new QX.Model.Sys_Config_ListPage();
List<QX.Model.Sys_Config_Fieled> D_List = new List<QX.Model.Sys_Config_Fieled>();
QX.BLL.Bll_Comm.GetListConfig(Module, out M_Model, out D_List);
DataTable dt = new DataTable();
if (M_Model != null)
{
var Paramter = M_Model.M_Parameters.Split(',');
System.Data.SqlClient.SqlParameter[] param = new System.Data.SqlClient.SqlParameter[Paramter.Length + 1];
var ModuleParameter = new System.Data.SqlClient.SqlParameter("@Module", System.Data.SqlDbType.VarChar, 50);
ModuleParameter.Value = Module;
param[0] = ModuleParameter;
for (var i = 0; i < Paramter.Count(); i++)
{
var item = Paramter[i];
if (!string.IsNullOrEmpty(item))
{
ModuleParameter = new System.Data.SqlClient.SqlParameter();
ModuleParameter.ParameterName = "@" + item;
if (form.ContainsKey(item))
{
if (item.ToLower().Contains("edate"))
{
var date = DateTime.Parse(form[item]).ToString("yyyy-MM-dd 23:59:59");
ModuleParameter.Value = date;
}
else
{
ModuleParameter.Value = form[item];
}
}
else
{
ModuleParameter.Value = "";
}
param[i + 1] = ModuleParameter;
}
}
dt = QX.BLL.Bll_Comm.RunProc(M_Model.M_SQL, param);
if (dt.Rows.Count==0)
{
return Content("<script>alert('没有数据,不需要导出');history.go(-1);</script>");
}
if (string.IsNullOrEmpty(M_Model.M_Title))
{
return Content("<script>alert('配置错误,请配置模块名称');history.go(-1);</script>");
}
var headers = D_List.Where(o => string.IsNullOrEmpty(o.D_Hidden) || o.D_Hidden == "false")
.OrderBy(o => o.D_ShowOrder).Select(o => o.D_Name).ToArray();
var rowsKey = D_List.Where(o => string.IsNullOrEmpty(o.D_Hidden) || o.D_Hidden == "false")
.OrderBy(o => o.D_ShowOrder).Select(o => o.D_Index).ToArray();
return this.Excel(M_Model.M_Title, M_Model.M_Title, dt, headers, rowsKey);
}
else
{
return Content("<script>alert('导出配置模块出错');history.go(-1);</script>");
}
}
/// <summary>
/// 动态解析查询条件
/// </summary>
/// <param name="txt"></param>
/// <param name="module"></param>
/// <returns></returns>
public static string BuildSearch(this string txt, string module)
{
var QueryLeftTree = string.Empty;
StringBuilder strQuery = new StringBuilder();
//Dictionary<string, string> dict = ReturnBuild();
Dictionary<string, string> dict = new Dictionary<string, string>();
MetaOper mod = JsonConvert.DeserializeObject<MetaOper>(txt);
List<MetaRules> oper = JsonConvert.DeserializeObject<List<MetaRules>>(mod.rules.ToString());
ADOBse_Dict DictInstance = new ADOBse_Dict();
Sys_Config_ListPage M_Model = new Sys_Config_ListPage();
List<Sys_Config_Fieled> D_List = new List<Sys_Config_Fieled>();
GetListConfig(module, out M_Model, out D_List);
var D_List_Dict = D_List.Where(o => !string.IsNullOrEmpty(o.D_DictKey) && (string.IsNullOrEmpty(o.D_Hidden) || o.D_Hidden == "false"));
var Str_DictList = D_List.Select(o => o.D_Index);
var Str_Oper = oper.Select(o => o.field);
if (D_List_Dict.Count() > 0 && Str_DictList.Intersect(Str_Oper).Count() > 0)
{
for (int i = 0; i < oper.Count; i++)
{
string _oper = string.Empty;
StringBuilder ConvertData = new StringBuilder();
if (i != oper.Count - 1)
{
_oper = " " + mod.groupOp + " ";
}
var D_ListQuery = D_List_Dict.Where(o => o.D_Index == oper[i].field);
if (D_ListQuery.Count() > 0)
{
dict = ReturnBuildDict();
//构建查询条件Field
QueryLeftTree = !string.IsNullOrEmpty(D_ListQuery.First().D_DBField) ? D_ListQuery.First().D_DBField : oper[i].field;
//获取字典Code
if (!string.IsNullOrEmpty(oper[i].data))
{
var DictResult = DictInstance.GetListByWhere(" AND Dict_Key!=Dict_Code AND Dict_Name like '%" + oper[i].data + "%'");
if (DictResult.Count > 0)
{
foreach (var item in DictResult)
{
ConvertData.Append("'" + item.Dict_Code + "',");
}
}
strQuery.Append(dict[oper[i].op].Replace("{field}", QueryLeftTree).Replace("{data}", ConvertData.ToString().TrimEnd(',')) + _oper);
}
}
else
{
dict = ReturnBuild();
if (i != oper.Count - 1)
{
_oper = " " + mod.groupOp + " ";
}
strQuery.Append(dict[oper[i].op].Replace("{field}", oper[i].field).Replace("{data}", oper[i].data) + _oper);
}
}
}
else
{
if (oper.Count > 0)
{
dict = ReturnBuild();
for (int i = 0; i < oper.Count; i++)
{
string _oper = string.Empty;
if (i != oper.Count - 1)
{
_oper = " " + mod.groupOp + " ";
}
strQuery.Append(dict[oper[i].op].Replace("{field}", oper[i].field).Replace("{data}", oper[i].data) + _oper);
}
}
}
return strQuery.ToString();
}
/// <summary>
/// 导出当前查询的Excel
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Export(string id, string data)
{
data = HttpContext.Request.QueryString.ToString();
Dictionary <string, string> form = new Dictionary <string, string>();
var newForm = new Dictionary <string, string>();
if (!string.IsNullOrEmpty(data))
{
newForm = QX.Comm.StringHelper.FormParse(data);
if (newForm.Count == 0)
{
return(Content("script> alert('获取参数失败');history.go(-1); </script>"));
}
}
//获取
var itemValue = "";
foreach (var item in newForm)
{
if (!string.IsNullOrEmpty(item.Value))
{
itemValue = HttpContext.Server.UrlDecode(item.Value);
form.Add(item.Key, itemValue);
}
else
{
form.Add(item.Key, "");
}
}
string Module = id;
QX.Model.Sys_Config_ListPage M_Model = new QX.Model.Sys_Config_ListPage();
List <QX.Model.Sys_Config_Fieled> D_List = new List <QX.Model.Sys_Config_Fieled>();
QX.BLL.Bll_Comm.GetListConfig(Module, out M_Model, out D_List);
DataTable dt = new DataTable();
if (M_Model != null)
{
var Paramter = M_Model.M_Parameters.Split(',');
System.Data.SqlClient.SqlParameter[] param = new System.Data.SqlClient.SqlParameter[Paramter.Length + 1];
var ModuleParameter = new System.Data.SqlClient.SqlParameter("@Module", System.Data.SqlDbType.VarChar, 50);
ModuleParameter.Value = Module;
param[0] = ModuleParameter;
for (var i = 0; i < Paramter.Count(); i++)
{
var item = Paramter[i];
if (!string.IsNullOrEmpty(item))
{
ModuleParameter = new System.Data.SqlClient.SqlParameter();
ModuleParameter.ParameterName = "@" + item;
if (form.ContainsKey(item))
{
if (item.ToLower().Contains("edate"))
{
var date = DateTime.Parse(form[item]).ToString("yyyy-MM-dd 23:59:59");
ModuleParameter.Value = date;
}
else
{
ModuleParameter.Value = form[item];
}
}
else
{
ModuleParameter.Value = "";
}
param[i + 1] = ModuleParameter;
}
}
dt = QX.BLL.Bll_Comm.RunProc(M_Model.M_SQL, param);
if (dt.Rows.Count == 0)
{
return(Content("<script>alert('没有数据,不需要导出');history.go(-1);</script>"));
}
if (string.IsNullOrEmpty(M_Model.M_Title))
{
return(Content("<script>alert('配置错误,请配置模块名称');history.go(-1);</script>"));
}
var headers = D_List.Where(o => string.IsNullOrEmpty(o.D_Hidden) || o.D_Hidden == "false")
.OrderBy(o => o.D_ShowOrder).Select(o => o.D_Name).ToArray();
var rowsKey = D_List.Where(o => string.IsNullOrEmpty(o.D_Hidden) || o.D_Hidden == "false")
.OrderBy(o => o.D_ShowOrder).Select(o => o.D_Index).ToArray();
return(this.Excel(M_Model.M_Title, M_Model.M_Title, dt, headers, rowsKey));
}
else
{
return(Content("<script>alert('导出配置模块出错');history.go(-1);</script>"));
}
}
/// <summary>
/// 获取指定的List报表类型配置表 Sys_Config_ListPage对象集合
/// </summary>
public List<Sys_Config_ListPage> GetListByWhere(string strCondition)
{
List<Sys_Config_ListPage> ret = new List<Sys_Config_ListPage>();
string sql = "SELECT M_ID,M_ModuleCode,M_TableName,M_NameSpace,M_SQL,M_Type,M_Title,M_AutoWidth,M_Width,M_Height,M_URL,M_MType,M_GetDataType,M_SQLParameter,M_RowNum,M_RowList,M_FooterRow,M_ViewURL,M_ViewType,M_Edit,M_EditUrl,M_EditSubmitUrl,M_OnSelectRow,M_GridComplete,M_InlineEditing,M_ImportURL,M_ImportTable,M_ImportExport,M_AltRows,M_Altclass,M_emptyrecords,M_Gridstate,M_EditCloumNum,M_ToolBar,M_ToolBarExtend,Stat,M_ExtendsJs,M_ExtendsControl,M_EditTitle,M_MSelect,M_Parameters,M_GroupingView,M_FormEditing,M_FormMethod,M_IsAdd,M_IsEdit,M_IsDelete,M_IsView FROM Sys_Config_ListPage WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
sql += " ORDER BY M_ID DESC ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Sys_Config_ListPage sys_Config_ListPage = new Sys_Config_ListPage();
if (dr["M_ID"] != DBNull.Value) sys_Config_ListPage.M_ID = Convert.ToInt32(dr["M_ID"]);
if (dr["M_ModuleCode"] != DBNull.Value) sys_Config_ListPage.M_ModuleCode = Convert.ToString(dr["M_ModuleCode"]);
if (dr["M_TableName"] != DBNull.Value) sys_Config_ListPage.M_TableName = Convert.ToString(dr["M_TableName"]);
if (dr["M_NameSpace"] != DBNull.Value) sys_Config_ListPage.M_NameSpace = Convert.ToString(dr["M_NameSpace"]);
if (dr["M_SQL"] != DBNull.Value) sys_Config_ListPage.M_SQL = Convert.ToString(dr["M_SQL"]);
if (dr["M_Type"] != DBNull.Value) sys_Config_ListPage.M_Type = Convert.ToString(dr["M_Type"]);
if (dr["M_Title"] != DBNull.Value) sys_Config_ListPage.M_Title = Convert.ToString(dr["M_Title"]);
if (dr["M_AutoWidth"] != DBNull.Value) sys_Config_ListPage.M_AutoWidth = Convert.ToString(dr["M_AutoWidth"]);
if (dr["M_Width"] != DBNull.Value) sys_Config_ListPage.M_Width = Convert.ToString(dr["M_Width"]);
if (dr["M_Height"] != DBNull.Value) sys_Config_ListPage.M_Height = Convert.ToString(dr["M_Height"]);
if (dr["M_URL"] != DBNull.Value) sys_Config_ListPage.M_URL = Convert.ToString(dr["M_URL"]);
if (dr["M_MType"] != DBNull.Value) sys_Config_ListPage.M_MType = Convert.ToString(dr["M_MType"]);
if (dr["M_GetDataType"] != DBNull.Value) sys_Config_ListPage.M_GetDataType = Convert.ToString(dr["M_GetDataType"]);
if (dr["M_SQLParameter"] != DBNull.Value) sys_Config_ListPage.M_SQLParameter = Convert.ToString(dr["M_SQLParameter"]);
if (dr["M_RowNum"] != DBNull.Value) sys_Config_ListPage.M_RowNum = Convert.ToString(dr["M_RowNum"]);
if (dr["M_RowList"] != DBNull.Value) sys_Config_ListPage.M_RowList = Convert.ToString(dr["M_RowList"]);
if (dr["M_FooterRow"] != DBNull.Value) sys_Config_ListPage.M_FooterRow = Convert.ToString(dr["M_FooterRow"]);
if (dr["M_ViewURL"] != DBNull.Value) sys_Config_ListPage.M_ViewURL = Convert.ToString(dr["M_ViewURL"]);
if (dr["M_ViewType"] != DBNull.Value) sys_Config_ListPage.M_ViewType = Convert.ToString(dr["M_ViewType"]);
if (dr["M_Edit"] != DBNull.Value) sys_Config_ListPage.M_Edit = Convert.ToString(dr["M_Edit"]);
if (dr["M_EditUrl"] != DBNull.Value) sys_Config_ListPage.M_EditUrl = Convert.ToString(dr["M_EditUrl"]);
if (dr["M_EditSubmitUrl"] != DBNull.Value) sys_Config_ListPage.M_EditSubmitUrl = Convert.ToString(dr["M_EditSubmitUrl"]);
if (dr["M_OnSelectRow"] != DBNull.Value) sys_Config_ListPage.M_OnSelectRow = Convert.ToString(dr["M_OnSelectRow"]);
if (dr["M_GridComplete"] != DBNull.Value) sys_Config_ListPage.M_GridComplete = Convert.ToString(dr["M_GridComplete"]);
if (dr["M_InlineEditing"] != DBNull.Value) sys_Config_ListPage.M_InlineEditing = Convert.ToString(dr["M_InlineEditing"]);
if (dr["M_ImportURL"] != DBNull.Value) sys_Config_ListPage.M_ImportURL = Convert.ToString(dr["M_ImportURL"]);
if (dr["M_ImportTable"] != DBNull.Value) sys_Config_ListPage.M_ImportTable = Convert.ToString(dr["M_ImportTable"]);
if (dr["M_ImportExport"] != DBNull.Value) sys_Config_ListPage.M_ImportExport = Convert.ToString(dr["M_ImportExport"]);
if (dr["M_AltRows"] != DBNull.Value) sys_Config_ListPage.M_AltRows = Convert.ToString(dr["M_AltRows"]);
if (dr["M_Altclass"] != DBNull.Value) sys_Config_ListPage.M_Altclass = Convert.ToString(dr["M_Altclass"]);
if (dr["M_emptyrecords"] != DBNull.Value) sys_Config_ListPage.M_emptyrecords = Convert.ToString(dr["M_emptyrecords"]);
if (dr["M_Gridstate"] != DBNull.Value) sys_Config_ListPage.M_Gridstate = Convert.ToString(dr["M_Gridstate"]);
if (dr["M_EditCloumNum"] != DBNull.Value) sys_Config_ListPage.M_EditCloumNum = Convert.ToInt32(dr["M_EditCloumNum"]);
if (dr["M_ToolBar"] != DBNull.Value) sys_Config_ListPage.M_ToolBar = Convert.ToString(dr["M_ToolBar"]);
if (dr["M_ToolBarExtend"] != DBNull.Value) sys_Config_ListPage.M_ToolBarExtend = Convert.ToString(dr["M_ToolBarExtend"]);
if (dr["Stat"] != DBNull.Value) sys_Config_ListPage.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["M_ExtendsJs"] != DBNull.Value) sys_Config_ListPage.M_ExtendsJs = Convert.ToString(dr["M_ExtendsJs"]);
if (dr["M_ExtendsControl"] != DBNull.Value) sys_Config_ListPage.M_ExtendsControl = Convert.ToString(dr["M_ExtendsControl"]);
if (dr["M_EditTitle"] != DBNull.Value) sys_Config_ListPage.M_EditTitle = Convert.ToString(dr["M_EditTitle"]);
if (dr["M_MSelect"] != DBNull.Value) sys_Config_ListPage.M_MSelect = Convert.ToString(dr["M_MSelect"]);
if (dr["M_Parameters"] != DBNull.Value) sys_Config_ListPage.M_Parameters = Convert.ToString(dr["M_Parameters"]);
if (dr["M_GroupingView"] != DBNull.Value) sys_Config_ListPage.M_GroupingView = Convert.ToString(dr["M_GroupingView"]);
if (dr["M_FormEditing"] != DBNull.Value) sys_Config_ListPage.M_FormEditing = Convert.ToString(dr["M_FormEditing"]);
if (dr["M_FormMethod"] != DBNull.Value) sys_Config_ListPage.M_FormMethod = Convert.ToString(dr["M_FormMethod"]);
if (dr["M_IsAdd"] != DBNull.Value) sys_Config_ListPage.M_IsAdd = Convert.ToInt32(dr["M_IsAdd"]);
if (dr["M_IsEdit"] != DBNull.Value) sys_Config_ListPage.M_IsEdit = Convert.ToInt32(dr["M_IsEdit"]);
if (dr["M_IsDelete"] != DBNull.Value) sys_Config_ListPage.M_IsDelete = Convert.ToInt32(dr["M_IsDelete"]);
if (dr["M_IsView"] != DBNull.Value) sys_Config_ListPage.M_IsView = Convert.ToString(dr["M_IsView"]);
ret.Add(sys_Config_ListPage);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return ret;
}
/// <summary>
/// 添加List报表类型配置表 Sys_Config_ListPage对象(即:一条记录)
/// </summary>
public object AddWithReturn(Sys_Config_ListPage sys_Config_ListPage)
{
string sql = "INSERT INTO Sys_Config_ListPage (M_ModuleCode,M_TableName,M_NameSpace,M_SQL,M_Type,M_Title,M_AutoWidth,M_Width,M_Height,M_URL,M_MType,M_GetDataType,M_SQLParameter,M_RowNum,M_RowList,M_FooterRow,M_ViewURL,M_ViewType,M_Edit,M_EditUrl,M_EditSubmitUrl,M_OnSelectRow,M_GridComplete,M_InlineEditing,M_ImportURL,M_ImportTable,M_ImportExport,M_AltRows,M_Altclass,M_emptyrecords,M_Gridstate,M_EditCloumNum,M_ToolBar,M_ToolBarExtend,Stat,M_ExtendsJs,M_ExtendsControl,M_EditTitle,M_MSelect,M_Parameters,M_GroupingView,M_FormEditing,M_FormMethod,M_IsAdd,M_IsEdit,M_IsDelete,M_IsView) VALUES (@M_ModuleCode,@M_TableName,@M_NameSpace,@M_SQL,@M_Type,@M_Title,@M_AutoWidth,@M_Width,@M_Height,@M_URL,@M_MType,@M_GetDataType,@M_SQLParameter,@M_RowNum,@M_RowList,@M_FooterRow,@M_ViewURL,@M_ViewType,@M_Edit,@M_EditUrl,@M_EditSubmitUrl,@M_OnSelectRow,@M_GridComplete,@M_InlineEditing,@M_ImportURL,@M_ImportTable,@M_ImportExport,@M_AltRows,@M_Altclass,@M_emptyrecords,@M_Gridstate,@M_EditCloumNum,@M_ToolBar,@M_ToolBarExtend,@Stat,@M_ExtendsJs,@M_ExtendsControl,@M_EditTitle,@M_MSelect,@M_Parameters,@M_GroupingView,@M_FormEditing,@M_FormMethod,@M_IsAdd,@M_IsEdit,@M_IsDelete,@M_IsView);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ModuleCode))
{
idb.AddParameter("@M_ModuleCode", DBNull.Value);
}
else
{
idb.AddParameter("@M_ModuleCode", sys_Config_ListPage.M_ModuleCode);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_TableName))
{
idb.AddParameter("@M_TableName", DBNull.Value);
}
else
{
idb.AddParameter("@M_TableName", sys_Config_ListPage.M_TableName);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_NameSpace))
{
idb.AddParameter("@M_NameSpace", DBNull.Value);
}
else
{
idb.AddParameter("@M_NameSpace", sys_Config_ListPage.M_NameSpace);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQL))
{
idb.AddParameter("@M_SQL", DBNull.Value);
}
else
{
idb.AddParameter("@M_SQL", sys_Config_ListPage.M_SQL);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Type))
{
idb.AddParameter("@M_Type", DBNull.Value);
}
else
{
idb.AddParameter("@M_Type", sys_Config_ListPage.M_Type);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Title))
{
idb.AddParameter("@M_Title", DBNull.Value);
}
else
{
idb.AddParameter("@M_Title", sys_Config_ListPage.M_Title);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_AutoWidth))
{
idb.AddParameter("@M_AutoWidth", DBNull.Value);
}
else
{
idb.AddParameter("@M_AutoWidth", sys_Config_ListPage.M_AutoWidth);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Width))
{
idb.AddParameter("@M_Width", DBNull.Value);
}
else
{
idb.AddParameter("@M_Width", sys_Config_ListPage.M_Width);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Height))
{
idb.AddParameter("@M_Height", DBNull.Value);
}
else
{
idb.AddParameter("@M_Height", sys_Config_ListPage.M_Height);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_URL))
{
idb.AddParameter("@M_URL", DBNull.Value);
}
else
{
idb.AddParameter("@M_URL", sys_Config_ListPage.M_URL);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_MType))
{
idb.AddParameter("@M_MType", DBNull.Value);
}
else
{
idb.AddParameter("@M_MType", sys_Config_ListPage.M_MType);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_GetDataType))
{
idb.AddParameter("@M_GetDataType", DBNull.Value);
}
else
{
idb.AddParameter("@M_GetDataType", sys_Config_ListPage.M_GetDataType);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQLParameter))
{
idb.AddParameter("@M_SQLParameter", DBNull.Value);
}
else
{
idb.AddParameter("@M_SQLParameter", sys_Config_ListPage.M_SQLParameter);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowNum))
{
idb.AddParameter("@M_RowNum", DBNull.Value);
}
else
{
idb.AddParameter("@M_RowNum", sys_Config_ListPage.M_RowNum);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowList))
{
idb.AddParameter("@M_RowList", DBNull.Value);
}
else
{
idb.AddParameter("@M_RowList", sys_Config_ListPage.M_RowList);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_FooterRow))
{
idb.AddParameter("@M_FooterRow", DBNull.Value);
}
else
{
idb.AddParameter("@M_FooterRow", sys_Config_ListPage.M_FooterRow);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewURL))
{
idb.AddParameter("@M_ViewURL", DBNull.Value);
}
else
{
idb.AddParameter("@M_ViewURL", sys_Config_ListPage.M_ViewURL);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewType))
{
idb.AddParameter("@M_ViewType", DBNull.Value);
}
else
{
idb.AddParameter("@M_ViewType", sys_Config_ListPage.M_ViewType);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Edit))
{
idb.AddParameter("@M_Edit", DBNull.Value);
}
else
{
idb.AddParameter("@M_Edit", sys_Config_ListPage.M_Edit);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditUrl))
{
idb.AddParameter("@M_EditUrl", DBNull.Value);
}
else
{
idb.AddParameter("@M_EditUrl", sys_Config_ListPage.M_EditUrl);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditSubmitUrl))
{
idb.AddParameter("@M_EditSubmitUrl", DBNull.Value);
}
else
{
idb.AddParameter("@M_EditSubmitUrl", sys_Config_ListPage.M_EditSubmitUrl);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_OnSelectRow))
{
idb.AddParameter("@M_OnSelectRow", DBNull.Value);
}
else
{
idb.AddParameter("@M_OnSelectRow", sys_Config_ListPage.M_OnSelectRow);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_GridComplete))
{
idb.AddParameter("@M_GridComplete", DBNull.Value);
}
else
{
idb.AddParameter("@M_GridComplete", sys_Config_ListPage.M_GridComplete);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_InlineEditing))
{
idb.AddParameter("@M_InlineEditing", DBNull.Value);
}
else
{
idb.AddParameter("@M_InlineEditing", sys_Config_ListPage.M_InlineEditing);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportURL))
{
idb.AddParameter("@M_ImportURL", DBNull.Value);
}
else
{
idb.AddParameter("@M_ImportURL", sys_Config_ListPage.M_ImportURL);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportTable))
{
idb.AddParameter("@M_ImportTable", DBNull.Value);
}
else
{
idb.AddParameter("@M_ImportTable", sys_Config_ListPage.M_ImportTable);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportExport))
{
idb.AddParameter("@M_ImportExport", DBNull.Value);
}
else
{
idb.AddParameter("@M_ImportExport", sys_Config_ListPage.M_ImportExport);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_AltRows))
{
idb.AddParameter("@M_AltRows", DBNull.Value);
}
else
{
idb.AddParameter("@M_AltRows", sys_Config_ListPage.M_AltRows);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Altclass))
{
idb.AddParameter("@M_Altclass", DBNull.Value);
}
else
{
idb.AddParameter("@M_Altclass", sys_Config_ListPage.M_Altclass);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_emptyrecords))
{
idb.AddParameter("@M_emptyrecords", DBNull.Value);
}
else
{
idb.AddParameter("@M_emptyrecords", sys_Config_ListPage.M_emptyrecords);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Gridstate))
{
idb.AddParameter("@M_Gridstate", DBNull.Value);
}
else
{
idb.AddParameter("@M_Gridstate", sys_Config_ListPage.M_Gridstate);
}
if (sys_Config_ListPage.M_EditCloumNum == 0)
{
idb.AddParameter("@M_EditCloumNum", 0);
}
else
{
idb.AddParameter("@M_EditCloumNum", sys_Config_ListPage.M_EditCloumNum);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBar))
{
idb.AddParameter("@M_ToolBar", DBNull.Value);
}
else
{
idb.AddParameter("@M_ToolBar", sys_Config_ListPage.M_ToolBar);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBarExtend))
{
idb.AddParameter("@M_ToolBarExtend", DBNull.Value);
}
else
{
idb.AddParameter("@M_ToolBarExtend", sys_Config_ListPage.M_ToolBarExtend);
}
if (sys_Config_ListPage.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Config_ListPage.Stat);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsJs))
{
idb.AddParameter("@M_ExtendsJs", DBNull.Value);
}
else
{
idb.AddParameter("@M_ExtendsJs", sys_Config_ListPage.M_ExtendsJs);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsControl))
{
idb.AddParameter("@M_ExtendsControl", DBNull.Value);
}
else
{
idb.AddParameter("@M_ExtendsControl", sys_Config_ListPage.M_ExtendsControl);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditTitle))
{
idb.AddParameter("@M_EditTitle", DBNull.Value);
}
else
{
idb.AddParameter("@M_EditTitle", sys_Config_ListPage.M_EditTitle);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_MSelect))
{
idb.AddParameter("@M_MSelect", DBNull.Value);
}
else
{
idb.AddParameter("@M_MSelect", sys_Config_ListPage.M_MSelect);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Parameters))
{
idb.AddParameter("@M_Parameters", DBNull.Value);
}
else
{
idb.AddParameter("@M_Parameters", sys_Config_ListPage.M_Parameters);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_GroupingView))
{
idb.AddParameter("@M_GroupingView", DBNull.Value);
}
else
{
idb.AddParameter("@M_GroupingView", sys_Config_ListPage.M_GroupingView);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormEditing))
{
idb.AddParameter("@M_FormEditing", DBNull.Value);
}
else
{
idb.AddParameter("@M_FormEditing", sys_Config_ListPage.M_FormEditing);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormMethod))
{
idb.AddParameter("@M_FormMethod", DBNull.Value);
}
else
{
idb.AddParameter("@M_FormMethod", sys_Config_ListPage.M_FormMethod);
}
if (sys_Config_ListPage.M_IsAdd == 0)
{
idb.AddParameter("@M_IsAdd", 0);
}
else
{
idb.AddParameter("@M_IsAdd", sys_Config_ListPage.M_IsAdd);
}
if (sys_Config_ListPage.M_IsEdit == 0)
{
idb.AddParameter("@M_IsEdit", 0);
}
else
{
idb.AddParameter("@M_IsEdit", sys_Config_ListPage.M_IsEdit);
}
if (sys_Config_ListPage.M_IsDelete == 0)
{
idb.AddParameter("@M_IsDelete", 0);
}
else
{
idb.AddParameter("@M_IsDelete", sys_Config_ListPage.M_IsDelete);
}
if (string.IsNullOrEmpty(sys_Config_ListPage.M_IsView))
{
idb.AddParameter("@M_IsView", DBNull.Value);
}
else
{
idb.AddParameter("@M_IsView", sys_Config_ListPage.M_IsView);
}
return idb.ReturnValue(sql);
}
/// <summary>
/// 更新List报表类型配置表 Sys_Config_ListPage对象(即:一条记录
/// </summary>
public int Update(Sys_Config_ListPage sys_Config_ListPage)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE Sys_Config_ListPage SET ");
if(sys_Config_ListPage.M_ModuleCode_IsChanged){sbParameter.Append("M_ModuleCode=@M_ModuleCode, ");}
if(sys_Config_ListPage.M_TableName_IsChanged){sbParameter.Append("M_TableName=@M_TableName, ");}
if(sys_Config_ListPage.M_NameSpace_IsChanged){sbParameter.Append("M_NameSpace=@M_NameSpace, ");}
if(sys_Config_ListPage.M_SQL_IsChanged){sbParameter.Append("M_SQL=@M_SQL, ");}
if(sys_Config_ListPage.M_Type_IsChanged){sbParameter.Append("M_Type=@M_Type, ");}
if(sys_Config_ListPage.M_Title_IsChanged){sbParameter.Append("M_Title=@M_Title, ");}
if(sys_Config_ListPage.M_AutoWidth_IsChanged){sbParameter.Append("M_AutoWidth=@M_AutoWidth, ");}
if(sys_Config_ListPage.M_Width_IsChanged){sbParameter.Append("M_Width=@M_Width, ");}
if(sys_Config_ListPage.M_Height_IsChanged){sbParameter.Append("M_Height=@M_Height, ");}
if(sys_Config_ListPage.M_URL_IsChanged){sbParameter.Append("M_URL=@M_URL, ");}
if(sys_Config_ListPage.M_MType_IsChanged){sbParameter.Append("M_MType=@M_MType, ");}
if(sys_Config_ListPage.M_GetDataType_IsChanged){sbParameter.Append("M_GetDataType=@M_GetDataType, ");}
if(sys_Config_ListPage.M_SQLParameter_IsChanged){sbParameter.Append("M_SQLParameter=@M_SQLParameter, ");}
if(sys_Config_ListPage.M_RowNum_IsChanged){sbParameter.Append("M_RowNum=@M_RowNum, ");}
if(sys_Config_ListPage.M_RowList_IsChanged){sbParameter.Append("M_RowList=@M_RowList, ");}
if(sys_Config_ListPage.M_FooterRow_IsChanged){sbParameter.Append("M_FooterRow=@M_FooterRow, ");}
if(sys_Config_ListPage.M_ViewURL_IsChanged){sbParameter.Append("M_ViewURL=@M_ViewURL, ");}
if(sys_Config_ListPage.M_ViewType_IsChanged){sbParameter.Append("M_ViewType=@M_ViewType, ");}
if(sys_Config_ListPage.M_Edit_IsChanged){sbParameter.Append("M_Edit=@M_Edit, ");}
if(sys_Config_ListPage.M_EditUrl_IsChanged){sbParameter.Append("M_EditUrl=@M_EditUrl, ");}
if(sys_Config_ListPage.M_EditSubmitUrl_IsChanged){sbParameter.Append("M_EditSubmitUrl=@M_EditSubmitUrl, ");}
if(sys_Config_ListPage.M_OnSelectRow_IsChanged){sbParameter.Append("M_OnSelectRow=@M_OnSelectRow, ");}
if(sys_Config_ListPage.M_GridComplete_IsChanged){sbParameter.Append("M_GridComplete=@M_GridComplete, ");}
if(sys_Config_ListPage.M_InlineEditing_IsChanged){sbParameter.Append("M_InlineEditing=@M_InlineEditing, ");}
if(sys_Config_ListPage.M_ImportURL_IsChanged){sbParameter.Append("M_ImportURL=@M_ImportURL, ");}
if(sys_Config_ListPage.M_ImportTable_IsChanged){sbParameter.Append("M_ImportTable=@M_ImportTable, ");}
if(sys_Config_ListPage.M_ImportExport_IsChanged){sbParameter.Append("M_ImportExport=@M_ImportExport, ");}
if(sys_Config_ListPage.M_AltRows_IsChanged){sbParameter.Append("M_AltRows=@M_AltRows, ");}
if(sys_Config_ListPage.M_Altclass_IsChanged){sbParameter.Append("M_Altclass=@M_Altclass, ");}
if(sys_Config_ListPage.M_emptyrecords_IsChanged){sbParameter.Append("M_emptyrecords=@M_emptyrecords, ");}
if(sys_Config_ListPage.M_Gridstate_IsChanged){sbParameter.Append("M_Gridstate=@M_Gridstate, ");}
if(sys_Config_ListPage.M_EditCloumNum_IsChanged){sbParameter.Append("M_EditCloumNum=@M_EditCloumNum, ");}
if(sys_Config_ListPage.M_ToolBar_IsChanged){sbParameter.Append("M_ToolBar=@M_ToolBar, ");}
if(sys_Config_ListPage.M_ToolBarExtend_IsChanged){sbParameter.Append("M_ToolBarExtend=@M_ToolBarExtend, ");}
if(sys_Config_ListPage.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(sys_Config_ListPage.M_ExtendsJs_IsChanged){sbParameter.Append("M_ExtendsJs=@M_ExtendsJs, ");}
if(sys_Config_ListPage.M_ExtendsControl_IsChanged){sbParameter.Append("M_ExtendsControl=@M_ExtendsControl, ");}
if(sys_Config_ListPage.M_EditTitle_IsChanged){sbParameter.Append("M_EditTitle=@M_EditTitle, ");}
if(sys_Config_ListPage.M_MSelect_IsChanged){sbParameter.Append("M_MSelect=@M_MSelect, ");}
if(sys_Config_ListPage.M_Parameters_IsChanged){sbParameter.Append("M_Parameters=@M_Parameters, ");}
if(sys_Config_ListPage.M_GroupingView_IsChanged){sbParameter.Append("M_GroupingView=@M_GroupingView, ");}
if(sys_Config_ListPage.M_FormEditing_IsChanged){sbParameter.Append("M_FormEditing=@M_FormEditing, ");}
if(sys_Config_ListPage.M_FormMethod_IsChanged){sbParameter.Append("M_FormMethod=@M_FormMethod, ");}
if(sys_Config_ListPage.M_IsAdd_IsChanged){sbParameter.Append("M_IsAdd=@M_IsAdd, ");}
if(sys_Config_ListPage.M_IsEdit_IsChanged){sbParameter.Append("M_IsEdit=@M_IsEdit, ");}
if(sys_Config_ListPage.M_IsDelete_IsChanged){sbParameter.Append("M_IsDelete=@M_IsDelete, ");}
if(sys_Config_ListPage.M_IsView_IsChanged){sbParameter.Append("M_IsView=@M_IsView ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and M_ID=@M_ID; " );
string sql=sb.ToString();
if(sys_Config_ListPage.M_ModuleCode_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ModuleCode))
{
idb.AddParameter("@M_ModuleCode", DBNull.Value);
}
else
{
idb.AddParameter("@M_ModuleCode", sys_Config_ListPage.M_ModuleCode);
}
}
if(sys_Config_ListPage.M_TableName_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_TableName))
{
idb.AddParameter("@M_TableName", DBNull.Value);
}
else
{
idb.AddParameter("@M_TableName", sys_Config_ListPage.M_TableName);
}
}
if(sys_Config_ListPage.M_NameSpace_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_NameSpace))
{
idb.AddParameter("@M_NameSpace", DBNull.Value);
}
else
{
idb.AddParameter("@M_NameSpace", sys_Config_ListPage.M_NameSpace);
}
}
if(sys_Config_ListPage.M_SQL_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQL))
{
idb.AddParameter("@M_SQL", DBNull.Value);
}
else
{
idb.AddParameter("@M_SQL", sys_Config_ListPage.M_SQL);
}
}
if(sys_Config_ListPage.M_Type_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Type))
{
idb.AddParameter("@M_Type", DBNull.Value);
}
else
{
idb.AddParameter("@M_Type", sys_Config_ListPage.M_Type);
}
}
if(sys_Config_ListPage.M_Title_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Title))
{
idb.AddParameter("@M_Title", DBNull.Value);
}
else
{
idb.AddParameter("@M_Title", sys_Config_ListPage.M_Title);
}
}
if(sys_Config_ListPage.M_AutoWidth_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_AutoWidth))
{
idb.AddParameter("@M_AutoWidth", DBNull.Value);
}
else
{
idb.AddParameter("@M_AutoWidth", sys_Config_ListPage.M_AutoWidth);
}
}
if(sys_Config_ListPage.M_Width_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Width))
{
idb.AddParameter("@M_Width", DBNull.Value);
}
else
{
idb.AddParameter("@M_Width", sys_Config_ListPage.M_Width);
}
}
if(sys_Config_ListPage.M_Height_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Height))
{
idb.AddParameter("@M_Height", DBNull.Value);
}
else
{
idb.AddParameter("@M_Height", sys_Config_ListPage.M_Height);
}
}
if(sys_Config_ListPage.M_URL_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_URL))
{
idb.AddParameter("@M_URL", DBNull.Value);
}
else
{
idb.AddParameter("@M_URL", sys_Config_ListPage.M_URL);
}
}
if(sys_Config_ListPage.M_MType_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_MType))
{
idb.AddParameter("@M_MType", DBNull.Value);
}
else
{
idb.AddParameter("@M_MType", sys_Config_ListPage.M_MType);
}
}
if(sys_Config_ListPage.M_GetDataType_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_GetDataType))
{
idb.AddParameter("@M_GetDataType", DBNull.Value);
}
else
{
idb.AddParameter("@M_GetDataType", sys_Config_ListPage.M_GetDataType);
}
}
if(sys_Config_ListPage.M_SQLParameter_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQLParameter))
{
idb.AddParameter("@M_SQLParameter", DBNull.Value);
}
else
{
idb.AddParameter("@M_SQLParameter", sys_Config_ListPage.M_SQLParameter);
}
}
if(sys_Config_ListPage.M_RowNum_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowNum))
{
idb.AddParameter("@M_RowNum", DBNull.Value);
}
else
{
idb.AddParameter("@M_RowNum", sys_Config_ListPage.M_RowNum);
}
}
if(sys_Config_ListPage.M_RowList_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowList))
{
idb.AddParameter("@M_RowList", DBNull.Value);
}
else
{
idb.AddParameter("@M_RowList", sys_Config_ListPage.M_RowList);
}
}
if(sys_Config_ListPage.M_FooterRow_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_FooterRow))
{
idb.AddParameter("@M_FooterRow", DBNull.Value);
}
else
{
idb.AddParameter("@M_FooterRow", sys_Config_ListPage.M_FooterRow);
}
}
if(sys_Config_ListPage.M_ViewURL_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewURL))
{
idb.AddParameter("@M_ViewURL", DBNull.Value);
}
else
{
idb.AddParameter("@M_ViewURL", sys_Config_ListPage.M_ViewURL);
}
}
if(sys_Config_ListPage.M_ViewType_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewType))
{
idb.AddParameter("@M_ViewType", DBNull.Value);
}
else
{
idb.AddParameter("@M_ViewType", sys_Config_ListPage.M_ViewType);
}
}
if(sys_Config_ListPage.M_Edit_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Edit))
{
idb.AddParameter("@M_Edit", DBNull.Value);
}
else
{
idb.AddParameter("@M_Edit", sys_Config_ListPage.M_Edit);
}
}
if(sys_Config_ListPage.M_EditUrl_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditUrl))
{
idb.AddParameter("@M_EditUrl", DBNull.Value);
}
else
{
idb.AddParameter("@M_EditUrl", sys_Config_ListPage.M_EditUrl);
}
}
if(sys_Config_ListPage.M_EditSubmitUrl_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditSubmitUrl))
{
idb.AddParameter("@M_EditSubmitUrl", DBNull.Value);
}
else
{
idb.AddParameter("@M_EditSubmitUrl", sys_Config_ListPage.M_EditSubmitUrl);
}
}
if(sys_Config_ListPage.M_OnSelectRow_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_OnSelectRow))
{
idb.AddParameter("@M_OnSelectRow", DBNull.Value);
}
else
{
idb.AddParameter("@M_OnSelectRow", sys_Config_ListPage.M_OnSelectRow);
}
}
if(sys_Config_ListPage.M_GridComplete_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_GridComplete))
{
idb.AddParameter("@M_GridComplete", DBNull.Value);
}
else
{
idb.AddParameter("@M_GridComplete", sys_Config_ListPage.M_GridComplete);
}
}
if(sys_Config_ListPage.M_InlineEditing_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_InlineEditing))
{
idb.AddParameter("@M_InlineEditing", DBNull.Value);
}
else
{
idb.AddParameter("@M_InlineEditing", sys_Config_ListPage.M_InlineEditing);
}
}
if(sys_Config_ListPage.M_ImportURL_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportURL))
{
idb.AddParameter("@M_ImportURL", DBNull.Value);
}
else
{
idb.AddParameter("@M_ImportURL", sys_Config_ListPage.M_ImportURL);
}
}
if(sys_Config_ListPage.M_ImportTable_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportTable))
{
idb.AddParameter("@M_ImportTable", DBNull.Value);
}
else
{
idb.AddParameter("@M_ImportTable", sys_Config_ListPage.M_ImportTable);
}
}
if(sys_Config_ListPage.M_ImportExport_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportExport))
{
idb.AddParameter("@M_ImportExport", DBNull.Value);
}
else
{
idb.AddParameter("@M_ImportExport", sys_Config_ListPage.M_ImportExport);
}
}
if(sys_Config_ListPage.M_AltRows_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_AltRows))
{
idb.AddParameter("@M_AltRows", DBNull.Value);
}
else
{
idb.AddParameter("@M_AltRows", sys_Config_ListPage.M_AltRows);
}
}
if(sys_Config_ListPage.M_Altclass_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Altclass))
{
idb.AddParameter("@M_Altclass", DBNull.Value);
}
else
{
idb.AddParameter("@M_Altclass", sys_Config_ListPage.M_Altclass);
}
}
if(sys_Config_ListPage.M_emptyrecords_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_emptyrecords))
{
idb.AddParameter("@M_emptyrecords", DBNull.Value);
}
else
{
idb.AddParameter("@M_emptyrecords", sys_Config_ListPage.M_emptyrecords);
}
}
if(sys_Config_ListPage.M_Gridstate_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Gridstate))
{
idb.AddParameter("@M_Gridstate", DBNull.Value);
}
else
{
idb.AddParameter("@M_Gridstate", sys_Config_ListPage.M_Gridstate);
}
}
if(sys_Config_ListPage.M_EditCloumNum_IsChanged)
{
if (sys_Config_ListPage.M_EditCloumNum == 0)
{
idb.AddParameter("@M_EditCloumNum", 0);
}
else
{
idb.AddParameter("@M_EditCloumNum", sys_Config_ListPage.M_EditCloumNum);
}
}
if(sys_Config_ListPage.M_ToolBar_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBar))
{
idb.AddParameter("@M_ToolBar", DBNull.Value);
}
else
{
idb.AddParameter("@M_ToolBar", sys_Config_ListPage.M_ToolBar);
}
}
if(sys_Config_ListPage.M_ToolBarExtend_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBarExtend))
{
idb.AddParameter("@M_ToolBarExtend", DBNull.Value);
}
else
{
idb.AddParameter("@M_ToolBarExtend", sys_Config_ListPage.M_ToolBarExtend);
}
}
if(sys_Config_ListPage.Stat_IsChanged)
{
if (sys_Config_ListPage.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Config_ListPage.Stat);
}
}
if(sys_Config_ListPage.M_ExtendsJs_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsJs))
{
idb.AddParameter("@M_ExtendsJs", DBNull.Value);
}
else
{
idb.AddParameter("@M_ExtendsJs", sys_Config_ListPage.M_ExtendsJs);
}
}
if(sys_Config_ListPage.M_ExtendsControl_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsControl))
{
idb.AddParameter("@M_ExtendsControl", DBNull.Value);
}
else
{
idb.AddParameter("@M_ExtendsControl", sys_Config_ListPage.M_ExtendsControl);
}
}
if(sys_Config_ListPage.M_EditTitle_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditTitle))
{
idb.AddParameter("@M_EditTitle", DBNull.Value);
}
else
{
idb.AddParameter("@M_EditTitle", sys_Config_ListPage.M_EditTitle);
}
}
if(sys_Config_ListPage.M_MSelect_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_MSelect))
{
idb.AddParameter("@M_MSelect", DBNull.Value);
}
else
{
idb.AddParameter("@M_MSelect", sys_Config_ListPage.M_MSelect);
}
}
if(sys_Config_ListPage.M_Parameters_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_Parameters))
{
idb.AddParameter("@M_Parameters", DBNull.Value);
}
else
{
idb.AddParameter("@M_Parameters", sys_Config_ListPage.M_Parameters);
}
}
if(sys_Config_ListPage.M_GroupingView_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_GroupingView))
{
idb.AddParameter("@M_GroupingView", DBNull.Value);
}
else
{
idb.AddParameter("@M_GroupingView", sys_Config_ListPage.M_GroupingView);
}
}
if(sys_Config_ListPage.M_FormEditing_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormEditing))
{
idb.AddParameter("@M_FormEditing", DBNull.Value);
}
else
{
idb.AddParameter("@M_FormEditing", sys_Config_ListPage.M_FormEditing);
}
}
if(sys_Config_ListPage.M_FormMethod_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormMethod))
{
idb.AddParameter("@M_FormMethod", DBNull.Value);
}
else
{
idb.AddParameter("@M_FormMethod", sys_Config_ListPage.M_FormMethod);
}
}
if(sys_Config_ListPage.M_IsAdd_IsChanged)
{
if (sys_Config_ListPage.M_IsAdd == 0)
{
idb.AddParameter("@M_IsAdd", 0);
}
else
{
idb.AddParameter("@M_IsAdd", sys_Config_ListPage.M_IsAdd);
}
}
if(sys_Config_ListPage.M_IsEdit_IsChanged)
{
if (sys_Config_ListPage.M_IsEdit == 0)
{
idb.AddParameter("@M_IsEdit", 0);
}
else
{
idb.AddParameter("@M_IsEdit", sys_Config_ListPage.M_IsEdit);
}
}
if(sys_Config_ListPage.M_IsDelete_IsChanged)
{
if (sys_Config_ListPage.M_IsDelete == 0)
{
idb.AddParameter("@M_IsDelete", 0);
}
else
{
idb.AddParameter("@M_IsDelete", sys_Config_ListPage.M_IsDelete);
}
}
if(sys_Config_ListPage.M_IsView_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_ListPage.M_IsView))
{
idb.AddParameter("@M_IsView", DBNull.Value);
}
else
{
idb.AddParameter("@M_IsView", sys_Config_ListPage.M_IsView);
}
}
idb.AddParameter("@M_ID", sys_Config_ListPage.M_ID);
return idb.ExeCmd(sql);