Example #1
0
        public static void InsertFixedAssetAllocationInfo(FixedAssetAllocationInfo info)
        {
            DataProvider dataProvider = new DataProvider();

            dataProvider.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString;
            SqlParameter[] parameters = new SqlParameter[] {
                new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@SecurityLevel", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@UrgenLevel", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@StartDeptId", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@DeptName", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@UserName", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@CreateTime", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@LeadersSelected", System.Data.SqlDbType.NVarChar, 2000),
                new SqlParameter("@ApproveResult", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@DepartName", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@ApplyDate", System.Data.SqlDbType.NVarChar, 200),
                new SqlParameter("@Applicant", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@Phone", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@FixedName", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@Quantity", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@Price", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@Account", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@Sum", System.Data.SqlDbType.NVarChar, 100),
                new SqlParameter("@DeployReason", System.Data.SqlDbType.NVarChar, 100),
            };
            parameters[0].Value  = info.FormId;
            parameters[1].Value  = info.SecurityLevel;
            parameters[2].Value  = info.UrgenLevel;
            parameters[3].Value  = info.StartDeptId;
            parameters[4].Value  = info.DeptName;
            parameters[5].Value  = info.UserName;
            parameters[6].Value  = info.CreateTime;
            parameters[7].Value  = info.LeadersSelected;
            parameters[8].Value  = info.ApproveResult;
            parameters[9].Value  = info.DepartName;
            parameters[10].Value = info.ApplyDate;
            parameters[11].Value = info.Applicant;
            parameters[12].Value = info.Phone;
            parameters[13].Value = info.FixedName;
            parameters[14].Value = info.Quantity;
            parameters[15].Value = info.Price;
            parameters[16].Value = info.Account;
            parameters[17].Value = info.Sum;
            parameters[18].Value = info.DeployReason;

            DataTable dataTable = dataProvider.ExecutedProcedure("Biz.OA_FixedAssetAllocation_Insert", parameters);
        }
Example #2
0
        public static FixedAssetAllocationInfo GetFixedAssetAllocationInfoByWfId(string wfId)
        {
            FixedAssetAllocationInfo info         = null;
            DataProvider             dataProvider = new DataProvider();

            dataProvider.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString;
            SqlParameter[] parameters = new SqlParameter[] {
                new SqlParameter("@WFInstanceId", System.Data.SqlDbType.NVarChar, 100),
            };
            parameters[0].Value = wfId;
            DataTable dataTable = dataProvider.ExecutedProcedure("Biz.OA_FixedAssetAllocation_GetByWfId", parameters);

            ///给实体赋值
            if (dataTable != null && dataTable.Rows.Count > 0)
            {
                info = new FixedAssetAllocationInfo();
                if (dataTable.Rows[0]["FormId"] != null && dataTable.Rows[0]["FormId"].ToString() != "")
                {
                    info.FormId = dataTable.Rows[0]["FormId"].ToString();
                }
                if (dataTable.Rows[0]["SecurityLevel"] != null && dataTable.Rows[0]["SecurityLevel"].ToString() != "")
                {
                    info.SecurityLevel = dataTable.Rows[0]["SecurityLevel"].ToString();
                }
                if (dataTable.Rows[0]["UrgenLevel"] != null && dataTable.Rows[0]["UrgenLevel"].ToString() != "")
                {
                    info.UrgenLevel = dataTable.Rows[0]["UrgenLevel"].ToString();
                }
                if (dataTable.Rows[0]["StartDeptId"] != null && dataTable.Rows[0]["StartDeptId"].ToString() != "")
                {
                    info.StartDeptId = dataTable.Rows[0]["StartDeptId"].ToString();
                }
                if (dataTable.Rows[0]["DeptName"] != null && dataTable.Rows[0]["DeptName"].ToString() != "")
                {
                    info.DeptName = dataTable.Rows[0]["DeptName"].ToString();
                }
                if (dataTable.Rows[0]["UserName"] != null && dataTable.Rows[0]["UserName"].ToString() != "")
                {
                    info.UserName = dataTable.Rows[0]["UserName"].ToString();
                }
                if (dataTable.Rows[0]["CreateTime"] != null && dataTable.Rows[0]["Phone"].ToString() != "")
                {
                    info.CreateTime = dataTable.Rows[0]["CreateTime"].ToString();
                }
                if (dataTable.Rows[0]["LeadersSelected"] != null && dataTable.Rows[0]["CreateTime"].ToString() != "")
                {
                    info.LeadersSelected = dataTable.Rows[0]["LeadersSelected"].ToString();
                }
                if (dataTable.Rows[0]["ApproveResult"] != null && dataTable.Rows[0]["RedHeadDocument"].ToString() != "")
                {
                    info.ApproveResult = dataTable.Rows[0]["ApproveResult"].ToString();
                }
                if (dataTable.Rows[0]["DepartName"] != null && dataTable.Rows[0]["IsPublish"].ToString() != "")
                {
                    info.DepartName = dataTable.Rows[0]["DepartName"].ToString();
                }
                if (dataTable.Rows[0]["ApplyDate"] != null && dataTable.Rows[0]["Title"].ToString() != "")
                {
                    info.ApplyDate = dataTable.Rows[0]["ApplyDate"].ToString();
                }
                if (dataTable.Rows[0]["Applicant"] != null && dataTable.Rows[0]["Content"].ToString() != "")
                {
                    info.Applicant = dataTable.Rows[0]["Applicant"].ToString();
                }
                if (dataTable.Rows[0]["Phone"] != null && dataTable.Rows[0]["LeadersSelected"].ToString() != "")
                {
                    info.Phone = dataTable.Rows[0]["Phone"].ToString();
                }
                if (dataTable.Rows[0]["FixedName"] != null && dataTable.Rows[0]["ApproveResult"].ToString() != "")
                {
                    info.FixedName = dataTable.Rows[0]["FixedName"].ToString();
                }
                if (dataTable.Rows[0]["Quantity"] != null && dataTable.Rows[0]["ApproveResult"].ToString() != "")
                {
                    info.Quantity = dataTable.Rows[0]["Quantity"].ToString();
                }
                if (dataTable.Rows[0]["Price"] != null && dataTable.Rows[0]["ApproveResult"].ToString() != "")
                {
                    info.Price = dataTable.Rows[0]["Price"].ToString();
                }
                if (dataTable.Rows[0]["Account"] != null && dataTable.Rows[0]["ApproveResult"].ToString() != "")
                {
                    info.Account = dataTable.Rows[0]["Account"].ToString();
                }
                if (dataTable.Rows[0]["Sum"] != null && dataTable.Rows[0]["ApproveResult"].ToString() != "")
                {
                    info.Sum = dataTable.Rows[0]["Sum"].ToString();
                }
                if (dataTable.Rows[0]["DeployReason"] != null && dataTable.Rows[0]["ApproveResult"].ToString() != "")
                {
                    info.DeployReason = dataTable.Rows[0]["DeployReason"].ToString();
                }
            }
            return(info);
        }