public static int Them(this int tong, string soluong, string scd, string so, string size, int solanin,
DateTime orderdate, string soluong2, int _tong)
{
if (_tong == 0)
{
db = new MyDBContextDataContext();
}
for (int i = 0; i < solanin; i++)
{
tbTemDanAd tb = new tbTemDanAd
{
IDTemDanAD = scd,
SO = so,
Size = size,
QTY = soluong,
OrderDate = orderdate
};
db.tbTemDanAds.InsertOnSubmit(tb);
}
tong = _tong + Convert.ToInt32(soluong) * solanin;
if (tong == Convert.ToInt32(soluong2))
{
db.SubmitChanges();
}
return(tong);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
for (int i = 0; i < 60; i++)
{
int tong = 0;
var db = new MyDBContextDataContext();
var soluong = Convert.ToInt32(gridView1.GetRowCellValue(i, colSoLuong)); // sl = 2300 //2000 //300
var solanin = Convert.ToInt32(gridView1.GetRowCellValue(i, colSoLanIn));
var size = gridView1.GetRowCellValue(i, colSize).ToString();
var _solanin = Math.Ceiling((double)soluong / 500); // 5 // 4 //1
var _sodu = soluong - (soluong / 500) * 500; // 300 // 0 // 0
for (int j = 1; j <= _solanin; j++)
{
tbTemDanAd tb = new tbTemDanAd();
tb.IDTemDanAD = scd;
tb.SO = so;
tb.Size = size;
if (i == _solanin && _sodu > 0 || soluong < 500 && _sodu == 0)
{
tb.QTY = _sodu.ToString();
}
else
{
tb.QTY = "500";
}
tb.OrderDate = orderdate;
db.tbTemDanAds.InsertOnSubmit(tb);
}
tong = tong + Convert.ToInt32(soluong) * solanin;
if (tong == Convert.ToInt32(qty))
{
db.SubmitChanges();
}
}
}
private void btnTinh_Click(object sender, EventArgs e)
{
var db = new MyDBContextDataContext();
var dsx = (from s in db.tbDonSanXuat_Averies where s.OrderDate == dateEdit1.DateTime && s.SKU == 1 && s.scd != null select s).ToList();
foreach (var item in dsx)
{
//var tdAD = db.tbTemDanAds.ToList();
var tdAD = (from s in db.tbTemDanAds where s.OrderDate == dateEdit1.DateTime && s.SO == item.SO && s.IDTemDanAD == item.scd select s).ToList();
if (tdAD.Count != 0)
{
continue;
}
var sli1 = (int)(Convert.ToInt32(item.Qty) / 500);
var sli2 = Convert.ToInt32(item.Qty) - ((int)(Convert.ToInt32(item.Qty) / 500) * 500);
for (int i = 0; i < sli1; i++)
{
var temdanAd = new tbTemDanAd();
temdanAd.IDTemDanAD = item.scd;
temdanAd.SO = item.SO;
temdanAd.Size = null;
temdanAd.QTY = "500";
temdanAd.OrderDate = dateEdit1.DateTime;
db.tbTemDanAds.InsertOnSubmit(temdanAd);
db.SubmitChanges();
}
var temdanAd2 = new tbTemDanAd();
temdanAd2.IDTemDanAD = item.scd;
temdanAd2.SO = item.SO;
temdanAd2.Size = null;
temdanAd2.QTY = sli2.ToString();
temdanAd2.OrderDate = dateEdit1.DateTime;
db.tbTemDanAds.InsertOnSubmit(temdanAd2);
var dsxAvery = (from s in db.tbDonSanXuat_Averies where s.SO == item.SO select s).Single();
dsxAvery.XacNhan = 2;
db.SubmitChanges();
}
MessageBox.Show(PrintRibbon.themthanhcong);
dateEdit1_EditValueChanged(sender, e);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int tong = 0;
var dbc = new MyDBContextDataContext();
for (int i = 0; i < gvBang.RowCount; i++)
{
var soluong = Convert.ToInt32(gvBang.GetRowCellValue(i, colSoLuong));
var size = gvBang.GetRowCellValue(i, colSize).ToString();
if (Convert.ToInt32(soluong) < 1)
{
continue;
}
var _solanin = Math.Ceiling((double)soluong / 500);
var _sodu = soluong - soluong / 500 * 500;
for (int j = 1; j <= _solanin; j++)
{
tbTemDanAd tb = new tbTemDanAd();
tb.IDTemDanAD = SCD;
tb.SO = so;
tb.Size = size;
tb.OrderDate = orderdate;
if (j == (int)_solanin && _sodu > 0 || soluong < 500 && _sodu == 0)
{
tb.QTY = _sodu.ToString();
}
else
{
tb.QTY = "500";
}
dbc.tbTemDanAds.InsertOnSubmit(tb);
tong = tong + Convert.ToInt32(tb.QTY);
}
//MessageBox.Show(tong.ToString());
}
if (tong == Convert.ToInt32(qty))
{
dbc.SubmitChanges();
MessageBox.Show(PrintRibbon.themthanhcong);
var tb = dbc.tbBaoCaoThietKes.Single(s => s.IDBaoCaoThietKe == SCD);
var nghiepvu = dbc.tbBaoCaoNghiepVus.Single(s => s.IDBaoCaoNghiepVu == SCD);
tb.BanIn = "Đạt";
tb.SanPham = "Đạt";
tb.Layout = "Đạt";
tb.NetChu = "Đạt";
tb.CoChu = "Đạt";
tb.VitriCatGap = "Đạt";
tb.KyHieu = "Đạt";
tb.DanhGia = "Đạt";
tb.Size = nghiepvu.Size;
var dsxAvery = (from s in dbc.tbDonSanXuat_Averies where s.SO == so select s).Single();
dsxAvery.XacNhan = 2;
dbc.SubmitChanges();
dateEdit1_EditValueChanged(sender, e);
}
else if (tong == 0)
{
MessageBox.Show("Đơn hàng không tồn tại");
}
else
{
MessageBox.Show("Số lượng không đúng , vui lòng xem lại");
}
}
