/// <summary> /// get table record /// <summary> /// <param name=id>id</param> /// <param name=out emsg>return error message</param> ///<returns>get a record detail of sysbulletin</returns> public modSysBulletin GetItem(int?id, out string emsg) { try { //Execute a query to read the categories string sql = string.Format("select id,title,msg,attach_file,start_time,end_time,update_user,update_time from sys_bulletin where id={0} order by id", id); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { if (rdr.Read()) { modSysBulletin model = new modSysBulletin(); model.Id = dalUtility.ConvertToInt(rdr["id"]); model.Title = dalUtility.ConvertToString(rdr["title"]); model.Msg = dalUtility.ConvertToString(rdr["msg"]); model.AttachFile = dalUtility.ConvertToString(rdr["attach_file"]); model.StartTime = dalUtility.ConvertToDateTime(rdr["start_time"]); model.EndTime = dalUtility.ConvertToDateTime(rdr["end_time"]); 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); } }
protected override void Find() { for (int i = 0; i < DBGrid.Rows.Count; i++) { modSysBulletin mod = (modSysBulletin)DBGrid.Rows[i].DataBoundItem; if (mod.Id.ToString().CompareTo(FindText) == 0) { DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0]; return; } } }
private void DBGrid_SelectionChanged(object sender, EventArgs e) { if (DBGrid.CurrentRow != null) { modSysBulletin mod = (modSysBulletin)DBGrid.CurrentRow.DataBoundItem; txtId.Text = mod.Id.ToString(); txtTitle.Text = mod.Title; txtMessage.Text = mod.Msg; txtAttachFile.Text = mod.AttachFile; dtpStartTime.Value = mod.StartTime; dtpEndTime.Value = mod.EndTime; FindText = mod.Id.ToString(); } }
/// <summary> /// get all sysbulletin /// <summary> /// <param name=out emsg>return error message</param> ///<returns>details of all sysbulletin</returns> public BindingCollection <modSysBulletin> GetIList(bool showall, out string emsg) { try { BindingCollection <modSysBulletin> modellist = new BindingCollection <modSysBulletin>(); //Execute a query to read the categories string sql = string.Empty; if (showall) { sql = "select id,title,msg,attach_file,start_time,end_time,update_user,update_time from sys_bulletin order by id desc"; } else { sql = "select id,title,msg,attach_file,start_time,end_time,update_user,update_time from sys_bulletin where start_time<=getdate() and end_time>=getdate() order by id desc"; } using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modSysBulletin model = new modSysBulletin(); model.Id = dalUtility.ConvertToInt(rdr["id"]); model.Title = dalUtility.ConvertToString(rdr["title"]); model.Msg = dalUtility.ConvertToString(rdr["msg"]); model.AttachFile = dalUtility.ConvertToString(rdr["attach_file"]); model.StartTime = dalUtility.ConvertToDateTime(rdr["start_time"]); model.EndTime = dalUtility.ConvertToDateTime(rdr["end_time"]); 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); } }
/// <summary> /// update a sysbulletin /// <summary> /// <param name=id>id</param> /// <param name=mod>model object of sysbulletin</param> /// <param name=out emsg>return error message</param> /// <returns>true/false</returns> public bool Update(int?id, modSysBulletin mod, out string emsg) { try { string sql = string.Format("update sys_bulletin set title='{0}',msg='{1}',attach_file='{2}',start_time='{3}',end_time='{4}',update_user='******', update_time=getdate() where id={6}", mod.Title, mod.Msg, mod.AttachFile, mod.StartTime, mod.EndTime, mod.UpdateUser, id); 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 sysbulletin /// <summary> /// <param name=mod>model object of sysbulletin</param> /// <param name=out emsg>return error message</param> /// <returns>true/false</returns> public bool Insert(modSysBulletin mod, out string emsg) { try { string sql = string.Format("insert into sys_bulletin(title,msg,attach_file,start_time,end_time,update_user,update_time)values('{0}','{1}','{2}','{3}','{4}','{5}',getdate())", mod.Title, mod.Msg, mod.AttachFile, mod.StartTime, mod.EndTime, 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); } }
protected override bool Save() { try { this.Cursor = Cursors.WaitCursor; int?Id = Convert.ToInt32(txtId.Text); dtpEndTime.Refresh(); dtpStartTime.Refresh(); modSysBulletin mod = new modSysBulletin(Id, txtTitle.Text.Trim(), txtMessage.Text.Trim(), txtAttachFile.Text.Trim(), dtpStartTime.Value, dtpEndTime.Value, Util.UserId, DateTime.Now); bool ret = false; if (_status == 1) { ret = _dal.Insert(mod, out Util.emsg); } else if (_status == 2) { ret = _dal.Update(Id, mod, out Util.emsg); } if (ret) { Util.ChangeStatus(this, true); LoadData(); FindText = txtId.Text.Trim(); Find(); } return(ret); } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } finally { this.Cursor = Cursors.Default; } }