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); }