Каталог Рефератов - Разработка информационной системы ОВД г. Донецка

	Информационно-образоательный портал
	Рефераты, курсовые, дипломы, научные работы,



МЕНЮ\|

поиск

Разработка информационной системы ОВД г. Донецка

this.textBoxNetName.Size = new System.Drawing.Size(152, 20);

this.textBoxNetName.TabIndex = 11;

this.textBoxNetName.Text = "";

// comboBoxJobRole

this.comboBoxJobRole.Location = new System.Drawing.Point(304, 184);

this.comboBoxJobRole.Name = "comboBoxJobRole";

this.comboBoxJobRole.Size = new System.Drawing.Size(152, 21);

this.comboBoxJobRole.TabIndex = 12;

this.comboBoxStatus.Location = new System.Drawing.Point(304, 208);

this.comboBoxStatus.Name = "comboBoxStatus";

this.comboBoxStatus.Size = new System.Drawing.Size(152, 21);

this.comboBoxStatus.TabIndex = 13;

// comboBoxAccess

this.comboBoxAccess.Items.AddRange(new object[] {

"инженер",

"начальник тыла",

"начальник ГАИ",

"оператор",

"начальник милиции"});

this.comboBoxAccess.Location = new System.Drawing.Point(304, 232);

this.comboBoxAccess.Name = "comboBoxAccess";

this.comboBoxAccess.Size = new System.Drawing.Size(152, 21);

this.comboBoxAccess.TabIndex = 14;

// sqlSelectCommand1

this.sqlSelectCommand1.CommandText = "SELECT EmployeeID, JobRoleID, EmployeeSurname, EmployeeName, EmployeePatronymic, " +

"EmployeeStatus, Access, NetName FROM dbo.Employee";

this.sqlSelectCommand1.Connection = this.sqlConnection1;

// sqlConnection1

this.sqlConnection1.ConnectionString = "workstation id=\"608-24\";packet size=4096;integrated security=SSPI;data source=\"60" +

"8-24\\MS608_24\";persist security info=False;initial catalog=DOL";

// sqlInsertCommand1

this.sqlInsertCommand1.CommandText = @"INSERT INTO dbo.Employee(EmployeeID, JobRoleID, EmployeeSurname, EmployeeName, EmployeePatronymic, EmployeeStatus, Access, NetName) VALUES (@EmployeeID, @JobRoleID, @EmployeeSurname, @EmployeeName, @EmployeePatronymic, @EmployeeStatus, @Access, @NetName); SELECT EmployeeID, JobRoleID, EmployeeSurname, EmployeeName, EmployeePatronymic, EmployeeStatus, Access, NetName FROM dbo.Employee WHERE (EmployeeID = @EmployeeID)";

this.sqlInsertCommand1.Connection = this.sqlConnection1;

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeID", System.Data.SqlDbType.TinyInt, 1, "EmployeeID"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@JobRoleID", System.Data.SqlDbType.TinyInt, 1, "JobRoleID"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeSurname", System.Data.SqlDbType.VarChar, 20, "EmployeeSurname"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeName", System.Data.SqlDbType.VarChar, 20, "EmployeeName"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeePatronymic", System.Data.SqlDbType.VarChar, 20, "EmployeePatronymic"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeStatus", System.Data.SqlDbType.Int, 4, "EmployeeStatus"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Access", System.Data.SqlDbType.NVarChar, 20, "Access"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NetName", System.Data.SqlDbType.VarChar, 20, "NetName"));

// sqlUpdateCommand1

this.sqlUpdateCommand1.CommandText = @"UPDATE dbo.Employee SET JobRoleID = @JobRoleID, EmployeeSurname = @EmployeeSurname, EmployeeName = @EmployeeName, EmployeePatronymic = @EmployeePatronymic, EmployeeStatus = @EmployeeStatus, Access = @Access, NetName = @NetName WHERE (EmployeeID = @Original_EmployeeID) AND (Access = @Original_Access OR @Original_Access IS NULL AND Access IS NULL) AND (EmployeeName = @Original_EmployeeName) AND (EmployeePatronymic = @Original_EmployeePatronymic) AND (EmployeeStatus = @Original_EmployeeStatus OR @Original_EmployeeStatus IS NULL AND EmployeeStatus IS NULL) AND (EmployeeSurname = @Original_EmployeeSurname) AND (JobRoleID = @Original_JobRoleID) AND (NetName = @Original_NetName OR @Original_NetName IS NULL AND NetName IS NULL); SELECT EmployeeID, JobRoleID, EmployeeSurname, EmployeeName, EmployeePatronymic, EmployeeStatus, Access, NetName FROM dbo.Employee WHERE (EmployeeID = @EmployeeID)";

this.sqlUpdateCommand1.Connection = this.sqlConnection1;

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@JobRoleID", System.Data.SqlDbType.TinyInt, 1, "JobRoleID"));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeSurname", System.Data.SqlDbType.VarChar, 20, "EmployeeSurname"));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeName", System.Data.SqlDbType.VarChar, 20, "EmployeeName"));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeePatronymic", System.Data.SqlDbType.VarChar, 20, "EmployeePatronymic"));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeStatus", System.Data.SqlDbType.Int, 4, "EmployeeStatus"));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Access", System.Data.SqlDbType.NVarChar, 20, "Access"));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NetName", System.Data.SqlDbType.VarChar, 20, "NetName"));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeID", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeID", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Access", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Access", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeName", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeePatronymic", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeePatronymic", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeStatus", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeStatus", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeSurname", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeSurname", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_JobRoleID", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "JobRoleID", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_NetName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NetName", System.Data.DataRowVersion.Original, null));

