/// <summary>
/// 保存时参数设置
/// </summary>
/// <param name="comm">命令</param>
/// <param name="model">人才代理信息</param>
private static void SetSaveParameter(SqlCommand comm, SalaryItemModel model)
{
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemName", model.ItemName));//工资项名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemOrder", model.ItemOrder));//排列先后顺序
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Calculate", model.Calculate));//计算公式
comm.Parameters.Add(SqlHelper.GetParameterFromString("@PayFlag", model.PayFlag));//是否扣款(0否，1是)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ChangeFlag", model.ChangeFlag));//是否为固定项（0否，1是）
comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用，1启用)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//备注
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ParamsList", model.CalculateParam ));//备注
}
/// <summary>
/// 更新工资项申请信息
/// </summary>
/// <param name="model">工资项申请信息</param>
/// <returns></returns>
private static SqlCommand UpdateSalaryItemInfo(SalaryItemModel model,string CompanyCD)
{
#region SQL文拼写
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.SalaryItem ");
updateSql.AppendLine(" SET ");
updateSql.AppendLine(" ItemName = @ItemName ");
updateSql.AppendLine(" ,ItemOrder = @ItemOrder ");
updateSql.AppendLine(" ,Calculate = @Calculate ");
updateSql.AppendLine(" ,ParamsList = @ParamsList ");
updateSql.AppendLine(" ,PayFlag = @PayFlag ");
updateSql.AppendLine(" ,ChangeFlag = @ChangeFlag ");
updateSql.AppendLine(" ,UsedStatus = @UsedStatus ");
updateSql.AppendLine(" ,Remark = @Remark ");
updateSql.AppendLine(" WHERE ");
updateSql.AppendLine("CompanyCD = @CompanyCD and ");
updateSql.AppendLine(" ItemNo = @ItemNo ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = updateSql.ToString();
//工资项编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", model.ItemNo));
//其他参数
SetSaveParameter(comm, model);
//执行更新
return comm;
}
/// <summary>
/// 新建工资项申请信息
/// </summary>
/// <param name="model">工资项申请信息</param>
/// <returns></returns>
private static SqlCommand InsertSalaryItemInfo(SalaryItemModel model)
{
#region 登陆SQL文
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine(" INSERT INTO ");
insertSql.AppendLine(" officedba.SalaryItem ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,ItemName ");
insertSql.AppendLine(" ,ItemOrder ");
insertSql.AppendLine(" ,Calculate ");
insertSql.AppendLine(" ,ParamsList ");
insertSql.AppendLine(" ,PayFlag ");
insertSql.AppendLine(" ,ChangeFlag ");
insertSql.AppendLine(" ,UsedStatus ");
insertSql.AppendLine(" ,Remark) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@ItemName ");
insertSql.AppendLine(" ,@ItemOrder ");
insertSql.AppendLine(" ,@Calculate ");
insertSql.AppendLine(" ,@ParamsList ");
insertSql.AppendLine(" ,@PayFlag ");
insertSql.AppendLine(" ,@ChangeFlag ");
insertSql.AppendLine(" ,@UsedStatus ");
insertSql.AppendLine(" ,@Remark) ");
insertSql.AppendLine(" SET @SalaryItemNo= @@IDENTITY ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
//设置存储过程名
comm.CommandText = insertSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//添加返回参数
comm.Parameters.Add(SqlHelper.GetOutputParameter("@SalaryItemNo", SqlDbType.Int));
//执行插入并返回插入结果
return comm;
}
public static bool InsertSalaryItem(SalaryItemModel model)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine(" INSERT INTO ");
insertSql.AppendLine(" officedba.SalaryItem ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,ItemName ");
insertSql.AppendLine(" ,ItemOrder ");
insertSql.AppendLine(" ,Calculate ");
insertSql.AppendLine(" ,PayFlag ");
insertSql.AppendLine(" ,ChangeFlag ");
insertSql.AppendLine(" ,UsedStatus ");
insertSql.AppendLine(" ,Remark) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@ItemName ");
insertSql.AppendLine(" ,@ItemOrder ");
insertSql.AppendLine(" ,@Calculate ");
insertSql.AppendLine(" ,@PayFlag ");
insertSql.AppendLine(" ,@ChangeFlag ");
insertSql.AppendLine(" ,@UsedStatus ");
insertSql.AppendLine(" ,@Remark) ");
// insertSql.AppendLine(" set @ElemID= @@IDENTITY ");
#endregion
//定义插入基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemName", model.ItemName));//工资项名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemOrder", model.ItemOrder));//排列先后顺序
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Calculate", model.Calculate));//计算公式
comm.Parameters.Add(SqlHelper.GetParameterFromString("@PayFlag", model.PayFlag));//是否扣款(0否，1是)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ChangeFlag", model.ChangeFlag));//是否为固定项（0否，1是）
comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用，1启用)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//备注
//添加返回参数
// comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int));
//执行插入操作
bool isSucc = SqlHelper.ExecuteTransWithCommand(comm);
return isSucc;
}
public static bool InsertSalaryItem(SalaryItemModel model)
{
//定义返回变量
bool isSucc = true;
//信息存在时，进行操作
if (model != null )
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//执行保存操作
try
{
//执行保存操作
isSucc = SalaryItemDBHelper.InsertSalaryItem(model);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
//操作日志
LogInfoModel logModel = InitLogInfo(userInfo.CompanyCD);
//设置关键元素
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//更新成功时
if (isSucc)
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
//更新不成功
else
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
//登陆日志
LogDBHelper.InsertLog(logModel);
}
return isSucc;
}
