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