/// <summary> /// get table record /// <summary> /// <param name=warehouseid>warehouseid</param> /// <param name=out emsg>return error message</param> ///<returns>get a record detail of warehouselist</returns> public modWarehouseList GetItem(string warehouseid, out string emsg) { try { //Execute a query to read the categories string sql = string.Format("select warehouse_id,warehouse_desc,status,default_flag,update_user,update_time from warehouse_list where warehouse_id='{0}' order by warehouse_id", warehouseid); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { if (rdr.Read()) { modWarehouseList model = new modWarehouseList(); model.WarehouseId = dalUtility.ConvertToString(rdr["warehouse_id"]); model.WarehouseDesc = dalUtility.ConvertToString(rdr["warehouse_desc"]); model.Status = dalUtility.ConvertToInt(rdr["status"]); model.DefaultFlag = dalUtility.ConvertToInt(rdr["default_flag"]); model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]); model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]); emsg = null; return(model); } else { emsg = "Error on read data"; return(null); } } } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
/// <summary> /// get all warehouselist /// <summary> /// <param name=validonly>status is valid</param> /// <param name=out emsg>return error message</param> ///<returns>details of all warehouselist</returns> public BindingCollection <modWarehouseList> GetIList(bool validonly, out string emsg) { try { BindingCollection <modWarehouseList> modellist = new BindingCollection <modWarehouseList>(); //Execute a query to read the categories string getwhere = validonly == true ? "and status=1" : string.Empty; string sql = "select warehouse_id,warehouse_desc,status,default_flag,update_user,update_time from warehouse_list where warehouse_id<>'ÁÙʱ' " + getwhere + " order by warehouse_id"; using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modWarehouseList model = new modWarehouseList(); model.WarehouseId = dalUtility.ConvertToString(rdr["warehouse_id"]); model.WarehouseDesc = dalUtility.ConvertToString(rdr["warehouse_desc"]); model.Status = dalUtility.ConvertToInt(rdr["status"]); model.DefaultFlag = dalUtility.ConvertToInt(rdr["default_flag"]); model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]); model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]); modellist.Add(model); } } emsg = null; return(modellist); } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
private void DBGrid_SelectionChanged(object sender, EventArgs e) { if (DBGrid.CurrentRow != null) { modWarehouseList mod = (modWarehouseList)DBGrid.CurrentRow.DataBoundItem; txtWarehouseId.Text = mod.WarehouseId; txtWarehouseDesc.Text = mod.WarehouseDesc; cboStatus.SelectedIndex = Convert.ToInt32(mod.Status); cboDefault.SelectedIndex = Convert.ToInt32(mod.DefaultFlag); FindText = mod.WarehouseId; } }
protected override void Find() { for (int i = 0; i < DBGrid.Rows.Count; i++) { modWarehouseList mod = (modWarehouseList)DBGrid.Rows[i].DataBoundItem; if (mod.WarehouseId.CompareTo(FindText) == 0) { DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0]; DBGrid_SelectionChanged(null, null); return; } } }
protected override bool Save() { try { this.Cursor = Cursors.WaitCursor; if (string.IsNullOrEmpty(txtWarehouseId.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("Warehouse Id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtWarehouseId.Focus(); return(false); } modWarehouseList mod = new modWarehouseList(); mod.WarehouseId = txtWarehouseId.Text.Trim(); mod.WarehouseDesc = txtWarehouseDesc.Text.Trim(); mod.Status = cboStatus.SelectedIndex; mod.DefaultFlag = cboDefault.SelectedIndex; mod.UpdateUser = Util.UserId; bool ret = false; if (_status == 1) { ret = _dal.Insert(mod, out Util.emsg); } else if (_status == 2) { ret = _dal.Update(txtWarehouseId.Text, mod, out Util.emsg); } if (ret) { Util.ChangeStatus(this, true); DBGrid.Enabled = true; LoadData(); FindText = mod.WarehouseId; Find(); } return(ret); } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } finally { this.Cursor = Cursors.Default; } }
/// <summary> /// update a warehouselist /// <summary> /// <param name=warehouseid>warehouseid</param> /// <param name=mod>model object of warehouselist</param> /// <param name=out emsg>return error message</param> /// <returns>true/false</returns> public bool Update(string warehouseid, modWarehouseList mod, out string emsg) { try { string sql = string.Format("update warehouse_list set warehouse_desc='{0}',status={1},default_flag={2},update_user='******',update_time=getdate() where warehouse_id='{4}'", mod.WarehouseDesc, mod.Status, mod.DefaultFlag, mod.UpdateUser, warehouseid); int i = SqlHelper.ExecuteNonQuery(sql); if (i > 0) { emsg = null; return(true); } else { emsg = "Unknown error when ExecuteNonQuery!"; return(false); } } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(false); } }
/// <summary> /// insert a warehouselist /// <summary> /// <param name=mod>model object of warehouselist</param> /// <param name=out emsg>return error message</param> /// <returns>true/false</returns> public bool Insert(modWarehouseList mod, out string emsg) { try { string sql = string.Format("insert into warehouse_list(warehouse_id,warehouse_desc,status,default_flag,update_user,update_time)values('{0}','{1}',{2},{3},'{4}',getdate())", mod.WarehouseId, mod.WarehouseDesc, mod.Status, mod.DefaultFlag, mod.UpdateUser); int i = SqlHelper.ExecuteNonQuery(sql); if (i > 0) { emsg = null; return(true); } else { emsg = "Unknown error when ExecuteNonQuery!"; return(false); } } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(false); } }