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