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 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 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 override int Delete(FormM form, DFDictionary entity, ref string message)
{
var data = JsonSerializeHelper.DeserializeObject <List <Dictionary <string, string> > >(entity["data"]);
if (data == null)
{
throw new WFException("无效的参数data".GetRes());
}
WF_M_ROLE_MODELLoader.Delete(data.Select(a => new WF_M_ROLE_MODEL()
{
ModelId = a["ModelId"], RoleId = a["RoleId"]
}).ToList());
message = "删除成功".GetRes();
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_DEFECT where 1=1";
var param = new
{
DefectCode = QueryBuilder.Like(ref sql, entity, "DefectCode", "DefectCode"),
DefectName = QueryBuilder.Like(ref sql, entity, "DefectName", "DefectName")
};
var list = GetList(entity, ref count, start, limit, sql, "order by DefectCode", param);
vm.results = count;
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
public override int Update(FormM form, DFDictionary entity, ref string message)
{
CheckInput(form, entity);
var InstanceStepExecutorId = entity["InstanceStepExecutorId"];
var actionName = DFPub.UrlDecode(entity["actionName"]);
var user = Util.GetCurrentUser();
var ExecuteComment = entity["ExecuteComment"];
var ExecuteResult = actionName;
var list = base.GetGridClientData <VM_WF_M_USER>(entity);
new StateEngineHelper().TransferOrAdditional(InstanceStepExecutorId, list, ExecuteComment, ExecuteResult, user.UserName);
base.WriteScript(string.Format("alert('{0}成功，本窗口将自动关闭！');window.top.close();".GetRes(), actionName), ref message);
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 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);
}
/// <summary>
/// 保存到xml中
/// </summary>
/// <param name="form"></param>
/// <param name="entity"></param>
/// <param name="message"></param>
/// <returns></returns>
private int btnSave(FormM form, DFDictionary entity, ref string message)
{
var list = GetGridClientData <VM_ColumnMetadata>(entity);
var tableName = entity["TableName"];
var xmlFileName = entity["XmlFileName"];
ArgumentCheck.CheckMustInput(entity, "XmlFileName");
Save(xmlFileName, tableName, list);
// 更新界面上的配置文件下拉框,因为如果新增的话,就多了一个xml
SetSelectDataSource(form, "ConfigFile",
Directory.GetFiles(GetImportConfigXmlPath(string.Empty), "*.xml")
.Select(a => new DFSelectItem(Path.GetFileNameWithoutExtension(a), DFPub.PhysicalToRelative(a))).ToList());
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 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);
}
private List <WFTreeNode> Generate(FormM f)
{
var nodes = new List <WFTreeNode>();
var root = new WFTreeNode()
{
id = "ROOT", pid = string.Empty, text = f.FormName
};
nodes.Add(root);
for (int p = 0; p < f.Panels.Count; p++)
{
var panel = f.Panels[p];
var panelNode = new WFTreeNode()
{
id = string.Format("Panel|{0}", p), pid = root.id, text = panel.PanelType
};
nodes.Add(panelNode);
for (int r = 0; r < panel.Rows.Count; r++)
{
var rowNode = new WFTreeNode()
{
id = string.Format("{0}|Row|{1}", panelNode.id, r), pid = panelNode.id, text = "Row"
};
nodes.Add(rowNode);
for (int c1 = 0; c1 < panel.Rows[r].Controls.Count; c1++)
{
var control = panel.Rows[r].Controls[c1];
var controlNode = new WFTreeNode()
{
id = string.Format("{0}|Control|{1}", rowNode.id, c1), pid = rowNode.id, text = string.Format("{0}{1}", control.Name, control.Text)
};
nodes.Add(controlNode);
}
}
for (int c2 = 0; c2 < panel.Columns.Count; c2++)
{
var column = panel.Columns[c2];
var columnNode = new WFTreeNode()
{
id = string.Format("{0}|Column|{1}", panelNode.id, c2), pid = panelNode.id, text = string.Format("{0}{1}", column.Name, column.Text)
};
nodes.Add(columnNode);
}
}
return(nodes);
}
public override DFDictionary Get(FormM form, DFDictionary entity, ref string message)
{
var dict = new DFDictionary();
if (!string.IsNullOrWhiteSpace(entity["InstanceStepExecutorId"]))
{
using (var db = Pub.DB)
{
var sql = @"select a.*,c.DFFormName from WF_T_INSTANCESTEPEXECUTOR a
left outer join WF_T_INSTANCE b on a.InstanceId=b.InstanceId
left outer join WF_M_MODEL c on b.ModelId=c.ModelId where 1=1";
sql += " and a.InstanceStepExecutorId=@InstanceStepExecutorId";
var parameters = new
{
InstanceStepExecutorId = entity["InstanceStepExecutorId"]
};
var item = db.Query <VM_WF_T_INSTANCESTEPEXECUTOR>(sql, parameters).FirstOrDefault();
if (item != null)
{
dict = DFDictionary.Create <VM_WF_T_INSTANCESTEPEXECUTOR>(item);
}
}
}
else if (!string.IsNullOrWhiteSpace(entity["InstanceId"]))
{
using (var db = Pub.DB)
{
var sql = @"select a.*,b.DFFormName from WF_T_INSTANCE a
left outer join WF_M_MODEL b on a.ModelId=b.ModelId where 1=1";
sql += " and a.InstanceId=@InstanceId";
var parameters = new
{
InstanceId = entity["InstanceId"]
};
var item = db.Query <VM_WF_T_INSTANCE>(sql, parameters).FirstOrDefault();
if (item != null)
{
dict = DFDictionary.Create <VM_WF_T_INSTANCE>(item);
}
}
}
else
{
throw new Exception("无效的参数，必须提供 InstanceStepExecutorId 或者 InstanceId".GetRes());
}
return(dict);
}
public override DFDictionary Get(FormM form, DFDictionary entity, ref string message)
{
if (string.IsNullOrWhiteSpace(entity["ModelId"]))
{
throw new Exception("缺少参数 ModelId".GetRes());
}
var engine = NinjectHelper.Get <IEngine>();
if (engine == null)
{
throw new Exception("找不到 IEngine".GetRes());
}
var user = Util.GetCurrentUser();
var instanceId = Pub.GetNextIdFromDB("T", DateTime.Now.ToString("yyyyMMdd"), string.Empty, 4);
var Requestor = user.UserId;
var RequestorName = user.UserName;
var RequestorProxy = string.Empty;
var RequestorProxyName = string.Empty;
// 开始工作流
engine.StartDBWF(entity["ModelId"], instanceId, Requestor, RequestorProxy, RequestorName,
RequestorProxyName, DateTime.Now, true, user.UserId, user.UserName);
var dict = new DFDictionary();
if (!string.IsNullOrWhiteSpace(entity["ModelId"]))
{
using (var db = Pub.DB)
{
var sql = "select * from WF_T_INSTANCE where 1=1";
sql += " and InstanceId=@InstanceId";
var parameters = new
{
InstanceId = instanceId
};
var item = db.Query <WF_T_INSTANCE>(sql, parameters).FirstOrDefault();
if (item != null)
{
dict = DFDictionary.Create <WF_T_INSTANCE>(item);
}
}
}
return(dict);
}
public override void SetAccess(FormM form, DFDictionary entity)
{
var tableName = entity["TableName"];
List <VM_ColumnMetadata> list = null;
// 如果是客户端点击查询按钮，或者回传回的数据没有客户端数据
IDBHelper dbHelper;
using (var db = Pub.DB)
{
dbHelper = DBHelper.GetDBHelper(db);
}
list = dbHelper.LoadColumns(tableName);
SetSelectDataSource(form, "GetValueList", list.Select(a => new DFSelectItem(a.ColumnText + " " + a.ColumnName, a.ColumnName)).ToList(), true);
base.SetAccess(form, entity);
}
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 Delete(FormM form, DFDictionary entity, ref string message)
{
var data = JsonSerializeHelper.DeserializeObject <List <Dictionary <string, string> > >(entity["data"]);
if (data == null)
{
throw new WFException("无效的参数 data".GetRes());
}
using (var db = Pub.DB)
{
var sql = "delete from WF_M_STEPEXECUTOR where ExecutorId=@ExecutorId";
db.Execute(sql, data.Select(a => new { ExecutorId = a["ExecutorId"] }));
}
message = "删除成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
public override int Update(FormM form, DFDictionary entity, ref string message)
{
if (GetSubmitButton(entity) == "btnCopy")
{
return(btnCopy(form, entity, ref message));
}
else if (GetSubmitButton(entity) == "btnUp")
{
return(btnUp(form, entity, ref message));
}
else if (GetSubmitButton(entity) == "btnDown")
{
return(btnDown(form, entity, ref message));
}
return(DFPub.EXECUTE_SUCCESS);
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
using (var db = Pub.DB)
{
if (string.IsNullOrWhiteSpace(entity["ExecutorValue"]))
{
throw new WFException("请选择用户".GetRes());
}
var newEntity = entity.To <WF_M_STEPEXECUTOR>();
newEntity.ExecutorId = Guid.NewGuid().ToString();
newEntity.ExecutorPriority = ParseHelper.ParseInt(entity["ExecutorPriority"]);
db.Insert <WF_M_STEPEXECUTOR>(newEntity);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Update(FormM form, DFDictionary entity, ref string message)
{
var InstanceStepExecutorId = entity["InstanceStepExecutorId"];
var actionName = DFPub.UrlDecode(entity["actionName"]);
var user = Util.GetCurrentUser();
var ExecuteComment = entity["ExecuteComment"];
var ExecuteResult = actionName;
var ToStepId = entity["NextStep"];
var CurrentUserId = user.UserId;
var CurrentUserName = user.UserName;
new StateEngineHelper().Goto(InstanceStepExecutorId, ExecuteComment, ExecuteResult, ToStepId, CurrentUserId, CurrentUserName);
base.WriteScript(string.Format("alert('{0}成功，本窗口将自动关闭！');window.top.close();", actionName), ref message);
return(DFPub.EXECUTE_SUCCESS);
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
try
{
if (string.IsNullOrWhiteSpace(entity["ResId"]))
{
throw new Exception("资源编号".GetRes());
}
var currentUser = Util.GetCurrentUser();
var dict = new DFDictionary();
/*基本查询语句*/
var sql = "select * from WF_M_RES where 1=1";
/*查询条件*/
sql += " and ResId=@ResId";
using (var db = Pub.DB)
{
var parameters = new { ResId = entity["ResId"] };
var oldEntity = db.Query <WF_M_RES>(sql, parameters).FirstOrDefault();
if (oldEntity != null)
{
message = "记录已经存在".GetRes();
return(DFPub.EXECUTE_ERROR);
}
var newEntity = entity.To <WF_M_RES>();
newEntity.ResId = entity["ResId"];
newEntity.English = entity["English"];
newEntity.ChineseSimplified = entity["ChineseSimplified"];
newEntity.ChineseTraditional = entity["ChineseTraditional"];
newEntity.CreateUser = currentUser.UserName;
newEntity.CreateTime = DateTime.Now;
newEntity.LastModifyUser = currentUser.UserName;
newEntity.LastModifyTime = DateTime.Now;
db.Insert(newEntity);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
}
catch (Exception ex)
{
message = ex.Message;
return(DFPub.EXECUTE_ERROR);
}
}
public override int Update(FormM form, DFDictionary entity, ref string message)
{
if (entity["EditMode"] != "Edit")
{
return(Insert(form, entity, ref message));
}
try
{
if (string.IsNullOrWhiteSpace(entity["MenuId"]))
{
throw new Exception("请传入 MenuId 参数".GetRes());
}
if (string.IsNullOrWhiteSpace(entity["ModuleId"]))
{
throw new Exception("请选择对应的模块".GetRes());
}
if (string.IsNullOrWhiteSpace(entity["PMenuId"]))
{
throw new Exception("请选择父菜单".GetRes());
}
var oldEntity = WF_M_MENULoader.Query(entity["MenuId"]).FirstOrDefault();
if (oldEntity == null)
{
throw new Exception("找不到要更新的记录".GetRes());
}
// 先将数据库查出来的老的实体转成字典，然后把客户端传过来的字典合并进去，这样就实现了数据的更新
var newEntity = DFDictionary.Create <WF_M_MENU>(oldEntity).Merge(entity).To <WF_M_MENU>();
var user = Util.GetCurrentUser();
var parent = WF_M_MENULoader.Query(entity["PMenuId"]).FirstOrDefault();
var siblings = WF_M_MENULoader.Query(null, parent.MenuLabel).ToList();
newEntity.MenuLabel = LabelHelper.GetNextLabelUsingSubLabelList(parent.MenuLabel, siblings.Select(a => a.MenuLabel).ToList());
newEntity.LastModifyTime = DateTime.Now;
newEntity.LastModifyUser = user.UserName;
newEntity.Expanded = ParseHelper.ParseInt(entity["Expanded"]);
WF_M_MENULoader.Update(newEntity);
message = "保存成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
catch (Exception ex)
{
message = ex.Message;
return(DFPub.EXECUTE_ERROR);
}
}
public override void SetAccess(FormM form, DFDictionary entity)
{
// 编辑的时候 CodeType CodeName 是不能修改的
if (entity["EditMode"] == "Edit")
{
var c = form.GetControlM("CodeType");
if (null != c)
{
c.Readonly = true;
}
c = form.GetControlM("CodeName");
if (null != c)
{
c.Readonly = true;
}
}
}
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 void SetAccess(FormM form, DFDictionary entity)
{
base.SetAccess(form, entity);
// 检查按钮权限
form.GetControlM("btnDelete").Visible = false;
form.GetControlM("btnCancelWorkflow").Visible = false;
var user = Util.GetCurrentUser();
if (AuthLoader.CheckFunctionAccess("WFCore_AllWF.btnDelete", user.UserId))
{
form.GetControlM("btnDelete").Visible = true;
}
if (AuthLoader.CheckFunctionAccess("WFCore_AllWF.btnCancelWorkflow", user.UserId))
{
form.GetControlM("btnCancelWorkflow").Visible = true;
}
}
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_BASICVALUE where 1=1";
var param = new
{
LineName = QueryBuilder.Like(ref sql, entity, "LineName", "LineName"),
Station = QueryBuilder.Like(ref sql, entity, "LineName", "LineName"),
SubStation = QueryBuilder.Like(ref sql, entity, "LineName", "LineName"),
Category = QueryBuilder.Like(ref sql, entity, "LineName", "LineName")
};
var list = GetList(entity, ref count, start, limit, sql, "order by LineName", 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);
}
}
private void buttonlog_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Projects\VULCAN_TOP_CASINO\VULCAN_TOP_CASINO\Database1.mdf;Integrated Security=True;"))
{
try
{
con.Open();
String str1 = "select * from users where email='" + textBox1.Text + "' and pass='******'";
SqlCommand cmd = new SqlCommand(str1, con);
SqlDataAdapter da = new SqlDataAdapter(str1, con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
MessageBox.Show("hi " + dr["name"].ToString() + " thank you for using this app");
// new form
Class1.Login = true;
Class1.Id = Convert.ToInt32(dr["id"]);
Class1.Name = dr["name"].ToString();
Class1.Email = dr["email"].ToString();
Class1.Money = Convert.ToDouble(dr["money"]);
FormM frM = new FormM();
frM.Show();
// new form
}
}
else
{
Class1.Login = false;
MessageBox.Show("login failed");
}
}
catch
{
con.Close();
}
this.Close();
}
}
