public static void updata(object ob) { using (var conn = new SqlConnection(@string)) { if (ob is Accountant) { Accountant c = (Accountant)ob; string sql0 = String.Format(@"update Accountant set ID='{0}',ContractID='{1}',AffirmIncomeGist='{2}', SubAffirmIncomeAmount={3}, SubInvoiceCount={4},SubInvoiceAmount={5},SubCost={6},SubMaterial={7},Subworker={8},SubManufacturing_Costs={9},Subtotal={10},AvgGrossrofitMargin={11},NoAffirmIncomeAmount={12} where ID='{0}'", c.ID, c.ContractID, c.AffirmIncomeGist, c.SubAffirmIncomeAmount, c.SubInvoiceCount, c.SubInvoiceAmount, c.SubCost, c.SubMaterial, c.Subworker, c.SubManufacturing_Costs, c.Subtotal, c.AvgGrossrofitMargin, c.NoAffirmIncomeAmount); conn.Open(); SqlCommand cmd = new SqlCommand(sql0, conn); cmd.ExecuteNonQuery(); } if (ob is Productioner) { Productioner c = (Productioner)ob; string sql0 = String.Format(@"update Productioner set ID='{0}',ContractID='{1}',TotalProduct={2}, NoTotalProduct={3} where ID='{0}'", c.ID, c.ContractID, c.TotalProduct, c.NoTotalProduct); conn.Open(); SqlCommand cmd = new SqlCommand(sql0, conn); cmd.ExecuteNonQuery(); } if (ob is Sales) { Sales c = (Sales)ob; string sql0 = String.Format(@"update Sales set ID='{0}',ContractID='{1}',AmountCollection={2}, NoAmountCollection={3}, SubAffirmIncomeAmount={4},SubInvoiceCount={5},SubInvoiceAmount={6} where ID='{0}'", c.ID, c.ContractID, c.AmountCollection, c.NoAmountCollection, c.SubAffirmIncomeAmount, c.SubInvoiceCount, c.SubInvoiceAmount); conn.Open(); SqlCommand cmd = new SqlCommand(sql0, conn); cmd.ExecuteNonQuery(); } if (ob is Warehouse) { Warehouse c = (Warehouse)ob; string sql0 = String.Format(@"update Warehouse set ID='{0}',ContractID='{1}',Reserves={2},ShippedCount={3}, NoShippedCount={4} where ID='{0}'", c.ID, c.ContractID, c.Reserves, c.ShippedCount, c.NoShippedCount); conn.Open(); SqlCommand cmd = new SqlCommand(sql0, conn); cmd.ExecuteNonQuery(); } if (ob is Project) { Project c = (Project)ob; string sql0 = String.Format(@"update Project set ID='{0}',ContractID='{1}',DompletedDate='{2}',DompletedAcceptanceDate='{3}',ProjectStart='{4}' where ID='{0}'", c.ID, c.ContractID, c.DompletedDate, c.DompletedAcceptanceDate, c.ProjectStart); conn.Open(); SqlCommand cmd = new SqlCommand(sql0, conn); cmd.ExecuteNonQuery(); } if (ob is Contract_Data) { Contract_Data a = (Contract_Data)ob; string sql0 = String.Format(@"update Contract_Data set ID='{0}',Contract_ID='{1}',Service='{2}' where ID='{0}'", a.ID, a.Contract_ID, a.Service); conn.Open(); SqlCommand cmd = new SqlCommand(sql0, conn); cmd.ExecuteNonQuery(); } } }
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); }