public override void SetAccess(FormM form, DFDictionary entity) { var ds = new DataSet(); var InstanceId = entity["InstanceId"]; var count = 0; var dtHeader = new DataTable(); dtHeader = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from sm_t_process where InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtHeader.TableName = "SM_T_PROCESS"; ds.Tables.Add(dtHeader); var dtProduct = new DataTable(); dtProduct = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from sm_t_process_product p where p.InstanceId=@InstanceId", "order by LinePosition", new { InstanceId = entity["InstanceId"] }); dtProduct.TableName = "SM_T_PROCESS_PRODUCT"; ds.Tables.Add(dtProduct); var dtCY = new DataTable(); dtCY = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from sm_t_process_cy p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtCY.TableName = "SM_T_PROCESS_CY"; ds.Tables.Add(dtCY); var dtYC = new DataTable(); dtYC = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from sm_t_process_yc p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtYC.TableName = "SM_T_PROCESS_YC"; ds.Tables.Add(dtYC); //var dtLY = new DataTable(); //dtLY = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from v_sm_t_process_ly p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); //dtLY.TableName = "v_sm_t_process_ly"; //ds.Tables.Add(dtLY); var dtQuality = new DataTable(); dtQuality = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from v_sm_t_process_quality p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtQuality.TableName = "v_sm_t_process_quality"; ds.Tables.Add(dtQuality); //var dtAQ = new DataTable(); //dtAQ = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from SM_T_PROCESS_AQ p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); //dtAQ.TableName = "SM_T_PROCESS_AQ"; //ds.Tables.Add(dtAQ); this.ReportDataSource = ds; this.ReportPath = Path.Combine(new DirectoryInfo(CurrentFolderHelper.GetCurrentFolder()).Parent.FullName, "Reports", "Process.frx"); base.SetAccess(form, entity); }
public override int Update(FormM form, DFDictionary entity, ref string message) { DataTable dt; using (var db = Pub.DB) { var currentUser = Util.GetCurrentUser(); var category = ""; var SenderCompany = ""; var ReceiverCompany = ""; var sql = @"select * from sm_t_devicedowntime d where 1=1 "; if (!string.IsNullOrWhiteSpace(entity["ProductDateFrom"])) { sql += " and d.ProductDate>=@ProductDateFrom"; } if (!string.IsNullOrWhiteSpace(entity["ProductDateTo"])) { sql += " and d.ProductDate<=@ProductDateTo"; } if (!string.IsNullOrWhiteSpace(entity["LineName"])) { sql += " and d.LineName like @LineName"; } //var sql = string.Format("exec sp_Report_Recycle @CompanyName,@PalletType,@CMonth,@Category,@SenderCompany,@ReceiverCompany"); var p = new { ProductDateFrom = entity["ProductDateFrom"], ProductDateTo = entity["ProductDateTo"], LineName = string.Format("%{0}%", entity["LineName"]) }; dt = db.ExecuteDataTable(sql, p); if (dt.Rows.Count == 0) { message = "没有数据".GetRes(); return(DFPub.EXECUTE_ERROR); } dt.TableName = "SM_T_DEVICEDOWNTIME"; var ds = new DataSet(); ds.Tables.Add(dt); this.ReportDataSource = ds; this.ReportPath = Path.Combine(new DirectoryInfo(CurrentFolderHelper.GetCurrentFolder()).Parent.FullName, "Reports", "DownTime.frx"); } return(DFPub.EXECUTE_SUCCESS); }
public override void SetAccess(FormM form, DFDictionary entity) { var ds = new DataSet(); var InstanceId = entity["InstanceId"]; var count = 0; var dtHeader = new DataTable(); dtHeader = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from sm_t_process where InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtHeader.TableName = "SM_T_PROCESS"; ds.Tables.Add(dtHeader); var dtLY = new DataTable(); dtLY = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from sm_t_process_ly p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtLY.TableName = "SM_T_PROCESS_LY"; ds.Tables.Add(dtLY); var dtLW = new DataTable(); dtLY = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from SM_T_PROCESS_LW p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtLY.TableName = "SM_T_PROCESS_LW"; ds.Tables.Add(dtLY); var dtLQF = new DataTable(); dtLY = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from SM_T_PROCESS_LQF p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtLY.TableName = "SM_T_PROCESS_LQF"; ds.Tables.Add(dtLY); var dtAQ = new DataTable(); dtAQ = base.GetList(entity, ref count, 0, Int32.MaxValue, "select * from SM_T_PROCESS_AQ p where p.InstanceId=@InstanceId", "order by InstanceId", new { InstanceId = entity["InstanceId"] }); dtAQ.TableName = "SM_T_PROCESS_AQ"; ds.Tables.Add(dtAQ); this.ReportDataSource = ds; this.ReportPath = Path.Combine(new DirectoryInfo(CurrentFolderHelper.GetCurrentFolder()).Parent.FullName, "Reports", "Process_FX.frx"); base.SetAccess(form, entity); }
public override int Update(FormM form, DFDictionary entity, ref string message) { if (string.IsNullOrWhiteSpace(entity["TableName"])) { throw new WFException("请选择流程".GetRes()); } DataTable dt; using (var db = Pub.DB) { var sql = string.Format("SELECT * FROM {0} WHERE 1=1", entity["TableName"]); //if (!string.IsNullOrWhiteSpace(entity["Requestor"])) //{ // sql += " and (申请人姓名 like @Requestor or 申请人中文姓名 like @Requestor)"; //} var p = new { //DeptId = QueryBuilder.In(ref sql, entity, "部门", "DeptId"), //InstanceStatus = QueryBuilder.In(ref sql, entity, "流程状态", "InstanceStatus"), RequestTime_From = QueryBuilder.DateFrom(ref sql, entity, "申请时间", "RequestTime_From"), RequestTime_To = QueryBuilder.DateTo(ref sql, entity, "申请时间", "RequestTime_To"), //Requestor = string.Format("%{0}%", entity["Requestor"]) }; sql += " order by 流水号 desc"; dt = db.ExecuteDataTable(sql, p); if (dt.Rows.Count == 0) { message = "没有数据".GetRes(); return(DFPub.EXECUTE_ERROR); } dt.TableName = "T1"; var ds = new DataSet(); ds.Tables.Add(dt); this.ReportDataSource = ds; this.ReportPath = Path.Combine(new DirectoryInfo(CurrentFolderHelper.GetCurrentFolder()).Parent.FullName, "Reports", "WFDataReport.frx"); } return(DFPub.EXECUTE_SUCCESS); }