private void genLOt()
{
string LotMap = "";
string LotY = "";
string LotM = "";
string LotNo = "";
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
DateTime thisDay = DateTime.Now.AddDays(-500);
for (int i = 1; i <= 500; i++)
{
LotMap = "";
LotY = "";
LotM = "";
LotNo = "";
tb_GenerateLotMap g = db.tb_GenerateLotMaps.Where(t => t.Daysx == thisDay.Day).FirstOrDefault();
if (g != null)
{
LotMap = g.KeyLot;
LotY = thisDay.Year.ToString().Substring(3, 1);
LotM = thisDay.Month.ToString();
if (thisDay.Month == 10)
{
LotM = "X";
}
else if (thisDay.Month == 11)
{
LotM = "Y";
}
else if (thisDay.Month == 12)
{
LotM = "Z";
}
LotNo = LotY + LotM + LotMap + "T";
tb_LotNo nl = new tb_LotNo();
nl.LotNo = LotNo;
nl.LotDate = thisDay;
db.tb_LotNos.InsertOnSubmit(nl);
db.SubmitChanges();
}
thisDay = thisDay.AddDays(1);
}
MessageBox.Show("Completed");
}
}
private void LoadBomNo()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
int ac = 1;
int.TryParse(txtAC.Text, out ac);
var getCode = (from ix in db.sp_003_TPIC_GETBOMNo(txtBomNo.Text, ac) select ix).ToList();
if (getCode.Count > 0)
{
var rd = getCode.FirstOrDefault();
dtDate1.Value = Convert.ToDateTime(rd.CreateDate);
txtPartName.Text = rd.NAME.ToString();
txtPartNo.Text = rd.CODE.ToString();
txtCustItemName.Text = rd.CustItemName.ToString();
txtCustItemNo.Text = rd.CustItemNo.ToString();
txtCustomerName.Text = rd.CSTMName.ToString();
txtCustomerShortName.Text = rd.CustomerNo.ToString();
txtsNP.Text = Convert.ToInt32(rd.LotSize).ToString();
txtLotNo.Text = "";
txtQty.Text = Convert.ToInt32(rd.OrderQty).ToString("#####0");
tb_LotNo gl = db.tb_LotNos.Where(l => (l.LotDate.Year == dtDate1.Value.Year && l.LotDate.Month == dtDate1.Value.Month && l.LotDate.Day == dtDate1.Value.Day)).FirstOrDefault();
if (gl != null)
{
txtLotNo.Text = gl.LotNo.ToString();
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
