/// <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 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 { } } }