public DataTable GetMaterialHistory(StockVO vo) { using (SqlCommand cmd = new SqlCommand()) { StringBuilder sql = new StringBuilder(); //sql.Append($"select w_id, plan_id, factory_code, factory_name, p.product_codename, product_name, w_count_present, common_name as product_type from TBL_WAREHOUSE w inner join TBL_FACTORY f on w.factory_id = f.factory_id inner join TBL_PRODUCT p on p.product_id = w.product_id inner join TBL_COMMON_CODE c on c.common_value = p.product_type where 1=1"); sql.Append($"select wh_id, w.w_id, w.product_id, product_name, product_codename, wh_product_count, wh_udate, wh_comment, common_name ,plan_id from TBL_WAREHOUSE_HIS h inner join TBL_WAREHOUSE w on h.w_id = w.w_id inner join TBL_PRODUCT p on p.product_id = w.product_id inner join TBL_COMMON_CODE c on c.common_value = h.wh_category inner join TBL_FACTORY f on f.factory_id = w.factory_id where p.product_codename = @product_codename and factory_code = @factory_code order by wh_id desc"); cmd.Parameters.AddWithValue("@product_codename", vo.product_codename); cmd.Parameters.AddWithValue("@factory_code", vo.factory_code); cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = sql.ToString(); cmd.CommandType = CommandType.Text; DataTable dataTable = new DataTable(); cmd.Connection.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dataTable); da.Dispose(); cmd.Connection.Close(); return(dataTable); } }
public bool UpdateStock(StockVO stock) { string query = "UpdateStock"; SqlParameter[] sqlp = { new SqlParameter("stock_ID", stock.Stock_ID), new SqlParameter("stock_count", stock.Stock_Count) }; return(conn.SendExqueteQuery(query, sqlp)); }
public bool InsertStock(StockVO stock) { string query = "insert_stock"; SqlParameter[] sqlp = { new SqlParameter("stock_ID", stock.Stock_ID), new SqlParameter("pro_ID", stock.Pro_Id), new SqlParameter("seller_no", stock.Seller_no), new SqlParameter("stock_size", stock.Stock_Size), new SqlParameter("stock_count", stock.Stock_Count) }; return(conn.SendExqueteQuery(query, sqlp)); }
private void btnInsertStock_Click(object sender, EventArgs e) { StockVO stock = new StockVO(lblPro_No.Text + "_" + cmbSize.Text, lblPro_No.Text, Form1.CompanyNo, cmbSize.Text, (int)numStockCount.Value); try { stockDao.InsertStock(stock); MessageBox.Show("사이즈 추가 성공!"); } catch (Exception) { MessageBox.Show("이미 존재하는 사이즈 입니다."); } }
private void btnHistory_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } StockVO vo = new StockVO(); vo.product_codename = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(); vo.factory_code = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); warehouseHistoryPop frm = new warehouseHistoryPop(vo); frm.ShowDialog(); }
private void btnSubmit_Click(object sender, EventArgs e) { stock = null; Product pro = new Product(); pro.Pro_ID = lblPro_No.Text; foreach (var item in cat_kinds) { if (item.Cat_Kind == cmbCatID.Text) { pro.Cat_ID = item.Cat_ID; } } pro.Pro_Name = txtProName.Text; pro.Pro_Price = int.Parse(txtProPrice.Text); pro.Main_Comment = txtMainComment.Text; pro.Sub_Comment = txtSubComment.Text; if (proPic.Image != null) { pro.Main_Image = "https://jinweb.azurewebsites.net/img/" + pathFile; } else if (proPic.Image != null && !string.IsNullOrEmpty(row.Cells["main_image"].Value.ToString())) { pro.Main_Image = row.Cells["main_image"].Value.ToString(); } else if (proPic.Image == null) { pro.Main_Image = ""; } pro.Pro_Discount = int.Parse(txtDiscount.Text); pro.Pro_Gender = cmbGender.Text; foreach (var item in lstStock) { if (lblPro_No.Text + "_" + cmbSize.Text == item.Stock_ID) { stock = item; break; } } if (cmbSize.SelectedIndex > -1 && stock != null) { stock.Stock_Count = (int)numStockCount.Value; } if (string.IsNullOrEmpty(cmbSize.Text)) { //try { pDao.UpdateProduct(pro); MessageBox.Show("수정 성공"); } //catch (Exception) { //MessageBox.Show("수정 실패"); } } else { try { if (pDao.UpdateProduct(pro)) { if (stockDao.UpdateStock(stock)) { UploadImgToFTP(); MessageBox.Show("수정 성공"); } } } catch (Exception) { MessageBox.Show("수정 실패"); } } this.Close(); }
public warehouseHistoryPop(StockVO vo) { InitializeComponent(); this.vo = vo; }
public DataTable GetMaterialHistory(StockVO vo) { StockDAC dac = new StockDAC(); return(dac.GetMaterialHistory(vo)); }