/// <summary> /// 新增資料 /// </summary> public int Add(Models.MVote mod) { SqlCommand cmd = new SqlCommand(); StringBuilder sbTSQL = new StringBuilder(); sbTSQL.AppendLine("insert into [TB_Vote] ([TWYear],[MemberID],[AgentMemberID],[CreateDate],[CreateUser])"); sbTSQL.AppendLine("values (@TWYear,@MemberID,@AgentMemberID,@CreateDate,@CreateUser)"); sbTSQL.AppendLine(";select @@identity;"); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@AgentMemberID", SqlDbType.NVarChar).Value = mod.AgentMemberID; cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = mod.CreateDate; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.CommandText = sbTSQL.ToString(); object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.VoteID = intID; } return(intID); }
/// <summary> /// 實體物件取得DataRow資料 /// </summary> private Models.MVote SetModel(DataRow dr) { Models.MVote mod = new Models.MVote(); mod.VoteID = int.Parse(dr["VoteID"].ToString()); mod.TWYear = int.Parse(dr["TWYear"].ToString()); mod.MemberID = dr["MemberID"].ToString(); mod.AgentMemberID = dr["AgentMemberID"].ToString(); mod.CreateUser = dr["CreateUser"].ToString(); mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString()); return(mod); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MVote mod) { SqlCommand cmd = new SqlCommand("STP_VoteEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@VoteID", SqlDbType.Int).Value = mod.VoteID; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@AgentMemberID", SqlDbType.NVarChar).Value = mod.AgentMemberID; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 取得單筆資料 /// <summary> public Models.MVote GetModel(int intVoteID) { SqlCommand cmd = new SqlCommand("STP_VoteGetByPK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@VoteID", SqlDbType.Int).Value = intVoteID; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MVote mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
/// <summary> /// 修改資料 /// </summary> public bool Edit(Models.MVote mod) { return(new DAL.DVote().Edit(mod)); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MVote mod) { return(new DAL.DVote().Add(mod)); }