/// <summary>
/// ทำการตัด stock ที่ QtyAllow
/// </summary>
private void ConfirmISSOrder()
{
using (SSLsEntities db = new SSLsEntities())
{
var data = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == code);
data.FKSaleOrderWarehouseStatus = MyConstant.SaleOrderWarehouseStatus.WarehouseISS;
data.UpdateDate = DateTime.Now;
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(data).State = EntityState.Modified;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
int id = int.Parse(dataGridView1.Rows[i].Cells[colId].Value.ToString());
var dtl = data.SaleOrderWarehouseDtl.SingleOrDefault(w => w.Id == id);
dtl.QtyAllow = decimal.Parse(dataGridView1.Rows[i].Cells[colQtyAllow].Value.ToString());
dtl.UpdateDate = DateTime.Now;
dtl.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(dtl).State = EntityState.Modified;
}
db.SaveChanges();
data = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == code);
Library.MakeValueForUpdateStockWms(data.SaleOrderWarehouseDtl.Where(w => w.Enable == true).ToList());
this.saleOrderWarehouseTakeForm.LoadGrid();
this.Dispose();
}
}
/// <summary>
/// บันทึกการแก้ไข โดยไล่ Disable ตัวเดิมทิ้งให้หมด แล้ว add ใหม่
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button6_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?", "คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
using (SSLsEntities db = new SSLsEntities())
{
var order = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == code);
foreach (var item in order.SaleOrderWarehouseDtl.Where(w => w.Enable == true).ToList())
{
item.UpdateDate = DateTime.Now;
item.UpdateBy = SingletonAuthen.Instance().Id;
item.Enable = false;
db.Entry(item).State = EntityState.Modified;
}
List <SaleOrderWarehouseDtl> details = new List <SaleOrderWarehouseDtl>();
SaleOrderWarehouseDtl detail;
decimal discountList = 0;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
detail = new SaleOrderWarehouseDtl();
detail.FKSaleOrderWarehouse = order.Id;
detail.Enable = true;
detail.Description = dataGridView1.Rows[i].Cells[colRemark].Value.ToString();
detail.CreateDate = DateTime.Now;
detail.CreateBy = SingletonAuthen.Instance().Id;
detail.UpdateDate = DateTime.Now;
detail.UpdateBy = SingletonAuthen.Instance().Id;
detail.FKProductDtl = int.Parse(dataGridView1.Rows[i].Cells[colId].Value.ToString());
detail.Qty = decimal.Parse(dataGridView1.Rows[i].Cells[colQty].Value.ToString()); // จำนวนหน่วย
detail.PricePerUnit = decimal.Parse(dataGridView1.Rows[i].Cells[colPricePerUnit].Value.ToString()); // จำนวนหน่วย
detail.BathDiscount = decimal.Parse(dataGridView1.Rows[i].Cells[colDiscount].Value.ToString()); // จำนวนเงินส่วนลด
detail.TotalPrice = decimal.Parse(dataGridView1.Rows[i].Cells[colTotalPrice].Value.ToString()); // จำนวนเงิน หลังหักส่วนลด
details.Add(detail);
discountList += decimal.Parse(dataGridView1.Rows[i].Cells[colDiscount].Value.ToString());
if (i >= dataGridView1.Rows.Count - 2)
{
break;
}
}
db.SaleOrderWarehouseDtl.AddRange(details);
order.TotalDiscountInList = discountList; // วนใน ลิส
order.TotalBalance = decimal.Parse(textBoxTotalBalance.Text);
order.UpdateDate = DateTime.Now;
order.UpdateBy = SingletonAuthen.Instance().Id;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
saleOrderWarehouseListForm.LoadGrid();
this.Dispose();
}
break;
case DialogResult.No:
break;
}
}
private void button2_Click(object sender, EventArgs e)
{
if (_EmployeeId == 0)
{
MessageBox.Show("กรุณาเลือกผู้หยิบ");
return;
}
try
{
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
using (SSLsEntities db = new SSLsEntities())
{
var data = db.ISS2Front.SingleOrDefault(w => w.Code == code);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
int id = int.Parse(dataGridView1.Rows[i].Cells[0].Value.ToString());
decimal allow = decimal.Parse(dataGridView1.Rows[i].Cells[colAllowQty].Value.ToString());
var detail = data.ISS2FrontDetails.SingleOrDefault(w => w.Id == id);
detail.QtyAllow = allow;
detail.UpdateDate = DateTime.Now;
detail.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(detail).State = EntityState.Modified;
}
data.FKISS2FrontStatus = MyConstant.ISS2FrontStatus.ConfirmOrder;
data.FKEmployee = _EmployeeId;
data.Takedate = DateTime.Now;
data.TakeBy = Singleton.SingletonAuthen.Instance().Id;
data.Remark = textBoxRemark.Text;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
/// ตัด stock wms แล้ว
Library.MakeValueForUpdateStockWms(data.ISS2FrontDetails.ToList());
/// เพิ่ม stock
/// + store Front
Library.MakeValueForUpdateStockPos(data.ISS2FrontDetails.ToList());
this.iSS2FrontManageForm.LoadGrid();
this.Dispose();
}
break;
case DialogResult.No:
break;
}
}
catch (Exception)
{
MessageBox.Show("พบสิ่งผิดพลาด");
}
}
/// <summary>
/// ลบสินค้า ที่ selling price
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
int rowCurrent = dataGridView1.CurrentRow.Index;
int idSelling = int.Parse(dataGridView1.Rows[rowCurrent].Cells[0].Value.ToString());
using (SSLsEntities db = new SSLsEntities())
{
var data = db.SellingPrice.SingleOrDefault(w => w.Id == idSelling);
data.Enable = false;
data.UpdateDate = DateTime.Now;
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
Reload();
}
break;
case DialogResult.No:
break;
}
}
/// <summary>
/// ยกเลิก ต้องเอาลง CNCancel ด้วย
/// </summary>
private void SaveCommit()
{
using (SSLsEntities db = new SSLsEntities())
{
var data = db.CNHeader.SingleOrDefault(w => w.No == textBoxCNNo.Text.Trim());
data.UpdateDate = DateTime.Now;
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
data.Enable = false;
CNCancel cancel = new CNCancel();
cancel.FKCN = textBoxCNNo.Text.Trim();
cancel.Enable = true;
cancel.Description = textBoxDescription.Text.Trim();
cancel.CreateDate = DateTime.Now;
cancel.CreateBy = Singleton.SingletonAuthen.Instance().Id;
cancel.UpdateDate = DateTime.Now;
cancel.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.CNCancel.Add(cancel);
// update -stock pos
Library.MakeValueForUpdateStockPos(data.CNDetails.Where(w => w.Enable == true).ToList(), "ยกเลิกทำคืน");
foreach (var item in data.CNDetails.Where(w => w.Enable == true).ToList())
{
item.Enable = false;
item.UpdateDate = DateTime.Now;
item.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
}
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
this.Dispose();
}
}
/// <summary>
/// พิมพ์
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button4_Click(object sender, EventArgs e)
{
try
{
string code = textBoxDocNo.Text.Trim();
using (SSLsEntities db = new SSLsEntities())
{
var getDocOlder = db.StoreFrontValueDoc.SingleOrDefault(w => w.DocNo == code && w.Enable == true);
if (getDocOlder != null)
{
getDocOlder.PrintNumber = getDocOlder.PrintNumber + 1;
db.Entry(getDocOlder).State = EntityState.Modified;
db.SaveChanges();
}
else
{
MessageBox.Show("ไม่ถูกต้อง");
}
}
frmMainReport mr = new frmMainReport(this, code);
mr.Show();
}
catch (Exception)
{
MessageBox.Show("ไม่ถูกต้อง");
}
}
/// <summary>
/// ปฏิเสธออเดอร์ หรือ Reject จะต้องเป็น ออเดอร์ ที่ถูกยืนยันมาแล้ว เท่านั้น
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
string code = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value.ToString();
var data = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == code);
if (data.FKSaleOrderWarehouseStatus == MyConstant.SaleOrderWarehouseStatus.ConfirmOrder)
{
if (textBoxRemark.Text.Trim() == "")
{
MessageBox.Show("กรุณากรอกหมายเหตุ");
return;
}
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?", "คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
data.FKSaleOrderWarehouseStatus = MyConstant.SaleOrderWarehouseStatus.WarehouseRejectOrder;
data.UpdateDate = DateTime.Now;
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
LoadGrid();
break;
case DialogResult.No:
break;
}
}
else
{
MessageBox.Show("ไม่สามารถปฏิเสธออเดอร์นี้ได้");
}
}
}
/// <summary>
/// ปิดสถานะ จะปิดได้ ต้อง enable == true และต้องมีการรับเข้า > 0%
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button5_Click(object sender, EventArgs e)
{
SSLsEntities db = new SSLsEntities();
WH_TRATEntities wh = new WH_TRATEntities();
try
{
int currentRow = dataGridView1.CurrentRow.Index;
int currentId = int.Parse(dataGridView1.Rows[currentRow].Cells[0].Value.ToString());
var data = db.POHeader.SingleOrDefault(w => w.Id == currentId);
if (data.Enable == false)
{
MessageBox.Show("PO นี้ยกเลิกไปแล้ว");
}
else if (data.FKPOStatus == MyConstant.POStatus.RCVComplete || data.FKPOStatus == MyConstant.POStatus.RCVNotComplete_ButEnd)
{
MessageBox.Show("PO นี้ ปิดสถานะแล้ว");
}
else if (data.FKPOStatus == MyConstant.POStatus.NotRCV)
{
MessageBox.Show("PO นี้ ไม่เคยรับเข้ามาก่อน ไม่สามารถปิดได้");
}
else
{
//
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
data.UpdateDate = DateTime.Now;
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
data.FKPOStatus = MyConstant.POStatus.RCVNotComplete_ButEnd;
db.Entry(data).State = EntityState.Modified;
var poOrder = wh.PS_PO_ORDER.FirstOrDefault(w => w.ENABLE == true && w.PO_NO == data.PONo);
poOrder.CONFIRMRCV = DateTime.Now;
wh.Entry(poOrder).State = EntityState.Modified;
wh.SaveChanges();
db.SaveChanges();
Search();
break;
case DialogResult.No:
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show("พบข้อผิดพลาด ในการเลือกรายการ");
}
finally
{
db.Dispose();
wh.Dispose();
}
}
/// <summary>
/// ตรวจสอบ Promotion หยุดทำงาน
/// </summary>
private void CheckPromorionstop()
{
using (SSLsEntities db = new SSLsEntities())
{
var dateQuery = db.Database.SqlQuery <DateTime>("SELECT getdate()");
DateTime serverDate = dateQuery.AsEnumerable().First();
var dateCheck = db.PriceScheduleCheck.FirstOrDefault(w => DbFunctions.TruncateTime(w.DateCheck) == DbFunctions.TruncateTime(serverDate));
if (dateCheck.IsCheck == false)
{
// ถ้าวันนี้ ยังไม่เชค ก็เชค
dateCheck.IsCheck = true;
dateCheck.CheckDate = serverDate;
dateCheck.CheckBy = SingletonAuthen.Instance().Id;
db.Entry(dateCheck).State = EntityState.Modified;
var priceSchedule = db.PriceSchedule.Where(w => w.Enable == true && w.IsStop == false);
foreach (var item in priceSchedule)
{
if (serverDate > item.EndDate)
{
// ถ้าวันนี้ มากกว่า วันสิ้นสุด
// โปรโมชั่น ควร Stop ลง
item.IsStop = true;
item.StopReason = "Stop By Code";
item.UpdateDate = DateTime.Now;
item.UpdateBy = SingletonAuthen.Instance().Id;
db.Entry(item).State = EntityState.Modified;
}
}
db.SaveChanges();
}
else
{
// ถ้าวันนี้ เชคแล้ว ปล่อยผ่าน
}
//int days = 1000;
//for (int i = 0; i < days; i++)
//{
// PriceScheduleCheck f = new PriceScheduleCheck();
// f.DateCheck = DateTime.Now.AddDays(i + 1);
// f.IsCheck = false;
// db.PriceScheduleCheck.Add(f);
//}
//db.SaveChanges();
}
}
private void CheckCount1()
{
string docno = textBoxDocNo.Text.Trim();
using (SSLsEntities db = new SSLsEntities())
{
var getDocOlder = db.StoreFrontValueDoc.SingleOrDefault(w => w.DocNo == docno && w.Enable == true);
if (getDocOlder.ConfirmCheck1Date != null)
{
return;
}
if (getDocOlder != null)
{
_GetDocNo = getDocOlder;
if (_GetDocNo.ConfirmCheck1Date == null) // ยังไม่ยืนยัน 1
{
getDocOlder.ConfirmCheck1Date = DateTime.Now;
getDocOlder.ConfirmCheck1By = Singleton.SingletonAuthen.Instance().Id;
foreach (var item in getDocOlder.StoreFrontValueSet.Where(w => w.Enable == true).ToList())
{
item.QtyUnit2 = item.QtyUnit1;
item.Total = item.CostOnlyPerUnit * item.QtyUnit2;
db.Entry(item).State = EntityState.Modified;
}
db.Entry(getDocOlder).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("ยืนยันตรวจนับ 1 เรียบร้อย");
BinddingUI();
}
//else if (_GetDocNo.ConfirmCheck1Date != null && _GetDocNo.ConfirmCheck2Date == null)
//{
// dataGridView1.Columns[colQty1].ReadOnly = true;
// dataGridView1.Columns[colQty2].ReadOnly = false;
// dataGridView1.Columns[colCode].ReadOnly = true;
//}
//else
//{
// dataGridView1.Columns[colCode].ReadOnly = true;
//}
}
}
}
private void CheckCount2()
{
string docno = textBoxDocNo.Text.Trim();
using (SSLsEntities db = new SSLsEntities())
{
var getDocOlder = db.StoreFrontValueDoc.SingleOrDefault(w => w.DocNo == docno && w.Enable == true);
if (getDocOlder != null)
{
_GetDocNo = getDocOlder;
if (_GetDocNo.ConfirmCheck1Date != null && _GetDocNo.ConfirmCheck2Date == null) // ยังไม่ยืนยัน 1
{
getDocOlder.ConfirmCheck2Date = DateTime.Now;
getDocOlder.ConfirmCheck2By = Singleton.SingletonAuthen.Instance().Id;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells[colCode].Value != null)
{
int number = int.Parse(dataGridView1.Rows[i].Cells[colNumber].Value.ToString());
decimal qty1 = decimal.Parse(dataGridView1.Rows[i].Cells[colQty1].Value.ToString());
decimal qty2 = decimal.Parse(dataGridView1.Rows[i].Cells[colQty2].Value.ToString());
decimal total = decimal.Parse(dataGridView1.Rows[i].Cells[colTotal].Value.ToString());
if (qty1 != qty2)
{
// แปลว่ามีการนับ 2
var edit = getDocOlder.StoreFrontValueSet.FirstOrDefault(w => w.Enable == true && w.Number == number);
edit.QtyUnit2 = qty2;
edit.Total = total;
db.Entry(edit).State = EntityState.Modified;
}
}
}
getDocOlder.TotalQtyUnit = decimal.Parse(textBoxUnit.Text);
getDocOlder.TotalCostOnly = decimal.Parse(textBoxValue.Text);
db.Entry(getDocOlder).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("ยืนยันตรวจนับ 2 เรียบร้อย");
BinddingUI();
}
}
}
}
/// <summary>
/// po ที่จะ ไม่อนุมัติ หรือเตะทิ้ง จะต้องยังไม่อนูมัติ
/// </summary>
private void NotApproveSave()
{
List <int> idsPO = new List <int>();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
var po = dataGridView1.Rows[i].Cells[3].Value.ToString();
string check = "";
if (dataGridView1.Rows[i].Cells[9].Value == null)
{
check = "FALSE";
}
else
{
check = dataGridView1.Rows[i].Cells[9].Value.ToString();
}
var id = dataGridView1.Rows[i].Cells[0].Value.ToString();
Console.WriteLine(id + " " + po + " --------- " + check);
if (check.ToUpper() == "TRUE")
{
idsPO.Add(int.Parse(id));
}
}
Console.WriteLine(idsPO.Count());
if (idsPO.Count() < 1)
{
MessageBox.Show("ไม่มีพบเลือกรายการ");
return;
}
else if (idsPO.Count() > 0 && textBoxNotApproveRemark.Text == "")
{
MessageBox.Show("กรุณากรอกเหตุผล");
return;
}
using (SSLsEntities db = new SSLsEntities())
{
var pos = db.POHeader.Where(w => idsPO.Contains(w.Id)).ToList();
foreach (var item in pos)
{
if (item.ApproveDate != null || item.NotApproveDate != null)
{
MessageBox.Show("พบ PO อนุมัติแล้ว " + item.PONo);
return;
}
item.NotApproveDate = DateTime.Now;
item.NotApproveBy = Singleton.SingletonAuthen.Instance().Id;
item.NotApproveRemark = textBoxNotApproveRemark.Text;
db.Entry(item).State = EntityState.Modified;
}
db.SaveChanges();
}
Search();
}
/// <summary>
/// ยืนยันบันทึก
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button4_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
//Console.WriteLine(textBoxTotalCost.Text);
if (_SaveChangeType == 0)
{
SaveCommit();
}
else if (_SaveChangeType == 1)
{
// check ว่าใครหายไป
ReturnToStock();
// check การเพิ่ม ลด วัตถุดิบ ต้องไล่คืน ให้หมดก่อน
CheckAddNew();
// check ว่า เพิ่มเติมหรือไม่
int newQty = int.Parse(textBoxQty.Text) - _QTY;
if (newQty > 0)
{
// กระทำกับกับ _QTY
QtyEdit(MyConstant.PosTransaction.AddProcessingGoods, Math.Abs(newQty), MyConstant.PosTransaction.ProcessingGoods);
}
else if (newQty < 0)
{
QtyEdit(MyConstant.PosTransaction.MinusProcessingGoods, Math.Abs(newQty), MyConstant.PosTransaction.CancelProcessingGoods);
}
}
using (SSLsEntities db = new SSLsEntities())
{
var data = db.ProductDetails.SingleOrDefault(w => w.Id == _FKProDtl);
decimal totalcost = decimal.Parse(textBoxTotalCost.Text);
if (data.CostAndVat != totalcost)
{
// update now
data.CostAndVat = totalcost;
data.CostVat = Library.CalVatFromValue(data.CostAndVat);
data.CostOnly = data.CostAndVat - data.CostVat;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
}
}
this.Dispose();
break;
case DialogResult.No:
break;
}
}
/// <summary>
///
/// </summary>
private void SaveCommit()
{
using (SSLsEntities db = new SSLsEntities())
{
if (_id == 0)
{
// add new
Debtor d = new Debtor();
d.Code = textBoxCode.Text.Trim();
d.Name = textBoxName.Text.Trim();
d.Address = textBoxAddress.Text.Trim();
d.Tel = textBoxTel.Text.Trim();
d.Email = textBoxEmail.Text.Trim();
d.TaxNo = textBoxTax.Text.Trim();
d.LineId = textBoxLine.Text.Trim();
d.Fax = "-";
d.Description = null;
d.CreateDate = DateTime.Now;
d.CreateBy = Singleton.SingletonAuthen.Instance().Id;
d.UpdateDate = DateTime.Now;
d.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
d.Enable = true;
db.Debtor.Add(d);
db.SaveChanges();
Debtor data = db.Debtor.OrderByDescending(w => w.CreateDate).FirstOrDefault(w => w.CreateBy == d.CreateBy);
Singleton.SingletonDebtor.Instance().Debtors.Add(data);
}
else
{
// Update
var d = db.Debtor.SingleOrDefault(w => w.Id == _id);
var oldDeb = Singleton.SingletonDebtor.Instance().Debtors.SingleOrDefault(w => w.Id == _id);
Singleton.SingletonDebtor.Instance().Debtors.Remove(oldDeb);
d.Code = textBoxCode.Text.Trim();
d.Name = textBoxName.Text.Trim();
d.Address = textBoxAddress.Text.Trim();
d.Tel = textBoxTel.Text.Trim();
d.Email = textBoxEmail.Text.Trim();
d.TaxNo = textBoxTax.Text.Trim();
d.LineId = textBoxLine.Text.Trim();
d.UpdateDate = DateTime.Now;
d.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(d).State = EntityState.Modified;
Debtor data = db.Debtor.OrderByDescending(w => w.UpdateDate).FirstOrDefault(w => w.UpdateBy == d.UpdateBy);
Singleton.SingletonDebtor.Instance().Debtors.Add(data);
db.SaveChanges();
}
Reload(textBoxSearchKey.Text.Trim());
}
}
/// <summary>
/// บันทึก
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
try
{
if (_checkAdd)
{
// is add new
Users user = new Users();
user.Id = textBoxUser.Text;
user.Password = "******";
user.Name = textBoxFullName.Text;
user.Description = textBoxDesc.Text;
user.FKRole = int.Parse(textBoxRoleId.Text);
user.FKBranch = MyConstant.MyBranch._02;
user.CreateDate = DateTime.Now;
user.CreateBy = Singleton.SingletonAuthen.Instance().Id;
user.UpdateDate = DateTime.Now;
user.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
user.Enable = true;
db.Users.Add(user);
_checkAdd = false;
}
else
{
var data = db.Users.SingleOrDefault(w => w.Id == textBoxUser.Text);
data.Name = textBoxFullName.Text;
data.FKRole = int.Parse(textBoxRoleId.Text);
data.Description = textBoxDesc.Text;
data.UpdateDate = DateTime.Now;
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
if (radioButtonNon.Checked == true)
{
// ถ้าระงับใช้งาน
data.Enable = false;
}
else
{
data.Enable = true;
}
db.Entry(data).State = EntityState.Modified;
}
db.SaveChanges();
Reload();
}
catch (Exception)
{
MessageBox.Show("กรุณาตรวจสอบ User ซ้ำ");
}
}
}
private void SaveConfirm()
{
using (SSLsEntities db = new SSLsEntities())
{
string code = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString();
var data = db.CNWarehouse.SingleOrDefault(w => w.Enable == true && w.Code == code);
data.ConfirmCNDate = DateTime.Now;
data.ConfirmCNBy = SingletonAuthen.Instance().Id;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
SearchData();
}
}
/// <summary>
/// ยกเลิก PO ทีละ 1 PO
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button4_Click(object sender, EventArgs e)
{
SSLsEntities db = new SSLsEntities();
try
{
int currentRow = dataGridView1.CurrentRow.Index;
int currentId = int.Parse(dataGridView1.Rows[currentRow].Cells[0].Value.ToString());
var data = db.POHeader.SingleOrDefault(w => w.Id == currentId);
if (data.Enable == false)
{
MessageBox.Show("PO นี้ยกเลิกไปแล้ว");
}
else if (data.FKPOStatus == MyConstant.POStatus.RCVComplete || data.FKPOStatus == MyConstant.POStatus.RCVNotComplete_ButEnd)
{
MessageBox.Show("PO นี้ ปิดสถานะแล้ว");
}
else if (data.FKPOStatus == MyConstant.POStatus.RCVNotEnd)
{
MessageBox.Show("PO นี้ อยู่ในระหว่างรับเข้า");
}
else
{
//
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
data.UpdateDate = DateTime.Now;
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
data.Enable = false;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
Search();
break;
case DialogResult.No:
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show("พบข้อผิดพลาด ในการเลือกรายการ");
}
finally
{
db.Dispose();
}
}
private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
if (_Id == 0)
{
// add new
Supplier obj = new Supplier();
obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Address = textBoxAddress.Text;
obj.Tel = textBoxTel.Text;
obj.Description = textBoxDesc.Text;
obj.CreateDate = DateTime.Now;
obj.CreateBy = Singleton.SingletonAuthen.Instance().Id;
obj.Enable = true;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
obj.UpdateDate = DateTime.Now;
db.Supplier.Add(obj);
}
else
{
// edit
var obj = db.Supplier.SingleOrDefault(w => w.Id == _Id);
obj.UpdateDate = DateTime.Now;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Address = textBoxAddress.Text;
obj.Tel = textBoxTel.Text;
obj.Description = textBoxDesc.Text;
if (radioButton1.Checked)
{
obj.Enable = true;
}
else
{
obj.Enable = false;
}
db.Entry(obj).State = EntityState.Modified;
}
db.SaveChanges();
Singleton.SingletonPriority1.SetInstance();
//Singleton.SingletonPriority1.Instance();
dataGrid();
//this.Dispose();
//_Id = 0;
}
}
public frmMainReport(RCVPOEditForm rCVPOEditForm, string code)
{
InitializeComponent();
this.rCVPOEditForm = rCVPOEditForm;
this.code = code;
using (SSLsEntities db = new SSLsEntities())
{
var data = db.PORcv.SingleOrDefault(w => w.Enable == true && w.Code == code);
data.PrintNumber = data.PrintNumber + 1;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
}
this.TypeReport = MyConstant.TypeReport.RCVPO;
}
private void SaveSubmit()
{
// save pass
using (SSLsEntities db = new SSLsEntities())
{
string id = Singleton.SingletonAuthen.Instance().Id;
var user = db.Users.SingleOrDefault(w => w.Id == id);
user.Password = textBoxNewPass.Text.Trim();
user.Description = "แก้ไขรหัสผ่าน " + Library.ConvertDateToThaiDate(DateTime.Now, true);
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
Environment.Exit(0);
}
/// <summary>
/// ลบสมาชิก ออกจากระบบ Disable ทั้ง HD Details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
///
private void button3_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
int index = dataGridView1.CurrentRow.Index;
int id = int.Parse(dataGridView1.Rows[index].Cells[col1Id].Value.ToString());
var member = Singleton.SingletonMember.Instance().Members.SingleOrDefault(w => w.Id == id);
Singleton.SingletonMember.Instance().Members.Remove(member);
using (SSLsEntities db = new SSLsEntities())
{
var data = db.Member.SingleOrDefault(w => w.Id == id);
data.UpdateDate = DateTime.Now;
data.UpdateBy = SingletonAuthen.Instance().Id;
data.Enable = false;
db.Entry(data).State = EntityState.Modified;
foreach (var item in data.MemberShare.Where(w => w.Enable == true))
{
item.UpdateDate = DateTime.Now;
item.UpdateBy = SingletonAuthen.Instance().Id;
item.Enable = false;
db.Entry(item).State = EntityState.Modified;
}
db.SaveChanges();
}
reload();
break;
case DialogResult.No:
break;
}
}
private void Recount()
{
using (SSLsEntities db = new SSLsEntities())
{
string barcodescan = textBoxScanner.Text.Trim();
var getProductDetails = Singleton.SingletonProduct.Instance().ProductDetails.FirstOrDefault(w => w.Enable == true && w.Code == barcodescan);
var checkFKPro = db.CheckStockDetails.FirstOrDefault(w => w.Enable == true && w.FKProductDetails == getProductDetails.Id);
checkFKPro.Enable = false;
checkFKPro.UpdateDate = DateTime.Now;
checkFKPro.UpdateBy = _UserId;
db.Entry(checkFKPro).State = EntityState.Modified;
db.SaveChanges();
}
ResetNew();
}
/// <summary>
/// ตกลง ต่อเวลา
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
priceSchedule = db.PriceSchedule.SingleOrDefault(w => w.Id == priceSchedule.Id);
priceSchedule.StartDate = dateTimePickerStart.Value;
priceSchedule.EndDate = dateTimePickerEnd.Value;
priceSchedule.UpdateDate = DateTime.Now;
priceSchedule.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(priceSchedule).State = EntityState.Modified;
db.SaveChanges();
this.searchEditPromotionForm.Reload();
this.Dispose();
}
}
/// <summary>
/// ยืนยันบันทึก disable ชุดเดิมทิ้งทั้งหมด
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
List <int> ids = new List <int>();
for (int i = 0; i < dataGridView2.Rows.Count; i++)
{
//Console.WriteLine();
int id = int.Parse(dataGridView2.Rows[i].Cells[0].Value.ToString());
ids.Add(id);
}
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
using (SSLsEntities db = new SSLsEntities())
{
var menuAc = db.MenuAccess.Where(w => w.Enable == true && w.FKRole == _idRole);
foreach (var item in menuAc)
{
item.Enable = false;
item.UpdateDate = DateTime.Now;
item.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(item).State = EntityState.Modified;
}
// add new ids
foreach (var item in ids)
{
MenuAccess ac = new MenuAccess();
ac.CreateBy = Singleton.SingletonAuthen.Instance().Id;
ac.CreateDate = DateTime.Now;
ac.FKRole = _idRole;
ac.FKMenu = item;
ac.UpdateDate = DateTime.Now;
ac.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
ac.Enable = true;
db.MenuAccess.Add(ac);
}
db.SaveChanges();
ReloaGrid1();
}
break;
case DialogResult.No:
break;
}
}
private void SaveCommit()
{
using (SSLsEntities db = new SSLsEntities())
{
string username = Singleton.SingletonAuthen.Instance().Id;
var data = db.Users.SingleOrDefault(w => w.Id == username);
data.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
data.UpdateDate = DateTime.Now;
data.Name = textBoxFullName.Text;
data.Description = textBoxDesc.Text;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
this.Dispose();
}
}
private void CancelOrder(IEnumerable<string> stackDocNo)
{
using (SSLsEntities db = new SSLsEntities())
{
foreach (var item in stackDocNo)
{
var order = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == item);
order.UpdateDate = DateTime.Now;
order.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
order.Enable = false;
order.FKSaleOrderWarehouseStatus = MyConstant.SaleOrderWarehouseStatus.CancelOrder;
db.Entry(order).State = EntityState.Modified;
}
db.SaveChanges();
LoadGrid();
}
}
/// <summary>
/// คำนวน Order ใหม่
/// </summary>
/// <param name="code"></param>
private void Recal(string code)
{
using (SSLsEntities db = new SSLsEntities())
{
var data = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == code);
decimal totalHasVat = 0; // ยอดสินค้ามีภาษี
decimal totalUnVat = 0; // ยอดสินค้ายกเว้นภาษี
decimal totalDisInList = 0;
foreach (var item in data.SaleOrderWarehouseDtl.Where(w => w.Enable == true).ToList())
{
if (item.QtyAllow < item.Qty)
{
// ได้ยอดไม่ตามเป้า
item.QtyOriginal = item.Qty;
item.Qty = item.QtyAllow;
// clear ส่วนลด
item.PercentDiscount = 0;
item.BathDiscount = 0;
item.TotalPrice = item.QtyAllow * item.PricePerUnit;
db.Entry(item).State = EntityState.Modified;
}
if (item.ProductDetails.Products.ProductVatType.Id == MyConstant.ProductVatType.HasVat)
{
totalHasVat += item.TotalPrice;
}
else
{
totalUnVat += item.TotalPrice;
}
totalDisInList += item.BathDiscount;
}
decimal total = totalHasVat + totalUnVat; // ยอดรวมก่อนหักลด
decimal totalBalance = total - data.TotalDiscount;
data.TotalVat = totalHasVat * MyConstant.MyVat.Vat / MyConstant.MyVat.VatRemove;
data.TotaNoVat = totalUnVat;
data.TotalBeforeVat = totalHasVat - data.TotalVat;
data.Total = total;
data.TotalDiscountInList = totalDisInList;
data.TotalBalance = totalBalance;
db.SaveChanges();
}
}
/// <summary>
/// save or edit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
if (_Id == 0)
{
// add new
ProductUnit obj = new ProductUnit();
obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Description = textBoxDesc.Text;
obj.CreateDate = DateTime.Now;
obj.CreateBy = Singleton.SingletonAuthen.Instance().Id;
obj.Enable = true;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
obj.UpdateDate = DateTime.Now;
db.ProductUnit.Add(obj);
}
else
{
// edit
var unit = db.ProductUnit.SingleOrDefault(w => w.Id == _Id);
unit.UpdateDate = DateTime.Now;
unit.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
unit.Code = textBoxCode.Text;
unit.Name = textBoxName.Text;
unit.Description = textBoxDesc.Text;
if (radioButton1.Checked)
{
unit.Enable = true;
}
else
{
unit.Enable = false;
}
db.Entry(unit).State = EntityState.Modified;
}
db.SaveChanges();
Singleton.SingletonPUnit.SetInstance();
dataGrid();
//this.Dispose();
//_Id = 0;
}
}
/// <summary>
/// บันทึก Role
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
if (_idRole == 0)
{
// add new role
Role role = new Role();
role.Code = textBoxCode.Text;
role.Name = textBoxName.Text;
role.Description = textBoxDesc.Text;
role.CreateDate = DateTime.Now;
role.CreateBy = Singleton.SingletonAuthen.Instance().Id;
role.UpdateDate = DateTime.Now;
role.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
role.Enable = true;
db.Role.Add(role);
}
else
{
// Update Role Value
Role role = new Role();
role = db.Role.SingleOrDefault(w => w.Id == _idRole);
role.Code = textBoxCode.Text;
role.Name = textBoxName.Text;
role.Description = textBoxDesc.Text;
role.UpdateDate = DateTime.Now;
role.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(role).State = EntityState.Modified;
}
DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
"คำเตือนจากระบบ", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
db.SaveChanges();
ReloaGrid1();
break;
case DialogResult.No:
break;
}
}
}
private void button4_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
var obj = db.Vendor.SingleOrDefault(w => w.Id == _Id);
var vendorSingle = Singleton.SingletonVender.Instance().Vendors.SingleOrDefault(w => w.Id == _Id);
Singleton.SingletonVender.Instance().Vendors.Remove(vendorSingle);
obj.UpdateDate = DateTime.Now;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Address = textBoxAddress.Text;
obj.Tel = textBoxTel.Text;
obj.Fax = textBoxFax.Text;
obj.Description = textBoxDesc.Text;
if (radioButton1.Checked)
{
obj.Enable = true;
}
else
{
obj.Enable = false;
}
if (radioButtonCostOnly.Checked == true)
{
obj.FKPOCostType = MyConstant.POCostType.CostOnly;
}
else
{
obj.FKPOCostType = MyConstant.POCostType.CostAndVat;
}
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
string user = Singleton.SingletonAuthen.Instance().Id;
var v = db.Vendor.Include("POCostType").OrderByDescending(w => w.UpdateDate).Where(w => w.UpdateBy == user).FirstOrDefault();
Singleton.SingletonVender.Instance().Vendors.Add(v);
dataGrid();
//_Id = 0;
Reload(textBoxSearchKey.Text.Trim());
}
}