/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpUser_Click(object sender, EventArgs e) { try { if (this.txtTestItems_Count.Text == "") { mf.ShowToolTip(ToolTipIcon.Info, "提示", "检测项目次数不能为空!", txtTestItems_Count, this); return; } if (this.txtTestItems_Name.Text == "") { mf.ShowToolTip(ToolTipIcon.Info, "提示", "检测项目名称不能为空!", txtTestItems_Count, this); return; } if (Convert.ToDouble(this.txtTestItems_Count.Text) == 0) { mf.ShowToolTip(ToolTipIcon.Info, "提示", "检测项目次数不能为零!", txtTestItems_Count, this); return; } if (this.cbxTestItemsState.SelectedIndex > -1) { Expression <Func <TestItems, bool> > p = n => n.TestItems_NAME == this.lvwTestItems.SelectedRows[0].Cells["TestItems_NAME"].Value.ToString(); Action <TestItems> ap = s => { s.TestItems_NAME = this.txtTestItems_Name.Text.Trim(); //s.Tes_TestItems_ID = Convert.ToInt32(this.txtTes_TestItems_ID.Text.Trim()); s.Tes_TestItems_ID = Convert.ToInt32(this.cbxTes_TestItems_ID.SelectedValue); s.TestItems_Dictionary_ID = Convert.ToInt32(this.cbxTestItemsState.SelectedValue); s.TestItems_COUNT = Convert.ToInt32(this.txtTestItems_Count.Text.Trim()); s.TestItems_REMARK = this.txtTestItems_Remark.Text.Trim(); }; if (TestItemsDAL.Update(p, ap)) { MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } string strContent = "检测项目名称为:" + this.txtTestItems_Name.Text.Trim();; LogInfoDAL.loginfoadd("修改", "修改 " + strContent + " 的信息", Common.USERNAME);//添加日志 } } catch (Exception ex) { Common.WriteTextLog("项目检测管理 bntUpUser_Click()" + ex.Message.ToString()); } finally { page = new PageControl(); page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); LoadData(); ShowAddButton(); } }
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { try { if (this.txtTestItems_Count.Text == "") { mf.ShowToolTip(ToolTipIcon.Info, "提示", "检测项目次数不能为空!", txtTestItems_Count, this); return; } if (Convert.ToDouble(this.txtTestItems_Count.Text) == 0) { mf.ShowToolTip(ToolTipIcon.Info, "提示", "检测项目次数不能为零!", txtTestItems_Count, this); return; } //ValidateTextBox();//调用验证文本框方法 if (!btnCheck()) { return; //去重 } var TestItemsadd = new TestItems { TestItems_NAME = this.txtTestItems_Name.Text.Trim(), //Tes_TestItems_ID = Convert.ToInt32(this.txtTes_TestItems_ID.Text.Trim()), Tes_TestItems_ID = Convert.ToInt32(this.cbxTes_TestItems_ID.SelectedValue), TestItems_Dictionary_ID = Convert.ToInt32(this.cbxTestItemsState.SelectedValue), TestItems_COUNT = Convert.ToInt32(this.txtTestItems_Count.Text.Trim()), TestItems_REMARK = this.txtTestItems_Remark.Text.Trim() }; if (TestItemsDAL.InsertOneQCRecord(TestItemsadd)) { MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } string strContent = "检测项目名称为:" + this.txtTestItems_Name.Text.Trim();; LogInfoDAL.loginfoadd("新增", "新增 " + strContent + " 的信息", Common.USERNAME);//添加日志 } catch (Exception ex) { Common.WriteTextLog("项目检测管理 btnAdd_Click()" + ex.Message.ToString()); } finally { page = new PageControl(); page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); LoadData(); } }
/// <summary> ///删除项目检测信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tbtnDelUser_delete() { try { int j = 0; if (lvwTestItems.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 int count = lvwTestItems.SelectedRows.Count; string id = ""; //遍历 for (int i = 0; i < count; i++) { Expression <Func <TestItems, bool> > funuserinfo = n => n.TestItems_ID == Convert.ToInt32(this.lvwTestItems.SelectedRows[i].Cells["TestItems_ID"].Value.ToString()); if (!TestItemsDAL.DeleteToMany(funuserinfo)) { j++; } } if (j == 0) { MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } string strContent = "检测项目编号为:" + this.lvwTestItems.SelectedRows[0].Cells["TestItems_ID"].Value.ToString(); LogInfoDAL.loginfoadd("删除", "删除 " + strContent + " 的信息", Common.USERNAME);//添加日志 } } else//没有选中 { MessageBox.Show("请选择要删除的行!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { Common.WriteTextLog("项目检测管理 tbtnDelUser_delete()+" + ex.Message.ToString()); } finally { page = new PageControl(); page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); LoadData();//更新 } }
/// <summary> /// 登记 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button4_Click(object sender, EventArgs e) { string Instrument_ID = Getclbinstrument(); try { if (this.cob_ClientName.Text != "" && this.clbInstrument_Name.Text != "" && this.cob_Collection_Name.Text != "" && Instrument_ID != "") { string sql = null; //调用判断当前采集端是否被客户端占用的方法 if (!GetCollection_id(false)) { MessageBox.Show("修改失败,该采集端已被占用", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //判断当前采集端是否被客户端占用或者仪表被占用 if (GetInstrument_ID(false)) { MessageBox.Show("修改失败,该仪表已被占用", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } sql = "insert into dbo.PolicyConfigurationInfo values('" + this.cob_ClientName.SelectedValue + "','" + this.cob_Collection_Name.SelectedValue + "','" + Instrument_ID + "')"; int cou = LinQBaseDao.ExecuteSql(sql); if (cou > 0) { MessageBox.Show("登记成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string strContent = "客户端为:" + this.cob_ClientName.Text; LogInfoDAL.loginfoadd("登记", "登记" + strContent + "的策略配置的信息", Common.USERNAME);//添加日志 InstrumentList(); return; } else { MessageBox.Show("登记失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } else { MessageBox.Show("客户端,采集端端,仪表不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (Exception) { } InstrumentList(); }
/// <summary> /// 删除详情信息 /// </summary> private void tsbDelete_Click() { try { int j = 0; if (this.dvgCarList.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 int count = dvgCarList.SelectedRows.Count; //遍历 for (int i = 0; i < count; i++) { Expression <Func <QCRecord, bool> > funQCRecordinfo = n => n.QCInfo.QCInfo_ID == Convert.ToInt32(dvgCarList.SelectedRows[i].Cells["QCInfo_ID"].Value.ToString()); if (!QCRecordDAL.DeleteToMany(funQCRecordinfo)) { j++; } } if (j == 0) { MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } string strContent = "质检编号为:" + Convert.ToInt32(dvgCarList.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(Name);//更新 page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); LoadData(); } }
/// <summary> /// 删除选中的行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsbDelete_Click() { try { int j = 0; if (this.dgv_SFJC.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 int count = dgv_SFJC.SelectedRows.Count; string id = ""; //遍历 for (int i = 0; i < count; i++) { Expression <Func <QCRecord, bool> > funQCRecordinfo = n => n.QCRecord_ID == Convert.ToInt32(dgv_SFJC.SelectedRows[i].Cells["QCRecord_ID"].Value.ToString()); if (!QCRecordDAL.DeleteToMany(funQCRecordinfo)) { j++; } } if (j == 0) { MessageBox.Show("成功删除", "提示"); } else { MessageBox.Show("删除失败", "提示"); } string strContent = "质检记录编号为:" + QCRecord_ID.ToString() + ",删除"; LogInfoDAL.loginfoadd("删除", "删除质检记录信息", Common.USERNAME);//添加日志 } } else//没有选中 { MessageBox.Show("请选择要删除的行!"); } } catch (Exception ex) { Common.WriteTextLog("手动修改管理 tbtnDelUser_delete()+" + ex.Message.ToString()); } finally { LoadData(""); } }
/// <summary> /// 删除 /// </summary> private void tsbDelete_Click() { try { int j = 0; if (this.DGVUnusual.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 int count = DGVUnusual.SelectedRows.Count; //遍历 for (int i = 0; i < count; i++) { Expression <Func <Unusualstandard, bool> > funUnusual = n => n.Unusualstandard_ID == Convert.ToInt32(DGVUnusual.SelectedRows[i].Cells["Unusualstandard_ID"].Value.ToString()); if (!UnusualstandardDAL.DeleteToMany(funUnusual)) { j++; LogInfoDAL.loginfoadd("删除", "删除检测项目异常标准:" + DGVUnusual.SelectedRows[i].Cells["Unusualstandard_PROD"].Value.ToString(), Common.USERNAME);//添加日志 } } if (j == 0) { MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else//没有选中 { MessageBox.Show("请选择要删除的行!"); } } catch (Exception ex) { Common.WriteTextLog("检测项目异常标准 tsbDelete_Click()+" + ex.Message.ToString()); } finally { page = new PageControl(); //LoadData(Name);//更新 page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); } }
/// <summary> /// 删除 /// </summary> private void InstrumentYanzheng() { string sql = null; try { if (MessageBox.Show("确定删除吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (this.dgvInstrumentInfo.SelectedRows.Count > 0)//选中删除 { bool r = false; //选中数量 int count = dgvInstrumentInfo.SelectedRows.Count; int cou = 0; for (int i = 0; i < count; i++) { int id = Convert.ToInt32(dgvInstrumentInfo.SelectedRows[i].Cells["Instrument_ID"].Value.ToString()); sql = "delete from dbo.InstrumentInfo where Instrument_ID= " + id; //受影响的行数 if (LinQBaseDao.ExecuteSql(sql) > 0) { string strContent = ":" + dgvInstrumentInfo.SelectedRows[i].Cells["Instrument_Name"].Value.ToString(); LogInfoDAL.loginfoadd("删除", "删除" + strContent + "仪表登记的信息", Common.USERNAME);//添加日志 cou++; } } if (cou > 0) { MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); BingList(); } else { MessageBox.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("请选择要删除的行!"); } } } catch (Exception) { } }
private void toolSave_Click(object sender, EventArgs e) { if (getIntCount() == 1) { if (intFalg == 1) { try { //退货 Sales model = SalesDAL.getEntryById <Sales, DateTime>(addtime); if (model == null) { MessageBox.Show("记录不存在", "提示"); } else if (model.Num - sales.Num < 0) { MessageBox.Show("退货数量超出销售数量", "提示"); } else if (model.Num - sales.Num == 0) { //退货数量和销售数量一致,删除该销售记录 SalesDAL.DeleteEntry <Sales, DateTime>(model.AddTime); LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 3, model.Num, DateTime.Now)); MessageBox.Show("退货成功", "提示"); BinddgvData(); } else { sales.Num = (model.Num - sales.Num); SalesDAL.EditEntry <Sales>(sales, "AddTime"); LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 2, (model.Num - sales.Num), DateTime.Now)); MessageBox.Show("退货成功", "提示"); BinddgvData(); } intFalg = 0; ClearControl(); ControlStaus(); } catch (Exception ex) { MessageBox.Show("退货失败," + ex.Message, "提示"); } } } }
/// <summary> /// 确认修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdate_Click(object sender, EventArgs e) { //得到要修改的仪表 string Instrument_Name = Getclbinstrument(); try { if (this.cob_ClientName.Text != "" && this.clbInstrument_Name.Text != "" && this.cob_Collection_Name.Text != "") { string sql = null; //调用判断当前采集端是否被客户端占用的方法 if (!GetCollection_id(false)) { MessageBox.Show("修改失败,该采集端已被占用", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //判断当前采集端是否被客户端占用或者仪表被占用 if (GetInstrument_ID(false)) { MessageBox.Show("修改失败,该仪表已被占用", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //修改客户端,采集表 int id = int.Parse(cob_ClientName.Tag.ToString()); sql = "Update dbo.PolicyConfigurationInfo set PolicyConfiguration_Client_ID=" + this.cob_ClientName.SelectedValue + ",PolicyConfiguration_Collection_ID=" + this.cob_Collection_Name.SelectedValue + ", PolicyConfiguration_Instrument_ID='" + Instrument_Name + "' where PolicyConfiguration_Id=" + id; if (LinQBaseDao.ExecuteSql(sql) > 0) { MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string strContent = "编号为:" + this.cob_ClientName.Tag; LogInfoDAL.loginfoadd("修改", "修改" + strContent + "的策略配置的信息", Common.USERNAME);//添加日志 InstrumentList(); return; } else { MessageBox.Show("修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } } catch (Exception) { } }
/// <summary> /// 添加仪表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnADD_Click(object sender, EventArgs e) { try { if (txtInstrument_name.Text.Trim() == "") { MessageBox.Show("登记失败!仪表不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } string sql = ""; DataTable dt = SelectName(); //if (dt.Rows.Count <= 0) //{ if (cobInstrument_UserName.Text == "") { sql = "insert into InstrumentInfo(Instrument_Collection_ID,Instrument_Name,Instrument_Type) values( " + cmbCollection.SelectedValue + ",'" + txtInstrument_name.Text + "','" + cmbType.SelectedIndex + "')"; } else { sql = "insert into InstrumentInfo(Instrument_Collection_ID,Instrument_Name,Instrument_UserID,Instrument_Type) values(" + cmbCollection.SelectedValue + ",'" + txtInstrument_name.Text + "'," + cobInstrument_UserName.SelectedValue + ",'" + cmbType.SelectedIndex + "')"; } if (LinQBaseDao.ExecuteSql(sql) > 0) { MessageBox.Show("登记成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string strContent = this.txtInstrument_name.Text; LogInfoDAL.loginfoadd("添加", "添加:" + strContent + "仪表登记的信息", Common.USERNAME); //添加日志 BingList(); } else { MessageBox.Show("登记失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //} //else //{ // MessageBox.Show("登记失败,该仪表或检测员已存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); //} } catch (Exception) { } }
/// <summary> /// 操作记录到数据库表fh_operateinfo /// </summary> /// <param name="operType">操作类型</param> /// <param name="content">内容</param> /// <param name="oper_name">操作人</param> public static void WriteLogData(string operType, string content, string oper_name) { try { LogInfo qcRecord = new LogInfo(); if (oper_name == "") { oper_name = Common.USERNAME; } qcRecord.Log_Name = oper_name; qcRecord.Log_Dictionary_ID = DictionaryDAL.GetDictionaryID(operType); qcRecord.Log_Content = content; qcRecord.Log_Time = DateTime.Now; LogInfoDAL.InsertOneQCRecord(qcRecord); } catch (Exception ex) { Common.WriteTextLog("Common.WriteLogData:" + ex.Message.ToString()); } }
/// <summary> /// 确认修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdate_Click(object sender, EventArgs e) { try { if (txtInstrument_name.Text.Trim() == "") { MessageBox.Show("修改失败!仪表不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { string sql = ""; DataTable dt = SelectName(); if (dt.Rows.Count > 0 && dt.Rows[0]["Instrument_ID"].ToString() != this.txtInstrument_name.Tag.ToString()) { MessageBox.Show("修改失败,该仪表已存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } sql = "Update InstrumentInfo set Instrument_Collection_ID=" + cmbCollection.SelectedValue + ", Instrument_UserID=" + this.cobInstrument_UserName.SelectedValue + ",Instrument_Name='" + this.txtInstrument_name.Text + "',Instrument_Type='" + cmbType.SelectedIndex + "' where Instrument_ID=" + this.txtInstrument_name.Tag + ""; if (LinQBaseDao.ExecuteSql(sql) > 0) { MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string strContent = this.txtInstrument_name.Text; LogInfoDAL.loginfoadd("修改", "修改:" + strContent + "仪表登记的信息", Common.USERNAME);//添加日志 BingList(); btnUpdate.Enabled = false; btnADD.Enabled = true; btnqk.Enabled = false; } else { MessageBox.Show("修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception) { } }
private void toolSave_Click(object sender, EventArgs e) { if (getIntCount() == 1) { if (intFalg == 1) { try { if (StockDAL.add(stock)) { LogInfoDAL.add(new LogInfo(0, 1, currentUser.EmpId, 1, stock.Num, stock.AddTime)); MessageBox.Show("添加成功", "提示"); BinddgvData(); } else { MessageBox.Show("添加失败", "提示"); } intFalg = 0; ClearControl(); ControlStaus(); } catch (Exception ex) { MessageBox.Show("添加失败," + ex.Message, "提示"); } } if (intFalg == 2) { //修改 Stock model = StockDAL.getEntryById <Stock, DateTime>(stock.AddTime); if (model == null) { MessageBox.Show("记录不存在", "提示"); } else { stock.AddTime = model.AddTime; StockDAL.EditEntry <Stock>(stock, "AddTime"); LogInfoDAL.add(new LogInfo(0, 1, currentUser.EmpId, 2, stock.Num - model.Num, DateTime.Now)); MessageBox.Show("修改成功", "提示"); BinddgvData(); } intFalg = 0; ClearControl(); ControlStaus(); } if (intFalg == 3) { Stock model = StockDAL.getEntryById <Stock, DateTime>(stock.AddTime); if (model == null) { MessageBox.Show("记录不存在", "提示"); } else { if (MessageBox.Show("确定删除吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { LogInfoDAL.add(new LogInfo(0, 1, currentUser.EmpId, 3, model.Num, DateTime.Now)); StockDAL.DeleteEntry <Stock, DateTime>(model.AddTime); MessageBox.Show("删除成功", "提示"); BinddgvData(); } } intFalg = 0; ClearControl(); ControlStaus(); } } }
/// <summary> /// 对已绑定的单行数据进行修改并保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (this.dgv_SFJC.SelectedRows.Count > 1 || iQCRecordId <= 0) { MessageBox.Show("修改只能选中一行!"); } else { #region 验证文本框 if (this.txtQCRecord_RESULT.Text == "") { mf.ShowToolTip(ToolTipIcon.Info, "提示", "质检结果不能为空!", txtQCRecord_RESULT, this); return; } if (Convert.ToDecimal(this.txtQCRecord_RESULT.Text) == 0) { mf.ShowToolTip(ToolTipIcon.Info, "提示", "质检结果不能为零!", txtQCRecord_RESULT, this); return; } #endregion #region 找到要修改行信息的位置并进行修改 Expression <Func <QCRecord, bool> > p = n => n.QCRecord_ID == iQCRecordId; Action <QCRecord> ap = s => { s.QCRecord_RESULT = Convert.ToDecimal(this.txtQCRecord_RESULT.Text.Trim()); //水分值 s.QCRecord_NUMBER = this.txtQCRecord_NUMBER.Text.Trim(); //质检序号 s.QCRecord_DRAW = Convert.ToDecimal(this.txtQCRecord_DRAW.Text.Trim()); //抽检包号 s.QCRecord_TARE = Convert.ToDecimal(this.txtQCRecord_TARE.Text.Trim()); //预置皮重 s.QCRecord_QCCOUNT = Convert.ToInt32(this.txtQCRecord_QCCOUNT.Text.Trim()); //结果质检次数 s.QCRecord_COUNT = this.txtQCRecord_COUNT.Text.Trim(); //记录质检次数 }; if (txtQCRecord_RESULT.Text.Substring(0, 1) == ".") { mf.ShowToolTip(ToolTipIcon.Info, "提示", "第一位不能是小数点!", txtQCRecord_RESULT, this); return; } else { if (QCRecordDAL.Update(p, ap)) { MessageBox.Show("修改成功", "提示"); } else { MessageBox.Show("修改失败", "提示"); } } string strContent = "质检记录编号为:" + QCRecord_ID.ToString() + ",修改"; LogInfoDAL.loginfoadd("修改", "修改质检记录信息", Common.USERNAME);//添加日志 #endregion } } catch (Exception ex) { Common.WriteTextLog("手动修改管理 bntUpUser_Click()" + ex.Message.ToString()); } finally { ClearB(); LoadData(""); } }
private void toolSave_Click(object sender, EventArgs e) { if (getIntCount() == 1) { if (intFalg == 1) { try { ReturnRet <int> result = StockDAL.QueryGoodsNum(sales.GoodsId, sales.Num); if (result.success) { if (SalesDAL.add(sales)) { LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 1, sales.Num, sales.AddTime)); MessageBox.Show("添加成功", "提示"); BinddgvData(); intFalg = 0; ClearControl(); ControlStaus(); } else { MessageBox.Show("添加失败", "提示"); } } else { MessageBox.Show(result.message); intFalg = 1; txtSellGoodsNum.Text = result.data.ToString(); return; } } catch (Exception ex) { MessageBox.Show("添加失败," + ex.Message, "提示"); } } if (intFalg == 2) { //修改 Sales model = SalesDAL.getEntryById <Sales, DateTime>(addtime); if (model == null) { MessageBox.Show("记录不存在", "提示"); } else { ReturnRet <int> result = StockDAL.QueryGoodsNum(sales.GoodsId, sales.Num); if (result.success) { sales.AddTime = model.AddTime; SalesDAL.EditEntry <Sales>(sales, "AddTime"); LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 2, sales.Num - model.Num, DateTime.Now)); MessageBox.Show("修改成功", "提示"); BinddgvData(); } else { MessageBox.Show(result.message); txtSellGoodsNum.Text = result.data.ToString(); intFalg = 2; return; } } intFalg = 0; ClearControl(); ControlStaus(); } if (intFalg == 3) { Sales model = SalesDAL.getEntryById <Sales, DateTime>(addtime); if (model == null) { MessageBox.Show("记录不存在", "提示"); } else { if (MessageBox.Show("确定删除吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 3, model.Num, DateTime.Now)); SalesDAL.DeleteEntry <Sales, DateTime>(model.AddTime); MessageBox.Show("删除成功", "提示"); BinddgvData(); } } intFalg = 0; ClearControl(); ControlStaus(); } } }
/// <summary> /// 删除信息 /// </summary> private void tsbDelete_Click() { try { bool isdel = false; int j = 0; if (this.dvgCarList.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("将会同时删除该车辆过数DTS水分数据表的信息,确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { isdel = true; //选中数量 int count = dvgCarList.SelectedRows.Count; //遍历 for (int i = 0; i < count; i++) { Expression <Func <MATERIAL_QC_INTERFACE, bool> > material_qc = n => n.PO_NO == dvgCarList.SelectedRows[i].Cells["PO_NO"].Value.ToString() && n.SHIPMENT_NO == dvgCarList.SelectedRows[i].Cells["SHIPMENT_NO"].Value.ToString(); Expression <Func <OCC_MOIST_INTERFACE, bool> > occ_moist = n => n.PO_NO == dvgCarList.SelectedRows[i].Cells["PO_NO"].Value.ToString() && n.SHIPMENT_NO == dvgCarList.SelectedRows[i].Cells["SHIPMENT_NO"].Value.ToString(); IEnumerable <OCC_MOIST_INTERFACE> occ_erface = OCC_MOIST_INTERFACEDAL.Query(occ_moist); string trans_to_dtsflag = ""; foreach (var occ in occ_erface) { if (!string.IsNullOrEmpty(occ.TRANS_TO_DTS_FLAG)) { trans_to_dtsflag = occ.TRANS_TO_DTS_FLAG; } } if (!string.IsNullOrEmpty(trans_to_dtsflag)) { if (MessageBox.Show("编号为:" + dvgCarList.SelectedRows[i].Cells["MATERIAL_QC_INTERFACE_ID"].Value.ToString() + "车牌号为:" + dvgCarList.SelectedRows[i].Cells["CNTRNO"].Value.ToString() + " 已经过数,确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (!MATERIAL_QC_INTERFACEDAL.DeleteToMany(material_qc)) { j++; } if (!OCC_MOIST_INTERFACEDAL.DeleteToMany(occ_moist)) { j++; } } else { isdel = false; } } else { if (!MATERIAL_QC_INTERFACEDAL.DeleteToMany(material_qc)) { j++; } if (!OCC_MOIST_INTERFACEDAL.DeleteToMany(occ_moist)) { j++; } } } if (j == 0) { if (isdel) { MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { if (isdel) { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } string strContent = "编号为:" + dvgCarList.SelectedRows[0].Cells["MATERIAL_QC_INTERFACE_ID"].Value.ToString() + ",车牌号为:" + dvgCarList.SelectedRows[0].Cells["CNTRN"].Value.ToString() + ",删除成功!"; LogInfoDAL.loginfoadd("删除", "删除过数DTS水分数据与过数DTS重量数据", Common.USERNAME);//添加日志 } } else if (this.dataGridView1.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("将会同时删除该车辆过数DTS重量数据表的信息,确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { isdel = true; //选中数量 int count = dataGridView1.SelectedRows.Count; //遍历 for (int i = 0; i < count; i++) { Expression <Func <MATERIAL_QC_INTERFACE, bool> > material_qc = n => n.PO_NO == dataGridView1.SelectedRows[i].Cells["PONO"].Value.ToString() && n.SHIPMENT_NO == dataGridView1.SelectedRows[i].Cells["SHIPMENTNO"].Value.ToString(); Expression <Func <OCC_MOIST_INTERFACE, bool> > occ_moist = n => n.PO_NO == dataGridView1.SelectedRows[i].Cells["PONO"].Value.ToString() && n.SHIPMENT_NO == dataGridView1.SelectedRows[i].Cells["SHIPMENTNO"].Value.ToString(); IEnumerable <OCC_MOIST_INTERFACE> occ_erface = OCC_MOIST_INTERFACEDAL.Query(occ_moist); string trans_to_dtsflag = ""; foreach (var occ in occ_erface) { if (!string.IsNullOrEmpty(occ.TRANS_TO_DTS_FLAG)) { trans_to_dtsflag = occ.TRANS_TO_DTS_FLAG; } } if (!string.IsNullOrEmpty(trans_to_dtsflag)) { if (MessageBox.Show("编号为:" + dataGridView1.SelectedRows[i].Cells["OCC_MOIST_INTERFACE_ID"].Value.ToString() + "车牌号为:" + dataGridView1.SelectedRows[i].Cells["CNTRN"].Value.ToString() + " 已经过数,确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (!MATERIAL_QC_INTERFACEDAL.DeleteToMany(material_qc)) { j++; } if (!OCC_MOIST_INTERFACEDAL.DeleteToMany(occ_moist)) { j++; } } else { isdel = false; } } else { if (!MATERIAL_QC_INTERFACEDAL.DeleteToMany(material_qc)) { j++; } if (!OCC_MOIST_INTERFACEDAL.DeleteToMany(occ_moist)) { j++; } } } if (j == 0) { if (isdel) { MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { if (isdel) { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } string strContent = "编号为:" + dataGridView1.SelectedRows[0].Cells["OCC_MOIST_INTERFACE_ID"].Value.ToString() + ",车牌号为:" + dataGridView1.SelectedRows[0].Cells["CNTRN"].Value.ToString() + ",删除成功!"; LogInfoDAL.loginfoadd("删除", "删除过数DTS水分数据与过数DTS重量数据", Common.USERNAME);//添加日志 } } else//没有选中 { MessageBox.Show("请选择要删除的行!"); } } catch (Exception ex) { Common.WriteTextLog("InsetfaceFrom tsbDelete_Click()+" + ex.Message.ToString()); } finally { page = new PageControl(); page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); LoadData(); } }
/// <summary> /// “搜 索” 的单击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSearch_Click(object sender, EventArgs e) { #region 注释 try { int i = 0; string str = ""; //得到查询的条件 string name = this.txtLog_Name.Text.Trim(); string beginTime = this.txtbeginTime.Text.Trim(); string endTime = this.txtendTime.Text.Trim(); string begin = beginTime + " 00:00:00"; string end = endTime + "23:59:59 "; expr = PredicateExtensionses.True <View_LogInfo_Dictionary>(); if (name != "")//操作人 { expr = expr.And(n => SqlMethods.Like(n.Log_Name, "%" + txtLog_Name.Text.Trim() + "%")); i++; } if (beginTime != "")//开始时间 { expr = expr.And(n => n.Log_Time >= CommonalityEntity.GetDateTime(begin)); i++; } if (endTime != "")//结束时间 { expr = expr.And(n => n.Log_Time <= CommonalityEntity.GetDateTime(end)); i++; } if (beginTime != "" && endTime != "") { if (CommonalityEntity.GetDateTime(beginTime) > CommonalityEntity.GetDateTime(endTime)) { MessageBox.Show("查询开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtbeginTime.Text = ""; txtendTime.Text = ""; return; } } if (this.comboxType.SelectedValue != null) { int stateID = Converter.ToInt(comboxType.SelectedValue.ToString()); if (stateID > 0) { Dictionary dicEntity = comboxType.SelectedItem as Dictionary; if (dicEntity.Dictionary_Value == "全部") { expr = n => n.Log_ID != null; } else { expr = expr.And(n => n.Log_Type == CommonalityEntity.GetInt(comboxType.SelectedValue.ToString())); } } i++; } if (i == 0) { expr = n => n.Log_ID != null; } } catch { CommonalityEntity.WriteTextLog("CommonalityEntity.btnSearch()"); } finally { page = new PageControl(); LogInfoLoad(""); LoadData(); } #endregion if (btnSearch.Enabled) { btnSearch.Enabled = false; GetLogInfoSeach(); LogInfoDAL.AddLoginfo("查询", "检测项目查询", CommonalityEntity.USERNAME);//操作日志 btnSearch.Enabled = true; } }