/// <summary> /// 單筆審核資料 /// </summary> /// <param name="dataBean">查詢條件</param> /// <param name="sb">傳入之前組好Command</param> /// <param name="isReset">StringBuilder Reset or not</param> public static void GetVisitFormDetailData(OnBizReqAppdOperationBean dataBean, ref StringBuilder sb, bool isReset = false) { if (isReset) { sb = new StringBuilder(); } sb.Append("SELECT VF.CompID + '-' + C.CompName AS CompID_Name,VF.WriterID + '-' + VF.WriterName AS WriterID_Name"); sb.Append(" ,CONVERT(NVARCHAR(10),VF.WriteDate,111) AS WriteDate,VF.EmpID + '-' + VF.EmpNameN AS EmpID_NameN,VF.VisitFormNo"); sb.Append(" ,VF.DeptName,VF.TitleName,VF.Position,VF.Tel_1,VF.Tel_2"); sb.Append(" ,CONVERT(NVARCHAR(10),VF.VisitBeginDate,111) + '~' + CONVERT(NVARCHAR(10),VF.VisitEndDate,111) AS VisitDate"); sb.Append(" ,CONVERT(NVARCHAR (5),VF.BeginTime) + '~' + CONVERT(NVARCHAR (5),VF.EndTime) AS VisitTime"); sb.Append(" ,VF.DeputyID + '-' + VF.DeputyName AS DeputyID_Name,VF.LocationType,VF.InterLocationName,VF.ExterLocationName,VF.VisiterName,VF.VisiterTel"); sb.Append(" ,VF.VisitReasonID + '-' + VF.VisitReasonCN AS VisitReason,VF.VisitReasonDesc,VF.LastChgComp + '-' + Co.CompName AS LastChgComp_Name"); sb.Append(" ,VF.LastChgID + '-' + P.NameN AS LastChgID_Nanme,REPLACE(CONVERT(NVARCHAR(19),VF.LastChgDate,111),'-','/') AS LastChgDate"); sb.Append(" ,FlowCaseID "); sb.Append(" FROM VisitForm VF"); sb.Append(" LEFT JOIN " + _eHRMSDB_ITRD + ".dbo.Company C ON VF.CompID = C.CompID"); sb.Append(" LEFT JOIN " + _eHRMSDB_ITRD + ".dbo.Company Co ON VF.CompID = Co.CompID"); sb.Append(" LEFT JOIN " + _eHRMSDB_ITRD + ".dbo.Personal P ON VF.LastChgComp = P.CompID AND VF.LastChgID = P.EmpID"); sb.Append(" WHERE VF.CompID=@CompID"); sb.Append(" AND VF.EmpID=@EmpID"); sb.Append(" AND VF.WriteDate=@WriteDate"); sb.Append(" AND VF.FormSeq=@FormSeq"); sb.Append(" ; "); }
public static OnBizReqAppdOperationModel DetailDataFormat(OnBizReqAppdOperationBean Detaildatas) { var result = new OnBizReqAppdOperationModel(); result.CompID_Name = Detaildatas.CompID_Name; result.EmpID_NameN = Detaildatas.EmpID_NameN; result.WriteDate = Detaildatas.WriteDate; result.WriterID_Name = Detaildatas.WriterID_Name; result.VisitFormNo = Detaildatas.VisitFormNo; result.DeptName = Detaildatas.DeptName; result.TitleName = Detaildatas.TitleName; result.Position = Detaildatas.Position; result.Tel_1 = Detaildatas.Tel_1; result.Tel_2 = Detaildatas.Tel_2; result.VisitDate = Detaildatas.VisitDate; result.VisitTime = Detaildatas.VisitTime; result.DeputyID_Name = Detaildatas.DeputyID_Name; result.LocationType = Detaildatas.LocationType; result.InterLocationName = Detaildatas.InterLocationName; result.ExterLocationName = Detaildatas.ExterLocationName; result.VisiterName = Detaildatas.VisiterName; result.VisiterTel = Detaildatas.VisiterTel; result.VisitReason = Detaildatas.VisitReason; result.VisitReasonDesc = Detaildatas.VisitReasonDesc; result.LastChgComp_Name = Detaildatas.LastChgComp_Name; result.LastChgID_Nanme = Detaildatas.LastChgID_Nanme; result.LastChgDate = Detaildatas.LastChgDate; result.FlowCaseID = Detaildatas.FlowCaseID; return(result); }
protected void subGetData() { var isSuccess = false; var msg = ""; var Detaildatas = new OnBizReqAppdOperationBean(); var ViewData = new OnBizReqAppdOperationModel(); CheckVisitPKModel QueryData = new CheckVisitPKModel(); QueryData.CompID = _SessionCheckVisitPKModel.CompID; QueryData.EmpID = _SessionCheckVisitPKModel.EmpID; QueryData.WriteDate = _SessionCheckVisitPKModel.WriteDate; QueryData.FormSeq = _SessionCheckVisitPKModel.FormSeq; isSuccess = FN_OnBizReqAppdOperation.GetVisitFormDetailData(QueryData, out Detaildatas, out msg); if (isSuccess && Detaildatas != null) { ViewData = FN_OnBizReqAppdOperation.DetailDataFormat(Detaildatas); //Format Data lblWriterID_Nametxt.Text = ViewData.WriterID_Name; lblWriteDatetxt.Text = ViewData.WriteDate; lblEmpID_NameNtxt.Text = ViewData.EmpID_NameN; lblVisitFormNotxt.Text = ViewData.VisitFormNo; lblCompNametxt.Text = ViewData.CompID_Name; lblDeptNametxt.Text = ViewData.DeptName; lblTitleNametxt.Text = ViewData.TitleName; lblPositiontxt.Text = ViewData.Position; lblTel_1txt.Text = ViewData.Tel_1; lblTel_2txt.Text = ViewData.Tel_2; lblVisitDatetxt.Text = ViewData.VisitDate; lblVisitTimetxt.Text = ViewData.VisitTime; lblDeputyID_Nametxt.Text = ViewData.DeputyID_Name; if (ViewData.LocationType.Equals("1")) { chkInterLocation.Checked = true; lblInterLocationNametxt.Text = ViewData.InterLocationName; } else if (ViewData.LocationType.Equals("2")) { chkExterLocation.Checked = true; lblExterLocationNametxt.Text = ViewData.ExterLocationName; } else if (ViewData.LocationType.Equals("3")) { chkInterLocation.Checked = true; lblInterLocationNametxt.Text = ViewData.InterLocationName; chkExterLocation.Checked = true; lblExterLocationNametxt.Text = ViewData.ExterLocationName; } lblVisiterNametxt.Text = ViewData.VisiterName; lblVisiterTeltxt.Text = ViewData.VisiterTel; lblVisitReasontxt.Text = ViewData.VisitReason; lblVisitReasonDesctxt.Text = ViewData.VisitReasonDesc; lblLastChgComptxt.Text = ViewData.LastChgComp_Name; lblLastChgIDtxt.Text = ViewData.LastChgID_Nanme; lblLastChgDatetxt.Text = ViewData.LastChgDate; ViewState["FlowCaseID"] = ViewData.FlowCaseID; } }
public static bool GetVisitFormDetailData(CheckVisitPKModel model, out OnBizReqAppdOperationBean ReturnDatas, out string msg) { bool result = false; msg = ""; ReturnDatas = new OnBizReqAppdOperationBean(); try { using (var conn = new SqlConnection() { ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString }) { OnBizReqAppdOperationBean dataBean = new OnBizReqAppdOperationBean() { CompID = model.CompID, EmpID = model.EmpID, WriteDate = model.WriteDate, FormSeq = model.FormSeq }; StringBuilder sb = new StringBuilder(); OnBizReqAppdOperationSql.GetVisitFormDetailData(dataBean, ref sb); try { ReturnDatas = conn.Query <OnBizReqAppdOperationBean>(sb.ToString(), dataBean).FirstOrDefault(); } catch (Exception) { throw; } if (ReturnDatas == null) { throw new Exception("查無資料!"); } } result = true; } catch (Exception ex) { msg = ex.Message; } return(result); }