/// <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;
}
}
