public static string GetWatermeterPos(string WatermeterID) { MySQLDB.InitDb(); DataSet ds = new DataSet("dspipe"); string strSQL = "select w.Position,p.StartLocation,p.EndLocation from twatermeter w,tpipe p where w.WaterMeterID=" + WatermeterID + " and w.PipeID=p.PipeID"; try { ds = MySQLDB.SelectDataSet(strSQL, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) // 有数据集 { return(PublicMethod.DataTableToJson(ds.Tables[0])); } else { return(PublicMethod.OperationResultJson("99", "数据为空")); };; } else { return(PublicMethod.OperationResultJson("99", "数据为空")); } } catch (Exception ex) { return(PublicMethod.getResultJson(ErrorCodeDefinition.DB_ERROR, ErrorCodeDefinition.getErrorMessageByErrorCode(ErrorCodeDefinition.DB_ERROR)));//数据库异常 } }
public static string userLogin(string loginname, string password) { DataSet ds = new DataSet(); MySQLDB.InitDb(); string strSQL = " select u.UserID, u.*,a.AreaName,g.* " + " from tuser u,tarea a ,tgroup g " + " where u.AreaID=a.areaid " + " and u.GroupID=g.GroupID " + " and u.UserName=?UserName "; MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter("?UserName", MySqlDbType.VarChar) }; try { parms[0].Value = loginname.ToLower();//全部小写 ds = MySQLDB.SelectDataSet(strSQL, parms); if (ds.Tables[0].Rows.Count == 0) //用户名不存在 { return(PublicMethod.getResultJson(ErrorCodeDefinition.USER_NOT_EXISTS, ErrorCodeDefinition.getErrorMessageByErrorCode(ErrorCodeDefinition.USER_NOT_EXISTS))); } else //做下一步的处理,检查密码是否正确 { string pwd = ""; pwd = PublicMethod.GetMD5Hash(password); string strDBpwd = ds.Tables[0].Rows[0]["Password"].ToString(); if (strDBpwd.Equals(pwd)) { string strResult = ""; HttpContext.Current.Session["UserName"] = loginname; HttpContext.Current.Session["UserID"] = ds.Tables[0].Rows[0]["UserID"].ToString(); HttpContext.Current.Session["AreaID"] = ds.Tables[0].Rows[0]["AreaID"].ToString(); return(PublicMethod.DataTableToJson(ds.Tables[0])); } else { return(PublicMethod.getResultJson(ErrorCodeDefinition.USER_PASSWORD_ERROR, ErrorCodeDefinition.getErrorMessageByErrorCode(ErrorCodeDefinition.USER_PASSWORD_ERROR))); } } } catch (Exception ex) { return(PublicMethod.getResultJson(ErrorCodeDefinition.DB_ERROR, ErrorCodeDefinition.getErrorMessageByErrorCode(ErrorCodeDefinition.DB_ERROR)));//数据库异常 } }