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; }