/// <summary>
/// 修改資料
/// <summary>
public bool Edit(Models.MUser mod)
{
SqlCommand cmd = new SqlCommand("STP_UserEdit");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = mod.UserID;
cmd.Parameters.Add("@UserPassword", SqlDbType.NVarChar).Value = Security.Encrypt(mod.UserPassword);
cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = mod.UserName;
cmd.Parameters.Add("@Actived", SqlDbType.Bit).Value = mod.Actived;
cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser;
return(SQLUtil.ExecuteSql(cmd) > 0);
}
/// <summary>
/// 取得單筆資料
/// <summary>
public Models.MUser GetModel(string strUserID)
{
SqlCommand cmd = new SqlCommand("STP_UserGetByPK");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = strUserID;
SqlDataReader dr = SQLUtil.QueryDR(cmd);
bool isHasRows = dr.HasRows;
Models.MUser mod = SetModel(dr);
dr.Close();
return(isHasRows ? mod : null);
}
/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MUser SetModel(DataRow dr)
{
Models.MUser mod = new Models.MUser();
mod.UserID = dr["UserID"].ToString();
//mod.UserPassword = Security.Decrypt(dr["UserPassword"].ToString());
mod.UserName = dr["UserName"].ToString();
mod.Actived = bool.Parse(dr["Actived"].ToString());
mod.CreateUser = dr["CreateUser"].ToString();
mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString());
mod.UpdateUser = dr["UpdateUser"].ToString();
mod.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString());
return(mod);
}
/// <summary>
/// 新增資料
/// </summary>
public string Add(Models.MUser mod)
{
SqlCommand cmd = new SqlCommand("STP_UserAdd");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = mod.UserID;
cmd.Parameters.Add("@UserPassword", SqlDbType.NVarChar).Value = Security.Encrypt(mod.UserPassword);
cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = mod.UserName;
cmd.Parameters.Add("@Actived", SqlDbType.Bit).Value = mod.Actived;
cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser;
cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser;
if (SQLUtil.ExecuteSql(cmd) > 0)
{
return(mod.UserID);
}
else
{
return(null);
}
}
/// <summary>
/// 修改資料
/// </summary>
public bool Edit(Models.MUser mod)
{
return(new DAL.DUser().Edit(mod));
}
/// <summary>
/// 新增資料
/// </summary>
public string Add(Models.MUser mod)
{
return(new DAL.DUser().Add(mod));
}
