/// <summary> /// 제품타입리스트를 반환하는 메서드 /// </summary> /// <returns>제품리스트 반환 </returns> internal DataTable proTypeList() { DataTable proTypeList = new DataTable(); string sp = "Bom_JW_ProType"; try { proTypeList = dbp.ExecuteParametersDT(sp, null); } catch (Exception) { throw; } return(proTypeList); }
/// <summary> /// 판매현황을 데이터 그리드뷰에 표현 /// </summary> private void RealTiemSales() { salesList.Clear(); dgvMainSales.DataSource = null; DataTable dataTable = dbp.ExecuteParametersDT("Bom_JW_MainSelect_Procedure", null); foreach (DataRow item in dataTable.Rows) { salesList.Add(new Cus_OrderVO { OrderNo = Int32.Parse(item["Cus_Order_OrderNo"].ToString()), CusID = item["Cus_ID"].ToString(), OrderContants = item["Pro_Name"].ToString() + ", " + item["Cus_Order_EA"].ToString() + " 개", OrderDate = DateTime.Parse(item["Cus_Order_Date"].ToString()) }); } dgvMainSales.DataSource = salesList; //dgvMainSales.AutoResizeColumns(); dgvMainSales.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvMainSales.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None; dgvMainSales.Columns[0].Width = 70; dgvMainSales.Columns[1].Width = 80; dgvMainSales.Columns[3].Width = 150; dgvMainSales.Columns[0].HeaderText = "주문번호"; dgvMainSales.Columns[1].HeaderText = "고객명"; dgvMainSales.Columns[2].HeaderText = "주문내용"; dgvMainSales.Columns[3].HeaderText = "주문날짜"; }
/// <summary> /// 주문내역을 상세하게 보여주는 메서드 /// </summary> private void SalesInfo() { DataTable dataTable = dbp.ExecuteParametersDT("Bom_JW_ProSelect2_Procedure", null); lblOrderNo.Text = dataTable.Rows[thisContantsIndex]["Cus_Order_OrderNo"].ToString(); productsName = lblCusID.Text = dataTable.Rows[thisContantsIndex]["Cus_ID"].ToString(); lblProName.Text = dataTable.Rows[thisContantsIndex]["Pro_Name"].ToString(); lblProEA.Text = dataTable.Rows[thisContantsIndex]["Cus_Order_EA"].ToString() + " 개"; int price = Int32.Parse(dataTable.Rows[thisContantsIndex]["Cus_Order_Price"].ToString()); lblDate.Text = (DateTime.Parse(dataTable.Rows[thisContantsIndex]["Cus_Order_Date"].ToString()).ToShortDateString()).ToString(); lblEmpName.Text = dataTable.Rows[thisContantsIndex]["Emp_Name"].ToString(); if (dataTable.Rows[thisContantsIndex]["Mat_No"].ToString() == "") { lblProductCount.Text = "0" + " 개"; } else { lblProductCount.Text = dataTable.Rows[thisContantsIndex]["Mat_No"].ToString() + " 개"; } lblPhone.Text = dataTable.Rows[thisContantsIndex]["Cus_Phone"].ToString(); lblAddr.Text = dataTable.Rows[thisContantsIndex]["Cus_Addr"].ToString(); lblOrderPrice.Text = String.Format("{0:##,##0}", price) + " 원"; }
/// <summary> /// 모든 상품 출력 프로시져 /// </summary> /// <returns></returns> internal List <Products> SelectPro() { List <Products> proLst = new List <Products>(); string sp = "Bom_Pro_View_Procedure"; SqlParameter[] sqlParameters = null; DataTable dt = con.ExecuteParametersDT(sp, sqlParameters); foreach (DataRow item in dt.Rows) { proLst.Add(new Products { Pro_No = Int32.Parse(item["Pro_No"].ToString()), Pro_Name = item["Pro_Name"].ToString(), Mat_No = Int32.Parse(item["Mat_No"].ToString()), Pro_Price = Int32.Parse(item["Pro_Price"].ToString()) }); } return(proLst); }
/// <summary> /// /// </summary> /// <param name="sp">프로시저 이름</param> /// <param name="search">조회할 변수</param> /// <param name="search2">조회할 변수</param> /// <param name="parameter1">파라메터 변수1</param> /// <param name="parameter2">파라메터 변수2</param> /// <returns>조회한 데이터리스트 반환</returns> public List <SalesVO> SalesSelect(string sp, string search, string search2, string parameter1, string parameter2) { List <SalesVO> salesList = new List <SalesVO>(); int parameterCount = 1; if (search2 != "") // 두개의 입력값 있을시 배열의 크기를 증가시킴 { parameterCount++; } SqlParameter[] sqlParameters = new SqlParameter[parameterCount]; if (search == "" && parameter1 == "") { sqlParameters = null; } else { sqlParameters[0] = new SqlParameter(parameter1, search); } if (search2 != "") { sqlParameters[1] = new SqlParameter(parameter2, search2); } DataTable dateTable = dbp.ExecuteParametersDT(sp, sqlParameters); foreach (DataRow item in dateTable.Rows) { salesList.Add(new SalesVO() { OrderNo = Int32.Parse(item["Cus_Order_OrderNo"].ToString()), CusID = item["Cus_ID"].ToString(), EmpID = item["Emp_Name"].ToString(), Pro_No = item["Pro_Name"].ToString(), Price = Int32.Parse(item["Cus_Order_Price"].ToString()), Ea = Int32.Parse(item["Cus_Order_EA"].ToString()), OrderDate = DateTime.Parse(item["Cus_Order_Date"].ToString()), OrderComplete = item["Com_Type"].ToString(), }); } return(salesList); }
public DataTable ProSelectFromMat() { try { string sp = "Materials_Type_Product_Select_Procedure"; return(dp.ExecuteParametersDT(sp, null)); } catch (Exception) { throw; } }
/// <summary> /// 매출 정보를 반환하는 메서드 /// </summary> /// <param name="startDate">조회할 시작날짜</param> /// <param name="endDate">조회할 마지막날짜</param> /// <returns>매출정보 반환</returns> internal List <RevenueVO> Revenue(string startDate, string endDate) { RevenueList1.Clear(); string sp = "Bom_JW_Revenue"; SqlParameter[] sqlParameter = new SqlParameter[2]; sqlParameter[0] = new SqlParameter("@startDate", startDate); sqlParameter[1] = new SqlParameter("@endDate", endDate); dt = dbp.ExecuteParametersDT(sp, sqlParameter); foreach (DataRow item in dt.Rows) { RevenueList1.Add(new RevenueVO { OrderNo = Int32.Parse(item["Cus_Order_No"].ToString()), OrderDate = DateTime.Parse(item["Cus_Order_Date"].ToString()), OrderPrice = String.Format("{0:##,##0}", Int32.Parse(item["Cus_Order_Price"].ToString())) + " 원" }); } return(RevenueList1); }
public string DateInsert1() { int year = 0; int month = 0; int day = 0; DateTime dt; Random rd = new Random(); DBProcessor dbp = new DBProcessor(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString); int cusno = 0; int empno = 0; int prono = 0; int cusorderorderno = 0; string date = null; int price = 0; int ea = 0; string sp1 = "DataInsertProPrice"; SqlParameter[] sqlParameter1 = new SqlParameter[1]; string sp2 = "DataInsert"; SqlParameter[] sqlParameters2 = new SqlParameter[8]; int errorCheck = 0; for (int i = 0; i < 50; i++) // >> 버튼 한번클릭마다 인트 i = 0 초기값을 올려줘야함 { try { errorCheck++; price = 0; prono = new Random().Next(24, 28); ea = new Random().Next(1, 4); year = rd.Next(2019, (int)DateTime.Today.Year + 1); month = rd.Next(1, 3); day = rd.Next(1, 28); date = month.ToString() + "/" + day.ToString() + "/" + year.ToString(); dt = DateTime.Parse(date); ///////////////////////////////////////////////////////////////////////////// sqlParameter1[0] = new SqlParameter("@pro_No", prono); //dbp.ExecuteParametersDT(sp1, sqlParameter1); foreach (DataRow item in dbp.ExecuteParametersDT(sp1, sqlParameter1).Rows) { price = Int32.Parse(item["Pro_Price"].ToString()) * ea; } ////////////////////////////////////////////////////////////////////////////////// sqlParameters2[0] = new SqlParameter("@cus_No", 10); //5~9번 있음 sqlParameters2[1] = new SqlParameter("@emp_No", new Random().Next(1, 5)); //4명 sqlParameters2[2] = new SqlParameter("@pro_No", prono); //6개 sqlParameters2[3] = new SqlParameter("@cus_Order_OrderNo", i + 1047); // >> 버튼 한번클릭마다 인트 i = 0 초기값을 올려줘야함 sqlParameters2[4] = new SqlParameter("@cus_Order_Date", dt); sqlParameters2[5] = new SqlParameter("@cus_OrderComplete", 2); //2번고정 sqlParameters2[6] = new SqlParameter("@cus_Order_Price", price); sqlParameters2[7] = new SqlParameter("@cus_Order_EA", ea); dbp.ExecuteParameters(sp2, sqlParameters2); } catch (Exception) { return(errorCheck.ToString() + "번째에서 멈춤"); } } return("완료"); }
public DataTable SelectOrderList() { string sp = "Offerer_Order_List_View_Procedure"; return(dp.ExecuteParametersDT(sp, null)); }
public DataTable SelectMat(string sp) { return(dp.ExecuteParametersDT(sp, null)); }
/// <summary> /// 넘겨받은 준문정보로 출하지시서 폼의 내용을 표시 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Shipment_Load(object sender, EventArgs e) { dgvProList.Font = new Font("맑은고딕", 9); if (this.orderNo != 0) { string sp = "Bom_JW_Shipment_Procedure"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@OrderNo", orderNo); DataTable dt = dbp.ExecuteParametersDT(sp, sqlParameters); foreach (DataRow item in dt.Rows) { lblOrderNo.Text = item["Cus_Order_OrderNO"].ToString(); lblDate.Text = DateTime.Parse(item["Cus_Order_Date"].ToString()).ToShortDateString().ToString(); lblCus.Text = item["Cus_ID"].ToString(); lblEmp.Text = item["Emp_Name"].ToString(); lblPhone.Text = item["Cus_Phone"].ToString(); lblAddr.Text = item["Cus_Addr"].ToString(); ProList.Add(new ShipmentVO { ProName = item["Pro_Name"].ToString(), ProEa = Int32.Parse(item["Cus_Order_EA"].ToString()), ProPrice = String.Format("{0:##,##0}", item["Cus_Order_Price"]) + " 원", ResidualAmount = Int32.Parse(item["RemainingAmount"].ToString()) }); } lblShipDate.Text = DateTime.Now.AddDays(2).ToShortDateString(); dgvProList.DataSource = null; dgvProList.DataSource = ProList; dgvProList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvProList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None; dgvProList.Columns[0].Width = 200; dgvProList.Columns[1].Width = 40; dgvProList.Columns[2].Width = 90; dgvProList.Columns[3].Width = 90; dgvProList.Columns[0].HeaderText = "제품명"; dgvProList.Columns[1].HeaderText = "개수"; dgvProList.Columns[2].HeaderText = "가격"; dgvProList.Columns[3].HeaderText = "잔여량"; DataGridViewDisableButtonColumn column1 = new DataGridViewDisableButtonColumn(); column1.Name = "발주"; dgvProList.Columns.Add(column1); for (int i = 0; i < dgvProList.RowCount; i++) { dgvProList.Rows[i].Cells["발주"].Value = "소요량 확인"; } dgvProList.CellClick += DgvProList_CellClick; this.Controls.Add(dgvProList); for (int i = 0; i < dgvProList.Rows.Count; i++) { if (Int32.Parse(dgvProList.Rows[i].Cells["ProEa"].Value.ToString()) < Int32.Parse(dgvProList.Rows[i].Cells["residualAmount"].Value.ToString())) { DataGridViewDisableButtonCell buttonCell = (DataGridViewDisableButtonCell)dgvProList.Rows[i].Cells["발주"]; buttonCell.Enabled = false; dgvProList.Invalidate(); } } } if (lblOrderNo.Text != "") { btnPath.Enabled = btnConfirm.Enabled = true; } }