private void dgv_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { string productID = dgv.Rows[e.RowIndex].Cells[1].Value.ToString(); Ingreadient ob = supBLL.GetIngredientWithID(productID); if (ob != null) { txtlIngredientd.Text = ob.IngredientId; txtName.Text = ob.IngredientName; txtExchange.Text = ob.IngredientExchange; //txtAddress.Text = ob.SupplierAddress; txtUnit.Text = ob.IngredientUnit; txtMeasure.Text = ob.IngredientMeasure; txtDonviGoc.Text = ob.IntakeUnit; } //// Xóa if (e.ColumnIndex == 6) { if (CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("KhoaNv"), Common.clsLanguages.GetResource("Information"), Common.Config.CUSTOM_MESSAGEBOX_ICON.Information, Common.Config.CUSTOM_MESSAGEBOX_BUTTON.YESNO) == DialogResult.Yes) { int Xoa = supBLL.DeleteIngredient(productID); if (Xoa == 1) // xóa thành côg { CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("KhoaTCong"), Common.clsLanguages.GetResource("Information"), Common.Config.CUSTOM_MESSAGEBOX_ICON.Information, Common.Config.CUSTOM_MESSAGEBOX_BUTTON.OK); dgv.Rows.RemoveAt(e.RowIndex); foreach (Control c in this.pInput.Controls) { if (c is TextBox) { ((TextBox)c).Text = String.Empty; } if (c is RichTextBox) { ((RichTextBox)c).Text = String.Empty; } if (c is ComboBox) { ((ComboBox)c).SelectedIndex = 0; } if (c is CheckBox) { ((CheckBox)c).Checked = false; } lblTB1.Text = "..."; lblTB.Text = "..."; } DanhLaiSTT(); } } } } }
public int UpdateIngredient(Ingreadient employ) { /// 1: update thành công /// 0: Update ko thành công int res = 0; string queryStr = "UPDATE ingredient SET "; if (!string.IsNullOrEmpty(employ.IngredientName)) { queryStr += string.Format(" IngredientName = '{0}',", employ.IngredientName); } //if (!string.IsNullOrEmpty(employ.Unit)) //{ queryStr += string.Format(" IngredientMeasure = '{0}',", employ.IngredientMeasure); //} //if (!string.IsNullOrEmpty(employ.Notes)) //{ queryStr += string.Format(" IngredientExchange = '{0}',", employ.IngredientExchange); //} queryStr += string.Format(" IngredientUnit = '{0}',", employ.IngredientUnit); queryStr += string.Format(" IntakeUnit = '{0}'", employ.IntakeUnit); queryStr += string.Format(" WHERE IngredientId = '{0}'", employ.IngredientId); Program.destopService.DataExecute(Program.Username, Program.Password, queryStr, ref errorString); if (string.IsNullOrEmpty(errorString)) { res = 1; } return(res); }
public Ingreadient GetIngredientWithID(string id) { Ingreadient reEmp = new Ingreadient(); DataSet ds = new DataSet(); string query = @"SELECT * FROM `ingredient` WHERE `IngredientId`='" + id + "' "; //Program.destopService.DataQuery(Program.Username, Program.Password, query, ref ds, "X", ref errorString); Program.destopService.DataQuery(Program.Username, Program.Password, query, ref ds, "X", ref errorString); if (string.IsNullOrEmpty(errorString) && ds.Tables[0].Rows.Count > 0) { reEmp.IngredientId = ds.Tables[0].Rows[0]["IngredientId"].ToString(); reEmp.IngredientName = ds.Tables[0].Rows[0]["IngredientName"].ToString(); reEmp.IngredientMeasure = ds.Tables[0].Rows[0]["IngredientMeasure"].ToString(); reEmp.IngredientExchange = ds.Tables[0].Rows[0]["IngredientExchange"].ToString(); reEmp.IngredientUnit = ds.Tables[0].Rows[0]["IngredientUnit"].ToString(); reEmp.IntakeUnit = ds.Tables[0].Rows[0]["IntakeUnit"].ToString(); } else { reEmp = null; } return(reEmp); }
public frmManageIngreadient() { InitializeComponent(); sup = new Ingreadient(); supSea = new Ingreadient(); SettingControl(); SetUIChanges(); }
private void bntSeach_Click(object sender, EventArgs e) { CurPage = 1; totalPage = 1; supSea = new Ingreadient(); supSea.IngredientId = txtlIngredientd.Text; supSea.IngredientName = txtName.Text; //supSea.SupplierAddress = txtAddress.Text; supSea.IngredientMeasure = txtMeasure.Text; supSea.IngredientExchange = txtExchange.Text; supSea.IngredientUnit = txtUnit.Text; SearchProducts(1); }
public DataTable SearchIngredient(Ingreadient sup, int page, out int TotalRecord) { int RecordPerPage = int.Parse(ConfigurationManager.AppSettings["MaxRecordDesk"]); int limit = (page - 1) * RecordPerPage; //int offset = limit + RecordPerPage; TotalRecord = 0; DataTable res = new DataTable(); DataSet ds = new DataSet(); ///p_CreateBy VARCHAR(20), //p_CreatedDate DATETIME, //p_ModifiedBy VARCHAR(20), p_SupplierId VARCHAR(20) , string[][] param = { new string[] { "p_IngredientId", string.IsNullOrEmpty(sup.IngredientId)?null:sup.IngredientId }, new string[] { "p_IngredientName", string.IsNullOrEmpty(sup.IngredientName)?null:sup.IngredientName }, new string[] { "p_IngredientMeasure", string.IsNullOrEmpty(sup.IngredientMeasure)?null: sup.IngredientMeasure }, new string[] { "p_IngredientExchange", string.IsNullOrEmpty(sup.IngredientExchange)?null: sup.IngredientExchange }, new string[] { "p_IngredientUnit", string.IsNullOrEmpty(sup.IngredientUnit)?null: sup.IngredientUnit }, new string[] { "p_NoStart", limit.ToString() }, new string[] { "p_NoEnd", RecordPerPage.ToString() } }; Program.destopService.DataStoreProcQuery_Param(Program.Username, Program.Password, "spSearch_Ingredients", ref ds, param, ref errorString); if (string.IsNullOrEmpty(errorString)) { res = ds.Tables[0]; TotalRecord = int.Parse(ds.Tables[1].Rows[0][0].ToString()); } else { res = null; } return(res); }
private void SaveData() { // check xem có trong db chưa? string SupplierID = txtlIngredientd.Text.Trim(); Ingreadient pro = new Ingreadient(); pro = supBLL.GetIngredientWithID(SupplierID); supSea = new Ingreadient(); supSea.IngredientName = txtName.Text; //supSea.SupplierAddress = txtAddress.Text; supSea.IngredientMeasure = txtMeasure.Text; supSea.IngredientExchange = txtExchange.Text; supSea.IngredientUnit = txtUnit.Text; supSea.IntakeUnit = txtDonviGoc.Text; if (pro != null) {// Cập nhật if (CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("CommonCodeUpdate"), Common.clsLanguages.GetResource("Information"), Common.Config.CUSTOM_MESSAGEBOX_ICON.Information, Common.Config.CUSTOM_MESSAGEBOX_BUTTON.YESNO) == DialogResult.Yes) { supSea.IngredientId = SupplierID; int i = supBLL.UpdateIngredient(supSea); if (i == 1) { lblTB1.Text = Common.clsLanguages.GetResource("UpdateSuccess1"); } else { lblTB1.Text = Common.clsLanguages.GetResource("UpdateNoSuccess1"); } } } else {// Thêm mới if (CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("CommonCodeCreate"), Common.clsLanguages.GetResource("Information"), Common.Config.CUSTOM_MESSAGEBOX_ICON.Information, Common.Config.CUSTOM_MESSAGEBOX_BUTTON.YESNO) == DialogResult.Yes) { SupplierID = supBLL.CreateSupplierId(); supSea.IngredientId = SupplierID; int i = supBLL.InsertIngredient(supSea); if (i == 1) { lblTB1.Text = Common.clsLanguages.GetResource("InsertSuccess1"); txtlIngredientd.Text = SupplierID; } else { lblTB1.Text = Common.clsLanguages.GetResource("InsertNoSuccess1"); } } } SearchProducts(1); }
public int InsertIngredient(Ingreadient employ) { /// 1: update thành công /// 0: Update ko thành công int res = 0; string queryStr = "INSERT INTO"; queryStr += " ingredient ("; if (!string.IsNullOrEmpty(employ.IngredientId)) { queryStr += "`IngredientId`,"; } if (!string.IsNullOrEmpty(employ.IngredientName)) { queryStr += "`IngredientName`,"; } if (!string.IsNullOrEmpty(employ.IngredientMeasure)) { queryStr += "`IngredientMeasure`,"; } if (!string.IsNullOrEmpty(employ.IngredientExchange)) { queryStr += "`IngredientExchange`,"; } if (!string.IsNullOrEmpty(employ.IngredientUnit)) { queryStr += "`IngredientUnit`,"; } queryStr += "`IntakeUnit`"; queryStr += ") VALUES ("; if (!string.IsNullOrEmpty(employ.IngredientId)) { queryStr += string.Format("'{0}',", employ.IngredientId); } if (!string.IsNullOrEmpty(employ.IngredientName)) { queryStr += string.Format("'{0}',", employ.IngredientName); } if (!string.IsNullOrEmpty(employ.IngredientMeasure)) { queryStr += string.Format("'{0}',", employ.IngredientMeasure); } if (!string.IsNullOrEmpty(employ.IngredientExchange)) { queryStr += string.Format("'{0}',", employ.IngredientExchange); } if (!string.IsNullOrEmpty(employ.IngredientUnit)) { queryStr += string.Format("'{0}',", employ.IngredientUnit); } queryStr += string.Format("'{0}'", employ.IntakeUnit); queryStr += ")"; Program.destopService.DataExecute(Program.Username, Program.Password, queryStr, ref errorString); if (string.IsNullOrEmpty(errorString)) { res = 1; } return(res); }