/// <summary> /// 绩效工资基数录入信息 /// </summary> /// <returns>DataTable</returns> public static DataTable GetInfo(PerformanceRoyaltyBaseModel model, int pageIndex, int pageCount, string ord, ref int TotalCount) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("SELECT a.ID "); strSql.AppendLine(",a.EmployeeID "); strSql.AppendLine(",case a.EmployeeID when '0' then '默认' else b.EmployeeName end as EmployeeName "); strSql.AppendLine(",a.BaseMoney "); strSql.AppendLine(",a.TaskFlag"); strSql.AppendLine(",case a.TaskFlag when '1' then '月考核系数' when '2' then '季度考核系数' when '3' then '半年考核系数' when '4' then '年考核系数' end as TaskFlagName "); strSql.AppendLine("FROM officedba.PerformanceRoyaltyBase a "); strSql.AppendLine("left join officedba.EmployeeInfo b on a.EmployeeID=b.ID "); strSql.AppendLine("where a.CompanyCD=@CompanyCD "); SqlCommand comm = new SqlCommand(); //添加公司代码参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); if (!string.IsNullOrEmpty(model.EmployeeID)) { strSql.AppendLine(" and a.EmployeeID = @EmployeeID"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID)); } if (!string.IsNullOrEmpty(model.TaskFlag)) { strSql.AppendLine(" and a.TaskFlag = @TaskFlag"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag)); } comm.CommandText = strSql.ToString(); return SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, ord, ref TotalCount); }
/// <summary> /// 插入一条新的数据,如果成功给Model.ID赋值主键,否则Model.ID="0" /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool InSert(PerformanceRoyaltyBaseModel Model) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("insert into officedba.PerformanceRoyaltyBase("); strSql.AppendLine("EmployeeID,CompanyCD,BaseMoney,TaskFlag,ModifiedUserID,ModifiedDate)"); strSql.AppendLine(" values ("); strSql.AppendLine("@EmployeeID,@CompanyCD,@BaseMoney,@TaskFlag,@ModifiedUserID,getdate())"); strSql.AppendLine(";set @IndexID= @@IDENTITY"); SqlCommand comm = new SqlCommand(); comm.CommandText = strSql.ToString(); SqlParameter IndexID = new SqlParameter("@IndexID", SqlDbType.Int); IndexID.Direction = ParameterDirection.Output; comm.Parameters.Add(IndexID); SetSaveParameter(comm, Model); bool result = SqlHelper.ExecuteTransWithCommand(comm); if (result) { Model.ID = comm.Parameters["@IndexID"].Value.ToString(); } else { Model.ID = "0"; } return result; }
/// <summary> /// 查询绩效工资基数信息 /// </summary> /// <returns>DataTable</returns> public static DataTable GetInfo(PerformanceRoyaltyBaseModel model, int pageIndex, int pageCount, string ord, ref int TotalCount) { try { return PerformanceRoyaltyBaseDBHelper.GetInfo(model, pageIndex, pageCount, ord, ref TotalCount); } catch (Exception) { throw; } }
/// <summary> /// 插入一条新的数据,如果成功给Model.ID赋值主键,否则Model.ID="0" /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool InSert(PerformanceRoyaltyBaseModel Model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ try { isSucc = PerformanceRoyaltyBaseDBHelper.InSert(Model); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(Model.EmployeeID); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; }
/// <summary> /// 存在则返回true /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool ifEitst(PerformanceRoyaltyBaseModel Model) { string strSql = "select count(*) from officedba.PerformanceRoyaltyBase where CompanyCD='" + Model.CompanyCD + "' and EmployeeID=" + Model.EmployeeID + " and TaskFlag='" + Model.TaskFlag + "'"; return SqlHelper.Exists(strSql, null); }
/// <summary> /// 保存时基本信息参数设置 /// </summary> /// <param name="comm"></param> /// <param name="model"></param> private static void SetSaveParameter(SqlCommand comm, PerformanceRoyaltyBaseModel model) { if (model.ID != "0") { comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID ", model.ID));//自动生成 } comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID ", model.EmployeeID));//分公司ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD ", model.CompanyCD));//公司编码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@BaseMoney ", model.BaseMoney));//数量 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag ", model.TaskFlag));//考核类型 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID ", model.ModifiedUserID));//最后更新人 }
/// <summary> /// 更新数据 /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool Update(PerformanceRoyaltyBaseModel Model) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("update officedba.PerformanceRoyaltyBase set "); strSql.AppendLine("EmployeeID=@EmployeeID,"); strSql.AppendLine("CompanyCD=@CompanyCD,"); strSql.AppendLine("BaseMoney=@BaseMoney,"); strSql.AppendLine("TaskFlag=@TaskFlag,"); strSql.AppendLine("ModifiedUserID=@ModifiedUserID,"); strSql.AppendLine("ModifiedDate=getdate()"); strSql.AppendLine(" where ID=@ID "); SqlCommand comm = new SqlCommand(strSql.ToString()); SetSaveParameter(comm, Model); return SqlHelper.ExecuteTransWithCommand(comm); }
/// <summary> /// 存在则返回true /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool ifEitst(PerformanceRoyaltyBaseModel Model) { try { return PerformanceRoyaltyBaseDBHelper.ifEitst(Model); } catch (Exception) { throw; } }