/// <summary>
/// close a job by Desk
/// </summary>
/// <param name="strsql">sql sentence</param>
/// <returns>0 or 1</returns>
public static int closeByDesk(JobInfo job)
{
string strsql = string.Format("UPDATE `jobs` SET `desk`=0 WHERE id = 2", job.desk.UserId);
return(SqliteHelper.ExecuteNoneQuery(strsql));
}
/// <summary>
/// set a job's priority
/// </summary>
/// <param name="strsql">sql sentence</param>
/// <returns>0 or 1</returns>
public static int setPriority(JobInfo job)
{
string strsql = string.Format("UPDATE `jobs` SET `priority`=0, WHERE id = 2", job.priority);
return(SqliteHelper.ExecuteNoneQuery(strsql));
}
public static IList <JobInfo> GetJobsBySQL(string strsql)
{
IList <JobInfo> jobs = new List <JobInfo>();
DataTable dt = SqliteHelper.ExecuteTable(strsql);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//to do: some fiels have been seperated from jobs
JobInfo job = new JobInfo();
job.id = dt.Rows[i]["id"].ToString();
job.carNo = dt.Rows[i]["carNo"].ToString();
string customerId = dt.Rows[i]["customer"].ToString();
if (customerId != null && customerId.Length > 0)
{
job.customer = Sys_roleService.GetUserByiId(int.Parse(customerId));
}
job.jobDescription = dt.Rows[i]["jobDescription"].ToString();
try
{
job.createdate = DateTime.Parse(dt.Rows[i]["createdate"].ToString());
}
catch
{
job.createdate = DateTime.Now;
}
job.jobStatus = (JobStatus)int.Parse(dt.Rows[i]["jobStatus"].ToString());
job.priority = (Priority)int.Parse(dt.Rows[i]["priority"].ToString());
string type = dt.Rows[i]["jobType"].ToString();
if (type != null && type.Length > 0)
{
job.jobType = (JobType)int.Parse(type);
}
string resolve = dt.Rows[i]["resolve"].ToString();
if (resolve != null && resolve.Length > 0)
{
job.resolve = (ResolveStatus)int.Parse(resolve);
}
//outer key
string deskId = dt.Rows[i]["desk"].ToString();
if (deskId != null && deskId.Length > 0)
{
job.desk = Sys_roleService.GetUserByiId(int.Parse(deskId));
}
string managerId = dt.Rows[i]["manager"].ToString();
if (managerId != null && managerId.Length > 0)
{
job.manager = Sys_roleService.GetUserByiId(int.Parse(managerId));
}
string workerId = dt.Rows[i]["worker"].ToString();
if (workerId != null && workerId.Length > 0)
{
job.worker = Sys_roleService.GetUserByiId(int.Parse(workerId));
}
//add outlet key
string outletID = dt.Rows[i]["outlet"].ToString();
if (outletID != null && outletID.Length > 0)
{
job.outlet = sys_outletService.GetOutletbyotID(int.Parse(outletID));
}
try
{
job.closedate = DateTime.Parse(dt.Rows[i]["closedate"].ToString());
}
catch
{
job.closedate = DateTime.Now;
}
job.comment = dt.Rows[i]["comment"].ToString();
jobs.Add(job);
}
}
return(jobs);
}