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