/// <summary>
/// get all remarklist
/// <summary>
/// <param name=remarktype>remarktype</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all remarklist</returns>
public BindingCollection <modRemarkList> GetIList(string remarktype, out string emsg)
{
try
{
BindingCollection <modRemarkList> modellist = new BindingCollection <modRemarkList>();
//Execute a query to read the categories
string sql = string.Format("select remark_type,remark,update_user,update_time from remark_list where remark_type='{0}' order by remark_type,remark", remarktype);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modRemarkList model = new modRemarkList();
model.RemarkType = dalUtility.ConvertToString(rdr["remark_type"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
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>
/// get table record
/// <summary>
/// <param name=remarktype>remarktype</param>
/// <param name=remark>remark</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of remarklist</returns>
public modRemarkList GetItem(string remarktype, string remark, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select remark_type,remark,update_user,update_time from remark_list where remark_type='{0}' and remark='{1}' order by remark_type,remark", remarktype, remark);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modRemarkList model = new modRemarkList();
model.RemarkType = dalUtility.ConvertToString(rdr["remark_type"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
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);
}
}
private void DBGrid_SelectionChanged(object sender, EventArgs e)
{
if (DBGrid.CurrentRow != null)
{
modRemarkList mod = (modRemarkList)DBGrid.CurrentRow.DataBoundItem;
txtRemark.Text = mod.Remark;
}
else
{
Util.EmptyFormBox(this);
}
}
protected override void Find()
{
for (int i = 0; i < DBGrid.Rows.Count; i++)
{
modRemarkList mod = (modRemarkList)DBGrid.Rows[i].DataBoundItem;
if (mod.Remark.IndexOf(FindText) >= 0)
{
DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0];
DBGrid_SelectionChanged(null, null);
return;
}
}
}
/// <summary>
/// update a remarklist
/// <summary>
/// <param name=remarktype>remarktype</param>
/// <param name=remark>remark</param>
/// <param name=mod>model object of remarklist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string remarktype, string remark, modRemarkList mod, out string emsg)
{
try
{
string sql = string.Format("update remark_list set update_user='******',update_time=getdate() where remark_type='{1}' and remark='{2}'", mod.UpdateUser, remarktype, remark);
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 remarklist
/// <summary>
/// <param name=mod>model object of remarklist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modRemarkList mod, out string emsg)
{
try
{
string sql = string.Format("insert into remark_list(remark_type,remark,update_user,update_time)values('{0}','{1}','{2}',getdate())", mod.RemarkType, mod.Remark, 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;
if (string.IsNullOrEmpty(txtRemark.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("store id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRemark.Focus();
return(false);
}
if (string.IsNullOrEmpty(_remarktype))
{
MessageBox.Show(clsTranslate.TranslateString("Type Id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
tvLeft.Focus();
return(false);
}
modRemarkList mod = new modRemarkList(_remarktype, txtRemark.Text.Trim(), Util.UserId, DateTime.Now);
bool ret = _dal.Insert(mod, out Util.emsg);
if (ret)
{
Util.ChangeStatus(this, true);
LoadData();
}
return(ret);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
finally
{
this.Cursor = Cursors.Default;
}
}
