public int Update(PromotionItemGroupInfo oParam) { string sql = @"UPDATE Promotion_Item_Group SET PromotionSysNo=@PromotionSysNo, GroupName=@GroupName, OrderNum=@OrderNum, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPromotionSysNo = new SqlParameter("@PromotionSysNo", SqlDbType.Int, 4); SqlParameter paramGroupName = new SqlParameter("@GroupName", SqlDbType.Char, 10); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.PromotionSysNo != AppConst.IntNull) paramPromotionSysNo.Value = oParam.PromotionSysNo; else paramPromotionSysNo.Value = System.DBNull.Value; if (oParam.GroupName != AppConst.StringNull) paramGroupName.Value = oParam.GroupName; else paramGroupName.Value = System.DBNull.Value; if (oParam.OrderNum != AppConst.IntNull) paramOrderNum.Value = oParam.OrderNum; else paramOrderNum.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramPromotionSysNo); cmd.Parameters.Add(paramGroupName); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public int Insert(PromotionItemGroupInfo oParam) { string sql = @"INSERT INTO Promotion_Item_Group ( PromotionSysNo, GroupName, OrderNum, Status ) VALUES ( @PromotionSysNo, @GroupName, @OrderNum, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPromotionSysNo = new SqlParameter("@PromotionSysNo", SqlDbType.Int, 4); SqlParameter paramGroupName = new SqlParameter("@GroupName", SqlDbType.Char, 10); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.PromotionSysNo != AppConst.IntNull) paramPromotionSysNo.Value = oParam.PromotionSysNo; else paramPromotionSysNo.Value = System.DBNull.Value; if (oParam.GroupName != AppConst.StringNull) paramGroupName.Value = oParam.GroupName; else paramGroupName.Value = System.DBNull.Value; if (oParam.OrderNum != AppConst.IntNull) paramOrderNum.Value = oParam.OrderNum; else paramOrderNum.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramPromotionSysNo); cmd.Parameters.Add(paramGroupName); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
private void map(PromotionItemGroupInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.PromotionSysNo = Util.TrimIntNull(tempdr["PromotionSysNo"]); oParam.GroupName = Util.TrimNull(tempdr["GroupName"]); oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public void UpdateItemGroup(PromotionItemGroupInfo oParam) { new PromotionItemGroupDac().Update(oParam); }
public PromotionItemGroupInfo LoadGroup(int sysNo) { string sql = "select * from Promotion_Item_Group where sysno =" + sysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; PromotionItemGroupInfo oGroutInfo = new PromotionItemGroupInfo(); map(oGroutInfo, ds.Tables[0].Rows[0]); return oGroutInfo; }
public void InsertItemGroup(PromotionItemGroupInfo oParam) { new PromotionItemGroupDac().Insert(oParam); }