public static List <int> QueryRMARequsetSysNoByRefundSysNo(int refundSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("QueryRMARequsetSysNoByRefundSysNo");
command.SetParameterValue("@RefundSysNo", refundSysNo);
return(command.ExecuteFirstColumn <int>());
}
/// <summary>
/// 根据供应商系统编号取得代收结算单系统编号列表
/// </summary>
/// <param name="vendorSysNo">供应商系统编号</param>
/// <returns></returns>
public List <int> GetGatherSettlementSysNoListByVendorSysNo(int vendorSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetGatherSettlementSysNoListByVendorSysNo");
command.SetParameterValue("@VendorSysNo", vendorSysNo);
return(command.ExecuteFirstColumn <Int32>());
}
/// <summary>
/// 查询前台分类的父类系统编号列表
/// </summary>
/// <param name="sysNo">前台分类系统编号</param>
/// <returns>父类系统编号列表</returns>
public List <int> GetECCategoryCurrentParentSysNos(int sysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("ECCategory_LoadParentSysNoList");
cmd.SetParameterValue("@SysNo", sysNo);
return(cmd.ExecuteFirstColumn <int>());
}
public List <int> GetSelectedArea(int RefSysNo, BizEntity.MKT.AreaRelationType Type)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetSelectedArea");
dc.SetParameterValue("@RefSysNo", RefSysNo);
dc.SetParameterValue("@Type", Type);
return(dc.ExecuteFirstColumn <int>());
}
/// <summary>
/// 获取组件的可选商品分类编号
/// </summary>
/// <param name="partSysNo">组件系统编号</param>
/// <returns></returns>
public List <int> GetComputerPartsCategory(int partSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryCategoryByComputerPart");
cmd.SetParameterValue("@ComputerPartSysNo", partSysNo);
return(cmd.ExecuteFirstColumn <int>());
}
public List <string> GetEmailAddressByResponsibleUserName(string userName)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetEmailAddressByResponsibleUserName");
cmd.SetParameterValue("@ResponsibleUserName", userName);
cmd.SetParameterValue("@CompanyCode", "8601"); //TODO:暂时写成8601
return(cmd.ExecuteFirstColumn <string>());
}
