private void cmdedit_Click(object sender, EventArgs e)
{
if (txtCompleteNo.Text.Trim() == "")
{
MessageBox.Show("กรุณาป้อน completeno !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtCompleteNo.Focus();
return;
}
if (txtPartName.Text.Trim() == "")
{
MessageBox.Show("กรุณาป้อน PartName!!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPartName.Focus();
return;
}
if (txtModel.Text.Trim() == "")
{
MessageBox.Show("กรุณาป้อน Model!!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtModel.Focus();
return;
}
if (txtScanStep.Text.Trim() == "")
{
MessageBox.Show("กรุณาป้อน ScanStep!!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtScanStep.Focus();
return;
}
CompleteNumber _completeNumber = new CompleteNumber();
_completeNumber.CompleteNo = txtCompleteNo.Text.Trim();
_completeNumber.PartName =txtPartName.Text.Trim();
_completeNumber.ModelNo = txtModel.Text.Trim();
_completeNumber.ScanStep =txtScanStep.Text.Trim();
_completeNumber.DateCretate = Convert.ToString(DateTime.Now);
_completeNumber.UserCreateName = "admin";
_completeNumber.Status="1";
int result = service.CreateCompleteNumber(_completeNumber);
if (result > 0)
{
Console.WriteLine("Insert complete");
lblresult.Visible = true;
lblresult.Text = " บันทึกเรียบร้อย";
List<CompleteNumber> completeNumbers = service.getCompleteAll();
dgvList.DataSource = completeNumbers;
FormatdgvList();
dgvList.ReadOnly = true;
}
else
{
Console.WriteLine("Insert Not Complete");
lblresult.Text = "ไม่สามารถบันทึกได้";
return;
}
}
public int CreateCompleteNumber(CompleteNumber newCompleteNumber)
{
int result = -1;
try
{
conn = db.openConn();
tr = conn.BeginTransaction();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO complete_numbers(complete_no,part_name,model_id,scan_step,date_create,user_create_name,status)");
sb.Append(" VALUES (@complete_no,@part_name,@model_id,@scan_step,@date_create,@user_create_name,@status)");
string sqlsave;
sqlsave = sb.ToString();
comm = new SqlCommand();
comm.Connection = conn;
comm.Transaction = tr;
comm.CommandText = sqlsave;
comm.Parameters.Clear();
comm.Parameters.Add("@complete_no", SqlDbType.NVarChar).Value = newCompleteNumber.CompleteNo;
comm.Parameters.Add("@part_name", SqlDbType.NVarChar).Value = newCompleteNumber.PartName;
comm.Parameters.Add("@model_id", SqlDbType.NVarChar).Value = newCompleteNumber.ModelNo;
comm.Parameters.Add("@scan_step", SqlDbType.NVarChar).Value = newCompleteNumber.ScanStep;
comm.Parameters.Add("@date_create", SqlDbType.NVarChar).Value = newCompleteNumber.DateCretate;
comm.Parameters.Add("@user_create_name", SqlDbType.NVarChar).Value = newCompleteNumber.UserCreateName;
comm.Parameters.Add("@status", SqlDbType.NVarChar).Value = newCompleteNumber.Status;
comm.ExecuteNonQuery();
tr.Commit();
result = 1;
}
catch (Exception ex)
{
tr.Rollback();
conn.Close();
return result;
throw ex;
}
finally
{
conn.Close();
}
return result;
}
public int DeleteCompleteNumber(CompleteNumber _completeNumber)
{
int result = -1;
try
{
conn = db.openConn();
tr = conn.BeginTransaction();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" DELETE complete_numbers ");
sb.Append(" WHERE (complete_no='" + _completeNumber.CompleteNo + "')");
string sqlUpdate;
sqlUpdate = sb.ToString();
comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = sqlUpdate;
comm.Transaction = tr;
comm.Parameters.Clear();
comm.ExecuteNonQuery();
tr.Commit();
result = 1;
}
catch (Exception ex)
{
tr.Rollback();
conn.Close();
return result;
throw ex;
}
finally
{
conn.Close();
}
return result;
}
public List<CompleteNumber> getCompleteByComplete(string _completeno)
{
List<CompleteNumber> completeNumbers = new List<CompleteNumber>();
CompleteNumber c;
try
{
conn = db.openConn();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" SELECT id,complete_no,part_name,model_id,scan_step,date_create,user_create_name,status FROM complete_numbers ");
sb.Append(" where complete_no='" + _completeno + "'");
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)
{
c = new CompleteNumber();
c.ID = Convert.ToInt32(drw["id"].ToString());
c.CompleteNo = drw["complete_no"].ToString();
c.PartName = drw["part_name"].ToString();
c.ModelNo = drw["model_id"].ToString();
//c.Customer = drw["customer"].ToString();
c.ScanStep = drw["scan_step"].ToString();
c.DateCretate = drw["date_create"].ToString();
c.UserCreateName = drw["user_create_name"].ToString();
c.Status = drw["status"].ToString();
completeNumbers.Add(c);
}
}
}
catch (Exception ex)
{
dr.Close();
conn.Close();
return null;
throw ex;
}
finally
{
conn.Close();
}
return completeNumbers;
}
