private void addView(UserData user)
{
try
{
ListViewItem lvi = new ListViewItem(user.Name);
lvi.Tag = user;
ListViewItem.ListViewSubItem lvs = new ListViewItem.ListViewSubItem();
UserData tempUser = UserCortrol.getUser(user.ID);
switch (tempUser.Purview)
{
case Set.Admin:
lvs.Text = "管理员";
lvs.Tag = tempUser;
break;
case Set.Super:
lvs.Text = "高级用户";
lvs.Tag = tempUser;
break;
case Set.Ordinarily:
lvs.Text = "普通用户";
lvs.Tag = tempUser;
break;
}
lvi.SubItems.Add(lvs);
this.lviUser.Items.Add(lvi);
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDel_Click(object sender, EventArgs e)
{
try
{
if (this.lviUser.SelectedItems.Count == 0)
{
throw new MessageException("请选择要删除的项目！");
}
DialogResult dr = MessageBox.Show("您确定要删除该项目吗？", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
UserData us = (UserData)this.lviUser.SelectedItems[0].Tag;
if (dr != DialogResult.No && us.ID != Set.User.ID)
{
UserCortrol.delUser(us);
this.lviUser.Items.RemoveAt(this.lviUser.SelectedIndices[0]);
clear();
}
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 在定单信息中增加一项未审批的定单
/// </summary>
/// <param name="ls"></param>
private void setLVs(StockData sd, ListViewItem lv)
{
ListViewItem lvi = new ListViewItem(sd.StockNo);
lvi.Tag = sd;
lvi.SubItems.Add(PInfoCortrol.getPInfoOfID(sd.PInfoID).Name);
if (sd.Down == false && sd.Blank == false)
{
lvi.SubItems.Add("未审批");
lvi.SubItems.Add(sd.StockDate.ToString("d"));
lvi.SubItems.Add(UserCortrol.getUser(sd.UserID).Name);
lvi.ImageIndex = 3;
}
else if (sd.Down == true)
{
lvi.SubItems.Add("已审批");
lvi.SubItems.Add(sd.DownDate.ToString("d"));
lvi.SubItems.Add(UserCortrol.getUser(sd.UserID).Name);
lvi.SubItems.Add(UserCortrol.getUser(sd.DownUserID).Name);
lvi.ImageIndex = 0;
}
else if (sd.Blank == true)
{
lvi.SubItems.Add("已作废");
lvi.SubItems.Add(sd.BlankDate.ToString("d"));
lvi.SubItems.Add(UserCortrol.getUser(sd.UserID).Name);
lvi.SubItems.Add(UserCortrol.getUser(sd.BlankUserID).Name);
lvi.ImageIndex = 1;
}
this.lvS.Items[this.lvS.Items.IndexOf(lv)] = lvi;
}
/// <summary>
/// 在定单信息中增加一项未审批的定单
/// </summary>
/// <param name="ls"></param>
private void addLVs(List <StockData> ls)
{
this.lvS.Items.Clear();
this.lvSInfo.Items.Clear();
foreach (StockData sd in ls)
{
ListViewItem lvi = new ListViewItem(sd.StockNo);
lvi.Tag = sd;
lvi.SubItems.Add(PInfoCortrol.getPInfoOfID(sd.PInfoID).Name);
if (sd.Down == false && sd.Blank == false)
{
lvi.SubItems.Add("未审批");
lvi.SubItems.Add(sd.StockDate.ToString("d"));
lvi.SubItems.Add(UserCortrol.getUser(sd.UserID).Name);
lvi.ImageIndex = 3;
}
else if (sd.Down == true)
{
lvi.SubItems.Add("已审批");
lvi.SubItems.Add(sd.DownDate.ToString("d"));
lvi.SubItems.Add(UserCortrol.getUser(sd.UserID).Name);
lvi.SubItems.Add(UserCortrol.getUser(sd.DownUserID).Name);
lvi.ImageIndex = 0;
}
else if (sd.Blank == true)
{
lvi.SubItems.Add("已作废");
lvi.SubItems.Add(sd.BlankDate.ToString("d"));
lvi.SubItems.Add(UserCortrol.getUser(sd.UserID).Name);
lvi.SubItems.Add(UserCortrol.getUser(sd.BlankUserID).Name);
lvi.ImageIndex = 1;
}
this.lvS.Items.Add(lvi);
}
}
private void fillView()
{
this.lviUser.Items.Clear();
foreach (UserData user in UserCortrol.selUser())
{
addView(user);
}
}
private void button1_Click(object sender, EventArgs e)
{
Set.set.SqlServerName = this.txtServer.Text;
Set.set.SqlUser = this.txtUser.Text;
Set.set.SqlPwd = this.txtPwd.Text;
UserCortrol.setConn(Set.set.SqlServerName, Set.set.SqlUser, Set.set.SqlPwd);
Set.XmlSerializer();
this.Close();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (this.txtName.Text == "")
{
throw new MessageException("请输入用户名");
}
if (this.txtPwd.Text == "")
{
throw new MessageException("请输入密码");
}
if (this.lviUser.SelectedItems != null)
{
ListViewItem lvi = this.lviUser.SelectedItems[0];
UserData user = (UserData)lvi.Tag;
user.Name = this.txtName.Text;
user.Pwd = this.txtPwd.Text;
switch (this.cobPru.Text)
{
case "管理员":
user.Purview = 0;
break;
case "高级用户":
user.Purview = 1;
break;
case "普通用户":
user.Purview = 2;
break;
}
UserCortrol.updateUser(user);
clear();
fillView();
}
else
{
throw new MessageException("请选择要更新的项目！");
}
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (this.txtName.Text == "")
{
throw new MessageException("请输入用户名");
}
if (this.txtPwd.Text == "")
{
throw new MessageException("请输入密码");
}
UserData user = new UserData();
user.Name = this.txtName.Text;
user.Pwd = this.txtPwd.Text;
switch (this.cobPru.Text)
{
case "管理员":
user.Purview = 0;
break;
case "高级用户":
user.Purview = 1;
break;
case "普通用户":
user.Purview = 2;
break;
}
int i = UserCortrol.insertUser(user);
user.ID = i;
addView(user);
clear();
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (this.txtName.Text.Length == 0)
{
throw new MessageException("用户名不能为空！");
}
else if (this.txtPwd.Text == "")
{
throw new MessageException("密码不能为空！");
}
UserData u = UserCortrol.login(this.txtName.Text, this.txtPwd.Text);
Set.User = u;
this.DialogResult = DialogResult.Yes;
}
catch (SqlException)
{
DialogResult dr = MessageBox.Show("连接到SqlServer服务器失败！\n是否进行服务器配置？", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.No)
{
return;
}
frmSqlSet fss = new frmSqlSet();
fss.ShowDialog();
}
catch (MessageException ex)
{
if (ex.Message != "")
{
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmLogin_Load(object sender, EventArgs e)
{
UserCortrol.setConn(Set.set.SqlServerName, Set.set.SqlUser, Set.set.SqlPwd);
}
