/// <summary>
/// 向数据库中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_tb_UsersModel">tb_Users实体</param>
/// <returns>新插入记录的编号</returns>
public int Insert(SqlTransaction sp, tb_UsersEntity _tb_UsersModel)
{
string sqlStr = "insert into tb_Users([Phone],[Pwd],[RealName],[Mail],[LocationId],[Addtime],[IdCard],[IdentityType],[OpenID]) values(@Phone,@Pwd,@RealName,@Mail,@LocationId,@Addtime,@IdCard,@IdentityType,@OpenID) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Pwd", SqlDbType.VarChar),
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Mail", SqlDbType.VarChar),
new SqlParameter("@LocationId", SqlDbType.Int),
new SqlParameter("@Addtime", SqlDbType.DateTime),
new SqlParameter("@IdCard", SqlDbType.VarChar),
new SqlParameter("@IdentityType", SqlDbType.Int),
new SqlParameter("@OpenID", SqlDbType.VarChar)
};
_param[0].Value = _tb_UsersModel.Phone;
_param[1].Value = _tb_UsersModel.Pwd;
_param[2].Value = _tb_UsersModel.RealName;
_param[3].Value = _tb_UsersModel.Mail;
_param[4].Value = _tb_UsersModel.LocationId;
_param[5].Value = _tb_UsersModel.Addtime;
_param[6].Value = _tb_UsersModel.IdCard;
_param[7].Value = _tb_UsersModel.IdentityType;
_param[8].Value = _tb_UsersModel.OpenID;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(sp, CommandType.Text, sqlStr, _param));
return(res);
}
protected override void BasePage_Load(tb_UsersEntity user)
{
if (user != null)
{
BindData();
}
}
/// <summary>
/// 向数据表tb_Users更新一条记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_tb_UsersModel">_tb_UsersModel</param>
/// <returns>影响的行数</returns>
public int Update(SqlTransaction sp, tb_UsersEntity _tb_UsersModel)
{
string sqlStr = "update tb_Users set [Phone]=@Phone,[Pwd]=@Pwd,[RealName]=@RealName,[Mail]=@Mail,[LocationId]=@LocationId,[Addtime]=@Addtime,[IdCard]=@IdCard,[IdentityType]=@IdentityType,OpenID=@OpenID where UserId=@UserId";
SqlParameter[] _param =
{
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Pwd", SqlDbType.VarChar),
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Mail", SqlDbType.VarChar),
new SqlParameter("@LocationId", SqlDbType.Int),
new SqlParameter("@Addtime", SqlDbType.DateTime),
new SqlParameter("@IdCard", SqlDbType.VarChar),
new SqlParameter("@IdentityType", SqlDbType.Int),
new SqlParameter("@OpenID", SqlDbType.VarChar),
};
_param[0].Value = _tb_UsersModel.UserId;
_param[1].Value = _tb_UsersModel.Phone;
_param[2].Value = _tb_UsersModel.Pwd;
_param[3].Value = _tb_UsersModel.RealName;
_param[4].Value = _tb_UsersModel.Mail;
_param[5].Value = _tb_UsersModel.LocationId;
_param[6].Value = _tb_UsersModel.Addtime;
_param[7].Value = _tb_UsersModel.IdCard;
_param[8].Value = _tb_UsersModel.IdentityType;
_param[9].Value = _tb_UsersModel.OpenID;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param));
}
protected override void BasePage_Load(tb_UsersEntity user)
{
// PlateNumber = PlateNumber.Replace("+", "%20");
//PlateNumber = System.Web.HttpUtility.UrlDecode(PlateNumber, System.Text.Encoding.GetEncoding("GB2312"));
AutoRepair.Entity.T_AutoInfoEntity model = AutoRepair.BLL.T_AutoInfoBLL.GetInstance().Get_CarinDetailOne(PlateNumber);
if (model != null)
{
PlateColor = model.PlateColor;
VIN = model.VIN;
AutoBrand = model.AutoBrand;
AutoType = model.AutoType;
UnitName = model.UnitName;
LinkMan = model.LinkMan;
Phone = model.Phone;
EngineNumber = model.EngineNumber;
AutoColor = model.AutoColor;
ChassisNumber = model.ChassisNumber;
CardNumber = model.CardNumber;
UnitID = model.UnitID;
UploadTime = model.EnforceInsuranceDate;
n = 1;
}
else
{
n = 0;
}
}
protected override void BasePage_Load(tb_UsersEntity user)
{
if (user != null)
{
DataSet ds = AutoRepair.BLL.tb_EvaluateBLL.GetInstance().GetEvaluationDetail(id);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)
{
Isbool = ds.Tables[0].Rows[0]["AssessCount2"].ToString();
rptEvaluation.DataSource = ds;
rptEvaluation.DataBind();
}
}
}
/// <summary>
/// 得到 tb_users 数据实体
/// </summary>
/// <param name="dr">dr</param>
/// <returns>tb_users 数据实体</returns>
public tb_UsersEntity Populate_tb_UsersEntity_FromDr(IDataReader dr)
{
tb_UsersEntity Obj = new tb_UsersEntity();
Obj.UserId = ((dr["UserId"]) == DBNull.Value)?0:Convert.ToInt32(dr["UserId"]);
Obj.Phone = dr["Phone"].ToString();
Obj.Pwd = dr["Pwd"].ToString();
Obj.RealName = dr["RealName"].ToString();
Obj.Mail = dr["Mail"].ToString();
Obj.LocationId = ((dr["LocationId"]) == DBNull.Value)?0:Convert.ToInt32(dr["LocationId"]);
Obj.Addtime = ((dr["Addtime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["Addtime"]);
Obj.IdCard = dr["IdCard"].ToString();
Obj.IdentityType = ((dr["IdentityType"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["IdentityType"]);
Obj.OpenID = dr["OpenID"].ToString();
return(Obj);
}
protected override void BasePage_Load(tb_UsersEntity user)
{
if (user != null)
{
DataSet ds = AutoRepair.BLL.T_RepairDocumentBLL.GetInstance().GetRepairEvaluationByType(user.OpenID);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)
{
rptRepairList.DataSource = ds;
rptRepairList.DataBind();
}
else
{
record = "<div style=\"font-size:15px;color:#d5d2d2;position:fixed;top:35%;left:30%;\">没有未完成的评价哦~</div>";
}
}
}
/// <summary>
/// 根据ID,返回一个tb_Users对象
/// </summary>
/// <param name="userId">userId</param>
/// <returns>tb_Users对象</returns>
public tb_UsersEntity Get_tb_UsersEntity(int userId)
{
tb_UsersEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@UserId", SqlDbType.Int)
};
_param[0].Value = userId;
string sqlStr = "select * from tb_Users with(nolock) where UserId=@UserId";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.AutoRepairRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_UsersEntity_FromDr(dr);
}
}
return(_obj);
}
protected override void BasePage_Load(tb_UsersEntity user)
{
if (user != null)
{
AutoRepair.Entity.T_RepairDocumentEntity model = AutoRepair.BLL.T_RepairDocumentBLL.GetInstance().GetAdminSingle(id);
if (model != null)
{
UnitName = model.UnitName;
UnitPhone = model.UnitPhone;
UnitAddress = model.UnitAddress;
RepairNumber = model.RepairNumber;
PlateNumber = model.PlateNumber;
CarColor = model.CarColor;
AutoType = model.AutoType;
SignDate = model.SignDate;
FinishDate = model.FinishDate;
TotalMoney = model.TotalMoney;
}
}
}
public tb_UsersEntity GetModelByOpenId(string openid)
{
tb_UsersEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@OpenId", SqlDbType.VarChar)
};
_param[0].Value = openid;
string sqlStr = "select * from tb_Users with(nolock) where OpenID = @OpenID";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.AutoRepairRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_UsersEntity_FromDr(dr);
}
}
return(_obj);
}
/// <summary>
/// 得到 tb_users 数据实体
/// </summary>
/// <param name="row">row</param>
/// <returns>tb_users 数据实体</returns>
public tb_UsersEntity Populate_tb_UsersEntity_FromDr(DataRow row)
{
tb_UsersEntity Obj = new tb_UsersEntity();
if (row != null)
{
Obj.UserId = ((row["UserId"]) == DBNull.Value)?0:Convert.ToInt32(row["UserId"]);
Obj.Phone = row["Phone"].ToString();
Obj.Pwd = row["Pwd"].ToString();
Obj.RealName = row["RealName"].ToString();
Obj.Mail = row["Mail"].ToString();
Obj.LocationId = ((row["LocationId"]) == DBNull.Value)?0:Convert.ToInt32(row["LocationId"]);
Obj.Addtime = ((row["Addtime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["Addtime"]);
Obj.IdCard = row["IdCard"].ToString();
Obj.IdentityType = ((row["IdentityType"]) == DBNull.Value)?0:Convert.ToInt32(row["IdentityType"]);
Obj.OpenID = row["OpenID"].ToString();
}
else
{
return(null);
}
return(Obj);
}
protected override void OnInit(EventArgs e)
{
shopid = int.Parse(Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("shopid"));
appid = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("appid");
secret = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("secret");
weixincode = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("weixincode");
sitepath = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("sitepath");
tb_UsersEntity user = null;
Jnwf.Model.tb_App_UserEntity app_user = null;
//检查cookie
string ticket = "";
string disney = CookieHelper.GetCookieValue("disney");
if (!string.IsNullOrEmpty(disney))
{
jinru = "cookie";
Jnwf.Utils.Log.Logger.Log4Net.Error("BasePage,jinru:" + jinru);
ticket = Jnwf.Utils.Helper.DESEncrypt.Decrypt(disney);
//Jnwf.Utils.Log.Logger.Log4Net.Error("basepage,cookie:" + ticket);
user = AutoRepair.BLL.tb_UsersBLL.GetInstance().GetModelByOpenId(ticket);
app_user = Jnwf.BLL.tb_App_UserBLL.GetInstance().GetModelByOpenId(ticket);
if (app_user == null)
{
try
{
Response.Redirect("http://mp.weixin.qq.com/s?__biz=MzI4MzE0ODM1Nw==&mid=402172802&idx=1&sn=c66fe86ffd6b8c8cb73bd3033c1d2903#rd");
}
catch (System.Threading.ThreadAbortException ex)
{ }
}
else if (user == null)
{
try
{
Response.Redirect(sitepath + "Registered.aspx");
}
catch (System.Threading.ThreadAbortException ex)
{ }
}
else
{
this.OnBasePageLoad(user);
}
}
else if (!string.IsNullOrEmpty(Code))
{
jinru = "code";
Jnwf.Utils.Log.Logger.Log4Net.Error("BasePage,jinru:" + jinru);
string url = "https://api.weixin.qq.com/sns/oauth2/access_token?appid=" + appid + "&secret=" + secret + "&code=" + Code + "&grant_type=authorization_code";
string json = Jnwf.Utils.Helper.HttpHelper.LoadPageContent(url);
if (json.IndexOf("errcode") >= 0)
{
Jnwf.Utils.Log.Logger.Log4Net.Error("Results.aspx:" + json);
}
else
{
wx_OpenInfoEntity info = Jnwf.Utils.Json.JsonHelper.DeserializeJson <wx_OpenInfoEntity>(json);
string str = info.openid;
//Jnwf.Utils.Log.Logger.Log4Net.Error("basepage,code:" + str);
CookieHelper.SetCookie("disney", Jnwf.Utils.Helper.DESEncrypt.Encrypt(str));
user = AutoRepair.BLL.tb_UsersBLL.GetInstance().GetModelByOpenId(info.openid);
app_user = Jnwf.BLL.tb_App_UserBLL.GetInstance().GetModelByOpenId(info.openid);
if (app_user == null)
{
try
{
Response.Redirect("http://mp.weixin.qq.com/s?__biz=MzI4MzE0ODM1Nw==&mid=402172802&idx=1&sn=c66fe86ffd6b8c8cb73bd3033c1d2903#rd");
}
catch (System.Threading.ThreadAbortException ex)
{ }
}
else if (user == null)
{
try
{
Response.Redirect(sitepath + "Registered.aspx");
}
catch (System.Threading.ThreadAbortException ex)
{ }
}
else
{
this.OnBasePageLoad(user);
}
}
}
else
{
jinru = "url";
Jnwf.Utils.Log.Logger.Log4Net.Error("BasePage,jinru:" + jinru);
//string host = this.Request.Url.Host;
//string path = this.Request.Path;
//string redirect_uri = HttpUtility.UrlEncode("http://" + host + path);
string redirect_uri = HttpUtility.UrlEncode(this.Request.Url.ToString());
Dictionary <string, string> data = new Dictionary <string, string>();
data.Add("appid", appid);
data.Add("redirect_uri", redirect_uri);
data.Add("response_type", "code");
data.Add("scope", "snsapi_base");
string temp_url = "https://open.weixin.qq.com/connect/oauth2/authorize?";
foreach (var dic in data)
{
temp_url += dic.Key + "=" + dic.Value + "&";
}
//Jnwf.Utils.Log.Logger.Log4Net.Error("detail:" + temp_url);
try
{
//触发微信返回code码
this.Response.Redirect(temp_url.TrimEnd('&'));//Redirect函数会抛出ThreadAbortException异常，不用处理这个异常
}
catch (System.Threading.ThreadAbortException ex)
{
}
}
base.OnInit(e);
}
protected virtual void BasePage_Load(tb_UsersEntity user)
{
}
public void Update(tb_UsersEntity tb_UsersEntity)
{
tb_Usersdal.Update(tb_UsersEntity);
}
public int Insert(tb_UsersEntity tb_UsersEntity)
{
return(tb_Usersdal.Insert(tb_UsersEntity));
}
