/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Salary_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Stale_Salary("); strSql.Append("NewSalary,OldSalary,Reason,PubDate,EmpName,OperPerson,Remark)"); strSql.Append(" values ("); strSql.Append("@NewSalary,@OldSalary,@Reason,@PubDate,@EmpName,@OperPerson,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@NewSalary", SqlDbType.Decimal, 9), new SqlParameter("@OldSalary", SqlDbType.Decimal, 9), new SqlParameter("@Reason", SqlDbType.NVarChar, 200), new SqlParameter("@PubDate", SqlDbType.DateTime), new SqlParameter("@EmpName", SqlDbType.NVarChar, 50), new SqlParameter("@OperPerson", SqlDbType.NVarChar, 30), new SqlParameter("@Remark", SqlDbType.NVarChar, 1000) }; parameters[0].Value = model.NewSalary; parameters[1].Value = model.OldSalary; parameters[2].Value = model.Reason; parameters[3].Value = model.PubDate; parameters[4].Value = model.EmpName; parameters[5].Value = model.OperPerson; parameters[6].Value = model.Remark; return(DbHelperSQL.ExecuteCommand(strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Salary_Model model) { return(dal.Add(model)); }