public bool GiveUpTempTrans(SaleBillDetails_Model detail, out string strErrMsg)
{
try
{
string sql = @"update salebillvouchs_extradefine set cbdefine5 = null,cbdefine6 = null where autoid = " + detail.autoid;
int i = OperationSql.ExecuteNonQueryForERP(CommandType.Text, sql, null);
if (i <= 0)
{
strErrMsg = "数据库操作失败,未能弃审记录";
return(false);
}
sql = @"update T_temptrans set verifydate = null where cinvcode = '" + detail.cinvcode + "' and ssbvcode = '" + detail.ssbvcode + "'";
i = OperationSql.ExecuteNonQuery(CommandType.Text, sql, null);
if (i <= 0)
{
strErrMsg = "数据库操作失败,未能弃审记录";
return(false);
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
public bool DelTempTrans(SaleBillDetails_Model detail, out string strErrMsg)
{
try
{
string sql = @"delete T_temptrans where cinvcode = '" + detail.cinvcode + "' and ssbvcode = '" + detail.ssbvcode + "' and ssbvrowno = '" + detail.ssbvrowno + "'";
int i = OperationSql.ExecuteNonQuery(CommandType.Text, sql, null);
if (i <= 0)
{
strErrMsg = "数据库操作失败,未能删除记录";
return(false);
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
//借调记录表
//id
//cinvcode物料编码
//cinvname物料名称
//cinvstd规格型号
//qty借调数量
//creater借调人员
//createdate借调生单时间
//verifydate借调审核时间
//ssocode原销售订单号
//ssorowno原销售订单行号
//ssoqty原销售订单数量
//ssbvcode原销售发票号
//ssbvrowno原销售发票行号
//ssbvqty原销售发票数量
//dsocode被借销售订单号
//dsorowno被借销售订单行号
//dsoqty被借销售订单数量
public bool SaveTempTrans(string creater, SaleBillDetails_Model detail, out string strErrMsg)
{
try
{
string sql = @"insert T_temptrans (cinvcode,cinvname,cinvstd,qty,creater,createdate,ssocode,ssorowno,ssoqty,ssbvcode,ssbvrowno,ssbvqty,dsocode,dsorowno,dsoqty)
values ('" + detail.cinvcode + "','" + detail.cinvname + "','" + detail.cinvstd + "'," + detail.qty.ToString() + ",'" + creater + "',GETDATE(),'" + detail.ssocode + "','" + detail.ssorowno + "',"
+ detail.ssoqty.ToString() + ",'" + detail.ssbvcode + "','" + detail.ssbvrowno + "'," + detail.ssbvqty.ToString() + ",'" + detail.dsocode + "','" + detail.dsorowno + "'," + detail.dsoqty.ToString() + ")";
int i = OperationSql.ExecuteNonQuery(CommandType.Text, sql, null);
if (i <= 0)
{
strErrMsg = "数据库操作失败,未能保存记录";
return(false);
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}