()
ͳ
(, , )
1. () 볺
2. ()
3. () 볺
4. - ( , ):
1. ERwin.
2. MS SQL Server 2014.
3. Visual Studio 2015.
5. ( ):
1.
2. Գ
3. MS SQL Server
5.
6.
: 볺 .
ʳ 볺, .
ERwin AllFusion 9.6. AllFusion Data Modeler . MS SQL Server 2014, 볺 MS VS14 C#.
, , .
30 , 21, 6, 4.
: ֲ , ²IJ, , ֲ, , , ERWin, SQL SERVER, VISUAL STUDIO.
̲
. 3
.. 5
1. ײ 7
2. ײ 10
3. ֲ .. 18
.. 29
ί ˲.. 30
() , , , , , , ', ' . ' ' ' :
, ;
, ;
.
, - , , . , , , . , , .
, , , . г , 볺 , . , , .
, , 볺 ,
볺, , .
' . , , , .
1.
볺, .
, .
, .
볺 , , , , , , , . 볺 , , / .
볺 :
볺
³
, , . MS SQL Server 2014, .
.
:
³ ( , , , , . , )
³ (ϲ, , , )
³ (, , , , , , , )
³ ( , , 䳿 )
³ ( , , , , , )
³ (, , )
³ (ϲ, , , )
³ - ( , , , , , , , )
:
/
2.
CASE ERWin. MS SQL Server . ERWin MS SQL Server (Tools Forward Engineer/Schema Generation). Generate SQL . ij SQL Connect. MS SQL Server .
:
Microsoft Visual Studio.
Windows Application Form, .
, , .
, .
ᒺ .
.
³ Microsoft Visual Studio 2015 , . (. )
, Wndows , .
private void ToolStripMenuItem_Click(object sender, EventArgs e)
{
Form3 N = new Form3();
N.ShowDialog();
}
, .
:
-. . ³ . , . dz , , , .
- Form6. (BindingNavigator) . , dipDataSet, _TableAdapter, _BindingSource _BindingNavigator.
_ _ - ComboBox , , . ComboBox .
_ DBGrid.
, _ ComboBox. _ DBGrid, , ComboBox, , .
, ,
. , TableAdapter :
SELECT _, ʳ, ֳ_, ʳ * ֳ_ AS , _, _, , _
FROM _
:
SELECT SUM(_.ʳ * _.ֳ_) AS _
FROM _ INNER JOIN
_ ON _._ = _._
GROUP BY _._, _._, _._, _._, _._, _.,
_._
HAVING (_. = '+') AND (_._ = @p)
, , , , :
private void _BindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this._BindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.dipDataSet);
this._TableAdapter.Fill(this.dipDataSet._);
_TextBox.Text = this._TableAdapter.Qur(Int32.Parse(this._TextBox.Text)).ToString();
this.Validate();
this._BindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.dipDataSet);
}
.
MS SQL Server (SqlException)
MS SQL Server (SqlException)
SqlException :
璺 ;
;
.
MS SQL Server. .
.
private void BindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this. BindingSource.EndEdit();
try
{
this.tableAdapterManager.UpdateAll(this.kreditDataSet);
}
catch (SqlException ex)
{
MessageBox.Show(": " + ex.Message, "");
}
}
, DataSet . TableAdapter.
, , , .
.
SELECT _._, _._, _._, _._, _._, .,
.Բ
FROM INNER JOIN
_ ON ._ = _._ INNER JOIN
ON _._ = ._
WHERE (. = @p)
ComboBox, , .
ComboBox 䒺 , , , .
private void button1_Click(object sender, EventArgs e)
{
this.dataTable1TableAdapter.Fill(this.dipDataSet.DataTable1, comboBox1.Text);
}
}
.
SELECT ., SUM(_.ʳ) AS [ ], SUM(_._) AS [ ]
FROM INNER JOIN
_ ON ._ = _._ INNER JOIN
_ ON _._ = _._ INNER JOIN
ON _._ = ._
GROUP BY ., _., _._
HAVING (_._ = '') AND (_. = '+')
SELECT .Բ AS , . AS , SUM(_._) AS [ ]
FROM _ INNER JOIN
ON _._ = ._ INNER JOIN
ON _._ = ._ INNER JOIN
ON _._ = ._
GROUP BY .Բ, ., _._
HAVING (_._ = '')
.
SELECT .Բ AS , . AS , SUM(_._) AS [ ]
FROM _ INNER JOIN
ON _._ = ._ INNER JOIN
ON _._ = ._ INNER JOIN
_ ON _._ = _._
GROUP BY .Բ, ., _._
HAVING (_._ = '')
Գ , , .
this._BindingSource.Filter = ("_=''");
, , - .
this._BindingSource.Filter = ("_=''");
this._BindingSource.Filter = ("='+'");
, , - , - , , - +.
. radiobutton, . :
private void button1_Click(object sender, EventArgs e)
{
if (radioButton2.Checked)
{
int itemFound = this._BindingSource.Find("_",textBox1.Text);
this._BindingSource.Position = itemFound;
}
else
{
if (radioButton1.Checked)
{
int itemFound = this._BindingSource.Find("_", textBox1.Text);
this._BindingSource.Position = itemFound;
}
}
}
Microsoft Visual Studio 2015 , Windows Forms ASP.NET AJAX. , , . ReportViewer .
ReportProject, 䒺 .
3.
ϳ (. 3.1). . : , , , , .
. 3.1
(. 3.2):
. 3.2
, . ϳ (. 3.3), . ϳ , (. 3.4).
. 3.3
. 3.4 .
ϳ , (. 3.5).
. 3.5 .
// , 䳿, , , .
. 3.6 .
. 3.7 .
. 3.8 .
. 3.9 .
. 3.10 .
. 3.11 ⳻ .
. 3.12 ͻ ͻ.
. 3.13
:
. 3.14
, , .
. 3.15
, , , .
. 3.16
, , , , .
. 3.17
, .
. 3.18
(. 3.18). . , , .
. 3.18
. 3.19 , , ϲ , .
. 3.20 , .
. 3.21 , .
볺 .
ERwin AllFusion 9.6. Microsoft Visual Studio 2015.
. , .
, , , , .
Microsoft Visual Studio 2015 C#.
1. .. BPwin ERwin. CASE - .: -, 2000
2. 6.050101 / . .. ̒ .: , 2011.
3. ̒ .. : . 7.080401 0804 . . .: , 2006 67.
4. . . . 6.050101 㳿 0605 2 ( 볺 )/ .: .. ̒, .. .: , 2014 30 .
.......................................................................... 2
Գ ....................................................................... 3
MS SQL Server 2014................................................. 4
........................................................... 5
Գ
MS SQL Server 2014