/// <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("操作失败！");
}
}
}
/// <summary>
/// 删除
/// </summary>
private void tsbDelete_Click()
{
try
{
int j = 0;
if (listrecordID.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//遍历
for (int i = 0; i < listrecordID.Count; i++)
{
Expression <Func <Unusual, bool> > funUnusual = n => n.Unusual_Id == Convert.ToInt32(listrecordID[i]);
if (!UnusualDAL.DeleteToMany(funUnusual))
{
j++;
}
}
if (j == 0)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
string strContent = "质检编号为：" + Convert.ToInt32(DGVUnusual.SelectedRows[0].Cells["QCInfo_ID"].Value.ToString()) + "，质检车牌号为：" + this.txtCarNO.Text.Trim() + "，删除成功！";
LogInfoDAL.loginfoadd("删除", "删除质检信息", Common.USERNAME);//添加日志
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！");
}
}
catch (Exception ex)
{
Common.WriteTextLog("异常信息处理 tsbDelete_Click()+" + ex.Message.ToString());
}
finally
{
page = new PageControl();
LoadData("");
page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
}
}
public MainFrom mf;//主窗体
/// <summary>
/// 单击发送按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSMSSend_Click(object sender, EventArgs e)
{
//短信内容
if (string.IsNullOrEmpty(txtcontent.Text.Trim()))
{
MessageBox.Show("请输入短信内容");
return;
}
//质检状态改为暂停质检
LinQBaseDao.Query("update QCInfo set QCInfo_Dictionary_ID=(select Dictionary_ID from Dictionary where Dictionary_Name='暂停质检') where QCInfo_ID=" + QcinfoID);
//添加异常信息
//insert into Unusual values(质检编号,异常类型编号,异常类型编号,'内容','未处理',经手人编号,0)
Unusual un = new Unusual();
un.Unusual_QCInfo_ID = QcinfoID;
un.Unusual_UnusualType_Id = Convert.ToInt32(cboUnusualType_Name.SelectedValue);
un.Unusual_TestItems_ID = Convert.ToInt32(cboUnusualType_Name.SelectedValue);
un.Unusual_content = cboUnusualType_Name.Text + "异常：" + txtcontent.Text.Trim();
un.Unusual_State = "未处理";
un.Unusual_ISSMSSend = false;
un.Unusual_time = LinQBaseDao.getDate();
int u_id = 0;
if (UnusualDAL.InsertOneQCRecord(un, out u_id))
{
MessageBox.Show("短信发送成功！");
int TestItems_ID = Convert.ToInt32(cboUnusualType_Name.SelectedValue);
//发送内容及发送人
DataSet SMSDs = LinQBaseDao.Query("select top(1)* from SMSConfigure where SMSConfigure_TestItems_ID=" + TestItems_ID);//只会存在一条
#region 取内容
string[] SMSContent = SMSDs.Tables[0].Rows[0]["SMSConfigure_SendContent"].ToString().Split(',');
string[] SMSContentTxt = SMSDs.Tables[0].Rows[0]["SMSConfigure_SendContentText"].ToString().Split(',');
string Contents = SMSSendContent(SMSContent, un.Unusual_Id, SMSContentTxt, un.Unusual_content);//存储短信内容
#endregion
#region 取号码、姓名,并对其号码发送短信（号码和姓名同位置是一组数据）
string[] SMSPhon = SMSDs.Tables[0].Rows[0]["SMSConfigure_ReceivePhone"].ToString().Split(';'); //号码
string[] SMSName = SMSDs.Tables[0].Rows[0]["SMSConfigure_Receive"].ToString().Split(';'); //姓名
for (int y = 0; y < SMSPhon.Count(); y++) //循环要发送的人数的电话号码
{
if (SMSPhon[y] != "")
{
SmsSend ss = new SmsSend();
ss.SmsSend_Phone = SMSPhon[y];
ss.SmsSend_Text = Contents;
ss.SmsSend_userName = SMSName[y];
ss.SmsSend_IsSend = "0";
ss.SmsSend_Unusunal_ID = un.Unusual_Id;
bool b = SmsSendDAL.Insert(ss);
}
}
#endregion
Emety();
}
else
{
MessageBox.Show("短信发送失败！");
return;
}
}
/// <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);
}
