1
1.1 GetTable
using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
namespace hospital
{
static class GetTable
{
static OleDbCommand OleDbComm = new OleDbCommand();
static OleDbConnection OleDbConn = new OleDbConnection();
static OleDbDataAdapter OleDbAdapter = new OleDbDataAdapter();
/// <summary>
/// ет/дет де /
/// </summary>
/// <param name="quary"></param>
/// <returns></returns>
static public DataTable Get(string quary)
{
OleDbConn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=db.accdb;Persist Security Info=True";
// OleDbConn.ConnectionString = FormDialogMethods.ConnectionString;
OleDbComm.Connection = OleDbConn;
DataTable dt = new DataTable();
OleDbAdapter.SelectCommand = new OleDbCommand(quary, OleDbConn);
OleDbAdapter.Fill(dt);
try
{
OleDbConn.Open();
}
catch
{
OleDbConn.Close();
return dt;
}
OleDbConn.Close();
127
return dt;
}
}
1.2
public DataTable GetAllOrders()
{
return GetгrueDataгableGetгable.Get"вELECг [щ ].К, [щ
]., З., ., ., К.я, .А,
[щ
].Д FбOM [щ ], З, , , К, , [щ ]
LEFг JOIN З ON [щ ].З =З.К, [щ ] LEFг JOIN ON
[щ ].=.К, [щ ] LEFг JOIN ON [щ
].=.К, [щ ] LEFг JOIN К ON [щ
].К=К.К, [щ ] LEFг JOIN ON [щ ].=.К
"));
//return Getгable.Get"вELECг [щ ].К, [щ ].Д FбOM ";
}
1.3 ,
public Dataгable GetOrdersFromNumberstring number
{
return Getгable.Get"вELECг [щ ].К, [щ ].,
З., ., ., К.я, .А, [щ
].Д FбOM [щ ], З, , , К, , [щ ] LEFг
JOIN З ON [щ ].З =З.К, [щ ] LEFг JOIN ON [щ
].=.К, [щ ] LEFг JOIN ON [щ
].=.К, [щ ] LEFг JOIN К ON [щ
].К=К.К, [щ ] LEFг JOIN ON [щ ].=.К
WHEбE ='"+number+"' ";
//return Getгable.Get"вELECг [щ ].К, [щ ].Д FбOM ";
}
1.4
public Dataгable GetOrdersProduct
{
return Getгable.Get"вELECг [щ ].К, [щ ].,
З., ., К.я, .А, [щ ].Д FбOM [щ
], З, , К, , [щ ] LEFг JOIN З ON [щ
].З =З.К, [щ ] LEFг JOIN ON [щ ].=.К,
[щ ] LEFг JOIN К ON [щ ].К=К.К, [щ ] LEFг
JOIN ON [щ ].=.К WHEбE [щ ]. Iв NOг NдLL";
//return Getгable.Get"вELECг [щ ].К, [щ ].Д FбOM ";
}
1.5
public DataTable GetOrdersServices()
{
return Getгable.Get"вELECг [щ ].К, [щ ].,
З., ., К.я, .А, [щ ].Д FбOM [щ
], З, , К, , [щ ] LEFг JOIN З ON [щ
128
].З =З.К, [щ ] LEFг JOIN ON [щ
].=.К, [щ ] LEFг JOIN К ON [щ
].К=К.К, [щ ] LEFг JOI
N ON [щ ].=.К
WHEбE [щ ]. Iв NOг NдLL";
//return Getгable.Get"вELECг [щ ].К, [щ ].Д FбOM ";
}
1.6
public DataTable GetAllClient()
{
return Getгable.Get"вELECг * FбOM [ ]";
}
public Dataгable GetAllFilial
{
return Getгable.Get"вELECг * FбOM ";
}
public DataTable GetAllCard()
{
return Getгable.Get"вELECг * FбOM [Дя ]";
}
1.7 CoЦЛoЛoб’o
public int GetгypeClientFromNamestring type
{
Dataгable dt = Getгable.Get"вELECг * FбOM [ ] WHEбE
='"+type+"'";
return intdt.бows[0][0];
}
public int GetгypeFilialFromNamestring type
{
Dataгable dt = Getгable.Get"вELECг * FбOM [] WHEбE А='" + type +
"'";
return intdt.бows[0][0];
}
public int GetгypeOrderFromNamestring type
{
Dataгable dt = Getгable.Get"вELECг * FбOM [З] WHEбE ='" + type +
"'";
return intdt.бows[0][0];
}
public int GetгypeвpecFromNamestring type
{
Dataгable dt = Getгable.Get"вELECг * FбOM [ цц] WHEбE
='" + type + "'";
return intdt.бows[0][0];
}
public int GetгypeDiscontFromNamestring type
{
Dataгable dt = Getгable.Get"вELECг * FбOM [Дя ] WHEбE
='" + type + "'";
return intdt.бows[0][0];
}
public int GetгypeProductFromNamestring type
{
Dataгable dt = Getгable.Get"вELECг * FбOM [ ] WHEбE ='" +
129
type + "'";
return intdt.бows[0][0];
}
public int GetProviderFromNamestring type
{
Dataгable dt = Getгable.Get"вELECг * FбOM [щ] WHEбE ='" +
type + "'";
return intdt.бows[0][0];
}
1.8
public Dataгable вhowAllProductint filial
{
return Getгable.Get"вELECг
.К, ., [ ].,
щ., ., .Ц FбOM , [ ], щ,
LEFг JOIN [ ] ON .=[ ].К, LEFг JOIN щ ON
.щ=щ.К WHEбE .=" + filial;
}
1.9
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace photo
{
static class Program
{
/// <summary>
/// л точк од дл плое.
/// </summary>
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
130
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace photo
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
SqlWorker sqlWorker = new SqlWorker();
dgvMain.DataSource = sqlWorker.GetAllOrders();
}
private void btAdd_Click(object sender, EventArgs e)
{
fmAddClient form = new fmAddClient();
form.Show();
}
}
}
using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
namespace hospital
{
static class GetTable
{
static OleDbCommand OleDbComm = new OleDbCommand();
static OleDbConnection OleDbConn = new OleDbConnection();
static OleDbDataAdapter OleDbAdapter = new OleDbDataAdapter();
/// <summary>
/// ет/дет де /
/// </summary>
/// <param name="quary"></param>
/// <returns></returns>
static public DataTable Get(string quary)
{
131
OleDbConn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=db.accdb;Persist Security Info=True";
// OleDbConn.ConnectionString = FormDialogMethods.ConnectionString;
OleDbComm.Connection = OleDbConn;
DataTable dt = new DataTable();
OleDbAdapter.SelectCommand = new OleDbCommand(quary, OleDbConn);
OleDbAdapter.Fill(dt);
try
{
OleDbConn.Open();
}
catch
{
OleDbConn.Close();
return dt;
}
OleDbConn.Close();
return dt;
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace photo
{
public partial class fmAddClient : Form
{
public fmAddClient()
{
InitializeComponent();
}
private void fmAddClient_Load(object sender, EventArgs e)
{
SqlWorker sqlWorker = new SqlWorker();
DataTable dt = sqlWorker.GetAllCard();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbCard.Items.Add(dt.Rows[i][1]);
}
132
dt = sqlWorker.GetAllClient();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbClient.Items.Add(dt.Rows[i][1]);
}
dt = sqlWorker.GetAllFilial();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbFilial.Items.Add(dt.Rows[i][1]);
}
}
}
}
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using hospital;
namespace photo
{
class SqlWorker
{
public DataTable GetAllOrders()
{
return GetTable.Get"SйэйCT [Ощ к].Код, к.п, о.е,
лу.е, Клет.л, укт.де, [Ощ к].т нROM [Ощ к],
к, о, лу, Клет, укт, [Ощ к] эйнT JOIN к ON [Ощ к].к
=к.Код, [Ощ к] эйнT JOIN о ON [Ощ к].о=о.Код, [Ощ
к] эйнT JOIN лу ON [Ощ к].лу=лу.Код, [Ощ к] эйнT JOIN
Клет ON [Ощ к].Клет=Клет.Код, [Ощ к] эйнT JOIN укт ON [Ощ
к].лл=укт.Код ";
//return GetTable.Get"SйэйCT [Ощ к].Код, [Ощ к].т нROM ";
}
public DataTable GetAllClient()
{
return GetTable.Get"SйэйCT * нROM [п клет]";
}
public DataTable GetAllFilial()
{
return GetTable.Get"SйэйCT * нROM укт";
}
public DataTable GetAllCard()
{
return GetTable.Get"SйэйCT * нROM [кот кт]";
133
}
}
}
134
2
отщк
PK Код
е
FK1,I1 пел
кот кт
PK Код
е
кдк
укт
PK Код
де
ое телео
к
PK Код
FK2,I2 п
кдк
е
FK1,I1 лл
п к
PK Код
I1 п
п клет
PK Код
е
Кок
PK Код
де
ое телео
FK1,I1 лл
п пел
PK Код
е
п то
PK Код
е
Клет
PK Код
л
Отчето
FK2,I3 п
FK1,I2 лл
еол дк
о
PK Код
е
FK3,I3 п
FK1,I1 отщк
кдк
FK2,I2 лл
лу
PK Код
е
е
кдк
FK1,I1 лл
Ощ к
PK Код
FK1,I1 к
FK4,I4 о
FK5,I5 лу
FK2,I2 Клет
FK3,I3 лл
т
135
3
3.1 – « »
3.2 – «»
136