<
br
>
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage_Menu.master" AutoEventWireup="true" CodeFile="Coding.aspx.cs" Inherits="Coding" %><
br
>
<
br
>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"nestedContent"
Runat
=
"Server"
><
br
>
<
br
>
<
br
>
<
form
id
=
"form1"
runat
=
"server"
><
br
>
<
div
style
=
"min-height:600px"
><
br
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
><
br
>
<
Scripts
><
br
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/><
br
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/><
br
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
/><
br
>
</
Scripts
><
br
>
</
telerik:RadScriptManager
><
br
>
<
telerik:RadGrid
ID
=
"RadGrid1"
ShowStatusBar
=
"True"
<br>
AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True"<
br
>
DataSourceID="SqlDataSource1" runat="server" AutoGenerateColumns="False" PageSize="15"<
br
>
AllowSorting="True" AllowMultiRowSelection="True" AllowPaging="True" <
br
>
OnItemUpdated="RadGrid1_ItemUpdated" OnItemDeleted="RadGrid1_ItemDeleted"<
br
>
OnItemInserted="RadGrid1_ItemInserted" OnInsertCommand="RadGrid1_InsertCommand" <
br
>
Height="95px" onupdatecommand="RadGrid1_UpdateCommand" <
br
>
><
br
>
<
PagerStyle
Mode
=
"NumericPages"
></
PagerStyle
><
br
>
<
MasterTableView
DataSourceID
=
"SqlDataSource1"
Font-Names
=
"Tahoma"
DataKeyNames
=
"GroupHesabId"
CommandItemDisplay
=
"Top"
<br>
Name="GroupHesab" AllowMultiColumnSorting="True" ExpandCollapseColumn-Display="true" Dir ="RTL" ItemStyle-BackColor="#00CCFF" AlternatingItemStyle-BackColor="#00CCFF"<
br
>
RowIndicatorColumn-Display="false" AllowAutomaticUpdates="True" EditMode ="PopUp" ><
br
>
<
DetailTables
><
br
>
<
telerik:GridTableView
Caption
=
"جدول گروه حسابها"
Name
=
"Kol"
DataKeyNames
=
"KolId"
EditMode
=
"InPlace"
ItemStyle-BackColor
=
"Yellow"
AlternatingItemStyle-BackColor
=
"Yellow"
<br>
runat="server" CommandItemDisplay="Top" Font-Names="Tahoma" DataSourceID="SqlDataSource2" EditItemStyle-HorizontalAlign="Right"><
br
>
<
ParentTableRelation
><
br
>
<
telerik:GridRelationFields
DetailKeyField
=
"GroupHesabId"
MasterKeyField
=
"GroupHesabId"
></
telerik:GridRelationFields
><
br
>
</
ParentTableRelation
><
br
>
<
DetailTables
><
br
>
<
telerik:GridTableView
Caption
=
""
Name
=
"Moien"
DataKeyNames
=
"MoeinId"
EditMode
=
"PopUp"
Font-Names
=
"Tahoma"
ItemStyle-BackColor
=
"#80E680"
AlternatingItemStyle-BackColor
=
"#80E680"
<br>
runat="server" CommandItemDisplay="Top" DataSourceID="SqlDataSource3" Dir="RTL" EditItemStyle-HorizontalAlign="Right"><
br
>
<
ParentTableRelation
><
br
>
<
telerik:GridRelationFields
DetailKeyField
=
"KolId"
MasterKeyField
=
"KolId"
></
telerik:GridRelationFields
><
br
>
</
ParentTableRelation
><
br
>
<
DetailTables
><
br
>
<
telerik:GridTableView
Name
=
"TafsiliGroupMoien"
DataKeyNames
=
"TafsiliGroupMoienId"
EditMode
=
"PopUp"
Font-Names
=
"Tahoma"
ItemStyle-BackColor
=
"#80E680"
AlternatingItemStyle-BackColor
=
"#80E680"
<br>
runat="server" AutoGenerateColumns="false" CommandItemDisplay="Top" DataSourceID="TafsiliGroupMoienSqlDataSource" Dir="RTL" EditItemStyle-HorizontalAlign="Right"><
br
>
<
ParentTableRelation
><
br
>
<
telerik:GridRelationFields
DetailKeyField
=
"MoienId"
MasterKeyField
=
"MoienId"
></
telerik:GridRelationFields
><
br
>
</
ParentTableRelation
><
br
>
<
br
>
<
Columns
><
br
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumnTafsiliGroup"
><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
</
telerik:GridEditCommandColumn
><
br
>
<
br
>
<
telerik:GridTemplateColumn
HeaderText
=
"گروه تفصیلی"
ItemStyle-Width
=
"240px"
><
br
>
<
ItemTemplate
><
br
>
<%#DataBinder.Eval(Container.DataItem, "TafsiliGroupName")%><
br
>
</
ItemTemplate
><
br
>
<
EditItemTemplate
><
br
>
<
telerik:RadComboBox
runat
=
"server"
ID
=
"RadComboBox6"
DataTextField
=
"TafsiliGroupName"
<br>
DataValueField="TafsiliGroupId" DataSourceID="TafsiliGroupDataSource" SelectedValue='<%#Bind("TafsiliGroupId") %>' ><
br
>
</
telerik:RadComboBox
><
br
>
</
EditItemTemplate
><
br
>
<
br
>
<
ItemStyle
Width
=
"240px"
></
ItemStyle
><
br
>
</
telerik:GridTemplateColumn
><
br
>
<
br
>
<
telerik:GridButtonColumn
ConfirmText
=
"آیا این گروه تفصیلی حذف گردد؟"
ButtonType
=
"ImageButton"
<br>
CommandName="Delete" Text="Delete" UniqueName="DeleteColumn4"><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
CssClass
=
"MyImageButton"
></
ItemStyle
><
br
>
</
telerik:GridButtonColumn
><
br
>
</
Columns
><
br
>
<
EditFormSettings
><
br
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
><
br
>
</
EditFormSettings
><
br
>
<
br
>
<
ItemStyle
BackColor
=
"#80E680"
></
ItemStyle
><
br
>
<
br
>
<
AlternatingItemStyle
BackColor
=
"#80E680"
></
AlternatingItemStyle
><
br
>
<
br
>
<
EditItemStyle
HorizontalAlign
=
"Right"
></
EditItemStyle
><
br
>
<
br
>
<
PagerStyle
PageSizeControlType
=
"RadComboBox"
></
PagerStyle
><
br
>
<
br
>
</
telerik:GridTableView
><
br
>
</
DetailTables
><
br
>
<
br
>
<
Columns
><
br
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumn"
><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
</
telerik:GridEditCommandColumn
><
br
>
<
br
>
<
telerik:GridBoundColumn
SortExpression
=
"MoienNum"
ItemStyle-HorizontalAlign
=
"Right"
HeaderText
=
"کد معین"
HeaderButtonType
=
"TextButton"
<br>
DataField="MoienNum" UniqueName="MoienNum" HeaderStyle-Font-Bold="true" ItemStyle-Width="50"><
br
>
<
HeaderStyle
Font-Bold
=
"True"
></
HeaderStyle
><
br
>
<
br
>
<
ItemStyle
HorizontalAlign
=
"Right"
Width
=
"50px"
></
ItemStyle
><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
SortExpression
=
"MoienName"
HeaderStyle-Font-Bold
=
"true"
ItemStyle-HorizontalAlign
=
"Right"
HeaderText
=
"نام معین"
HeaderButtonType
=
"TextButton"
<br>
DataField="MoienName" UniqueName="MoienName"><
br
>
<
HeaderStyle
Font-Bold
=
"True"
></
HeaderStyle
><
br
>
<
br
>
<
ItemStyle
HorizontalAlign
=
"Right"
></
ItemStyle
><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridTemplateColumn
HeaderText
=
"ماهیت حساب معین"
ItemStyle-Width
=
"240px"
><
br
>
<
ItemTemplate
><
br
>
<%#DataBinder.Eval(Container.DataItem, "MahiyatMoinName")%><
br
>
</
ItemTemplate
><
br
>
<
EditItemTemplate
><
br
>
<
telerik:RadComboBox
runat
=
"server"
ID
=
"RadComboBox2"
DataTextField
=
"MahiyatMoinName"
<br>
DataValueField="MahiyatMoinID" DataSourceID="MahiyatMoienDataSource" SelectedValue='<%#Bind("MahiyatMoinID") %>' ><
br
>
</
telerik:RadComboBox
><
br
>
</
EditItemTemplate
><
br
>
<
br
>
<
ItemStyle
Width
=
"240px"
></
ItemStyle
><
br
>
</
telerik:GridTemplateColumn
><
br
>
<
br
>
<
telerik:GridButtonColumn
ConfirmText
=
"آیا این حساب معین حذف گردد؟"
ButtonType
=
"ImageButton"
<br>
CommandName="Delete" Text="Delete" UniqueName="DeleteColumn2"><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
CssClass
=
"MyImageButton"
></
ItemStyle
><
br
>
</
telerik:GridButtonColumn
><
br
>
<
br
>
</
Columns
><
br
>
<
br
>
<
EditFormSettings
><
br
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
><
br
>
</
EditFormSettings
><
br
>
<
br
>
<
ItemStyle
BackColor
=
"#80E680"
></
ItemStyle
><
br
>
<
br
>
<
AlternatingItemStyle
BackColor
=
"#80E680"
></
AlternatingItemStyle
><
br
>
<
br
>
<
EditItemStyle
HorizontalAlign
=
"Right"
></
EditItemStyle
><
br
>
<
br
>
<
PagerStyle
PageSizeControlType
=
"RadComboBox"
></
PagerStyle
><
br
>
</
telerik:GridTableView
><
br
>
</
DetailTables
><
br
>
<
br
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
><
br
>
<
br
>
<
RowIndicatorColumn
FilterControlAltText
=
"Filter RowIndicator column"
></
RowIndicatorColumn
><
br
>
<
br
>
<
ExpandCollapseColumn
Visible
=
"True"
Created
=
"True"
FilterControlAltText
=
"Filter ExpandColumn column"
></
ExpandCollapseColumn
><
br
>
<
Columns
><
br
>
<
br
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumn"
><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
<
ItemStyle
CssClass
=
"MyImageButton"
></
ItemStyle
><
br
>
</
telerik:GridEditCommandColumn
><
br
>
<
br
>
<
telerik:GridBoundColumn
ItemStyle-HorizontalAlign
=
"Right"
SortExpression
=
"KolNum"
HeaderStyle-Font-Bold
=
"true"
HeaderText
=
"کد حساب کل"
HeaderButtonType
=
"TextButton"
ItemStyle-Width
=
"50"
<br>
DataField="KolNum" UniqueName="KolNum"><
br
>
<
HeaderStyle
Font-Bold
=
"True"
></
HeaderStyle
><
br
>
<
br
>
<
ItemStyle
HorizontalAlign
=
"Right"
Width
=
"50px"
></
ItemStyle
><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
SortExpression
=
"KolName"
HeaderText
=
"نام حساب کل"
HeaderStyle-Font-Bold
=
"true"
HeaderButtonType
=
"TextButton"
<br>
DataField="KolName" UniqueName="KolName"><
br
>
<
br
>
<
HeaderStyle
Font-Bold
=
"True"
></
HeaderStyle
><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridTemplateColumn
HeaderText
=
"ماهیت حساب کل"
ItemStyle-Width
=
"240px"
><
br
>
<
ItemTemplate
><
br
>
<%#DataBinder.Eval(Container.DataItem, "MahiyatKolName")%><
br
>
</
ItemTemplate
><
br
>
<
EditItemTemplate
><
br
>
<
telerik:RadComboBox
runat
=
"server"
ID
=
"RadComboBox2"
DataTextField
=
"MahiyatKolName"
<br>
DataValueField="MahiyatKolId" DataSourceID="MahiyatKolDataSource" SelectedValue='<%#Bind("MahiyatKolId") %>' ><
br
>
</
telerik:RadComboBox
><
br
>
</
EditItemTemplate
><
br
>
<
br
>
<
ItemStyle
Width
=
"240px"
></
ItemStyle
><
br
>
</
telerik:GridTemplateColumn
><
br
>
<
telerik:GridButtonColumn
ConfirmText
=
"آیا این حساب کل حذف گردد؟"
ButtonType
=
"ImageButton"
<br>
CommandName="Delete" Text="Delete" UniqueName="DeleteColumn3"><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
CssClass
=
"MyImageButton"
></
ItemStyle
><
br
>
</
telerik:GridButtonColumn
><
br
>
</
Columns
><
br
>
<
br
>
<
EditFormSettings
><
br
>
<
EditColumn
UniqueName
=
"EditCommandColumn"
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
><
br
>
</
EditFormSettings
><
br
>
<
br
>
<
ItemStyle
BackColor
=
"Yellow"
></
ItemStyle
><
br
>
<
br
>
<
AlternatingItemStyle
BackColor
=
"Yellow"
></
AlternatingItemStyle
><
br
>
<
br
>
<
EditItemStyle
HorizontalAlign
=
"Right"
></
EditItemStyle
><
br
>
<
br
>
<
PagerStyle
PageSizeControlType
=
"RadComboBox"
></
PagerStyle
><
br
>
</
telerik:GridTableView
><
br
>
</
DetailTables
><
br
>
<
br
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
><
br
>
<
br
>
<
RowIndicatorColumn
Display
=
"False"
FilterControlAltText
=
"Filter RowIndicator column"
></
RowIndicatorColumn
><
br
>
<
br
>
<
ExpandCollapseColumn
Visible
=
"True"
FilterControlAltText
=
"Filter ExpandColumn column"
Created
=
"True"
></
ExpandCollapseColumn
><
br
>
<
Columns
><
br
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumn"
><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
<
ItemStyle
CssClass
=
"MyImageButton"
></
ItemStyle
><
br
>
</
telerik:GridEditCommandColumn
><
br
>
<
br
>
<
telerik:GridBoundColumn
SortExpression
=
"GroupHsabNum"
HeaderText
=
"کد گروه حساب"
HeaderStyle-Font-Bold
=
"true"
HeaderButtonType
=
"TextButton"
ItemStyle-Width
=
"50"
<br>
DataField="GroupHsabNum" UniqueName="GroupHsabNum"><
br
>
<
HeaderStyle
Font-Bold
=
"True"
></
HeaderStyle
><
br
>
<
br
>
<
ItemStyle
Width
=
"50px"
></
ItemStyle
><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
SortExpression
=
"GroupHesabName"
HeaderText
=
"نام گروه حساب"
HeaderStyle-Font-Bold
=
"true"
HeaderButtonType
=
"TextButton"
<br>
DataField="GroupHesabName" UniqueName="GroupHesabName"><
br
>
<
HeaderStyle
Font-Bold
=
"True"
></
HeaderStyle
><
br
>
</
telerik:GridBoundColumn
><
br
>
<
br
>
<
telerik:GridTemplateColumn
HeaderText
=
"نوع گروه حساب"
ItemStyle-Width
=
"240px"
><
br
>
<
ItemTemplate
><
br
>
<%#DataBinder.Eval(Container.DataItem, "TypeOfGroupHesabName")%><
br
>
</
ItemTemplate
><
br
>
<
EditItemTemplate
><
br
>
<
telerik:RadComboBox
runat
=
"server"
ID
=
"RadComboBox2"
DataTextField
=
"TypeOfGroupHesabName"
<br>
DataValueField="TypeOfGroupHesabId" DataSourceID="TypeHesabDataSource" SelectedValue='<%#Bind("TypeOfHesabId") %>' ><
br
>
</
telerik:RadComboBox
><
br
>
</
EditItemTemplate
><
br
>
<
br
>
<
ItemStyle
Width
=
"240px"
></
ItemStyle
><
br
>
</
telerik:GridTemplateColumn
><
br
>
<
br
>
<
br
>
<
br
>
<
telerik:GridButtonColumn
ConfirmText
=
"آیا این گروه حساب حذف گردد؟"
ButtonType
=
"ImageButton"
<br>
CommandName="Delete" Text="Delete" UniqueName="DeleteColumn4"><
br
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
CssClass
=
"MyImageButton"
></
ItemStyle
><
br
>
</
telerik:GridButtonColumn
><
br
>
</
Columns
><
br
>
<
br
>
<
EditFormSettings
><
br
>
<
EditColumn
UniqueName
=
"EditCommandColumn"
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
><
br
>
</
EditFormSettings
><
br
>
<
br
>
<
ItemStyle
BackColor
=
"#00CCFF"
></
ItemStyle
><
br
>
<
br
>
<
AlternatingItemStyle
BackColor
=
"#00CCFF"
></
AlternatingItemStyle
><
br
>
<
br
>
<
PagerStyle
PageSizeControlType
=
"RadComboBox"
></
PagerStyle
><
br
>
<
br
>
</
MasterTableView
><
br
>
<
br
>
<
ClientSettings
Selecting-AllowRowSelect
=
"true"
><
br
>
<
Selecting
AllowRowSelect
=
"True"
></
Selecting
> <
br
>
</
ClientSettings
><
br
>
<
br
>
<
FilterMenu
EnableImageSprites
=
"False"
></
FilterMenu
><
br
>
</
telerik:RadGrid
><
br
>
<
asp:SqlDataSource
ID
=
"TypeHesabDataSource"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT TypeOfGroupHesabId,TypeOfGroupHesabName FROM TypeOfGroupHesab" <
br
>
runat="server"><
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"MahiyatKolDataSource"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM MahiyatKol" <
br
>
runat="server"><
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"MahiyatMoienDataSource"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM MahiyatMoien" <
br
>
runat="server"><
br
>
</
asp:SqlDataSource
> <
br
>
<
asp:SqlDataSource
ID
=
"TafsiliGroupDataSource"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM TafsiliGroup" <
br
>
runat="server"><
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"TafsiliGroupMoienSqlDataSource"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM TafsiliGroupMoien tgm inner join TafsiliGroup tg on tgm.TafsiliGroupId=tg.TafsiliGroupId where MoienId=@MoienId"<
br
>
InsertCommand="INSERT INTO TafsiliGroupMoien(MoienId,TafsiliGroupId) VALUES (@MoienId,@TafsiliGroupId)"<
br
>
DeleteCommand="Delete from TafsiliGroupMoien where TafsiliGroupMoienId=@TafsiliGroupMoienId"<
br
>
UpdateCommand ="Update TafsiliGroupMoien Set MoienId=@MoienId ,TafsiliGroupId=@TafsiliGroupId where TafsiliGroupMoienId=@TafsiliGroupMoienId"<
br
>
runat="server"> <
br
>
<
UpdateParameters
><
br
>
<
br
>
<
asp:Parameter
Name
=
"MoienId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"TafsiliGroupId"
Type
=
"Int16"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"TafsiliGroupMoienId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
</
UpdateParameters
><
br
>
<
DeleteParameters
><
br
>
<
asp:Parameter
Name
=
"TafsiliGroupMoienId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
</
DeleteParameters
><
br
>
<
InsertParameters
><
br
>
<
asp:Parameter
Name
=
"MoienId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"TafsiliGroupId"
Type
=
"Int16"
></
asp:Parameter
><
br
>
<
br
>
</
InsertParameters
><
br
>
<
SelectParameters
> <
br
>
<
asp:SessionParameter
Name
=
"MoienId"
SessionField
=
"MoienId"
Type
=
"string"
></
asp:SessionParameter
><
br
>
</
SelectParameters
><
br
>
<
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM GroupHesab g inner join TypeOfGroupHesab t on t.TypeOfGroupHesabId=g.TypeOfHesabId"<
br
>
InsertCommand="INSERT INTO GroupHesab(GroupHesabName,GroupHsabNum,TypeOfHesabId) VALUES (@GroupHesabName,@GroupHsabNum,@TypeOfHesabId)"<
br
>
DeleteCommand="Delete from GroupHesab where GroupHesabId=@GroupHesabId"<
br
>
UpdateCommand ="Update GroupHesab Set GroupHesabName=@GroupHesabName ,GroupHsabNum=@GroupHsabNum,TypeOfHesabId=@TypeOfHesabId where GroupHesabId=@GroupHesabId"<
br
>
runat="server"><
br
>
<
UpdateParameters
><
br
>
<
asp:Parameter
Name
=
"GroupHesabId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"GroupHesabName"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"GroupHsabNum"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"TypeOfHesabId"
Type
=
"Int16"
></
asp:Parameter
><
br
>
</
UpdateParameters
><
br
>
<
DeleteParameters
><
br
>
<
asp:Parameter
Name
=
"GroupHesabId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
</
DeleteParameters
><
br
>
<
InsertParameters
><
br
>
<
asp:Parameter
Name
=
"GroupHesabName"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"GroupHsabNum"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"TypeOfHesabId"
Type
=
"Int16"
></
asp:Parameter
><
br
>
<
br
>
</
InsertParameters
><
br
>
<
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"SqlDataSource2"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM Kol k LEFT OUTER JOIN MahiyatKol m on k.MahiyatKolID=m.MahiyatKolID Where GroupHesabId = @GroupHesabId"<
br
>
InsertCommand="INSERT INTO Kol(KolName,KolNum,GroupHesabId,MahiyatKolID) VALUES (@KolName,@KolNum,@GroupHesabId,@MahiyatKolID)"<
br
>
DeleteCommand="Delete from Kol where KolId=@KolId"<
br
>
UpdateCommand ="Update Kol Set KolName=@KolName ,KolNum=@KolNum,GroupHesabId=@GroupHesabId,MahiyatKolID=@MahiyatKolID where KolId=@KolId"<
br
>
<
br
>
runat="server"><
br
>
<
UpdateParameters
><
br
>
<
asp:Parameter
Name
=
"KolName"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"KolNum"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"GroupHesabId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"MahiyatKolID"
Type
=
"Int16"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"KolId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
</
UpdateParameters
><
br
>
<
DeleteParameters
><
br
>
<
asp:Parameter
Name
=
"KolId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
</
DeleteParameters
><
br
>
<
InsertParameters
><
br
>
<
asp:Parameter
Name
=
"KolName"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"KolNum"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"GroupHesabId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"MahiyatKolID"
Type
=
"Int16"
></
asp:Parameter
><
br
>
<
br
>
</
InsertParameters
><
br
>
<
SelectParameters
> <
br
>
<
asp:SessionParameter
Name
=
"GroupHesabId"
SessionField
=
"GroupHesabId"
Type
=
"string"
></
asp:SessionParameter
><
br
>
</
SelectParameters
> <
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"SqlDataSource3"
ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>"<
br
>
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Moien] m LEFT OUTER JOIN MahiyatMoien mh on m.MahiyatMoinID=mh.MahiyatMoinID where KolId = @KolId"<
br
>
InsertCommand="INSERT INTO Moien(MoienName,MoienNum,KolId,MahiyatMoinId) VALUES (@MoienName,@MoienNum,@KolId,@MahiyatMoinId)"<
br
>
DeleteCommand="Delete from Moien where MoeinId=@MoeinId"<
br
>
UpdateCommand ="Update Moien Set MoienName=@MoienName ,MoienNum=@MoienNum,KolId=@KolId,MahiyatMoinId=@MahiyatMoinId where MoeinId=@MoeinId"<
br
>
runat="server"><
br
>
<
UpdateParameters
><
br
>
<
asp:Parameter
Name
=
"MoienName"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"MoienNum"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"KolId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"MahiyatMoinId"
Type
=
"Int16"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"MoeinId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
</
UpdateParameters
><
br
>
<
DeleteParameters
><
br
>
<
asp:Parameter
Name
=
"MoeinId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
</
DeleteParameters
><
br
>
<
InsertParameters
><
br
>
<
asp:Parameter
Name
=
"MahiyatMoinId"
Type
=
"Int16"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"MoienName"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"MoienNum"
Type
=
"String"
></
asp:Parameter
><
br
>
<
asp:Parameter
Name
=
"KolId"
Type
=
"Int32"
></
asp:Parameter
><
br
>
<
br
>
</
InsertParameters
><
br
>
<
SelectParameters
><
br
>
<
asp:SessionParameter
Name
=
"KolId"
SessionField
=
"KolId"
Type
=
"Int32"
></
asp:SessionParameter
><
br
>
</
SelectParameters
><
br
>
</
asp:SqlDataSource
><
br
>
</
div
><
br
>
</
form
><
br
>
</
asp:Content
><
br
>