public IMenu GetMenu(Model.Table.User u) { Esunnet.Model.Frame.IMenu m = new Esunnet.Model.Frame.Dhtmlx.Menu.Menu(); UP_GetMenu us = new UP_GetMenu(u.id, u.permission); using (DbClinet db = new DbClinet()) { List <Dictionary <string, object> > mv = db.Select(us); for (int i = 0; i < mv.Count; i++) { Node n = new Node(); n.id = mv[i]["id"]; n.pid = mv[i]["pid"]; n.text = mv[i]["text"] as string; n.title = mv[i]["title"] as string; n.type = "node"; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add(C.FUN, mv[i]["function"] as string); dic.Add(C.PATH, mv[i]["path"] as string); dic.Add(C.PARAM, mv[i]["remark"] as string); n.userdata = dic; m.Add(n); } } return(m); }
public User Login(Model.Table.User u) { String pw = u.userPassword; u.userId = "admin"; // u.userPassword = "******"; using (DbClinet db = new DbClinet()) { db.AddParameter("@userId", u.userId); List <Dictionary <string, object> > mv = db.Select("select * from SYS_User where userId=@userId"); if (mv.Count > 0) { string userPasswordTemp = mv.FirstOrDefault()["userPassword"] as string; if (userPasswordTemp.Equals(u.userPassword, StringComparison.OrdinalIgnoreCase)) { //u.lastLoginIp = mv.FirstOrDefault()["lastLoginIp"] as string; u.State = 1; db.AddParameter("@userId", u.userId); db.AddParameter("@ip", u.lastLoginIp); db.ExecuteNonQuery("update SYS_User set lastLoginTime=GETDATE(),lastLoginIp=@ip where userId=@userId"); } else { //密码错误 u.State = -1; } } else { u.State = -2; //不存在用户 } } return(u); }
public bool UpdatePassword(Model.Table.User u) { using (DbClinet db = new DbClinet()) { db.AddParameter("@userPassword", u.userPassword); db.AddParameter("@userId", u.userId); db.ExecuteNonQuery("update SYS_User set userPassword=@userPassword where userId=@userId"); return(true); } }
public void ExecProc(Sbw.DbClinet.Proc proc) { using (DbClinet Clinet = new DbClinet()) { DbDataReader dr = Clinet.ExecuteReader(proc); Row r; List <object> data; Dictionary <string, object> ud = null; while (dr.Read()) { r = new Row(); data = new List <object>(); if (SwitchData != null) { ud = new Dictionary <string, object>(); r.id = dr[SwitchData.Id]; for (int i = 0; i < dr.FieldCount; i++) { ud.Add(dr.GetName(i), dr.GetValue(i)); } for (int i = 0; i < SwitchData.Data.Length; i++) { Match m = Regex.Match(SwitchData.Data[i], "(.{0,})\\[(.{0,})\\]"); if (m.Success) { if ("".Equals(m.Groups[1].Value)) { data.Add(SwitchData.SwitchData(m.Groups[2].Value, ud)); } else { data.Add(SwitchData.SwitchData(m.Groups[2].Value, dr[m.Groups[1].Value])); } } else { data.Add(dr[SwitchData.Data[i]]); } } } else { r.id = dr.GetValue(0); for (int i = 1 - proc.type; i < dr.FieldCount; i++) { data.Add(dr.GetValue(i)); } } r.data = data; r.userdata = ud; rows.Add(r); } if (proc.type == 0 && dr.NextResult() && dr.Read()) { this.total_count = dr.GetInt32(0); } if (dr.NextResult() && dr.Read()) { List <string> l = new List <string>(); for (int i = 0; i < dr.FieldCount; i++) { l.Add(dr.GetName(i)); } if (l.Contains("Header")) { this.Header = dr["Header"] as string; } if (l.Contains("ColAlign")) { this.ColAlign = dr["ColAlign"] as string; } if (l.Contains("ColTypes")) { this.ColTypes = dr["ColTypes"] as string; } if (l.Contains("ColSorting")) { this.ColSorting = dr["ColSorting"] as string; } if (l.Contains("Width")) { this.Width = dr["Width"] as string; } } else if (SwitchData != null) { this.Header = SwitchData.Header; this.ColAlign = SwitchData.ColAlign; this.ColTypes = SwitchData.ColTypes; this.ColSorting = SwitchData.ColSorting; this.Width = SwitchData.Width; } dr.Close(); } }