/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Sys_Config_Refer model)
{
bool result = false;
var e = new ModelExceptions();
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_Refer 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='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_Config_Refer GetModel(string strCondition)
{
List <Sys_Config_Refer> list = instance.GetListByWhere(strCondition);
Sys_Config_Refer model = new Sys_Config_Refer();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return(model);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Sys_Config_Refer 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 Update(Sys_Config_Refer model)
//{
// bool result = false;
// var e = new ModelExceptions();
// int _rseult = instance.Update(model);
// if (_rseult > 0)
// {
// result = true;
// }
// return result;
//}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
//public bool Update(Sys_Config_Refer 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'>model</param>
/// <returns>bool</returns>
public bool Delete(string Condition)
{
bool result = false;
List <Sys_Config_Refer> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
Sys_Config_Refer model = list[0];
model.Stat = 1;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(Sys_Config_Refer model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 获取所有的通用参考主表 Sys_Config_Refer对象(即:一条记录
/// </summary>
public List <Sys_Config_Refer> GetAll()
{
List <Sys_Config_Refer> ret = new List <Sys_Config_Refer>();
string sql = "SELECT R_ID,R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url FROM Sys_Config_Refer where 1=1 AND ((Stat is null) or (Stat=0) ) order by R_ID desc ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Sys_Config_Refer sys_Config_Refer = new Sys_Config_Refer();
if (dr["R_ID"] != DBNull.Value)
{
sys_Config_Refer.R_ID = Convert.ToDecimal(dr["R_ID"]);
}
if (dr["R_ModuleName"] != DBNull.Value)
{
sys_Config_Refer.R_ModuleName = Convert.ToString(dr["R_ModuleName"]);
}
if (dr["R_NameSpace"] != DBNull.Value)
{
sys_Config_Refer.R_NameSpace = Convert.ToString(dr["R_NameSpace"]);
}
if (dr["R_Title"] != DBNull.Value)
{
sys_Config_Refer.R_Title = Convert.ToString(dr["R_Title"]);
}
if (dr["R_Width"] != DBNull.Value)
{
sys_Config_Refer.R_Width = Convert.ToInt32(dr["R_Width"]);
}
if (dr["R_Height"] != DBNull.Value)
{
sys_Config_Refer.R_Height = Convert.ToInt32(dr["R_Height"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_Config_Refer.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["R_TableName"] != DBNull.Value)
{
sys_Config_Refer.R_TableName = Convert.ToString(dr["R_TableName"]);
}
if (dr["R_FilterSql"] != DBNull.Value)
{
sys_Config_Refer.R_FilterSql = Convert.ToString(dr["R_FilterSql"]);
}
if (dr["R_SQL"] != DBNull.Value)
{
sys_Config_Refer.R_SQL = Convert.ToString(dr["R_SQL"]);
}
if (dr["R_Url"] != DBNull.Value)
{
sys_Config_Refer.R_Url = Convert.ToString(dr["R_Url"]);
}
ret.Add(sys_Config_Refer);
}
}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>
/// 获取指定的通用参考主表 Sys_Config_Refer对象集合
/// </summary>
public List <Sys_Config_Refer> GetListByWhere(string strCondition)
{
List <Sys_Config_Refer> ret = new List <Sys_Config_Refer>();
string sql = "SELECT R_ID,R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url FROM Sys_Config_Refer WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY R_ID DESC ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Sys_Config_Refer sys_Config_Refer = new Sys_Config_Refer();
if (dr["R_ID"] != DBNull.Value)
{
sys_Config_Refer.R_ID = Convert.ToDecimal(dr["R_ID"]);
}
if (dr["R_ModuleName"] != DBNull.Value)
{
sys_Config_Refer.R_ModuleName = Convert.ToString(dr["R_ModuleName"]);
}
if (dr["R_NameSpace"] != DBNull.Value)
{
sys_Config_Refer.R_NameSpace = Convert.ToString(dr["R_NameSpace"]);
}
if (dr["R_Title"] != DBNull.Value)
{
sys_Config_Refer.R_Title = Convert.ToString(dr["R_Title"]);
}
if (dr["R_Width"] != DBNull.Value)
{
sys_Config_Refer.R_Width = Convert.ToInt32(dr["R_Width"]);
}
if (dr["R_Height"] != DBNull.Value)
{
sys_Config_Refer.R_Height = Convert.ToInt32(dr["R_Height"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_Config_Refer.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["R_TableName"] != DBNull.Value)
{
sys_Config_Refer.R_TableName = Convert.ToString(dr["R_TableName"]);
}
if (dr["R_FilterSql"] != DBNull.Value)
{
sys_Config_Refer.R_FilterSql = Convert.ToString(dr["R_FilterSql"]);
}
if (dr["R_SQL"] != DBNull.Value)
{
sys_Config_Refer.R_SQL = Convert.ToString(dr["R_SQL"]);
}
if (dr["R_Url"] != DBNull.Value)
{
sys_Config_Refer.R_Url = Convert.ToString(dr["R_Url"]);
}
ret.Add(sys_Config_Refer);
}
}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>
/// 获取指定的通用参考主表 Sys_Config_Refer对象(即:一条记录
/// </summary>
public Sys_Config_Refer GetByKey(decimal r_ID)
{
Sys_Config_Refer sys_Config_Refer = new Sys_Config_Refer();
string sql = "SELECT R_ID,R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url FROM Sys_Config_Refer WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND R_ID=@R_ID ";
idb.AddParameter("@R_ID", r_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["R_ID"] != DBNull.Value)
{
sys_Config_Refer.R_ID = Convert.ToDecimal(dr["R_ID"]);
}
if (dr["R_ModuleName"] != DBNull.Value)
{
sys_Config_Refer.R_ModuleName = Convert.ToString(dr["R_ModuleName"]);
}
if (dr["R_NameSpace"] != DBNull.Value)
{
sys_Config_Refer.R_NameSpace = Convert.ToString(dr["R_NameSpace"]);
}
if (dr["R_Title"] != DBNull.Value)
{
sys_Config_Refer.R_Title = Convert.ToString(dr["R_Title"]);
}
if (dr["R_Width"] != DBNull.Value)
{
sys_Config_Refer.R_Width = Convert.ToInt32(dr["R_Width"]);
}
if (dr["R_Height"] != DBNull.Value)
{
sys_Config_Refer.R_Height = Convert.ToInt32(dr["R_Height"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_Config_Refer.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["R_TableName"] != DBNull.Value)
{
sys_Config_Refer.R_TableName = Convert.ToString(dr["R_TableName"]);
}
if (dr["R_FilterSql"] != DBNull.Value)
{
sys_Config_Refer.R_FilterSql = Convert.ToString(dr["R_FilterSql"]);
}
if (dr["R_SQL"] != DBNull.Value)
{
sys_Config_Refer.R_SQL = Convert.ToString(dr["R_SQL"]);
}
if (dr["R_Url"] != DBNull.Value)
{
sys_Config_Refer.R_Url = Convert.ToString(dr["R_Url"]);
}
}
}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(sys_Config_Refer);
}
/// <summary>
/// 更新通用参考主表 Sys_Config_Refer对象(即:一条记录
/// </summary>
public int Update(Sys_Config_Refer sys_Config_Refer)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Sys_Config_Refer SET ");
if (sys_Config_Refer.R_ModuleName_IsChanged)
{
sbParameter.Append("R_ModuleName=@R_ModuleName, ");
}
if (sys_Config_Refer.R_NameSpace_IsChanged)
{
sbParameter.Append("R_NameSpace=@R_NameSpace, ");
}
if (sys_Config_Refer.R_Title_IsChanged)
{
sbParameter.Append("R_Title=@R_Title, ");
}
if (sys_Config_Refer.R_Width_IsChanged)
{
sbParameter.Append("R_Width=@R_Width, ");
}
if (sys_Config_Refer.R_Height_IsChanged)
{
sbParameter.Append("R_Height=@R_Height, ");
}
if (sys_Config_Refer.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (sys_Config_Refer.R_TableName_IsChanged)
{
sbParameter.Append("R_TableName=@R_TableName, ");
}
if (sys_Config_Refer.R_FilterSql_IsChanged)
{
sbParameter.Append("R_FilterSql=@R_FilterSql, ");
}
if (sys_Config_Refer.R_SQL_IsChanged)
{
sbParameter.Append("R_SQL=@R_SQL, ");
}
if (sys_Config_Refer.R_Url_IsChanged)
{
sbParameter.Append("R_Url=@R_Url ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and R_ID=@R_ID; ");
string sql = sb.ToString();
if (sys_Config_Refer.R_ModuleName_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_Refer.R_ModuleName))
{
idb.AddParameter("@R_ModuleName", DBNull.Value);
}
else
{
idb.AddParameter("@R_ModuleName", sys_Config_Refer.R_ModuleName);
}
}
if (sys_Config_Refer.R_NameSpace_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_Refer.R_NameSpace))
{
idb.AddParameter("@R_NameSpace", DBNull.Value);
}
else
{
idb.AddParameter("@R_NameSpace", sys_Config_Refer.R_NameSpace);
}
}
if (sys_Config_Refer.R_Title_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_Refer.R_Title))
{
idb.AddParameter("@R_Title", DBNull.Value);
}
else
{
idb.AddParameter("@R_Title", sys_Config_Refer.R_Title);
}
}
if (sys_Config_Refer.R_Width_IsChanged)
{
if (sys_Config_Refer.R_Width == 0)
{
idb.AddParameter("@R_Width", 0);
}
else
{
idb.AddParameter("@R_Width", sys_Config_Refer.R_Width);
}
}
if (sys_Config_Refer.R_Height_IsChanged)
{
if (sys_Config_Refer.R_Height == 0)
{
idb.AddParameter("@R_Height", 0);
}
else
{
idb.AddParameter("@R_Height", sys_Config_Refer.R_Height);
}
}
if (sys_Config_Refer.Stat_IsChanged)
{
if (sys_Config_Refer.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Config_Refer.Stat);
}
}
if (sys_Config_Refer.R_TableName_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_Refer.R_TableName))
{
idb.AddParameter("@R_TableName", DBNull.Value);
}
else
{
idb.AddParameter("@R_TableName", sys_Config_Refer.R_TableName);
}
}
if (sys_Config_Refer.R_FilterSql_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_Refer.R_FilterSql))
{
idb.AddParameter("@R_FilterSql", DBNull.Value);
}
else
{
idb.AddParameter("@R_FilterSql", sys_Config_Refer.R_FilterSql);
}
}
if (sys_Config_Refer.R_SQL_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_Refer.R_SQL))
{
idb.AddParameter("@R_SQL", DBNull.Value);
}
else
{
idb.AddParameter("@R_SQL", sys_Config_Refer.R_SQL);
}
}
if (sys_Config_Refer.R_Url_IsChanged)
{
if (string.IsNullOrEmpty(sys_Config_Refer.R_Url))
{
idb.AddParameter("@R_Url", DBNull.Value);
}
else
{
idb.AddParameter("@R_Url", sys_Config_Refer.R_Url);
}
}
idb.AddParameter("@R_ID", sys_Config_Refer.R_ID);
return(idb.ExeCmd(sql));
}
/// <summary>
/// 添加通用参考主表 Sys_Config_Refer对象(即:一条记录)
/// </summary>
public int Add(Sys_Config_Refer sys_Config_Refer)
{
string sql = "INSERT INTO Sys_Config_Refer (R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url) VALUES (@R_ModuleName,@R_NameSpace,@R_Title,@R_Width,@R_Height,@Stat,@R_TableName,@R_FilterSql,@R_SQL,@R_Url)";
if (string.IsNullOrEmpty(sys_Config_Refer.R_ModuleName))
{
idb.AddParameter("@R_ModuleName", DBNull.Value);
}
else
{
idb.AddParameter("@R_ModuleName", sys_Config_Refer.R_ModuleName);
}
if (string.IsNullOrEmpty(sys_Config_Refer.R_NameSpace))
{
idb.AddParameter("@R_NameSpace", DBNull.Value);
}
else
{
idb.AddParameter("@R_NameSpace", sys_Config_Refer.R_NameSpace);
}
if (string.IsNullOrEmpty(sys_Config_Refer.R_Title))
{
idb.AddParameter("@R_Title", DBNull.Value);
}
else
{
idb.AddParameter("@R_Title", sys_Config_Refer.R_Title);
}
if (sys_Config_Refer.R_Width == 0)
{
idb.AddParameter("@R_Width", 0);
}
else
{
idb.AddParameter("@R_Width", sys_Config_Refer.R_Width);
}
if (sys_Config_Refer.R_Height == 0)
{
idb.AddParameter("@R_Height", 0);
}
else
{
idb.AddParameter("@R_Height", sys_Config_Refer.R_Height);
}
if (sys_Config_Refer.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Config_Refer.Stat);
}
if (string.IsNullOrEmpty(sys_Config_Refer.R_TableName))
{
idb.AddParameter("@R_TableName", DBNull.Value);
}
else
{
idb.AddParameter("@R_TableName", sys_Config_Refer.R_TableName);
}
if (string.IsNullOrEmpty(sys_Config_Refer.R_FilterSql))
{
idb.AddParameter("@R_FilterSql", DBNull.Value);
}
else
{
idb.AddParameter("@R_FilterSql", sys_Config_Refer.R_FilterSql);
}
if (string.IsNullOrEmpty(sys_Config_Refer.R_SQL))
{
idb.AddParameter("@R_SQL", DBNull.Value);
}
else
{
idb.AddParameter("@R_SQL", sys_Config_Refer.R_SQL);
}
if (string.IsNullOrEmpty(sys_Config_Refer.R_Url))
{
idb.AddParameter("@R_Url", DBNull.Value);
}
else
{
idb.AddParameter("@R_Url", sys_Config_Refer.R_Url);
}
return(idb.ExeCmd(sql));
}
public ActionResult GetData(int page, int rows, string search, string sidx, string sord)
{
string Name = Request["name"] == null ? "" : Request["name"].ToString();
string filters = Request["filters"] == null ? "" : Request["filters"].ToString();
string filter = Request["filter"] == null ? "" : Request["filter"].ToString();
string ModuleName = Request["m"] == null ? "" : Request["m"].ToString();
string NameSpace = Request["n"] == null ? "" : Request["n"].ToString();
string filtersSql = string.Empty;
string mapSqlFilter = string.Empty;
if (!string.IsNullOrEmpty(filters))
{
filtersSql = BulidJqGridSearch.BuildSearch(filters);
}
Bll_Sys_Config_Refer configRefer = new Bll_Sys_Config_Refer();
Bll_Sys_Config_Field_Refer configReferList = new Bll_Sys_Config_Field_Refer();
Sys_Config_Refer model = configRefer.GetListByCode(" AND R_ModuleName='"
+ ModuleName + "'")[0];
var referList = configReferList.GetListByCode(" AND D_ModuleName='" + ModuleName + "'").Where(o => !string.IsNullOrEmpty(o.D_DictKey));
Bll_Bse_Dict DictInstance = new Bll_Bse_Dict();
DataTable dt = new DataTable();
if (!string.IsNullOrEmpty(model.R_SQL))
{
if (!string.IsNullOrEmpty(filter))
{
model.R_SQL = model.R_SQL + filter;
}
if (!string.IsNullOrEmpty(filtersSql))
{
model.R_SQL = model.R_SQL + " AND " + filtersSql;
}
dt = configRefer.ListBySql(model.R_SQL);
}
else
{
string _filtersql = !String.IsNullOrEmpty(model.R_FilterSql) ? model.R_FilterSql : "";
_filtersql = _filtersql + filter;
//#region 特殊映射处理
//if (ModuleName=="HR_StuffModule")
//{
// //读取映射配置表中公司配置
// Bll_Comm comm = new Bll_Comm();
// string mapFilter = "";
// var mapModel = comm.CommMap(ModuleName, "Company");
// if (mapModel!=null)
// {
// var deptList = comm.GetChildListDeptNon(comm.CommMap(ModuleName, "Company").Map_Object);
// if (deptList.Count()>0)
// {
// foreach (var item in deptList)
// {
// }
// for (int i = 0; i < deptList.Count;i++ )
// {
// if (i==(deptList.Count-1))
// {
// mapFilter += "'" + deptList[i].Dept_Code+"'";
// }
// else
// {
// mapFilter += "'" + deptList[i].Dept_Code+ "',";
// }
// }
// mapFilter.TrimEnd(',');
// }
// mapSqlFilter = " Stuff_DepCode in(" + mapFilter + ")";
// }
//}
//#endregion
//为空时不初始化
//if (!string.IsNullOrEmpty(filter))
//{
// dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter);
//}
dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter);
}
DataTable newdt = DataTablePage.GetPagedTable(dt, page, rows);
#region 字典进行转换
//对字典进行转换
for (int i = 0; i < newdt.Rows.Count; i++)
{
foreach (var item in referList.ToList())
{
var value = newdt.Rows[i][item.D_Index] != null ? newdt.Rows[i][item.D_Index].ToString() : "";
var DictResult = DictInstance.GetListByCode(" AND Dict_Code='" + value
+ "' AND Dict_Key='" + item.D_DictKey + "' ");
if (DictResult.Count > 0)
{
newdt.Rows[i][item.D_Index] = DictResult.FirstOrDefault().Dict_Name;
}
}
}
#endregion
var json = DataTablePage.JsonForJqgrid(newdt, page, rows, dt.Rows.Count);
return(JavaScript(json));
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_Config_Refer GetModel(int id)
{
Sys_Config_Refer model = instance.GetByKey(id);
return(model);
}
public static string ReferControlEx(
this HtmlHelper helper,
string ModuleName,
string NameSpace, bool Multiselect)
{
string str = string.Empty;
ADOSys_Config_Refer ReferInstance = new ADOSys_Config_Refer();
ADOSys_Config_Field_Refer DListInstance = new ADOSys_Config_Field_Refer();
if (string.IsNullOrEmpty(ModuleName) || string.IsNullOrEmpty(NameSpace))
{
return string.Empty;
}
Sys_Config_Refer MRefer = ReferInstance.GetListByWhere(" AND R_ModuleName='" +
ModuleName + "'")[0];
List<Sys_Config_Field_Refer> D_List = DListInstance.GetListByWhere(" AND D_ModuleName='" +
ModuleName + "'");
#region JqGrid Html 列表显示部分
string html = @"
<div class='Comm_Ref' id='{ModuleName}{M_NameSpace}' style='display:none'>
{ToolBar}
<div id='{M_NameSpace}search'>
</div>
<table id='{M_NameSpace}grid'' class='scroll' cellpadding='0' cellspacing='0'>
</table>
<div id='{M_NameSpace}pager' class='scroll' style='text-align: center;'>
</div>
<div style='float:right;padding-top:20px'>
<span> <input id='btnok_{M_NameSpace}' type='button' value='确定'/> <input type='button' value='关闭' onclick='{M_NameSpace}Close()'/> </span>
</div>
</div>";
#endregion
#region JqGrid Js部分
string js_header = @"<script type='text/javascript'>";
string js_footer = @"</script>";
string jsBody = @"
var {M_NameSpace}_{ModuleName}_GridControl = {
setupGrid: function(grid, pager, search, dataurl) {
grid.jqGrid({
url: dataurl,
mtype: 'post',
rowNum: 10,
rowList: [10,20,50],
pager: pager,
sortorder: 'asc',
viewrecords: true,
multiselect: {MultiSelect}, //多选时出现checkbox
width: '{M_Width}',
height: '{M_Height}',
autowidth: false,
rownumbers: true,
gridview: true,
footerrow: false,
colNames: [{M_ColNames_list}],
colModel: [{M_ColModel_List}],
gridComplete: function() {
var ids = grid.jqGrid('getDataIDs');
for (var i = 0; i < ids.length; i++) {
var cl = ids[i];
var ret = grid.jqGrid('getRowData', cl);
var operation='';
{M_GridComplete}
grid.jqGrid('setRowData', ids[i], { Edit: operation });
}
},
userDataOnFooter: true
})
},
Init: function(dataurl, targetPreFix) {
var gridobj = targetPreFix + 'grid';
var pagerobj = targetPreFix + 'pager';
var searchobj = targetPreFix + 'search';
{M_NameSpace}_{ModuleName}_GridControl.setupGrid($('#' + gridobj), $('#' + pagerobj), $('#' + searchobj), dataurl);
$('#' + gridobj).navGrid('#'+pagerobj, { refresh: false, edit: false, add: false, del: false, search:false,multipleSearch:false });
}
}
";
#endregion
string btnMJs = @"
$('#btnok_{M_NameSpace}').click(function(){
var grid = $('#{M_NameSpace}grid');
var curids = grid.getGridParam('selarrrow'); //获取选择行的id
if(curids!=''){
var ids=new Array();
var selectRows=new Array();
//selectRows.length=0;
ids=curids.toString().split(',');
for(var i=0;i<ids.length;i++){
var data = grid.getRowData(ids[i]); //获取行号为curid的数据
if(data!=null){
selectRows.push(data);
}
}
{M_NameSpace}callback(selectRows);
$('#{ModuleName}{M_NameSpace}').dialog('close');
}
});
";
string btnSJs = @"
$('#btnok_{M_NameSpace}').click(function(){
var grid = $('#{M_NameSpace}grid');
var curid = grid.getGridParam('selrow'); //获取选择行的id
var data = grid.getRowData(curid); //获取行号为curid的数据
if(curid==null) return;
{M_NameSpace}callback(data);
$('#{ModuleName}{M_NameSpace}').dialog('close');
});
";
//0131 YSW
#region JqGrid调用部分
string callJs = @"
<script type='text/javascript'>
var {M_NameSpace}callback;
$(document).ready(function() {
{M_NameSpace}_{ModuleName}_GridControl.Init('{M_URL}','{M_NameSpace}');
//初始化层
$('#{ModuleName}{M_NameSpace}').dialog({ autoOpen: false, width: {Width}, height: {Height},title:'{M_Title}' });
//$('#{M_NameSpace}grid').jqGrid('filterGrid','#{M_NameSpace}grid', { multipleSearch:true } );
{BtnJs}
});
function {ModuleName}{M_NameSpace}OpenRefer(callback){
$('#{ModuleName}{M_NameSpace}').dialog('open');
{M_NameSpace}callback=callback;
}
function {ModuleName}{M_NameSpace}OpenReferWithFilter(_filter,callback){
var _url={filterUrl};
var refGrid=$('#{M_NameSpace}grid');
refGrid.setGridParam({ url: _url });
refGrid.trigger('reloadGrid');
$('#{ModuleName}{M_NameSpace}').dialog('open');
{M_NameSpace}callback=callback;
}
function {M_NameSpace}Close(){
$('#{ModuleName}{M_NameSpace}').dialog('close');
}
function {M_NameSpace}ToolBarSearch(){
$('#{M_NameSpace}grid').jqGrid('searchGrid', { multipleSearch:true } );
}
</script>
";
#endregion
#region 生成列头
string strColNames = string.Empty;
D_List = D_List.OrderBy(o => o.D_Order).ToList();
for (int i = 0; i < D_List.Count; i++)
{
if (i != (D_List.Count - 1))
{
strColNames += "'" + D_List[i].D_Name.Trim() + "'" + ",";
}
else
{
strColNames += "'" + D_List[i].D_Name.Trim() + "'";
}
}
#endregion
#region 生成列详细配置
StringBuilder header = new StringBuilder();
string header_template = @"{ name: '{D_Index}',width:100,index: '{D_Index}', align: 'center', {D_Hidden} searchoptions:{ sopt: ['eq', 'ne', 'cn'] } }";
string header_template_fix = ",";
for (var m = 0; m < D_List.Count; m++)
{
string tmpFix = m != (D_List.Count - 1) ? header_template_fix : "";
header.AppendLine(header_template
.Replace("{D_Name}", D_List[m].D_Name.Trim())
.Replace("{D_Index}", D_List[m].D_Index.Trim())
.Replace("{D_Hidden}", !string.IsNullOrEmpty(D_List[m].D_Hidden) ? "hidden:" + D_List[m].D_Hidden + "," : "")
+ tmpFix);
}
#endregion
str += html;
str += js_header + jsBody + js_footer;
str += callJs;
string url = string.Empty;
string filter = string.Empty;
if (!string.IsNullOrEmpty(MRefer.R_Url))
{
url = MRefer.R_Url;
filter = "'" + MRefer.R_Url + "?filter='+_filter";
}
else
{
url = string.Format("/Sys_Config_Refer/GetData/?name={0}&m={1}&n={2}", MRefer.R_TableName, MRefer.R_ModuleName, MRefer.R_NameSpace);
filter = "'/Sys_Config_Refer/GetData/?name=" + MRefer.R_TableName + "&m=" + MRefer.R_ModuleName + "&n=" + MRefer.R_NameSpace + "&filter='+_filter";
}
string tool = string.Empty;
if (string.IsNullOrEmpty(MRefer.R_Tool))
{
tool = "";
}
else
{
tool = MRefer.R_Tool;
}
str = str
.Replace("{BtnJs}", Multiselect ? btnMJs : btnSJs)
.Replace("{ModuleName}", ModuleName)
.Replace("{M_NameSpace}", NameSpace)
.Replace("{Width}", MRefer.R_Width.ToString())
.Replace("{Height}", MRefer.R_Height.ToString())
.Replace("{M_Width}", (MRefer.R_Width * 0.93).ToString())
.Replace("{M_Height}", (MRefer.R_Height * 0.4).ToString())
.Replace("{M_Title}", MRefer.R_Title)
.Replace("{M_ColNames_list}", strColNames)
.Replace("{M_ColModel_List}", header.ToString())
.Replace("{M_GridComplete}", "")
.Replace("{M_URL}", url)
.Replace("{filterUrl}", filter)
.Replace("{Width}", "")
.Replace("{Height}", "")
.Replace("{Table}", MRefer.R_TableName)
.Replace("{MultiSelect}", Multiselect ? "true" : "false")
//.Replace("{ToolBar}", helper.Common_ToolBarForListPage(ModuleName, "",
//"'add':'hidden','edit':'hidden','del':'hidden','import':'hidden','export':'hidden',view:'hidden'"));
.Replace("{ToolBar}", helper.GenToolbarNoPermissionHelper(ModuleName,NameSpace,
tool));
return str;
}
