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