public void LoadListPlannedOrder()
{
dtgPlannedOrder.DataSource = PlanndeBusiness.GetListAvailblePlannedOrder();
dtgPlannedOrder.Columns[0].HeaderText = "Planned Order Number";
dtgPlannedOrder.Columns[1].HeaderText = "Mã sản phẩm";
dtgPlannedOrder.Columns[2].HeaderText = "Số lượng";
dtgPlannedOrder.Columns[3].HeaderText = "Plant";
dtgPlannedOrder.Columns[4].HeaderText = "Kho";
dtgPlannedOrder.Columns[5].HeaderText = "Tên sản phẩm";
dtgPlannedOrder.Columns[6].HeaderText = "Ngày sửa đổi";
dtgPlannedOrder.Columns[7].HeaderText = "Tài khoản";
dtgPlannedOrder.Columns[8].HeaderText = "Trạng thái";
//dtgPlannedOrder.Columns[8] = new DataGridViewCheckBoxColumn();
}
public void ShowInfo(int plnum)
{
dtgPlannedOrderDetail.DataSource = DetailBusiness.GetListDetailFromPlnum(plnum);
Plannde objPlannedOrder = PlanndeBusiness.GetPlannde(plnum);
txtMaterial.Text = objPlannedOrder.matnr;
txtOrderQuantitty.Text = objPlannedOrder.gsmng.ToString();
txtDocumentName.Text = objPlannedOrder.maktx.ToString();
txtPlanNumber.Text = objPlannedOrder.plnum.ToString();//
txtStog.Text = objPlannedOrder.lgort;
//dtgPlannedOrderDetail.Columns["plnum"].DisplayIndex = 0;
//dtgPlannedOrderDetail.Columns["matnr"].DisplayIndex = 1;
//dtgPlannedOrderDetail.Columns["maktx"].DisplayIndex = 2;
//dtgPlannedOrderDetail.Columns["erfmg"].DisplayIndex = 3;
//dtgPlannedOrderDetail.Columns["count"].DisplayIndex = 4;
//dtgPlannedOrderDetail.Columns["erfme"].DisplayIndex = 5;
//dtgPlannedOrderDetail.Columns["plwrk"].DisplayIndex = 6;
//dtgPlannedOrderDetail.Columns["lgpro"].DisplayIndex = 7;
//dtgPlannedOrderDetail.Columns["charg"].DisplayIndex = 8;
//dtgPlannedOrderDetail.Columns["posnr"].DisplayIndex = 9;
dtgPlannedOrderDetail.Columns["plnum"].HeaderText = "Planned order";
dtgPlannedOrderDetail.Columns["plnum"].Visible = false;
dtgPlannedOrderDetail.Columns[1].HeaderText = "Mã sản phẩm con";
dtgPlannedOrderDetail.Columns[2].HeaderText = "Tên sản phẩm con";
dtgPlannedOrderDetail.Columns[3].HeaderText = "Số lượng ban đầu";
dtgPlannedOrderDetail.Columns[4].HeaderText = "SỐ LƯỢNG THỰC TẾ";
dtgPlannedOrderDetail.Columns[5].HeaderText = "Đơn vị tính";
dtgPlannedOrderDetail.Columns[6].HeaderText = "Plant";
dtgPlannedOrderDetail.Columns[7].HeaderText = "Kho";
dtgPlannedOrderDetail.Columns[8].HeaderText = "Số batch";
dtgPlannedOrderDetail.Columns[9].HeaderText = "Số thứ tự";
dtgPlannedOrderDetail.Columns["dateCreated"].Visible = false;
dtgPlannedOrderDetail.Columns["dateEdited"].Visible = false;
dtgPlannedOrderDetail.Columns["status"].Visible = false;
}
private void CheckPlan()
{
try
{
int plnum = int.Parse(txtDocument.Text);
Plannde objPlan = PlanndeBusiness.GetPlannde(plnum);
//Trường hợp nếu đã tồn tại plan này và đã post
if (objPlan != null && objPlan.status == true)
{
string query = "update dbo.PlannedOrder set status = 0 where plnum =" + plnum;
DataProvider.Execute(query, null, false);
frmDocumentDetail f = new frmDocumentDetail(plnum, lblAccount.Text);
txtDocument.Clear();
this.Hide();
f.ShowDialog();
this.Show();
}
else
{
List <Plannde> lstPlan = PlanndeBusiness.GetListPlannedOrder();
int planCount = 0;
foreach (Plannde item in lstPlan)
{
if (item.plnum == plnum.ToString())
{
planCount++;
}
}
if (planCount == 1)
{
LoadListPlannedOrder();
frmDocumentDetail f = new frmDocumentDetail(plnum, lblAccount.Text);
txtDocument.Clear();
this.Hide();
f.ShowDialog();
this.Show();
}
else
{
AccessToken objToken = DataProvider.GetTokenDictionary("*****@*****.**", "Wuvl@1234", ConfigurationManager.AppSettings["tokenUrl"].ToString());
string url = ConfigurationManager.AppSettings["get_planned_order"].ToString() + plnum;
string jsonString = DataProvider.GetRESTDats(url, objToken.accessToken.ToString());
List <Plannde> lstPlannedOrder = new List <Plannde>();
lstPlannedOrder = JsonConvert.DeserializeObject <List <Plannde> >(jsonString);
if (lstPlannedOrder.Count == 0)
{
txtDocument.BackColor = Color.OrangeRed;
MessageBox.Show("K tồn tại Planned Order bạn muốn tìm!", "Thong bao!");
txtDocument.Clear();
txtDocument.BackColor = Color.White;
}
else
{
PlanndeBusiness.AddPlannedOrder(lstPlannedOrder[0]);
var lstPlannedOrderDetail = lstPlannedOrder[0].detail.ToList();
foreach (Detail item in lstPlannedOrderDetail)
{
DetailBusiness.AddDetail(item, false);
}
LoadListPlannedOrder();
frmDocumentDetail f = new frmDocumentDetail(plnum, lblAccount.Text);
txtDocument.Clear();
this.Hide();
f.ShowDialog();
this.Show();
}
}
}
}
catch (FormatException)
{
txtDocument.BackColor = Color.OrangeRed;
MessageBox.Show("Bạn nhập sai mã plan number!", "Thông báo!");
txtDocument.Clear();
txtDocument.BackColor = Color.White;
}
LoadListPlannedOrder();
}
private void BtnChooseBatch_Click(object sender, EventArgs e)
{
//Neu da ton tai plannedOrderDetail + Batch do thi + them
//Neu chua co batch do cho plannedOrderDetail do thi add 1 dong moi
string matnr = txtMatnr.Text;
List <Itemcode> lstItem = ItemCodeBusiness.GetITemList(matnr);
string maktx = lstItem[0].maktx;
int loai = int.Parse(lblLoai.Text);
int plnum = int.Parse(lblPlnum.Text);
double count = (double)nmItemCount.Value;
string charg = "";
string erfme = txtErfme.Text;
List <string> lstBatch = BatchBusiness.GetBatchList2(plnum.ToString(), matnr);
if (lstBatch.Count == 0)
{
if (!String.IsNullOrEmpty(cboChooseBatch.Text))
{
MessageBox.Show("Không tồn tại batch tương ứng với Planned Order Detail này!", "Thông báo!");
return;
}
else
{
charg = "";
}
}
else
{
if (String.IsNullOrEmpty(cboChooseBatch.Text))
{
charg = "";
}
else
{
int i = 0;
foreach (string item in lstBatch)
{
if (item == cboChooseBatch.Text)
{
i++;
}
}
if (i == 0)
{
MessageBox.Show("Không tồn tại batch tương ứng với Planned Order Detail này!", "Thông báo!");
return;
}
else
{
charg = cboChooseBatch.Text;
}
}
}
//Xử lý trường hợp nếu item không có batch ( ví dụ 1 số sản phẩm như chai lọ)
//string lgort = (PlanndeBusiness.GetPlannedOrderFromPlnum(plnum)).lgort;
string lgort = txtlg.Text;
string lgpro = cboLgpro.SelectedItem.ToString();
int posnr = DetailBusiness.GetMaxPosnrFromMatnr(plnum);
//Truong hop da ton tai matnr do trong list Detail
//Them moi neu k trung batch, update neu trung batch
//Kiểm tra xem batch đó có trong danh sách batch tương ứng với
if (count == 0)
{
MessageBox.Show("So luong khong duoc bang 0!", "Thong bao!");
}
else
{
if (loai == 0)
{
Detail objDetail = DetailBusiness.GetDetail(matnr, plnum, lgpro, charg);
List <Detail> lstDetail = DetailBusiness.GetListDetailFromPlnum(plnum);
#region code thừa
//int i = 0;
//foreach (Detail item in lstDetail)
//{
// if (item.charg == charg && item.matnr == matnr)
// {
// i++;
// }
//}
#endregion
if (objDetail.charg == charg && objDetail.lgpro == lgpro)
{
//Neu da co thi update them erfmg
DetailBusiness.UpdateCountForDetail(plnum, objDetail.count + count, matnr, charg, lgpro);
}
else
{
//if (cboErfme.SelectedItem == null)
//{
// erfme = "";
//}
//Neu chua co thi add them
objDetail.plnum = plnum.ToString();
objDetail.matnr = matnr;
objDetail.maktx = maktx;
objDetail.charg = charg;
objDetail.erfmg = objDetail.erfmg;
objDetail.plwrk = PlanndeBusiness.GetPlannde(plnum).plwrk;
objDetail.posnr = (posnr + 10);
objDetail.erfme = erfme;
objDetail.lgpro = lgpro;
objDetail.count = count;
DetailBusiness.AddDetail(objDetail);
}
}
//Them moi 1 Detail
else
{
//if (cboErfme.SelectedItem == null)
//{
// erfme = "";
//}
//else
//{
Detail objDetail = new Detail();
objDetail.plnum = plnum.ToString();
objDetail.matnr = matnr;
objDetail.maktx = maktx;
objDetail.erfmg = 0;
objDetail.plwrk = PlanndeBusiness.GetPlannde(plnum).plwrk;
objDetail.lgpro = lgort;
objDetail.charg = charg;
objDetail.posnr = (posnr + 10);
objDetail.erfme = erfme;
objDetail.count = count;
DetailBusiness.AddDetail(objDetail);
//}
}
}
this.Close();
#region code cũ
/*
* string matnr = txtMatnr.Text;
* Detail objDetail = DetailBusiness.GetPlannedOrderDetailFromMatnr(matnr);
* List<Detail> lstPlannedOrderDetail = DetailBusiness.GetListPlannedOrderDetail(int.Parse(objDetail.plnum));
* string charg = (cboChooseBatch.SelectedItem as Batch).charg;
* Detail obj = DetailBusiness.GetPlannedOrderDetailFromMatnr(matnr);
* float plannedOrderDetailCount = float.Parse(nmItemCount.Value.ToString());
* int count = 0;
* foreach (Detail item in lstPlannedOrderDetail)
* {
* if (item.matnr == matnr && item.charg == charg)
* {
* count++;
* }
* }
* if (count > 0)
* {
* DetailBusiness.UpdateErfmgForPlannedOrderDetail(plannedOrderDetailCount + obj.erfmg, matnr, charg);
* }
* else
* {
* obj.erfmg = plannedOrderDetailCount;
* obj.charg = charg;
* obj.posnr = (DetailBusiness.GetMaxPosnrFromMatnr(matnr) + 10).ToString();
* DetailBusiness.AddPlannedOrderDetail(obj);
* }
*/
#endregion
}
private void BtnPost_Click(object sender, EventArgs e)
{
#region oldCode
//AccessToken objToken = DataProvider.GetTokenDictionary("*****@*****.**", "Wuvl@1234", @"http://ssm.unza.com.vn:88/token");
//string url = @"http://ssm.unza.com.vn:88/api/GET_PLANNED_ORDER?ZPLNUM=" + plnum;
//string jsonString = DataProvider.GetRESTDats(url, objToken.accessToken.ToString());
//List<Plannde> lstPlannedOrder = new List<Plannde>();
//lstPlannedOrder = JsonConvert.DeserializeObject<List<Plannde>>(jsonString);
//if (lstPlannedOrder.Count == 0)
//{
// MessageBox.Show("K tồn tại Planned Order bạn muốn tìm!", "Thong bao!");
//}
//else
//{
// PlanndeBusiness.AddPlannedOrder(lstPlannedOrder[0]);
// var lstPlannedOrderDetail = lstPlannedOrder[0].detail.ToList();
// foreach (Detail item in lstPlannedOrderDetail)
// {
// DetailBusiness.AddDetail(item);
// }
// LoadListPlannedOrder();
// frmDocumentDetail f = new frmDocumentDetail(plnum);
// this.Hide();
// f.ShowDialog();
// this.Show();
//}
#endregion
string query = "select count(*) as soLuong from PlannedOrderDetail where plnum = " + txtPlanNumber.Text + " and status = 1";
DataTable dt = DataProvider.GetList(query, null, false);
string soLuong = dt.Rows[0]["soLuong"].ToString();
string query1 = "select distinct count(matnr) as soLuong from PlannedOrderDetail where plnum = " + txtPlanNumber.Text;
DataTable dt1 = DataProvider.GetList(query1, null, false);
string soLuongGoc = dt1.Rows[0]["soLuong"].ToString();
if (MessageBox.Show("Số lượng hiện tại là " + soLuong + "/" + soLuongGoc + " \nBạn có chắc muốn gửi biểu mẫu này?", "Thông báo", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
List <Pnl> lstDetail = new List <Pnl>();
foreach (DataGridViewRow row in dtgPlannedOrderDetail.Rows)
{
Pnl pn = new Pnl();
pn.plnum = row.Cells["plnum"].Value.ToString();
pn.posnr = row.Cells["posnr"].Value.ToString();
pn.charg = row.Cells["charg"].Value.ToString();
pn.idnrk = row.Cells["matnr"].Value.ToString();
pn.menge = float.Parse(row.Cells["count"].Value.ToString());
pn.matnr = txtMaterial.Text;
lstDetail.Add(pn);
}
/*
* get data cua dtgPlannedOrderDetail ra ojb plannerorder*/
string url = ConfigurationManager.AppSettings["put_planned_order"].ToString() + lblAccount.Text;
AccessToken objToken = DataProvider.GetTokenDictionary("*****@*****.**", "Wuvl@1234", ConfigurationManager.AppSettings["tokenUrl"].ToString());
string jsonString = DataProvider.GetRESTDats3(url, objToken.accessToken.ToString(), lstDetail);
if (jsonString == "\"ok\"")
{
DetailBusiness.PUTDetail(int.Parse(txtPlanNumber.Text));
PlanndeBusiness.PUTPlannde(int.Parse(txtPlanNumber.Text));
}
//ShowInfo(int.Parse(txtPlanNumber.Text));
this.Close();
//load lại bảng planned Order
}
else
{
return;
}
}
