/// <summary>
/// 删除单据
/// </summary>
/// <param name="orderNos"></param>
/// <returns></returns>
public static bool DelOrder(string orderNos, out string strMsg, out string strFieldText)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
strFieldText = "";
strMsg = "";
try
{
isSucc = SellChannelSttlDBHelper.DelOrder(orderNos, out strMsg, out strFieldText);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLCHANNELSTTL_INFO);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
string[] orderNoS = null;
orderNoS = orderNos.Split(',');
for (int i = 0; i < orderNoS.Length; i++)
{
SellLogCommon.InsertLog(orderNoS[i], ConstUtil.MODULE_ID_SELLCHANNELSTTL_INFO, ConstUtil.CODING_RULE_TABLE_SELLCHANNELSTTL, remark, ConstUtil.LOG_PROCESS_DELETE);
}
return(isSucc);
}
/// <summary>
/// 取消结单
/// </summary>
/// <param name="OrderNO">单据编号</param>
/// <param name="strMsg">操作返回的信息</param>
/// <returns></returns>
public static bool UnCloseOrder(string OrderNO, out string strMsg)
{
string strElement = string.Empty;
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
//操作名称
strElement = ConstUtil.LOG_PROCESS_CONCELCOMPLETE;
strMsg = "";
try
{
isSucc = SellChannelSttlDBHelper.UnCloseOrder(OrderNO, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//写入日志
SellLogCommon.InsertLog(OrderNO, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD, ConstUtil.CODING_RULE_TABLE_SELLCHANNELSTTL, remark, strElement);
return(isSucc);
}
/// <summary>
/// 删除单据
/// </summary>
/// <param name="orderNos"></param>
/// <returns></returns>
public static bool DelOrder(string orderNos, out string strMsg, out string strFieldText)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
strFieldText = "";
strMsg = "";
try
{
isSucc = SellPlanDBHelper.DelOrder(orderNos, out strMsg, out strFieldText);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031002");
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
string[] orderNoS = null;
orderNoS = orderNos.Split(',');
for (int i = 0; i < orderNoS.Length; i++)
{
SellLogCommon.InsertLog(orderNoS[i], "2031002", "officedba.SellPlan", remark, ConstUtil.LOG_PROCESS_DELETE);
}
return(isSucc);
}
/// <summary>
/// 取消结单
/// </summary>
/// <param name="OrderNO">单据编号</param>
/// <param name="strMsg">操作返回的信息</param>
/// <returns></returns>
public static bool UnCloseOrder(string OrderNO, out string strMsg)
{
string strElement = string.Empty;
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
//操作名称
strElement = ConstUtil.LOG_PROCESS_CONCELCOMPLETE;
strMsg = "";
try
{
isSucc = SellPlanDBHelper.UnCloseOrder(OrderNO, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031001");
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//写入日志
SellLogCommon.InsertLog(OrderNO, "2031001", "officedba.SellPlan", remark, strElement);
return(isSucc);
}
/// <summary>
/// 删除回款计划
/// </summary>
/// <param name="strIDS"></param>
/// <returns></returns>
public static bool DelSellGathering(string strIDS, out string strMsg)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
strMsg = "";
try
{
isSucc = SellGatheringDBHelper.DelSellGathering(strIDS, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_GATHERING_INFO);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
string[] orderNoS = null;
orderNoS = strIDS.Split(',');
for (int i = 0; i < orderNoS.Length; i++)
{
SellLogCommon.InsertLog(orderNoS[i], ConstUtil.MODULE_ID_GATHERING_INFO, ConstUtil.CODING_RULE_TABLE_GATHERING, remark, ConstUtil.LOG_PROCESS_DELETE);
}
return(isSucc);
}
/// <summary>
/// 确认单据
/// </summary>
/// <param name="OrderNO">单据编号</param>
/// <param name="strMsg">操作返回的信息</param>
/// <returns></returns>
public static bool ConfirmOrder(SellChannelSttlModel sellChannelSttlModel, out string strMsg, out string strFieldText)
{
string strElement = string.Empty;
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
//操作名称
strElement = ConstUtil.LOG_PROCESS_CONFIRM;
strFieldText = "";
strMsg = "";
try
{
isSucc = SellChannelSttlDBHelper.ConfirmOrder(sellChannelSttlModel.SttlNo, out strMsg, out strFieldText);
//确认成功后调用“自动生成凭证”方法
if (isSucc == true)
{
string str = "";
bool AutoVoucherInsertFlag = XBase.Business.Office.FinanceManager.AutoVoucherBus.AutoVoucherInsert(3, Convert.ToDecimal(sellChannelSttlModel.TotalFee), "officedba.SellChannelSttl," + sellChannelSttlModel.ID, sellChannelSttlModel.CurrencyType + "," + sellChannelSttlModel.Rate, Convert.ToInt32(sellChannelSttlModel.CustID), out str);
//returnValue=0 业务单未设凭证模板,returnValue=1 企业不启用业务单自动生成凭证,returnValue = 2 企业不启用自动生成凭证自动登帐, returnValue = 3 自动生成凭证失败 ，returnValue = "4" 回写业务单登记凭证状态成功，returnValue = "5" 回写业务单登记凭证状态失败
if (AutoVoucherInsertFlag == true)
{
strMsg += str;
}
else
{
strMsg += str;
}
}
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//写入日志
SellLogCommon.InsertLog(sellChannelSttlModel.SttlNo, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD, ConstUtil.CODING_RULE_TABLE_SELLCHANNELSTTL, remark, strElement);
return(isSucc);
}
/// <summary>
/// 取消确认单据
/// </summary>
/// <param name="OrderNO">单据编号</param>
/// <param name="strMsg">操作返回的信息</param>
/// <returns></returns>
public static bool UnConfirmOrder(SellChannelSttlModel sellChannelSttlModel, out string strMsg)
{
string strElement = string.Empty;
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
//操作名称
strElement = ConstUtil.LOG_PROCESS_UNCONFIRM;
strMsg = "";
try
{
isSucc = SellChannelSttlDBHelper.UnConfirmOrder(sellChannelSttlModel.SttlNo, out strMsg);
//取消确认成功后调用“自动生成凭证”方法
if (isSucc == true)
{
string str = "";
bool AutoVoucherInsertFlag = XBase.Business.Office.FinanceManager.AutoVoucherBus.AntiConfirmVoucher("officedba.SellChannelSttl," + sellChannelSttlModel.ID, out str);
if (AutoVoucherInsertFlag == true)
{
//strMsg += str;
}
else
{
strMsg += str;
}
}
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//写入日志
SellLogCommon.InsertLog(sellChannelSttlModel.SttlNo, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD, ConstUtil.CODING_RULE_TABLE_SELLCHANNELSTTL, remark, strElement);
return(isSucc);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="adversarySellModel"></param>
public static bool Update(AdversarySellModel adversarySellModel)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
try
{
isSucc = AdversarySellDBHelper.Update(adversarySellModel);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_ADVERSARYSELL_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(adversarySellModel.CustNo, ConstUtil.MODULE_ID_ADVERSARYSELL_ADD, ConstUtil.CODING_RULE_TABLE_ADVERSARYSELL, remark, ConstUtil.LOG_PROCESS_UPDATE);
return(isSucc);
}
/// <summary>
/// 添加销售机会及阶段
/// </summary>
/// <param name="sellChanceModel">销售机会表实体</param>
/// <param name="sellChancePushModel">销售阶段表实体</param>
/// <returns>是否添加成功</returns>
public static bool UpdateSellChance(Hashtable ht, SellChanceModel sellChanceModel, SellChancePushModel sellChancePushModel)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
try
{
isSucc = SellChanceDBHelper.UpdateSellChance(ht, sellChanceModel, sellChancePushModel);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLCHANCE_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(sellChanceModel.ChanceNo, ConstUtil.MODULE_ID_SELLCHANCE_ADD, ConstUtil.CODING_RULE_TABLE_SELLCHANCE, remark, ConstUtil.LOG_PROCESS_UPDATE);
return(isSucc);
}
/// <summary>
/// 更新销售委托代销单
/// </summary>
/// <returns></returns>
public static bool UpdateOrder(Hashtable ht, SellChannelSttlModel sellChannelSttlModel, List <SellChannelSttlDetailModel> sellChannelSttlDetailModellist, out string strMsg)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
strMsg = "";
try
{
isSucc = SellChannelSttlDBHelper.UpdateOrder(ht, sellChannelSttlModel, sellChannelSttlDetailModellist, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(sellChannelSttlModel.SttlNo, ConstUtil.MODULE_ID_SELLCHANNELSTTL_ADD, ConstUtil.CODING_RULE_TABLE_SELLCHANNELSTTL, remark, ConstUtil.LOG_PROCESS_UPDATE);
return(isSucc);
}
/// <summary>
///总结计划
/// </summary>
/// <returns></returns>
public static bool SummarizeOrder(SellPlanDetailModel model, out string strMsg)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
strMsg = "";
try
{
isSucc = SellPlanDBHelper.SummarizeOrder(model, out strMsg);
//设置操作成功标识
remark = "总结成功";
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031001");
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(model.PlanNo, "2031001", "officedba.SellPlanDetail", remark, ConstUtil.LOG_PROCESS_UPDATE);
return(isSucc);
}
/// <summary>
/// 更新销售发货单
/// </summary>
/// <returns></returns>
public static bool Update(Hashtable ht, SellPlanModel sellPlanModel, SellPlanDetailModel sellPlanDetail, string strDetailAction, out string strMsg)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
strMsg = "";
try
{
isSucc = SellPlanDBHelper.Update(ht, sellPlanModel, sellPlanDetail, strDetailAction, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031001");
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(sellPlanModel.PlanNo, "2031001", "officedba.SellPlan", remark, ConstUtil.LOG_PROCESS_UPDATE);
return(isSucc);
}
/// <summary>
/// 保存销售发货单
/// </summary>
/// <returns></returns>
public static bool SaveSellBack(Hashtable ht, SellBackModel sellBackModel, List <SellBackDetailModel> sellBackDetailModellList, out string strMsg)
{
bool isSuc = false;
string remark = string.Empty;
strMsg = "";
try
{
isSuc = SellBackDBHelper.SaveSellBack(ht, sellBackModel, sellBackDetailModellList, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLBACK_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(sellBackModel.BackNo, ConstUtil.MODULE_ID_SELLBACK_ADD, ConstUtil.CODING_RULE_TABLE_SELLBACK, remark, ConstUtil.LOG_PROCESS_INSERT);
return(isSuc);
}
/// <summary>
/// 修改回款计划
/// </summary>
/// <param name="sellGatheringModel"></param>
/// <returns></returns>
public static bool UpdateSellGathering(Hashtable ht, SellGatheringModel sellGatheringModel, out string strMsg)
{
bool isSuc = false;
string remark = string.Empty;
strMsg = "";
try
{
isSuc = SellGatheringDBHelper.UpdateSellGathering(ht, sellGatheringModel, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_GATHERING_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(sellGatheringModel.GatheringNo, ConstUtil.MODULE_ID_GATHERING_ADD, ConstUtil.CODING_RULE_TABLE_GATHERING, remark, ConstUtil.LOG_PROCESS_UPDATE);
return(isSuc);
}
/// <summary>
/// 删除单据
/// </summary>
/// <param name="orderNos"></param>
/// <returns></returns>
public static bool DelOrder(string orderIDs)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
try
{
isSucc = AdversarySellDBHelper.DelOrder(orderIDs);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_ADVERSARYSELL_INFO);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(orderIDs, ConstUtil.MODULE_ID_ADVERSARYSELL_INFO, ConstUtil.CODING_RULE_TABLE_ADVERSARYSELL, remark, ConstUtil.LOG_PROCESS_DELETE);
return(isSucc);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="adversarySellModel"></param>
/// <returns></returns>
public static int?Insert(AdversarySellModel adversarySellModel)
{
int?id = null;
string remark = string.Empty;
try
{
id = AdversarySellDBHelper.Insert(adversarySellModel);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_ADVERSARYSELL_ADD);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(adversarySellModel.CustNo, ConstUtil.MODULE_ID_ADVERSARYSELL_ADD, ConstUtil.CODING_RULE_TABLE_ADVERSARYSELL, remark, ConstUtil.LOG_PROCESS_INSERT);
return(id);
}