private static string AddPeople()
{
string strReturn;
string userName = NetSchool.Common.Library.GetPostBack.GetPostBackStr("userName");
string realName = NetSchool.Common.Library.GetPostBack.GetPostBackStr("realName");
if ("" == userName)
{
strReturn = JsonConvert.SerializeObject(new { state = "error", msg = "获取用户名失败" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
if ("" == realName)
{
strReturn = JsonConvert.SerializeObject(new { state = "error", msg = "没有填写姓名" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
if (NetSchool.BLL.People.Exists(userName))
{
strReturn = JsonConvert.SerializeObject(new { state = "error", msg = "该用户名已存在，不可重复使用" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
NetSchool.Model.People peopleInfo = new Model.People();
peopleInfo.UserName = userName;
peopleInfo.RealName = realName;
peopleInfo.TelePhone = NetSchool.Common.Library.GetPostBack.GetPostBackStr("telephone");
peopleInfo.Email = NetSchool.Common.Library.GetPostBack.GetPostBackStr("Email");
peopleInfo.Permission = NetSchool.Common.Library.GetPostBack.GetPostBackStr("permission");
peopleInfo.Password = Common.EnDeCryption.Base64.Encode(Common.EnDeCryption.JCode.Encode("123456"));//Common.EnDeCryption.
if (NetSchool.BLL.People.Add(peopleInfo))
{
strReturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
strReturn = JsonConvert.SerializeObject(new { state = "error", msg = "添加失败" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
}
}
}
return(strReturn);
}
public static Model.People DataRowToModel(DataRow Rows)
{
Model.People model = new Model.People();
if (Rows["UserName"] != DBNull.Value)
{
model.UserName = (string)Rows["UserName"];
}
if (Rows["RealName"] != DBNull.Value)
{
model.RealName = (string)Rows["RealName"];
}
if (Rows["TelePhone"] != DBNull.Value)
{
model.TelePhone = (string)Rows["TelePhone"];
}
if (Rows["Email"] != DBNull.Value)
{
model.Email = (string)Rows["Email"];
}
if (Rows["Permission"] != DBNull.Value)
{
model.Permission = (string)Rows["Permission"];
}
if (Rows["Password"] != DBNull.Value)
{
model.Password = (string)Rows["Password"];
}
return(model);
}
private static void AddLoginState(Model.People user)
{
var Session = HttpContext.Current.Session;
Session.Timeout = 1441;
Session["Username"] = user.UserName;
Session["Realname"] = user.RealName;
Session["Permissions"] = user.Permission;
Session["LoginTime"] = DateTime.Now;
}
public Lift(int n, Model.Level le, Model.People pe, Model.Statistics s)
{
l = le; p = pe; sta = s;
numLevel = n;
for (int i = 0; i < numLevel; i++)
{
indicStat[i] = false;
}
TimerCallback tm = new TimerCallback(Move);
Timer timer = new Timer(tm, null, 1000, 1000);
}
public MLift(int n, Level le, People pe, Statistics s)
{
l = le; p = pe; sta = s;
numLevel = n;
indicStat = new bool[numLevel];
for (int i = 0; i < numLevel; i++)
{
indicStat[i] = false;
}
TimerCallback tm = new TimerCallback(Move);
Timer timer = new Timer(tm, null, 1000, 1000);
}
private static string UserCheck(string username, string password, out Model.People user)
{
user = null;
if (string.IsNullOrWhiteSpace(username))
{
return("用户名不能为空");
}
if (string.IsNullOrWhiteSpace(password))
{
return("密码不能为空");
}
user = BLL.People.GetModel(username);
if (user == null)
{
return("用户不存在！");
}
if (user.Password != Common.EnDeCryption.Base64.Encode(Common.EnDeCryption.JCode.Encode(password)))
{
return("用户密码错误！");
}
return("ok");
}
public static bool Update(Model.People model)
{
return(dal.Update(model));
}
public static bool Add(Model.People model)
{
return(dal.Add(model));
}
public bool Update(Model.People model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(updatesql, GetModelPare(model)) > 0);
}
public bool Add(Model.People model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(insertsql, GetModelPare(model)) > 0);
}
public static SqlParameter[] GetModelPare(Model.People model)
{
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@RealName", SqlDbType.NVarChar, 20),
new SqlParameter("@Telephone", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 20),
new SqlParameter("@Permission", SqlDbType.NVarChar, 10),
new SqlParameter("@Password", SqlDbType.NVarChar, 100)
};
#region
if (string.IsNullOrWhiteSpace(model.UserName))
{
parameters[0].Value = DBNull.Value;
}
else
{
parameters[0].Value = model.UserName;
}
if (string.IsNullOrWhiteSpace(model.RealName))
{
parameters[1].Value = DBNull.Value;
}
else
{
parameters[1].Value = model.RealName;
}
if (string.IsNullOrWhiteSpace(model.TelePhone))
{
parameters[2].Value = DBNull.Value;
}
else
{
parameters[2].Value = model.TelePhone;
}
if (string.IsNullOrWhiteSpace(model.Email))
{
parameters[3].Value = DBNull.Value;
}
else
{
parameters[3].Value = model.Email;
}
if (string.IsNullOrWhiteSpace(model.Permission))
{
parameters[4].Value = DBNull.Value;
}
else
{
parameters[4].Value = model.Permission;
}
if (string.IsNullOrWhiteSpace(model.Password))
{
parameters[5].Value = DBNull.Value;
}
else
{
parameters[5].Value = model.Password;
}
#endregion
return(parameters);
}
