private void LoadData() { using (var db = new SlaughterhouseEntities()) { lblMinWeight.Text = product.min_weight.ToString(); lblMaxWeight.Text = product.max_weight.ToString(); var receive = db.receives.Where(p => p.receive_no == lblReceiveNo.Text).SingleOrDefault(); //int stock_qty = receive.receive_item.Where(p => p.product_code.Equals(product.product_code)).Sum(p => p.receive_qty); //decimal stock_wgh = receive.receive_item.Where(p => p.product_code.Equals(product.product_code)).Sum(p => p.receive_wgh); var receive_item = receive.receive_item.Where(p => p.product_code.Equals(product.product_code)).LastOrDefault(); int stock_qty = Convert.ToInt16(receive.carcass_qty); decimal stock_wgh = Convert.ToDecimal(receive.carcass_wgh); int remain_qty = receive.farm_qty - stock_qty; lblReceiveNo.Text = receive.receive_no; lblFarm.Text = receive.farm.farm_name; lblBreeder.Text = receive.breeder.breeder_name; //lblTruckNo.Text = receive.truck.truck_no; //lblQueueNo.Text = receive.queue_no.ToString(); lblLotNo.Text = receive.lot_no; lblFarmQty.Text = receive.farm_qty.ToComma(); lblFactoryQty.Text = stock_qty.ToComma(); lblFactoryWgh.Text = stock_wgh.ToFormat2Decimal(); lblRemainQty.Text = remain_qty.ToComma(); if (receive_item != null) { lblLastWgh.Text = receive_item.receive_wgh.ToFormat2Decimal(); } } lblMessage.Text = Constants.START_WAITING; }
private void LoadProduct() { flowLayoutPanel1.Controls.Clear(); using (var db = new SlaughterhouseEntities()) { var products = db.products.Where(p => p.product_group_code == _productGroupCode).ToList(); foreach (var item in products) { var btn = new Button { Text = item.product_name, Width = 150, Height = 80, FlatStyle = FlatStyle.Flat, Font = new Font("Kanit", 16), BackColor = Color.WhiteSmoke, Tag = item.product_code }; btn.Click += Btn_Click; flowLayoutPanel1.Controls.Add(btn); } } }
private void LoadProduct() { using (var db = new SlaughterhouseEntities()) { product = db.products.Where(p => p.product_code == productCode).SingleOrDefault(); lblMinWeight.Text = product.min_weight.ToString(); lblMaxWeight.Text = product.max_weight.ToString(); var receiveItems = db.receive_item.Where(p => p.product_code.Equals(product.product_code) && p.receive_no.Equals(lblReceiveNo.Text)).ToList(); int stock_qty = 0; decimal stock_wgh = 0; foreach (var item in receiveItems) { stock_qty += item.receive_qty; stock_wgh += item.receive_wgh; } //int remain_qty = lblSwineQty.Text.ToInt16() - stock_qty; lblStockQty.Text = stock_qty.ToComma(); lblStockWgh.Text = stock_wgh.ToFormat2Decimal(); btnStart.Enabled = true; lblMessage.Text = Constants.START_WAITING; } }
private void LoadProduct() { flowLayoutPanel1.Controls.Clear(); buttons = new List <Button>(); string productCode = lblProductCode.Text; using (var db = new SlaughterhouseEntities()) { var plant = db.plants.Find(plantID); var productionDate = plant.production_date; var sql = @"SELECT DISTINCT a.product_code, a.lot_no,b.product_name FROM rm_issued_info a,product b WHERE a.product_code =b.product_code AND production_date = @production_date"; var qry = db.Database.SqlQuery <RMIssuedInfo>(sql, new MySqlParameter("production_date", productionDate)).ToList(); productIssueds = qry.ToList(); for (int i = 0; i < productIssueds.Count; i++) { var btn = new Button { Text = $"{productIssueds[i].product_code}\r{productIssueds[i].product_name}\r{productIssueds[i].lot_no}", Width = 190, Height = 100, FlatStyle = FlatStyle.Flat, Font = new Font("Kanit", 12), BackColor = Color.White, Tag = i.ToString() }; buttons.Add(btn); btn.Click += Btn_Click; Index = 0; } DisplayPaging(); } }
private void LoadData() { var productCode = ddlProduct.SelectedValue.ToString(); //if (string.IsNullOrEmpty(productCode)) //{ // return; //} using (var db = new SlaughterhouseEntities()) { var plant = db.plants.Find(plantID); var barcodes = db.barcodes.Where(p => p.production_date == plant.production_date && p.product_code == productCode); //if (!string.IsNullOrEmpty(productCode)) //{ // barcodes = barcodes.Where(p => p.product_code == productCode); //} var coll = barcodes.Select(p => new { p.barcode_no, p.product.product_code, p.product.product_name, p.lot_no, quantity = p.qty, weight = p.wgh }).OrderByDescending(p => p.barcode_no).ToList(); gv.DataSource = coll; } }
private void LoadData() { using (var db = new SlaughterhouseEntities()) { var qry = db.receives.Where(p => (p.farm_qty - p.factory_qty) > 0 && p.receive_flag != 2).ToList(); var coll = qry.AsEnumerable().Select(p => new { p.receive_no, receive_date = p.receive_date.ToString("dd-MM-yyyy"), p.transport_doc_no, p.truck.truck_no, p.farm.farm_name, p.coop_no, p.queue_no, p.breeder.breeder_name, farm_qty = p.farm_qty.ToComma(), farm_wgh = p.farm_wgh.ToFormat2Decimal() }).OrderBy(p => p.receive_no).ToList(); gv.DataSource = coll; gv.Columns[0].HeaderText = "เลขที่ใบรับ"; gv.Columns[1].HeaderText = "วันที่รับ"; gv.Columns[2].HeaderText = "เลขที่ใบส่ง"; gv.Columns[3].HeaderText = "ทะเบียนรถ"; gv.Columns[4].HeaderText = "ฟาร์ม"; gv.Columns[5].HeaderText = "เล้า"; gv.Columns[6].HeaderText = "คิวที่"; gv.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[7].HeaderText = "ประเภท"; gv.Columns[8].HeaderText = "จำนวน"; gv.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[9].HeaderText = "น้ำหนัก"; gv.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } }
private void LoadData(string receiveNo) { using (var db = new SlaughterhouseEntities()) { var receive = db.receives.Where(p => p.receive_no == receiveNo).SingleOrDefault(); lblReceiveNo.Text = receive.receive_no; lblFarm.Text = receive.farm.farm_name; lblBreeder.Text = receive.breeder.breeder_name; lblTruckNo.Text = receive.truck_no; lblQueueNo.Text = receive.queue_no.ToString(); lblFarmQty.Text = receive.farm_qty.ToComma(); lblFactoryQty.Text = receive.factory_qty.ToComma(); lblFactoryWgh.Text = receive.factory_wgh.ToFormatNoDecimal(); var remain_qty = receive.farm_qty - receive.factory_qty; lblRemainQty.Text = remain_qty.ToComma(); if (remain_qty == 0) { btnStart.Enabled = false; //BtnCloseQueue.Enabled = true; } else { btnStart.Enabled = true; } } lblMessage.Text = Constants.START_WAITING; }
private void LoadData(string receiveNo) { using (var db = new SlaughterhouseEntities()) { var receive = db.receives.Where(p => p.receive_no == receiveNo).SingleOrDefault(); int stock_qty = receive.receive_item.Where(p => p.product_code.Equals(product.product_code)).Sum(p => p.receive_qty); decimal stock_wgh = receive.receive_item.Where(p => p.product_code.Equals(product.product_code)).Sum(p => p.receive_wgh); int remain_qty = receive.farm_qty - stock_qty; lblReceiveNo.Text = receive.receive_no; lblFarm.Text = receive.farm.farm_name; lblBreeder.Text = receive.breeder.breeder_name; lblTruckNo.Text = receive.truck_no; lblQueueNo.Text = receive.queue_no.ToString(); lblSwineQty.Text = receive.factory_qty.ToComma(); lblStockQty.Text = stock_qty.ToComma(); lblStockWgh.Text = stock_wgh.ToFormat2Decimal(); lblRemainQty.Text = remain_qty.ToComma(); if (remain_qty == 0) { btnStart.Enabled = false; } else { btnStart.Enabled = true; } } lblMessage.Text = Constants.START_WAITING; }
private void LoadTruck() { flowLayoutPanel1.Controls.Clear(); buttons = new List <Button>(); using (var db = new SlaughterhouseEntities()) { var trucks = db.trucks.Where(p => p.active == true).Select(p => new { p.truck_no, }) .ToList(); foreach (var item in trucks) { var btn = new Button { Text = item.truck_no, Width = 190, Height = 80, FlatStyle = FlatStyle.Flat, Font = new Font("Kanit", 14), BackColor = Color.WhiteSmoke, Tag = item.truck_no }; buttons.Add(btn); btn.Click += Btn_Click; DisplayPaging(); } } }
private void LoadProduct() { using (var db = new SlaughterhouseEntities()) { var plant = db.plants.Find(plantID); var sql = ""; if (IsMainProduct) { sql = @"SELECT distinct a.product_code,b.product_name FROM basic_yield_info a,product b WHERE a.product_code =b.product_code and a.production_date =@production_date"; } else { sql = @"SELECT distinct a.product_code,b.product_name FROM special_yield_info a,product b WHERE a.product_code =b.product_code and a.production_date =@production_date"; } var coll = db.Database.SqlQuery <ProductReceived>(sql, new MySqlParameter("production_date", plant.production_date)).ToList(); //var coll = db.barcodes.Where(p => p.production_date == plant.production_date).ToList(); //coll.Insert(0, new ProductReceived //{ // product_code = "", // product_name = "--เลือก--" //}); ddlProduct.DisplayMember = "product_name"; ddlProduct.ValueMember = "product_code"; ddlProduct.DataSource = coll.ToList(); //ddlProduct.SelectedIndex = 0; } }
private void LoadBomItem(int bomCode) { using (var db = new SlaughterhouseEntities()) { //var bom = db.boms.Where(p => p.bom_code == bomCode).SingleOrDefault(); //lblCaption.Text = bom.product.product_name; var bomItems = db.bom_item.Where(p => p.bom_code == bomCode).ToList(); //lblMinWeight.Text = product.min_weight.ToString(); //lblMaxWeight.Text = product.max_weight.ToString(); flowLayoutPanel1.Controls.Clear(); buttons = new List <Button>(); foreach (var item in bomItems) { var btn = new Button { Text = item.product.product_name, Width = 200, Height = 80, FlatStyle = FlatStyle.Flat, Font = new Font("Kanit", 14), BackColor = Color.WhiteSmoke, Tag = item.product_code }; buttons.Add(btn); btn.Click += Btn_Click; //flowLayoutPanel1.Controls.Add(btn); DisplayPaging(); } } }
private void LoadLocation() { using (var db = new SlaughterhouseEntities()) { var locations = db.locations.Where(p => _locations.Contains(p.location_code)).ToList(); cboLocation.DisplayMember = "location_name"; cboLocation.ValueMember = "location_code"; cboLocation.DataSource = locations; //flowLayoutPanel1.Controls.Clear(); //buttons = new List<Button>(); //foreach (var item in locations) //{ // var btn = new Button // { // Text = item.location_name, // Width = 150, // Height = 80, // FlatStyle = FlatStyle.Flat, // Font = new Font("Kanit", 14), // BackColor = Color.WhiteSmoke, // Tag = item.location_code // }; // buttons.Add(btn); // btn.Click += Btn_Click; // DisplayPaging(); //} } }
private void LoadData() { using (var db = new SlaughterhouseEntities()) { var productionDate = db.plants.Find(plantID).production_date; var sql = ""; MySqlParameter[] parameters; if (string.IsNullOrEmpty(_productCode)) { sql = @"select distinct ord.order_no,ord.order_date,ord.customer_code,ord.comments,cus.customer_name,cus.address from orders as ord,orders_item as ord_item,customer cus where ord.order_no = ord_item.order_no and ord.customer_code =cus.customer_code and ord.order_flag =0 and ord.invoice_flag =0 and (ord_item.order_qty - ord_item.unload_qty)>0"; var qry = db.Database.SqlQuery <CustomerOrder>(sql).ToList(); var coll = qry.AsEnumerable().Select(p => new { p.order_no, order_date = p.order_date.ToString("dd-MM-yyyy"), p.customer_name, p.address, p.comments }).ToList(); gv.DataSource = coll; } else { sql = @"select distinct ord.order_no,ord.order_date,ord.customer_code,ord.comments,cus.customer_name,cus.address from orders as ord,orders_item as ord_item,customer cus where ord.order_no = ord_item.order_no and ord.customer_code =cus.customer_code and ord_item.product_code =@product_code and ord.order_flag =0 and ord.invoice_flag =0 and (ord_item.order_qty - ord_item.unload_qty)>0"; parameters = new[] { new MySqlParameter("@product_code", _productCode), }; var qry = db.Database.SqlQuery <CustomerOrder>(sql, parameters).ToList(); var coll = qry.AsEnumerable().Select(p => new { p.order_no, order_date = p.order_date.ToString("dd-MM-yyyy"), p.customer_name, p.address, p.comments }).ToList(); gv.DataSource = coll; } gv.Columns[0].HeaderText = "เลขที่"; gv.Columns[1].HeaderText = "วันที่เอกสาร"; gv.Columns[2].HeaderText = "ลูกค้า"; gv.Columns[3].HeaderText = "ที่อยู่"; gv.Columns[4].HeaderText = "หมายเหตุ"; } }
private bool SaveData() { try { decimal receiveWgh = lblWeight.Text.ToDecimal(); string createBy = Helper.GetLocalIPAddress(); barcode_no = Helper.GetMaxBarcode(); using (var db = new SlaughterhouseEntities()) { using (DbContextTransaction transaction = db.Database.BeginTransaction()) { try { //insert barcode var barcode = new barcode { barcode_no = barcode_no, product_code = productIssued.product_code, production_date = productionDate, lot_no = productIssued.lot_no, qty = 1, wgh = receiveWgh, active = true, create_by = createBy, qrcode_image = Helper.GenerateQRCode(barcode_no.ToString()), //location_code = locationCode }; db.barcodes.Add(barcode); //insert basic_yield_info var basicYield = new basic_yield_info { production_date = productionDate, product_code = barcode.product_code, lot_no = barcode.lot_no, quantity = barcode.qty, weight = barcode.wgh, ref_product_code = PRODUCT_CODE, ref_lot_no = barcode.lot_no.Substring(0, barcode.lot_no.Length - 4), barcode_no = barcode_no, create_by = createBy }; db.basic_yield_info.Add(basicYield); db.SaveChanges(); transaction.Commit(); return(true); } catch (Exception) { transaction.Rollback(); throw; } } } } catch (Exception) { throw; } }
private void Form_Load(object sender, EventArgs e) { using (var db = new SlaughterhouseEntities()) { int plantID = System.Configuration.ConfigurationManager.AppSettings["plantID"].ToInt16(); var plant = db.plants.Find(plantID); lblCurrentDatetime.Text = plant.production_date.ToString("dd-MM-yyyy"); } }
//private void LoadStock() //{ // using (var db = new SlaughterhouseEntities()) // { // var stocks = db.stocks.Where(p => p.stock_date == productionDate // && p.product_code == product_code // && p.lot_no == lot_no // && p.transaction_type == 1).Select(p => new // { // p.barcode_no, // p.stock_qty, // p.stock_wgh // }).ToList(); // //var stock = (from s in db.stocks // // where (s.product_code == product_code && s.lot_no == lot_no && s.transaction_type == 1 && s.stock_date == DateTime.Today) // // group s by 1 into g // // select new // // { // // stock_qty = g.Sum(x => x.stock_qty), // // stock_wgh = g.Sum(x => x.stock_wgh), // // }); // //from p in m.Items // //group p by 1 into g // //select new // //{ // // SumTotal = g.Sum(x => x.Total), // // SumDone = g.Sum(x => x.Done) // //}; // int stock_qty = stocks.Sum(p => p.stock_qty); // decimal stock_wgh = stocks.Sum(p => p.stock_wgh); // lblStockQty.Text = stock_qty.ToComma(); // lblStockWgh.Text = stock_wgh.ToFormat2Decimal(); // if (stocks.Count > 0) // { // lblLastWeight.Text = stocks[stocks.Count - 1].stock_wgh.ToFormat2Decimal(); // barcode_no = stocks[stocks.Count - 1].barcode_no; // } // else // { // lblLastWeight.Text = 0.0.ToFormat2Double(); // barcode_no = 0; // } // } //} private void LoadLotNo() { flowLayoutPanel1.Controls.Clear(); buttons = new List <Button>(); List <string> lotNoList = new List <string>(); using (var db = new SlaughterhouseEntities()) { //รับชิ้นส่วนต้องอ้าง LOT หมูซีก // 00000 =หมูซีก var issuedInfos = db.issued_info.Where(p => p.issued_date == productionDate && p.product_code == PRODUCT_CODE).ToList(); string lotProductionDate = productionDate.ToString("ddMM"); //if (issuedInfos.Count == 0) //{ // var sqlParams = new[]{ // new MySqlParameter("@transport_date",productionDate), // new MySqlParameter("@product_code", "00000") // }; // // ไปหา lot ออกขาย // var sql = @"select distinct lot_no from transport a,transport_item b // where a.transport_no =b.transport_no // and a.transport_date =@transport_date // and b.product_code =@product_code"; // var saleLotList = db.Database.SqlQuery<string>(sql, sqlParams).ToList(); // foreach (string item in saleLotList) // { // lotNoList.Add(item.ToString()); // } //} //else //{ // foreach (var item in issuedInfos) // { // lotNoList.Add(item.lot_no); // } //} foreach (var item in issuedInfos) { var lotno = $"{item.lot_no}{plantID}{lotProductionDate}"; var btn = new Button { Text = lotno, Width = 180, Height = 80, FlatStyle = FlatStyle.Flat, Font = new Font("Kanit", 14), BackColor = Color.WhiteSmoke, Tag = lotno }; buttons.Add(btn); btn.Click += Btn_Click; } Index = 0; DisplayPaging(); } }
private void LoadProduct(string productCode) { using (var db = new SlaughterhouseEntities()) { product = db.products.Where(p => p.product_code == productCode).SingleOrDefault(); lblMinWeight.Text = product.min_weight.ToString(); lblMaxWeight.Text = product.max_weight.ToString(); } }
private void LoadRMIssuedInfo() { try { using (var db = new SlaughterhouseEntities()) { //var barcode = db.barcodes.Find(txtBarcodeNo.Text.ToLong()); //barcodeIssuedList.Add(new barcode //{ // barcode_no = barcode.barcode_no, // product_code = barcode.product_code, // product = barcode.product, // lot_no = barcode.lot_no, // qty = barcode.qty, // wgh = barcode.wgh, // modified_at = barcode.modified_at //}); var qry = db.rm_issued_info.Where(p => p.production_date == productionDate) .OrderByDescending(p => p.create_at).ToList(); var coll = qry.AsEnumerable().Select(p => new { p.barcode_no, p.product_code, p.product.product_name, p.lot_no, p.quantity, p.weight, create_at = p.create_at.ToString("dd/MM/yyyy HH:mm") }).ToList(); gv.DataSource = coll; gv.Columns[0].HeaderText = "รหัส"; gv.Columns[1].HeaderText = "รหัสสินค้า"; gv.Columns[2].HeaderText = "ชื่อสินค้า"; gv.Columns[3].HeaderText = "Lot No."; gv.Columns[4].HeaderText = "จำนวน"; gv.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[5].HeaderText = "น้ำหนัก"; gv.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[6].HeaderText = "วันเวลาสแกน"; } //var coll = barcodeIssuedList.Select(p => new //{ // p.barcode_no, // p.product_code, // p.product.product_name, // p.lot_no, // qty = p.qty.ToComma(), // wgh = p.wgh.ToFormat2Decimal(), // modified_at = p.modified_at == null ? "" : Convert.ToDateTime(p.modified_at).ToString("dd-MM-yyyy HH:mm") //}).OrderByDescending(p => p.modified_at).ToList(); } catch (Exception) { throw; } }
private void LoadData() { using (var db = new SlaughterhouseEntities()) { var productionDate = db.plants.Find(plantID).production_date; var qry = db.receives.Where(p => p.receive_flag == 1 && p.receive_date == productionDate).ToList(); //switch (ProductCode) //{ // case "00000": //หมูซีก // qry = qry.Where(p => p.farm_qty > p.carcass_qty).ToList(); // break; // case "0000A": //หมูซีก 1 ซีก // qry = qry.Where(p => p.farm_qty > p.carcass_qty).ToList(); // break; // case "00101"://เครื่องในแดง // //qry = qry.Where(p => p.farm_qty > p.byproduct_red_qty).ToList(); // break; // case "00201"://เครื่องในขาว // //qry = qry.Where(p => p.farm_qty > p.byproduct_white_qty).ToList(); // break; // case "04001"://หัวหมู // qry = qry.Where(p => p.farm_qty > p.head_qty).ToList(); // break; //} var coll = qry.AsEnumerable().Select(p => new { p.receive_no, receive_date = p.receive_date.ToString("dd-MM-yyyy"), p.transport_doc_no, p.truck.truck_no, p.farm.farm_name, p.coop_no, p.queue_no, p.breeder.breeder_name, p.lot_no, farm_qty = p.farm_qty.ToComma(), farm_wgh = p.farm_wgh.ToFormat2Decimal() }).ToList(); gv.DataSource = coll; gv.Columns[0].HeaderText = "เลขที่ใบรับ"; gv.Columns[1].HeaderText = "วันที่รับ"; gv.Columns[2].HeaderText = "เลขที่ใบส่ง"; gv.Columns[3].HeaderText = "ทะเบียนรถ"; gv.Columns[4].HeaderText = "ฟาร์ม"; gv.Columns[5].HeaderText = "เล้า"; gv.Columns[6].HeaderText = "คิวที่"; gv.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[7].HeaderText = "ประเภท"; gv.Columns[8].HeaderText = "Lot No"; gv.Columns[9].HeaderText = "จำนวน"; gv.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[10].HeaderText = "น้ำหนัก"; gv.Columns[10].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } }
private void LoadProduct() { using (var db = new SlaughterhouseEntities()) { product = db.products.Where(p => p.product_code.Equals(productIssued.product_code)).SingleOrDefault(); lblProduct.Text = product.product_name; lblMinWeight.Text = product.min_weight.ToString(); lblMaxWeight.Text = product.max_weight.ToString(); lblLotNo.Text = productIssued.lot_no; } }
//private void SuggestMessage() //{ // try // { // if (string.IsNullOrEmpty(lblOrderNo.Text)) // { // } // if (string.IsNullOrEmpty(lblTruckNo.Text)) // { // } // } // catch (Exception) // { // throw; // } //} private void LoadOrder() { try { using (var db = new SlaughterhouseEntities()) { var order = db.orders.Find(lblOrderNo.Text); //lblOrderNo.Text = order.order_no; lblCustomer.Text = order.customer.customer_name; lblOrderDate.Text = order.order_date.ToString("dd-MM-yyyy"); var transport = db.transports.Where(p => p.ref_document_no == order.order_no).SingleOrDefault(); if (transport != null) { cboTruckNo.SelectedValue = transport.truck_id; lblMessage.Text = Constants.PLEASE_SCAN; } else { lblMessage.Text = Constants.CHOOSE_TRUCK; } txtBarcodeNo.Focus(); var coll = (from or in order.orders_item join bom in db.boms on or.bom_code equals bom.bom_code join p in db.products on bom.product_code equals p.product_code select new { or.seq, or.product.product_name, bom_name = p.product_name, or.order_qty, or.order_wgh, or.unload_qty, or.unload_wgh }).OrderBy(p => p.seq).ToList(); gv.DataSource = coll; gv.Columns[0].HeaderText = "ลำดับ"; gv.Columns[1].HeaderText = "สินค้า"; gv.Columns[2].HeaderText = "ชื่อชุด"; gv.Columns[3].HeaderText = "จำนวนสั่ง"; gv.Columns[4].HeaderText = "น้ำหนักสั่ง"; gv.Columns[5].HeaderText = "จำนวนจ่าย"; gv.Columns[6].HeaderText = "น้ำหนักจ่าย"; gv.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gv.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } } catch (Exception) { throw; } }
private void LoadProduct() { int productGroupCode = ddlProductGroup.SelectedValue.ToString().ToInt16(); flowLayoutPanel1.Controls.Clear(); buttons = new List <Button>(); string productCode = lblProductCode.Text; using (var db = new SlaughterhouseEntities()) { var qry = db.products.Where(p => p.active == true && p.product_group_code == productGroupCode && p.product_code.Contains(productCode)); //if (!string.IsNullOrEmpty(productCode)) //{ // qry = qry.Where(p => p.product_code.Contains(productCode)); //} //else //{ // if (productGroupCode > 0) // { // qry = qry.Where(p => p.product_group_code == productGroupCode); // } //} var products = qry.ToList(); //var products = db.products.Where(p => p.product_group_code == productGroupCode // && p.active == true // && p.product_code.Contains(productCode)) // .Select(p => new // { // p.product_code, // p.product_name // }).ToList(); foreach (var item in products) { var btn = new Button { Text = $"{item.product_code}\r{item.product_name}", Width = 190, Height = 80, FlatStyle = FlatStyle.Flat, Font = new Font("Kanit", 12), BackColor = Color.White, Tag = item.product_code }; buttons.Add(btn); btn.Click += Btn_Click; Index = 0; } DisplayPaging(); } }
public Form_ByProduct(string title, int bomCode, int locationCode) { InitializeComponent(); UserInitialization(); _locationCode = locationCode; lblCaption.Text = title; using (var db = new SlaughterhouseEntities()) { bom = db.boms.Where(p => p.bom_code == bomCode).SingleOrDefault(); } }
public static DataTable GetBarcode(long barcode_no) { try { using (var db = new SlaughterhouseEntities()) { var barcode = db.barcodes.Where(p => p.barcode_no == barcode_no).SingleOrDefault(); DataTable dt = new DataTable("Barcode"); dt.Columns.Add("barcode_no", typeof(string)); dt.Columns.Add("barcode_no_text", typeof(string)); dt.Columns.Add("barcode_info", typeof(string)); dt.Columns.Add("product_code", typeof(string)); dt.Columns.Add("product_name", typeof(string)); dt.Columns.Add("production_date", typeof(DateTime)); dt.Columns.Add("expired_date", typeof(DateTime)); dt.Columns.Add("lot_no", typeof(string)); dt.Columns.Add("qty", typeof(int)); dt.Columns.Add("qty_unit", typeof(string)); dt.Columns.Add("wgh", typeof(double)); dt.Columns.Add("wgh_unit", typeof(string)); dt.Columns.Add("qr_code", typeof(byte[])); dt.Columns.Add("bar_qr_code", typeof(byte[])); DataRow dr = dt.NewRow(); string qrData = string.Format("00{0}{1}", barcode.product_code, Convert.ToInt64(barcode.wgh * 10000).ToString().PadLeft(6, '0')); //string barcode_no_text = string.Format("1{0}", barcode.barcode_no.ToString().PadLeft(12, '0')); dr["barcode_no"] = string.Format("*{0}*", barcode.barcode_no); dr["barcode_no_text"] = barcode.barcode_no; dr["barcode_info"] = qrData; dr["product_code"] = barcode.product_code; dr["product_name"] = barcode.product.product_name; dr["production_date"] = barcode.production_date; dr["expired_date"] = barcode.production_date.AddDays(barcode.product.shelflife.ToString().ToDouble()); dr["lot_no"] = barcode.lot_no; dr["qty"] = barcode.qty; dr["qty_unit"] = barcode.product.unit_of_measurement.unit_name; dr["wgh"] = barcode.wgh; dr["wgh_unit"] = barcode.product.unit_of_measurement1.unit_name; dr["qr_code"] = GenerateQRCode(qrData); dr["bar_qr_code"] = GenerateQRCode(barcode.barcode_no.ToString()); dt.Rows.Add(dr); string path = Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), @"..\..\Report\xml\")); //dt.WriteXml(path + @"barcode_qr.xml", XmlWriteMode.WriteSchema); return(dt); } } catch (Exception) { throw; } }
private void LoadProductGroup() { using (var db = new SlaughterhouseEntities()) { var coll = db.product_group.Where(p => p.product_group_code > 3).ToList(); coll.Insert(0, new product_group { product_group_code = 0, product_group_name = "--เลือก--" }); ddlProductGroup.DisplayMember = "product_group_name"; ddlProductGroup.ValueMember = "product_group_code"; ddlProductGroup.DataSource = coll.ToList(); ddlProductGroup.SelectedIndex = 0; } }
//private void LoadProduct() //{ // //flowLayoutPanel1.Controls.Clear(); // using (var db = new SlaughterhouseEntities()) // { // var products = db.products.Where(p => p.product_group_code == 2).ToList(); // foreach (var item in products) // { // var btn = new Button // { // Text = item.product_name, // Width = 150, // Height = 80, // FlatStyle = FlatStyle.Flat, // Font = new Font("Kanit", 16), // BackColor = Color.WhiteSmoke, // Tag = item.product_code // }; // btn.Click += Btn_Click; // flowLayoutPanel1.Controls.Add(btn); // } // } //} //private void Btn_Click(object sender, EventArgs e) //{ // foreach (Control ctrl in flowLayoutPanel1.Controls) // { // var b = (Button)ctrl; // b.BackColor = Color.WhiteSmoke; // b.ForeColor = Color.Black; // } // var btn = (Button)sender; // btn.BackColor = ColorTranslator.FromHtml("#2D9CDB"); // btn.ForeColor = Color.White; // productCode = btn.Tag.ToString(); // lblMessage.Text = WEIGHT_WAITING; //} private void LoadData(string receiveNo) { using (var db = new SlaughterhouseEntities()) { var receive = db.receives.Where(p => p.receive_no == receiveNo).SingleOrDefault(); //int stock_qty = receive.receive_item.Where(p => p.product_code.Equals(product.product_code)).Sum(p => p.receive_qty); //decimal stock_wgh = receive.receive_item.Where(p => p.product_code.Equals(product.product_code)).Sum(p => p.receive_wgh); //int remain_qty = receive.farm_qty - stock_qty; lblReceiveNo.Text = receive.receive_no; lblFarm.Text = receive.farm.farm_name; lblBreeder.Text = receive.breeder.breeder_name; lblTruckNo.Text = receive.truck.truck_no; lblQueueNo.Text = receive.queue_no.ToString(); } }
private void LoadData() { using (var db = new SlaughterhouseEntities()) { var qry = db.production_order.Where(p => p.po_flag == 0).ToList(); var coll = qry.AsEnumerable().Select(p => new { p.po_no, p.po_date, p.comments, }).ToList(); gv.DataSource = coll; gv.Columns[0].HeaderText = "เลขที่เอกสาร"; gv.Columns[1].HeaderText = "วันที่เอกสาร"; gv.Columns[2].HeaderText = "หมายเหตุ"; } }
private void Form_Load(object sender, EventArgs e) { try { using (var db = new SlaughterhouseEntities()) { coreProduct = db.products.Find(CoreProductCode); lblCaption.Text = coreProduct.product_name; //lblMinWeight.Text = product.min_weight.ToString(); //lblMaxWeight.Text = product.max_weight.ToString(); //lblProduct.Text = product.product_name; //lblCaption.Text = product.product_name; plantID = System.Configuration.ConfigurationManager.AppSettings["plantID"].ToInt16(); productionDate = db.plants.Find(plantID).production_date; lblCurrentDatetime.Text = productionDate.ToString("dd-MM-yyyy"); lblWeight.Text = 0.00.ToString(); //lblQty.Text = DEFAULT_QTY.ToString(); //var products = db.products.Where(p => p.product_group_code == product.product_group_code).ToList(); //flowLayoutPanel1.Controls.Clear(); //buttons = new List<System.Windows.Forms.Button>(); //foreach (var item in products) //{ // var btn = new System.Windows.Forms.Button // { // Text = $"{item.product_code}\r{item.product_name}", // Width = 180, // Height = 80, // FlatStyle = FlatStyle.Flat, // Font = new Font("Kanit", 14), // BackColor = Color.WhiteSmoke, // Tag = item.product_code // }; // buttons.Add(btn); // btn.Click += Btn_Click; //} //DisplayPaging(); //productList = new List<product>(); } customProducts = new List <CustomProduct>(); lblMessage.Text = Constants.CHOOSE_QUEUE; } catch (Exception ex) { lblMessage.Text = ex.Message; } }
private void PrintBarcode() { try { using (var db = new SlaughterhouseEntities()) { var barcode = db.barcodes.Where(p => p.barcode_no == barcode_no).SingleOrDefault(); DataTable dt = new DataTable("Barcode"); dt.Columns.Add("barcode_no", typeof(string)); dt.Columns.Add("barcode_no_text", typeof(string)); dt.Columns.Add("product_code", typeof(string)); dt.Columns.Add("product_name", typeof(string)); dt.Columns.Add("production_date", typeof(DateTime)); dt.Columns.Add("expired_date", typeof(DateTime)); dt.Columns.Add("lot_no", typeof(string)); dt.Columns.Add("qty", typeof(int)); dt.Columns.Add("qty_unit", typeof(string)); dt.Columns.Add("wgh", typeof(double)); dt.Columns.Add("wgh_unit", typeof(string)); DataRow dr = dt.NewRow(); dr["barcode_no"] = string.Format("*{0}*", barcode.barcode_no); dr["barcode_no_text"] = barcode.barcode_no.ToString(); dr["product_code"] = barcode.product_code; dr["product_name"] = barcode.product.product_name; dr["production_date"] = barcode.production_date; dr["expired_date"] = barcode.production_date.AddDays(barcode.product.shelflife.ToString().ToDouble()); dr["lot_no"] = barcode.lot_no; dr["qty"] = barcode.qty; dr["qty_unit"] = barcode.product.unit_of_measurement.unit_name; dr["wgh"] = barcode.wgh; dr["wgh_unit"] = barcode.product.unit_of_measurement1.unit_name; dt.Rows.Add(dr); //string path = Path.GetFullPath(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"\Report\Rpt\"));//Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), @"..\..\Report")); //dt.WriteXml(path + @"\xml\barcode.xml", XmlWriteMode.WriteSchema); doc.SetDataSource(dt); doc.PrintToPrinter(1, true, 0, 0); btnPrint.Enabled = false; } } catch (Exception) { throw; } }
private void Btn_Click(object sender, EventArgs e) { try { //var foundPart = false; //foreach (var item in customProducts) //{ // if (item.ProductCode != CoreProductCode) // { // if (item.ReciveQty > 0) // { // foundPart = true; // break; // } // } //} //if (foundPart) //{ // throw new Exception("ไม่สามารถรับสินค้าชุดได้\rเนื่องจากรับชิ้น"); //} var btn = (System.Windows.Forms.Button)sender; var receiveNo = lblReceiveNo.Text; var productSelectedCode = btn.Tag.ToString(); using (var db = new SlaughterhouseEntities()) { productSelected = db.products.Find(productSelectedCode); if (productSelected == null) { return; } lblQty.Text = DEFAULT_QTY.ToString(); lblMinWeight.Text = (productSelected.min_weight * int.Parse(lblQty.Text)).ToString(); lblMaxWeight.Text = (productSelected.max_weight * int.Parse(lblQty.Text)).ToString(); btnStart.Enabled = true; lblSelectedProduct.Text = $"{productSelected.product_code}: {productSelected.product_name}"; firstTime = true; } //btn.BackColor = ColorTranslator.FromHtml("#1C6BBC"); //btn.ForeColor = Color.White; } catch (Exception ex) { DisplayNotification("Error", ex.Message, Color.Red); } }