/// <summary> /// 實體物件取得DataRow資料 /// </summary> private Models.MPaperDomainSeq SetModel(DataRow dr) { Models.MPaperDomainSeq mod = new Models.MPaperDomainSeq(); mod.PaperID = int.Parse(dr["PaperID"].ToString()); mod.PaperDomainID = dr["PaperDomainID"].ToString(); mod.Seq = int.Parse(dr["Seq"].ToString()); return(mod); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MPaperDomainSeq mod) { SqlCommand cmd = new SqlCommand("STP_PaperDomainSeqEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID; cmd.Parameters.Add("@PaperDomainID", SqlDbType.NVarChar).Value = mod.PaperDomainID; cmd.Parameters.Add("@Seq", SqlDbType.Int).Value = mod.Seq; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 實體物件取得DataReader資料 /// </summary> private Models.MPaperDomainSeq SetModel(SqlDataReader dr) { Models.MPaperDomainSeq mod = new Models.MPaperDomainSeq(); while (dr.Read()) { mod.PaperID = int.Parse(dr["PaperID"].ToString()); mod.PaperDomainID = dr["PaperDomainID"].ToString(); mod.Seq = int.Parse(dr["Seq"].ToString()); } return(mod); }
/// <summary> /// 取得單筆資料 /// <summary> public Models.MPaperDomainSeq GetModel(int intPaperID) { SqlCommand cmd = new SqlCommand("STP_PaperDomainSeqGetByPK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = intPaperID; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MPaperDomainSeq mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
/// <summary> /// 修改資料 /// </summary> public bool Edit(Models.MPaperDomainSeq mod) { return(new DAL.DPaperDomainSeq().Edit(mod)); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MPaperDomainSeq mod) { return(new DAL.DPaperDomainSeq().Add(mod)); }