/// <summary> /// 實體物件取得DataRow資料 /// </summary> private Models.MEDM SetModel(DataRow dr) { Models.MEDM mod = new Models.MEDM(); mod.MemberID = dr["MemberID"].ToString(); mod.NameC = dr["NameC"].ToString(); mod.Email = dr["Email"].ToString(); mod.IsSend = bool.Parse(dr["IsSend"].ToString()); return(mod); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MEDM mod) { SqlCommand cmd = new SqlCommand("STP_EDMEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@NameC", SqlDbType.NVarChar).Value = mod.NameC; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = mod.Email; cmd.Parameters.Add("@IsSend", SqlDbType.Bit).Value = mod.IsSend; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 實體物件取得DataReader資料 /// </summary> private Models.MEDM SetModel(SqlDataReader dr) { Models.MEDM mod = new Models.MEDM(); while (dr.Read()) { mod.MemberID = dr["MemberID"].ToString(); mod.NameC = dr["NameC"].ToString(); mod.Email = dr["Email"].ToString(); mod.IsSend = bool.Parse(dr["IsSend"].ToString()); } return(mod); }
/// <summary> /// 新增資料 /// </summary> public string Add(Models.MEDM mod) { SqlCommand cmd = new SqlCommand("STP_EDMAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@NameC", SqlDbType.NVarChar).Value = mod.NameC; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = mod.Email; cmd.Parameters.Add("@IsSend", SqlDbType.Bit).Value = mod.IsSend; if (SQLUtil.ExecuteSql(cmd) > 0) { return(mod.MemberID); } else { return(null); } }
/// <summary> /// 取得單筆資料 /// <summary> public Models.MEDM GetModel(string strMemberID) { SqlCommand cmd = new SqlCommand("STP_EDMGetByPK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = strMemberID; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MEDM mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
/// <summary> /// 修改資料 /// </summary> public bool Edit(Models.MEDM mod) { return(new DAL.DEDM().Edit(mod)); }
/// <summary> /// 新增資料 /// </summary> public string Add(Models.MEDM mod) { return(new DAL.DEDM().Add(mod)); }