/// <summary> /// 新建社会保险录入信息 /// </summary> /// <param name="model">社会保险录入信息</param> /// <returns></returns> private static SqlCommand InsertInsuEmployeeInfo(InsuEmployeeModel model) { #region 登陆SQL文 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO "); insertSql.AppendLine(" officedba.InsuEmployee "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,EmployeeID "); insertSql.AppendLine(" ,StartDate "); insertSql.AppendLine(" ,Addr "); insertSql.AppendLine(" ,InsuranceID "); insertSql.AppendLine(" ,InsuranceBase "); insertSql.AppendLine(" ,ModifiedDate "); insertSql.AppendLine(" ,ModifiedUserID) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@EmployeeID "); insertSql.AppendLine(" ,@StartDate "); insertSql.AppendLine(" ,@Addr "); insertSql.AppendLine(" ,@InsuranceID "); insertSql.AppendLine(" ,@InsuranceBase "); insertSql.AppendLine(" ,getdate() "); insertSql.AppendLine(" ,@ModifiedUserID) "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); //设置存储过程名 comm.CommandText = insertSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //执行插入并返回插入结果 return(comm); }
/// <summary> /// 更新社会保险录入信息 /// </summary> /// <param name="model">社会保险录入信息</param> /// <returns></returns> private static SqlCommand UpdateInsuEmployeeInfo(InsuEmployeeModel model) { #region SQL文拼写 StringBuilder updateSql = new StringBuilder(); updateSql.AppendLine(" UPDATE "); updateSql.AppendLine(" officedba.InsuEmployee "); updateSql.AppendLine(" SET StartDate = @StartDate "); updateSql.AppendLine(" ,Addr = @Addr "); updateSql.AppendLine(" ,InsuranceBase = @InsuranceBase "); updateSql.AppendLine(" ,ModifiedDate = getdate() "); updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); updateSql.AppendLine(" WHERE "); updateSql.AppendLine(" CompanyCD = @CompanyCD "); updateSql.AppendLine(" AND InsuranceID = @InsuranceID "); updateSql.AppendLine(" AND EmployeeID = @EmployeeID "); #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, InsuEmployeeModel model) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID)); //员工ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@InsuranceID", model.InsuranceID)); //保险ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartDate", model.StartDate)); //参保时间 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Addr", model.Addr)); //参保地 comm.Parameters.Add(SqlHelper.GetParameterFromString("@InsuranceBase", model.InsuranceBase)); //金额 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //更新用户ID }
/// <summary> /// 保存社会保险录入信息 /// </summary> /// <param name="lstEdit">社会保险录入信息</param> /// <param name="modifyUserID">最后修改人</param> /// <returns></returns> public static bool SaveInsuEmployeeInfo(ArrayList lstEdit, string companyCD, string modifyUserID) { //定义返回变量 bool isSucc = true; //信息存在时,进行操作 if (lstEdit != null && lstEdit.Count > 0) { //保存库列表 ArrayList lstSave = new ArrayList(); //遍历所有社会保险录入,进行增删改操作 for (int i = 0; i < lstEdit.Count; i++) { //获取值 InsuEmployeeModel model = (InsuEmployeeModel)lstEdit[i]; //设置最后修改人 model.ModifiedUserID = modifyUserID; //设置公司代码 model.CompanyCD = companyCD; //更新 if ("1".Equals(model.EditFlag)) { //执行更新操作 lstSave.Add(UpdateInsuEmployeeInfo(model)); } //插入 else if ("0".Equals(model.EditFlag)) { //执行插入操作 lstSave.Add(InsertInsuEmployeeInfo(model)); } else { //执行删除操作 lstSave.Add(DeleteInsuEmployeeInfo(model.CompanyCD, model.EmployeeID, model.InsuranceID)); } } //执行保存操作 isSucc = SqlHelper.ExecuteTransWithArrayList(lstSave); } return(isSucc); }