public ActionResult Login(string IsCheck, string username, string password)
{
if (IsCheck == "on")
{
RemPassWord = 24;
}
// 身份认证
LumluxSSYDB.Model.tUserInfoes ui = new LumluxSSYDB.Model.tUserInfoes();
LumluxSSYDB.BLL.tUserInfoes uiBll = new LumluxSSYDB.BLL.tUserInfoes();
string passwordMD5 = LumluxSSYDB.DBUtility.Utility.MD5(password);
if (uiBll.ExistsUserByPassword(username, passwordMD5))
{
ui = uiBll.GetUserMode(username, passwordMD5);
this.UserName = ui.sUserName;
this.UserID = ui.sGUID;
this.PrjGUID = ui.sPrjectInfoGUID;
this.UserAuthority = ui.iAuthorityGUID;
return(RedirectToAction("index", "Main", new { Area = "Lamp" }));
}
else
{
ViewBag.IsError = true;
ModelState.AddModelError("error", "用户名或密码错误");
return(View());
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LumluxSSYDB.Model.tUserInfoes GetUserMode(string UIName, string UIPassword)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tUserInfoes ");
strSql.Append(" where sUserName=@UIName and sPassWord=@UIPassword ");
SqlParameter[] parameters =
{
new SqlParameter("@UIName", SqlDbType.NVarChar, 50),
new SqlParameter("@UIPassword", SqlDbType.NVarChar, 50)
};
parameters[0].Value = UIName;
parameters[1].Value = UIPassword;
LumluxSSYDB.Model.tUserInfoes model = new LumluxSSYDB.Model.tUserInfoes();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LumluxSSYDB.Model.tUserInfoes DataRowToModel(DataRow row)
{
LumluxSSYDB.Model.tUserInfoes model = new LumluxSSYDB.Model.tUserInfoes();
if (row != null)
{
if (row["sGUID"] != null)
{
model.sGUID = row["sGUID"].ToString();
}
if (row["sID"] != null)
{
model.sID = row["sID"].ToString();
}
if (row["sUserName"] != null)
{
model.sUserName = row["sUserName"].ToString();
}
if (row["sPassWord"] != null)
{
model.sPassWord = row["sPassWord"].ToString();
}
if (row["iAuthorityGUID"] != null)
{
model.iAuthorityGUID = row["iAuthorityGUID"].ToString();
}
if (row["sAlias"] != null)
{
model.sAlias = row["sAlias"].ToString();
}
if (row["sPhone"] != null)
{
model.sPhone = row["sPhone"].ToString();
}
if (row["sEmail"] != null)
{
model.sEmail = row["sEmail"].ToString();
}
if (row["dCreateDate"] != null && row["dCreateDate"].ToString() != "")
{
model.dCreateDate = DateTime.Parse(row["dCreateDate"].ToString());
}
if (row["dUpdateTime"] != null && row["dUpdateTime"].ToString() != "")
{
model.dUpdateTime = DateTime.Parse(row["dUpdateTime"].ToString());
}
if (row["sRemark"] != null)
{
model.sRemark = row["sRemark"].ToString();
}
if (row["sPrjectInfoGUID"] != null)
{
model.sPrjectInfoGUID = row["sPrjectInfoGUID"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LumluxSSYDB.Model.tUserInfoes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tUserInfoes set ");
strSql.Append("sID=@sID,");
strSql.Append("sUserName=@sUserName,");
strSql.Append("sPassWord=@sPassWord,");
strSql.Append("iAuthorityGUID=@iAuthorityGUID,");
strSql.Append("sAlias=@sAlias,");
strSql.Append("sPhone=@sPhone,");
strSql.Append("sEmail=@sEmail,");
strSql.Append("dCreateDate=@dCreateDate,");
strSql.Append("dUpdateTime=@dUpdateTime,");
strSql.Append("sRemark=@sRemark,");
strSql.Append("sPrjectInfoGUID=@sPrjectInfoGUID");
strSql.Append(" where sGUID=@sGUID ");
SqlParameter[] parameters =
{
new SqlParameter("@sID", SqlDbType.NVarChar, 100),
new SqlParameter("@sUserName", SqlDbType.NVarChar, 100),
new SqlParameter("@sPassWord", SqlDbType.NVarChar, 200),
new SqlParameter("@iAuthorityGUID", SqlDbType.Char, 36),
new SqlParameter("@sAlias", SqlDbType.NVarChar, 100),
new SqlParameter("@sPhone", SqlDbType.NVarChar, 100),
new SqlParameter("@sEmail", SqlDbType.NVarChar, 100),
new SqlParameter("@dCreateDate", SqlDbType.DateTime),
new SqlParameter("@dUpdateTime", SqlDbType.DateTime),
new SqlParameter("@sRemark", SqlDbType.NVarChar, 500),
new SqlParameter("@sPrjectInfoGUID", SqlDbType.Char, 36),
new SqlParameter("@sGUID", SqlDbType.Char, 36)
};
parameters[0].Value = model.sID;
parameters[1].Value = model.sUserName;
parameters[2].Value = model.sPassWord;
parameters[3].Value = model.iAuthorityGUID;
parameters[4].Value = model.sAlias;
parameters[5].Value = model.sPhone;
parameters[6].Value = model.sEmail;
parameters[7].Value = model.dCreateDate;
parameters[8].Value = model.dUpdateTime;
parameters[9].Value = model.sRemark;
parameters[10].Value = model.sPrjectInfoGUID;
parameters[11].Value = model.sGUID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(LumluxSSYDB.Model.tUserInfoes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tUserInfoes(");
strSql.Append("sGUID,sID,sUserName,sPassWord,iAuthorityGUID,sAlias,sPhone,sEmail,dCreateDate,dUpdateTime,sRemark,sPrjectInfoGUID)");
strSql.Append(" values (");
strSql.Append("@sGUID,@sID,@sUserName,@sPassWord,@iAuthorityGUID,@sAlias,@sPhone,@sEmail,@dCreateDate,@dUpdateTime,@sRemark,@sPrjectInfoGUID)");
SqlParameter[] parameters =
{
new SqlParameter("@sGUID", SqlDbType.Char, 36),
new SqlParameter("@sID", SqlDbType.NVarChar, 100),
new SqlParameter("@sUserName", SqlDbType.NVarChar, 100),
new SqlParameter("@sPassWord", SqlDbType.NVarChar, 200),
new SqlParameter("@iAuthorityGUID", SqlDbType.Char, 36),
new SqlParameter("@sAlias", SqlDbType.NVarChar, 100),
new SqlParameter("@sPhone", SqlDbType.NVarChar, 100),
new SqlParameter("@sEmail", SqlDbType.NVarChar, 100),
new SqlParameter("@dCreateDate", SqlDbType.DateTime),
new SqlParameter("@dUpdateTime", SqlDbType.DateTime),
new SqlParameter("@sRemark", SqlDbType.NVarChar, 500),
new SqlParameter("@sPrjectInfoGUID", SqlDbType.Char, 36)
};
parameters[0].Value = model.sGUID;
parameters[1].Value = model.sID;
parameters[2].Value = model.sUserName;
parameters[3].Value = model.sPassWord;
parameters[4].Value = model.iAuthorityGUID;
parameters[5].Value = model.sAlias;
parameters[6].Value = model.sPhone;
parameters[7].Value = model.sEmail;
parameters[8].Value = model.dCreateDate;
parameters[9].Value = model.dUpdateTime;
parameters[10].Value = model.sRemark;
parameters[11].Value = model.sPrjectInfoGUID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult GetUserProjectInfo()
{
if (!string.IsNullOrWhiteSpace(this.UserID))
{
LumluxSSYDB.BLL.tUserInfoes bllUser = new LumluxSSYDB.BLL.tUserInfoes();
LumluxSSYDB.Model.tUserInfoes modelUser = new LumluxSSYDB.Model.tUserInfoes();
LumluxSSYDB.BLL.tPrjectInfo bllProject = new LumluxSSYDB.BLL.tPrjectInfo();
LumluxSSYDB.Model.tPrjectInfo modelProject = new LumluxSSYDB.Model.tPrjectInfo();
modelUser = bllUser.GetModel(this.UserID);
if ((modelUser != null) && (!string.IsNullOrWhiteSpace(modelUser.sPrjectInfoGUID)))
{
modelProject = bllProject.GetModel(modelUser.sPrjectInfoGUID);
return(View());
}
else
{
return(View());
}
}
else
{
return(View());
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LumluxSSYDB.Model.tUserInfoes GetModel(string sGUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 sGUID,sID,sUserName,sPassWord,iAuthorityGUID,sAlias,sPhone,sEmail,dCreateDate,dUpdateTime,sRemark,sPrjectInfoGUID from tUserInfoes ");
strSql.Append(" where sGUID=@sGUID ");
SqlParameter[] parameters =
{
new SqlParameter("@sGUID", SqlDbType.Char, 36)
};
parameters[0].Value = sGUID;
LumluxSSYDB.Model.tUserInfoes model = new LumluxSSYDB.Model.tUserInfoes();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
