コード例 #1
0
        //public static List<OCPB.Service.Model.ComplainlistDetail> GetComplainTimeLine(string ApiKey, int? Skip, int? take, int? IsCloseJob)
        //{
        //    SqlParameter[] param = new SqlParameter[4];
        //    param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
        //    param[1] = new SqlParameter("@Skip", Skip != null ? Skip : (Object)DBNull.Value);
        //    param[2] = new SqlParameter("@take", take != null ? take : (Object)DBNull.Value);
        //    param[3] = new SqlParameter("@IsCloseJob", IsCloseJob != null ? IsCloseJob : (Object)DBNull.Value);
        //    return DirectSqlDao.GetAllStored<OCPB.Service.Model.ComplainlistDetail>("GetComplainTimeLine", param);
        //}

        public static List <OCPB.Service.Model.ComplainlistDetail> GetComplainByCaseId(string ApiKey, string Case_Id)
        {
            SqlParameter[] param = new SqlParameter[2];
            param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
            param[1] = new SqlParameter("@Case_Id", !String.IsNullOrEmpty(Case_Id) ? Case_Id.Trim() : (Object)DBNull.Value);
            return(DirectSqlDao.GetAllStored <OCPB.Service.Model.ComplainlistDetail>("GetComplainByCaseId", param));
        }
コード例 #2
0
 public static List <ComplainGetFileModel> GetfileUploadByCaseId(string ApiKey, string Case_Id)
 {
     SqlParameter[] param = new SqlParameter[2];
     param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
     param[1] = new SqlParameter("@Case_Id", Case_Id);
     return(DirectSqlDao.GetAllStored <ComplainGetFileModel>("GetComplainFileUploadByCaseId", param));
 }
コード例 #3
0
        public static List <OCPB.Service.Model.ComplainGetFileModel> GetfileUpload(int ComplainID)
        {
            SqlParameter[] param = new SqlParameter[1];
            param[0] = new SqlParameter("@ComplainID", ComplainID);


            return(DirectSqlDao.GetAllStored <OCPB.Service.Model.ComplainGetFileModel>("GetComplainFileUpload", param));
        }
コード例 #4
0
 public static List <OCPB.Service.Model.GetComplainTimeLineResult> GetComplainTimeLine(string ApiKey, int?Skip, int?take, int?IsCloseJob, int? @CusID)
 {
     SqlParameter[] param = new SqlParameter[5];
     param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
     param[1] = new SqlParameter("@Skip", Skip != null ? Skip : (Object)DBNull.Value);
     param[2] = new SqlParameter("@take", take != null ? take : (Object)DBNull.Value);
     param[3] = new SqlParameter("@IsCloseJob", IsCloseJob != null ? IsCloseJob : (Object)DBNull.Value);
     param[4] = new SqlParameter("@CusID", CusID != null ? CusID : (Object)DBNull.Value);
     return(DirectSqlDao.GetAllStored <OCPB.Service.Model.GetComplainTimeLineResult>("GetComplainTimeLine", param));
 }
コード例 #5
0
        // GET api/integration/5
        public string Get(int id)
        {
            SqlParameter[] param  = new SqlParameter[0];
            string         Stored = null;

            switch (id)
            {
            case 2: Stored = "Bi_rpt_Complains_By_Area"; break;

            case 3: Stored = "Bi_rpt_Complain_Dept"; break;

            case 4: Stored = "Bi_rpt_Complains_By_Call_Center"; break;

            case 5: Stored = "Bi_rpt_Complains_By_Division"; break;

            case 7: Stored = "Bi_rpt_in_process"; break;

            case 8: Stored = "Bi_Rpt_Complains_by_CompanyName"; break;
            }

            return(DataTableToJsonObj(DirectSqlDao.GetAllStored_Datatable(Stored, param)));
        }
コード例 #6
0
 public static List <OCPB.Service.Model.GetComplainTimeLineResult> GetTimelineHeader_From_Dep(int CompID)
 {
     SqlParameter[] param = new SqlParameter[1];
     param[0] = new SqlParameter("@CompID", CompID);
     return(DirectSqlDao.GetAllStored <OCPB.Service.Model.GetComplainTimeLineResult>("GetTimelineHeader_From_Dep", param));
 }
コード例 #7
0
        // POST api/integration
        public string Post([FromBody] string value)
        {
            SqlParameter[] param = new SqlParameter[0];

            return(DataTableToJsonObj(DirectSqlDao.GetAllStored_Datatable("Bi_rpt_Complain_Dept", param)));
        }