} static Note TableNames ()
{(); TableNames=new Note (); cmd=new SqlCommand ( select * from information_schema.tables raquo ;, conn); (SqlDataReader dr=cmd.ExecuteReader (CommandBehavior.CloseConnection))
{(dr.Read ())
{. Records.Add (dr.GetValue (2) .ToString (). Trim ());
}
} (); TableNames;
} static void Insert (string query)
{(); cmd=new SqlCommand (query, conn) ;. ExecuteNonQuery (); ();
} static void Delete (string query)
{(); cmd=new SqlCommand (query, conn) ;. ExecuteNonQuery (); ();
} static void Update (string query)
{(); cmd=new SqlCommand (query, conn) ;. ExecuteNonQuery (); ();
}
}
}
Вихідний код програмного модуля, що здійснює зв'язок View-проекту з Data-проектом
using System;System.Collections.Generic;System.Linq;System.Text;System.Threading.Tasks;Data;Entity;Logic
{static class WorkWithDB
{static string DBConnect ()
{Data.DBConnect.DBConnection ();
} static void CloseConnection ()
{. DBConnect.CloseConnection ();
} static TableStruct ReadRecords (string Table)
{query; (Table)
{ Expenses raquo ;: query= SELECT ex. [№], com.Name, com.Sum, pd. [FIO], sal.Sum, sre.Name as Sort, c.Name as Currency FROM Expenses as Ex JOIN Sort_Rev_Exp as sre ON ex.Sort_Expenses=sre. [№] JOIN Currency as c ON Ex.Currency=c. [№] LEFT JOIN Coming as com on Ex. [№]=com. [Product Code] LEFT JOIN Salary as sal ON ex. [№]=sal. [№] LEFT JOIN Personal_Data as pd ON sal. [№Contract]=pd. [№Contract] raquo ;;; Coming raquo ;: query = SELECT com. [Product Code], com.Name, com.Count, com.Purchase_price, com.Retail_price, sup. [FIO] as Supplier, com.Date, com.Time from Coming as com JOIN Suppliers as sup ON com.Supplier=sup. [№] raquo ;;; Posts raquo ;: query= SELECT p. [№], p.Name, p.Salary, d.Name as Department FROM Posts as p JOIN Departments as d ON p.Department=d. [№] raquo ;;; Salary raquo ;: query= SELECT sal. [№], sal.Date, pd. [FIO], sal.Sum From Salary as sal JOIN Personal_Data as pd ON sal. [№Contract]=pd. [№Contract] raquo ;;; Empl_Data raquo ;: query= SELECT ed. [№Contract], pd. [FIO], p.Name as Post, d.Name as Department FROM Empl_Data as ed JOIN Posts as p ON ed.Post=p. [№] JOIN Departments as d ON ed.Department=d. [№] JOIN Personal_Data as pd ON ed. [№Contract]=pd. [№Contract] raquo ;;; Merchandise raquo ;: query= SELECT m.Product_Code, m.Name, s.Title as Sort, m.Count, m.Sale_Price FROM Merchandise as m JOIN Sort as s ON m. Sort=s. [№]; raquo ;;; Revenue raquo ;: query= SELECT r. [№], Sale.Name, Sale.Sum, pd. [FIO], sr.Revenue, sre.Name as Sort, c.Name as Currency FROM Revenue as r LEFT JOIN Sale as sale ON r. [№]=sale. [№] LEFT JOIN Services_Rendered as sr ON r. [№]=sr. [№] LEFT JOIN Personal_Data as pd ON sr.Employee=pd. [№Contract] JOIN Sort_Rev_Exp as sre ON r.Sort_Revenue=sre. [№] JOIN Currency as c ON r.Currency=c. [№] raquo ;;; Sale raquo ;: query= SELECT sale. [№], sale.Product_Code, sale.Name, sort.Title as Sort, sale.Count, sale.Price, sale.PriceNDS, cli. [FIO] as Client, sale.Date, sale.Time , sale.Sum FROM Sale as sale JOIN Sort as sort ON sale.Sort=sort. [№] JOIN Clients as cli ON sale.Client=cli. [№] raquo ;;; Services_Rendered raquo ;: query= SELECT sr. [№], ser.Service_Sort, sr.Date, sr.Start_time, sr.Finish_time, pd. [FIO] as Employee, sr.Revenue FROM Services_Rendered as sr JOIN Services as ser ON sr.Service_Sort=ser. [№ ] JOIN Personal_Data as pd ON sr.Employee=pd. [№Contract] raquo ;;;: query= SELECT * FROM + Table ;;
} Data.DBConnect.ReadRecords (query);
} static Note TableNames ()
{Data.DBConnect.TableNames ();
} static void Insert (string query)
{. DBConnect.Insert (query);
} static void Delete (string query)
{. DBConnect.Delete (query);
} static TableStruct Find (string query)
{Data.DBConnect.ReadRecords (query);
} static void Update (string query)
{. DBConnect.Update (query);
}
}
}
Вихідний код програмного модуля, що здійснює роботу Form
using System;System.Collections.Generic;System.ComponentModel;System.Data;System.Dra...
