public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
if (entity["action"] == "querylist")
{
vm.rows = WF_M_MENULoader.Query(entity["MenuId"]);
return(DFPub.EXECUTE_SUCCESS);
}
throw new Exception("无效的 action.GetRes()");
}
public static void GetList(DFDictionary entity, DataGridVM vm, int start, int limit, string userId, string additionalSql = "")
{
using (var db = Pub.DB)
{
var sql = @"select a.*,b.Requestor,b.RequestorName,b.RequestorProxy,b.RequestorProxyName,b.InstanceStatus,b.RequestTime
,user1.ChineseName + ISNULL('[' + user2.ChineseName + ' 代理申请]','') AS ChineseName,dept.DeptDisplayText
from WF_T_INSTANCESTEPEXECUTOR a left outer join WF_T_INSTANCE b on a.InstanceId=b.InstanceId
LEFT OUTER JOIN dbo.WF_M_USER user1 ON b.Requestor=user1.UserId
LEFT OUTER JOIN dbo.WF_M_DEPT dept ON dept.DeptId = user1.DeptId
LEFT OUTER JOIN dbo.WF_M_USER user2 ON b.RequestorProxy=user2.UserId
WHERE 1=1";
//var sql = @"select * from v_ad_mytask a where 1=1 ";
sql += " and a.ExecutorId=@UserId";
if (!string.IsNullOrWhiteSpace(entity["ExecuteStatus"]))
{
sql += " and a.ExecuteStatus in @ExecuteStatus";
}
if (!string.IsNullOrWhiteSpace(entity["InstanceId"]))
{
sql += " and a.InstanceId like @InstanceId";
}
if (!string.IsNullOrWhiteSpace(entity["ModelName"]))
{
sql += " and a.ModelName like @ModelName";
}
if (!string.IsNullOrWhiteSpace(entity["AFENumber"]))
{
sql += " and a.AFENumber like @AFENumber";
}
if (!string.IsNullOrWhiteSpace(entity["ProjectName"]))
{
sql += " and a.ProjectName like @ProjectName";
}
if (!string.IsNullOrWhiteSpace(entity["RequestorName"]))
{
sql += " and a.RequestorName like @RequestorName";
}
sql += additionalSql;
sql += " order by a.LastModifyTime desc";
var parameters = new
{
UserId = userId,
ExecuteStatus = entity["ExecuteStatus"].Split(',').ToList(),
InstanceId = string.Format("%{0}%", entity["InstanceId"]),
ModelName = string.Format("%{0}%", entity["ModelName"]),
AFENumber = string.Format("%{0}%", entity["AFENumber"].ToUpper()),
ProjectName = string.Format("%{0}%", entity["ProjectName"]),
RequestorName = string.Format("%{0}%", entity["RequestorName"])
};
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <VM_WF_T_INSTANCESTEPEXECUTOR>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
list.ForEach(a => a.InstanceStatus = a.InstanceStatus.GetRes());
vm.rows = list;
}
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
//var count = 0;
//var sql = @"select * from SM_T_PROCESS where 1=1";
//var param = new
//{
// InstanceId = QueryBuilder.Like(ref sql, entity, "InstanceId", "InstanceId")
//};
//var list = GetList(entity, ref count, start, limit, sql, "order by InstanceId", param);
//vm.results = count;
//vm.rows = list;
//return DFPub.EXECUTE_SUCCESS;
if (entity["GridId"] == "grid_product")
{
//查询生产信息
QueryGridProduct(form, entity, vm, start, limit);
}
else if (entity["GridId"] == "grid_yc")
{
//查询浴槽设定信息
QueryGridYC(form, entity, vm, start, limit);
}
else if (entity["GridId"] == "grid_quality")
{
//查询产品质量信息
QueryGridQuality(form, entity, vm, start, limit);
}
else if (entity["GridId"] == "grid_cy")
{
//查询产品质量信息
QueryGridCY(form, entity, vm, start, limit);
}
else if (entity["GridId"] == "grid_ly")
{
//查询产品质量信息
QueryGridLY(form, entity, vm, start, limit);
}
else if (entity["GridId"] == "grid_lw")
{
//查询产品质量信息
QueryGridLW(form, entity, vm, start, limit);
}
else if (entity["GridId"] == "grid_lqf")
{
//查询产品质量信息
QueryGridLQF(form, entity, vm, start, limit);
}
else if (entity["GridId"] == "grid_aq")
{
//查询产品质量信息
QueryGridAQ(form, entity, vm, start, limit);
}
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
if (entity["action"] == "querylist")
{
if (entity["subAction"] == "queryVariables")
{
var data1 = WFBusinessData.AddPrefix("WF_T_INSTANCE_", WFBusinessData.CreateInstance <WF_T_INSTANCE>(new WFInstance()));
var data2 = WFBusinessData.AddPrefix("WF_T_INSTANCESTEP_", WFBusinessData.CreateInstance <WF_T_INSTANCESTEP>(new WFInstanceStep()));
var data3 = WFBusinessData.AddPrefix("WF_T_INSTANCESTEPEXECUTOR_", WFBusinessData.CreateInstance <WF_T_INSTANCESTEPEXECUTOR>(new WF_T_INSTANCESTEPEXECUTOR()));
WFBusinessData.Merge(data2, data1);
WFBusinessData.Merge(data3, data1);
var businessData = data1;
vm.rows = businessData.Keys.OrderBy(a => a).Select(a => new WFItem()
{
text = string.Format("@{0}", a), value = string.Format("@{0}", a)
}).ToList();
return(DFPub.EXECUTE_SUCCESS);
}
else
{
var list = new List <WFItem>();
var model = WFDA.Instance.GetModelById(entity["ModelId"]);
if (model != null)
{
list.Add(new WFItem()
{
text = model.ModelName, value = string.Format("{0}", model.ModelName).Trim()
});
}
list.AddRange(WFDA.Instance.GetSteps(entity["ModelId"]).Select(a =>
new WFItem()
{
text = a.StepName, value = string.Format("{0}", a.StepName).Trim()
}).ToList());
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
using (var db = Pub.DB)
{
var sql = "select * from WF_M_STEP where 1=1";
sql += " and ModelId=@ModelId";
sql += " order by StepOrder";
var parameters = new
{
ModelId = entity["ModelId"]
};
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <VM_WF_M_STEP>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
if (entity["QueryType"] == "Signle")
{
return(QuerySignle(form, entity, vm, start, limit, ref message));
}
else if (entity["QueryType"] == "Line")
{
return(QueryLine(form, entity, vm, start, limit, ref message));
}
return(DFPub.EXECUTE_SUCCESS);
}
public DataGridVM GetTree(DFDictionary dict)
{
var vm = new DataGridVM();
var nodes = Generate(SessionHelper.Get <FormM>("f"));
var listStatus = JsonSerializeHelper.DeserializeObject <List <WFTreeNode> >(Base64StringHelper.ConvertFromBase64String(dict["DF_TREE_VIEWSTATE"]));
var list = WFTreeHelper.GenerateTree("ROOT", nodes);
// 下面这段代码就是为了处理保持客户端树的状态
WFTreeHelper.SetStatus(nodes, listStatus);
vm.rows = list;
return(vm);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
//if (IsEmptyQuery(entity))
//{
// return EmptyQuery(vm);
//}
var count = 0;
var list = WF_M_ROLE_MODELLoader.GetList(entity, ref count, start, limit);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public void SetSource(IDataGridSource source)
{
_vm = new DataGridVM(source);
DataContext = _vm;
GenerateFields(_vm.DataSource.GetTypeOfObjects(), _vm.GetFields());
//verify that the ID is avaiable
var id = source.GetIDPropertyInfo();
if (id == null)
{
throw new Exception("ID not identified!");
}
}
private DataGridVM UploadFile(HttpContext context, DFDictionary dict)
{
var vm = new DataGridVM();
try
{
int maxSize = 1024 * 1024 * 10;
if (context.Request.Files.Count == 0)
{
throw new WFException("请上传文件");
}
for (int i = 0; i < context.Request.Files.Count; i++)
{
var item = context.Request.Files[i];
if (item.InputStream == null || item.InputStream.Length > maxSize)
{
throw new WFException(string.Format("第 {0} 个上传文件大小超过限制", i + 1));
}
}
var user = Util.GetCurrentUser();
var list = new List <XDSW_T_FILE>();
for (int i = 0; i < context.Request.Files.Count; i++)
{
var item = context.Request.Files[i];
// 将文件插入到数据库中
var entity = new XDSW_T_FILE();
using (var db = Pub.DB)
{
entity.FileId = Guid.NewGuid().ToString();
entity.FileName = Path.GetFileName(item.FileName);
entity.FileData = StreamHelper.ToBytes(item.InputStream);
entity.LastModifyTime = DateTime.Now;
entity.LastModifyUser = user.UserName;
entity.CreateTime = DateTime.Now;
entity.CreateUser = user.UserName;
list.Add(entity);
db.Insert(entity);
}
}
vm.rows = list.Select(a => new { FileId = a.FileId, FileName = a.FileName }).ToList();
}
catch (Exception ex)
{
vm.hasError = true;
vm.error = ex.Message;
}
return(vm);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select * from BT_PaiGongDan where 1=1";
var param = new
{
ID = QueryBuilder.Like(ref sql, entity, "ID", "ID")
};
var list = GetList(entity, ref count, start, limit, sql, "order by ID", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select * from WF_M_MSG_TEMPLATE where 1=1";
var param = new
{
TemplateName = QueryBuilder.Like(ref sql, entity, "TemplateName", "TemplateName")
};
var list = GetList(entity, ref count, start, limit, sql, "order by TemplateName", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
using (var db = Pub.DB)
{
var sql = "select * from WF_M_MODEL where 1=1";
var parameters = new
{
};
sql += " order by ModelName";
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <VM_WF_M_MODEL>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select * from SM_M_QD where 1=1";
var param = new
{
GangHao = QueryBuilder.Like(ref sql, entity, "GangHao", "GangHao"),
QDLevel = QueryBuilder.Like(ref sql, entity, "QDLevel", "QDLevel")
};
var list = GetList(entity, ref count, start, limit, sql, "order by GangHao", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public void QueryGridCY(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit)
{
var count = 0;
var sql = "select * from v_sm_t_process_cy where 1=1";
var param = new
{
InstanceId = QueryBuilder.Like(ref sql, entity, "InstanceId", "InstanceId")
};
//从存储过程得到信息
var list = GetList(entity, ref count, start, limit, sql, "order by PKId", param);
vm.results = count;
vm.rows = list;
}
public void QueryGridProduct(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit)
{
var count = 0;
var sql = "select * from SM_T_PROCESS_PRODUCT where 1=1";
var param = new
{
InstanceId = QueryBuilder.Like(ref sql, entity, "InstanceId", "InstanceId")
};
//从存储过程得到信息
var list = GetList(entity, ref count, start, limit, sql, "order by LinePosition", param);
vm.results = count;
vm.rows = list;
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select * from v_sm_oee_bydate where 1=1";
var param = new
{
MasterDeviceName = QueryBuilder.Like(ref sql, entity, "MasterDeviceName", "MasterDeviceName"),
ProductDate = QueryBuilder.Like(ref sql, entity, "ProductDate", "ProductDate")
};
var list = GetList(entity, ref count, start, limit, sql, "order by MasterDeviceName", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public void QueryGridLY(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit)
{
var count = 0;
var sql = "select * from v_SM_T_PROCESS_LY_LOG where 1=1";
var param = new
{
InstanceId = QueryBuilder.Like(ref sql, entity, "InstanceId", "InstanceId")
};
//从存储过程得到信息
var list = GetList(entity, ref count, start, limit, sql, "order by LastModifyTime desc", param);
vm.results = count;
vm.rows = list;
}
public int QuerySignle(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = "";
var CollectMonthFrom = "";
var CollectMonthTo = "";
var str = entity["Position"].Split(',');
if (string.IsNullOrWhiteSpace(entity["CollectMonthFrom"]) && string.IsNullOrWhiteSpace(entity["CollectMonthTo"]))
{
CollectMonthFrom = DateTime.Now.AddMonths(-7).ToString("yyyy-MM");
CollectMonthTo = DateTime.Now.ToString("yyyy-MM");
sql = @"select sum(CollectValue) as CollectValue,Position,CollectMonth as CollectDate from SM_T_POWER
where Position in @Position and collectMonth>=@CollectMonthFrom
and collectMonth<=@CollectMonthTo
group by Position,CollectMonth
";
var list = GetList(entity, ref count, start, limit, sql, "order by CollectDate desc", new { Position = str.ToArray(), CollectMonthFrom = CollectMonthFrom, CollectMonthTo = CollectMonthTo });
vm.results = count;
vm.rows = list;
}
else
{
sql = @"select sum(CollectValue) as CollectValue,Position,CollectMonth as CollectDate from SM_T_POWER
where Position in @Position ";
if (!string.IsNullOrWhiteSpace(entity["CollectMonthFrom"]))
{
sql = sql + " and CollectMonth>=@CollectMonthFrom";
}
if (!string.IsNullOrWhiteSpace(entity["CollectMonthTo"]))
{
sql = sql + " and CollectMonth<=@CollectMonthTo ";
}
sql = sql + " group by Position,CollectMonth ";
var list = GetList(entity, ref count, start, limit, sql, "order by CollectDate desc", new { Position = str.ToArray(), CollectMonthFrom = entity["CollectMonthFrom"], CollectMonthTo = entity["CollectMonthTo"] });
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var path = DFPub.RelativeToPhysical(entity["ConfigFile"]);
var configs = GetTableConfig(path);
var t = configs.FirstOrDefault(a => a.TableName == entity["TableName"]);
var list = new List <VM_ColumnMetadata>();
if (t != null)
{
list = t.Columns;
}
vm.results = list.Count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select * from SM_M_PLC where 1=1";
var param = new
{
Line = QueryBuilder.Like(ref sql, entity, "Line", "Line"),
Station = QueryBuilder.Like(ref sql, entity, "Station", "Station"),
ParamName = QueryBuilder.Like(ref sql, entity, "ParamName", "ParamName")
};
var list = GetList(entity, ref count, start, limit, sql, "order by Line", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select * from SM_T_SOP where 1=1";
var param = new
{
SOPName = QueryBuilder.Like(ref sql, entity, "SOPName", "SOPName"),
SOPCode = QueryBuilder.Like(ref sql, entity, "SOPCode", "SOPCode"),
SOPUser = QueryBuilder.Like(ref sql, entity, "SOPUser", "SOPUser"),
};
var list = GetList(entity, ref count, start, limit, sql, "order by SOPName", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select p.* from wf_t_instance i left join sm_t_process p on i.instanceid=p.instanceid where 1=1
and i.instancestatus='Finished' and p.processstatus='INFLOW'";
var param = new
{
InstanceId = QueryBuilder.Like(ref sql, entity, "p.InstanceId", "InstanceId")
};
//从存储过程得到信息
var list = GetList(entity, ref count, start, limit, sql, "order by InstanceId", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var currentUser = Util.GetCurrentUser();
if (!string.IsNullOrWhiteSpace(entity["MsgId"]))
{
MsgCenter.MarkRead(new List <string>()
{
entity["MsgId"]
}, currentUser.UserName);
MsgCenter.RefreshUserMessage(currentUser.UserId);
return(EmptyQuery(vm));
}
using (var db = Pub.DB)
{
var sql = "select * from WF_T_MSG where 1=1";
sql += " and UserId=@UserId";
if (!string.IsNullOrWhiteSpace(entity["IsRead"]))
{
sql += " and IsRead=@IsRead";
}
if (!string.IsNullOrWhiteSpace(entity["CreateTimeFrom"]))
{
sql += " and CreateTime>=@CreateTimeFrom";
}
if (!string.IsNullOrWhiteSpace(entity["CreateTimeTo"]))
{
sql += " and CreateTime<=@CreateTimeTo";
}
sql += " order by CreateTime desc";
var parameters = new
{
UserId = currentUser.UserId,
IsRead = ParseHelper.ParseInt(entity["IsRead"]).GetValueOrDefault(),
CreateTimeFrom = ParseHelper.ParseDate(entity["CreateTimeFrom"]).GetValueOrDefault(),
CreateTimeTo = ParseHelper.ParseDate(entity["CreateTimeTo"]).GetValueOrDefault().AddDays(1).AddSeconds(-1),
};
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <VM_WF_T_MSG>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = "";
if (string.IsNullOrWhiteSpace(entity["CollectMonthFrom"]) && string.IsNullOrWhiteSpace(entity["CollectMonthTo"]))
{
var CollectMonthFrom = DateTime.Now.AddMonths(-7).ToString("yyyy-MM");
//var MonthFrom = DateTime.Now.AddMonths(-7).Month;
var CollectMonthTo = DateTime.Now.ToString("yyyy-MM");
var MonthTo = DateTime.Now.Month;
sql = @"select TotalValue,Line, CollectDate
from v_sm_t_energy_month where Category = @Category
and CollectDate>=@CollectMonthFrom and CollectDate<=@CollectMonthTo ";
var list = GetList(entity, ref count, start, limit, sql, "order by CollectDate desc", new { Category = entity["Category"], CollectMonthFrom = CollectMonthFrom, CollectMonthTo = CollectMonthTo });
vm.results = count;
vm.rows = list;
}
else
{
sql = @"select TotalValue,Line,CollectDate from v_sm_t_energy_month
where Category = @Category ";
if (!string.IsNullOrWhiteSpace(entity["CollectMonthFrom"]))
{
sql = sql + " and CollectDate>=@CollectMonthFrom ";
}
if (!string.IsNullOrWhiteSpace(entity["CollectMonthTo"]))
{
sql = sql + " and CollectDate<=@CollectMonthTo ";
}
var list = GetList(entity, ref count, start, limit, sql, "order by collectdate desc", new { Category = entity["Category"], CollectMonthFrom = entity["CollectMonthFrom"], CollectMonthTo = entity["CollectMonthTo"] });
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var subAction = entity["subAction"];
if (entity["action"] == "querylist")
{
if (subAction == "QueryMenu")
{
// 客户端在载入的时候调用树的数据源
vm.rows = QueryModuleTree(entity);
}
else if (subAction == "QueryDept")
{
vm.rows = QueryDeptTree(entity);
}
}
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = @"select p.*,(case when p.ProcessStatus='INFLOW' then N'使用中' when p.ProcessStatus='RECOVER' then N'回收' else '' end ) as ProcessStatusText from SM_T_PROCESS p
left join WF_T_INSTANCE i on i.InstanceId=p.InstanceId
where i.InstanceStatus ='Finished' ";
var param = new
{
ProcessName = QueryBuilder.Like(ref sql, entity, "ProcessName", "ProcessName"),
InstanceId = QueryBuilder.Like(ref sql, entity, "InstanceId", "InstanceId"),
//ProcessStauts = QueryBuilder.Like(ref sql, entity, "ProcessStauts", "ProcessStauts")
};
var list = GetList(entity, ref count, start, limit, sql, "order by InstanceId", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
/*基本查询语句*/
var sql = @"select * from WF_T_LOG where 1=1";
/*查询条件*/
if (!string.IsNullOrWhiteSpace(entity["FuncModule"]))
{
sql += " and FuncModule like @FuncModule";
}
if (!string.IsNullOrWhiteSpace(entity["LogLevel"]))
{
sql += " and LogLevel like @LogLevel";
}
if (!string.IsNullOrWhiteSpace(entity["UserName"]))
{
sql += " and UserName like @UserName";
}
if (!string.IsNullOrWhiteSpace(entity["CreateTimeFrom"])) // 日志时间从
{
sql += " and CreateTime>=@CreateTimeFrom";
}
if (!string.IsNullOrWhiteSpace(entity["CreateTimeTo"])) // 日志时间到
{
sql += " and CreateTime<=@CreateTimeTo";
}
sql += " order by CreateTime desc";
using (var db = Pub.DB)
{
var parameters = new
{
FuncModule = string.Format("%{0}%", entity["FuncModule"]),
UserName = string.Format("%{0}%", entity["UserName"]),
LogLevel = string.Format("%{0}%", entity["LogLevel"]),
CreateTimeFrom = ParseHelper.ParseDate(entity["CreateTimeFrom"]).GetValueOrDefault(),
CreateTimeTo = ParseHelper.ParseDate(entity["CreateTimeTo"]).GetValueOrDefault().AddDays(1).AddSeconds(-1),
};
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <WF_T_LOG>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
using (var db = Pub.DB)
{
var sql = "select * from WF_M_STEPEXECUTOR where 1=1";
sql += " and ModelId=@ModelId and StepId=@StepId";
sql += " order by ExecutorPriority";
var parameters = new
{
ModelId = entity["ModelId"],
StepId = entity["StepId"]
};
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <VM_WF_M_STEPEXECUTOR>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
using (var db = Pub.DB)
{
var sql = @"select a.*,b.Requestor,b.RequestorName,b.RequestorProxy,b.RequestorProxyName,b.InstanceStatus,b.RequestTime
from WF_T_INSTANCESTEPEXECUTOR a left outer join WF_T_INSTANCE b on a.InstanceId=b.InstanceId where 1=1";
//var sql = @"select * from v_ad_alltask a where 1=1 ";
if (!string.IsNullOrWhiteSpace(entity["ExecuteStatus"]))
{
sql += " and a.ExecuteStatus in @ExecuteStatus";
}
if (!string.IsNullOrWhiteSpace(entity["InstanceId"]))
{
sql += " and a.InstanceId like @InstanceId";
}
if (!string.IsNullOrWhiteSpace(entity["ModelName"]))
{
sql += " and a.ModelName like @ModelName";
}
if (!string.IsNullOrWhiteSpace(entity["AFENumber"]))
{
sql += " and a.AFENumber like @AFENumber";
}
if (!string.IsNullOrWhiteSpace(entity["ProjectName"]))
{
sql += " and a.ProjectName like @ProjectName";
}
sql += " order by a.LastModifyTime desc";
var parameters = new
{
ExecuteStatus = entity["ExecuteStatus"].Split(',').ToList(),
InstanceId = string.Format("%{0}%", entity["InstanceId"]),
ModelName = string.Format("%{0}%", entity["ModelName"]),
AFENumber = string.Format("%{0}%", entity["AFENumber"].ToUpper()),
ProjectName = string.Format("%{0}%", entity["ProjectName"]),
};
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <VM_WF_T_INSTANCESTEPEXECUTOR>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
public int QueryLine(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
var count = 0;
var sql = "";
var str = entity["Line"].Split(',');
if (string.IsNullOrWhiteSpace(entity["CollectYearFrom"]) && string.IsNullOrWhiteSpace(entity["CollectYearTo"]))
{
sql = @"select sum(CollectValue) as CollectValue,Line as Position,CollectYear as CollectDate from SM_T_POWER
where Line in @Line and CollectYear>=convert(nvarchar(4), getdate(), 120) - 7
group by Line,CollectYear
";
var list = GetList(entity, ref count, start, limit, sql, "order by CollectDate desc", new { Line = str.ToArray() });
vm.results = count;
vm.rows = list;
}
else
{
sql = @"select sum(CollectValue) as CollectValue,Line as Position,CollectYear as CollectDate from SM_T_POWER
where Line in @Line ";
if (!string.IsNullOrWhiteSpace(entity["CollectYearFrom"]))
{
sql = sql + " and CollectYear>=@CollectYearFrom ";
}
if (!string.IsNullOrWhiteSpace(entity["CollectYearTo"]))
{
sql = sql + " and CollectYear<=@CollectYearTo ";
}
sql = sql + " group by Line,CollectYear ";
var list = GetList(entity, ref count, start, limit, sql, "order by CollectDate desc", new { Line = str.ToArray(), CollectYearFrom = entity["CollectYearFrom"], CollectYearTo = entity["CollectYearTo"] });
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
return(DFPub.EXECUTE_SUCCESS);
}
