Beispiel #1
0
        //获取编号

        public List <string> bianHao()
        {
            string sql = "dj";

            SqlParameter[] ji =
            {
                new SqlParameter()
                {
                    ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
                },
            };
            DataTable dt = DBHaipu.SelectProc(sql, ji, "");
            //获取值
            List <string> sttt = new List <string>();
            string        r    = ji[0].Value.ToString();



            sttt.Add(r);
            string       sql1 = "FF";
            SqlParameter ji1  = new SqlParameter()
            {
                ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
            };

            DataTable dt1 = DBHaipu.SelectProc1(sql1, ji1, "");
            //获取值
            string r1 = ji1.Value.ToString();

            sttt.Add(r1);
            return(sttt);
        }
Beispiel #2
0
        public int Add(salary_grantModel item)
        {
            string sql = "dj";

            SqlParameter[] ji =
            {
                new SqlParameter()
                {
                    ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
                },
            };
            DataTable dt = DBHaipu.SelectProc(sql, ji, "");
            //获取值
            string r = ji[0].Value.ToString();



            salary_grant ko = new salary_grant();

            ko.salary_grant_id = r;
            string       sql1 = "FF";
            SqlParameter ji1  = new SqlParameter()
            {
                ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
            };

            DataTable dt1 = DBHaipu.SelectProc1(sql1, ji1, "");
            //获取值
            string r1 = ji1.Value.ToString();

            ko.salary_standard_id  = r1;
            ko.first_kind_id       = item.first_kind_id;
            ko.first_kind_name     = item.first_kind_name;
            ko.second_kind_id      = item.second_kind_id;
            ko.second_kind_name    = item.second_kind_name;
            ko.third_kind_id       = item.third_kind_id;
            ko.third_kind_name     = item.third_kind_name;
            ko.human_amount        = item.human_amount;
            ko.salary_standard_sum = item.salary_standard_sum;
            ko.salary_paid_sum     = item.salary_paid_sum;

            ko.regist_time = DateTime.Now;

            ko.check_time   = DateTime.Now;
            ko.check_status = item.check_status;
            return(Add(ko));
        }
Beispiel #3
0
        public string BianHao()
        {
            string sql = "xcbj";

            SqlParameter[] ji =
            {
                new SqlParameter()
                {
                    ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
                },
            };
            DataTable dt = DBHaipu.SelectProc(sql, ji, "");
            //获取值
            string r = ji[0].Value.ToString();

            return(r);
        }
Beispiel #4
0
        public string Add(human_fileModel item)
        {
            human_file ko  = new human_file();
            string     sql = "bd";

            SqlParameter[] ji =
            {
                new SqlParameter()
                {
                    ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
                },
            };
            DataTable dt = DBHaipu.SelectProc(sql, ji, "");
            //获取值
            string r = ji[0].Value.ToString();

            ko.human_id = r;
            // ko.human_id = item.human_id;
            ko.first_kind_id         = item.first_kind_id;
            ko.first_kind_name       = item.first_kind_name;
            ko.second_kind_id        = item.second_kind_id;
            ko.second_kind_name      = item.second_kind_name;
            ko.third_kind_id         = item.third_kind_id;
            ko.third_kind_name       = item.third_kind_name;
            ko.human_name            = item.human_name;
            ko.human_address         = item.human_address;
            ko.human_postcode        = item.human_postcode;
            ko.human_pro_designation = item.human_pro_designation;
            ko.human_major_kind_id   = item.human_major_kind_id;
            ko.human_major_kind_name = item.human_major_kind_name;
            ko.human_major_id        = item.human_major_id;
            ko.hunma_major_name      = item.hunma_major_name;
            ko.human_telephone       = item.human_telephone;
            ko.human_mobilephone     = item.human_mobilephone;
            ko.human_bank            = item.human_bank;
            ko.human_account         = item.human_account;
            ko.human_qq                  = item.human_qq;
            ko.human_email               = item.human_email;
            ko.human_hobby               = item.human_hobby;
            ko.human_speciality          = item.human_speciality;
            ko.human_sex                 = item.human_sex;
            ko.human_religion            = item.human_religion;
            ko.human_party               = item.human_party;
            ko.human_nationality         = item.human_nationality;
            ko.human_race                = item.human_race;
            ko.human_birthday            = item.human_birthday;
            ko.human_birthplace          = item.human_birthplace;
            ko.human_age                 = item.human_age;
            ko.human_educated_degree     = item.human_educated_degree;
            ko.human_educated_years      = item.human_educated_years;
            ko.human_educated_major      = item.human_educated_major;
            ko.human_society_security_id = item.human_society_security_id;
            ko.human_id_card             = item.human_id_card;

            ko.remark               = item.remark;
            ko.salary_standard_id   = item.salary_standard_id;
            ko.salary_standard_name = item.salary_standard_name;
            ko.salary_sum           = item.salary_sum;
            ko.demand_salaray_sum   = item.demand_salaray_sum;
            ko.paid_salary_sum      = item.paid_salary_sum;
            ko.major_change_amount  = item.major_change_amount;
            ko.bonus_amount         = item.bonus_amount;
            ko.training_amount      = item.training_amount;
            ko.file_chang_amount    = item.file_chang_amount;

            ko.human_histroy_records   = item.human_histroy_records;
            ko.human_family_membership = item.human_family_membership;
            ko.human_picture           = item.human_picture;
            //
            ko.attachment_name = item.attachment_name;
            ko.check_status    = item.check_status;
            ko.register        = item.register;
            ko.checker         = item.checker;
            ko.changer         = item.changer;
            //
            ko.regist_time          = item.regist_time;
            ko.check_time           = DateTime.Now;
            ko.change_time          = DateTime.Now;
            ko.lastly_change_time   = DateTime.Now;
            ko.delete_time          = DateTime.Now;
            ko.recovery_time        = DateTime.Now;
            ko.human_file_status    = item.human_file_status;
            ko.salary_standard_name = item.salary_standard_name;
            ko.salary_standard_id   = item.salary_standard_id;
            ko.salary_sum           = item.salary_sum;
            ko.register             = item.register;


            if (Add(ko) > 0)
            {
                return(r);
            }
            else
            {
                return(null);
            }
        }