/// <summary>
/// 查询在职部门岗位等相关信息
/// </summary>
/// <returns></returns>
public static DataTable SearchPersonTaxInfo(string OrderNo, string EmpName, string StartDate, string EndDate, int pageIndex, int pageCount, string ord, ref int totalCount)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string CompanyCD = userInfo.CompanyCD;
//查询并返回人员信息
return(InputPersonalRoyaltyDBHelper.SearchPersonTaxInfo(CompanyCD, OrderNo, EmpName, StartDate, EndDate, pageIndex, pageCount, ord, ref totalCount));
}
/// <summary>
/// 同步提成率
/// </summary>
/// <param name="ID"></param>
/// <param name="Rate"></param>
/// <returns></returns>
public static bool UpdateRate(string ID, string Rate)
{
try
{
return(InputPersonalRoyaltyDBHelper.UpdateRate(ID, Rate));
}
catch
{
return(false);
throw;
}
}
public static DataTable GetSynchronizerRate(string ID)
{
DataTable dt = new DataTable();
try
{
return(InputPersonalRoyaltyDBHelper.GetSynchronizerRate(ID));
}
catch
{
return(dt);
}
}
public static bool UpdateIsuPersonalTaxInfo(DataTable dt)
{
try
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string ModifiedUserID = userInfo.UserID;
return(InputPersonalRoyaltyDBHelper.UpdateIsuPersonalTaxInfo(dt, ModifiedUserID));
}
catch
{
throw;
}
}
/// <summary>
/// 根据员工和客户获取整个个人提成设置
/// </summary>
/// <param name="OrdrNO"></param>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetSellOrderSynchronizerDetail(string CustID, string EmpID)
{
try
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string CompanyCD = userInfo.CompanyCD;
return(InputPersonalRoyaltyDBHelper.GetSellOrderSynchronizerDetail(CustID, EmpID, CompanyCD));
}
catch
{
return(null);
}
}
public static bool ChargeHava()
{
try
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string CompanyCD = userInfo.CompanyCD;
return(InputPersonalRoyaltyDBHelper.ChargeHava(CompanyCD));
}
catch
{
return(false);
}
}
/// <summary>
/// 判断新老客户
/// </summary>
/// <param name="CustID"></param>
/// <param name="CompanyCD"></param>
/// <param name="OrderDate"></param>
/// <returns></returns>
public static bool ChargeNewOrOld(string CustID, string OrderDate)
{
try
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string CompanyCD = userInfo.CompanyCD;
return(InputPersonalRoyaltyDBHelper.ChargeNewOrOld(CustID, CompanyCD, OrderDate));
}
catch
{
return(false);
}
}
public static bool UpdateSellDetailInfo(DataTable dt)
{
try
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string ModifiedUserID = userInfo.UserID;
string CompanyCD = userInfo.CompanyCD;
return(InputPersonalRoyaltyDBHelper.UpdatePieceworkSalary(dt, ModifiedUserID, CompanyCD));
}
catch
{
throw;
}
}
/// <summary>
/// 获取销售订单明细信息
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="OrderNo"></param>
/// <returns></returns>
public static DataTable GetNotSetSellDetail(string OrdrNO)
{
DataTable dt = new DataTable();
try
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string CompanyCD = userInfo.CompanyCD;
return(InputPersonalRoyaltyDBHelper.GetNotSetSellDetail(CompanyCD, OrdrNO));
}
catch
{
return(dt);
}
}
/// <summary>
/// 获取所有的产品单品提成设置
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="OrdrNO"></param>
/// <returns></returns>
public static DataTable GetCommissionItemProdNo()
{
DataTable dt = new DataTable();
try
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string CompanyCD = userInfo.CompanyCD;
return(InputPersonalRoyaltyDBHelper.GetCommissionItemProdNo(CompanyCD));
}
catch
{
return(dt);
}
}
/// <summary>
/// 获取个人提成工资录入
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="EmpNO"></param>
/// <param name="EmpName"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="ord"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable SearchInputPersonalRoyalty(string EmpNO, string EmpName, string StartDate, string EndDate)
{
DataTable dt = new DataTable();
try
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
string CompanyCD = userInfo.CompanyCD;
return(InputPersonalRoyaltyDBHelper.SearchInputPersonalRoyalty(CompanyCD, EmpNO, EmpName, StartDate, EndDate));
}
catch
{
return(dt);
}
}
