/// <summary>
/// get table record
/// <summary>
/// <param name=taskcode>taskcode</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of qstasklist</returns>
public modTaskList GetItem(string taskcode, out string emsg)
{
try
{
string sql = string.Format("select task_code,task_name,status,group_id,task_type,url,web_url,form_name,remark,update_user,update_time from sys_task_list where task_code='{0}'", taskcode);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modTaskList model = new modTaskList(dalUtility.ConvertToString(rdr["task_code"]), dalUtility.ConvertToString(rdr["task_name"]), dalUtility.ConvertToInt(rdr["status"]), dalUtility.ConvertToString(rdr["group_id"]), dalUtility.ConvertToString(rdr["task_type"]), dalUtility.ConvertToString(rdr["url"]), dalUtility.ConvertToString(rdr["web_url"]), dalUtility.ConvertToString(rdr["form_name"]), dalUtility.ConvertToString(rdr["remark"]), dalUtility.ConvertToString(rdr["update_user"]), dalUtility.ConvertToDateTime(rdr["update_time"]));
emsg = "";
return(model);
}
else
{
emsg = "";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
protected override bool Save()
{
if (string.IsNullOrEmpty(txtTaskCode.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("store id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtTaskCode.Focus();
return(false);
}
if (string.IsNullOrEmpty(txtTaskName.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("store name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtTaskName.Focus();
return(false);
}
if (string.IsNullOrEmpty(_groupid))
{
MessageBox.Show(clsTranslate.TranslateString("Group Id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
tvLeft.Focus();
return(false);
}
if (string.IsNullOrEmpty(txtUrl.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Url ") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtUrl.Focus();
return(false);
}
if (string.IsNullOrEmpty(txtFormName.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Form name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtFormName.Focus();
return(false);
}
int? status = cboStatus.SelectedIndex;
string password = Util.Encrypt(txtTaskCode.Text.Trim(), Util.PWD_MASK);
modTaskList mod = new modTaskList(txtTaskCode.Text.Trim(), txtTaskName.Text.Trim(), status, _groupid, cboTaskType.Text.Trim(), txtUrl.Text.Trim(), txtWebUrl.Text.Trim(), txtFormName.Text.Trim(), txtRemark.Text.Trim(), Util.UserId, DateTime.Now);
bool ret = false;
if (_status == 1)
{
ret = _dal.Insert(mod, out Util.emsg);
}
else if (_status == 2)
{
ret = _dal.Update(txtTaskCode.Text, mod, out Util.emsg);
}
if (ret)
{
Util.ChangeStatus(this, true);
LoadData();
FindText = mod.TaskCode;
Find();
}
return(ret);
}
/// <summary>
/// get all qstasklist
/// <summary>
/// <param name=groupidlist>groupidlist</param>
/// <param name=chkurl>chkurl</param>
/// <param name=chkweburl>chkweburl</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all qstasklist</returns>
public BindingCollection <modTaskList> GetIList(string groupidlist, bool chkurl, bool chkweburl, out string emsg)
{
try
{
string groupwhere = string.Empty;
if (!string.IsNullOrEmpty(groupidlist) && groupidlist != "ALL")
{
groupwhere = "and group_id in ('" + groupidlist.Replace(",", "','") + "') ";
}
string urlwhere = string.Empty;
if (chkurl)
{
if (chkweburl)
{
urlwhere = "and LEN(rtrim(ltrim(url)))>0 and LEN(rtrim(ltrim(web_url)))>0 ";
}
else
{
urlwhere = "and LEN(rtrim(ltrim(url)))>0 ";
}
}
else
{
if (chkweburl)
{
urlwhere = "and LEN(rtrim(ltrim(web_url)))>0 ";
}
else
{
urlwhere = string.Empty;
}
}
string sql = "select task_code,task_name,status,group_id,task_type,url,web_url,form_name,remark,update_user,update_time from sys_task_list where 1=1 "
+ groupwhere + urlwhere + " order by group_id, task_code ";
BindingCollection <modTaskList> modellist = new BindingCollection <modTaskList>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modTaskList model = new modTaskList(dalUtility.ConvertToString(rdr["task_code"]), dalUtility.ConvertToString(rdr["task_name"]), dalUtility.ConvertToInt(rdr["status"]), dalUtility.ConvertToString(rdr["group_id"]), dalUtility.ConvertToString(rdr["task_type"]), dalUtility.ConvertToString(rdr["url"]), dalUtility.ConvertToString(rdr["web_url"]), dalUtility.ConvertToString(rdr["form_name"]), dalUtility.ConvertToString(rdr["remark"]), dalUtility.ConvertToString(rdr["update_user"]), dalUtility.ConvertToDateTime(rdr["update_time"]));
modellist.Add(model);
}
}
emsg = "";
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
protected override void Find()
{
for (int i = 0; i < DBGrid.Rows.Count; i++)
{
modTaskList mod = (modTaskList)DBGrid.Rows[i].DataBoundItem;
if (mod.TaskCode.CompareTo(FindText) == 0 || mod.TaskName.IndexOf(FindText) > 0)
{
DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0];
DBGrid_SelectionChanged(null, null);
return;
}
}
}
private void DBGrid_SelectionChanged(object sender, EventArgs e)
{
if (DBGrid.CurrentRow != null)
{
modTaskList mod = (modTaskList)DBGrid.CurrentRow.DataBoundItem;
txtTaskCode.Text = mod.TaskCode;
txtTaskName.Text = mod.TaskName;
cboStatus.SelectedIndex = Convert.ToInt32(mod.Status);
cboTaskType.Text = mod.TaskType;
txtUrl.Text = mod.Url;
txtWebUrl.Text = mod.WebUrl;
txtFormName.Text = mod.FormName;
FindText = mod.TaskCode;
}
else
{
Util.EmptyFormBox(this);
}
}
/// <summary>
/// update a qstasklist
/// <summary>
/// <param name=taskcode>taskcode</param>
/// <param name=mod>mod</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string taskcode, modTaskList mod, out string emsg)
{
try
{
string sql = string.Format("update sys_task_list set task_name='{0}',status={1},url='{2}',web_url='{3}',form_name='{4}',remark='{5}',task_type='{6}',update_user='******',update_time=getdate() where task_code='{8}'", mod.TaskName, mod.Status, mod.Url, mod.WebUrl, mod.FormName, mod.Remark, mod.TaskType, mod.UpdateUser, taskcode);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = "";
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
/// <summary>
/// insert a qstasklist
/// <summary>
/// <param name=mod>mod</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modTaskList mod, out string emsg)
{
try
{
string sql = string.Format("insert into sys_task_list(task_code,task_name,status,group_id,task_type,url,web_url,form_name,remark,update_user,update_time)values('{0}','{1}',{2},'{3}','{4}','{5}','{6}','{7}','{8}','{9}',getdate())", mod.TaskCode, mod.TaskName, mod.Status, mod.GroupId, mod.TaskType, mod.Url, mod.WebUrl, mod.FormName, mod.Remark, mod.UpdateUser);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = "";
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
