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