public override String ajax_MasterGridData(q_Users queryObj)
{
#region 連接BusinessLogicLibary資料庫並取得資料
ac = new a_Users()
{
Connection = getSQLConnection()
};
RunQueryPackage <m_Users> HResult = ac.SearchMaster(queryObj, LoginUserId);
HandleResultCheck(HResult);
#endregion
#region 設定 Page物件 頁數 總筆數 每頁筆數
int page = (queryObj.page == null ? 1 : queryObj.page.CInt());
int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count);
#endregion
#region 每行及每個欄位資料組成
List <RowElement> setRowElement = new List <RowElement>();
var Modules = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize);
UnitData unit = new UnitData();
var dic = unit.CollectIdNameFields(x => x.id, x => x.name, getSQLConnection());
foreach (m_Users md in Modules)
{
List <String> setFields = new List <String>(5);
setFields.Add(md.id.ToString());
setFields.Add(md.account);
setFields.Add(md.unit.TableCodeValue(dic));
setFields.Add(md.state.CodeValue(CodeSheet.使用者狀態.MakeCodes()));
setFields.Add(md.isadmin.BooleanValue(BooleanSheet.ynv));
setRowElement.Add(new RowElement()
{
id = md.id.ToString(), cell = setFields.ToArray()
});
}
#endregion
#region 回傳JSON資料
JQGridDataObject dataObj = new JQGridDataObject()
{
rows = setRowElement.ToArray(),
total = PageCount.TotalPage,
page = PageCount.Page,
records = PageCount.RecordCount
};
return(JsonConvert.SerializeObject(dataObj, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
#endregion
}
public override String ajax_MasterSubGridData(q__CodeSheet queryObj)
{
#region 連接BusinessLogicLibary資料庫並取得資料
acd = new a__CodeSheet()
{
Connection = getSQLConnection(), logPlamInfo = plamInfo
};;
RunQueryPackage <m__CodeSheet> HResult = acd.SearchMaster(queryObj, LoginUserId);
HandleResultCheck(HResult);
#endregion
#region 設定 Page物件 頁數 總筆數 每頁筆數
int page = (queryObj.page == null ? 1 : queryObj.page.CInt());
int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count);
#endregion
#region 每行及每個欄位資料組成
List <RowElement> setRowElement = new List <RowElement>();
var Modules = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize);
foreach (m__CodeSheet md in Modules)
{
List <String> setFields = new List <String>();
setFields.Add(md.id.ToString());
setFields.Add(md.Code);
setFields.Add(md.Value);
setFields.Add(md.Memo);
setFields.Add(md.Sort.ToString());
setFields.Add(md.IsUse.BooleanValue(BooleanSheet.ynv));
setFields.Add(md.CodeHeadId.ToString());
setRowElement.Add(new RowElement()
{
id = md.id.ToString(), cell = setFields.ToArray()
});
}
#endregion
#region 回傳JSON資料
JQGridDataObject dataObj = new JQGridDataObject()
{
rows = setRowElement.ToArray(),
total = PageCount.TotalPage,
page = PageCount.Page,
records = PageCount.RecordCount
};
JavaScriptSerializer js = new JavaScriptSerializer()
{
MaxJsonLength = 65536
}; //64K
return(js.Serialize(dataObj));
#endregion
}
public override String ajax_MasterGridData(q_ProgData queryObj)
{
#region 連接BusinessLogicLibary資料庫並取得資料
ac = new a_ProgData();
ac.Connection = this.getSQLConnection();
RunQueryPackage <m_ProgData> HResult = ac.SearchMasterLVL1(LoginUserId);
HandleResultCheck(HResult);
#endregion
#region 設定 Page物件 頁數 總筆數 每頁筆數
//int page = (queryObj.page == null ? 1 : queryObj.page.CInt());
//int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count);
#endregion
#region 組成資料
List <RowElement> setRowElement = new List <RowElement>();
m_ProgData[] drDataCollect = HResult.SearchData;
foreach (m_ProgData dr in drDataCollect)
{
List <String> setFields = new List <String>();
setFields.Add(dr.id.ToString());
setFields.Add(dr.prog_name);
setFields.Add(dr.area);
setFields.Add(dr.controller);
setFields.Add(dr.action);
setFields.Add(dr.sort);
setFields.Add(dr.isfolder.BooleanValue(BooleanSheet.ynvx));
setRowElement.Add(new RowElement()
{
id = dr.id.ToString(), cell = setFields.ToArray()
});
}
#endregion
#region 回傳JSON資料
JQGridDataObject dataObj = new JQGridDataObject()
{
rows = setRowElement.ToArray(),
total = 1,
page = 1,
records = PageCount.RecordCount
};
JavaScriptSerializer js = new JavaScriptSerializer()
{
MaxJsonLength = 65536
}; //64K
return(js.Serialize(dataObj));
#endregion
}
public String ajax_MasterGridData(q_PowerUnit sh)
{
a_PowerUnit ac = new a_PowerUnit()
{
Connection = getSQLConnection(), logPlamInfo = plamInfo
};
var r = ac.SearchMaster(sh, LoginUserId);
HandleResultAjaxFiles(r, Resources.Res.NoMessage);
int page = (sh.page == null ? 1 : sh.page.CInt()); //int.Parse(getPage);
int startRecord = PageCount.PageInfo(page, this.DefPageSize, r.Count);
JQGridDataObject dataObject = new JQGridDataObject();
List <RowElement> setRowElement = new List <RowElement>();
foreach (var v in r.SearchData)
{
RowElement re = new RowElement();
re.id = v.progid.ToString();
re.cell = new String[8];
re.cell[0] = v.progname;
for (int i = 0; i < v.Powers.Count; i++)
{
re.cell[i + 1] = JsonConvert.SerializeObject(v.Powers[i], new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
});
}
setRowElement.Add(re);
}
dataObject.rows = setRowElement.ToArray();
dataObject.total = PageCount.TotalPage;
dataObject.page = PageCount.Page;
dataObject.records = PageCount.RecordCount;
return(JsonConvert.SerializeObject(dataObject, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
}
public override string ajax_MasterGridData(q_Unit queryObj)
{
#region 連接BusinessLogicLibary資料庫並取得資料
ac = new a_Unit();
ac.Connection = this.getSQLConnection();
RunQueryPackage <m_Unit> HResult = ac.SearchMaster(queryObj, LoginUserId);
HandleResultCheck(HResult);
#endregion
#region 設定 Page物件 頁數 總筆數 每頁筆數
int page = (queryObj.page == null ? 1 : queryObj.page.CInt());
int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count);
#endregion
#region 組成資料
List <RowElement> setRowElement = new List <RowElement>();
var drDataCollect = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize);
this.Tab = new UnitData();
foreach (var dr in drDataCollect)
{
RowElement GridRow = new RowElement()
{
id = dr.id.ToString(), cell = new String[3]
};
GridRow.cell[0] = dr.id.ToString();
GridRow.cell[1] = dr.name;
GridRow.cell[2] = dr.sort.ToString();
setRowElement.Add(GridRow);
}
#endregion
#region 回傳JSON資料
JQGridDataObject dataObj = new JQGridDataObject()
{
rows = setRowElement.ToArray(),
total = PageCount.TotalPage,
page = PageCount.Page,
records = PageCount.RecordCount
};
return(JsonConvert.SerializeObject(dataObj, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
#endregion
}
