/// <summary>
/// 获取计划列表
/// </summary>
/// <param name="strWhere"></param>
/// <param name="strOrder"></param>
/// <param name="db"></param>
/// <returns></returns>
public static List <YK_ZJJG_JH> GetJhList(string strWhere, string strOrder, RelationalDatabase db)
{
List <YK_ZJJG_JH> lstJh = new List <YK_ZJJG_JH>();
foreach (DataRow row in GetJhDataTable(strWhere, strOrder, db).Rows)
{
YK_ZJJG_JH jh = new YK_ZJJG_JH();
jh.id = new Guid(row["id"].ToString());
jh.ywlx = row["ywlx"].ToString();
jh.djh = Convert.ToInt32(row["djh"]);
jh.djrq = Convert.ToDateTime(row["djrq"]);
jh.shrq = (row["shrq"] is DBNull)?DateTime.Now:Convert.ToDateTime(row["shrq"]);
jh.djy = Convert.ToInt32(row["djy"]);
jh.shy = Convert.ToInt32(row["shy"]);
jh.bshbz = Convert.ToInt32(row["bshbz"]);
jh.bscbz = Convert.ToInt32(row["bscbz"]);
jh.rkdjid = new Guid(row["rkdjid"].ToString());
jh.ckdjid = new Guid(row["ckdjid"].ToString());
jh.deptid = Convert.ToInt32(row["deptid"]);
jh.bz = row["bz"].ToString();
jh._djymc = (row["djymc"] is DBNull)?null:row["djymc"].ToString();
jh._shymc = (row["shymc"] is DBNull) ? null : row["shymc"].ToString();
lstJh.Add(jh);
}
return(lstJh);
}
/// <summary>
/// 移除生产计划
/// </summary>
/// <param name="scjh"></param>
public static void RemoveScjh(YK_ZJJG_JH jh, RelationalDatabase db, int jgbm)
{
//移除原料消耗明细-取消原料消耗出库-移除计划明细表数据
try
{
#region 移除计划
List <YK_ZJJG_JH> lstjh_check = YK_ZJJG_JH.GetJhList(string.Format(" and a.id='{0}' ", jh.id), "", db);
if (lstjh_check.Count <= 0)
{
throw new Exception("移除失败！找不到该计划,请刷新数据后重试！");
}
else
{
YK_ZJJG_JH jh_check = lstjh_check[0];
if (jh_check.bshbz == 1)
{
throw new Exception("移除失败！该计划已经审核，不能移除！请先取消审核计划");
}
if (jh_check.bscbz == 1)
{
throw new Exception("移除失败！该计划已经被删除，请刷新数据！");
}
}
YK_ZJJG_JH.DeleteJh(db, jh.id, false);
#endregion
//#region 移除计划明细
//YK_ZJJG_JHMX.DeleteJhmxByJhid(jh.id, db);
//#endregion
//#region 移除原料
//YK_ZJJG_YLMX.DeleteYlmxByDjid(jh.id,db);
//#endregion
#region 更新库存
//反向单据明细
int upt_err_code = 0;
string upt_err_text = "";
Yk_dj_djmx.UpdateKcDrt(jh.ckdjid, db);
Yk_dj_djmx.AddUpdateKcmx(jh.ckdjid, out upt_err_code, out upt_err_text, Convert.ToInt64(jgbm), db);
if (upt_err_code != 0)
{
throw new Exception(upt_err_text.ToString());
}
Yk_dj_djmx.UpdateKcDrt(jh.ckdjid, db);
#endregion
#region 移除原料消耗入库单据
Yk_dj_djmx.DeleteDj(jh.ckdjid, db);
#endregion
}
catch (Exception err)
{
throw err;
}
}
/// <summary>
/// 保存计划(新增或者修改)
/// </summary>
/// <param name="db"></param>
/// <param name="OperationType">操作类型 0-新增 1-修改 2-删除</param>>
public static void SaveJh(RelationalDatabase db, YK_ZJJG_JH jh, int OperationType)
{
if (OperationType == 1)
{
//修改计划
string ssql = string.Format(@" update yk_zjjg_jh set
shrq='{0}',shy={1},bshbz={2},bscbz={3},rkdjid='{4}',
ckdjid='{5}',bz='{6}' where id='{7}'",
jh.shrq,
jh.shy,
jh.bshbz,
jh.bscbz,
jh.rkdjid,
jh.ckdjid,
jh.bz,
jh.id);
if (Convert.ToInt32(db.DoCommand(ssql)) <= 0)
{
throw new Exception("保存失败!");
}
}
if (OperationType == 0)
{
//新增计划
jh.id = Guid.NewGuid();
jh.djh = Convert.ToInt64(SeekNewJhDjh(db, jh.ywlx, jh.deptid));
string ywlx = "032";
string ssql = string.Format(@" insert into yk_zjjg_jh
(id,ywlx,djh,djrq,shrq,
djy,shy,bshbz,bscbz,rkdjid,
ckdjid,deptid,bz )values (
'{0}','{1}',{2},'{3}',{4},
{5},{6},{7},{8},'{9}',
'{10}',{11},'{12}')",
jh.id, jh.ywlx, jh.djh,
jh.djrq,
"null",
jh.djy, jh.shy, jh.bshbz, jh.bscbz, jh.rkdjid,
jh.ckdjid, jh.deptid, jh.bz);
if (Convert.ToInt32(db.DoCommand(ssql)) <= 0)
{
throw new Exception("保存失败！");
}
}
}
/// <summary>
/// 取消审核生产计划
/// </summary>
/// <param name="scjh"></param>
public static void UnShScJh(YK_ZJJG_JH jh, RelationalDatabase db, int jgbm)
{
//更新计划明细-更新原料消耗明细-取消加工入库
try
{
List <YK_ZJJG_JH> lstjh_check = YK_ZJJG_JH.GetJhList(string.Format(" and a.id='{0}' ", jh.id), "", db);
if (lstjh_check.Count <= 0)
{
throw new Exception("取消审核失败！找不到该计划,请刷新数据后重试！");
}
else
{
YK_ZJJG_JH jh_check = lstjh_check[0];
if (jh_check.bshbz != 1)
{
throw new Exception("取消审核失败！请刷新数据后重试！");
}
if (jh_check.bscbz == 1)
{
throw new Exception("取消审核失败！该计划已经被删除，请刷新数据！");
}
}
#region 更新计划
if (jh.bshbz != 1)
{
throw new Exception("该计划还未审核，不能进行取消审核");
}
jh.bshbz = 0;
YK_ZJJG_JH.SaveJh(db, jh, 1);
#endregion
#region 更新计划明细
#endregion
#region 更新原料消耗明细
#endregion
#region 更新库存
int upt_err_code = 0;
string upt_err_text = "";
Yk_dj_djmx.UpdateKcDrt(jh.rkdjid, db);
Yk_dj_djmx.AddUpdateKcmx(jh.rkdjid, out upt_err_code, out upt_err_text, Convert.ToInt64(jgbm), db);
if (upt_err_code != 0)
{
throw new Exception(upt_err_text.ToString());
}
Yk_dj_djmx.UpdateKcDrt(jh.rkdjid, db);
#endregion
#region 除加工入库单
Yk_dj_djmx.DeleteDj(jh.rkdjid, db);
#endregion
}
catch (Exception err)
{
throw err;
}
}
/// <summary>
/// 创建生产计划
/// </summary>
/// <param name="scjh"></param>
public static void CreatScJh(YK_ZJJG_JH jh, List <Jhmx_lstYlmx> lst, RelationalDatabase db, string ywlx, int jgbm)
{
//插入计划表数据
//插入计划明细表数据-插入原料消耗明细-办理原料消耗出库
try
{
//db.BeginTransaction();
#region 插入原料消耗出库单据头
Guid ck_djid;
int ck_err_code = 0; //保存单据头存储过程错误代码
string ck_err_text = ""; //保存单据头存储过程错误文本
long ck_djh = Yp.SeekNewDjh(ywlx, jh.deptid, db);
long ck_sdjh = Yp.SeekNewDjh(ywlx, jh.deptid, db);
decimal ck_sumjhje = 0;
decimal ck_sumpfje = 0;
decimal ck_sumlsje = 0;
int deptid = jh.deptid;
int uid = jh.djy;
string sDate = db.GetDataResult(db.GetServerTimeString()).ToString();//当前服务器时间
foreach (Jhmx_lstYlmx jhmx_lstYlmx in lst)
{
foreach (YK_ZJJG_YLMX ylmx in jhmx_lstYlmx.lstYlmx)
{
ck_sumjhje += ylmx.jhj * ylmx.sl;
ck_sumpfje += ylmx.pfj * ylmx.sl;
ck_sumlsje += ylmx.lsj * ylmx.sl;
}
}
Yk_dj_djmx.SaveDJ(new Guid(Guid.Empty.ToString()),
ck_djh, //单据号
deptid, //仓库id
ywlx, //业务类型
deptid, + //往来单位
0, //经手人
DateTime.Now.ToShortDateString(),
uid,
Convert.ToDateTime(sDate).ToShortDateString(),
Convert.ToDateTime(sDate).ToLongTimeString(),
"", //发票号
"", //发票日期
"", //备注
"", //送货单号
0, //原因代码
0, //申请单号
ck_sumjhje,
ck_sumpfje,
ck_sumlsje,
ck_sdjh.ToString(),
out ck_djid, out ck_err_code, out ck_err_text, jgbm, db);
#endregion
#region 插入生产计划
jh.ckdjid = ck_djid;//回填计划表中 消耗出库单据id
jh.djh = YK_ZJJG_JH.SeekNewJhDjh(db, jh.ywlx, deptid);
YK_ZJJG_JH.SaveJh(db, jh, 0);
#endregion
foreach (Jhmx_lstYlmx jhmx_lstYlmx in lst)
{
#region 插入计划明细
YK_ZJJG_JHMX jhmx = jhmx_lstYlmx.jhmx;
jhmx.djid = jh.id; //计划id
jhmx.djh = Convert.ToInt32(jh.djh); //计划号
Guid jhmxid = jhmx.id;
YK_ZJJG_JHMX.SaveJhmx(jhmx, db, 0);
#endregion
int pxxh = 0;
foreach (YK_ZJJG_YLMX ylmx in jhmx_lstYlmx.lstYlmx)
{
pxxh += 1;
#region 构造原料消耗出库单据明细
//int ck_djmx_err_code = 0;
//string ck_djmx_err_text = "";
Guid ck_djmxid = Guid.NewGuid();
Ypcj YPCJ = new Ypcj(ylmx.cjid, db);
Ypgg YPGG = new Ypgg(YPCJ.GGID, db);
////此方法不再使用 统一方法
//InsertDjmx(db,
// ck_djmxid, ck_djid, ylmx.cjid,0,"",
// ylmx.yppm, ylmx.yppm, ylmx.ypgg, ylmx.sccj, ylmx.ph,
// ylmx.xq.ToShortDateString(), 0, 0, ylmx.sl, ylmx.ypdw,
// YPGG.YPDW,1,YPCJ.ZBJ, YPCJ.PFJ, YPCJ.LSJ,
// YPCJ.ZBJ * ylmx.sl,YPCJ.PFJ * ylmx.sl, YPCJ.LSJ * ylmx.sl, ck_djh,
// deptid, ywlx, "","", pxxh, 1);
int err_code = 0;
string err_text = "";
Yk_dj_djmx.SaveDJMX_ID(Guid.Empty, ck_djid, ylmx.cjid, 0, "",
ylmx.yppm, ylmx.yppm, ylmx.ypgg, ylmx.sccj, ylmx.ph,
ylmx.xq.ToShortDateString(), 0, 0, ylmx.sl, ylmx.ypdw,
YPGG.YPDW, 1,
0, //YPCJ.MRJJ, //ypcjd中默认进价
YPCJ.PFJ, //批发价
YPCJ.LSJ, //零售价
0, //YPCJ.MRJJ * ylmx.sl/jhmx.ydwbl, //ypcjd中默认进价*原料数量
YPCJ.PFJ * ylmx.sl / jhmx.ydwbl, //批发金额
YPCJ.LSJ * ylmx.sl / jhmx.ydwbl, //零售金额
ck_djh,
deptid, ywlx, "", "", out err_code, out err_text, db, pxxh, out ck_djmxid, "", Guid.Empty);
if (err_code != 0)
{
throw new Exception(err_text);
}
#endregion
#region 插入原料消耗明细
ylmx.ckmxid = ck_djmxid; //原料消耗出库单据明细id
ylmx.djid = jh.id; //原料出库单据id
ylmx.jhmxid = jhmxid; //计划明细id
ylmx.djh = Convert.ToInt32(jh.djh); //计划号
YK_ZJJG_YLMX.SaveYlmx(ylmx, db);
#endregion
}
}
#region 审核消耗出库单据
Yk_dj_djmx.Shdj(ck_djid, db.GetDataResult(db.GetServerTimeString()).ToString(), db);
#endregion
#region 更新库存
int upt_err_code = 0;
string upt_err_text = "";
Yk_dj_djmx.AddUpdateKcmx(ck_djid, out upt_err_code, out upt_err_text, Convert.ToInt64(jgbm), db);
if (upt_err_code != 0)
{
throw new Exception(upt_err_text.ToString());
}
#endregion
//db.CommitTransaction();
}
catch (Exception err)
{
//db.RollbackTransaction();
throw err;
}
}
/// <summary>
/// 审核生产计划
/// </summary>
/// <param name="scjh"></param>
public static void ShScJh(YK_ZJJG_JH jh, List <YK_ZJJG_JHMX> lstjhmx, RelationalDatabase db, string ywlx, int jgbm)
{
//更新计划明细-更新原料消耗明细-更新计划表
//办理加工入库
try
{
List <YK_ZJJG_JH> lstjh_check = YK_ZJJG_JH.GetJhList(string.Format(" and a.id='{0}' ", jh.id), "", db);
if (lstjh_check.Count <= 0)
{
throw new Exception("审核失败！找不到该计划,请刷新数据后重试！");
}
else
{
YK_ZJJG_JH jh_check = lstjh_check[0];
if (jh_check.bshbz == 1)
{
throw new Exception("审核失败！请刷新数据后重试！");
}
if (jh_check.bscbz == 1)
{
throw new Exception("审核失败！该计划已经被删除，请刷新数据！");
}
}
#region 插入加工入库单据头
Guid rk_djid;
int rk_err_code = 0; //保存单据头存储过程错误代码
string rk_err_text = ""; //保存单据头存储过程错误文本
long rk_djh = Yp.SeekNewDjh(ywlx, jh.deptid, db);
long rk_sdjh = Yp.SeekNewDjh(ywlx, jh.deptid, db);
decimal rk_sumjhje = 0;
decimal rk_sumpfje = 0;
decimal rk_sumlsje = 0;
int deptid = jh.deptid;
int uid = jh.djy;
string sDate = (db.GetDataResult(db.GetServerTimeString())).ToString();//当前服务器时间
foreach (YK_ZJJG_JHMX jhmx in lstjhmx)
{
rk_sumjhje += jhmx.jhj * jhmx.cpsl;
rk_sumpfje += jhmx.pfj * jhmx.cpsl;
rk_sumlsje += jhmx.lsj * jhmx.cpsl;
}
Yk_dj_djmx.SaveDJ(new Guid(Guid.Empty.ToString()),
rk_djh, //单据号
deptid, //仓库id
ywlx, //业务类型
deptid, //往来单位
0, //经手人
DateTime.Now.ToShortDateString(),
uid,
Convert.ToDateTime(sDate).ToShortDateString(),
Convert.ToDateTime(sDate).ToLongTimeString(),
"",
"",
"",
"",
0,
0,
rk_sumjhje,
rk_sumpfje,
rk_sumlsje,
rk_sdjh.ToString(),
out rk_djid, out rk_err_code, out rk_err_text, jgbm, db);
#endregion
#region 更新计划
//if (jh.bshbz == 1) throw new Exception("该计划已经审核！");
jh.bshbz = 1;
jh.rkdjid = rk_djid;
jh.shrq = Convert.ToDateTime(db.GetDataResult(db.GetServerTimeString()));
YK_ZJJG_JH.SaveJh(db, jh, 1);
#endregion
#region 更新计划明细
int pxxh = 0;
foreach (YK_ZJJG_JHMX jhmx in lstjhmx)
{
pxxh += 1;
//计算成本价
List <YK_ZJJG_YLMX> lstYlmx = YK_ZJJG_YLMX.GetYlmxList(string.Format(" and b.id='{0}'", jhmx.id), "", db);
decimal sumYlpfje = 0;
foreach (YK_ZJJG_YLMX ylmx in lstYlmx)
{
sumYlpfje += ylmx.pfj * ylmx.sl;
}
if (jhmx.cpsl == 0)
{
throw new Exception("成品数量不能为0");
}
jhmx.cbj = Convert.ToDecimal(sumYlpfje / jhmx.cpsl); //成本价
#region 插入加工入库单据明细
//int rk_djmx_err_code = 0;
//string rk_djmx_err_text = "";
Guid rk_djmxid = Guid.Empty;
Ypcj YPCJ = new Ypcj(jhmx.cjid, db);
Ypgg YPGG = new Ypgg(YPCJ.GGID, db);
//此方法不再使用 统一方法
//InsertDjmx(db, rk_djmxid, rk_djid, jhmx.cjid,
// 0, "", jhmx.yppm, jhmx.yppm, jhmx.ypgg,
// jhmx.sccj, jhmx.ph,
// jhmx.xq.ToShortDateString(), 0, 0, jhmx.cpsl, jhmx.ypdw, YPGG.YPDW, 1,
// YPCJ.ZBJ, YPCJ.PFJ, YPCJ.LSJ, YPCJ.ZBJ * jhmx.cpsl,
// YPCJ.PFJ * jhmx.cpsl, YPCJ.LSJ * jhmx.cpsl, rk_djh, deptid, ywlx, "", rk_sdjh.ToString(),
// pxxh, 1);
int err_code = 0;
string err_text = "";
//20140211 ncq 将成品入库批发价 设定为成本价 系统对账将会出现批发金额不对问题
Yk_dj_djmx.SaveDJMX_ID(Guid.Empty, rk_djid, jhmx.cjid, 0, "",
jhmx.yppm, jhmx.yppm, jhmx.ypgg, jhmx.sccj, jhmx.ph,
jhmx.xq.ToShortDateString(), 0, 0, jhmx.cpsl, jhmx.ypdw, YPGG.YPDW, 1,
0, //YPCJ.MRJJ, //ypcjd中默认进价
YPCJ.PFJ, //批发价 //jhmx.cbj, //成本价
YPCJ.LSJ, //零售价
//jhmx.cpsl*YPCJ.MRJJ,//ypcjd中默认进价*成品数量
0, //YPCJ.MRJJ * jhmx.cpsl/jhmx.ydwbl,//进货金额
jhmx.cpsl * YPCJ.PFJ / jhmx.ydwbl, //批发金额 //jhmx.cbj * jhmx.cpsl/jhmx.ydwbl, //采用成本价计算批发金额
YPCJ.LSJ * jhmx.cpsl / jhmx.ydwbl, //零售金额
rk_djh, deptid, ywlx, "", rk_sdjh.ToString(),
out err_code, out err_text, db, pxxh, out rk_djmxid, "", Guid.Empty);
if (err_code != 0)
{
throw new Exception(err_text);
}
#endregion
#region 更新计划明细
jhmx.cpl = Convert.ToDecimal(jhmx.cpsl / jhmx.jhsl); //成本率
jhmx.rkdjmxid = rk_djmxid; //更新计划明细中 入库单据明细id
jhmx.djid = jh.id;
jhmx.djh = Convert.ToInt32(jh.djh);
YK_ZJJG_JHMX.SaveJhmx(jhmx, db, 1);
#endregion
}
#endregion
#region 审核加工入库单据
Yk_dj_djmx.Shdj(rk_djid, db.GetDataResult(db.GetServerTimeString()).ToString(), db);
#endregion
#region 更新库存
int upt_err_code = 0;
string upt_err_text = "";
//MessageBox.Show(rk_djid.ToString());
Yk_dj_djmx.AddUpdateKcmx(rk_djid, out upt_err_code, out upt_err_text, Convert.ToInt64(jgbm), db);
if (upt_err_code != 0)
{
throw new Exception(upt_err_text.ToString());
}
//MessageBox.Show(upt_err_text);
#endregion
}
catch (Exception err)
{
throw err;
}
}