/// <summary> /// 上传 /// </summary> void FileUpLoad() { try { if (m_filePathExternal.Trim().Length == 0) { if (openFileDialog1.ShowDialog() == DialogResult.OK) { m_filePathExternal = openFileDialog1.FileName; } } if (m_filePathExternal.Trim().Length > 0) { CursorControl.SetWaitCursor(this); m_serverFileFtp.Upload(m_filePathExternal, m_filePathInternal); this.Cursor = System.Windows.Forms.Cursors.Arrow; if (GetError()) { MessageDialog.ShowPromptMessage("上传成功"); } } } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); this.Cursor = System.Windows.Forms.Cursors.Arrow; } }
/// <summary> /// 获取供应商信息对话框 /// </summary> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetProviderInfoDialog(string strType) { IProviderServer m_providerServer = ServerModuleFactory.GetServerModule <IProviderServer>(); IQueryable <View_Provider> queryResult; if (!m_providerServer.GetAllProvider(out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } queryResult = from r in queryResult where r.是否在用 == true select r; switch (strType) { case "零件合格供应商": queryResult = from r in queryResult where r.零星采购供应商 == false select r; break; default: break; } System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_Provider>(queryResult); FormQueryInfo form = new FormQueryInfo(dataTable); return(form); }
/// <summary> /// 刷新数据 /// </summary> public void RefreshData(TabPage tp) { try { DataGridView dgv = GetDataGridView(tp); dgv.DataSource = _ServiceFlow.ShowBusinessAllInfo(_Enum_BillType, cmbVersion.Text, checkBillDateAndStatus1.ListBillStatus == null || checkBillDateAndStatus1.ListBillStatus.Count() == 0 ? new string[] { "全部" } : checkBillDateAndStatus1.ListBillStatus.ToArray(), checkBillDateAndStatus1.dtpStartTime.Value, checkBillDateAndStatus1.dtpEndTime.Value, tp.Text, null); Flow_BusinessInfo bussinessInfo = _ServiceFlow.GetBusinessInfo(_Enum_BillType, cmbVersion.Text); foreach (DataGridViewColumn dgvc in dgv.Columns) { if (dgvc.HeaderText == bussinessInfo.KeysName) { dgvc.Visible = false; } } userControlDataLocalizer1.Init(dgv, this.Name, UniversalFunction.SelectHideFields(this.Name, dgv.Name, BasicInfo.LoginID)); } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); } }
/// <summary> /// 删除我的查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDeleteSearch_Click(object sender, EventArgs e) { if (cmbSearchName.Text == "") { MessageDialog.ShowPromptMessage("不允许删除空查询"); return; } else { if (MessageDialog.ShowEnquiryMessage("您真的要删除我的查询“" + cmbSearchName.Text + "”?") == DialogResult.Yes) { string error = null; if (!m_searchParamsServer.DeleteParam(m_parentTitle, Business, cmbSearchName.Text, out error)) { MessageDialog.ShowErrorMessage(error); } else { MessageDialog.ShowPromptMessage("操作成功"); cmbSearchName.Items.Remove(cmbSearchName.Text); if (cmbSearchName.Items.Count <= 1) { panelSelectSearch.Visible = false; } } } } }
/// <summary> /// 文件阅读 /// </summary> void FileRead() { try { string winFilePath = Path.Combine(GlobalObject.GlobalParameter.FileTempPath, m_fileName + m_fileNameSuffix); CursorControl.SetWaitCursor(this); m_serverFileFtp.Download(m_filePathInternal, winFilePath); this.Cursor = System.Windows.Forms.Cursors.Arrow; if (GetError()) { switch (m_fileType) { case CE_SystemFileType.Word: case CE_SystemFileType.Excel: Office文件显示 frmOffice = new Office文件显示(winFilePath, m_fileType); frmOffice.Show(); break; default: 其他文件显示 frmNormal = new 其他文件显示(winFilePath); frmNormal.Show(); break; } } } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); this.Cursor = System.Windows.Forms.Cursors.Arrow; } }
/// <summary> /// 获取供应商信息对话框 /// </summary> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetProviderInfoDialog() { IProviderServer m_providerServer = ServerModuleFactory.GetServerModule <IProviderServer>(); IQueryable <View_Provider> queryResult; DepotManagementDataContext ctx = CommentParameter.DepotDataContext; if (!m_providerServer.GetAllProvider(out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } queryResult = from r in queryResult where r.是否在用 == true select r; if (!BasicInfo.ListRoles.Contains(CE_RoleEnum.采购账务管理员.ToString()) && BasicInfo.ListRoles.Contains(CE_RoleEnum.采购员.ToString())) { var varData = (from r in ctx.View_Provider join f in ctx.ProviderPrincipal on r.供应商编码 equals f.Provider where f.PrincipalWorkId == BasicInfo.LoginID && r.是否在用 == true select r).Distinct(); List <View_Provider> lstProvider = new List <View_Provider>(); foreach (var item in varData) { View_Provider lnqProvider = new View_Provider(); lnqProvider.供应商编码 = item.供应商编码; lnqProvider.供应商名称 = item.供应商名称; lnqProvider.简称 = item.简称; lnqProvider.拼音码 = item.拼音码; lnqProvider.零星采购供应商 = item.零星采购供应商; lnqProvider.是否在用 = item.是否在用; lnqProvider.五笔码 = item.五笔码; lstProvider.Add(lnqProvider); } queryResult = lstProvider.AsQueryable(); } System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_Provider>(queryResult); FormQueryInfo form = new FormQueryInfo(dataTable); return(form); }
/// <summary> /// 保存我的查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (!TestFilterCondition()) { return; } List <FilterInfo> lstFilter = new List <FilterInfo>(); for (int i = 0; i < panelParameter.Controls.Count; i++) { UserControlFindCondition control = panelParameter.Controls[i] as UserControlFindCondition; FilterInfo info = new FilterInfo(); info.OrderNo = i; info.FieldName = control.FieldName; info.DataValue = control.DataValue; if (m_queryResult != null) { info.DataType = m_queryResult.DataCollection.Tables[0].Columns[info.FieldName].DataType.Name; } else { info.DataType = control.DataType; } info.Logic = control.LogicSymbol; info._operator1 = control.Operator; info.LeftParentheses = control.LeftParentheses; info.RghtParentheses = control.RightParentheses; lstFilter.Add(info); } QueryFilterControl.SaveFilter(m_title, lstFilter); QueryFilterControl.Save(); MessageDialog.ShowPromptMessage("成功保存查询过滤条件!"); } catch (Exception exce) { MessageDialog.ShowErrorMessage(exce.Message); } }
/// <summary> /// 为领料而获取领料退库单信息对话框 /// </summary> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetReturnedInDepotBillDialogForFetchGoods() { IMaterialReturnedInTheDepot billServer = ServerModuleFactory.GetServerModule <IMaterialReturnedInTheDepot>(); PlatformManagement.IQueryResult queryInfo; if (!billServer.GetAllBillForFetchGoods(out queryInfo, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } FormQueryInfo form = new FormQueryInfo(queryInfo); form.ShowColumns = new string[] { "退库单号", "退库时间", "申请部门", "申请人", "初始用途", "退库原因", "备注" }; return(form); }
/// <summary> /// 为领料而获取报废单信息对话框 /// </summary> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetScrapBillDialogForFetchGoods() { IScrapBillServer scrapBillServer = ServerModuleFactory.GetServerModule <IScrapBillServer>(); PlatformManagement.IQueryResult queryInfo; if (!scrapBillServer.GetAllBillForFetchGoods(out queryInfo, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } FormQueryInfo form = new FormQueryInfo(queryInfo); form.ShowColumns = new string[] { "报废单号", "报废时间", "报废类别", "报废原因", "是否冲抵领料单", "申请人签名", "仓管签名" }; return(form); }
/// <summary> /// 选择原来保存了的检索名称 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmbSearchName_SelectedIndexChanged(object sender, EventArgs e) { panelParameter.Controls.Clear(); panelTop.Height = 120; if (cmbSearchName.Text != "") { string error = null; IQueryable <SYS_SearchParams> searchParams = m_searchParamsServer.GetParams( m_parentTitle, Business, cmbSearchName.Text, out error); if (searchParams == null) { return; } if (!GlobalObject.GeneralFunction.IsNullOrEmpty(error)) { MessageDialog.ShowErrorMessage(error); return; } m_count = 0; foreach (var item in searchParams) { UserControlFindCondition tmpControl = new UserControlFindCondition(m_arrayFindFild, this); tmpControl.LeftParentheses = item.LeftParentheses.ToString(); tmpControl.FieldName = item.FieldName; tmpControl.Operator = item.Operator; tmpControl.DataType = item.DataType; tmpControl.DataValue = item.DataValue; tmpControl.RightParentheses = item.RightParentheses.ToString(); tmpControl.LogicSymbol = item.Logic; tmpControl.Parent = panelParameter; tmpControl.Dock = DockStyle.Bottom; panelTop.Height = panelTop.Height + tmpControl.Height; m_count++; tmpControl.Name = m_count.ToString(); } } }
/// <summary> /// 文件编辑 /// </summary> void FileEdit() { try { string winFilePath = Path.Combine(GlobalObject.GlobalParameter.FileTempPath, m_fileName + m_fileNameSuffix); m_serverFileFtp.Download(m_filePathInternal, winFilePath); Thread thread = new Thread(new ThreadStart(ProcessMethod)); thread.IsBackground = true; thread.Start(); } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); this.Cursor = System.Windows.Forms.Cursors.Arrow; } }
/// <summary> /// 获取库存中指定物品的供应商信息对话框 /// </summary> /// <param name="goodsID">物品ID</param> /// <param name="providerType">供应商类型</param> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetDistinctProviderInfoDialog(int goodsID, CE_ScrapProviderType providerType) { IProviderServer m_providerServer = ServerModuleFactory.GetServerModule <IProviderServer>(); IQueryable <View_Provider> queryResult; System.Data.DataTable dataTable = new DataTable(); switch (providerType) { case CE_ScrapProviderType.责任供应商: if (!m_providerServer.GetDistinctProvider(out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_Provider>(queryResult); break; case CE_ScrapProviderType.供应商: View_F_GoodsPlanCost viewGoods = UniversalFunction.GetGoodsInfo(goodsID); string strSql = " select distinct a.* from View_Provider as a inner join ( " + " select distinct GoodsID, Provider from S_InDepotDetailBill as a " + " union all select distinct GoodsID, Provider from S_Stock) as b " + " on a.供应商编码 = b.Provider inner join F_GoodsPlanCost as c on b.GoodsID = c.ID " + " where GoodsName = '" + viewGoods.物品名称 + "'"; dataTable = GlobalObject.DatabaseServer.QueryInfo(strSql); break; default: break; } FormQueryInfo form = new FormQueryInfo(dataTable); form.ShowColumns = new string[] { "供应商编码" }; return(form); }
/// <summary> /// 获取订单信息对话框 /// </summary> /// <param name="billType">单据类型</param> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetOrderFormInfoDialog(CE_BillTypeEnum billType) { DepotManagementDataContext dataContext = CommentParameter.DepotDataContext; IOrderFormInfoServer orderFormInfoServer = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>(); IQueryable <View_B_OrderFormInfo> queryResult; if (!orderFormInfoServer.GetAllOrderFormInfo(BasicInfo.ListRoles, BasicInfo.LoginID, billType, out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_B_OrderFormInfo>(queryResult); FormQueryInfo form = new FormQueryInfo(dataTable); form.HideColumns = new string[] { "供应商联系人", "供应商联系电话", "供应商传真号", "供应商电子邮件", "权限控制用登录名", "录入人员" }; return(form); }
/// <summary> /// 获取指定订单的物品信息对话框 /// </summary> /// <param name="orderFormNumber">订单号</param> /// <param name="simpleMode">是否是简单模式的标志, 是则只显示最基本的物品信息列(图号、名称、规格)</param> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetOrderFormGoodsDialog(string orderFormNumber, bool simpleMode) { IOrderFormGoodsServer orderFormGoodsServer = ServerModuleFactory.GetServerModule <IOrderFormGoodsServer>(); IQueryable <View_B_OrderFormGoods> queryResult; if (!orderFormGoodsServer.GetOrderFormGoods(BasicInfo.ListRoles, BasicInfo.LoginID, orderFormNumber, out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } //FormQueryInfo form = new FormQueryInfo(queryInfo); System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_B_OrderFormGoods>(queryResult); FormQueryInfo form = new FormQueryInfo(dataTable); if (simpleMode) { form.ShowColumns = new string[] { "物品ID", "图号型号", "物品名称", "规格" }; } return(form); }
/// <summary> /// 获取指定合同的物品信息对话框 /// </summary> /// <param name="bargainNumber">合同号</param> /// <param name="simpleMode">是否是简单模式的标志, 是则只显示最基本的物品信息列(图号、名称、规格)</param> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetBargainGoodsDialog(string bargainNumber, bool simpleMode) { IBargainGoodsServer infoServer = ServerModuleFactory.GetServerModule <IBargainGoodsServer>(); IQueryable <View_B_BargainGoods> queryResult; if (!infoServer.GetBargainGoods(bargainNumber, out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } //FormQueryInfo form = new FormQueryInfo(queryInfo); System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_B_BargainGoods>(queryResult); FormQueryInfo form = new FormQueryInfo(dataTable); if (simpleMode) { form.ShowColumns = new string[] { "图号型号", "物品名称", "规格" }; } return(form); }
/// <summary> /// 显示帮助 /// </summary> /// <param name="keyword">要显示帮助的关键字</param> static void Show(string keyword) { if (m_hp == null) { m_hp = new HelpProvider(); m_hp.HelpNamespace = "进销存信息化系统操作手册.chm"; } if (m_helpControl == null) { MessageDialog.ShowErrorMessage("用于触发帮助的控件为NULL,操作失败"); return; } if (GlobalObject.GeneralFunction.IsNullOrEmpty(keyword)) { MessageDialog.ShowErrorMessage("帮助关键字为空,操作失败"); return; } Help.ShowHelp(m_helpControl, m_hp.HelpNamespace, HelpNavigator.KeywordIndex, keyword); }
/// <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; } }
/// <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(); }
/// <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; } } } } }
/// <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 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> /// 获取库存中的物品信息对话框 /// </summary> /// <param name="billType">单据类型</param> /// <param name="showZeroStoreGoods">是否显示零库存物品</param> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetStoreGoodsInfoDialog(CE_BillTypeEnum billType, bool showZeroStoreGoods, string strStorageID) { IStoreServer server = ServerModuleFactory.GetServerModule <IStoreServer>(); IQueryable <View_S_Stock> queryResult; System.Data.DataTable dataTable = null; if (!server.GetAllStore(null, true, out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } // 仅显示状态为正常且不在隔离库中的物品 if (billType == CE_BillTypeEnum.领料单) { List <string> listTempStockStatus = new List <string>(); listTempStockStatus.Add("正常"); foreach (int statusID in _lstStockStatus) { switch (statusID) { case 1: listTempStockStatus.Add("仅限于返修箱用"); break; case 2: listTempStockStatus.Add("样品"); break; case 3: listTempStockStatus.Add("仅限于返修箱用"); listTempStockStatus.Add("仅限于售后备件"); break; case 4: listTempStockStatus.Add("隔离"); break; default: break; } } queryResult = from r in queryResult where listTempStockStatus.Contains(r.物品状态) && r.库房代码 == strStorageID select r; } else if (billType == CE_BillTypeEnum.领料退库单) { queryResult = from r in queryResult where r.物品状态 != "隔离" select r; } ////TCU 采购部领用委外装配 Modify by cjb on 2014.5.28 //if (!GlobalObject.GeneralFunction.IsNullOrEmpty(prefixDepotType) && strStorageID != "03") //{ // int len = prefixDepotType.Length; // queryResult = from r in queryResult where r.材料类别编码.Substring(0, len) == prefixDepotType select r; //} if (!showZeroStoreGoods) { queryResult = from r in queryResult where r.库存数量 > 0 select r; } FormQueryInfo form = null; if (!BasicInfo.ListRoles.Exists(r => r.Contains("库管理员"))) { if (billType == CE_BillTypeEnum.领料单 && !_lstStockStatus.Contains(2) && !_lstStockStatus.Contains(4)) { var result = (from r in queryResult select r).ToList().Distinct(new StockGoodsComparer()); dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_S_Stock>(result); } else { dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_S_Stock>(queryResult); } } else { dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_S_Stock>(queryResult); } form = new FormQueryInfo(dataTable); if (!showZeroStoreGoods) { form.Text = form.Text + ",库存数量为0的物品不会显示在列表中。"; } if (!BasicInfo.ListRoles.Exists(r => r.Contains("库管理员"))) { if (billType == CE_BillTypeEnum.报废单 || billType == CE_BillTypeEnum.领料退库单) { form.HideColumns = new string[] { "序号", "物品ID", "单位", "单位ID", "库存数量", "仓库", "货架", "层", "列", "实际单价", "实际金额" } } ; else if (billType == CE_BillTypeEnum.领料单) { form.HideColumns = new string[] { "序号", "物品ID", "单位", "实际单价", "实际金额" } } ; } else { form.HideColumns = new string[] { "序号", "物品ID", "单位ID", "单位", "实际单价", "实际金额" }; } return(form); }