コード例 #1
0
ファイル: PromotionCodeDA.cs プロジェクト: sanlonezhang/ql
        public static List <PromotionCodeEntity> QuerySingle(SettingCustomerEntity query)
        {
            DataCommand command = DataCommandManager.GetDataCommand("Promotion_QuerySinglePromotionCode");

            command.SetParameterValue("PromotionSysNo", query.PromotionSysNo);
            command.SetParameterValue("CompanyCode", ConstValues.CompanyCode);
            return(command.ExecuteEntityList <PromotionCodeEntity>());
        }
コード例 #2
0
ファイル: SettingCustomerDA.cs プロジェクト: sanlonezhang/ql
        public static int UpdateStatus(SettingCustomerEntity entity)
        {
            DataCommand command = DataCommandManager.GetDataCommand("Promotion_SetSettingCustomerStatus");

            command.SetParameterValue("EditUser", ConstValues.EditUser);
            command.SetParameterValue("Status", entity.Status);
            command.SetParameterValue("SysNo", entity.SysNo);
            command.SetParameterValue("CompanyCode", ConstValues.CompanyCode);
            return(command.ExecuteNonQuery());
        }
コード例 #3
0
        public static List <CustomerResultEntity> GetLimitCustomer(SettingCustomerEntity setting)
        {
            DataCommand command = DataCommandManager.GetDataCommand("Promotion_GetLimitCustomer");

            command.SetParameterValue("@CompanyCode", ConstValues.CompanyCode);
            command.SetParameterValue("@PromotionSysNo", setting.PromotionSysNo);
            List <CustomerResultEntity> customerList = command.ExecuteEntityList <CustomerResultEntity>();

            return(customerList);
        }