/// <summary>
/// 得到一个对象实体
/// </summary>
public QQWeiBoUserMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, OpenId, WB_Name, WB_Nick, Oauth2Token, Expire, TS, Location, FansNum, IsVIP, OpenId1, Oauth2Token1, Expire1, CustomerSysNo from Apps.dbo.QQWeiBoUser");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4)
};
parameters[0].Value = SysNo;
QQWeiBoUserMod model = new QQWeiBoUserMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
model.OpenId = ds.Tables[0].Rows[0]["OpenId"].ToString();
model.WB_Name = ds.Tables[0].Rows[0]["WB_Name"].ToString();
model.WB_Nick = ds.Tables[0].Rows[0]["WB_Nick"].ToString();
model.Oauth2Token = ds.Tables[0].Rows[0]["Oauth2Token"].ToString();
if (ds.Tables[0].Rows[0]["Expire"].ToString() != "")
{
model.Expire = DateTime.Parse(ds.Tables[0].Rows[0]["Expire"].ToString());
}
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
model.Location = ds.Tables[0].Rows[0]["Location"].ToString();
if (ds.Tables[0].Rows[0]["FansNum"].ToString() != "")
{
model.FansNum = int.Parse(ds.Tables[0].Rows[0]["FansNum"].ToString());
}
if (ds.Tables[0].Rows[0]["IsVIP"].ToString() != "")
{
model.IsVIP = int.Parse(ds.Tables[0].Rows[0]["IsVIP"].ToString());
}
model.OpenId1 = ds.Tables[0].Rows[0]["OpenId1"].ToString();
model.Oauth2Token1 = ds.Tables[0].Rows[0]["Oauth2Token1"].ToString();
if (ds.Tables[0].Rows[0]["Expire1"].ToString() != "")
{
model.Expire1 = DateTime.Parse(ds.Tables[0].Rows[0]["Expire1"].ToString());
}
if (ds.Tables[0].Rows[0]["CustomerSysNo"].ToString() != "")
{
model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public QQWeiBoUserMod GetRecordByName(string name)
{
QQWeiBoUserMod model = new QQWeiBoUserMod();
using (SQLData data = new SQLData())
{
StringBuilder builder = new StringBuilder();
builder.Append("select SysNo from Apps.dbo.QQWeiBoUser where WB_Name='").Append(SQLData.SQLFilter(name) + "'");
try
{
model.SysNo = int.Parse(data.CmdtoDataRow(builder.ToString())["SysNo"].ToString());
}
catch (Exception)
{
}
}
if (model.SysNo != -999999)
{
model = this.GetModel(model.SysNo);
}
return model;
}
public QQWeiBoUserMod GetRecordByName(string name)
{
QQWeiBoUserMod model = new QQWeiBoUserMod();
using (SQLData data = new SQLData())
{
StringBuilder builder = new StringBuilder();
builder.Append("select SysNo from Apps.dbo.QQWeiBoUser where WB_Name='").Append(SQLData.SQLFilter(name) + "'");
try
{
model.SysNo = int.Parse(data.CmdtoDataRow(builder.ToString())["SysNo"].ToString());
}
catch (Exception)
{
}
}
if (model.SysNo != -999999)
{
model = this.GetModel(model.SysNo);
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if ((base.Request.QueryString["openid"] != null) && (base.Request.QueryString["openid"] != ""))
{
this.openid = base.Request.QueryString["openid"];
}
if ((base.Request.QueryString["openkey"] != null) && (base.Request.QueryString["openkey"] != ""))
{
this.openkey = base.Request.QueryString["openkey"];
}
if ((base.Request.QueryString["name"] != null) && (base.Request.QueryString["name"] != ""))
{
this.wb_name = base.Request.QueryString["name"];
}
if ((base.Request.QueryString["oauth2atoken"] != null) && (base.Request.QueryString["oauth2atoken"] != ""))
{
try
{
string[] strArray = base.Request.QueryString["oauth2atoken"].Split(new char[] { '&' });
this.oauth2token = strArray[0].Split(new char[] { '=' })[0];
this.expire = DateTime.Now.AddSeconds((double)int.Parse(strArray[1].Split(new char[] { '=' })[1]));
}
catch
{
}
}
if ((base.Request.QueryString["nick"] != null) && (base.Request.QueryString["nick"] != ""))
{
this.wb_nick = base.Request.QueryString["nick"];
}
if (!base.IsPostBack)
{
Dictionary <string, string> dictionary = new Dictionary <string, string>();
for (int i = 0; i <= 0x17; i++)
{
dictionary.Add(i.ToString(), i.ToString());
}
this.ddlHour.DataSource = dictionary;
this.ddlHour.DataTextField = "Key";
this.ddlHour.DataValueField = "Value";
this.ddlHour.DataBind();
this.ddlHour.SelectedIndex = 12;
QQWeiBo bo = new QQWeiBo();
if (this.openid != "")
{
QQWeiBoUserMod recordByName = QQWeiBoUserBll.GetInstance().GetRecordByName(this.wb_name);
if (recordByName.SysNo <= 0)
{
string[] strArray2 = bo.GetUserSimpleInfo(this.openid, this.openkey, base.Request.UserHostAddress, AppEnum.Apps.venus).Split(new char[] { '|' });
recordByName.Oauth2Token = this.oauth2token;
recordByName.OpenId = this.openid;
recordByName.TS = DateTime.Now;
recordByName.WB_Name = this.wb_name;
recordByName.WB_Nick = this.wb_nick;
recordByName.Location = strArray2[2];
recordByName.FansNum = int.Parse(strArray2[3]);
recordByName.IsVIP = int.Parse(strArray2[4]);
QQWeiBoUserBll.GetInstance().Add(recordByName);
}
else if ((recordByName.WB_Name == "") || (recordByName.FansNum == -999999))
{
string[] strArray3 = bo.GetUserSimpleInfo(this.openid, this.openkey, base.Request.UserHostAddress, AppEnum.Apps.venus).Split(new char[] { '|' });
recordByName.WB_Name = this.wb_name;
recordByName.WB_Nick = this.wb_nick;
recordByName.Location = strArray3[2];
recordByName.FansNum = int.Parse(strArray3[3]);
recordByName.IsVIP = int.Parse(strArray3[4]);
QQWeiBoUserBll.GetInstance().Update(recordByName);
}
}
if (bo.CheckFriend(this.openid, this.openkey, base.Request.UserHostAddress, AppEnum.Apps.venus))
{
this.nofriend1.Style["display"] = "none";
this.nofriend2.Style["display"] = "none";
}
else
{
this.isfriend1.Style["display"] = "none";
this.isfriend2.Style["display"] = "none";
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(QQWeiBoUserMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(QQWeiBoUserMod model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(QQWeiBoUserMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Apps.dbo.QQWeiBoUser(");
strSql.Append("OpenId,WB_Name,WB_Nick,Oauth2Token,Expire,TS,Location,FansNum,IsVIP,OpenId1,Oauth2Token1,Expire1,CustomerSysNo)");
strSql.Append(" values (");
strSql.Append("@OpenId,@WB_Name,@WB_Nick,@Oauth2Token,@Expire,@TS,@Location,@FansNum,@IsVIP,@OpenId1,@Oauth2Token1,@Expire1,@CustomerSysNo)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@OpenId",SqlDbType.VarChar,100),
new SqlParameter("@WB_Name",SqlDbType.VarChar,100),
new SqlParameter("@WB_Nick",SqlDbType.NVarChar,200),
new SqlParameter("@Oauth2Token",SqlDbType.VarChar,100),
new SqlParameter("@Expire",SqlDbType.DateTime),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@Location",SqlDbType.NVarChar,200),
new SqlParameter("@FansNum",SqlDbType.Int,4),
new SqlParameter("@IsVIP",SqlDbType.Int,4),
new SqlParameter("@OpenId1",SqlDbType.VarChar,100),
new SqlParameter("@Oauth2Token1",SqlDbType.VarChar,100),
new SqlParameter("@Expire1",SqlDbType.DateTime),
new SqlParameter("@CustomerSysNo",SqlDbType.Int,4),
};
if (model.OpenId != AppConst.StringNull)
parameters[0].Value = model.OpenId;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.WB_Name != AppConst.StringNull)
parameters[1].Value = model.WB_Name;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.WB_Nick != AppConst.StringNull)
parameters[2].Value = model.WB_Nick;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.Oauth2Token != AppConst.StringNull)
parameters[3].Value = model.Oauth2Token;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.Expire != AppConst.DateTimeNull)
parameters[4].Value = model.Expire;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
if (model.TS != AppConst.DateTimeNull)
parameters[5].Value = model.TS;
else
parameters[5].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[5]);
if (model.Location != AppConst.StringNull)
parameters[6].Value = model.Location;
else
parameters[6].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[6]);
if (model.FansNum != AppConst.IntNull)
parameters[7].Value = model.FansNum;
else
parameters[7].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[7]);
if (model.IsVIP != AppConst.IntNull)
parameters[8].Value = model.IsVIP;
else
parameters[8].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[8]);
if (model.OpenId1 != AppConst.StringNull)
parameters[9].Value = model.OpenId1;
else
parameters[9].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[9]);
if (model.Oauth2Token1 != AppConst.StringNull)
parameters[10].Value = model.Oauth2Token1;
else
parameters[10].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[10]);
if (model.Expire1 != AppConst.DateTimeNull)
parameters[11].Value = model.Expire1;
else
parameters[11].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[11]);
if (model.CustomerSysNo != AppConst.IntNull)
parameters[12].Value = model.CustomerSysNo;
else
parameters[12].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[12]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(QQWeiBoUserMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Apps.dbo.QQWeiBoUser set ");
strSql.Append("OpenId=@OpenId,");
strSql.Append("WB_Name=@WB_Name,");
strSql.Append("WB_Nick=@WB_Nick,");
strSql.Append("Oauth2Token=@Oauth2Token,");
strSql.Append("Expire=@Expire,");
strSql.Append("TS=@TS,");
strSql.Append("Location=@Location,");
strSql.Append("FansNum=@FansNum,");
strSql.Append("IsVIP=@IsVIP,");
strSql.Append("OpenId1=@OpenId1,");
strSql.Append("Oauth2Token1=@Oauth2Token1,");
strSql.Append("Expire1=@Expire1,");
strSql.Append("CustomerSysNo=@CustomerSysNo");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@SysNo",SqlDbType.Int,4),
new SqlParameter("@OpenId",SqlDbType.VarChar,100),
new SqlParameter("@WB_Name",SqlDbType.VarChar,100),
new SqlParameter("@WB_Nick",SqlDbType.NVarChar,200),
new SqlParameter("@Oauth2Token",SqlDbType.VarChar,100),
new SqlParameter("@Expire",SqlDbType.DateTime),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@Location",SqlDbType.NVarChar,200),
new SqlParameter("@FansNum",SqlDbType.Int,4),
new SqlParameter("@IsVIP",SqlDbType.Int,4),
new SqlParameter("@OpenId1",SqlDbType.VarChar,100),
new SqlParameter("@Oauth2Token1",SqlDbType.VarChar,100),
new SqlParameter("@Expire1",SqlDbType.DateTime),
new SqlParameter("@CustomerSysNo",SqlDbType.Int,4)
};
if (model.SysNo != AppConst.IntNull)
parameters[0].Value = model.SysNo;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.OpenId != AppConst.StringNull)
parameters[1].Value = model.OpenId;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.WB_Name != AppConst.StringNull)
parameters[2].Value = model.WB_Name;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.WB_Nick != AppConst.StringNull)
parameters[3].Value = model.WB_Nick;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.Oauth2Token != AppConst.StringNull)
parameters[4].Value = model.Oauth2Token;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
if (model.Expire != AppConst.DateTimeNull)
parameters[5].Value = model.Expire;
else
parameters[5].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[5]);
if (model.TS != AppConst.DateTimeNull)
parameters[6].Value = model.TS;
else
parameters[6].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[6]);
if (model.Location != AppConst.StringNull)
parameters[7].Value = model.Location;
else
parameters[7].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[7]);
if (model.FansNum != AppConst.IntNull)
parameters[8].Value = model.FansNum;
else
parameters[8].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[8]);
if (model.IsVIP != AppConst.IntNull)
parameters[9].Value = model.IsVIP;
else
parameters[9].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[9]);
if (model.OpenId1 != AppConst.StringNull)
parameters[10].Value = model.OpenId1;
else
parameters[10].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[10]);
if (model.Oauth2Token1 != AppConst.StringNull)
parameters[11].Value = model.Oauth2Token1;
else
parameters[11].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[11]);
if (model.Expire1 != AppConst.DateTimeNull)
parameters[12].Value = model.Expire1;
else
parameters[12].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[12]);
if (model.CustomerSysNo != AppConst.IntNull)
parameters[13].Value = model.CustomerSysNo;
else
parameters[13].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[13]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public QQWeiBoUserMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, OpenId, WB_Name, WB_Nick, Oauth2Token, Expire, TS, Location, FansNum, IsVIP, OpenId1, Oauth2Token1, Expire1, CustomerSysNo from Apps.dbo.QQWeiBoUser");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters = {
new SqlParameter("@SysNo", SqlDbType.Int,4 )
};
parameters[0].Value = SysNo;
QQWeiBoUserMod model = new QQWeiBoUserMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
model.OpenId = ds.Tables[0].Rows[0]["OpenId"].ToString();
model.WB_Name = ds.Tables[0].Rows[0]["WB_Name"].ToString();
model.WB_Nick = ds.Tables[0].Rows[0]["WB_Nick"].ToString();
model.Oauth2Token = ds.Tables[0].Rows[0]["Oauth2Token"].ToString();
if (ds.Tables[0].Rows[0]["Expire"].ToString() != "")
{
model.Expire = DateTime.Parse(ds.Tables[0].Rows[0]["Expire"].ToString());
}
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
model.Location = ds.Tables[0].Rows[0]["Location"].ToString();
if (ds.Tables[0].Rows[0]["FansNum"].ToString() != "")
{
model.FansNum = int.Parse(ds.Tables[0].Rows[0]["FansNum"].ToString());
}
if (ds.Tables[0].Rows[0]["IsVIP"].ToString() != "")
{
model.IsVIP = int.Parse(ds.Tables[0].Rows[0]["IsVIP"].ToString());
}
model.OpenId1 = ds.Tables[0].Rows[0]["OpenId1"].ToString();
model.Oauth2Token1 = ds.Tables[0].Rows[0]["Oauth2Token1"].ToString();
if (ds.Tables[0].Rows[0]["Expire1"].ToString() != "")
{
model.Expire1 = DateTime.Parse(ds.Tables[0].Rows[0]["Expire1"].ToString());
}
if (ds.Tables[0].Rows[0]["CustomerSysNo"].ToString() != "")
{
model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(QQWeiBoUserMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Apps.dbo.QQWeiBoUser(");
strSql.Append("OpenId,WB_Name,WB_Nick,Oauth2Token,Expire,TS,Location,FansNum,IsVIP,OpenId1,Oauth2Token1,Expire1,CustomerSysNo)");
strSql.Append(" values (");
strSql.Append("@OpenId,@WB_Name,@WB_Nick,@Oauth2Token,@Expire,@TS,@Location,@FansNum,@IsVIP,@OpenId1,@Oauth2Token1,@Expire1,@CustomerSysNo)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@OpenId", SqlDbType.VarChar, 100),
new SqlParameter("@WB_Name", SqlDbType.VarChar, 100),
new SqlParameter("@WB_Nick", SqlDbType.NVarChar, 200),
new SqlParameter("@Oauth2Token", SqlDbType.VarChar, 100),
new SqlParameter("@Expire", SqlDbType.DateTime),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@Location", SqlDbType.NVarChar, 200),
new SqlParameter("@FansNum", SqlDbType.Int, 4),
new SqlParameter("@IsVIP", SqlDbType.Int, 4),
new SqlParameter("@OpenId1", SqlDbType.VarChar, 100),
new SqlParameter("@Oauth2Token1", SqlDbType.VarChar, 100),
new SqlParameter("@Expire1", SqlDbType.DateTime),
new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4),
};
if (model.OpenId != AppConst.StringNull)
{
parameters[0].Value = model.OpenId;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.WB_Name != AppConst.StringNull)
{
parameters[1].Value = model.WB_Name;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.WB_Nick != AppConst.StringNull)
{
parameters[2].Value = model.WB_Nick;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.Oauth2Token != AppConst.StringNull)
{
parameters[3].Value = model.Oauth2Token;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.Expire != AppConst.DateTimeNull)
{
parameters[4].Value = model.Expire;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[5].Value = model.TS;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.Location != AppConst.StringNull)
{
parameters[6].Value = model.Location;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.FansNum != AppConst.IntNull)
{
parameters[7].Value = model.FansNum;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.IsVIP != AppConst.IntNull)
{
parameters[8].Value = model.IsVIP;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
if (model.OpenId1 != AppConst.StringNull)
{
parameters[9].Value = model.OpenId1;
}
else
{
parameters[9].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[9]);
if (model.Oauth2Token1 != AppConst.StringNull)
{
parameters[10].Value = model.Oauth2Token1;
}
else
{
parameters[10].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[10]);
if (model.Expire1 != AppConst.DateTimeNull)
{
parameters[11].Value = model.Expire1;
}
else
{
parameters[11].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[11]);
if (model.CustomerSysNo != AppConst.IntNull)
{
parameters[12].Value = model.CustomerSysNo;
}
else
{
parameters[12].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[12]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(QQWeiBoUserMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Apps.dbo.QQWeiBoUser set ");
strSql.Append("OpenId=@OpenId,");
strSql.Append("WB_Name=@WB_Name,");
strSql.Append("WB_Nick=@WB_Nick,");
strSql.Append("Oauth2Token=@Oauth2Token,");
strSql.Append("Expire=@Expire,");
strSql.Append("TS=@TS,");
strSql.Append("Location=@Location,");
strSql.Append("FansNum=@FansNum,");
strSql.Append("IsVIP=@IsVIP,");
strSql.Append("OpenId1=@OpenId1,");
strSql.Append("Oauth2Token1=@Oauth2Token1,");
strSql.Append("Expire1=@Expire1,");
strSql.Append("CustomerSysNo=@CustomerSysNo");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4),
new SqlParameter("@OpenId", SqlDbType.VarChar, 100),
new SqlParameter("@WB_Name", SqlDbType.VarChar, 100),
new SqlParameter("@WB_Nick", SqlDbType.NVarChar, 200),
new SqlParameter("@Oauth2Token", SqlDbType.VarChar, 100),
new SqlParameter("@Expire", SqlDbType.DateTime),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@Location", SqlDbType.NVarChar, 200),
new SqlParameter("@FansNum", SqlDbType.Int, 4),
new SqlParameter("@IsVIP", SqlDbType.Int, 4),
new SqlParameter("@OpenId1", SqlDbType.VarChar, 100),
new SqlParameter("@Oauth2Token1", SqlDbType.VarChar, 100),
new SqlParameter("@Expire1", SqlDbType.DateTime),
new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4)
};
if (model.SysNo != AppConst.IntNull)
{
parameters[0].Value = model.SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.OpenId != AppConst.StringNull)
{
parameters[1].Value = model.OpenId;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.WB_Name != AppConst.StringNull)
{
parameters[2].Value = model.WB_Name;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.WB_Nick != AppConst.StringNull)
{
parameters[3].Value = model.WB_Nick;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.Oauth2Token != AppConst.StringNull)
{
parameters[4].Value = model.Oauth2Token;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.Expire != AppConst.DateTimeNull)
{
parameters[5].Value = model.Expire;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[6].Value = model.TS;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.Location != AppConst.StringNull)
{
parameters[7].Value = model.Location;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.FansNum != AppConst.IntNull)
{
parameters[8].Value = model.FansNum;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
if (model.IsVIP != AppConst.IntNull)
{
parameters[9].Value = model.IsVIP;
}
else
{
parameters[9].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[9]);
if (model.OpenId1 != AppConst.StringNull)
{
parameters[10].Value = model.OpenId1;
}
else
{
parameters[10].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[10]);
if (model.Oauth2Token1 != AppConst.StringNull)
{
parameters[11].Value = model.Oauth2Token1;
}
else
{
parameters[11].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[11]);
if (model.Expire1 != AppConst.DateTimeNull)
{
parameters[12].Value = model.Expire1;
}
else
{
parameters[12].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[12]);
if (model.CustomerSysNo != AppConst.IntNull)
{
parameters[13].Value = model.CustomerSysNo;
}
else
{
parameters[13].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[13]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(QQWeiBoUserMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(QQWeiBoUserMod model)
{
return dal.Add(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if ((base.Request.QueryString["openid"] != null) && (base.Request.QueryString["openid"] != ""))
{
this.openid = base.Request.QueryString["openid"];
}
if ((base.Request.QueryString["openkey"] != null) && (base.Request.QueryString["openkey"] != ""))
{
this.openkey = base.Request.QueryString["openkey"];
}
if ((base.Request.QueryString["name"] != null) && (base.Request.QueryString["name"] != ""))
{
this.wb_name = base.Request.QueryString["name"];
}
if ((base.Request.QueryString["oauth2atoken"] != null) && (base.Request.QueryString["oauth2atoken"] != ""))
{
try
{
string[] strArray = base.Request.QueryString["oauth2atoken"].Split(new char[] { '&' });
this.oauth2token = strArray[0].Split(new char[] { '=' })[0];
this.expire = DateTime.Now.AddSeconds((double)int.Parse(strArray[1].Split(new char[] { '=' })[1]));
}
catch
{
}
}
if ((base.Request.QueryString["nick"] != null) && (base.Request.QueryString["nick"] != ""))
{
this.wb_nick = base.Request.QueryString["nick"];
}
if (!base.IsPostBack)
{
this.MultiView1.ActiveViewIndex = 0;
QQWeiBo bo = new QQWeiBo();
QQWeiBoUserMod recordByName = QQWeiBoUserBll.GetInstance().GetRecordByName(this.wb_name);
if (this.openid != "")
{
if (recordByName.SysNo <= 0)
{
string[] strArray2 = (this.oauth2token == "") ? bo.GetUserSimpleInfo(this.openid, this.openkey, base.Request.UserHostAddress, AppEnum.Apps.astrodice).Split(new char[] { '|' }) : bo.GetUserSimpleInfo(this.openid, this.oauth2token, base.Request.UserHostAddress, AppEnum.Apps.astrodice, true).Split(new char[] { '|' });
recordByName.Oauth2Token1 = this.oauth2token;
recordByName.OpenId1 = this.openid;
recordByName.Expire1 = this.expire;
recordByName.WB_Name = this.wb_name;
recordByName.WB_Nick = this.wb_nick;
recordByName.TS = DateTime.Now;
recordByName.Location = strArray2[2];
recordByName.FansNum = int.Parse(strArray2[3]);
recordByName.IsVIP = int.Parse(strArray2[4]);
QQWeiBoUserBll.GetInstance().Add(recordByName);
this.ViewState["userpara"] = strArray2;
}
else if ((recordByName.WB_Name == "") || (recordByName.FansNum == -999999))
{
string[] strArray3 = (this.oauth2token == "") ? bo.GetUserSimpleInfo(this.openid, this.openkey, base.Request.UserHostAddress, AppEnum.Apps.astrodice).Split(new char[] { '|' }) : bo.GetUserSimpleInfo(this.openid, this.oauth2token, base.Request.UserHostAddress, AppEnum.Apps.astrodice, true).Split(new char[] { '|' });
recordByName.Oauth2Token1 = this.oauth2token;
recordByName.OpenId1 = this.openid;
recordByName.Expire1 = this.expire;
recordByName.WB_Name = this.wb_name;
recordByName.WB_Nick = this.wb_nick;
recordByName.Location = strArray3[2];
recordByName.FansNum = int.Parse(strArray3[3]);
recordByName.IsVIP = int.Parse(strArray3[4]);
QQWeiBoUserBll.GetInstance().Update(recordByName);
this.ViewState["userpara"] = strArray3;
}
else
{
string[] strArray4 = (this.oauth2token == "") ? bo.GetUserSimpleInfo(this.openid, this.openkey, base.Request.UserHostAddress, AppEnum.Apps.astrodice).Split(new char[] { '|' }) : bo.GetUserSimpleInfo(this.openid, this.oauth2token, base.Request.UserHostAddress, AppEnum.Apps.astrodice, true).Split(new char[] { '|' });
this.ViewState["userpara"] = strArray4;
}
}
this.ViewState["weibouser"] = recordByName;
if ((this.oauth2token == "") ? bo.CheckFriend(this.openid, this.openkey, base.Request.UserHostAddress, AppEnum.Apps.astrodice) : bo.CheckFriend(this.openid, this.oauth2token, base.Request.UserHostAddress, AppEnum.Apps.astrodice, true))
{
this.nofriend1.Style["display"] = "none";
}
else
{
this.isfriend1.Style["display"] = "none";
}
this.LinkButton8.Style["display"] = "none";
this.LinkButton9.Style["display"] = "none";
this.LinkButton10.Style["display"] = "none";
this.Label1.Text = "<p><b>提问说明：</b><br />★一定要是你很诚心很想知道的事。问题可以是具体的小事，如今天晚上吃什么；也可以是别人的是，某某明星是不是真的有外遇。<br />\r\n ★不要在短时间内重复问一个问题，除非事态已经有了新的变化。<br />\r\n ★问Whether不如问How，骰子不会简单回答Yes或No。如果问“我该跳槽么？”不如问“如果换工作的话前景如何？”</p>\r\n <p><b>特别提示：</b><br />★占星骰子需消耗灵力，建议一天内不要超过3次，否则会降低准确度。<br />\r\n ★骰子给出的结果需要你对行星，星座和宫位的关键字含义进行意会。<br />\r\n ★如无法理解骰子的结果，可以把问题发出，等待专业占星师解答。</p><p style='color:#fffd64;'>若需购买占星骰子实物，请在淘宝搜索“超级占星骰子”</p>";
try
{
GetTopic("");
this.Repeater1.DataSource = this.GetReplys("");
this.Repeater1.DataBind();
}
catch
{
}
}
}
