public IEnumerable <CeShi> FenYeGet(int page, int rows, string s)
{
DataTable dt = MySqlHelper.ExecuteDataTable("select Id,时间,进口压力,出口压力,设定压力,1变频器运行频率,2变频器运行频率,3变频器运行频率,4变频器运行频率 from " + s + " limit " + (page - 1) * rows + "," + rows + ";");
List <CeShi> list = new List <CeShi>();
foreach (DataRow dr in dt.Rows)
{
CeShi p = new CeShi();
p.Id = Convert.ToInt32(dr["Id"]);
p.时间 = (DateTime)dr["时间"];
p.进口压力 = dr["进口压力"].ToString();
p.出口压力 = dr["出口压力"].ToString();
p.设定压力 = dr["设定压力"].ToString();
p.变频器1运行频率 = dr["1变频器运行频率"].ToString();
p.变频器2运行频率 = dr["2变频器运行频率"].ToString();
p.变频器3运行频率 = dr["3变频器运行频率"].ToString();
p.变频器4运行频率 = dr["4变频器运行频率"].ToString();
list.Add(p);
}
return(list);
}
/// <summary>
/// 水晶打印配货单
/// </summary>
/// <returns></returns>
public ActionResult ShuiJingConverList()
{
var Linq = (from tbConverlist in MyModels.B_ConverList
join tbFaHuoBuMen in MyModels.S_SpouseBRanchList on tbConverlist.SpouseBRanchID equals tbFaHuoBuMen.SpouseBRanchID
join tbShouHuoBuMen in MyModels.S_StockPlaceList on tbConverlist.StockPlaceID equals tbShouHuoBuMen.StockPlaceID
orderby tbConverlist.P_Remember descending
select new LY.CeShi
{
ConverID = tbConverlist.ConverID, //id
P_Remember = tbConverlist.P_Remember, //编号
payName = tbConverlist.payName, //发货人
furlName = tbConverlist.furlName, //收货人
SpouseBRanchName = tbFaHuoBuMen.SpouseBRanchName, //发货部门
StockPlaceName = tbShouHuoBuMen.StockPlaceName, //发货部门
Remarks = tbConverlist.Remarks, //备注
RegisterName = tbConverlist.RegisterName, //制单人
registerTime = tbConverlist.RegisterTime.ToString(), //制单时间
ExamineName = tbConverlist.ExamineName, //审核人
examineTime = tbConverlist.ExamineTime.ToString(), //审核时间
ExamineNot = tbConverlist.ExamineNot.ToString() //审核否
}).ToList();
List <CeShi> listWareHouseDeitaLL = new List <CeShi>();
for (int i = 0; i < Linq.Count; i++)
{
CeShi myWareHouseDeitaLL = new CeShi();
if (Convert.ToBoolean(Linq[i].ExamineNot) == true)
{
myWareHouseDeitaLL.ExamineNot = "已审核";
}
else
{
myWareHouseDeitaLL.ExamineNot = "未审核";
}
myWareHouseDeitaLL.P_Remember = Linq[i].P_Remember;
myWareHouseDeitaLL.payName = Linq[i].payName;
myWareHouseDeitaLL.furlName = Linq[i].furlName;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.StockPlaceName = Linq[i].StockPlaceName;
myWareHouseDeitaLL.Remarks = Linq[i].Remarks;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
//查询数据
List <CeShi> listExaminee = listWareHouseDeitaLL;
//实例table
DataTable dt = new DataTable();
//给table添加列
dt.Columns.Add("P_Remember");
dt.Columns.Add("payName");
dt.Columns.Add("furlName");
dt.Columns.Add("SpouseBRanchName");
dt.Columns.Add("StockPlaceName");
dt.Columns.Add("Remarks");
dt.Columns.Add("registerTime");
dt.Columns.Add("RegisterName");
dt.Columns.Add("ExamineName");
dt.Columns.Add("examineTime");
dt.Columns.Add("ExamineNot");
foreach (CeShi item in listExaminee)
{
DataRow dr = dt.NewRow();
dr["P_Remember"] = item.P_Remember;
dr["payName"] = item.payName;
dr["furlName"] = item.furlName;
dr["SpouseBRanchName"] = item.SpouseBRanchName;
dr["StockPlaceName"] = item.StockPlaceName;
dr["Remarks"] = item.Remarks;
dr["registerTime"] = item.registerTime;
dr["RegisterName"] = item.RegisterName;
dr["ExamineName"] = item.ExamineName;
dr["examineTime"] = item.examineTime;
dr["ExamineNot"] = item.ExamineNot;
dt.Rows.Add(dr);
}
//1、实例数据集
CRP.DataSWareHou dtAchievement = new CRP.DataSWareHou();
//2、合并：
dtAchievement.Tables["DataPeiHuoDan"].Merge(dt);
ReportDocument rd = new ReportDocument();
string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Areas\\CRP\\CrystalRPeiHuo.rpt";
rd.Load(strRptPath);
rd.SetDataSource(dtAchievement); //设置报表数据源
//最后（IO 流形式）
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(stream, "application/pdf"));
}
