Esempio n. 1
0
        public static DataTable GetStatementsPage(SqlTransaction trans, PageSettings pageSettings, Guid userId, int departmentId)
        {
            Department department = new Department(trans, departmentId);
            Worker     worker     = new Worker(trans, userId);

            SqlParameter[] sps = new SqlParameter[19];
            sps[0]       = new SqlParameter("@PageIndex", SqlDbType.Int);
            sps[0].Value = pageSettings.PageIndex;

            sps[1]       = new SqlParameter("@SortColumnName", SqlDbType.VarChar, 50);
            sps[1].Value = pageSettings.SortColumn;

            sps[2]       = new SqlParameter("@SortOrderBy", SqlDbType.VarChar, 4);
            sps[2].Value = pageSettings.SortOrder;

            sps[3]       = new SqlParameter("@NumberOfRows", SqlDbType.Int);
            sps[3].Value = pageSettings.PageSize;

            sps[4]           = new SqlParameter("@TotalRecords", SqlDbType.Int);
            sps[4].Direction = ParameterDirection.Output;

            sps[5] = new SqlParameter("@CreationDate", SqlDbType.DateTime);
            if (pageSettings.Where.HasRule("CreationDate"))
            {
                sps[5].Value = SqlDateTime.Parse(pageSettings.Where.GetRule("CreationDate").Data);
            }
            else
            {
                sps[5].Value = DBNull.Value;
            }

            sps[6]       = new SqlParameter("@CreationDateStart", SqlDbType.DateTime);
            sps[6].Value = pageSettings.Where.HasRule("CreationDateStart")
                               ? SqlDateTime.Parse(pageSettings.Where.GetRule("CreationDateStart").Data)
                               : SqlDateTime.MinValue;

            sps[7]       = new SqlParameter("@CreationDateEnd", SqlDbType.DateTime);
            sps[7].Value = pageSettings.Where.HasRule("CreationDateEnd")
                               ? SqlDateTime.Parse(pageSettings.Where.GetRule("CreationDateEnd").Data)
                               : SqlDateTime.MaxValue;

            sps[8]       = new SqlParameter("@CitizenLastName", SqlDbType.NVarChar, 50);
            sps[8].Value = pageSettings.Where.HasRule("CitizenLastName")
                               ? pageSettings.Where.GetRule("CitizenLastName").Data
                               : String.Empty;

            sps[9]       = new SqlParameter("@HeadLastName", SqlDbType.NVarChar, 50);
            sps[9].Value = pageSettings.Where.HasRule("HeadLastName")
                                ? pageSettings.Where.GetRule("HeadLastName").Data
                                : String.Empty;

            sps[10]       = new SqlParameter("@CityObjectName", SqlDbType.NVarChar, 50);
            sps[10].Value = pageSettings.Where.HasRule("CityObjectName")
                                ? pageSettings.Where.GetRule("CityObjectName").Data
                                : String.Empty;

            sps[11]       = new SqlParameter("@Number", SqlDbType.NVarChar, 50);
            sps[11].Value = pageSettings.Where.HasRule("Number")
                                ? pageSettings.Where.GetRule("Number").Data
                                : String.Empty;

            sps[12]       = new SqlParameter("@ExternalNumber", SqlDbType.NVarChar, 50);
            sps[12].Value = pageSettings.Where.HasRule("ExternalNumber")
                                ? pageSettings.Where.GetRule("ExternalNumber").Data
                                : String.Empty;

            sps[13]       = new SqlParameter("@DepartmentID", SqlDbType.Int);
            sps[13].Value = departmentId;

            sps[14]       = new SqlParameter("@Content", SqlDbType.NVarChar);
            sps[14].Value = pageSettings.Where.HasRule("Content")
                                ? pageSettings.Where.GetRule("Content").Data
                                : String.Empty;

            sps[15] = new SqlParameter("@Controlled", SqlDbType.Bit);
            bool controlled = false;

            if (pageSettings.Where.HasRule("Controlled"))
            {
                Boolean.TryParse(pageSettings.Where.GetRule("Controlled").Data, out controlled);
            }

            if (controlled)
            {
                sps[15].Value = true;
            }
            else
            {
                sps[15].Value = DBNull.Value;
            }

            sps[16]       = new SqlParameter("@WorkerID", SqlDbType.Int);
            sps[16].Value = worker.ID;

            sps[17]       = new SqlParameter("@InnerNumber", SqlDbType.NVarChar, 50);
            sps[17].Value = pageSettings.Where.HasRule("InnerNumber")
                               ? pageSettings.Where.GetRule("InnerNumber").Data
                               : String.Empty;

            sps[18] = new SqlParameter("@OpenWorker", SqlDbType.Bit);
            if (pageSettings.Where.HasRule("OpenWorker"))
            {
                bool openWorker = false;
                Boolean.TryParse(pageSettings.Where.GetRule("OpenWorker").Data, out openWorker);
                sps[18].Value = openWorker;
            }
            else
            {
                sps[18].Value = DBNull.Value;
            }

            DataTable dt = SPHelper.ExecuteDataset(trans, SpNames.StatementsPage, sps).Tables[0];

            pageSettings.TotalRecords = sps[4].Value != DBNull.Value ? Convert.ToInt32(sps[4].Value) : 0;


            return(dt);
        }
