/// <summary>
/// get all task group
/// <summary>
/// <param name=validonly>validonly</param>
///<returns>Details about all TaskGroup</returns>
public BindingCollection <modTaskGroup> GetIList(bool validonly, out string emsg)
{
try
{
string sql;
string getwhere = validonly == true ? "and status=1" : string.Empty;
sql = "select group_id,group_desc,status,seq,update_user,update_time from sys_task_group where 1=1 "
+ getwhere + "order by seq";
BindingCollection <modTaskGroup> modellist = new BindingCollection <modTaskGroup>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modTaskGroup model = new modTaskGroup();
model.GroupId = dalUtility.ConvertToString(rdr["group_id"]);
model.GroupDesc = dalUtility.ConvertToString(rdr["group_id"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.Seq = dalUtility.ConvertToInt(rdr["seq"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
modellist.Add(model);
}
}
emsg = "";
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get TaskGroup by groupid
/// <summary>
/// <param name=groupid>groupid</param>
///<returns>get record of TaskGroup</returns>
///<returns>Details about all TaskGroup</returns>
public modTaskGroup GetItem(string groupid, out string emsg)
{
string sql = string.Format("select group_id,group_desc,status,seq,update_user,update_time from sys_task_group where group_id='{0}'", groupid);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modTaskGroup model = new modTaskGroup();
model.GroupId = dalUtility.ConvertToString(rdr["group_id"]);
model.GroupDesc = dalUtility.ConvertToString(rdr["group_id"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.Seq = dalUtility.ConvertToInt(rdr["seq"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
emsg = "";
return(model);
}
else
{
emsg = "";
return(null);
}
}
}
/// <summary>
/// insert a TaskGroup
/// <summary>
/// <param name=mod>mod</param>
/// <returns>true/false</returns>
public bool Insert(modTaskGroup mod, out string emsg)
{
try
{
string sql = string.Format("insert into sys_task_group(group_id,group_desc,status,seq,update_user,update_time)values('{0}','{1}',{2},{3},'{4}',getdate())", mod.GroupId, mod.GroupDesc, mod.Status, mod.Seq, 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.ToString());
return(false);
}
}
/// <summary>
/// update a TaskGroup
/// <summary>
/// <param name=groupid>groupid</param>
/// <param name=mod>mod</param>
/// <returns>true/false</returns>
public bool Update(string groupid, modTaskGroup mod, out string emsg)
{
try
{
string sql = string.Format("update sys_task_group set group_desc='{0}',status={1}, seq= {2}, update_user='******',update_time=getdate() where group_id='{4}'", mod.GroupDesc, mod.Status, mod.Seq, mod.UpdateUser, groupid);
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.ToString());
return(false);
}
}
private void DBGrid_RowValidating(object sender, DataGridViewCellCancelEventArgs e)
{
if (!rowChanged)
{
return;
}
try
{
this.Cursor = Cursors.WaitCursor;
DataGridViewRow row = DBGrid.Rows[e.RowIndex];
string valResult = ValidateRowEntry(e);
if (valResult.Length > 0)
{
row.ErrorText = valResult;
e.Cancel = true;
if (row.IsNewRow)
{
row.ErrorText = "";
DBGrid.CancelEdit();
}
return;
}
string groupid = row.Cells[0].Value.ToString().ToUpper();
string groupdesc = row.Cells[1].Value.ToString();
int status = row.Cells[2].Value == null ? 0 : Convert.ToInt32(row.Cells[2].Value.ToString());
int? seq = Convert.ToInt32(row.Cells[3].Value.ToString());
modTaskGroup mod = new modTaskGroup(groupid, groupdesc, status, seq, Util.UserId, DateTime.Now);
if (Convert.ToDateTime(row.Cells[5].Value).Year == 1)
{
bool ret = _dal.Insert(mod, out Util.emsg);
if (!ret)
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Failure"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
row.Cells[0].Value = row.Cells[0].Value.ToString().ToUpper();
row.Cells[5].Value = DateTime.Now.ToString();
row.Tag = "1";
StatusLabel4.Text = "Add succeed!";
}
}
else
{
bool ret = _dal.Update(groupid, mod, out Util.emsg);
if (!ret)
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Failure"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
row.Cells[0].Value = row.Cells[0].Value.ToString().ToUpper();
row.Cells[5].Value = DateTime.Now.ToString();
StatusLabel4.Text = "Update succeed!";
}
}
rowChanged = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
