def _submit(self):
stock = Stock()
brand = self.brand_comboBox
stock.brand_name(brand.currentText()).brand_id(brand.currentData())
model = self.model_combo_box
stock.model_name(model.currentText()).model_id(model.currentData())
first_service = self.first_service_combo_box
stock.first_service_id(first_service.currentData()).first_service_name(
first_service.currentText())
second_service = self.second_service_combo_box
stock.second_service_name(
second_service.currentText()).second_service_id(
second_service.currentData())
name = brand.currentText() + '-' + model.currentText()
stock.name(name)
stock.unit(self.unit.text())
stock.create_op(common.config.login_user_info[0])
stock.create_time(get_now())
stock_id = stock_handler.add_stock_info(stock)
stock.id(stock_id)
def add_stock_info(model, brand, model_id, brand_id, unit, second_service_id):
second_service = service_handler.get_service_by_id(second_service_id)
stock_info = Stock()
stock_info.model_id(model_id).model_name(model)
stock_info.brand_id(brand_id).brand_name(brand)
stock_info.first_service_id(second_service['father_id']).first_service_name(second_service['father_name'])
stock_info.second_service_id(second_service_id).second_service_name(second_service['name'])
stock_info.unit(unit)
stock_info.name(brand + '-' + model)
stock_info.create_op(config.login_user_info[0]).create_time(time_utils.get_now())
stock_id = stock_handler.add_stock_info(stock_info)
stock_info.id(stock_id)
return stock_info
def _add_stock_info(self, model, brand, model_id, brand_id, line_number, total, number, unit):
service_id = getattr(self, 'service_' + line_number).currentData()
service_name = getattr(self, 'service_' + line_number).currentText()
stock_info = Stock()
services = service_name.split('-')
service_ids = service_id.split('-')
first_service_id = int(service_ids[0])
first_service_name = services[0]
second_service_id = int(service_ids[1])
second_service_name = services[1]
stock_info.model_id(model_id).model_name(model)
stock_info.brand_id(brand_id).brand_name(brand)
stock_info.first_service_id(first_service_id).first_service_name(first_service_name)
stock_info.second_service_id(second_service_id).second_service_name(second_service_name)
stock_info.unit(unit).name(brand + '-' + model)
stock_info.create_op(config.login_user_info[0]).create_time(time_utils.get_now())
stock_info.total_cost(total).balance(number)
stock_id = stock_handler.add_stock_info(stock_info)
return stock_id
def add_stock_info(stock: Stock):
sql_text = '''
INSERT INTO stock_info(
UNIT,
first_service_name,
first_service_id,
model_id,
model_name,
brand_id,
brand_name,
name,
second_service_id,
second_service_name,
balance,
total_cost,
create_time,
create_op
)
VALUES(
'{}',
'{}',
{},
{},
'{}',
{},
'{}',
'{}',
{},
'{}',
{},
{:.2f},
'{}',
{}
)''' \
.format(stock.unit(), stock.first_service_name(), stock.first_service_id(), stock.model_id(),
stock.model_name(), stock.brand_id(), stock.brand_name(), stock.name(), stock.second_service_id(),
stock.second_service_name(), stock.balance(), stock.total_cost(), stock.create_time(),
stock.create_op())
new_stock_id = execute(sql_text)
return new_stock_id