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(); } }