private void listView_Contract_SelectionChanged(object sender, SelectionChangedEventArgs e) { ct = (ContractNameT)listView_Contract.SelectedItem; if (ct == null) { listView_Contract.SelectedIndex = 0; ct = (ContractNameT)listView_Contract.SelectedItem; } ocd = SqlQuery.ContractDataQuery(ct.ID); ListViewSerices.ItemsSource = ocd; MClass mc = new MClass(); aac = SqlQuery.AccountantQuery(ct.ID); mc.ac = aac; mc.oac = SqlQuery.AccountantLogQuery(ct.ID); oac = mc.oac; wwh = SqlQuery.WarehouseQuery(ct.ID); mc.wh = wwh; ocw = SqlQuery.WarehouseLogQuery(ct.ID); mc.ocw = ocw; ppr = SqlQuery.ProductionerQuery(ct.ID); mc.pr = ppr; opr = SqlQuery.ProductionerLogQuery(ct.ID); mc.opr = opr; ppt = SqlQuery.Project_dataQuery(ct.ID); mc.pt = ppt; opt = mc.opt = SqlQuery.ProjectLogQuery(ct.ID); ssl = SqlQuery.SalesQuery(ct.ID); mc.sl = ssl; osl = mc.osl = SqlQuery.SalesLogQuery(ct.ID); mc.ct = SqlQuery.ContractVQuery(ct.ID)[0]; MGrid.DataContext = mc; }
public static void Contractinsert(ContractNameT ct, Accountant ac, Productioner pr, Project pj, Sales sa, Warehouse wh) { using (var conn = new SqlConnection(@string)) { string sql0 = String.Format(@"insert into ContractNameT (ID,Customer,Contract_Type,Contract_Amount,Count,Contract_Number,Contract_Date,ContractName) values('{7}','{0}','{1}',{2},{3},'{4}','{5}','{6}');", ct.Customer, ct.Contract_Type, ct.Contract_Amount, ct.Count, ct.Contract_Number, ct.Contract_Date, ct.ContractName, ct.ID); //string sql1 = String.Format(@"insert into Contract_Data (ID,Service,Contract_ID) values('{0}','{1}','{2}');", cd.ID,cd.Service, cd.Contract_ID); string sql2 = String.Format(@"insert into Accountant (ID,ContractID,AffirmIncomeGist,SubAffirmIncomeAmount,SubInvoiceCount,SubInvoiceAmount,SubCost,SubMaterial,Subworker,SubManufacturing_Costs,AvgGrossrofitMargin,NoAffirmIncomeAmount,Subtotal) values('{0}','{1}','{2}',{3},{4},{5},{6},{7},{8},{9},{10},{11},{12});", ac.ID, ac.ContractID, ac.AffirmIncomeGist, ac.SubAffirmIncomeAmount, ac.SubInvoiceCount, ac.SubInvoiceAmount, ac.SubCost, ac.SubMaterial, ac.Subworker, ac.SubManufacturing_Costs, ac.AvgGrossrofitMargin, ac.NoAffirmIncomeAmount, ac.Subtotal); string sql3 = String.Format(@"insert into Productioner (ID,ContractID,TotalProduct,NoTotalProduct) values('{0}','{1}',{2},{3});", pr.ID, pr.ContractID, pr.TotalProduct, pr.NoTotalProduct); string sql4 = String.Format(@"insert into Project (ID,ContractID,DompletedDate,DompletedAcceptanceDate) values('{0}','{1}','{2}','{3}');", pj.ID, pj.ContractID, pj.DompletedDate, pj.DompletedAcceptanceDate); string sql5 = String.Format(@"insert into Sales (ID,ContractID,AmountCollection,NoAmountCollection,SubAffirmIncomeAmount,SubInvoiceCount,SubInvoiceAmount) values('{0}','{1}',{2},'{3}',{4},{5},{6});", sa.ID, sa.ContractID, sa.AmountCollection, sa.NoAmountCollection, sa.SubAffirmIncomeAmount, sa.SubInvoiceCount, sa.SubInvoiceAmount); string sql6 = String.Format(@"insert into Warehouse (ID,ContractID,Reserves,ShippedCount,NoShippedCount) values('{0}','{1}',{2},{3},{4});", wh.ID, wh.ContractID, wh.Reserves, wh.ShippedCount, wh.NoShippedCount); string[] sqls = { sql0, sql2, sql3, sql4, sql5, sql6 }; string s = string.Concat(sqls); conn.Open(); SqlCommand cmd = new SqlCommand(s, conn); cmd.ExecuteNonQuery(); } }
public static void first(ContractNameT ct, Contract_Data cd) { Accountant ac = new Accountant(); ac.ID = Guid.NewGuid(); ac.ContractID = ct.ID; ac.NoAffirmIncomeAmount = ct.Contract_Amount; ac.SubAffirmIncomeAmount = 0; ac.SubInvoiceAmount = 0; ac.SubInvoiceCount = 0; ac.SubManufacturing_Costs = 0; ac.SubMaterial = 0; ac.Subtotal = 0; ac.Subworker = 0; ac.SubCost = 0; Productioner pr = new Productioner(); pr.ContractID = ct.ID; pr.NoTotalProduct = ct.Count; pr.TotalProduct = 0; pr.ID = Guid.NewGuid(); Project pt = new Project(); pt.ID = Guid.NewGuid(); pt.ContractID = ct.ID; Sales sl = new Sales(); sl.ID = Guid.NewGuid(); sl.ContractID = ct.ID; sl.AmountCollection = 0; sl.NoAmountCollection = ct.Contract_Amount; sl.SubAffirmIncomeAmount = 0; sl.SubInvoiceCount = 0; sl.SubInvoiceAmount = 0; Warehouse wh = new Warehouse(); wh.ID = Guid.NewGuid(); wh.ContractID = ct.ID; wh.NoShippedCount = ct.Count; wh.Reserves = 0; wh.ShippedCount = 0; SqlQuery.Contractinsert(ct, ac, pr, pt, sl, wh); }
private void btn_Save_Click(object sender, RoutedEventArgs e) { try { string contractName = tb_ContractName.Text.ToString().Trim(); string customer = tb_Customer.Text.ToString().Trim(); ComboBoxItem item = cb_Contract_Type.SelectedItem as ComboBoxItem; string contract_Type = item.Content.ToString().Trim(); string contract_Amount = tb_Contract_Amount.Text.ToString().Trim(); string count = tb_Count.Text.ToString().Trim(); string contract_Number = tb_Contract_Number.Text.ToString().Trim(); string contract_Date; if (string.IsNullOrEmpty(tb_Contract_Date.ToString())) { contract_Date = ""; } else { contract_Date = DateTime.Parse(tb_Contract_Date.ToString().Trim()).ToShortDateString(); } if (string.IsNullOrEmpty(contractName) || string.IsNullOrEmpty(customer) || string.IsNullOrEmpty(contract_Type) || string.IsNullOrEmpty(contract_Amount) || string.IsNullOrEmpty(count) || string.IsNullOrEmpty(contract_Number) || string.IsNullOrEmpty(contract_Date)) { MessageBox.Show("所有值皆不能为空"); } else if (decimal.Parse(contract_Amount) < 0) { MessageBox.Show("合同金额不能为负数"); } else if (double.Parse(count) < 0) { MessageBox.Show("数量不能为负数"); } else if (double.Parse(count) % 1 != 0) { MessageBox.Show("数量不能为小数"); } else { ContractNameT ct = new ContractNameT(); ct.ID = Guid.NewGuid(); ct.Customer = customer; ct.ContractName = contractName; ct.Contract_Type = contract_Type; ct.Contract_Amount = Convert.ToDecimal(contract_Amount); ct.Contract_Date = contract_Date; ct.Contract_Number = contract_Number; ct.Count = Convert.ToDouble(count); Contract_Data cd = new Contract_Data(); cd.ID = Guid.NewGuid(); cd.Contract_ID = ct.ID; //cd.Service = "总服务"; GetData.first(ct, cd); //oct = new ObservableCollection<ContractNameT>(); var a = mw.oct; mw.oct.Add(ct); mw.oct = new ObservableCollection <ContractNameT>(mw.oct.OrderByDescending(x => DateTime.Parse(x.Contract_Date))); mw.listView_Contract.ItemsSource = mw.oct; mw.listView_Contract.Items.Refresh(); MessageBox.Show("操作成功!"); mw.listView_Contract.SelectedItem = ct; //立即创建一个服务 InsertService ins = new InsertService(); ins.mw = this.mw; ins.ShowDialog(); this.Close(); } } catch (FormatException) { MessageBox.Show("合同金额和数量只能为正数"); } }