public string checkIPArea(SqlDataReader dr, string SID, string sSubmitIP) { string sResult = ""; string sArea = ""; //objComm = new OleDbCommand("SELECT TOP 1 Content FROM CondtionTable WHERE SID=" + SID, objConn); dr = new Survey_SurveyCode_Layer().GetCondtionTable(SID); if (dr.Read()) { sArea = dr[0].ToString(); } dr.Close(); if (sArea != "") { if (sSubmitIP == "") { sResult = "25"; } sSubmitIP = getIP10(sSubmitIP); //objComm.CommandText = "SELECT TOP 1 Province,City FROM IP WHERE " + sSubmitIP + ">=StartIP AND " + sSubmitIP + "<=EndIP"; dr = new Survey_SurveyCode_Layer().GetIP(sSubmitIP); if (dr.Read()) { string sCity = "," + dr["City"].ToString() + ","; string sProvince = "," + dr["Province"].ToString() + ","; string[] arrArea = sArea.Split('|'); if (arrArea[2].IndexOf(sProvince) < 0)//如果所在省不在允许内 { if (sCity == ",,") { sResult = "29";//检查不到城市来源 } else if (arrArea[1].IndexOf(sCity) < 0) { sResult = "26";//IP来源城市不在允许的范围 } } } else { sResult = "27";//检查不到来源 } dr.Close(); } else { sResult = "28"; } return(sResult); }
protected string[] getSurveyPar(long SID, SqlDataReader dr) { string[] arrResult = new string[5]; //objComm.CommandText = "SELECT SurveyPSW,State,Active,Par,EndDate FROM SurveyTable WHERE SID=" + SID.ToString(); dr = new Survey_SurveyCode_Layer().GetSurveyTable(SID.ToString()); while (dr.Read()) { arrResult[0] = dr["SurveyPSW"].ToString();// sSurveyPSW = Convert.ToString(dr["SurveyPSW"]); if (!Convert.IsDBNull(dr["EndDate"])) { arrResult[1] = dr["EndDate"].ToString();// sEndDate = dr["EndDate"].ToString(); } else { arrResult[1] = ""; } arrResult[2] = dr["State"].ToString(); // sState = dr["State"].ToString(); arrResult[3] = dr["Active"].ToString(); // sActive = dr["Active"].ToString(); arrResult[4] = "|" + Convert.ToString(dr["Par"]) + "|"; //sPar = "|" + Convert.ToString(dr["Par"]) + "|"; } dr.Close(); return(arrResult); }
protected string getSurveyExpand(long SID, SqlDataReader dr) { string sResult = ""; //objComm.CommandText = "SELECT ExpandContent,ExpandType FROM SurveyExpand WHERE SID=" + SID + " AND ExpandType IN(0,1,8)"; dr = new Survey_SurveyCode_Layer().GetSurveyExpand(SID.ToString()); while (dr.Read()) { if (dr[1].ToString() == "0") { sResult += "sHiddenItem = '" + dr[0].ToString() + "';\n"; } else if (dr[1].ToString() == "1") { sResult += "sURLVar = '" + dr[0].ToString() + "';\n"; } else if (dr[1].ToString() == "8") { sResult += "sProgressiveAsk = '" + dr[0].ToString() + "';\n"; } } dr.Close(); return(sResult); }
protected bool checkSurveyExpand_5(long SID, SqlDataReader dr, string sGUID) { bool blnResult = true; string sTemp = ""; string sDep = ""; //objComm.CommandText = "SELECT ExpandContent FROM SurveyExpand WHERE SID=" + SID + " AND ExpandType =5"; dr = new Survey_SurveyCode_Layer().GetSurveyExpand1(SID.ToString()); if (dr.Read()) { sTemp = dr[0].ToString(); } dr.Close(); if (sTemp == "") { return(true); } string[] arrTemp = sTemp.Split('|'); //objComm.CommandText = "SELECT TOP 1 Dep FROM GUTable WHERE GUID=" + sGUID; sGUID = "," + sGUID + ","; if (arrTemp[1] != "") { if (arrTemp[0] == "W") { if (("," + arrTemp[1] + ",").IndexOf(sGUID) < 0)//设置了白名单,而不在白名单中 { //如果这样,那只要不处于白名单中,不管是否处于部门黑白名单,均得到同一结果,即部门设置无用 //在个人检查中未通过,放到下面部门检查是否通过 blnResult = false; //return false; } else { return(true);//设置了白名单,在白名单中 } } else { if (("," + arrTemp[1] + ",").IndexOf(sGUID) > 0)//设置了黑名单,并且在黑名单中 { return(false); } } } if (arrTemp[3] != "") { //dr = objComm.ExecuteReader(); if (dr.Read()) { sDep = "," + dr[0].ToString() + ","; } dr.Close(); if (arrTemp[2] == "W") { if (("," + arrTemp[3] + ",").IndexOf(sDep) < 0)//如果不在部门白名单 { return(false); } else { return(true); } } else { if (("," + arrTemp[3] + ",").IndexOf(sDep) > 0) { return(false); } } } return(blnResult); }