private void 供应商挂账单_Load(object sender, EventArgs e) { View_Provider providerInfo = UniversalFunction.GetProviderInfo(_Provider); string strSql = "select 挂账年月, 图号型号, 物品名称, 规格, 供应商, 挂账方式 + '挂账' as 挂账方式, 协议单价, 税率, 上月未挂, 本月入库, 本月应挂, " + " 本月未挂, 到票数量, 到票金额, F_Id, GoodsID, 单位 as 计量单位 from View_Bus_PurchasingMG_Account " + " where 挂账年月 = '" + _YearMonth + "' and 供应商 = '" + _Provider + "' and 本月应挂 > 0"; DataTable tempTable = GlobalObject.DatabaseServer.QueryInfo(strSql); reportViewer1.LocalReport.DataSources.Clear(); List <ReportParameter> para = new List <ReportParameter>(); //这里是添加两个字段 para.Add(new ReportParameter("供应商", providerInfo.供应商名称)); para.Add(new ReportParameter("挂账年月", _YearMonth.Substring(0, 4) + "年" + _YearMonth.Substring(4, 2) + "月")); para.Add(new ReportParameter("打印人", BasicInfo.LoginName)); this.reportViewer1.LocalReport.SetParameters(para); ReportDataSource rds = new ReportDataSource("ReportDataSet_View_Bus_PurchasingMG_Account", tempTable); reportViewer1.LocalReport.DataSources.Add(rds); this.reportViewer1.RefreshReport(); }
/// <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); }
private void btnInput_Click(object sender, EventArgs e) { try { DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { return; } if (!dtTemp.Columns.Contains("图号型号")) { throw new Exception("文件无【图号型号】列名"); } if (!dtTemp.Columns.Contains("物品名称")) { throw new Exception("文件无【物品名称】列名"); } if (!dtTemp.Columns.Contains("规格")) { throw new Exception("文件无【规格】列名"); } if (!dtTemp.Columns.Contains("供应商")) { throw new Exception("文件无【供应商】列名"); } if (!dtTemp.Columns.Contains("单价")) { throw new Exception("文件无【单价】列名"); } if (!dtTemp.Columns.Contains("税率")) { throw new Exception("文件无【税率】列名"); } if (!dtTemp.Columns.Contains("有效期开始时间")) { throw new Exception("文件无【有效期开始时间】列名"); } if (!dtTemp.Columns.Contains("有效期结束时间")) { throw new Exception("文件无【有效期结束时间】列名"); } List <Bus_PurchasingMG_UnitPriceList> lstTemp = new List <Bus_PurchasingMG_UnitPriceList>(); foreach (DataRow dr in dtTemp.Rows) { if ((dr["图号型号"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dr["图号型号"].ToString())) && (dr["物品名称"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dr["物品名称"].ToString())) && (dr["规格"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dr["规格"].ToString()))) { continue; } Bus_PurchasingMG_UnitPriceList tempInfo = new Bus_PurchasingMG_UnitPriceList(); string goodsMessage = "【图号型号】:" + (dr["图号型号"] == null ? "" : dr["图号型号"].ToString().Trim()).ToString() + "【物品名称】:" + (dr["物品名称"] == null ? "" : dr["物品名称"].ToString().Trim()).ToString() + "【规格】:" + (dr["规格"] == null ? "" : dr["规格"].ToString().Trim()).ToString(); View_F_GoodsPlanCost goodsInfo = UniversalFunction.GetGoodsInfo(dr["图号型号"] == null ? "" : dr["图号型号"].ToString().Trim(), dr["物品名称"] == null ? "" : dr["物品名称"].ToString().Trim(), dr["规格"] == null ? "" : dr["规格"].ToString().Trim()); if (goodsInfo == null) { throw new Exception("未找到对应的系统物品:" + goodsMessage); } //if (goodsInfo.禁用) //{ // throw new Exception("此物品已被禁用无法导入:" + goodsMessage); //} tempInfo.GoodsID = goodsInfo.序号; string strProvicer = dr["供应商"] == null ? "" : dr["供应商"].ToString(); View_Provider provider = UniversalFunction.GetProviderInfo(strProvicer); if (provider == null) { throw new Exception("未找到对应的系统供应商:" + strProvicer); } if (!provider.是否在用) { throw new Exception("【系统供应商】:" + strProvicer + " 被禁用,无法导入"); } tempInfo.Provider = provider.供应商编码; tempInfo.Rate = dr["税率"] == null || dr["税率"].ToString().Trim() == "" ? 0 : Convert.ToInt32(dr["税率"]); tempInfo.UnitPrice = dr["单价"] == null || dr["单价"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(dr["单价"]); if (dr["有效期开始时间"] == null || dr["有效期开始时间"].ToString().Trim() == "") { throw new Exception("有效期开始时间有误:" + goodsMessage); } else { tempInfo.ValidityStart = Convert.ToDateTime(dr["有效期开始时间"]).Date; } if (dr["有效期结束时间"] == null || dr["有效期结束时间"].ToString().Trim() == "") { throw new Exception("有效期结束时间有误:" + goodsMessage); } else { tempInfo.ValidityEnd = Convert.ToDateTime(dr["有效期结束时间"]).Date; } lstTemp.Add(tempInfo); } _Service_UnitList.SaveInfo(lstTemp); MessageDialog.ShowPromptMessage("导入并保存成功"); DataGridViewShow(); } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }