/// <summary>
/// 更新社会保险申请信息
/// </summary>
/// <param name="model">社会保险申请信息</param>
/// <returns></returns>
private static SqlCommand UpdateInsuSocialInfo(InsuSocialModel model)
{
#region SQL文拼写
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.InsuSocial ");
updateSql.AppendLine(" SET InsuranceName = @InsuranceName ");
updateSql.AppendLine(" ,InsuranceWay = @InsuranceWay ");
updateSql.AppendLine(" ,CompanyPayRate = @CompanyPayRate ");
updateSql.AppendLine(" ,PersonPayRate = @PersonPayRate ");
updateSql.AppendLine(" ,UsedStatus = @UsedStatus ");
updateSql.AppendLine(" ,ModifiedDate = getdate() ");
updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID ");
updateSql.AppendLine(" WHERE ");
updateSql.AppendLine("companyCD=@companyCD and ID = @ID ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = updateSql.ToString();
//社会保险编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID", model.ID));
//comm.Parameters.Add(SqlHelper.GetParameterFromString("@companyCD", model.CompanyCD ));
//其他参数
SetSaveParameter(comm, model);
//执行更新
return comm;
}
/// <summary>
/// 保存时参数设置
/// </summary>
/// <param name="comm">命令</param>
/// <param name="model">人才代理信息</param>
private static void SetSaveParameter(SqlCommand comm, InsuSocialModel model)
{
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@InsuranceName", model.InsuranceName));//社会保险名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@InsuranceWay", model.InsuranceWay));//投保方式
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyPayRate", model.CompanyPayRate));//单位缴费比例
comm.Parameters.Add(SqlHelper.GetParameterFromString("@PersonPayRate", model.PersonPayRate));//个人缴费比例
comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用，1启用)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//更新用户ID
}
/// <summary>
/// 新建社会保险申请信息
/// </summary>
/// <param name="model">社会保险申请信息</param>
/// <returns></returns>
private static SqlCommand InsertInsuSocialInfo(InsuSocialModel model)
{
#region 登陆SQL文
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine(" INSERT INTO ");
insertSql.AppendLine(" officedba.InsuSocial ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,InsuranceName ");
insertSql.AppendLine(" ,InsuranceWay ");
insertSql.AppendLine(" ,CompanyPayRate ");
insertSql.AppendLine(" ,PersonPayRate ");
insertSql.AppendLine(" ,UsedStatus ");
insertSql.AppendLine(" ,ModifiedDate ");
insertSql.AppendLine(" ,ModifiedUserID) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@InsuranceName ");
insertSql.AppendLine(" ,@InsuranceWay ");
insertSql.AppendLine(" ,@CompanyPayRate ");
insertSql.AppendLine(" ,@PersonPayRate ");
insertSql.AppendLine(" ,@UsedStatus ");
insertSql.AppendLine(" ,getdate() ");
insertSql.AppendLine(" ,@ModifiedUserID) ");
insertSql.AppendLine(" SET @InsuSocialID= @@IDENTITY ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
//设置存储过程名
comm.CommandText = insertSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//添加返回参数
comm.Parameters.Add(SqlHelper.GetOutputParameter("@InsuSocialID", SqlDbType.Int));
//执行插入并返回插入结果
return comm;
}