private void InsertCustomerPriceClickExecute() { if (NewCustomerPrice <= 0) { MessageBox.Show("設定的客戶單價不正確!!"); return; } bool newDefaultPriceSuccess = false; if (SelectedCustomerCheckBillSheet.DefaultPrice == 0) { List <AccountTextile> accountTextile = new List <AccountTextile>() { new AccountTextile { FactoryID = SelectedCustomerCheckBillSheet.F_01, ItemID = SelectedCustomerCheckBillSheet.I_01, ItemName = SelectedCustomerCheckBillSheet.I_03, DefaultPrice = Convert.ToInt32(SelectedCustomerCheckBillSheet.Price) } }; newDefaultPriceSuccess = AccountSystemModule.InsertDefaultPrice(accountTextile); } IEnumerable <AccountTextile> accountTextiles = AccountSystemModule.GetAccountTextile(); CustomerTextilePrice customerTextilePrice = new CustomerTextilePrice { AccountTextileID = accountTextiles.Where(w => w.FactoryID == SelectedCustomerCheckBillSheet.F_01 && w.ItemID == SelectedCustomerCheckBillSheet.I_01).FirstOrDefault().AccountTextileID, AccountCustomerID = SelectedTrashCustomer.CARD_NO, Price = NewCustomerPrice }; if (!AccountSystemModule.GetCustomerTextilePrice(SelectedCustomerCheckBillSheet.C_01).Any(a => a.AccountTextileID == SelectedCustomerCheckBillSheet.AccountTextileID)) { bool success = AccountSystemModule.InsertCustomerTextilePrice(customerTextilePrice); if (success) { bool updateTrashSystemsuccess = UpdateTrashSystemPrice(SelectedCustomerCheckBillSheet, NewCustomerPrice); if (updateTrashSystemsuccess) { DisplayUpdate(newDefaultPriceSuccess, NewCustomerPrice); MessageBox.Show("新增客戶單價成功!"); } else { MessageBox.Show("帳務系統新增失敗!!", "錯誤!", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("新增失敗!!", "錯誤!", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("已設定過該客戶的布種單價,請使用更新單價功能!!"); } }
/// <summary> /// 新增客戶布種單價 /// </summary> /// <returns></returns> public int InsertCustomerTextilePrice(CustomerTextilePrice customerTextilePrice) { string sql = @"INSERT INTO CustomerTextilePrice ([AccountCustomerID] ,[AccountTextileID] ,[Price]) VALUES (@AccountCustomerID, @AccountTextileID, @Price);"; var result = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sql, customerTextilePrice); return(result); }
/// <summary> /// 新增客戶布種單價 /// </summary> /// <returns></returns> public bool InsertCustomerTextilePrice(CustomerTextilePrice customerTextilePrice) { int count = AccountSystemAdapter.InsertCustomerTextilePrice(customerTextilePrice); return(count == 1); }