/// <summary>
/// 增加
/// </summary>
/// <param name="model">T_Work_Number表实体</param>
/// <returns></returns>
public static bool Insert(T_Work_Number model)
{
string sqlcmd = string.Format(@"insert into T_Work_Number(WoCode,ProductCode,ProductName,PlanQty,AQty,BQty,TQty,Status,MaterialModel,Creator,CreateTime,Remark,C_PartNumber,Version)
values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}',getdate(),'{10}','{11}','{12}')", model.WoCode, model.ProductCode, model.ProductName, model.PlanQty, model.AQty, model.BQty,
model.TQty, model.Status, model.MaterialModel, model.Creator, model.Remark, model.C_PartNumber, model.Version);
return(NMS.ExecTransql(CIT.MES.PubUtils.uContext, sqlcmd));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">T_Work_Number表实体</param>
/// <returns></returns>
public static bool UpdateC_PartNumber(T_Work_Number model)
{
string sqlcmd = string.Format(@"update T_Work_Number set
C_PartNumber='{1}'
where WoCode='{0}'" , model.WoCode, model.C_PartNumber);
return(NMS.ExecTransql(CIT.MES.PubUtils.uContext, sqlcmd));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">T_Work_Number表实体</param>
/// <returns></returns>
public static bool Update(T_Work_Number model)
{
string sqlcmd = string.Format(@"update T_Work_Number set
ProductCode='{1}',
ProductName='{2}',
PlanQty='{3}',
AQty='{4}',
BQty='{5}',
TQty='{6}',
Status='{7}',
MaterialModel='{8}',
Creator='{9}',
Remark='{10}'
where WoCode='{0}'" , model.WoCode, model.ProductCode, model.ProductName, model.PlanQty, model.AQty, model.BQty,
model.TQty, model.Status, model.MaterialModel, model.Creator, model.Remark);
return(NMS.ExecTransql(CIT.MES.PubUtils.uContext, sqlcmd));
}
