public int CreateInjectionCabinetLabel(InjectionCabinetLabel newInjectionCabinetLabel)
{
int result = -1;
try
{
conn = db.openConn();
tr = conn.BeginTransaction();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO injection_cabinet_labels(barcode,part,date,serial,shift,rev,matterial_no,lot_no,color_no,machine_no,mold_no,user_create_name,create_date,status)");
sb.Append(" VALUES (@barcode,@part,@date,@serial,@shift,@rev,@matterial_no,@lot_no,@color_no,@machine_no,@mold_no,@user_create_name,@create_date,@status)");
string sqlsave;
sqlsave = sb.ToString();
comm = new SqlCommand();
comm.Connection = conn;
comm.Transaction = tr;
comm.CommandText = sqlsave;
comm.Parameters.Clear();
comm.Parameters.Add("@barcode", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.BarCode;
comm.Parameters.Add("@part", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.Part;
comm.Parameters.Add("@date", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.date;
comm.Parameters.Add("@serial", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.Serial;
comm.Parameters.Add("@shift", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.Shift;
comm.Parameters.Add("@rev", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.Rev;
comm.Parameters.Add("@matterial_no", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.MatterialNo;
comm.Parameters.Add("@lot_no", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.LotNo;
comm.Parameters.Add("@color_no", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.ColorNo;
comm.Parameters.Add("@machine_no", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.MachineNo;
comm.Parameters.Add("@mold_no", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.MoldNo;
comm.Parameters.Add("@user_create_name", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.UserCreateName;
comm.Parameters.Add("@create_date", SqlDbType.DateTime).Value = newInjectionCabinetLabel.CreateDate;
comm.Parameters.Add("@status", SqlDbType.NVarChar).Value = newInjectionCabinetLabel.Status;
comm.ExecuteNonQuery();
tr.Commit();
result = 1;
}
catch (Exception ex)
{
tr.Rollback();
conn.Close();
return result;
throw ex;
}
finally
{
conn.Close();
}
return result;
}
private void dgvList_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
string _barcode = "";
_barcode = dgvList.Rows[e.RowIndex].Cells[1].Value.ToString();
injectionCabinetLabel = injectionCabinetService.GetByCode(_barcode);
}
private void btnGen_Click(object sender, EventArgs e)
{
if (cbopart.Text.Trim() == "")
{
MessageBox.Show("กรุณาเลือก Part ก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
cbopart.Focus();
return;
}
if (txtLotNo.Text.Trim() == "")
{
MessageBox.Show("กรุณาป้อน Lot No ก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtLotNo.Focus();
return;
}
//if (cbomold.Text.Trim() == "")
//{
// MessageBox.Show("กรุณาเลือก Mold No ก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// cbomold.Focus();
// return;
//}
if (txtNumPrint.Text.Trim() == "")
{
MessageBox.Show("กรุณาป้อน จำนวน ก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtNumPrint.Focus();
return;
}
InjectionCabinetLabel _il = new InjectionCabinetLabel();
_il.Part = cbopart.SelectedValue.ToString();
string _date = String.Format("{0:dd/MM/yyyy}", dtbDate.Value);
_il.date = _date;
_il.Shift = cboShift.Text.Trim();
_il.LotNo = txtLotNo.Text.Trim();
_il.Rev = lblrevision.Text.Trim();
_il.MatterialNo =lblmeterial.Text.Trim();
_il.ColorNo = lbocolor.Text.Trim();
_il.MachineNo = injectionMachine.Name;
_il.MoldNo = lblmachine.Text.Trim();
int _numPrint = Convert.ToInt32(txtNumPrint.Text.Trim());
injectionCabinetLabels = injectionService.GenBarCode(_il, _numPrint);
dgvList.DataSource = injectionCabinetLabels;
FormatdgvList();
}
public List<InjectionCabinetLabel> GetByCodes(string _part,string _date)
{
List<InjectionCabinetLabel> injectionCabinetLabels = new List<InjectionCabinetLabel>();
InjectionCabinetLabel injb = null;
try
{
conn = db.openConn();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" select barcode,part,date,serial,shift,rev,matterial_no,lot_no,color_no,machine_no,mold_no,user_create_name,create_date,status from dbo.injection_cabinet_labels");
sb.Append(" where part ='" + _part + "'");
sb.Append(" and date ='" + _date + "'");
string sql;
sql = sb.ToString();
comm = new SqlCommand();
comm.CommandText = sql;
comm.CommandType = CommandType.Text;
comm.Connection = conn;
dr = comm.ExecuteReader();
if (dr.HasRows)
{
DataTable dt = new DataTable();
dt.Load(dr);
foreach (DataRow drw in dt.Rows)
{
injb = new InjectionCabinetLabel();
injb.BarCode = drw["barcode"].ToString();
injb.Part = drw["part"].ToString();
injb.date = drw["date"].ToString();
injb.Serial = drw["serial"].ToString();
injb.Shift = drw["shift"].ToString();
injb.Rev = drw["rev"].ToString();
injb.MatterialNo = drw["matterial_no"].ToString();
injb.LotNo = drw["lot_no"].ToString();
injb.ColorNo = drw["color_no"].ToString();
injb.MachineNo = drw["machine_no"].ToString();
injb.MoldNo = drw["mold_no"].ToString();
injb.UserCreateName = drw["user_create_name"].ToString();
injb.CreateDate = Convert.ToDateTime(drw["create_date"].ToString());
injb.Status = drw["status"].ToString();
injectionCabinetLabels.Add(injb);
}
}
}
catch (Exception ex)
{
dr.Close();
conn.Close();
return null;
throw ex;
}
finally
{
conn.Close();
}
return injectionCabinetLabels;
}
public List<InjectionCabinetLabel> GenBarCode(InjectionCabinetLabel injectionCabinetLabel, int genNumber)
{
List<InjectionCabinetLabel> injectionCabinetLabels = new List<InjectionCabinetLabel>();
InjectionCabinetLabel inl;
string[] arr = Regex.Split(injectionCabinetLabel.date, "/");
int _year = Convert.ToInt32(arr[2])/* - 543*/;
injectionCabinetLabel.date = arr[0] + "/" + arr[1] + "/" + _year;
/*
injectionCabinetLabel.Rev = "00";
injectionCabinetLabel.MatterialNo = "700-314";
injectionCabinetLabel.ColorNo = "B1";
injectionCabinetLabel.MachineNo = "MC13001";*/
int _lastSerial = this.GetLastSerial(injectionCabinetLabel.Part, injectionCabinetLabel.date, injectionCabinetLabel.Shift, injectionCabinetLabel.LotNo, injectionCabinetLabel.MoldNo);
if (_lastSerial == 0)
{
_lastSerial = 1;
}
else
{
_lastSerial++;
}
int j = 0;
genNumber = genNumber + _lastSerial;
for (j = _lastSerial; j < genNumber; j++)
{
inl = new InjectionCabinetLabel();
inl.BarCode = injectionCabinetLabel.Part + "!" + injectionCabinetLabel.date+"!";
inl.BarCode += j.ToString("00000") + "!" + injectionCabinetLabel.Shift+"!";
inl.BarCode += injectionCabinetLabel.Rev + "!" + injectionCabinetLabel.MatterialNo+"!";
inl.BarCode += injectionCabinetLabel.LotNo + "!" + injectionCabinetLabel.ColorNo+"!";
inl.BarCode += injectionCabinetLabel.MachineNo+"!"+injectionCabinetLabel.MoldNo;
inl.Part = injectionCabinetLabel.Part;
inl.date = injectionCabinetLabel.date;
inl.Serial = Convert.ToString(j);
inl.Shift = injectionCabinetLabel.Shift;
inl.Rev = injectionCabinetLabel.Rev;
inl.MatterialNo = injectionCabinetLabel.MatterialNo;
inl.LotNo = injectionCabinetLabel.LotNo;
inl.ColorNo = injectionCabinetLabel.ColorNo;
inl.MachineNo = injectionCabinetLabel.MachineNo;
inl.MoldNo = injectionCabinetLabel.MoldNo;
inl.UserCreateName = "admin";
inl.CreateDate = DateTime.Now;
inl.Status = "1";
injectionCabinetLabels.Add(inl);
}
return injectionCabinetLabels;
}