逐浪cms SQL注入

protected void Page_Load(object sender, EventArgs e)

{

    if (base.Request.QueryString["type"] != null)

    {

        if (base.Request.QueryString["type"] == "Seat")

        {

            this.GetSeat();

        }

        if (base.Request.QueryString["type"] == "add")

        {

            this.SetInfo(base.Request.Form.ToString());

        }

        bool flag1 = base.Request.QueryString["type"] == "answer";

        if ((base.Request.QueryString["type"] == "getservice") && (base.Request.QueryString["uid"] != null))

        {

            this.GetServerInfo(base.Request.QueryString["uid"].ToString(), base.Request.Cookies["Provisional"]["Uid"]); //跟進

        }

        if (base.Request.QueryString["type"] == "OnlineUsers")

        {

            this.GetOnlineUsers();

        }

        bool flag2 = base.Request.QueryString["type"] == "CallMe";

        if (base.Request.QueryString["type"] == "msg")

        {

            this.GetMsg(); //跟進

        }

        this.DelUser();

    }

}




private void GetMsg()

{

    StringBuilder builder = new StringBuilder();

    DataTable table = this.bcsbll.Select_Where(" CS_Type=0 and CS_OID=" + base.Request.Cookies["Provisional"]["Uid"], " DISTINCT CS_SendID,CS_SendName ", ""); //沒處理存在注入

    for (int i = 0; i < table.Rows.Count; i++)

    {

        builder.Append(string.Concat(new object[] { table.Rows[i]["CS_SendID"], ",", table.Rows[i]["CS_SendName"], ";" }));

    }

    string s = builder.ToString();

    if (s.EndsWith(";"))

    {

        s = s.Substring(0, s.Length - 1);

    }

    base.Response.Write(s);

}

private void GetServerInfo(string uid, string sessid)

{

    DataTable customerByUid = this.bcsbll.GetCustomerByUid(DataConverter.CLng(uid), sessid); //跟進

    StringBuilder builder = new StringBuilder();

    if (!string.IsNullOrEmpty(uid) && !string.IsNullOrEmpty(sessid))

    {

        for (int i = 0; i < customerByUid.Rows.Count; i++)

        {

            if (((customerByUid.Rows[i]["CS_OID"] != null) && (sessid == customerByUid.Rows[i]["CS_OID"].ToString())) && (customerByUid.Rows[i]["CS_SendID"].ToString() == sessid))

            {

                builder.Append(string.Concat(new object[] { customerByUid.Rows[i]["CS_AddTime"], "  你對", customerByUid.Rows[i]["CS_CtoName"], "說：<br />&nbsp;&nbsp;", customerByUid.Rows[i]["CS_Context"], "<br />" }));

            }

            else

            {

                builder.Append(string.Concat(new object[] { customerByUid.Rows[i]["CS_AddTime"].ToString(), "  ", customerByUid.Rows[i]["CS_SendName"], "對你說：<br />&nbsp;&nbsp;", customerByUid.Rows[i]["CS_Context"], "<br />" }));

            }

        }

    }

    base.Response.Write(builder.ToString());

}




public DataTable GetCustomerByUid(int id, string sessid)

{

    string strSQL = "";

    if (id > 0)

    {

        string str2 = strSQL;

        strSQL = str2 + " (CS_SendID=" + id.ToString() + " or CS_Ctouid=" + id.ToString() + ")";

    }

    if (!string.IsNullOrEmpty(sessid))

    {

        strSQL = strSQL + " and CS_OID='" + sessid + "'"; //沒處理存在注入

    }

    DataTable dt = this.SelectWhere(strSQL, " CS_ID,CS_Context,CS_SendName,CS_SendID,CS_CtoName,CS_AddTime,CS_OID ", " CS_AddTime asc");

    this.updateType(dt, id, sessid);

    return dt;

}