private void SetDisplayColumns(PagerGridView gridview)
{
//设置可视列
IList <ColumnInfoVo> clist = new List <ColumnInfoVo>();
ColumnInfoVo columnvo = new ColumnInfoVo();
columnvo.Columnname = "IDispItemCd";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "IDispItemRev";
columnvo.Columnwidth = 50;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "IItemDesc";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "VDlDesc";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "VItemclsdesc";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "VItemtypedesc";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "VMakerdesc";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "IModel";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "IDrwNo";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "ISpec";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "ISeiban";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
columnvo = new ColumnInfoVo();
columnvo.Columnname = "IQryMtrl";
columnvo.Columnwidth = 100;
clist.Add(columnvo);
gridview.SetDisplayColumns(gridview.Name, clist);
}
public Int32 GetPmMsDetail(PagerGridView gridview, CardVo cardvo)
{
LoginUserInfoVo uservo = (LoginUserInfoVo)SessionUtils.GetSession(SessionUtils.COMMON_LOGIN_USER_INFO);
SearchCondition condition = new SearchCondition();
condition.SetAddtionalCondition("ALLFACTORY", false);
condition.AddCondition("T_PM_MS.I_ITEM_ENTRY_CLS", "IITEMENTRYCLS", "00", SqlOperator.Equal);
condition.AddCondition("T_PM_MS.I_FAC_CD", "IFACCD", cardvo.IFacCd, SqlOperator.Equal);
condition.AddCondition("T_PM_MS.I_ITEM_TYPE", "IITEMTYPE", cardvo.IItemType, SqlOperator.Equal);
condition.AddCondition("T_PM_MS.I_ITEM_CLS", "IITEMCLS", cardvo.IItemCls, SqlOperator.Equal);
condition.AddCondition("T_PM_MS.I_DISP_ITEM_CD", "IDISPITEMCD", cardvo.IDispItemCd, SqlOperator.Equal);
condition.AddCondition("T_PM_MS.I_DISP_ITEM_REV", "IDISPITEMREV", cardvo.IDispItemRev, SqlOperator.Equal);
condition.AddCondition("T_PM_MS.I_ITEM_DESC", "IITEMDESC", cardvo.IItemDesc, SqlOperator.Like);
condition.AddCondition("T_PM_MS.I_MODEL", "IMODEL", cardvo.IModel, SqlOperator.Like);
condition.AddCondition("T_PM_MS.I_SPEC", "ISPEC", cardvo.ISpec, SqlOperator.Like);
condition.AddCondition("T_PM_MS.I_DRW_NO", "IDRWNO", cardvo.IDrwNo, SqlOperator.Like);
condition.AddCondition("T_PM_MS.I_SEIBAN", "ISEIBAN", cardvo.ISeiban, SqlOperator.Like);
condition.AddCondition("T_PM_MS.I_MAKER_CD", "IMAKERCD", cardvo.IMakerCd, SqlOperator.Equal);
condition.AddCondition("T_PM_MS.I_QRY_MTRL", "IQRYMTRL", cardvo.IQryMtrl, SqlOperator.Like);
condition.AddCondition("T_PM_MS.I_MNT_CLS", "IMNTCLS", cardvo.IMntCls, SqlOperator.Equal);
condition.AddCondition("companyCd", uservo.CompanyCondition.ICompanyCd);
condition.AddCondition("langCd", LangUtils.GetCurrentLanguage());
gridview.Pagerhelper = new PagerHelper("CTPmMsPagerNoARDao", condition, 1, 15);
gridview.LoadData();
log.Debug("Search Init");
//设置列名
foreach (string key in columnlist)
{
gridview.SetColumnAlias(key, rm.GetString(key));
}
// foreach (string key in gridview.Pagerhelper.Columns)
// {
// gridview.SetColumnAlias(key, rm.GetString(key));
// }
SetDisplayColumns(gridview);
DataSet ds = (DataSet)gridview.DataSource;
DataTable dt = ds.Tables["CTPmMsPagerNoARDao"];
return(dt.Rows.Count);
}
public void Init_GridView(PagerGridView gridview)
{
DataTable dt = new DataTable();
foreach (string key in columnlist)
{
DataColumn col = new DataColumn();
col.ColumnName = key;
dt.Columns.Add(col);
}
gridview.InitGridView(dt);
foreach (string key in columnlist)
{
gridview.SetColumnAlias(key, rm.GetString(key));
}
SetDisplayColumns(gridview);
}
