/// <summary>
/// 更新提成工资项信息
/// </summary>
/// <param name="model">提成工资项信息</param>
/// <returns></returns>
private static SqlCommand UpdateCommissionSalaryInfo(CommissionSalaryModel model)
{
#region SQL文拼写
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.CommissionSalary ");
updateSql.AppendLine(" SET Amount = @Amount ");
updateSql.AppendLine(" ,SalaryMoney = @SalaryMoney ");
updateSql.AppendLine(" ,ModifiedDate = getdate() ");
updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID ");
updateSql.AppendLine(" WHERE ");
updateSql.AppendLine(" CompanyCD = @CompanyCD ");
updateSql.AppendLine(" AND ItemNo = @ItemNo ");
updateSql.AppendLine(" AND EmployeeID = @EmployeeID ");
updateSql.AppendLine(" AND CONVERT(VARCHAR(10),CommDate,21) ");
updateSql.AppendLine(" = CONVERT(VARCHAR(10),@CommDate,21) ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = updateSql.ToString();
//参数
SetSaveParameter(comm, model);
//执行更新
return comm;
}
/// <summary>
/// 保存时参数设置
/// </summary>
/// <param name="comm">命令</param>
/// <param name="model">人才代理信息</param>
private static void SetSaveParameter(SqlCommand comm, CommissionSalaryModel model)
{
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID));//员工ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", model.ItemNo));//提成工资项编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CommDate", model.CommDate));//提成工资项日期
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Amount", model.Amount));//业务量
comm.Parameters.Add(SqlHelper.GetParameterFromString("@SalaryMoney", model.SalaryMoney));//金额
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//最后修改人
}
/// <summary>
/// 新建提成工资项信息
/// </summary>
/// <param name="model">提成工资项信息</param>
/// <returns></returns>
private static SqlCommand InsertCommissionSalaryInfo(CommissionSalaryModel model)
{
#region 登陆SQL文
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine(" INSERT INTO ");
insertSql.AppendLine(" officedba.CommissionSalary ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,EmployeeID ");
insertSql.AppendLine(" ,CommDate ");
insertSql.AppendLine(" ,ItemNo ");
insertSql.AppendLine(" ,Amount ");
insertSql.AppendLine(" ,SalaryMoney ");
insertSql.AppendLine(" ,ModifiedDate ");
insertSql.AppendLine(" ,ModifiedUserID) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@EmployeeID ");
insertSql.AppendLine(" ,@CommDate ");
insertSql.AppendLine(" ,@ItemNo ");
insertSql.AppendLine(" ,@Amount ");
insertSql.AppendLine(" ,@SalaryMoney ");
insertSql.AppendLine(" ,getdate() ");
insertSql.AppendLine(" ,@ModifiedUserID) ");
insertSql.AppendLine(" SET @SalaryID= @@IDENTITY ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
//设置存储过程名
comm.CommandText = insertSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//添加返回参数
comm.Parameters.Add(SqlHelper.GetOutputParameter("@SalaryID", SqlDbType.Int));
//执行插入并返回插入结果
return comm;
}