/// <summary>
/// 新增产品信息记录
/// </summary>
/// <param name="str">产品条码</param>
private static bool InsertProdcutInfo(Model_Bllb_productInfo_tbpi obj)
{
string strSql = string.Format(@"INSERT INTO T_Bllb_productInfo_tbpi(
TBPS_ID,
SERIAL_NUMBER,
QTY,
OVER_FLAG,
LAST_FLAG,
ERROR_FLAG,
REPAIR_FLAG,
SCRAP_FLAG,
SfcNo,
AUXILIARY_FLAG,
ONCE_OVER_FLAG)
VALUES(
'{0}',
'{1}',
'{2}',
'{3}',
'{4}',
'{5}',
'{6}',
'{7}',
'{8}',
'{9}',
'{10}')",
obj.TBPS_ID,
obj.SERIAL_NUMBER,
obj.QTY,
obj.OVER_FLAG,
obj.LAST_FLAG,
obj.ERROR_FLAG,
obj.REPAIR_FLAG,
obj.SCRAP_FLAG,
obj.SfcNo,
obj.AUXILIARY_FLAG,
obj.ONCE_OVER_FLAG);
return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 流程结束
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
private static bool UpdateOverTech(Model_Bllb_productInfo_tbpi obj)
{
//用于处理非条码转换指令的情况,对为空的参数进行赋值
if (obj.OLD_SERIAL_NUMBER == string.Empty)
{
obj.OLD_SERIAL_NUMBER = obj.SERIAL_NUMBER;
}
if (obj.SERIAL_NUMBER == string.Empty)
{
obj.SERIAL_NUMBER = obj.OLD_SERIAL_NUMBER;
}
string strSql = string.Format(@"UPDATE T_Bllb_productInfo_tbpi SET
OVER_FLAG='{1}',ONCE_OVER_FLAG='Y',SERIAL_NUMBER='{2}',OUTPUT_TIME=GETDATE()
where
SERIAL_NUMBER='{0}'
",
obj.OLD_SERIAL_NUMBER,
obj.OVER_FLAG,
obj.SERIAL_NUMBER);
return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql));
}
