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); }