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