public bool MatPrepareUpdate(matPlanBLL u) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { String sql = @"UPDATE tbl_matplan SET " + Prepare + "=@mat_preparing, " + Transferred + "=@mat_transferred, " + MatFrom + "=@mat_from, " + UpdatedDate + "=@updated_date, " + UpdatedBy + "=@updated_by " + " WHERE mat_code=@mat_code AND plan_id=@plan_id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@mat_code", u.mat_code); cmd.Parameters.AddWithValue("@plan_id", u.plan_id); cmd.Parameters.AddWithValue("@mat_transferred", u.mat_transferred); cmd.Parameters.AddWithValue("@mat_preparing", u.mat_preparing); cmd.Parameters.AddWithValue("@mat_from", u.mat_from); cmd.Parameters.AddWithValue("@updated_date", u.updated_date); cmd.Parameters.AddWithValue("@updated_by", u.updated_by); conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully then the rows' value = 0 if (rows > 0) { //query successful isSuccess = true; } else { //Query falled isSuccess = false; } } catch (Exception ex) { Module.Tool tool = new Module.Tool(); tool.saveToText(ex); } finally { conn.Close(); } return(isSuccess); }
public frmMatAddOrEdit(matPlanBLL u, bool addingMaterial) { InitializeComponent(); editMode = true; addMode = addingMaterial; uMatPlan = u; loadItemCategoryData(); cmbParentName.Text = u.part_name; cmbParentCode.Text = u.part_code; cmbPlanID.Items.Add(u.plan_id.ToString()); cmbPlanID.SelectedIndex = 0; txtFac.Text = u.pro_location; txtMac.Text = u.pro_machine; txtAblePro.Text = u.pro_max_qty; txtTargetQty.Text = u.pro_target_qty; txtStart.Text = Convert.ToDateTime(u.pro_start).ToShortDateString(); txtEnd.Text = Convert.ToDateTime(u.pro_end).ToShortDateString(); if (!addingMaterial) { cmbChildCat.Text = u.mat_cat; cmbChildName.Items.Add(u.mat_name); cmbChildName.SelectedIndex = 0; cmbChildCode.Items.Add(u.mat_code); cmbChildCode.SelectedIndex = 0; txtMatUseQty.Text = u.plan_to_use.ToString(); cmbChildCat.Enabled = false; cmbChildName.Enabled = false; cmbChildCode.Enabled = false; } cmbParentName.Enabled = false; cmbParentCode.Enabled = false; cmbPlanID.Enabled = false; updateTestName(); }
public frmMatAddOrEdit(DataTable dt, matPlanBLL u, string ParentCode, bool AddMaterial) { InitializeComponent(); dt_matplan = dt; if (!AddMaterial) { editMode = false; } addMode = AddMaterial; loadItemCategoryData(); cmbParentName.Text = tool.getItemName(ParentCode); cmbParentCode.Text = ParentCode; loadPlanID(); LoadPlanData(u.plan_id); if (!AddMaterial) { editMode = true; cmbChildCat.Text = u.mat_cat; cmbChildName.Items.Add(u.mat_name); cmbChildName.SelectedIndex = 0; cmbChildCode.Items.Add(u.mat_code); cmbChildCode.SelectedIndex = 0; txtMatUseQty.Text = u.plan_to_use.ToString(); cmbChildCat.Enabled = false; cmbChildName.Enabled = false; cmbChildCode.Enabled = false; } cmbPlanID.SelectedIndex = 0; cmbParentName.Enabled = false; cmbParentCode.Enabled = false; //cmbPlanID.Enabled = false; updateTestName(); }
public bool Update(matPlanBLL u) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { String sql = @"UPDATE tbl_matplan SET " + PlanToUse + "=@plan_to_use" + " WHERE mat_code=@mat_code"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@mat_code", u.mat_code); cmd.Parameters.AddWithValue("@plan_to_use", u.plan_to_use); conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully then the rows' value = 0 if (rows > 0) { //query successful isSuccess = true; } else { //Query falled isSuccess = false; } } catch (Exception ex) { Module.Tool tool = new Module.Tool(); tool.saveToText(ex); } finally { conn.Close(); } return(isSuccess); }
public bool Insert(matPlanBLL u) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { String sql = @"INSERT INTO tbl_matplan (" + MatCode + "," + PlanID + "," + PlanToUse + "," + MatUsed + "," + Active + "," + MatNote + "," + UpdatedDate + "," + UpdatedBy + ") VALUES" + "(@mat_code,@plan_id," + "@plan_to_use," + "@mat_used," + "@active," + "@mat_note," + "@updated_date," + "@updated_by)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@mat_code", u.mat_code); cmd.Parameters.AddWithValue("@plan_id", u.plan_id); cmd.Parameters.AddWithValue("@plan_to_use", u.plan_to_use); cmd.Parameters.AddWithValue("@mat_used", u.mat_used); cmd.Parameters.AddWithValue("@active", u.active); cmd.Parameters.AddWithValue("@mat_note", u.mat_note); cmd.Parameters.AddWithValue("@updated_date", u.updated_date); cmd.Parameters.AddWithValue("@updated_by", u.updated_by); conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully then the rows' value = 0 if (rows > 0) { //query successful isSuccess = true; } else { //Query falled isSuccess = false; } } catch (Exception ex) { Module.Tool tool = new Module.Tool(); tool.saveToTextAndMessageToUser(ex); } finally { conn.Close(); } return(isSuccess); }