/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <DC_EQUIP_NEW_Model> getModelList(DC_EQUIP_NEW_SW sw)
{
var result = new List <DC_EQUIP_NEW_Model>();
DataTable dt = BaseDT.DC_EQUIP_NEW.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt32 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "32"
}); //数据中心装备类型
DataTable dt36 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "36"
}); //使用现状
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_EQUIP_NEW_Model m = new DC_EQUIP_NEW_Model();
m.DC_EQUIP_NEW_ID = dt.Rows[i]["DC_EQUIP_NEW_ID"].ToString();
m.EQUIPTYPE = dt.Rows[i]["EQUIPTYPE"].ToString();
m.EQUIPTYPEName = BaseDT.T_SYS_DICT.getName(dt32, m.EQUIPTYPE);
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.MODEL = dt.Rows[i]["MODEL"].ToString();
m.BUYYEAR = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUYYEAR"].ToString());
m.USESTATE = dt.Rows[i]["USESTATE"].ToString();
m.USESTATEName = BaseDT.T_SYS_DICT.getName(dt36, m.USESTATE);
m.STOREADDR = dt.Rows[i]["STOREADDR"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.WORTH = dt.Rows[i]["WORTH"].ToString();
m.EQUIPAMOUNT = dt.Rows[i]["EQUIPAMOUNT"].ToString();
m.REPID = dt.Rows[i]["REPID"].ToString();
m.DCSUPPROPUNIT = dt.Rows[i]["DCSUPPROPUNIT"].ToString();
m.PRICE = dt.Rows[i]["PRICE"].ToString();
if (string.IsNullOrEmpty(m.REPID) == false)
{
m.REPNAME = DC_REPOSITORYCls.getdepotname(m.REPID);
}
else
{
m.REPNAME = "";
}
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dt32.Clear();
dt32.Dispose();
dt36.Clear();
dt36.Dispose();
return(result);
}
/// <summary>
/// 获取列表分页
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static IEnumerable <DC_DETAILS_Model> getModelPager(DC_DETAILS_SW sw, out int total)
{
var result = new List <DC_DETAILS_Model>();
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
DataTable dt = BaseDT.DC_DETAILS.getDT(sw, out total);//列表
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_DETAILS_Model m = new DC_DETAILS_Model();
m.DCDETAILSID = dt.Rows[i]["DCDETAILSID"].ToString();
m.SUPID = dt.Rows[i]["SUPID"].ToString();
m.SUPNAME = DC_SUPPLIESPROPCls.getsupname(m.SUPID);
m.DCSUPPROPMODEL = BaseDT.DC_SUPPLIESPROP.getmodel(new DC_SUPPLIESPROP_SW {
DC_SUPPLIESPROP_ID = m.SUPID
});
m.DCSUPPROPUNIT = BaseDT.DC_SUPPLIESPROP.getunit(new DC_SUPPLIESPROP_SW {
DC_SUPPLIESPROP_ID = m.SUPID
});
m.REPID = dt.Rows[i]["REPID"].ToString();
m.DPNAME = DC_REPOSITORYCls.getdepotname(m.REPID);
m.DCREPTIME = ClsSwitch.SwitDate(dt.Rows[i]["DCREPTIME"].ToString());;
m.DCREPFLAG = dt.Rows[i]["DCREPFLAG"].ToString();
m.DCREPSUPCOUNT = dt.Rows[i]["DCREPSUPCOUNT"].ToString();
m.DCENTYMANID = dt.Rows[i]["DCENTYMANID"].ToString();
m.DCUSERID = dt.Rows[i]["DCUSERID"].ToString();
m.DCCUSTODIANID = dt.Rows[i]["DCCUSTODIANID"].ToString();
m.DCUSERORG = dt.Rows[i]["DCUSERORG"].ToString();
m.PRICE = dt.Rows[i]["PRICE"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.REPERTORYCOUNT = dt.Rows[i]["REPERTORYCOUNT"].ToString();
m.DCFAFANGREN = dt.Rows[i]["DCFAFANGREN"].ToString();
m.DCZHIBIAOREN = dt.Rows[i]["DCZHIBIAOREN"].ToString();
//m.DCENTYMANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCENTYMANID);
//m.DCUSERNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCUSERID);
//m.DCCUSTODIANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCCUSTODIANID);
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.SUM = (float.Parse(m.DCREPSUPCOUNT) * float.Parse(m.PRICE)).ToString("F2");
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtUser.Clear();
dtUser.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DC_DETAILS_Model getModel(DC_DETAILS_SW sw)
{
DataTable dt = BaseDT.DC_DETAILS.getDT(sw);//列表
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
DC_DETAILS_Model m = new DC_DETAILS_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DCDETAILSID = dt.Rows[i]["DCDETAILSID"].ToString();
m.SUPID = dt.Rows[i]["SUPID"].ToString();
m.SUPNAME = DC_SUPPLIESPROPCls.getsupname(m.SUPID); //获取物资的名称
m.REPID = dt.Rows[i]["REPID"].ToString();
m.DPNAME = DC_REPOSITORYCls.getdepotname(m.REPID); //获取仓库的名称
m.DCSUPPROPMODEL = BaseDT.DC_SUPPLIESPROP.getmodel(new DC_SUPPLIESPROP_SW {
DC_SUPPLIESPROP_ID = m.SUPID
}); //获取物资的型号
m.DCSUPPROPUNIT = BaseDT.DC_SUPPLIESPROP.getunit(new DC_SUPPLIESPROP_SW {
DC_SUPPLIESPROP_ID = m.SUPID
}); //获取物资的单位
m.RESPONSIBLEMAN = DC_REPOSITORYCls.getdepotman(m.REPID); //获取仓库负责人
m.DCREPTIME = ClsSwitch.SwitDate(dt.Rows[i]["DCREPTIME"].ToString());;
m.DCREPFLAG = dt.Rows[i]["DCREPFLAG"].ToString();
m.DCREPSUPCOUNT = dt.Rows[i]["DCREPSUPCOUNT"].ToString();
m.DCENTYMANID = dt.Rows[i]["DCENTYMANID"].ToString();
m.DCUSERID = dt.Rows[i]["DCUSERID"].ToString();
m.DCCUSTODIANID = dt.Rows[i]["DCCUSTODIANID"].ToString();
m.DCUSERORG = dt.Rows[i]["DCUSERORG"].ToString();
m.PRICE = dt.Rows[i]["PRICE"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.REPERTORYCOUNT = dt.Rows[i]["REPERTORYCOUNT"].ToString();
m.DCFAFANGREN = dt.Rows[i]["DCFAFANGREN"].ToString();
m.DCZHIBIAOREN = dt.Rows[i]["DCZHIBIAOREN"].ToString();
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
//m.DCENTYMANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCENTYMANID);
//m.DCUSERNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCUSERID);
//m.DCCUSTODIANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCCUSTODIANID);
m.SUM = (float.Parse(m.DCREPSUPCOUNT) * float.Parse(m.PRICE)).ToString("F2");//金额
}
dt.Clear();
dt.Dispose();
return(m);
}