/// <summary> /// 實體物件取得DataRow資料 /// </summary> private Models.MPaperSuggestion SetModel(DataRow dr) { Models.MPaperSuggestion mod = new Models.MPaperSuggestion(); mod.PaperSuggestionID = int.Parse(dr["PaperSuggestionID"].ToString()); mod.PaperID = int.Parse(dr["PaperID"].ToString()); mod.PaperSuggestion = dr["PaperSuggestion"].ToString(); mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString()); return(mod); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MPaperSuggestion mod) { SqlCommand cmd = new SqlCommand("STP_PaperSuggestionEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperSuggestionID", SqlDbType.Int).Value = mod.PaperSuggestionID; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID; cmd.Parameters.Add("@PaperSuggestion", SqlDbType.NVarChar).Value = mod.PaperSuggestion; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 實體物件取得DataReader資料 /// </summary> private Models.MPaperSuggestion SetModel(SqlDataReader dr) { Models.MPaperSuggestion mod = new Models.MPaperSuggestion(); while (dr.Read()) { mod.PaperSuggestionID = int.Parse(dr["PaperSuggestionID"].ToString()); mod.PaperID = int.Parse(dr["PaperID"].ToString()); mod.PaperSuggestion = dr["PaperSuggestion"].ToString(); mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString()); } return(mod); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MPaperSuggestion mod) { SqlCommand cmd = new SqlCommand("STP_PaperSuggestionAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID; cmd.Parameters.Add("@PaperSuggestion", SqlDbType.NVarChar).Value = mod.PaperSuggestion; object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.PaperSuggestionID = intID; } return(intID); }
/// <summary> /// 取得單筆資料 /// <summary> public Models.MPaperSuggestion GetModel(int intPaperSuggestionID) { SqlCommand cmd = new SqlCommand("STP_PaperSuggestionGetByPK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperSuggestionID", SqlDbType.Int).Value = intPaperSuggestionID; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MPaperSuggestion mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
/// <summary> /// 修改資料 /// </summary> public bool Edit(Models.MPaperSuggestion mod) { return(new DAL.DPaperSuggestion().Edit(mod)); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MPaperSuggestion mod) { return(new DAL.DPaperSuggestion().Add(mod)); }