//获取编号
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);
}
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));
}
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);
}
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);
}
}