public static int UpdateMo_for_jxLock(Mo_for_jx pModel)
{
int Result = -1;
string strSQL = "";
SqlParameter[] paras = null;
if (pModel.apr_usr != null && pModel.apr_tim != null)
{
strSQL += @" UPDATE mo_for_jx SET apr_usr=@apr_usr, apr_tim=@apr_tim
WHERE mo_id=@mo_id AND wp_id=@wp_id AND goods_id=@goods_id";
paras = new SqlParameter[] {
new SqlParameter("@apr_usr", pModel.apr_usr),
new SqlParameter("@apr_tim", pModel.apr_tim),
new SqlParameter("@mo_id", pModel.mo_id),
new SqlParameter("@wp_id", pModel.wp_id),
new SqlParameter("@goods_id", pModel.goods_id)
};
}
else
{
strSQL += @" UPDATE mo_for_jx SET apr_usr=NULL, apr_tim=NULL
WHERE mo_id=@mo_id AND wp_id=@wp_id AND goods_id=@goods_id";
paras = new SqlParameter[] {
new SqlParameter("@mo_id", pModel.mo_id),
new SqlParameter("@wp_id", pModel.wp_id),
new SqlParameter("@goods_id", pModel.goods_id)
};
}
Result = DBUtility.ExecuteNonQuery(strSQL, paras, false);
return(Result);
}
public static int UpdateMo_for_jx(Mo_for_jx pModel)
{
int Result = -1;
string strSQL = @" UPDATE mo_for_jx SET prod_qty=@prod_qty ,am_usr=@am_usr, am_tim=@am_tim,rmk=@rmk,order_qty=@order_qty
,t_dat=@t_dat,chk_dat=@chk_dat,next_wp_id=@next_wp_id,next_wp_name=@next_wp_name,color_desc=@color_desc,do_color=@do_color
WHERE mo_id=@mo_id AND wp_id=@wp_id AND goods_id=@goods_id";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@prod_qty", pModel.prod_qty),
new SqlParameter("@am_usr", pModel.am_usr),
new SqlParameter("@am_tim", pModel.am_tim),
new SqlParameter("@mo_id", pModel.mo_id),
new SqlParameter("@wp_id", pModel.wp_id),
new SqlParameter("@rmk", pModel.rmk),
new SqlParameter("@goods_id", pModel.goods_id),
new SqlParameter("@order_qty", pModel.order_qty),
new SqlParameter("@t_dat", pModel.t_complete_date),
new SqlParameter("@chk_dat", pModel.check_date),
new SqlParameter("@next_wp_id", pModel.next_wp_id),
new SqlParameter("@next_wp_name", pModel.next_wp_name),
new SqlParameter("@color_desc", pModel.color_desc),
new SqlParameter("@do_color", pModel.do_color)
};
Result = DBUtility.ExecuteNonQuery(strSQL, paras, false);
return(Result);
}
public static int AddMo_for_jx(Mo_for_jx pModel)
{
int Result = -1;
string strIsExsit = DBUtility.ExecuteSqlReturnObject(string.Format("SELECT mo_id FROM mo_for_jx WHERE mo_id='{0}' AND wp_id='{1}' AND goods_id='{2}'", pModel.mo_id, pModel.wp_id, pModel.goods_id));
if (strIsExsit == "")
{
string strSQL = @"INSERT INTO mo_for_jx( mo_date, mo_id, wp_id, goods_id ,goods_name, prod_qty, rmk, cr_usr, cr_tim,order_qty,chk_dat,t_dat,next_wp_id,next_wp_name,ver,color_desc,do_color)
VALUES(@mo_date, @mo_id, @wp_id, @goods_id ,@goods_name, @prod_qty, @rmk, @cr_usr, @cr_tim,@order_qty,@chk_dat,@t_dat,@next_wp_id,@next_wp_name,@ver,@color_desc,@do_color)";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@mo_date", pModel.mo_date),
new SqlParameter("@mo_id", pModel.mo_id),
new SqlParameter("@wp_id", pModel.wp_id),
new SqlParameter("@goods_id", pModel.goods_id),
new SqlParameter("@goods_name", pModel.goods_name),
new SqlParameter("@prod_qty", pModel.prod_qty),
new SqlParameter("@rmk", pModel.rmk),
new SqlParameter("@cr_usr", pModel.cr_usr),
new SqlParameter("@cr_tim", pModel.cr_tim),
new SqlParameter("@order_qty", pModel.order_qty),
new SqlParameter("@chk_dat", pModel.check_date),
new SqlParameter("@t_dat", pModel.t_complete_date),
new SqlParameter("@next_wp_id", pModel.next_wp_id),
new SqlParameter("@next_wp_name", pModel.next_wp_name),
new SqlParameter("@ver", pModel.ver),
new SqlParameter("@color_desc", pModel.color_desc),
new SqlParameter("@do_color", pModel.do_color)
};
Result = DBUtility.ExecuteNonQuery(strSQL, paras, false);
}
else
{
MessageBox.Show("該條數據已存在，請重新輸入信息。");
}
return(Result);
}
