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