/// <summary> /// 检查数据 /// </summary> /// <param name="data">要检查的数据项</param> /// <returns>正确返回true</returns> bool CheckData(BASE_MaterialRequisitionPurpose data) { if (data == null || !data.IsEnd) { MessageDialog.ShowPromptMessage("必须要选择最终分类(即末节点), 而不允许选择大类"); return(false); } else if (data.Code == "1602") { MessageDialog.ShowPromptMessage("此选项不可选择"); return(false); } else { return(true); } }
private void timer1_Tick(object sender, EventArgs e) { try { if (btnAdd.Enabled) { Dictionary <CE_GoodsAttributeName, object> dic = UniversalFunction.GetGoodsInfList_Attribute_AttchedInfoList(m_barCodeInfo.GoodsID); if (!dic.Keys.ToList().Contains(CE_GoodsAttributeName.流水码)) { throw new Exception(UniversalFunction.GetGoodsMessage(m_barCodeInfo.GoodsID) + "基础属性未设置【流水码】"); } List <F_ProductWaterCode> lstWaterCode = dic[CE_GoodsAttributeName.流水码] as List <F_ProductWaterCode>; foreach (F_ProductWaterCode item in lstWaterCode) { if (item.SteelSealExample.Trim().Length == txtProductCode.Text.Trim().Length) { KeyEventArgs k = new KeyEventArgs(Keys.Enter); txtProductCode_KeyDown(sender, k); txtProductCode.Text = ""; break; } } } if ((txtBoxNo.Text.Length == 16 || txtBoxNo.Text.Length == 13) && btnAdd.Enabled && (m_dicMarkInfo.First().Value == CE_MarketingType.出库 || m_dicMarkInfo.First().Value == CE_MarketingType.退货 || m_dicMarkInfo.First().Value == CE_MarketingType.领料)) { KeyEventArgs k = new KeyEventArgs(Keys.Enter); txtBoxNo_KeyDown(sender, k); } } catch (Exception ex) { timer1.Enabled = false; MessageDialog.ShowPromptMessage(ex.Message); timer1.Enabled = true; return; } }
/// <summary> /// 根据树节点名称定位节点 /// </summary> /// <param name="name">节点名称</param> private void PositioningNode(string name) { if (GlobalObject.GeneralFunction.IsNullOrEmpty(name)) { return; } TreeNode[] nodes = treeView1.Nodes.Find(name, true); if (nodes == null || nodes.Length == 0) { MessageDialog.ShowPromptMessage(string.Format("没有找到你要的信息:{0}", name)); return; } treeView1.Focus(); treeView1.SelectedNode = nodes[0]; }
public void toolStripMenuItem_导入_Click(object sender, EventArgs e) { Control cltr = this.SourceControl; if (cltr == null) { return; } if (cltr is DataGridView) { DataGridView dgvTemp = cltr as DataGridView; DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { return; } foreach (DataGridViewColumn cl in dgvTemp.Columns) { if (!dtTemp.Columns.Contains(cl.HeaderText)) { MessageDialog.ShowPromptMessage("文件无【" + cl.HeaderText + "】列名"); return; } } if (_InputEvent != null) { _InputEvent(dtTemp); } MessageDialog.ShowPromptMessage("导入成功"); } else { if (_导入 != null) { _导入(); } } }
private void btnInput_Click(object sender, EventArgs e) { try { DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null || dtTemp.Rows.Count == 0) { throw new Exception("请填写对应列名的内容"); } if (!dtTemp.Columns.Contains("出厂流水码")) { MessageDialog.ShowPromptMessage("未找到列名为:【出厂流水码】的列"); return; } if (!dtTemp.Columns.Contains("箱体编码")) { MessageDialog.ShowPromptMessage("未找到列名为:【箱体编码】的列"); return; } m_dtProductCodes.Rows.Clear(); dataGridView1.DataSource = m_dtProductCodes; foreach (DataRow dr in dtTemp.Rows) { if (dr["出厂流水码"].ToString().Trim().Length != 0) { txtProductCode.Text = dr["出厂流水码"].ToString().Trim(); _TempBoxNo = dr["箱体编码"].ToString().Trim(); btnAdd_Click(sender, e); } } _TempBoxNo = ""; } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
/// <summary> /// 提交并查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFind_Click(object sender, EventArgs e) { if (panelParameter.Controls.Count == 0) { MessageDialog.ShowPromptMessage("您还没有建立查询条件无法进行此操作!"); return; } if (!TestFilterCondition()) { return; } dataGridView1.DataSource = m_queryResult.DataCollection.Tables[0]; lblAmount.Text = dataGridView1.Rows.Count.ToString(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Name.Contains("标志") || dataGridView1.Columns[i].Name.Contains("领料类型") || dataGridView1.Columns[i].Name.Contains("人编码") || dataGridView1.Columns[i].Name.Contains("权限控制") || dataGridView1.Columns[i].Name.Contains("序号")) { dataGridView1.Columns[i].Visible = false; } } #region 隐藏不允许查看的列 if (m_queryResult.HideFields != null && m_queryResult.HideFields.Length > 0) { for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (m_queryResult.HideFields.Contains(dataGridView1.Columns[i].Name)) { dataGridView1.Columns[i].Visible = false; } } } #endregion dataGridView1.Refresh(); }
/// <summary> /// 保存我的查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { if (m_quertResultTable == null || m_quertResultTable.Columns.Count == 0 || m_quertResultTable.Rows.Count == 0) { MessageDialog.ShowPromptMessage("没有数据无法保存查询结果"); return; } m_saveFlag = true; CreateExcelFile(); //m_controlDic.Clear(); //for (int i = 0; i < panelParameter.Controls.Count; i++) //{ // UserControlFindCondition newControl = panelParameter.Controls[i] as UserControlFindCondition; // newControl.SaveFlag = true; // m_controlDic.Add(newControl.Name, newControl); //} }
private void btnDelete_Click(object sender, EventArgs e) { try { CustomDataGridView dgv = GetDataGridView(tabControl1.SelectedTab); string tempStr = dgv.CurrentRow.Cells["业务编号"].Value.ToString(); if (MessageDialog.ShowEnquiryMessage("您确定要删除【" + tempStr + "】号业务单据吗?") == DialogResult.Yes) { _BusinessService.DeleteInfo(tempStr); MessageDialog.ShowPromptMessage("删除成功"); m_billMessageServer.DestroyMessage(tempStr); } RefreshData(tabControl1.SelectedTab); } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
private void btnOK_Click(object sender, EventArgs e) { if (cmbDJZT.Text == "" || cmbDJZT.Text.Trim().Length == 0 || cmbDJZT.Text == null) { cmbDJZT.Focus(); MessageDialog.ShowPromptMessage("请选择回退状态"); return; } if (txtReason.Text.Trim() == "") { txtReason.Focus(); MessageDialog.ShowPromptMessage("请填写回退原因"); return; } m_strBillStatus = cmbDJZT.Text; m_objValue = cmbDJZT.SelectedValue; this.DialogResult = DialogResult.OK; this.Close(); }
private void dataGridView1_DoubleClick(object sender, EventArgs e) { if (_KeyName != null) { if (dataGridView1.Columns.Contains(_KeyName)) { if (FormShow != null) { FormShow(dataGridView1, _KeyName); } else { MessageDialog.ShowPromptMessage("查询功能获取失败"); } } else { MessageDialog.ShowPromptMessage("查询结果集中无关键字段【" + _KeyName + "】"); } } }
/// <summary> /// 下载 /// </summary> void FileDownLoad() { try { saveFileDialog1.Filter = "All files (*.*)|*.*"; saveFileDialog1.FileName = ""; if (m_filePathExternal.Trim().Length == 0) { if (saveFileDialog1.ShowDialog() == DialogResult.OK) { m_filePathExternal = saveFileDialog1.FileName; } } if (m_filePathExternal.Trim().Length > 0) { BackgroundWorker worker = BackgroundWorkerTools.GetWorker("下载文件"); worker.RunWorkerAsync(); m_serverFileFtp.Download(m_filePathInternal, m_filePathExternal); worker.CancelAsync(); if (GetError()) { MessageDialog.ShowPromptMessage("下载成功"); } } } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); this.Cursor = System.Windows.Forms.Cursors.Arrow; } }
private void btnAdd_Click(object sender, EventArgs e) { try { txtProductCode.Text = txtProductCode.Text.Trim().ToUpper(); //if (m_blIsTCUFlag) //{ // List<string> lstTemp = txtProductCode.Text.Split(',').ToList(); // if (lstTemp.Count() > 1) // { // txtProductCode.Text = lstTemp[2] + "(" + lstTemp[3] + ")"; // } //} if (!m_serverProductCode.VerifyProductCodesInfo(m_barCodeInfo.GoodsID, txtProductCode.Text.Trim(), GlobalObject.CE_BarCodeType.内部钢印码, out m_err)) { throw new Exception(m_err); } switch (m_enumBusinessType) { case CE_BusinessType.库房业务: CheckBusiness(typeof(CE_MarketingType)); break; case CE_BusinessType.车间业务: CheckBusiness(typeof(CE_SubsidiaryOperationType)); break; case CE_BusinessType.综合业务: CheckBusiness(typeof(CE_MarketingType)); CheckBusiness(typeof(CE_SubsidiaryOperationType)); break; default: break; } if (!CheckNumber(txtProductCode.Text)) { return; } string strBoxNo = ""; if (_TempBoxNo.Trim().Length > 0) { strBoxNo = _TempBoxNo; } else { if (m_enumBusinessType == CE_BusinessType.库房业务 || m_enumBusinessType == CE_BusinessType.综合业务) { if (m_dicMarkInfo.First().Value == CE_MarketingType.入库) { SetBoxNo(); } else { strBoxNo = m_findSellIn.GetHoldBoxNo(txtProductCode.Text); } } } m_dtProductCodes = (DataTable)dataGridView1.DataSource; DataRow dr = m_dtProductCodes.NewRow(); dr["Number"] = m_dtProductCodes.Rows.Count + 1; dr["ProductCode"] = txtProductCode.Text; dr["BoxNo"] = strBoxNo == "" ? txtBoxNo.Text : strBoxNo; m_dtProductCodes.Rows.Add(dr); dataGridView1.DataSource = m_dtProductCodes; PositioningRecord(txtProductCode.Text); txtProductCode.Text = ""; txtProductCode.Focus(); } catch (Exception ex) { timer1.Enabled = false; MessageDialog.ShowPromptMessage("编号:【" + txtProductCode.Text + "】 " + ex.Message); txtProductCode.Text = ""; txtProductCode.Focus(); timer1.Enabled = true; return; } }
private void btnAuditing_Click(object sender, EventArgs e) { m_dtProductCodes = (DataTable)dataGridView1.DataSource; //由于RDC16FB在领料时,还未有组机厂,故型号为空,所以无法在此控制, 并且在入库的自动生成时,就已经未控制 Modify by cjb on 2014.10.11 //if (txtCode.Text == "") //{ // MessageBox.Show("请录入型号", "提示"); // return; //} if (Convert.ToDecimal(txtCount.Text) != (decimal)m_dtProductCodes.Rows.Count && m_dicMarkInfo.First().Value != CE_MarketingType.入库) { MessageDialog.ShowPromptMessage("流水号数量与申请人填写数量不符,请重新核实!"); return; } try { switch (m_enumBusinessType) { case CE_BusinessType.库房业务: if (!m_serverProductCode.UpdateProducts(m_dtProductCodes, txtCode.Text, "", Convert.ToInt32(txtGoodsName.Tag), m_strBillID, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return; } break; case CE_BusinessType.车间业务: m_serverWSProductCode.OperatorProductCodeDetail(m_dtProductCodes, m_strBillID, (int)txtGoodsName.Tag, m_dicWorkShopInfo); break; case CE_BusinessType.综合业务: if (!m_serverProductCode.UpdateProducts(m_dtProductCodes, txtCode.Text, "", Convert.ToInt32(txtGoodsName.Tag), m_strBillID, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return; } m_serverWSProductCode.OperatorProductCodeDetail(m_dtProductCodes, m_strBillID, (int)txtGoodsName.Tag, m_dicWorkShopInfo); break; case CE_BusinessType.未知: if (!m_serverProductCode.UpdateProducts(m_dtProductCodes, txtCode.Text, "", Convert.ToInt32(txtGoodsName.Tag), m_strBillID, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return; } break; default: break; } this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); return; } this.Close(); }
/// <summary> /// 将整盒TCU插入表中 /// </summary> private void InsertCode() { try { string storageId = null; foreach (KeyValuePair <string, CE_MarketingType> item in m_dicMarkInfo) { switch (item.Value) { case CE_MarketingType.退库: case CE_MarketingType.出库: case CE_MarketingType.退货: case CE_MarketingType.领料: case CE_MarketingType.调出: case CE_MarketingType.库房报废: storageId = item.Key; break; default: break; } } if (storageId == null) { throw new Exception("找不到出库库房"); } DataTable dtCodes = m_findSellIn.GetBoxInfo(txtBoxNo.Text, storageId); if (dtCodes == null || dtCodes.Rows.Count == 0) { return; } bool blInsert = false; m_dtProductCodes = (DataTable)dataGridView1.DataSource; DataTable dt = m_dtProductCodes.Copy(); for (int i = 0; i < dtCodes.Rows.Count; i++) { blInsert = false; for (int k = 0; k < dt.Rows.Count; k++) { if (dt.Rows[k]["ProductCode"].ToString() == dtCodes.Rows[i]["ProductCode"].ToString()) { blInsert = true; } } if (!blInsert) { foreach (KeyValuePair <string, CE_MarketingType> item in m_dicMarkInfo) { if (m_findSellIn.IsProductCodeOperationStandard(item.Value.ToString(), typeof(CE_MarketingType), Convert.ToInt32(txtGoodsName.Tag), dtCodes.Rows[i]["ProductCode"].ToString(), item.Key, out m_err)) { DataRow dr = m_dtProductCodes.NewRow(); dr["Number"] = m_dtProductCodes.Rows.Count + 1; dr["ProductCode"] = dtCodes.Rows[i]["ProductCode"].ToString(); dr["BoxNo"] = dtCodes.Rows[i]["BoxNo"].ToString(); m_dtProductCodes.Rows.Add(dr); } else { throw new Exception(m_err); } } } } dataGridView1.DataSource = m_dtProductCodes; } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
private void btnSubmit_Click(object sender, EventArgs e) { this.Cursor = System.Windows.Forms.Cursors.WaitCursor; this.btnSubmit.Enabled = false; this.btnHold.Enabled = false; this.btnReback.Enabled = false; try { if (!m_customForm.GetDateInfo(CE_FlowOperationType.提交)) { return; } CheckData(); string judge = ""; if (rbAgree.Checked) { judge = rbAgree.Text; } if (rbDisagree.Checked) { DisagreeOperation(); return; } if (rbIsread.Checked) { judge = rbIsread.Text; } string advise = judge + " " + textBox1.Text; if (CommonProcessSubmit != null && CommonProcessSubmit(m_customForm, advise)) { if (m_customForm.流程控制类型 == CE_FormFlowType.默认) { if (m_customForm.FlowInfo_BillNo == null || m_customForm.FlowInfo_BillNo.Trim().Length == 0) { throw new Exception("单据号不能为空"); } bool isParallel = false; if (m_serverFlow.IsPointPersonnel(m_customForm.FlowInfo_BillNo, out isParallel) && (m_customForm.FlowInfo_NotifyInfo.PersonnelBasicInfoList == null || m_customForm.FlowInfo_NotifyInfo.PersonnelBasicInfoList.Count() == 0)) { if (!m_customForm.GetNotifyPersonnel(true)) { throw new Exception("请选择指定人或者角色点【确定】"); } } m_serverFlow.FlowPass(m_customForm.FlowInfo_BillNo, advise, m_customForm.FlowInfo_StorageIDOrWorkShopCode, m_customForm.FlowInfo_NotifyInfo, m_customForm.KeyWords); } MessageDialog.ShowPromptMessage("提交成功"); this.DialogResult = DialogResult.OK; this.Close(); } } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } finally { this.btnSubmit.Enabled = true; this.btnHold.Enabled = true; this.btnReback.Enabled = true; this.Cursor = System.Windows.Forms.Cursors.Arrow; } }
private void toolStripMenuItem_取消导入项_Click(object sender, EventArgs e) { Control cltr = this.SourceControl; if (cltr == null) { return; } if (cltr is DataGridView) { DataGridView dgvTemp = cltr as DataGridView; int columnsIndex = -1; foreach (DataGridViewColumn cl in dgvTemp.Columns) { if (cl.CellType == typeof(DataGridViewCheckBoxColumn) || cl.CellType == typeof(DataGridViewCheckBoxCell)) { columnsIndex = cl.Index; break; } } if (columnsIndex != -1) { DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { return; } foreach (DataGridViewColumn cl in dgvTemp.Columns) { if (cl.Index != columnsIndex) { if (!dtTemp.Columns.Contains(cl.Name)) { MessageDialog.ShowPromptMessage("文件无【" + cl.Name + "】列名"); return; } } } foreach (DataGridViewRow dgvr in dgvTemp.Rows) { foreach (DataRow dr in dtTemp.Rows) { foreach (DataGridViewColumn dgvc in dgvTemp.Columns) { if (dgvc.Index != columnsIndex) { dgvr.Cells[dgvc.Name].Value = dgvr.Cells[dgvc.Name].Value == null ? "" : dgvr.Cells[dgvc.Name].Value.ToString(); dr[dgvc.Name] = dr[dgvc.Name] == null ? "" : dr[dgvc.Name].ToString(); if (dgvr.Cells[dgvc.Name].Value.ToString() == dr[dgvc.Name].ToString()) { dgvr.Cells[columnsIndex].Value = false; } } } } } } } else { if (_取消导入项 != null) { _取消导入项(); } } }
public static void BusinessDataSelect(CE_BillTypeEnum billType, string keyName, GlobalObject.DelegateCollection.ShowDataGirdViewInfo formShow) { try { string error = ""; _FormShow = formShow; ServerModule.IReport reportService = ServerModule.ServerModuleFactory.GetServerModule <ServerModule.IReport>(); List <BASE_IntegrationReport> listReport = reportService.GetBusinessSelect(billType); if (listReport != null && listReport.Count > 0) { FormDataComboBox frmCombox = new FormDataComboBox((from a in listReport select a.ReportName).ToList(), billType.ToString() + "报表查询"); if (frmCombox.ShowDialog() == DialogResult.OK) { string reportCode = (from a in listReport where a.ReportName == frmCombox.Result select a.ReportCode).Single().ToString(); List <BASE_IntegrationReportList> list = reportService.GetIntegrationReportList(reportCode); DataTable listInfo = null; if (list != null && list.Count() > 0) { FormValueSet frm = new FormValueSet(list); if (frm.ShowDialog() != DialogResult.OK) { return; } listInfo = new DataTable(); listInfo.Columns.Add("参数类型"); listInfo.Columns.Add("查询内容"); listInfo.Columns.Add("参数名"); for (int i = 0; i < frm.Result.Count(); i++) { DataRow dr = listInfo.NewRow(); dr["参数名"] = list[i].ParameterName; dr["参数类型"] = frm.Result[i].ParameterType; dr["查询内容"] = frm.Result[i].ReportCode; listInfo.Rows.Add(dr); } } DataTable dtSoucre = reportService.QueryInfo(reportCode, listInfo, out error); FormConditionDataTableFind frmShow = new FormConditionDataTableFind(dtSoucre, keyName); frmShow.FormShow += new DelegateCollection.ShowDataGirdViewInfo(frmShow_FormShow); frmShow.ShowDialog(); } } } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
/// <summary> /// 构建SQL查询where语句字段 /// </summary> /// <param name="lastFlag">是否为最后一个条件,True表示是最后一个条件,False表示不是最后一个条件</param> public string BuildSQLSentence(string typeName, bool lastFlag) { string findData = txtFindData.Text; m_sentenceSQL = null; if (dateTime.Visible) { findData = string.Format("{0}-{1}-{2}", dateTime.Value.Date.Year, dateTime.Value.Month, dateTime.Value.Day); } else if (cmbFindData.Visible) { findData = cmbFindData.SelectedItem.ToString(); } else if (txtFindData.Visible) { findData = txtFindData.Text; } else if (numPrice.Visible) { findData = numPrice.Value.ToString(); } else if (numCount.Visible) { findData = numCount.Value.ToString(); } if (!IsValidCondition(findData)) { throw new Exception("请输入正确的查询条件!"); } string centerString = null; if (cmbOperator.Text == "包含") { centerString = cmbFindField.SelectedItem.ToString() + " like '%" + findData + "%'"; } else if (cmbOperator.Text == "是" || cmbOperator.Text == "不是") { if (findData.Trim().ToLower() != "空") { string error = "当操作符选择 “是”或“不是”时查找数据值只能为“空”"; MessageDialog.ShowPromptMessage(error); txtFindData.Text = "空"; throw new ArgumentException(error); } string operatorSymbol = "is"; if (cmbOperator.Text == "不是") { operatorSymbol = "is not"; } centerString = string.Format("{0} {1} {2} ", cmbFindField.Text, operatorSymbol, "null"); //findData); } else { if (findData != "") { if (dateTime.Visible) { if (cmbOperator.Text == "=") { if (typeName != "") { centerString = string.Format("({0} >= '{1} 00:00:00' " + " and {0} <= '{1} 00:00:00')", cmbFindField.SelectedItem.ToString(), findData); } else { centerString = string.Format("( CAST({0} as DateTime ) >= '{1} 00:00:00' " + " and CAST({0} as DateTime) <= '{1} 00:00:00')", cmbFindField.SelectedItem.ToString(), findData); } } else { if (typeName != "") { centerString = string.Format("({0}{1} '{2} 00:00:00')", cmbFindField.SelectedItem.ToString(), cmbOperator.SelectedItem.ToString(), findData); } else { centerString = string.Format("( CAST({0} as DateTime ) {1} '{2} 00:00:00')", cmbFindField.SelectedItem.ToString(), cmbOperator.SelectedItem.ToString(), findData); } } } else { centerString = cmbFindField.SelectedItem.ToString() + cmbOperator.SelectedItem.ToString() + "'" + findData + "'"; } } else { centerString = "(" + cmbFindField.SelectedItem.ToString() + cmbOperator.SelectedItem.ToString() + "'" + findData + "'" + " or " + cmbFindField.SelectedItem.ToString() + " is null" + ")"; } } if (cmbLeft.SelectedItem != null) { centerString = cmbLeft.SelectedItem.ToString() + centerString; } if (cmbRight.SelectedItem != null) { centerString = centerString + cmbRight.SelectedItem.ToString(); } if (!lastFlag) { m_sentenceSQL = centerString + " " + cmbRelationSymbol.SelectedItem.ToString() + " "; } else { m_sentenceSQL = centerString; } return(m_sentenceSQL); }
/// <summary> /// 保存检索条件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSaveCondition_Click(object sender, EventArgs e) { if (panelParameter.Controls.Count == 0) { MessageDialog.ShowPromptMessage("还没有设置查询条件无法进行保存"); return; } string searchName = InputBox.ShowDialog("保存检索条件", "检索条件名称:", cmbSearchName.Text); if (!GlobalObject.GeneralFunction.IsNullOrEmpty(searchName)) { List <SYS_SearchParams> lstParam = new List <SYS_SearchParams>(); int orderNo = 0; string error = null; foreach (var item in panelParameter.Controls) { SYS_SearchParams param = new SYS_SearchParams(); param.BusinessName = m_parentTitle; param.ItemName = Business; param.SearchName = searchName; UserControlFindCondition tmpControl = (UserControlFindCondition)item; //if (tmpControl.LeftParentheses.Length > 0) // param.LeftParentheses = tmpControl.LeftParentheses[0].ToString(); //if (tmpControl.RightParentheses.Length > 0) // param.RightParentheses = tmpControl.RightParentheses[0].ToString(); param.LeftParentheses = tmpControl.LeftParentheses.Trim(); param.RightParentheses = tmpControl.RightParentheses.Trim(); param.FieldName = tmpControl.FieldName; param.Operator = tmpControl.Operator; param.OrderNo = orderNo++; param.Logic = tmpControl.LogicSymbol; param.DataType = tmpControl.DataType; param.DataValue = tmpControl.DataValue; param.UserCode = GlobalObject.BasicInfo.LoginID; lstParam.Add(param); } if (!m_searchParamsServer.AddParam(lstParam, out error)) { MessageDialog.ShowErrorMessage(error); } else { MessageDialog.ShowPromptMessage("成功保存查询条件"); if (!cmbSearchName.Items.Contains(searchName)) { cmbSearchName.Items.Add(""); cmbSearchName.Items.Add(searchName); cmbSearchName.Text = searchName; if (!panelSelectSearch.Visible) { panelSelectSearch.Visible = true; } } } } }
private void btnReback_Click(object sender, EventArgs e) { try { if (!m_customForm.GetDateInfo(CE_FlowOperationType.回退)) { return; } CheckData(); if (m_customForm.流程控制类型 == CE_FormFlowType.默认) { if (m_serverFlow.IsExist(m_customForm.FlowInfo_BillNo)) { Flow_FlowInfo lnqFlowInfo = m_serverFlow.GetNowFlowInfo(m_serverFlow.GetBusinessTypeID(m_billType, m_FlowBusinessVersion), m_customForm.FlowInfo_BillNo); List <Flow_FlowInfo> listFlowInfo = (from a in m_serverFlow.GetListFlowInfo(m_customForm.FlowInfo_BillNo) where a.FlowOrder < lnqFlowInfo.FlowOrder orderby a.FlowOrder select a).ToList(); if (listFlowInfo == null || listFlowInfo.Count == 0) { throw new Exception("回退流程无记录"); } else { 回退单据 frm = new 回退单据(m_billType, m_customForm.FlowInfo_BillNo, lnqFlowInfo.BusinessStatus, listFlowInfo); if (CommonProcessSubmit != null && CommonProcessSubmit(m_customForm, frm.Reason)) { if (frm.ShowDialog() == DialogResult.OK) { string advise = "回退 " + textBox1.Text + "原因:" + frm.Reason; m_serverFlow.FlowReback(m_customForm.FlowInfo_BillNo, advise, m_customForm.FlowInfo_StorageIDOrWorkShopCode, Convert.ToInt32(frm.ObjValue), m_customForm.KeyWords); MessageDialog.ShowPromptMessage("回退成功"); this.DialogResult = DialogResult.OK; this.Close(); } } } } else { throw new Exception("新建单据无法执行回退功能"); } } else { 回退单据 frm = new 回退单据(m_billType, m_customForm.FlowInfo_BillNo, null, null); if (CommonProcessSubmit != null && CommonProcessSubmit(m_customForm, frm.Reason)) { if (frm.ShowDialog() == DialogResult.OK) { string advise = "回退 " + textBox1.Text + "原因:" + frm.Reason; MessageDialog.ShowPromptMessage("回退成功"); this.DialogResult = DialogResult.OK; this.Close(); } } } } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
private void btnOK_Click(object sender, EventArgs e) { if ((DataTable)dataGridView1.DataSource == null || ((DataTable)dataGridView1.DataSource).Rows.Count == 0) { MessageDialog.ShowPromptMessage("请选择人员"); return; } if (dataGridView1.Rows.Count > 1 && !_IsMultiSelect) { MessageDialog.ShowPromptMessage("无法选择多条记录"); return; } m_receivedUserType = GlobalObject.GeneralFunction.StringConvertToEnum <BillFlowMessage_ReceivedUserType>(tabControl1.SelectedTab.Name); DataTable tempTable = new DataTable(); switch (m_receivedUserType) { case BillFlowMessage_ReceivedUserType.用户: DataTable tempPersonnel = (DataTable)dataGridView1.DataSource; m_listSelectedPersonnels = new List <PersonnelBasicInfo>(); foreach (DataRow dr in tempPersonnel.Rows) { PersonnelBasicInfo entityInfo = new PersonnelBasicInfo(); entityInfo.工号 = dr["员工编号"].ToString(); entityInfo.姓名 = dr["员工姓名"].ToString(); m_listSelectedPersonnels.Add(entityInfo); } break; case BillFlowMessage_ReceivedUserType.角色: DataTable tempRole = (DataTable)dataGridView1.DataSource; m_listSelectedPersonnels = new List <PersonnelBasicInfo>(); foreach (DataRow dr in tempRole.Rows) { PersonnelBasicInfo entityInfo = new PersonnelBasicInfo(); entityInfo.角色 = dr["角色名称"].ToString(); m_listSelectedPersonnels.Add(entityInfo); } break; default: break; } m_notifyPersonnelInfo.UserType = m_receivedUserType.ToString(); m_notifyPersonnelInfo.PersonnelBasicInfoList = m_listSelectedPersonnels; #region 2013-11-18 如果选择人员有问题则返回 if (OnCheckSelectedPersonnel != null) { if (!OnCheckSelectedPersonnel(m_listSelectedPersonnels)) { return; } } #endregion this.DialogResult = DialogResult.OK; this.Close(); }
/// <summary> /// 测试过滤条件 /// </summary> /// <returns>成功返回true</returns> private bool TestFilterCondition() { int leftParentheses = 0; int rightParentheses = 0; m_sentenceSQL = ""; try { for (int i = 0; i < panelParameter.Controls.Count; i++) { UserControlFindCondition control = panelParameter.Controls[i] as UserControlFindCondition; leftParentheses += control.LeftParentheses.Length == 0 ? 0 : 1; rightParentheses += control.RightParentheses.Length == 0 ? 0 : 1; if (i != panelParameter.Controls.Count - 1) { m_sentenceSQL = m_sentenceSQL + control.BuildSQLSentence("", false); } else { m_sentenceSQL = m_sentenceSQL + control.BuildSQLSentence("", true); } } if (leftParentheses != rightParentheses) { MessageDialog.ShowPromptMessage("左右括号数量不匹配"); return(false); } } catch (Exception exce) { Console.WriteLine(exce.Message); return(false); } IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = ""; switch (m_findBusiness) { case "报检入库单": businessID = "报检入库单查询"; break; case "普通入库单": businessID = "普通入库单查询"; break; case "采购退货单": businessID = "采购退货单查询"; break; case "领料单": businessID = "领料单查询"; break; case "领料退库单": businessID = "领料退库单查询"; break; case "销售退库单": businessID = "销售退库单查询"; break; case "销售出库单": businessID = "销售出库单查询"; break; case "产品入库单": businessID = "产品入库单查询"; break; case "还货单": businessID = "还货单查询"; break; case "借货单": businessID = "借货单查询"; break; case "报废单": businessID = "报废单查询"; break; case "合同信息管理": businessID = "合同信息综合查询"; break; case "订单信息管理": businessID = "订单信息综合查询"; break; case "自制件入库单": businessID = "自制件入库单查询"; break; case "产品型号变更单": businessID = "产品型号变更单查询"; break; } m_queryResult = authorization.Query(businessID, null, m_sentenceSQL); if (!m_queryResult.Succeeded) { MessageDialog.ShowErrorMessage(m_queryResult.Error); return(false); } else { return(true); } }
private void btnImport_Click(object sender, EventArgs e) { DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { return; } m_receivedUserType = GlobalObject.GeneralFunction.StringConvertToEnum <BillFlowMessage_ReceivedUserType>(tabControl1.SelectedTab.Name); switch (m_receivedUserType) { case BillFlowMessage_ReceivedUserType.用户: if (!dtTemp.Columns.Contains("员工姓名") && !dtTemp.Columns.Contains("员工编号")) { MessageDialog.ShowPromptMessage("无【员工编号】或【员工姓名】列"); return; } DataTable tempTable = ((DataTable)dataGridView2.DataSource).Clone(); foreach (DataRow dr in dtTemp.Rows) { DataRow newRow = tempTable.NewRow(); View_HR_Personnel personnel = new View_HR_Personnel(); object obj = ""; if (dtTemp.Columns.Contains("员工编号")) { obj = dr["员工编号"]; } else { obj = dr["员工姓名"]; } if (obj == null) { MessageDialog.ShowPromptMessage("有一行记录为空,请重新检查"); return; } personnel = UniversalFunction.GetPersonnelInfo(obj.ToString()); if (personnel == null) { MessageDialog.ShowPromptMessage("【员工编号】/【员工姓名】: " + obj.ToString() + " 数据错误,请重新检查"); return; } newRow["员工编号"] = personnel.工号; newRow["员工姓名"] = personnel.姓名; tempTable.Rows.Add(newRow); } dataGridView1.DataSource = tempTable; break; case BillFlowMessage_ReceivedUserType.角色: break; default: break; } }
/// <summary> /// 提交并查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFind_Click(object sender, EventArgs e) { if (panelParameter.Controls.Count == 0) { MessageDialog.ShowPromptMessage("您还没有建立查询条件无法进行此操作!"); return; } m_sentenceSQL = null; string pareTemp = ""; try { for (int i = 0; i < panelParameter.Controls.Count; i++) { UserControlFindCondition newControl = panelParameter.Controls[i] as UserControlFindCondition; if (i != panelParameter.Controls.Count - 1) { m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("", false); } else { m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("", true); if (newControl.FieldName == "单据号") { pareTemp = newControl.DataValue; } } } } catch (Exception exce) { Console.WriteLine(exce.Message); return; } IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = ""; switch (m_findBusiness) { case "报检入库单": businessID = "报检入库单查询"; break; case "普通入库单": businessID = "普通入库单查询"; break; case "采购退货单": businessID = "采购退货单查询"; break; case "领料单": businessID = "领料单查询"; break; case "领料退库单": businessID = "领料退库单查询"; break; case "销售退库单": businessID = "销售退库单查询"; break; case "销售出库单": businessID = "销售出库单查询"; break; case "产品入库单": businessID = "产品入库单查询"; break; case "报废单": businessID = "报废单查询"; break; case "报废单综合查询": businessID = m_findBusiness; break; case "合同信息管理": businessID = "合同信息综合查询"; break; case "订单信息管理": businessID = "订单信息综合查询"; break; case "自制件入库单": businessID = "自制件入库单查询"; break; case "采购退货单综合查询": businessID = m_findBusiness; break; case "领料单综合查询": businessID = m_findBusiness; break; case "样品确认申请单": businessID = "样品确认申请单综合查询"; break; case "不合格品隔离处置单": businessID = "不合格品隔离处置单查询"; break; case "挑选返工返修单": businessID = "挑选返工返修单查询"; break; case "供应质量信息反馈单": businessID = "供应商质量信息反馈单查询"; break; case "委外报检入库单": businessID = "委外报检入库单查询"; break; case "产品型号变更单": businessID = "产品型号变更单查询"; break; default: businessID = m_findBusiness; break; } string sql = m_sentenceSQL.ToLower(); if (sql.LastIndexOf(" union ") != -1) { MessageDialog.ShowPromptMessage("存在非法字符,无法进行此操作!"); return; } if (businessID == "培训综合统计查询" && (m_sentenceSQL.Contains("培训开始时间") || m_sentenceSQL.Contains("培训终止时间"))) { m_sentenceSQL = m_sentenceSQL + " or 培训开始时间 is null"; } IQueryResult qr = authorization.Query(businessID, null, m_sentenceSQL); if (m_findBusiness == "零星采购申请财务综合查询") { string[] pare = { pareTemp }; qr = authorization.QueryMultParam(businessID, m_sentenceSQL, pare); } if (m_findBusiness == "出差综合查询") { string[] pare = { BasicInfo.DeptCode }; qr = authorization.QueryMultParam(businessID, m_sentenceSQL, pare); } if (m_findBusiness == "出差人员查看") { string[] pare = { BasicInfo.LoginID }; qr = authorization.QueryMultParam(businessID, m_sentenceSQL, pare); } if (m_findBusiness == "订单入库单综合查询") { qr = authorization.QueryMultParam(businessID, m_sentenceSQL, m_proParameter); } if (!qr.Succeeded) { m_quertResultTable = null; MessageDialog.ShowErrorMessage(qr.Error); } else { m_quertResultTable = qr.DataCollection.Tables[0]; lblAmount.Text = m_quertResultTable.Rows.Count.ToString(); } dataGridView1.DataSource = m_quertResultTable; for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Name.Contains("标志") || dataGridView1.Columns[i].Name.Contains("领料类型") || dataGridView1.Columns[i].Name.Contains("人编码") || //dataGridView1.Columns[i].Name.Contains("签名") || dataGridView1.Columns[i].Name.Contains("权限控制") || dataGridView1.Columns[i].Name.Contains("序号")) { dataGridView1.Columns[i].Visible = false; } } #region 隐藏不允许查看的列 if (qr.HideFields != null && qr.HideFields.Length > 0) { for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (qr.HideFields.Contains(dataGridView1.Columns[i].Name)) { dataGridView1.Columns[i].Visible = false; } } } #endregion if (!BasicInfo.ListRoles.Contains(CE_RoleEnum.采购账务管理员.ToString()) && !BasicInfo.ListRoles.Contains(CE_RoleEnum.会计.ToString())) { for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Name.Contains("单价") || dataGridView1.Columns[i].Name.Contains("金额")) { dataGridView1.Columns[i].Visible = false; } } } dataGridView1.Refresh(); }