//****************************************************************************************************
//员工登录
private void btnLogin_Click(object sender, EventArgs e)
{
if (txtUsername.Text == "")
{
Function.showMessage("用户名为空", txtUsername);
return;
}
if (txtPassword.Text == "")
{
Function.showMessage("密码为空", txtPassword);
return;
}
//if (cmbDepartmentId.SelectedValue.ToString() == "0") {
// MessageBox.Show("请选择科室！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
// cmbDepartmentId.Focus();
// return;
//}
DataRow dr = new ModWorker().setWhere("(isPass = 1) and (username = '******') and (password = '******')").getFind();
if (dr == null)
{
Function.showMessage("用户名、密码错误或该账号禁用");
}
else
{
Program.intWorkerId = int.Parse(dr["id"].ToString());
Program.strUsername = dr["username"].ToString();
Program.strRealname = dr["realname"].ToString();
FrmMain frmMain = new FrmMain();
frmMain.Show();
this.Hide();
}
}
//****************************************************************************************************
//加载
private void FrmWorkerEdit_Load(object sender, EventArgs e)
{
if (intId == 0)
{
this.Text = "添加" + this.Text;
ParseCombobox.setDepartment(cmbDepartmentId);
ParseCombobox.setWorkerType(cmbWorkerTypeId);
ParseCombobox.setSex(cmbSex);
}
else
{
this.Text = "修改" + this.Text;
DataRow dr = new ModWorker().setWhere("id > 0", true).getFind(intId);
if (dr == null)
{
Function.showMessage("记录为空");
this.Close();
}
else
{
txtUsername.Enabled = false;
chkIsPass.Checked = Convert.ToBoolean(dr["isPass"]);
txtUsername.Text = dr["username"].ToString();
txtPassword.Text = dr["password"].ToString();
txtWorkerCode.Text = dr["workerCode"].ToString();
txtRealname.Text = dr["realname"].ToString();
txtTel.Text = dr["tel"].ToString();
txtSpell.Text = dr["spell"].ToString();
ParseCombobox.setDepartment(cmbDepartmentId, dr["departmentId"]);
ParseCombobox.setWorkerType(cmbWorkerTypeId, dr["workerTypeId"]);
ParseCombobox.setSex(cmbSex, dr["sex"].ToString());
}
}
}
//****************************************************************************************************
//员工
public static void setWorker(ComboBox cmb, Object value = null)
{
DataTable dt = new ModWorker().getSelect();
DataRow dr = dt.NewRow();
dr["id"] = 0;
dr["realname"] = "--请选择员工--";
dt.Rows.InsertAt(dr, 0);
cmb.DataSource = dt;
cmb.ValueMember = "id";
cmb.DisplayMember = "realname";
if (value == null)
{
cmb.SelectedValue = 0;
}
else
{
cmb.SelectedValue = Convert.ToInt32(value);
}
}
//****************************************************************************************************
//显示数据
private void showData()
{
DataTable dt = new ModWorker().setWhere("id > 0", true).setRelation(true).getSelect();
if (dt == null)
{
btnUpdate.Enabled = false;
}
else
{
btnUpdate.Enabled = true;
int intIndex = 0;
if (grd.Rows.Count > 0)
{
intIndex = grd.CurrentRow.Index;
}
grd.AutoGenerateColumns = false;
grd.DataSource = dt;
grd.Rows[intIndex].Cells[1].Selected = true;
}
}
