private void picLogin_Click(object sender, EventArgs e)
{
SqlDataReader sdr = null;
if (String.IsNullOrEmpty(txtCode.Text.Trim()))
{
MessageBox.Show("登录用户不许为空！", "软件提示");
txtCode.Focus();
return;
}
if (String.IsNullOrEmpty(txtPwd.Text))
{
MessageBox.Show("登录密码不许为空！", "软件提示");
txtPwd.Focus();
return;
}
//用户编码不重复
string strSql = "select * from tb_Operator where OperatorCode = '" + txtCode.Text.Trim() + "'";
try
{
sdr = dataOper.GetDataReader(strSql);
if (!sdr.HasRows) //若该用户编码无数据记录
{
MessageBox.Show("登录用户不正确！", "软件提示");
txtCode.Focus();
}
else
{
//MD5Encrypt.GetMD5Password(txtPwd.Text)
sdr.Read(); //读取唯一的一行记录
if (!((txtPwd.Text) == sdr["Password"].ToString())) //若密码不相同
{
MessageBox.Show("登录密码不正确！", "软件提示");
txtPwd.Focus();
}
else
{
GlobalProperty.OperatorCode = sdr["OperatorCode"].ToString();
GlobalProperty.OperatorName = sdr["OperatorName"].ToString();
GlobalProperty.Password = sdr["Password"].ToString();
GlobalProperty.IsFlag = sdr["IsFlag"].ToString();
this.Hide();
AppForm formApp = new AppForm();
formApp.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
}
finally
{
sdr.Close();
}
}
/// <summary>
/// 判断数据表中记录的主键值是否存在外键约束
/// </summary>
/// <param name="strPrimaryTable">主键表</param>
/// <param name="strPrimaryValue">数据表中某条记录主键的值</param>
/// <returns></returns>
public bool IsExistConstraint(string strPrimaryTable, string strPrimaryValue)
{
DataOperate dataOper = new DataOperate();
bool booIsExist = false;
string strSql = null;
string strForeignColumn = null;
string strForeignTable = null;
SqlDataReader sdr = null;
try
{
//创建SqlParameter对象，并赋值
SqlParameter param = new SqlParameter("@PrimaryTable", SqlDbType.VarChar);
param.Value = strPrimaryTable;
//创建泛型
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(param);
//把泛型中的元素复制到数组中
SqlParameter[] inputParameters = parameters.ToArray();
//通过存储过程得到外键表的相关数据
DataTable dt = dataOper.GetDataTable("QueryForeignConstraint", inputParameters);
//循环这些相关数据
foreach (DataRow dr in dt.Rows)
{
strForeignTable = dr["ForeignTable"].ToString();
strForeignColumn = dr["ForeignColumn"].ToString();
strSql = "Select " + strForeignColumn + " From " + strForeignTable + " Where " + strForeignColumn + " = '" + strPrimaryValue + "'";
sdr = dataOper.GetDataReader(strSql);
if (sdr.HasRows)
{
booIsExist = true;
sdr.Close();
//跳出循环
break;
}
sdr.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
throw ex;
}
return(booIsExist);
}
