private void AddData()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
decimal a1 = 0, a2 = 0, a3 = 0, a4 = 0, a5 = 0, a6 = 0, a7 = 0, a8 = 0, a9 = 0, a10 = 0, a11 = 0, a12 = 0;
decimal.TryParse(txtJan.Text, out a1);
decimal.TryParse(txtFeb.Text, out a2);
decimal.TryParse(txtMar.Text, out a3);
decimal.TryParse(txtApr.Text, out a4);
decimal.TryParse(txtMay.Text, out a5);
decimal.TryParse(txtJun.Text, out a6);
decimal.TryParse(txtJul.Text, out a7);
decimal.TryParse(txtAug.Text, out a8);
decimal.TryParse(txtSep.Text, out a9);
decimal.TryParse(txtOct.Text, out a10);
decimal.TryParse(txtNov.Text, out a11);
decimal.TryParse(txtDec.Text, out a12);
int yyyy = 0;
int.TryParse(txtYear.Text, out yyyy);
tb_ProductionForecast mp = new tb_ProductionForecast();
mp.YYYY = yyyy;
mp.ModelName = txtModelName.Text;
mp.PartName = txtPartName.Text;
mp.PartNo = txtPartNo.Text;
mp.Process = txtProcess.Text;
mp.JAN = a1;
mp.FEB = a2;
mp.MAR = a3;
mp.APR = a4;
mp.MAY = a5;
mp.JUN = a6;
mp.JUL = a7;
mp.AUG = a8;
mp.SEP = a9;
mp.OCT = a10;
mp.NOV = a11;
mp.DEC = a12;
mp.Active = true;
db.tb_ProductionForecasts.InsertOnSubmit(mp);
db.SubmitChanges();
}
dbClss.AddHistory(this.Name, "เพิ่ม Consumption ", "Model [" + txtModelName.Text + "," + txtYear.Text + "]", "");
MessageBox.Show("บันทึกเรียบร้อย");
NewClick1();
}
catch { }
}
private void ImportData()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (DataRow rd in dt2.Rows)
{
if (!rd["ModelName"].ToString().Equals("") && !rd["YYYY"].ToString().Equals("0"))
{
int id = 0;
int.TryParse(rd["id"].ToString(), out id);
var mp1 = (from ix in db.tb_ProductionForecasts
where ix.YYYY == Convert.ToInt32(rd["YYYY"].ToString()) &&
ix.ModelName == Convert.ToString(rd["ModelName"])
//&& ix.PartNo==Convert.ToString(rd["PartNo"])
select ix).FirstOrDefault();
DateTime?d = null;
DateTime d1 = DateTime.Now;
decimal a1 = 0, a2 = 0, a3 = 0, a4 = 0, a5 = 0, a6 = 0, a7 = 0, a8 = 0, a9 = 0, a10 = 0, a11 = 0, a12 = 0;
decimal.TryParse(rd["JAN"].ToString(), out a1);
decimal.TryParse(rd["FEB"].ToString(), out a2);
decimal.TryParse(rd["MAR"].ToString(), out a3);
decimal.TryParse(rd["APR"].ToString(), out a4);
decimal.TryParse(rd["MAY"].ToString(), out a5);
decimal.TryParse(rd["JUN"].ToString(), out a6);
decimal.TryParse(rd["JUL"].ToString(), out a7);
decimal.TryParse(rd["AUG"].ToString(), out a8);
decimal.TryParse(rd["SEP"].ToString(), out a9);
decimal.TryParse(rd["OCT"].ToString(), out a10);
decimal.TryParse(rd["NOV"].ToString(), out a11);
decimal.TryParse(rd["DEC"].ToString(), out a12);
int yyyy = 0;
int.TryParse(rd["YYYY"].ToString(), out yyyy);
if (mp1 == null)
{
tb_ProductionForecast mp = new tb_ProductionForecast();
mp.YYYY = yyyy;
mp.ModelName = rd["ModelName"].ToString();
mp.JAN = a1;
mp.FEB = a2;
mp.MAR = a3;
mp.APR = a4;
mp.MAY = a5;
mp.JUN = a6;
mp.JUL = a7;
mp.AUG = a8;
mp.SEP = a9;
mp.OCT = a10;
mp.NOV = a11;
mp.DEC = a12;
mp.PartName = rd["PartName"].ToString();
mp.PartNo = rd["PartNo"].ToString();
mp.Process = rd["Process"].ToString();
mp.Active = true;
db.tb_ProductionForecasts.InsertOnSubmit(mp);
db.SubmitChanges();
}
else
{
//mp1.YYYY = yyyy;
//mp1.ModelName = rd["ModelName"].ToString();
mp1.JAN = a1;
mp1.FEB = a2;
mp1.MAR = a3;
mp1.APR = a4;
mp1.MAY = a5;
mp1.JUN = a6;
mp1.JUL = a7;
mp1.AUG = a8;
mp1.SEP = a9;
mp1.OCT = a10;
mp1.NOV = a11;
mp1.DEC = a12;
mp1.Active = Convert.ToBoolean(rd["Active"].ToString());
db.SubmitChanges();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("InportData", ex.Message, this.Name);
}
}
