/// <summary>
/// 新增
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public int RSaveFault(CheckOrderISNFault p_BE, CheckOrderISN entity, int MainID, int PackDtsID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
int TempID = this.RSaveFault(p_BE, entity, MainID, PackDtsID, sqlTrans);
sqlTrans.CommitTrans();
return(TempID);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 此卷结束
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFabicFinish_Click(object sender, EventArgs e)
{
try
{
if (!FabricFinishCheckCorrect())
{
return;
}
CheckOrderISNFaultRule rule = new CheckOrderISNFaultRule();
CheckOrderISN entityMain = EntityGet();
int tempID = rule.RJYEnd(ISNID, entityMain, DtsID, SysConvert.ToDecimal(lblQty.Text), SysConvert.ToDecimal(lblQty.Text), SysConvert.ToInt32(lblReelNo.Text));
ISNID = tempID;
//if (chkAutoPrint.Checked)
//{
btnPrint_Click(null, null);//打印小票
//}
lblQty.Text = "0.00";
ISNID = 0;
BindGrid();
SetEntity(2);
btnCDCancel_Click(null, null);
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 开剪
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnKJ_Click(object sender, EventArgs e)
{
try
{
if (!CDInputCheck())
{
return;
}
CheckOrderISN entity = EntityGet();
if ((entity.StatusID != (int)EnumBoxStatus.未入库) && entity.ID > 0)//不是开匹的才计算
{
this.ShowMessage("不是未入库的条码不能开剪");
return;
}
saveCDItemType = 3;//
//txtJCYQty.Text = "";
CDSave();
lblKJQty.Text = "";
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private List <CheckOrderISN> GetCheckItem()
{
this.BaseFocusLabel.Focus();
List <CheckOrderISN> list = new List <CheckOrderISN>();
DataTable dt = gridView1.GridControl.DataSource as DataTable;
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
if (SysConvert.ToInt32(dr["CheckFlag"]) == 1)
{
CheckOrderISN entity = new CheckOrderISN();
entity.ID = SysConvert.ToInt32(dr["DID"]);
entity.SelectByID();
if (entity.StatusID <= (int)EnumBoxStatus.未入库)
{
list.Add(entity);
}
}
}
}
return(list);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
CheckOrderISN MasterEntity = (CheckOrderISN)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//删除主表数据
string Sql = "";
Sql = "DELETE FROM Chk_CheckOrderISN WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID);
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(Sql);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(Sql);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E);
}
}
/// <summary>
/// 检验结束
/// </summary>
/// <param name="p_BE"></param>
/// <param name="entity"></param>
/// <param name="p_PackID"></param>
/// <param name="Qty">码表数量</param>
/// <param name="YMQty">原码数量，暂不使用</param>
/// <param name="JarNo">缸号</param>
/// <returns></returns>
public int RJYEnd(int p_BE, CheckOrderISN entity, int p_PackID, decimal Qty, decimal YMQty, int JarNo)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
int tempID = this.RJYEnd(p_BE, entity, p_PackID, Qty, YMQty, JarNo, sqlTrans);
sqlTrans.CommitTrans();
return(tempID);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 检验字段值是否已存在
/// </summary>
/// <param name="p_TableName">表名</param>
/// <param name="p_FieldName">字段名</param>
/// <param name="p_FieldValue">字段值</param>
/// <param name="p_KeyField">主键（只考虑主键为ID的情况）</param>
/// <param name="p_KeyValue">主键值</param>
/// <param name="p_sqlTrans"></param>
/// <returns></returns>
private bool CheckFieldValueIsExist(BaseEntity p_BE, string p_FieldName, string p_FieldValue, IDBTransAccess p_sqlTrans)
{
CheckOrderISN entity = (CheckOrderISN)p_BE;
bool ret = false;
string sql = string.Format(" SELECT {0} FROM {1} WHERE 1=1 AND {0}={2} AND {3}<>{4}", p_FieldName, CheckOrderISN.TableName, SysString.ToDBString(p_FieldValue), "ID", entity.ID);
DataTable dt = p_sqlTrans.Fill(sql);
if (dt.Rows.Count != 0)
{
ret = true;
}
return(ret);
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public int RSaveFault(CheckOrderISNFault p_BE, CheckOrderISN entityMain, int MainID, int PackDtsID, IDBTransAccess sqlTrans)
{
try
{
if (PackDtsID == 0)
{
throw new Exception("请先选择检验指示单");
}
CheckOrderISNFault entity = p_BE as CheckOrderISNFault;
if (MainID == 0)
{
entityMain.MainID = PackDtsID;
CheckOrderISNRule rulebp = new CheckOrderISNRule();
//entityMain.CY += entity.CYQty;
entityMain.Qty = entityMain.ChkQty - entityMain.KJQty;
rulebp.RAdd(entityMain, sqlTrans);
entity.MainID = entityMain.ID;
}
else
{
CheckOrderISNRule rulebp = new CheckOrderISNRule();
//entityMain.CY += entity.CYQty;
entityMain.Qty = entityMain.ChkQty - entityMain.KJQty;
rulebp.RUpdate(entityMain, sqlTrans);
}
RAdd(entity, sqlTrans);
return(entity.MainID);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 获得布实体
/// </summary>
/// <returns></returns>
public CheckOrderISN EntityGet()
{
CheckOrderISN enity = new CheckOrderISN();
enity.ID = ISNID;
enity.SelectByID();
CheckOrderDts entityp = new CheckOrderDts();//检验指示单明细表信息
entityp.ID = DtsID;
entityp.SelectByID();
CheckOrder entityM = new CheckOrder();//检验指示单主表信息
entityM.ID = entityp.MainID;
entityM.SelectByID();
enity.ItemCode = entityM.ItemCode;
enity.ItemName = entityM.ItemName;
enity.ItemStd = entityM.ItemStd;
enity.ItemModel = entityM.ItemModel;
enity.MWeight = entityM.MWeight;
enity.MWidth = entityM.MWidth;
enity.ColorNum = entityp.ColorNum;
enity.ColorName = entityp.ColorName;
enity.Batch = entityp.Batch;
enity.VendorBatch = entityp.VendorBatch;
//enity.JarNum = entityp.JarNum;
enity.JarNum = lblJarNum.Text.Trim();
enity.YQty = entityp.Qty;//原米数
if (SysConvert.ToDecimal(lblQty.Text.Trim()) != 0m)
{
enity.ChkQty = SysConvert.ToDecimal(lblQty.Text.Trim());
}
else
{
throw new Exception("数据异常，未读取到码表数据，请稍后重新点击");
}
enity.ChkMWeight = entityM.MWeight; //检验的克重
enity.ChkMWidth = entityM.MWidth; //检验的门幅
enity.CheckDate = DateTime.Now;
enity.CheckOPID = FParamConfig.LoginID;
//EndityGetSetValue(enity);//继承类附加属性
return(enity);
}
/// <summary>
/// 疵点保存
/// </summary>
private void CDSave()
{
//ReadStart();
CheckOrderISNFaultRule rule = new CheckOrderISNFaultRule();
CheckOrderISN entityMain = EntityGet();
CheckOrderISNFault entityDtsFault = EntityGetDtsFault();
rule.RSaveFault(entityDtsFault, entityMain, m_ISNID, m_DtsID);
btnCDCancel_Click(null, null);
m_ISNID = entityDtsFault.MainID;
BindGrid();
SetEntity(1);
lblPositionS.Text = "";
lblPositionE.Text = "";
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
CheckOrderISN entity = (CheckOrderISN)p_BE;
CheckOrderISNCtl control = new CheckOrderISNCtl(sqlTrans);
control.Delete(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
CheckOrderISN entity = (CheckOrderISN)p_BE;
//CheckOrderISNCtl control=new CheckOrderISNCtl(sqlTrans);
//entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Chk_CheckOrderISN, sqlTrans);
//control.AddNew(entity);
if (entity.ID == 0)
{
CheckOrderISNCtl control = new CheckOrderISNCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Chk_CheckOrderISN, sqlTrans);
if (entity.Seq == 0)
{
entity.StatusID = (int)EnumBoxStatus.未入库;
entity.DISN = GetDISN(sqlTrans);
entity.Seq = GetMaxSeq(entity.MainID, entity.JarNum, sqlTrans);
entity.ReelNo = SysConvert.ToString(entity.Seq);//卷号
}
control.AddNew(entity);
}
else
{
if (entity.StatusID != (int)EnumBoxStatus.未入库)//已经入库的条码不能修改
{
throw new Exception("条码不是初始状态不能修改");
}
RUpdate(entity, sqlTrans);
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
private void btnDelete_Click_1(object sender, EventArgs e)
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.除))
{
this.ShowMessage("你没有此操作权限");
return;
}
if (MessageBox.Show("确定要删除这匹布吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
int ID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("DID"));
CheckOrderISN entity = new CheckOrderISN();
entity.ID = ID;
entity.SelectByID();
if (entity.StatusID > (int)EnumBoxStatus.未入库)
{
this.ShowMessage("布匹已经入库，请检查");
return;
}
//if (entity.KF25 == 1)
//{
// this.ShowMessage("开匹的数据不能删除");
// return;
//}
//if (entity.KF22 == 1)
//{
// this.ShowMessage("退货冲销修改的数据不能删除");
// return;
//}
CheckOrderISNRule rule = new CheckOrderISNRule();
rule.RDelete(entity);
btnQuery_Click(null, null);
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
CheckOrderISN entity = (CheckOrderISN)p_BE;
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
CheckOrderISN MasterEntity = (CheckOrderISN)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Chk_CheckOrderISN(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("MainID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MainID) + ",");
MasterField.Append("Seq" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ",");
MasterField.Append("DISN" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DISN) + ",");
MasterField.Append("StatusID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.StatusID) + ",");
MasterField.Append("InWHFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.InWHFlag) + ",");
MasterField.Append("CheckOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CheckOPID) + ",");
MasterField.Append("CheckDate" + ",");
if (MasterEntity.CheckDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ItemCode" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemCode) + ",");
MasterField.Append("ItemName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemName) + ",");
MasterField.Append("ItemStd" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemStd) + ",");
MasterField.Append("ItemModel" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemModel) + ",");
MasterField.Append("MWidth" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MWidth) + ",");
MasterField.Append("MWeight" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MWeight) + ",");
MasterField.Append("ColorNum" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorNum) + ",");
MasterField.Append("ColorName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorName) + ",");
MasterField.Append("Batch" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Batch) + ",");
MasterField.Append("VendorBatch" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VendorBatch) + ",");
MasterField.Append("JarNum" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.JarNum) + ",");
MasterField.Append("ReelNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ReelNo) + ",");
MasterField.Append("YQty" + ",");
if (MasterEntity.YQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.YQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ChkQty" + ",");
if (MasterEntity.ChkQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.ChkQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Qty" + ",");
if (MasterEntity.Qty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Qty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("KJQty" + ",");
if (MasterEntity.KJQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.KJQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ChkMWidth" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ChkMWidth) + ",");
MasterField.Append("ChkMWeight" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ChkMWeight) + ",");
MasterField.Append("ChkQtyKG" + ",");
if (MasterEntity.ChkQtyKG != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.ChkQtyKG) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("FaultDesc" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FaultDesc) + ",");
MasterField.Append("ChkLevel" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.ChkLevel) + ")");
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 检验结束
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public int RJYEnd(int p_BE, CheckOrderISN entity2, int p_PackID, decimal Qty, decimal YMQty, int ReelNo, IDBTransAccess sqlTrans)
{
try
{
if (p_BE == 0)//如果是0 则表示没有疵点
{
entity2.MainID = p_PackID;
CheckOrderISNRule rulebp = new CheckOrderISNRule();
rulebp.RAdd(entity2, sqlTrans);
p_BE = entity2.ID;
}
CheckOrderISN entity = new CheckOrderISN(sqlTrans);
entity.ID = p_BE;
entity.SelectByID();
entity.MainID = p_PackID;
entity.ChkQty = Qty;//码表数量
entity.ColorName = entity2.ColorName; //颜色
entity.ColorNum = entity2.ColorNum; //色号
entity.MWidth = entity2.MWidth; //平均门幅
entity.MWeight = entity2.MWeight; //平均克重
string sqls = "SELECT MAX(Seq) Seq FROM Chk_CheckOrderISN WHERE JarNum=" + SysString.ToDBString(entity.JarNum);
sqls += " AND MainID=" + p_BE;
//string sqls = "Select ISNULL(Max(ReelNo),0) From Chk_CheckOrderISN where JarNum=" + SysString.ToDBString(SysConvert.ToString(entity.JarNum));
//sqls += " AND ItemCode=" + SysString.ToDBString(SysConvert.ToString(entity.ItemCode));
//sqls += " AND ColorNum=" + SysString.ToDBString(SysConvert.ToString(entity.ColorNum));
DataTable dts = sqlTrans.Fill(sqls);
if ((SysConvert.ToInt32(dts.Rows[0][0]) + 1) != ReelNo)
{
entity.ReelNo = SysConvert.ToString(SysConvert.ToInt32(dts.Rows[0][0]) + 1);//卷号
}
else
{
entity.ReelNo = SysConvert.ToString(ReelNo);//卷号
}
//entity.YQty = SysConvert.ToDecimal(Qty * 1.0936132983377m, 2);//米数转码数
CheckOrderISNRule rule = new CheckOrderISNRule();
rule.RUpdate(entity, sqlTrans);
#region 统计合计数据
entity.KJQty = 0.0m;//开剪数量合计
string sql = "SELECT SUM(cast(Deduction as decimal(10,2))) Deduction FROM Chk_CheckOrderISNFault WHERE 1=1";
sql += " AND MainID=" + p_BE;
sql += " AND FaultType=3";//开剪
sql += " AND ISNUMERIC(Deduction)=1";
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count != 0)
{
entity.KJQty = SysConvert.ToDecimal(dt.Rows[0]["Deduction"]);
}
entity.Qty = SysConvert.ToDecimal(entity.ChkQty - entity.KJQty, 2);//实际数量=码表数量-裁剪数量
CheckOrderISNRule rulebp2 = new CheckOrderISNRule();
rulebp2.RUpdate(entity, sqlTrans);
#endregion
#region 合计检验米数汇总到待检清单
sql = "Select SUM(Qty) Qty from Chk_CheckOrderISN where MainID=" + p_PackID;
DataTable dtS = sqlTrans.Fill(sql);
if (dtS.Rows.Count != 0)
{
sql = "Update Chk_CheckOrderDts Set CheckQty=" + SysConvert.ToDecimal(dtS.Rows[0]["Qty"]);
sql += " where ID=" + p_PackID;
sqlTrans.ExecuteNonQuery(sql);
}
#endregion
#region 计算同个缸号的平均门幅、克重
//decimal AvgMWidth = 0.0m;
//decimal AvgMWeight = 0.0m;
//sql = "Select Avg(MWidth) MWidth,Avg(MWeight) MWeight from WO_BProductCheckDtsFault where 1=1";
//sql += " AND MainID in(select ID from WO_BProductCheckDts where 1=1 AND MainID=" + entity.MainID + ")";
//sql += " AND ISNULL(MWidth,0)<>0 AND ISNULL(MWeight,0)<>0 ";
//DataTable dtAvg = sqlTrans.Fill(sql);
//if (dtAvg.Rows.Count != 0)
//{
// AvgMWidth = SysConvert.ToDecimal(dtAvg.Rows[0]["MWidth"]);
// AvgMWeight = SysConvert.ToDecimal(dtAvg.Rows[0]["MWeight"]);
//}
//sql = "Update WO_BProductCheckDts set JarNumMWidth =" + AvgMWidth;
//sql += ",JarNumMWeight=" + AvgMWeight;
//sql += " where 1=1 AND MainID=" + entity.MainID;
//sqlTrans.ExecuteNonQuery(sql);
#endregion
return(p_BE);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
CheckOrderISN MasterEntity = (CheckOrderISN)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Chk_CheckOrderISN SET ");
UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ",");
UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ",");
UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ",");
UpdateBuilder.Append(" DISN=" + SysString.ToDBString(MasterEntity.DISN) + ",");
UpdateBuilder.Append(" StatusID=" + SysString.ToDBString(MasterEntity.StatusID) + ",");
UpdateBuilder.Append(" InWHFlag=" + SysString.ToDBString(MasterEntity.InWHFlag) + ",");
UpdateBuilder.Append(" CheckOPID=" + SysString.ToDBString(MasterEntity.CheckOPID) + ",");
if (MasterEntity.CheckDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" CheckDate=" + SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" CheckDate=null,");
}
UpdateBuilder.Append(" ItemCode=" + SysString.ToDBString(MasterEntity.ItemCode) + ",");
UpdateBuilder.Append(" ItemName=" + SysString.ToDBString(MasterEntity.ItemName) + ",");
UpdateBuilder.Append(" ItemStd=" + SysString.ToDBString(MasterEntity.ItemStd) + ",");
UpdateBuilder.Append(" ItemModel=" + SysString.ToDBString(MasterEntity.ItemModel) + ",");
UpdateBuilder.Append(" MWidth=" + SysString.ToDBString(MasterEntity.MWidth) + ",");
UpdateBuilder.Append(" MWeight=" + SysString.ToDBString(MasterEntity.MWeight) + ",");
UpdateBuilder.Append(" ColorNum=" + SysString.ToDBString(MasterEntity.ColorNum) + ",");
UpdateBuilder.Append(" ColorName=" + SysString.ToDBString(MasterEntity.ColorName) + ",");
UpdateBuilder.Append(" Batch=" + SysString.ToDBString(MasterEntity.Batch) + ",");
UpdateBuilder.Append(" VendorBatch=" + SysString.ToDBString(MasterEntity.VendorBatch) + ",");
UpdateBuilder.Append(" JarNum=" + SysString.ToDBString(MasterEntity.JarNum) + ",");
UpdateBuilder.Append(" ReelNo=" + SysString.ToDBString(MasterEntity.ReelNo) + ",");
if (MasterEntity.YQty != 0)
{
UpdateBuilder.Append(" YQty=" + SysString.ToDBString(MasterEntity.YQty) + ",");
}
else
{
UpdateBuilder.Append(" YQty=null,");
}
if (MasterEntity.ChkQty != 0)
{
UpdateBuilder.Append(" ChkQty=" + SysString.ToDBString(MasterEntity.ChkQty) + ",");
}
else
{
UpdateBuilder.Append(" ChkQty=null,");
}
if (MasterEntity.Qty != 0)
{
UpdateBuilder.Append(" Qty=" + SysString.ToDBString(MasterEntity.Qty) + ",");
}
else
{
UpdateBuilder.Append(" Qty=null,");
}
if (MasterEntity.KJQty != 0)
{
UpdateBuilder.Append(" KJQty=" + SysString.ToDBString(MasterEntity.KJQty) + ",");
}
else
{
UpdateBuilder.Append(" KJQty=null,");
}
UpdateBuilder.Append(" ChkMWidth=" + SysString.ToDBString(MasterEntity.ChkMWidth) + ",");
UpdateBuilder.Append(" ChkMWeight=" + SysString.ToDBString(MasterEntity.ChkMWeight) + ",");
if (MasterEntity.ChkQtyKG != 0)
{
UpdateBuilder.Append(" ChkQtyKG=" + SysString.ToDBString(MasterEntity.ChkQtyKG) + ",");
}
else
{
UpdateBuilder.Append(" ChkQtyKG=null,");
}
UpdateBuilder.Append(" FaultDesc=" + SysString.ToDBString(MasterEntity.FaultDesc) + ",");
UpdateBuilder.Append(" ChkLevel=" + SysString.ToDBString(MasterEntity.ChkLevel));
UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}
