private void AddData()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
decimal tl = 1;
decimal qty = 0;
int co = 1;
tb_Mapping mp = new tb_Mapping();
mp.ModelName = txtModelName.Text;
mp.PartName = txtPartName.Text;
mp.PartNo = txtPartNo.Text;
mp.Process = txtProcess.Text;
mp.Remark = txtRemark.Text;
mp.CodeNo = txtcodeNo.Text;
decimal.TryParse(txtQty.Text, out qty);
decimal.TryParse(txtToolLife.Text, out tl);
int.TryParse(txtCorner.Text, out co);
mp.ToolLife = tl;
mp.Corner = co;
mp.QtyPerPCS = qty;
db.tb_Mappings.InsertOnSubmit(mp);
db.SubmitChanges();
}
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["CodeNo"].ToString().Equals(""))
{
string Process = rd["Process"].ToString().Trim();
string CodeNo = rd["CodeNo"].ToString().Trim();
string Model = rd["ModelName"].ToString().Trim();
string PartName = rd["PartName"].ToString().Trim();
string PartNo = rd["PartNo"].ToString().Trim();
string Remark = rd["Remark"].ToString().Trim();
decimal qty = 0;
decimal tl = 1;
int co = 1;
int.TryParse(rd["Corner"].ToString(), out co);
decimal.TryParse(rd["QtyPerPCS"].ToString().Trim(), out qty);
decimal.TryParse(rd["ToolLife"].ToString().Trim(), out tl);
var x = (from ix in db.tb_Mappings where ix.ModelName.Equals(Model) &&
ix.PartName.Equals(PartName) && ix.CodeNo.Equals(CodeNo) && ix.Process.Equals(Process)
select ix).FirstOrDefault();
DateTime?d = null;
DateTime d1 = DateTime.Now;
if (x == null)
{
tb_Mapping u = new tb_Mapping();
u.ModelName = Model;
u.PartName = PartName;
u.PartNo = PartNo;
u.Process = Process;
u.Remark = Remark;
u.CodeNo = CodeNo;
u.QtyPerPCS = qty;
u.ToolLife = tl;
u.Corner = co;
db.tb_Mappings.InsertOnSubmit(u);
db.SubmitChanges();
}
else
{
x.ModelName = Model;
x.PartName = PartName;
x.PartNo = PartNo;
x.Process = Process;
x.Remark = Remark;
x.CodeNo = CodeNo;
x.QtyPerPCS = qty;
x.ToolLife = tl;
x.Corner = co;
db.SubmitChanges();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("InportData", ex.Message, this.Name);
}
}
