Exemple #1
0
        /// <summary>
        /// 更新表
        /// </summary>
        /// <param name="obj"></param>
        public void Update(ContractAuditOfEToIInfo model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@FormID",                   SqlDbType.NVarChar,  100),
                new SqlParameter("@SecurityLevel",            SqlDbType.NVarChar,  100),
                new SqlParameter("@UrgenLevel",               SqlDbType.NVarChar,  100),
                new SqlParameter("@DeptName",                 SqlDbType.NVarChar,  200),
                new SqlParameter("@DeptCode",                 SqlDbType.NVarChar,  100),
                new SqlParameter("@UserName",                 SqlDbType.NVarChar,  100),
                new SqlParameter("@Mobile",                   SqlDbType.NVarChar,  100),
                new SqlParameter("@DateTime",                 SqlDbType.NVarChar,  100),
                new SqlParameter("@ContractSum",              SqlDbType.NVarChar,  100),
                new SqlParameter("@IsSupplementProtocol",     SqlDbType.NVarChar,  100),
                new SqlParameter("@IsFormatContract",         SqlDbType.NVarChar,  100),
                new SqlParameter("@IsNormText",               SqlDbType.NVarChar,  100),
                new SqlParameter("@IsBidding",                SqlDbType.NVarChar,  100),
                new SqlParameter("@IsEstateProject",          SqlDbType.NVarChar,  100),
                new SqlParameter("@EstateProjectName",        SqlDbType.NVarChar,  300),
                new SqlParameter("@EstateProjectNum",         SqlDbType.NVarChar,  100),
                new SqlParameter("@ContractTitle",            SqlDbType.NVarChar,  500),
                new SqlParameter("@ContractContent",          SqlDbType.NVarChar, 4000),
                new SqlParameter("@LeadersSelected",          SqlDbType.NVarChar, 4000),
                new SqlParameter("@IsReport",                 SqlDbType.NVarChar,  100),
                new SqlParameter("@ContractType1",            SqlDbType.NVarChar,  100),
                new SqlParameter("@ContractTypeName1",        SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractType2",            SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractTypeName2",        SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractType3",            SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractTypeName3",        SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractSubject",          SqlDbType.NVarChar,  500),
                new SqlParameter("@ContractSubjectName",      SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractSubjectName2",     SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractSubjectName3",     SqlDbType.NVarChar,  200),
                new SqlParameter("@ContractSubjectName4",     SqlDbType.NVarChar,  200),
                new SqlParameter("@IsSupplementProtocolText", SqlDbType.NVarChar,   50),
                new SqlParameter("@RelatedFormID",            SqlDbType.NVarChar,  200),
                new SqlParameter("@EstateProjectNameText",    SqlDbType.NVarChar,  300),
                new SqlParameter("@EstateProjectNumText",     SqlDbType.NVarChar, 100)
            };
            parameters[0].Value  = model.FormID;
            parameters[1].Value  = model.SecurityLevel;
            parameters[2].Value  = model.UrgenLevel;
            parameters[3].Value  = model.DeptName;
            parameters[4].Value  = model.DeptCode;
            parameters[5].Value  = model.UserName;
            parameters[6].Value  = model.Mobile;
            parameters[7].Value  = model.DateTime;
            parameters[8].Value  = model.ContractSum;
            parameters[9].Value  = model.IsSupplementProtocol;
            parameters[10].Value = model.IsFormatContract;
            parameters[11].Value = model.IsNormText;
            parameters[12].Value = model.IsBidding;
            parameters[13].Value = model.IsEstateProject;
            parameters[14].Value = model.EstateProjectName;
            parameters[15].Value = model.EstateProjectNum;
            parameters[16].Value = model.ContractTitle;
            parameters[17].Value = model.ContractContent;
            parameters[18].Value = model.LeadersSelected;
            parameters[19].Value = model.IsReport;
            parameters[20].Value = model.ContractType1;
            parameters[21].Value = model.ContractTypeName1;
            parameters[22].Value = model.ContractType2;
            parameters[23].Value = model.ContractTypeName2;
            parameters[24].Value = model.ContractType3;
            parameters[25].Value = model.ContractTypeName3;
            parameters[26].Value = model.ContractSubject;
            parameters[27].Value = model.ContractSubjectName;
            parameters[28].Value = model.ContractSubjectName2;
            parameters[29].Value = model.ContractSubjectName3;
            parameters[30].Value = model.ContractSubjectName4;
            parameters[31].Value = model.IsSupplementProtocolText;
            parameters[32].Value = model.RelatedFormID;
            parameters[33].Value = model.EstateProjectNameText;
            parameters[34].Value = model.EstateProjectNumText;

            DataTable dataTable = DBHelper.ExecutedProcedure("Biz.OA_ContractAuditOfEToIInfo_Update", parameters);
        }