/// <summary> /// 상세 검색함수 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_detailSearch_Click(object sender, EventArgs e) { TradeDAO tradeDAO = new TradeDAO(); trades = tradeDAO.GetTrade(low_date.Value, max_date.Value, txt_bussiness.Text); gViewTrade.Rows.Clear(); string button = ""; businessList.Clear(); foreach (var item in trades) { foreach (var business in new MiniErpDB().Get_Specific_Business(item.Business_code)) { Business business1 = new Business(); business1.Code = business.Business_code; business1.Addr = business.Business_addr; business1.Email = business.Business_email; business1.Presenter = business.Business_presenter; business1.Name = business.Business_name; business1.Tel = business.Business_tel; businessList.Add(business1); } if (item.Trade_standard == "판매") { button = "매출전표"; } else { button = "매입전표"; } gViewTrade.Rows.Add(item.Trade_standard, item.Trade_code, item.Clerk_name, item.Business_name, item.Item_summary, item.Total_fee, item.Trade_status, item.End_date_str, button); } }
public bool delete(int pIdTrade) { bool bReturn = false; TradeDAO oTrade = new TradeDAO(); try { if (pIdTrade == 0) { throw new Exception("Código do Trade não informado."); } bReturn = oTrade.delete(pIdTrade); if (!bReturn) { throw new Exception("Ocorreu um erro ao atualizar o Trade"); } } catch (Exception ex) { throw ex; } finally { } return(bReturn); }
public bool update(List <TradeDTO> pTrade) { bool bReturn = false; TradeDAO oTrade = new TradeDAO(); try { foreach (TradeDTO pItem in pTrade) { if (pItem.tradeValue == 0) { throw new Exception("Valor do Trade não pode ser zero."); } bReturn = oTrade.update(pItem); if (!bReturn) { throw new Exception("Ocorreu um erro ao atualizar o Trade"); } } } catch (Exception ex) { throw ex; } finally { } return(bReturn); }
public string getSectorTrade(List <TradeDTO> pTrade) { string sReturn = ""; TradeDAO oTrade = new TradeDAO(); List <TradeCategoryDTO> oReturn = new List <TradeCategoryDTO>(); try { foreach (TradeDTO pItem in pTrade) { oReturn = oTrade.getSectorTrade(pItem); if (oReturn.Count > 0) { foreach (TradeCategoryDTO pRetorno in oReturn) { sReturn += pRetorno.dsCategory + ","; } } } if (sReturn.LastIndexOf(",") > -1) { sReturn = sReturn.Substring(0, (sReturn.Length - 1)); } } catch (Exception ex) { throw ex; } finally { } return(sReturn); }
public int insert(List <TradeDTO> pTrade) { int iReturn = 0; TradeDAO oTrade = new TradeDAO(); try { foreach (TradeDTO pItem in pTrade) { if (pItem.tradeValue == 0) { throw new Exception("Valor do Trade não pode ser zero."); } iReturn = oTrade.insert(pItem); if (iReturn == 0) { throw new Exception("Ocorreu um erro ao inserir o Trade"); } } } catch (Exception ex) { throw ex; } finally { } return(iReturn); }
public List <TradeDTO> listTrade() { List <TradeDTO> oReturn = new List <TradeDTO>(); TradeDAO oTrade = new TradeDAO(); try { oReturn = oTrade.listTrade(); } catch (Exception ex) { throw ex; } finally { } return(oReturn); }
public List <TradeDTO> getTradeByID(int pIdTrade) { List <TradeDTO> oReturn = new List <TradeDTO>(); TradeDAO oTrade = new TradeDAO(); try { oReturn = oTrade.getTradeByID(pIdTrade); } catch (Exception ex) { throw ex; } finally { } return(oReturn); }
/// <summary> /// 그리드뷰에 데이터를 입력하는 함수 /// </summary> private void GViewSetData() { gViewTrade.Rows.Clear(); TradeDAO tradeDAO = new TradeDAO(); if (rdo_sell.Checked) { trades = tradeDAO.GetProgTrade("판매"); gViewTrade.Columns["warehouse"].HeaderText = "출고창고"; } else { trades = tradeDAO.GetProgTrade("구매"); gViewTrade.Columns["warehouse"].HeaderText = "입고창고"; } foreach (var item in trades) { gViewTrade.Rows.Add(item.Trade_code, item.Clerk_name, item.Business_name, item.Item_summary, item.Total_fee, item.Trade_status, item.Warehouse_name); } }
/// <summary> /// '판매' 거래에대한 정보를 리스트에 초기화 /// </summary> private List <Trade> GetTreade() { TradeDAO tradeDAO = new TradeDAO(); return(tradeDAO.GetProgTrade("판매")); }
public static bool Remove(TradeDTO[] trade) => TradeDAO.Remove(trade);
public static List <TradeDTO> ListAllByIdLimited(int init, int end, string id) => TradeDAO.ListAllByIdLimited(init, end, id);
public static List <TradeDTO> ListAll(string userid) => TradeDAO.ListAllById(userid);
public static bool RegisterUser(TradeDTO person) => TradeDAO.Insert(person);