this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EmployeeID", System.Data.SqlDbType.TinyInt, 1, "EmployeeID"));

// sqlDeleteCommand1

this.sqlDeleteCommand1.CommandText = @"DELETE FROM dbo.Employee WHERE (EmployeeID = @Original_EmployeeID) AND (Access = @Original_Access OR @Original_Access IS NULL AND Access IS NULL) AND (EmployeeName = @Original_EmployeeName) AND (EmployeePatronymic = @Original_EmployeePatronymic) AND (EmployeeStatus = @Original_EmployeeStatus OR @Original_EmployeeStatus IS NULL AND EmployeeStatus IS NULL) AND (EmployeeSurname = @Original_EmployeeSurname) AND (JobRoleID = @Original_JobRoleID) AND (NetName = @Original_NetName OR @Original_NetName IS NULL AND NetName IS NULL)";

this.sqlDeleteCommand1.Connection = this.sqlConnection1;

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeID", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeID", System.Data.DataRowVersion.Original, null));

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Access", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Access", System.Data.DataRowVersion.Original, null));

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeName", System.Data.DataRowVersion.Original, null));

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeePatronymic", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeePatronymic", System.Data.DataRowVersion.Original, null));

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeStatus", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeStatus", System.Data.DataRowVersion.Original, null));

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EmployeeSurname", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EmployeeSurname", System.Data.DataRowVersion.Original, null));

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_JobRoleID", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "JobRoleID", System.Data.DataRowVersion.Original, null));

this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_NetName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NetName", System.Data.DataRowVersion.Original, null));

// sqlDataAdapterEmployee

this.sqlDataAdapterEmployee.DeleteCommand = this.sqlDeleteCommand1;

this.sqlDataAdapterEmployee.InsertCommand = this.sqlInsertCommand1;

this.sqlDataAdapterEmployee.SelectCommand = this.sqlSelectCommand1;

this.sqlDataAdapterEmployee.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "Employee", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("EmployeeID", "EmployeeID"),

new System.Data.Common.DataColumnMapping("JobRoleID", "JobRoleID"),

new System.Data.Common.DataColumnMapping("EmployeeSurname", "EmployeeSurname"),

new System.Data.Common.DataColumnMapping("EmployeeName", "EmployeeName"),

new System.Data.Common.DataColumnMapping("EmployeePatronymic", "EmployeePatronymic"),

new System.Data.Common.DataColumnMapping("EmployeeStatus", "EmployeeStatus"),

new System.Data.Common.DataColumnMapping("Access", "Access"),

new System.Data.Common.DataColumnMapping("NetName", "NetName")})});

this.sqlDataAdapterEmployee.UpdateCommand = this.sqlUpdateCommand1;

// sqlSelectCommand2

this.sqlSelectCommand2.CommandText = "SELECT JobRoleID, JobRoleName FROM dbo.[Job Title]";

this.sqlSelectCommand2.Connection = this.sqlConnection1;

// sqlInsertCommand2

this.sqlInsertCommand2.CommandText = "INSERT INTO dbo.[Job Title] (JobRoleID, JobRoleName) VALUES (@JobRoleID, @JobRole" +

"Name); SELECT JobRoleID, JobRoleName FROM dbo.[Job Title] WHERE (JobRoleID = @Jo" +

"bRoleID)";

this.sqlInsertCommand2.Connection = this.sqlConnection1;

this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@JobRoleID", System.Data.SqlDbType.TinyInt, 1, "JobRoleID"));

this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@JobRoleName", System.Data.SqlDbType.NVarChar, 50, "JobRoleName"));

// sqlUpdateCommand2

this.sqlUpdateCommand2.CommandText = @"UPDATE dbo.[Job Title] SET JobRoleID = @JobRoleID, JobRoleName = @JobRoleName WHERE (JobRoleID = @Original_JobRoleID) AND (JobRoleName = @Original_JobRoleName OR @Original_JobRoleName IS NULL AND JobRoleName IS NULL); SELECT JobRoleID, JobRoleName FROM dbo.[Job Title] WHERE (JobRoleID = @JobRoleID)";

this.sqlUpdateCommand2.Connection = this.sqlConnection1;

this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@JobRoleID", System.Data.SqlDbType.TinyInt, 1, "JobRoleID"));

this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@JobRoleName", System.Data.SqlDbType.NVarChar, 50, "JobRoleName"));

this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_JobRoleID", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "JobRoleID", System.Data.DataRowVersion.Original, null));

Страницы: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

© 2003-2013
Рефераты бесплатно, курсовые, рефераты биология, большая бибилиотека рефератов, дипломы, научные работы, рефераты право, рефераты, рефераты скачать, рефераты литература, курсовые работы, реферат, доклады, рефераты медицина, рефераты на тему, сочинения, реферат бесплатно, рефераты авиация, рефераты психология, рефераты математика, рефераты кулинария, рефераты логистика, рефераты анатомия, рефераты маркетинг, рефераты релиния, рефераты социология, рефераты менеджемент.