/// <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);
