public List <ASSETKKF_MODEL.Data.Mssql.Asset.TaskAudit> GetTracking(TaskAudit d, SqlTransaction transac = null, string conStr = null)
{
DynamicParameters param = new DynamicParameters();
sql = " SELECT * FROM [dbo].[FC_TrackingAudit] (" + QuoteStr(d.COMPANY);
sql += " ," + QuoteStr(d.INPID);
sql += " ) where 1 = 1";
if (!String.IsNullOrEmpty(d.COMPANY))
{
sql += " and COMPANY = '" + d.COMPANY + "'";
}
if (!String.IsNullOrEmpty(d.YR.ToString()))
{
sql += " and YR = '" + d.YR + "'";
}
if (!String.IsNullOrEmpty(d.MN.ToString()))
{
sql += " and MN = '" + d.MN + "'";
}
var res = Query <ASSETKKF_MODEL.Data.Mssql.Asset.TaskAudit>(sql, param, conStr).ToList();
return(res);
}
protected override void ExecuteChild(AsFixedAsset dataReq, ResponseAPI dataRes)
{
var res = new TaskAuditRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var state = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().AuditCancel(dataReq, null, conString);
var taskReq = new TaskAudit()
{
INPID = dataReq.INPID,
COMPANY = dataReq.COMPANY
};
var lst = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().GetData(taskReq, null, conString);
if (lst == null)
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
else
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
res.TaskAuditLST = lst;
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
private void OK_Click(object sender, EventArgs e)
{
// TODO: validate
var progress = Int32.Parse(convert(progressBox.Text));
//////
Audit = new TaskAudit(task, Authentication.getInstance().ActiveUser,
descBox.Text, progress, attachmentPanel1.getAttachments());
TaskAuditStorage.getInstance().create(Audit);
task.Progress = progress;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
public AuditTaskForm(TaskAudit audit)
{
InitializeComponent();
DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.task = audit.AuditTask;
this.targetName.Text = task.Title;
this.progressBox.Text = audit.Progress.ToString();
this.descBox.Text = audit.Description;
this.attachmentPanel1.populate(audit.Attachments);
this.attachmentPanel1.ViewMode = true;
this.progressBox.ReadOnly = true;
this.descBox.ReadOnly = true;
this.OK.Visible = false;
}
public void remove(TaskAudit item)
{
audits.Remove(item);
}
public void create(TaskAudit item)
{
audits.Add(item);
}
