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