/// <summary> /// 水晶报表 /// </summary> /// <param name="bsgridPage"></param> /// <returns></returns> /// public ActionResult ShuiJIngBaoBiao(int quFenLeiXingID) { //进仓、员工、类型、合同、供货商、结算方式 var Linq = (from tbWaerHouse in myModels.B_WareHouseList join tbStall in myModels.B_StaffList on tbWaerHouse.StaffID equals tbStall.StaffID //员工 join tbQuFen in myModels.S_QuFenLeiXingList on tbWaerHouse.QuFenLeiXingID equals tbQuFen.QuFenLeiXingID //区分类型 join tbHeTong in myModels.B_OrderFormPactList on tbWaerHouse.OrderFormPactID equals tbHeTong.OrderFormPactID //合同 join tbSupplier in myModels.B_SupplierList on tbHeTong.SupplierID equals tbSupplier.SupplierID //供货商 join tbJieSuan in myModels.S_MethodOfSettlingAccountsList on tbHeTong.MethodOfSettlingAccountsID equals tbJieSuan.MethodOfSettlingAccountsID //结算 orderby tbWaerHouse.Remember descending select new LY.GongHuoShang { Remember = tbWaerHouse.Remember, //进仓编号 ContractNumber = tbHeTong.ContractNumber, //合同编号 MethodOfSettlingAccounts = tbJieSuan.MethodOfSettlingAccounts, //结算方式 SupplierCHName = tbSupplier.SupplierCHName, //供货商名称 StaffCode = tbStall.StaffCode, //员工编号 StaffName = tbStall.StaffName, //姓名 RegisterTime = tbWaerHouse.RegisterTime.ToString(), //登记时间 ExamineNot = tbWaerHouse.ExamineNot.ToString(), //审核状态 Status = tbWaerHouse.Status.ToString(), //生效状态 CrushRedNot = tbWaerHouse.CrushRedNot.ToString(), //冲红状态 QuFenLeiXingID = tbQuFen.QuFenLeiXingID, //区分ID QuFenLeiXingMC = tbQuFen.QuFenLeiXingMC //区分 }).ToList(); List <GongHuoShang> listWareHouseDeitaLL = new List <GongHuoShang>(); for (int i = 0; i < Linq.Count; i++) { GongHuoShang myWareHouseDeitaLL = new GongHuoShang(); if (Convert.ToBoolean(Linq[i].ExamineNot) == true) { myWareHouseDeitaLL.ExamineNot = "已审核"; } else { myWareHouseDeitaLL.ExamineNot = "未审核"; } if (Convert.ToBoolean(Linq[i].Status) == true) { myWareHouseDeitaLL.Status = "已生效"; } else { myWareHouseDeitaLL.Status = "未生效"; } if (Convert.ToBoolean(Linq[i].CrushRedNot) == true) { myWareHouseDeitaLL.CrushRedNot = "冲红单"; } else { myWareHouseDeitaLL.CrushRedNot = "正常有效使用单"; } myWareHouseDeitaLL.Remember = Linq[i].Remember; myWareHouseDeitaLL.ContractNumber = Linq[i].ContractNumber; myWareHouseDeitaLL.MethodOfSettlingAccounts = Linq[i].MethodOfSettlingAccounts; myWareHouseDeitaLL.SupplierCHName = Linq[i].SupplierCHName; myWareHouseDeitaLL.StaffCode = Linq[i].StaffCode; myWareHouseDeitaLL.StaffName = Linq[i].StaffName; myWareHouseDeitaLL.RegisterTime = Linq[i].RegisterTime; myWareHouseDeitaLL.QuFenLeiXingID = Linq[i].QuFenLeiXingID; myWareHouseDeitaLL.QuFenLeiXingMC = Linq[i].QuFenLeiXingMC; listWareHouseDeitaLL.Add(myWareHouseDeitaLL); } //查询数据 List <GongHuoShang> listExaminee = listWareHouseDeitaLL; //实例table DataTable dt = new DataTable(); //给table添加列 dt.Columns.Add("Remember"); dt.Columns.Add("ContractNumber"); dt.Columns.Add("MethodOfSettlingAccounts"); dt.Columns.Add("SupplierCHName"); dt.Columns.Add("StaffCode"); dt.Columns.Add("StaffName"); dt.Columns.Add("RegisterTime"); dt.Columns.Add("ExamineNot");//如果出错bit 类型,去数据集改类型 dt.Columns.Add("Status"); dt.Columns.Add("CrushRedNot"); dt.Columns.Add("QuFenLeiXingMC"); foreach (GongHuoShang item in listExaminee) { DataRow dr = dt.NewRow(); dr["Remember"] = item.Remember; dr["ContractNumber"] = item.ContractNumber; dr["MethodOfSettlingAccounts"] = item.MethodOfSettlingAccounts; dr["SupplierCHName"] = item.SupplierCHName; dr["StaffCode"] = item.StaffCode; dr["StaffName"] = item.StaffName; dr["RegisterTime"] = item.RegisterTime; dr["ExamineNot"] = item.ExamineNot; dr["Status"] = item.Status; dr["CrushRedNot"] = item.CrushRedNot; dr["QuFenLeiXingMC"] = item.QuFenLeiXingMC; dt.Rows.Add(dr); } //1、实例数据集 CRP.DataSWareHou dtAchievement = new CRP.DataSWareHou(); //2、合并: dtAchievement.Tables["DataWareHouer"].Merge(dt); ReportDocument rd = new ReportDocument(); string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Areas\\CRP\\CrystalReWareHour.rpt"; rd.Load(strRptPath); rd.SetDataSource(dtAchievement); //设置报表数据源 //最后(IO 流形式) Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return(File(stream, "application/pdf")); }
/// <summary> /// 浏览器打印 /// </summary> /// <returns></returns> public ActionResult WidowesDaYin() { var Linq = (from tbWaerHouse in myModels.B_WareHouseList join tbStall in myModels.B_StaffList on tbWaerHouse.StaffID equals tbStall.StaffID //员工 join tbQuFen in myModels.S_QuFenLeiXingList on tbWaerHouse.QuFenLeiXingID equals tbQuFen.QuFenLeiXingID //区分类型 join tbHeTong in myModels.B_OrderFormPactList on tbWaerHouse.OrderFormPactID equals tbHeTong.OrderFormPactID //合同 join tbSupplier in myModels.B_SupplierList on tbHeTong.SupplierID equals tbSupplier.SupplierID //供货商 join tbJieSuan in myModels.S_MethodOfSettlingAccountsList on tbHeTong.MethodOfSettlingAccountsID equals tbJieSuan.MethodOfSettlingAccountsID //结算 orderby tbWaerHouse.Remember descending select new LY.GongHuoShang { Remember = tbWaerHouse.Remember, //进仓编号 ContractNumber = tbHeTong.ContractNumber, //合同编号 MethodOfSettlingAccounts = tbJieSuan.MethodOfSettlingAccounts, //结算方式 SupplierCHName = tbSupplier.SupplierCHName, //供货商名称 StaffCode = tbStall.StaffCode, //员工编号 StaffName = tbStall.StaffName, //姓名 RegisterTime = tbWaerHouse.RegisterTime.ToString(), //登记时间 ExamineNot = tbWaerHouse.ExamineNot.ToString(), //审核状态 Status = tbWaerHouse.Status.ToString(), //生效状态 CrushRedNot = tbWaerHouse.CrushRedNot.ToString(), //冲红状态 QuFenLeiXingID = tbQuFen.QuFenLeiXingID, //区分ID QuFenLeiXingMC = tbQuFen.QuFenLeiXingMC //区分 }).ToList(); List <GongHuoShang> listWareHouseDeitaLL = new List <GongHuoShang>(); for (int i = 0; i < Linq.Count; i++) { GongHuoShang myWareHouseDeitaLL = new GongHuoShang(); if (Convert.ToBoolean(Linq[i].ExamineNot) == true) { myWareHouseDeitaLL.ExamineNot = "已审核"; } else { myWareHouseDeitaLL.ExamineNot = "未审核"; } if (Convert.ToBoolean(Linq[i].Status) == true) { myWareHouseDeitaLL.Status = "已生效"; } else { myWareHouseDeitaLL.Status = "未生效"; } if (Convert.ToBoolean(Linq[i].CrushRedNot) == true) { myWareHouseDeitaLL.CrushRedNot = "冲红单"; } else { myWareHouseDeitaLL.CrushRedNot = "正常有效使用单"; } myWareHouseDeitaLL.Remember = Linq[i].Remember; myWareHouseDeitaLL.ContractNumber = Linq[i].ContractNumber; myWareHouseDeitaLL.MethodOfSettlingAccounts = Linq[i].MethodOfSettlingAccounts; myWareHouseDeitaLL.SupplierCHName = Linq[i].SupplierCHName; myWareHouseDeitaLL.StaffCode = Linq[i].StaffCode; myWareHouseDeitaLL.StaffName = Linq[i].StaffName; myWareHouseDeitaLL.RegisterTime = Linq[i].RegisterTime; myWareHouseDeitaLL.QuFenLeiXingID = Linq[i].QuFenLeiXingID; myWareHouseDeitaLL.QuFenLeiXingMC = Linq[i].QuFenLeiXingMC; listWareHouseDeitaLL.Add(myWareHouseDeitaLL); } return(PartialView(listWareHouseDeitaLL)); }