Esempio n. 2
0
        public static DataTable GetDraftPage(SqlTransaction trans, PageSettings pageSettings, Guid userId, int departmentId)
        {
            Department department = new Department(trans, departmentId);
            Worker     worker     = new Worker(trans, userId);

            /*if (!Permission.IsUserPermission(trans, userId, department.ObjectID, (int)Department.ActionType.View))
             * {
             *  throw new AccessException(userId.ToString(), "Get document template");
             * }*/
            //worker.PostID
            SqlParameter[] sps = new SqlParameter[14];
            sps[0]       = new SqlParameter("@PageIndex", SqlDbType.Int);
            sps[0].Value = pageSettings.PageIndex;

            sps[1]       = new SqlParameter("@SortColumnName", SqlDbType.VarChar, 50);
            sps[1].Value = pageSettings.SortColumn;

            sps[2]       = new SqlParameter("@SortOrderBy", SqlDbType.VarChar, 4);
            sps[2].Value = pageSettings.SortOrder;

            sps[3]       = new SqlParameter("@NumberOfRows", SqlDbType.Int);
            sps[3].Value = pageSettings.PageSize;

            sps[4]           = new SqlParameter("@TotalRecords", SqlDbType.Int);
            sps[4].Direction = ParameterDirection.Output;

            sps[5] = new SqlParameter("@CreationDate", SqlDbType.DateTime);
            if (pageSettings.Where.HasRule("CreationDate"))
            {
                sps[5].Value = DateTime.Parse(pageSettings.Where.GetRule("CreationDate").Data,
                                              CultureInfo.CurrentCulture);
            }
            else
            {
                sps[5].Value = DBNull.Value;
            }

            SqlDateTime cdStart = SqlDateTime.MinValue;

            if (pageSettings.Where.HasRule("CreationDateStart"))
            {
                cdStart = DateTime.Parse(pageSettings.Where.GetRule("CreationDateStart").Data,
                                         CultureInfo.CurrentCulture);
            }
            sps[6]       = new SqlParameter("@CreationDateStart", SqlDbType.DateTime);
            sps[6].Value = cdStart;

            SqlDateTime cdEnd = SqlDateTime.MaxValue;

            if (pageSettings.Where.HasRule("CreationDateEnd"))
            {
                cdEnd = DateTime.Parse(pageSettings.Where.GetRule("CreationDateEnd").Data, CultureInfo.CurrentCulture);
            }
            sps[7]       = new SqlParameter("@CreationDateEnd", SqlDbType.DateTime);
            sps[7].Value = cdEnd;

            sps[8]       = new SqlParameter("@Number", SqlDbType.NVarChar, 50);
            sps[8].Value = pageSettings.Where.HasRule("Number")
                               ? pageSettings.Where.GetRule("Number").Data
                               : String.Empty;

            sps[9]       = new SqlParameter("@DepartmentID", SqlDbType.Int);
            sps[9].Value = departmentId;

            sps[10] = new SqlParameter("@DocumentCodeID", SqlDbType.Int);
            int documentCodeId;

            if (pageSettings.Where.HasRule("DocumentCodeID") &&
                Int32.TryParse(pageSettings.Where.GetRule("DocumentCodeID").Data, out documentCodeId))
            {
                sps[10].Value = documentCodeId;
            }
            else
            {
                sps[10].Value = DBNull.Value;
            }

            sps[11]       = new SqlParameter("@Content", SqlDbType.NVarChar);
            sps[11].Value = pageSettings.Where.HasRule("Content")
                                ? pageSettings.Where.GetRule("Content").Data
                                : String.Empty;

            sps[12]       = new SqlParameter("@OrganizationName", SqlDbType.NVarChar, 256);
            sps[12].Value = pageSettings.Where.HasRule("OrganizationName")
                                ? pageSettings.Where.GetRule("OrganizationName").Data
                                : String.Empty;

            sps[13]       = new SqlParameter("@WorkerID", SqlDbType.Int);
            sps[13].Value = worker.ID;


            DataTable dt = SPHelper.ExecuteDataset(trans, SpNames.DraftPage, sps).Tables[0];

            pageSettings.TotalRecords = sps[4].Value != DBNull.Value ? Convert.ToInt32(sps[4].Value) : 0;

            return(dt);
        }