public static UserDeptCheckQuery GetInstance()
{
if (dqform == null || dqform.IsDisposed)
{
dqform = new UserDeptCheckQuery();
}
return(dqform);
}
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e)
{
UserDeptCheckQuery Frm = UserDeptCheckQuery.GetInstance();
Frm.TopLevel = false;
Frm.Parent = this;
Frm.Show();
Frm.BringToFront();
//Children.Add(Frm);
}
private void simpleButtonOK_Click(object sender, EventArgs e)
{
ConnDB conn = new ConnDB();
string strsql, strsql2, log_name, dept1, dept2, dept3;
int rows;
log_name = textEditLogName.Text.ToString().Trim();
dept1 = comboBoxDept1.Text.ToString();
dept2 = comboBoxDept2.Text.ToString();
dept3 = comboBoxDept3.Text.ToString();
if (dept1 == "请选择")
{
dept1 = "";
}
if (dept2 == "请选择")
{
dept2 = "";
}
if (dept3 == "请选择")
{
dept3 = "";
}
strsql = "insert into cost_check_dept(log_name,DEPT1,DEPT2,DEPT3) values('" + log_name + "','" + dept1 + "','" + dept2 + "','" + dept3 + "')";
strsql2 = "select * from cost_check_dept where log_name = '" + log_name + "' and dept1 = '" + dept1 + "' and dept2 = '" + dept2 + "' and dept3 ='" + dept3 + "'";
if (log_name != "")
{
rows = conn.ReturnRecordCount(strsql2);
if (rows > 0)
{
MessageBox.Show("该记录已经存在！");
}
else
{
bool isok = conn.EditDatabase(strsql);
if (isok)
{
MessageBox.Show("添加成功！");
UserDeptCheckQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
}
}
else
{
MessageBox.Show("不能为空！");
}
conn.Close();
}
//public void ChangAllChildRenSize()
//{
// foreach (Form ChildForm in Children)
// {
// ChildForm.Height = fheight;
// ChildForm.Width = fwidth;
// }
//}
//private void Dept_SizeChanged(object sender, EventArgs e)
//{
//if (isno)
//{
// fheight = this.Height;
// fwidth = this.Width;
// ChangAllChildRenSize();
//}
//}
private void User_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
UserDeptCheckQuery Frm = UserDeptCheckQuery.GetInstance();
Frm.TopLevel = false;
Frm.Parent = this;
Frm.Show();
Frm.BringToFront();
//xtraTabControl1.MakePageVisible(xtraTabPage1);
//isno = true;
//Children.Add(Frm);
}
private void barButtonItem修改_ItemClick(object sender, ItemClickEventArgs e)
{
string logname = "", personname = "", dept1 = "", dept2 = "", dept3 = "";
UserDeptCheckQuery.GetInfo(ref logname, ref personname, ref dept1, ref dept2, ref dept3);
if (logname != "")
{
UserDeptCheckUpdate Frm = new UserDeptCheckUpdate();
Frm.TopLevel = false;
Frm.Parent = this;
Frm.Show();
Frm.BringToFront();
}
}
private void UserUpdate_Load(object sender, EventArgs e)
{
//this.WindowState = FormWindowState.Maximized;
BindDept1();
BindDept2();
UserDeptCheckQuery.GetInfo(ref logname, ref personname, ref dept1, ref dept2, ref dept3);
if (logname != "")
{
textEditLogName.Text = logname;
textEditName.Text = personname;
comboBoxDept1.Text = dept1;
comboBoxDept2.Text = dept2;
comboBoxDept3.Text = dept3;
}
}
private void simpleButtonOK_Click(object sender, EventArgs e)
{
ConnDB conn = new ConnDB();
string dept11, dept22, dept33;
dept11 = comboBoxDept1.Text;
dept22 = comboBoxDept2.Text;
dept33 = comboBoxDept3.Text;
if (dept11 == "请选择")
{
dept11 = "";
}
if (dept22 == "请选择")
{
dept22 = "";
}
if (dept33 == "请选择")
{
dept33 = "";
}
string sql = "update cost_check_dept set dept1 ='" + dept11 + "',dept2 ='" + dept22 + "',dept3 ='" + dept33;
sql = sql + "' where log_name = '" + logname + "' and dept1 = '" + dept1 + "' and dept2 = '" + dept2 + "' and dept3 = '" + dept3 + "'";
// string sql2 = "select cname from cost_user where cname = '" + textEditLogName.Text.ToString().Trim() + "' and password ='******'";
if (textEditLogName.Text.ToString().Trim() != "")
{
bool isok = conn.EditDatabase(sql);
if (isok)
{
MessageBox.Show("修改成功！");
UserDeptCheckQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
}
else
{
MessageBox.Show("登录名不能为空值！");
}
conn.Close();
}
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e)
{
UserDeptCheckQuery.RefreshEX();
}
