/// <summary>
/// 添加
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Add(DC_DETAILS_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" INSERT INTO DC_DETAILS ( SUPID, REPID, DCREPTIME, DCREPFLAG, DCREPSUPCOUNT,DCENTYMANID,DCUSERID,DCCUSTODIANID,DCUSERORG,PRICE,MARK,REPERTORYCOUNT,DCZHIBIAOREN,DCFAFANGREN,NUMBER)");
sb.AppendFormat("VALUES(");
// sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCDETAILSID));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.SUPID));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.REPID));
//sb.AppendFormat("'{0}',", PublicClassLibrary.ClsSwitch.SwitDate(m.DCREPTIME));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCREPTIME));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCREPFLAG));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCREPSUPCOUNT));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCENTYMANID));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCUSERID));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCCUSTODIANID));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCUSERORG));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.PRICE));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.MARK));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.REPERTORYCOUNT));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCZHIBIAOREN));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.DCFAFANGREN));
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.NUMBER));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 通过id获取物资id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string getsupid(string id)
{
DC_DETAILS_Model m = getModel(new DC_DETAILS_SW {
DCDETAILSID = id
});
return(m.SUPID);
}
/// <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);
}
/// <summary>
/// 更新物资剩余数量
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Mdy(DC_DETAILS_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE DC_DETAILS");
sb.AppendFormat(" set ");
sb.AppendFormat(" REPERTORYCOUNT={0}", ClsSql.saveNullField(m.REPERTORYCOUNT));
sb.AppendFormat(" where DCDETAILSID= '{0}'", ClsSql.EncodeSql(m.DCDETAILSID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 出入库
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(DC_DETAILS_Model m)
{
if (m.opMethod == "INPORT")
{
if (string.IsNullOrEmpty(m.CountID) == false)
{
string[] arr = m.CountID.Split('|');
for (int i = 0; i < arr.Length; i++)
{
if (string.IsNullOrEmpty(arr[i]) == false)
{
string[] brr = arr[i].Split(',');
if (string.IsNullOrEmpty(brr[0].ToString()) == false)
{
m.SUPID = brr[0].ToString();//物资id
m.PRICE = brr[1].ToString();
m.DCREPSUPCOUNT = brr[2].ToString();
m.REPERTORYCOUNT = brr[2].ToString();
BaseDT.DC_DETAILS.Add(m);
DataTable dt = BaseDT.DC_SUPPLIES.getDT(new DC_SUPPLIES_SW {
SUPID = m.SUPID, REPID = m.REPID
});
if (dt.Rows.Count > 0)
{
DC_SUPPLIES_Model m1 = new DC_SUPPLIES_Model();
string id = BaseDT.DC_SUPPLIES.getid(new DC_SUPPLIES_SW {
SUPID = m.SUPID, REPID = m.REPID
}); //物资表id
string DCsupcount = BaseDT.DC_SUPPLIES.getNum(new DC_SUPPLIES_SW {
SUPID = m.SUPID, REPID = m.REPID
});
m1.DCSUPCOUNT = (Convert.ToInt32(DCsupcount) + Convert.ToInt32(m.DCREPSUPCOUNT)).ToString();
m1.SUPID = m.SUPID;
m1.REPID = m.REPID;
m1.DCSUPPLIESID = id;
m1.PRICE = m.PRICE;
BaseDT.DC_SUPPLIES.Mdy(m1);
DC_EQUIP_NEW_Model m2 = new DC_EQUIP_NEW_Model();
m2.DC_EQUIP_NEW_ID = m1.SUPID;
m2.EQUIPAMOUNT = m1.DCSUPCOUNT;
m2.WORTH = (Convert.ToInt32(m1.PRICE) * Convert.ToInt32(m1.DCSUPCOUNT)).ToString();
m2.REPID = m1.REPID;
BaseDT.DC_EQUIP_NEW.MdyCount(m2);
}
else
{
DC_SUPPLIES_Model m1 = new DC_SUPPLIES_Model();
m1.DCSUPCOUNT = m.DCREPSUPCOUNT;
m1.SUPID = m.SUPID;
m1.REPID = m.REPID;
m1.PRICE = m.PRICE;
BaseDT.DC_SUPPLIES.Add(m1);
DC_EQUIP_NEW_Model m2 = new DC_EQUIP_NEW_Model();
m2.DC_EQUIP_NEW_ID = m1.SUPID;
m2.EQUIPAMOUNT = m1.DCSUPCOUNT;
m2.WORTH = (Convert.ToInt32(m1.PRICE) * Convert.ToInt32(m1.DCSUPCOUNT)).ToString();
m2.REPID = m1.REPID;
BaseDT.DC_EQUIP_NEW.MdyCount(m2);
}
}
else
{
return(new Message(false, "请选择出库的物资", ""));
}
}
}
}
return(new Message(true, "入库成功", m.NUMBER));
}
if (m.opMethod == "EXPORT")//出库
{
string str = "";
if (string.IsNullOrEmpty(m.CountID) == false)
{
string[] arr = m.CountID.Split('|');
for (int i = 0; i < arr.Length; i++)
{
if (string.IsNullOrEmpty(arr[i]) == false)
{
string[] brr = arr[i].Split(',');
if (string.IsNullOrEmpty(brr[0].ToString()) == false)
{
//m.SUPID = BaseDT.DC_DETAILS.getsupid(brr[0].ToString());
m.SUPID = brr[0].ToString();
m.DCREPSUPCOUNT = brr[1].ToString();
m.PRICE = BaseDT.DC_SUPPLIES.getPrice(new DC_SUPPLIES_SW {
SUPID = m.SUPID
});
//m.PRICE = BaseDT.DC_DETAILS.getprice(brr[0].ToString());
DataTable dt = BaseDT.DC_SUPPLIES.getDT(new DC_SUPPLIES_SW {
SUPID = m.SUPID, REPID = m.REPID
});
if (dt.Rows.Count > 0)
{
DC_SUPPLIES_Model m1 = new DC_SUPPLIES_Model();
string id = BaseDT.DC_SUPPLIES.getid(new DC_SUPPLIES_SW {
SUPID = m.SUPID, REPID = m.REPID
});
string DCsupcount = BaseDT.DC_SUPPLIES.getNum(new DC_SUPPLIES_SW {
SUPID = m.SUPID, REPID = m.REPID
});
//string RECOUNT = BaseDT.DC_DETAILS.getsum(brr[0].ToString());//剩余数量
if (Convert.ToInt32(DCsupcount) >= Convert.ToInt32(m.DCREPSUPCOUNT))//如果剩余数量大于出库数量
{
m.REPERTORYCOUNT = (Convert.ToInt32(DCsupcount) - Convert.ToInt32(m.DCREPSUPCOUNT)).ToString();
m.DCDETAILSID = brr[0].ToString();
BaseDT.DC_DETAILS.Add(m);
BaseDT.DC_DETAILS.Mdy(m); //更新剩余数量
m1.DCSUPCOUNT = (Convert.ToInt32(DCsupcount) - Convert.ToInt32(m.DCREPSUPCOUNT)).ToString();
m1.SUPID = m.SUPID;
m1.REPID = m.REPID;
m1.DCSUPPLIESID = id;
m1.PRICE = m.PRICE;
BaseDT.DC_SUPPLIES.Mdy(m1);
str = "";
DC_EQUIP_NEW_Model m2 = new DC_EQUIP_NEW_Model();
m2.DC_EQUIP_NEW_ID = m1.SUPID;
m2.EQUIPAMOUNT = m1.DCSUPCOUNT;
m2.WORTH = (Convert.ToInt32(m1.PRICE) * Convert.ToInt32(m1.DCSUPCOUNT)).ToString();
m2.REPID = m1.REPID;
BaseDT.DC_EQUIP_NEW.MdyCount(m2);
}
else
{
return(new Message(true, "超过的部分未出库其他的出库成功", m.NUMBER));
}
}
else
{
str = "库存中没有改物资";
}
}
else
{
return(new Message(false, "请选择出库的物资", ""));
}
}
}
}
if (string.IsNullOrEmpty(str) == true)
{
return(new Message(true, "出库成功", m.NUMBER));
}
if (string.IsNullOrEmpty(str) == false)
{
return(new Message(false, str, ""));
}
}
return(new Message(false, "异常", ""));
}
