高校学报管理信息系统课程设计实验报告(5)

开始超级管理员登录浏览经费信息经费分类统计评审费统计稿费统计出版发行费统计办公费结束 4.核心代码

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; using System.Data.SqlClient;

namespace LJM.PerForm {

public partial class F_AuthorRegister : Form {

public DialogResult registerResult = DialogResult.Cancel;

DataClass.MyDataClass MyClass = new LJM.DataClass.MyDataClass();

public F_AuthorRegister() {

InitializeComponent(); }

//注册提交

private void btnAuthorSubmit_Click(object sender, EventArgs e) {

registerResult = DialogResult.Cancel; //判断符合条件，并录入数据库

if (tbAuthorID.Text != \ & tbAuthorPass.Text != \)//用户名、密码均非空 {

SqlDataReader temDR = MyClass.getcom(\用户表where Staff_ID='\ + tbAuthorID.Text.Trim() + \ + tbAuthorPass.Text.Trim() + \); bool ifcom = temDR.Read();

if (!ifcom)//查找结果为空，该用户尚未注册，符号条件，注册成功 {

//录入数据库 //登陆表tb_User

MyClass.getcom(\用户表values ('\ + tbAuthorID.Text.Trim() + \ + tbAuthorName.Text.Trim() + \ + tbAuthorPass.Text.Trim() + \ + \ + \); //作者表tb_Author

MyClass.getcom(\作者信息表values ('\

+ tbAuthorID.Text.Trim() + \ + tbAuthorName.Text.Trim() + \ + cbAuthorSex.Text.Trim() + \

+ dtpAuthorDateOfBirth.Value + \ + tbAuthorTel.Text.Trim() + \ + tbAuthorEmail.Text.Trim() + \ + tbAuthorAddress.Text.Trim() + \); MessageBox.Show(\注册成功！\\n点击确认进入系统\, \提示\, MessageBoxButtons.OK);

this.Close();

registerResult = DialogResult.OK; }

else//不符合条件，需重新注册 {

registerResult = DialogResult.Retry;

if (MessageBox.Show(\注册失败！\\n请重新注册\, \提示\, MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel) {

this.Close(); this.Dispose(); Application.Exit(); } } }

else//不符合条件，需重新注册

{

registerResult = DialogResult.Retry;

if (MessageBox.Show(\注册失败！\\n请重新注册\, \提示\, MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel) {

this.Close(); this.Dispose(); Application.Exit(); } } }

//注册取消

private void btnAuthorCancel_Click(object sender, EventArgs e) {

registerResult = DialogResult.Cancel; this.Close(); } } }

作者信息管理（包括删除、修改、查找功能）

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; using System.Data.SqlClient;

namespace LJM.PerForm {

public partial class F_Author : Form {

SqlConnection thisConnection; SqlCommand thisCommand; SqlDataReader thisReader; string sql = \; public F_Author() {

InitializeComponent();

thisConnection = new SqlConnection(

@\ + \); }

//初始化

private void F_Author_Load(object sender, EventArgs e) {

if (LJM.DataClass.MyDataClass.Login_Limit == 3) {

this.btnDel.Enabled = false; } if (LJM.DataClass.MyDataClass.Login_Limit == 1 LJM.DataClass.MyDataClass.Login_Limit == 2) {

this.btnDel.Enabled = false; }

this.lvAuthor.Columns.Add(\作者编号\, this.lvAuthor.Width / 7 - 1); this.lvAuthor.Columns.Add(\姓名\, this.lvAuthor.Width / 7 - 1); this.lvAuthor.Columns.Add(\性别\, this.lvAuthor.Width / 7 - 1); this.lvAuthor.Columns.Add(\出生日期\, this.lvAuthor.Width / 7 - 1); this.lvAuthor.Columns.Add(\手机\, this.lvAuthor.Width / 7 - 1); this.lvAuthor.Columns.Add(\, this.lvAuthor.Width / 7 - 1); this.lvAuthor.Columns.Add(\地址\, this.lvAuthor.Width / 7 - 1); thisConnection.Open();

thisCommand = thisConnection.CreateCommand(); sql = \作者信息表\;

if (DataClass.MyDataClass.Login_Limit == 3) {

//作者本人登录，仅显示本人信息

sql = \* from 作者信息表where Author_ID = DataClass.MyDataClass.Login_ID + \; //进行一些功能限制

//..................................................... // }

thisCommand.CommandText = sql;

thisReader = thisCommand.ExecuteReader(); //ListView上显示

lvAuthor.Items.Clear(); while (thisReader.Read()) {

string id = (string)thisReader[\].ToString().Trim();

string name = (string)thisReader[\].ToString().Trim(); string sex = (string)thisReader[\].ToString().Trim();

string Birthday = Convert.ToString(thisReader[\]).ToString().Trim(); string Phone = (string)thisReader[\].ToString().Trim(); string Email = (string)thisReader[\].ToString().Trim(); string Address = (string)thisReader[\].ToString().Trim();

|| '\ + //创建ListView的主项

ListViewItem item = new ListViewItem(id);//添加子项 item.SubItems.Add(name); item.SubItems.Add(sex);

item.SubItems.Add(Birthday); item.SubItems.Add(Phone); item.SubItems.Add(Email); item.SubItems.Add(Address); lvAuthor.Items.Add(item); }

thisReader.Close();//关闭dataReader对象 thisConnection.Close(); this.Text = \作者信息\;

if (lvAuthor.Items.Count > 1) {

this.Text = \作者信息\ + \：\ + lvAuthor.Items[0].Text.Trim(); } }

//显示函数

public void DisplayAll() {

thisConnection.Open();

thisCommand = thisConnection.CreateCommand();

thisCommand.CommandText = sql;// \作者信息表\ thisReader = thisCommand.ExecuteReader(); //ListView上显示

lvAuthor.Items.Clear(); while (thisReader.Read()) {

string id = (string)thisReader[\].ToString().Trim();

string name = (string)thisReader[\].ToString().Trim(); string sex = (string)thisReader[\].ToString().Trim();

string Birthday = Convert.ToString(thisReader[\]).ToString().Trim(); string Phone = (string)thisReader[\].ToString().Trim(); string Email = (string)thisReader[\].ToString().Trim(); string Address = (string)thisReader[\].ToString().Trim(); //创建ListView的主项

ListViewItem item = new ListViewItem(id);//添加子项 item.SubItems.Add(name); item.SubItems.Add(sex);

item.SubItems.Add(Birthday); item.SubItems.Add(Phone); item.SubItems.Add(Email); item.SubItems.Add(Address);