/// <summary> /// 審核畫面GridView /// </summary> /// <param name="dataBean">查詢條件</param> /// <param name="sb">傳入之前組好Command</param> /// <param name="isReset">StringBuilder Reset or not</param> public static void GetOnBizReqAppdOperationData(CheckVisitGridDataBean dataBean, ref StringBuilder sb, bool isReset = false) { if (isReset) { sb = new StringBuilder(); } sb.Append("SELECT CompID,EmpID,EmpNameN,CONVERT(NVARCHAR(10),WriteDate,111) AS WriteDate,DeputyID + '-' + DeputyName AS DeputyID_Name"); sb.Append(" ,CONVERT(NVARCHAR(10),VisitBeginDate,111) AS VisitBeginDate,CONVERT(NVARCHAR (5),BeginTime) AS BeginTime,CONVERT(NVARCHAR(10)"); sb.Append(" ,VisitEndDate,111) AS VisitEndDate,CONVERT(NVARCHAR (5),EndTime) AS EndTime,VisitReasonCN,FormSeq,VF.FlowCaseID,OBL.FlowLogID"); sb.Append(" FROM VisitForm VF"); sb.Append(" LEFT JOIN OnBizReqAppd_ITRDFlowOpenLog OBL ON VF.FlowCaseID = OBL.FlowCaseID "); sb.Append(" LEFT JOIN PS_UserProxy UP ON VF.ValidID = UP.UserID AND CONVERT(VARCHAR(8),GETDATE(),112) BETWEEN UP.ProxyStartDate AND UP.ProxyEndDate"); sb.Append(" WHERE (ValidID = @ValidID"); sb.Append(" OR UP.ProxyUser = @ValidID)"); sb.Append(" AND EmpID <> @ValidID "); sb.Append(" AND OBFormStatus = '2'"); sb.Append(" ; "); }
public static bool GetVisitFormGridViewData(OnBizReqAppdOperationModel model, out List <CheckVisitGridDataBean> ReturnDatas, out string msg) { bool result = false; msg = ""; ReturnDatas = new List <CheckVisitGridDataBean>(); try { using (var conn = new SqlConnection() { ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString }) { CheckVisitGridDataBean dataBean = new CheckVisitGridDataBean() { CompID = model.CompID, ValidID = model.ValidID }; StringBuilder sb = new StringBuilder(); OnBizReqAppdOperationSql.GetOnBizReqAppdOperationData(dataBean, ref sb); try { ReturnDatas = conn.Query <CheckVisitGridDataBean>(sb.ToString(), dataBean).ToList(); } catch (Exception) { throw; } if (ReturnDatas == null || ReturnDatas.Count == 0) { throw new Exception("查無資料!"); } } result = true; } catch (Exception ex) { msg = ex.Message; } return(result); }