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>
/// <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);
}
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>
/// <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);
}
}