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