/// <summary>
/// 抽包
/// </summary>
/// <param name="qcinfoid"></param>
private void getPackets(int qcinfoid, int did)
{
try
{
//DTS包号
List <string> listbags = QCInfoDAL.GetBags(qcinfoid);
//总包数
DataTable dtNO_OF_BALES = LinQBaseDao.Query("select NO_OF_BALES from dbo.DRAW_EXAM_INTERFACE where DRAW_EXAM_INTERFACE_ID=" + did).Tables[0];
string Packets_DTS = "";//DTS string类型包号
foreach (string item in listbags)
{
Packets_DTS += item + ",";
}
Packets_DTS = Packets_DTS.TrimEnd(',');
Packets p = new Packets();
p.Packets_DTS = Packets_DTS;
p.Packets_this = "";
p.Packets_QCInfo_DRAW_EXAM_INTERFACE_ID = did;
p.Packets_Time = DateTime.Now;
PacketsDAL.InsertOneQCRecord(p);
Common.GetSumWaterCount(qcinfoid);
LinQBaseDao.Query("update QCInfo set QCInfo_DRAW='" + Packets_DTS + "',QCInfo_PumpingPackets=" + Packets_DTS.Split(',').Count() + ",QCInfo_MOIST_Count=" + Common.SumWaterCount + " where QCInfo_ID=" + qcinfoid);
}
catch
{
}
}
/// <summary>
/// 收货
/// </summary>
private void tsbShouHuoClick()
{
if (MessageBox.Show("确定要收货吗？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
bool b = UpdateQCinfo("质检中");//修改质检状态为继续质检
if (b == false)
{
MessageBox.Show("操作失败！");
return;
}
foreach (int item in QCInfoIDS)
{
Expression <Func <QCInfo, bool> > fnQCiNFO = n => n.QCInfo_ID == item;
Action <QCInfo> ACQCInfo = q =>
{
q.QCInfo_RECV_RMA_METHOD = "收货";
q.QCInfo_REMARK = txtRemork.Text.Trim();
};
bool bol = QCInfoDAL.Update(fnQCiNFO, ACQCInfo);
if (bol == true)
{
Expression <Func <Unusual, bool> > fnUnusual = n => n.Unusual_QCInfo_ID == item && n.Unusual_State == "未处理";
var Unusuals = UnusualDAL.Query(fnUnusual);
foreach (var u in Unusuals)
{
Expression <Func <Unusual, bool> > fnU = n => n.Unusual_Id == u.Unusual_Id;
Action <Unusual> AcUnusual_Id = a =>
{
a.Unusual_State = "已处理";
a.Unusual_handle_UserId = Convert.ToInt32(Common.USERID);
a.Unusual_handle_Result = "收货";
if (CardPeoples != "")
{
a.Unusual_Remork = "异常处理授权人：" + CardPeoples;
}
else
{
a.Unusual_Remork = "";
}
};
UnusualDAL.Update(fnU, AcUnusual_Id);
}
}
}
MessageBox.Show("操作成功！");
}
catch
{
MessageBox.Show("操作失败！");
}
}
}
private void btn_CarAdd_Click(object sender, EventArgs e)
{
try
{
DRAW_EXAM_INTERFACE d = new DRAW_EXAM_INTERFACE();
QCInfo c = new QCInfo();
RegisterLoosePaperDistribution r = new RegisterLoosePaperDistribution();
Packets p = new Packets();
if (txt_SHIPMENT_NO.Text != "")
{
d.SHIPMENT_NO = txt_SHIPMENT_NO.Text.Trim();
}
else
{
MessageBox.Show("送货单号不能为空");
return;
}
if (txt_PO_NO.Text != "")
{
d.PO_NO = txt_PO_NO.Text.Trim();
}
else
{
MessageBox.Show("采购单号不能为空");
return;
}
if (cmb_PROD_ID.Text != "")
{
d.PROD_ID = cmb_PROD_ID.Text.Trim();
}
else
{
MessageBox.Show("货品不能为空");
return;
}
if (txt_CNTR_NO.Text != "")
{
d.CNTR_NO = txt_CNTR_NO.Text.Trim();
}
else
{
MessageBox.Show("车牌号不能为空");
return;
}
DataTable dt = LinQBaseDao.Query("select * from Unusualstandard where Unusualstandard_PROD ='" + cmb_PROD_ID.Text.Trim() + "' ").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
d.DEGRADE_MATERIAL_PERCT = Convert.ToDecimal(dt.Rows[0]["Unusualstandard_DEGRADE_MATERIAL_PERCT"]);
d.DEGRADE_MOISTURE_PERCT = Convert.ToDecimal(dt.Rows[0]["Unusualstandard_DEGRADE_MOISTURE_PERCT"]);
d.DEGRADE_OUTTHROWS_PERCT = Convert.ToDecimal(dt.Rows[0]["DEGRADE_OUTTHROWS_PERCT"]);
}
//过数表填写数据
d.COMPANY_ID = "9";
d.CREATE_DTTM = d.WEIGHT_DATE = DateTime.Now;
d.WEIGHT_TICKET_NO = txt_WEIGHT_TICKET_NO.Text.Trim();
d.REF_NO = txt_REF_NO.Text.Trim();
d.NO_OF_BALES = Convert.ToInt32(txtsendNum.Text.Trim());
d.DRAW_ONE = 0;
d.DRAW_TWO = 0;
d.DRAW_THREE = 0;
d.DRAW_FOUR = 0;
d.DRAW_FIVE = 0;
d.DRAW_SIX = 0;
d.DRAW_7 = 0;
d.DRAW_8 = 0;
d.DRAW_9 = 0;
d.DRAW_10 = 0;
d.DRAW_11 = 0;
d.DRAW_12 = 0;
d.DRAW_13 = 0;
d.DRAW_14 = 0;
d.IS_FINISHED = "Y";
d.CREATE_BY = Common.USERNAME; //记录人：当前登录人
d.IS_DengJi = "Y";
d.FINISHED_BY = "";
d.FINISHED_DTTM = Convert.ToDateTime("1900 - 01 - 01 00:00:00");
d.RECV_RMA_METHOD = "";
d.TRANS_TO_WPIS_FLAG = "Y";
d.TRANS_TO_WPIS_DTTM = DateTime.Now;
d.TRANS_TO_DTS_FLAG = "";
d.TRANS_TO_DTS_DTTM = Convert.ToDateTime("1900 - 01 - 01 00:00:00");
//d.IsSource = "手动";
string[] dtsList = txtchkNum.Text.Split(',');
for (int i = 0; i < dtsList.Length; i++)
{
switch (i)
{
case 0:
d.DRAW_ONE = Convert.ToInt32(dtsList[i]);
break;
case 1:
d.DRAW_TWO = Convert.ToInt32(dtsList[i]);
break;
case 2:
d.DRAW_THREE = Convert.ToInt32(dtsList[i]);
break;
case 3:
d.DRAW_FOUR = Convert.ToInt32(dtsList[i]);
break;
case 4:
d.DRAW_FIVE = Convert.ToInt32(dtsList[i]);
break;
case 5:
d.DRAW_SIX = Convert.ToInt32(dtsList[i]);
break;
case 6:
d.DRAW_7 = Convert.ToInt32(dtsList[i]);
break;
case 7:
d.DRAW_8 = Convert.ToInt32(dtsList[i]);
break;
case 8:
d.DRAW_9 = Convert.ToInt32(dtsList[i]);
break;
case 9:
d.DRAW_10 = Convert.ToInt32(dtsList[i]);
break;
case 10:
d.DRAW_11 = Convert.ToInt32(dtsList[i]);
break;
case 11:
d.DRAW_12 = Convert.ToInt32(dtsList[i]);
break;
case 12:
d.DRAW_13 = Convert.ToInt32(dtsList[i]);
break;
case 13:
d.DRAW_14 = Convert.ToInt32(dtsList[i]);
break;
}
}
int result = 0;
DRAW_EXAM_INTERFACEDAL.InsertOneCarInfo(d, out result);
if (result > 0)
{
//MessageBox.Show("添加成功！");
//this.Close();
// LoadData();
//查询新增过数ID
//质检登记成功填写数据
int result2 = 0;
r.OrganizationID = "ChongQingPaper";
r.R_DRAW_EXAM_INTERFACE_ID = result;
r.DepartmentCode = txtBuMen_Code.Text.Trim();
r.ExtensionField2 = txtDuiWei_code.Text.Trim();
r.issend = false;
RegisterLoosePaperDistributionDAL.InsertOneCarInfo(r, out result2);
//质检表填写数据
int result3 = 0;
c.QCInfo_Dictionary_ID = 8;
c.QCInfo_STATE = 2;
c.QCInfo_DEGREE = 1;
c.QCInfo_UnpackBefore_MOIST_PER_COUNT = 0;
c.QCInfo_UnpackBack_MOIST_COUNT = 0;
c.QCInfo_TIME = DateTime.Now; //日期时间
c.QCInfo_Client_ID = Common.CLIENTID; //客户端配置编号
c.QCInfo_UserId = EMEWE.Common.Converter.ToInt(Common.USERID); //记录人：当前登录人
c.QCInfo_DRAW_EXAM_INTERFACE_ID = result;
c.QCInfo_PumpingPackets = dtsList.Length;
c.QCInfo_DRAW = txtchkNum.Text.Trim();
if (dtsList.Length <= 4)
{
c.QCInfo_MOIST_Count = dtsList.Length * 8;
}
else
{
c.QCInfo_MOIST_Count = 32;
}
QCInfoDAL.InsertOneCarInfo(c, out result3);
if (result > 0)
{
MessageBox.Show("添加成功！");
int result4 = 0;
p.Packets_DTS = txtchkNum.Text.Trim();
p.Packets_this = "1";
p.Packets_QCInfo_DRAW_EXAM_INTERFACE_ID = result;
p.Packets_Time = DateTime.Now;
PacketsDAL.InsertOneCarInfo(p, out result4);
this.Close();
// LoadData();
}
}
}
catch (Exception err)
{
}
}
/// <summary>
/// 登记方法
/// </summary>
private void QcInfoAdd()
{
try
{
if (lvwUserList.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(lvwUserList.SelectedRows[0].Cells["DRAW_EXAM_INTERFACE_ID"].Value);
StringBuilder sbMessage = new StringBuilder();
int QCInfo_Dictionary_ID = 0;
int QCInfo_STATE = 0;
var dictionary = DictionaryDAL.Query();
foreach (var m in dictionary)
{
if (m.Dictionary_Name == "质检中")
{
QCInfo_Dictionary_ID = m.Dictionary_ID;
}
if (m.Dictionary_Name == "启动")
{
QCInfo_STATE = m.Dictionary_ID; //数据状态（启动）
}
}
int irnt = 0;
#region ykWarning： 和U9交互 纸种为 LSOP1的不和U9交互 ，测试的时候，可以删除U9交互，发布的时候务必要还原。
//#if !DEBUG
string PROD_ID = lvwUserList.SelectedRows[0].Cells["PROD_ID"].Value.ToString();
if (isIdebarJoinU9(PROD_ID))
{
DataSet ds = LinQBaseDao.Query("select SHIPMENT_NO,CNTR_NO from dbo.DRAW_EXAM_INTERFACE where DRAW_EXAM_INTERFACE_ID=" + id);
if (ds.Tables[0].Rows.Count > 0)
{
string SHIPMENT_NO = ds.Tables[0].Rows[0][0].ToString();
if (!gainData(SHIPMENT_NO, id))
{
string CNTR_NO = ds.Tables[0].Rows[0][0].ToString();
MessageBox.Show(CNTR_NO + "从U9获取数据失败，不能登记！");
return;
}
}
else
{
MessageBox.Show("登记失败！");
return;
}
}
else
{
DataSet ds = LinQBaseDao.Query("select SHIPMENT_NO,CNTR_NO from dbo.DRAW_EXAM_INTERFACE where DRAW_EXAM_INTERFACE_ID=" + id);
if (ds.Tables[0].Rows.Count > 0)
{
RegisterLoosePaperDistribution rpdb = new RegisterLoosePaperDistribution();
rpdb.R_DRAW_EXAM_INTERFACE_ID = id;
rpdb.issend = false;
LinQBaseDao.InsertOne(dc, rpdb);
}
}
//#endif
#endregion
if (YesNoDengJi(id))
{
MessageBox.Show("该信息已登记过", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Bangding_Load(RegistrationWhere());//更新数据
ids.Clear();
return;
}
var qf = new QCInfo();
qf.QCInfo_Dictionary_ID = QCInfo_Dictionary_ID;
qf.QCInfo_STATE = QCInfo_STATE;
int k = QCInfoDAL.GetIntDRAWCount(id);//抽样总次数
qf.QCInfo_PumpingPackets = k;
#region 周意 规则加上后需要修改
//e ReckonWaterTestCount(qf.QCInfo_ID);
qf.QCInfo_UnpackBefore_MOIST_PER_COUNT = OneCQCount + TwoCQCount;
qf.QCInfo_UnpackBack_MOIST_COUNT = OneCHCount + TwoCHCount;
#endregion
qf.QCInfo_DRAW_EXAM_INTERFACE_ID = id;
qf.QCInfo_DEGREE = 1; //检测次数
qf.QCInfo_TIME = DateTime.Now; //日期时间
qf.QCInfo_Client_ID = Common.CLIENTID; //客户端配置编号
qf.QCInfo_UserId = EMEWE.Common.Converter.ToInt(Common.USERID); //记录人：当前登录人
//修改抽样表状态
Action <DRAW_EXAM_INTERFACE> ap = n =>
{
//liemrao begin update 20160901
//n.IS_DengJi = Convert.ToChar("Y");
n.IS_DengJi = "Y";
//end update
};
Expression <Func <DRAW_EXAM_INTERFACE, bool> > p1 = n => n.DRAW_EXAM_INTERFACE_ID == id;
bool rboolDRAW_EXAM_INTERFACEDAL = DRAW_EXAM_INTERFACEDAL.Update(p1, ap);
if (rboolDRAW_EXAM_INTERFACEDAL)
{
if (QCInfoDAL.addQCInfoDAL(qf))
{
irnt++;
sbMessage.Append(id + ",");
Common.WriteLogData("新增", "登记数据抽样编号为：" + id, Common.NAME); //操作日志
#region 抽包
getPackets(qf.QCInfo_ID, id);
#endregion
}
else
{
//修改抽样表状态
Action <DRAW_EXAM_INTERFACE> ap2 = n =>
{
n.IS_DengJi = null;
};
Expression <Func <DRAW_EXAM_INTERFACE, bool> > p2 = n => n.DRAW_EXAM_INTERFACE_ID == id;
DRAW_EXAM_INTERFACEDAL.Update(p2, ap2);
}
}
if (!string.IsNullOrEmpty(sbMessage.ToString()))
{
DialogResult dia = MessageBox.Show("登记数据抽样编号为：" + sbMessage.ToString() + "成功\r\n是否现场抽包？", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dia.Equals(DialogResult.Yes))
{
tChoosePacks.Enabled = false;
ChoosePacks();
tChoosePacks.Enabled = true;
}
}
else//没有选中
{
MessageBox.Show("请选择列表再开始质检！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch
{
MessageBox.Show("登记失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
page = new PageControl();
page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
Bangding_Load(RegistrationWhere());//更新数据
}
}
/// <summary>
/// 修改质检状态
/// </summary>
/// <param name="dicName">字典名称</param>
private bool UpdateQCinfo(string dicName)
{
int num = 0;
DataTable statisIdDT = LinQBaseDao.Query("select Dictionary_ID from Dictionary where Dictionary_Name='" + dicName + "'").Tables[0];
if (QCInfoIDS.Count > 0)
{
int statisId = Convert.ToInt32(statisIdDT.Rows[0][0]);
foreach (int item in QCInfoIDS)//循环质检编号
{
Expression <Func <QCInfo, bool> > fnQCiNFO = n => n.QCInfo_ID == item;
Action <QCInfo> ACQCInfo = q =>
{
q.QCInfo_Dictionary_ID = statisId;
q.QCInfo_RECV_RMA_METHOD = null;
q.QCInfo_REMARK = txtRemork.Text.Trim();
};
bool b = QCInfoDAL.Update(fnQCiNFO, ACQCInfo);
if (b == true)
{
Expression <Func <Unusual, bool> > fnUnusual = n => n.Unusual_QCInfo_ID == item && n.Unusual_State == "未处理";
var Unusuals = UnusualDAL.Query(fnUnusual);
foreach (var u in Unusuals)
{
Expression <Func <Unusual, bool> > fnU = n => n.Unusual_Id == u.Unusual_Id;
Action <Unusual> AcUnusual_Id = a =>
{
a.Unusual_State = "已处理";
a.Unusual_handle_UserId = Convert.ToInt32(Common.USERID);
if (dicName == "质检中")
{
a.Unusual_handle_Result = "继续质检";
}
else
{
a.Unusual_handle_Result = "暂停质检";
}
if (CardPeoples != "")
{
a.Unusual_Remork = "异常处理授权人：" + CardPeoples;
}
else
{
a.Unusual_Remork = "";
}
};
bool bl = UnusualDAL.Update(fnU, AcUnusual_Id);
if (bl)
{
num++;
}
}
}
}
}
if (num > 0)
{
return(true);
}
return(false);
}
