/// <summary>아이템 타입별 수량 조회</summary> public List<BmItemQuantity> GetItemQuantityList(BmItemQuantity pDataRq) { try { #region SetQuery StringBuilder sbQuery = new StringBuilder("SELECT * FROM tbItemQuantity WHERE 1=1"); if (pDataRq.Seq > 0) sbQuery.AppendLine(" AND Seq = @Seq"); if (pDataRq.ItemSeq > 0) sbQuery.AppendLine(" AND ItemSeq = @ItemSeq"); if (!string.IsNullOrEmpty(pDataRq.Type)) sbQuery.AppendLine(" AND Type = @Type"); sbQuery.AppendLine(" ORDER BY ItemSeq, RegDt"); #endregion SetQuery List<BmItemQuantity> result = new List<BmItemQuantity>(); SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlConn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = sbQuery.ToString(); #region Set Parameters if (pDataRq.Seq > 0) cmd.Parameters.Add("@Seq", SqlDbType.Int, 0).Value = pDataRq.Seq; if (pDataRq.ItemSeq > 0) cmd.Parameters.Add("@ItemSeq", SqlDbType.Int, 0).Value = pDataRq.ItemSeq; if (!string.IsNullOrEmpty(pDataRq.Type)) cmd.Parameters.Add("@Type", SqlDbType.VarChar, 100).Value = pDataRq.Type; #endregion Set Parameters SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { DataTable dt = new DataTable(); dt.Load(reader); result = ConvertToBmItemQuantity(dt); } reader.Dispose(); cmd.Dispose(); return result; } catch (Exception ex) { throw ex; } }
/// <summary>상품 수량 수정</summary> public bool UpdateItemQuantity(BmItemQuantity pDataRq) { try { using (SqlConn = new SqlConnection(ConnectionString)) { using (TransactionScope scope = new TransactionScope()) { try { SqlConn.Open(); var result = dac.UpdateItemQuantity(pDataRq); scope.Complete(); return result; } catch (Exception ex) { throw ex; } finally { SqlConn.Dispose(); } } } } catch (Exception ex) { WriteLog("Exception", ex.Message); return false; } }
/// <summary>아이템 타입별 수량 삭제</summary> 로그 등록 필요 public bool DeleteItemQuantity(BmItemQuantity pDataRq) { try { #region SetQuery string strQuery = @"DELETE tbItemQuantity WHERE Seq = @Seq"; #endregion SetQuery int result = 0; SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlConn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = strQuery.ToString(); #region Set Parameters cmd.Parameters.Add("@Seq", SqlDbType.Int, 0).Value = pDataRq.Seq; #endregion Set Parameters result = cmd.ExecuteNonQuery(); cmd.Dispose(); if (result == 1) { WriteHistory(pDataRq, HistoryCommandType.DELETE); return true; } else { return false; } } catch (Exception ex) { throw ex; } }
/// <summary>아이템 타입별 수량 Convert DataTable -> BmItemQuantity</summary> private List<BmItemQuantity> ConvertToBmItemQuantity(DataTable dt) { List<BmItemQuantity> list = new List<BmItemQuantity>(); foreach (DataRow dr in dt.Rows) { BmItemQuantity data = new BmItemQuantity(); data.Seq = (int)dr["Seq"]; data.ItemSeq = (int)dr["ItemSeq"]; data.Type = dr["Type"].ToString(); data.Quantity = (int)dr["Quantity"]; data.SalesCount = (int)dr["SalesCount"]; data.State = (int)dr["State"]; data.Registrant = dr["Registrant"].ToString(); data.RegDt = (DateTime)dr["RegDt"]; data.Modifyer = dr["Modifyer"].ToString(); data.ModifyDt = string.IsNullOrEmpty(dr["ModifyDt"].ToString()) ? null : (DateTime?)dr["ModifyDt"]; list.Add(data); } return list; }
/// <summary>아이템 타입별 수량 수정</summary> public bool UpdateItemQuantity(BmItemQuantity pDataRq) { try { #region SetQuery string strQuery = @"UPDATE tbItemQuantity SET Type = @Type, Quantity = @Quantity, SalesCount = @SalesCount, State = @State, Modifyer = @Modifyer, ModifyDt = dbo.getkordate() WHERE Seq = @Seq"; #endregion SetQuery int result = 0; SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlConn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = strQuery.ToString(); #region Set Parameters cmd.Parameters.Add("@Type", SqlDbType.VarChar, 100).Value = pDataRq.Type; cmd.Parameters.Add("@Quantity", SqlDbType.Int, 0).Value = pDataRq.Quantity; cmd.Parameters.Add("@SalesCount", SqlDbType.Int, 0).Value = pDataRq.SalesCount; cmd.Parameters.Add("@State", SqlDbType.Int, 0).Value = pDataRq.State; cmd.Parameters.Add("@Seq", SqlDbType.Int, 0).Value = pDataRq.Seq; cmd.Parameters.Add("@Modifyer", SqlDbType.VarChar, 20).Value = pDataRq.Modifyer; #endregion Set Parameters result = cmd.ExecuteNonQuery(); cmd.Dispose(); if (result == 1) { WriteHistory(pDataRq, HistoryCommandType.UPDATE); return true; } else { return false; } } catch (Exception ex) { throw ex; } }
/// <summary>아이템 타입별 수량 등록</summary> public bool InsertItemQuantity(BmItemQuantity pDataRq) { try { #region SetQuery string strQuery = @"INSERT INTO tbItemQuantity (ItemSeq , Type , Quantity , SalesCount , State , Registrant ) Values (@ItemSeq , @Type , @Quantity , @SalesCount , @State , @Registrant) SELECT @@Identity"; #endregion SetQuery int result = 0; SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlConn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = strQuery.ToString(); #region Set Parameters cmd.Parameters.Add("@ItemSeq", SqlDbType.Int, 0).Value = pDataRq.ItemSeq; cmd.Parameters.Add("@Type", SqlDbType.VarChar, 100).Value = pDataRq.Type; cmd.Parameters.Add("@Quantity", SqlDbType.Int, 0).Value = pDataRq.Quantity; cmd.Parameters.Add("@SalesCount", SqlDbType.Int, 0).Value = pDataRq.SalesCount; cmd.Parameters.Add("@State", SqlDbType.Int, 0).Value = pDataRq.State; cmd.Parameters.Add("@Registrant", SqlDbType.VarChar, 20).Value = pDataRq.Registrant; #endregion Set Parameters result = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); if (result > 0) { pDataRq.Seq = result; WriteHistory(pDataRq, HistoryCommandType.INSERT); return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public BmItemQuantityPagingRq() { Item = new BmItemQuantity(); Paging = new BmPaging(); }