/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.user_tree model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"UPDATE ybd_user_tree SET
user_id = @user_id
,code = @code
,parent_code = @parent_code
,grand_code = @grand_code
WHERE id = @id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
, new SqlParameter("@user_id", SqlDbType.Int, 4)
, new SqlParameter("@code", SqlDbType.NVarChar, 10)
, new SqlParameter("@parent_code", SqlDbType.NVarChar, 10)
, new SqlParameter("@grand_code", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.id;
parameters[1].Value = model.user_id;
parameters[2].Value = model.code;
parameters[3].Value = model.parent_code;
parameters[4].Value = model.grand_code;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.user_tree DataRowToModel(DataRow row)
{
Model.user_tree model = new Model.user_tree();
if (row != null)
{
if (row["id"] != null) //&& row["id"].ToString() != ""
{
model.id = Convert.ToInt32(row["id"]);
}
if (row["user_id"] != null) //&& row["user_id"].ToString() != ""
{
model.user_id = Convert.ToInt32(row["user_id"]);
}
if (row["code"] != null) //&& row["code"].ToString() != ""
{
model.code = Convert.ToString(row["code"]);
}
if (row["parent_code"] != null) //&& row["parent_code"].ToString() != ""
{
model.parent_code = Convert.ToString(row["parent_code"]);
}
if (row["grand_code"] != null) //&& row["grand_code"].ToString() != ""
{
model.grand_code = Convert.ToString(row["grand_code"]);
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获得Model
/// </summary>
/// <param name="Top">大于0取前几行数据，否则取全部</param>
/// <param name="whereStr">where条件</param>
/// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param>
/// <returns></returns>
public Model.user_tree GetModel(int Top, string whereStr, string filedOrder)
{
DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0];
Model.user_tree model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
/// <summary>
/// 获得Model
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public Model.user_tree GetModel(string whereStr)
{
DataTable dt = dal.GetList(whereStr).Tables[0];
Model.user_tree model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
private void BindInfo()
{
BLL.user_tree bll = new BLL.user_tree();
Model.user_tree model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
txtuser_id.Text = model.user_id + "";
txtcode.Text = model.code + "";
txtparent_code.Text = model.parent_code + "";
txtgrand_code.Text = model.grand_code + "";
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_user_tree", EnumCollection.ActionEnum.Add.ToString()); //检查权限
#region
string strError = string.Empty;
if (txtuser_id.Text.Trim() == "" || txtuser_id.Text.Trim().Length > 4)
{
strError += "用户ID为空或超出长度![br]";
}
if (txtcode.Text.Trim() == "" || txtcode.Text.Trim().Length > 10)
{
strError += "唯一标识code为空或超出长度![br]";
}
if (txtparent_code.Text.Trim() == "" || txtparent_code.Text.Trim().Length > 10)
{
strError += "父级code为空或超出长度![br]";
}
if (txtgrand_code.Text.Trim() == "" || txtgrand_code.Text.Trim().Length > 10)
{
strError += "父级的父级code为空或超出长度![br]";
}
if (strError != string.Empty)
{
JscriptMsg(strError, "", "Error");
return;
}
#endregion
Model.user_tree model = new Model.user_tree();
BLL.user_tree bll = new BLL.user_tree();
model.user_id = Convert.ToInt32(txtuser_id.Text);
model.code = Convert.ToString(txtcode.Text);
model.parent_code = Convert.ToString(txtparent_code.Text);
model.grand_code = Convert.ToString(txtgrand_code.Text);
int id = bll.Add(model);
if (id > 0)
{
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加用户关系信息，主键:" + id); //记录日志
JscriptMsg("添加用户关系信息成功！", "Manage.aspx", "");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_user_tree", EnumCollection.ActionEnum.Modify.ToString()); //检查权限
BLL.user_tree bll = new BLL.user_tree();
Model.user_tree model = bll.GetModel(this.id);
model.user_id = Convert.ToInt32(txtuser_id.Text);
model.code = Convert.ToString(txtcode.Text);
model.parent_code = Convert.ToString(txtparent_code.Text);
model.grand_code = Convert.ToString(txtgrand_code.Text);
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改用户关系信息，主键:" + id); //记录日志
JscriptMsg("修改用户关系信息成功！", "Manage.aspx");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("_user_list", EnumCollection.ActionEnum.Delete.ToString()); //检查权限
int sucCount = 0;
int errorCount = 0;
BLL.user_info bll = new BLL.user_info();
BLL.user_oauths oBll = new BLL.user_oauths();
BLL.user_tree tBll = new BLL.user_tree();
Model.user_oauths uoModel = null;
Model.user_tree utModel = null;
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
uoModel = oBll.GetModel(" user_id = " + id);
utModel = tBll.GetModel(" user_id = " + id);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
if (bll.Delete(id))
{
if (uoModel != null)
{
oBll.Delete(uoModel.id);
}
if (utModel != null)
{
tBll.Delete(utModel.id);
}
sucCount += 1;
}
else
{
errorCount += 1;
}
}
}
AddAdminLog(EnumCollection.ActionEnum.Delete.ToString(), "删除用户信息" + sucCount + "条，失败" + errorCount + "条"); //记录日志
JscriptMsg("删除成功" + sucCount + "条，失败" + errorCount + "条！", Utils.CombUrlTxt("user_list.aspx", "keywords={0}", this.keywords));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_tree model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert Into ybd_user_tree(
user_id
,code
,parent_code
,grand_code
) Values (
@user_id
,@code
,@parent_code
,@grand_code
);
SELECT @@IDENTITY;");
SqlParameter[] parameters =
{
new SqlParameter("@user_id", SqlDbType.Int, 4)
, new SqlParameter("@code", SqlDbType.NVarChar, 10)
, new SqlParameter("@parent_code", SqlDbType.NVarChar, 10)
, new SqlParameter("@grand_code", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.code;
parameters[2].Value = model.parent_code;
parameters[3].Value = model.grand_code;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void Page_Load(object sender, EventArgs e)
{
string source_url = Request.QueryString["source_url"];
string code = Request.QueryString["code"];
string state = Request.QueryString["state"];
if (!string.IsNullOrEmpty(source_url))
{
string location = Request.RawUrl;
int index = location.IndexOf('=');
source_url = location.Substring(index + 1, location.Length - index - 1);
source_url = source_url.Replace('&', '*');
Utils.StringToTxt("wxOAuth_WeChat_GetCode————source_url==" + source_url);
Utils.WriteCookie("wxOAuth_WeChatGrant", "True");
string url = WeChatContext.GetRedirectCode("/html/wxOAuth.aspx", source_url, true);
Response.Redirect(url);
}
else if (!string.IsNullOrEmpty(code))
{
string temp = Utils.UrlDecode(state);
string decodeurl = temp.Replace('*', '&');
Utils.StringToTxt("wxOAuth_wxLogin————code==" + code + ";wxOAuth_state==" + decodeurl);
WeiXin_Access_token access_token = WeChatContext.GetAccessModel(code);
if (access_token != null)
{
SnsapiUserInfo userInfo = WeChatContext.GetSnsapiUserInfo(access_token.Access_token, access_token.Openid);//获取用户信息
if (userInfo != null)
{
user_info_entity entity = new user_info_entity();
//公众号openid存在
Model.user_oauths oaModel = new BLL.user_oauths().GetModel(" appid = '" + access_token.Openid + "'");
if (oaModel != null)
{
try
{
Utils.StringToTxt("wxOAuth_wxLogin————公众号openid存在，则更新openID=" + access_token.Openid + "和unionID=" + userInfo.unionid);
Model.user_info model = new BLL.user_info().GetModel(oaModel.user_id);
Utils.StringToTxt("wxOAuth_wxLogin————用户信息：" + Newtonsoft.Json.JsonConvert.SerializeObject(model));
Utils.StringToTxt("wxOAuth_wxLogin————认证信息：" + Newtonsoft.Json.JsonConvert.SerializeObject(oaModel));
//更新unionid(多应用唯一识别码)
oaModel.appid = userInfo.openid;
oaModel.unionid = userInfo.unionid;
new BLL.user_oauths().Update(oaModel);
if (model.school_id == 0)//没有学校，公共资源
{
decodeurl += "&method=scan";
Response.Redirect(decodeurl);
}
else//有学校，学校资源
{
int idindex = decodeurl.IndexOf('=');
string id = decodeurl.Substring(idindex + 1, decodeurl.Length - idindex - 1);
BLL.common_resource resBll = new BLL.common_resource();
Model.common_resource res = resBll.GetModel(Convert.ToInt32(id));
if (res != null)
{
if (res.from_id == (int)EnumCollection.resource_from.精品微课) //如果是精品微课的资源
{
if (res.group_id == (int)EnumCollection.resource_group.公共资源) //若此资源是公共资源，查询此章节下的学校资源
{
Model.common_resource newRes = resBll.GetModel(string.Format(" from_id = {0} and group_id = {1} and type = {2} and data_id = {3}",
res.from_id, (int)EnumCollection.resource_group.学校资源, res.type, res.data_id));
if (newRes != null)
{
decodeurl = decodeurl.Replace("id=" + id, "id=" + newRes.id);
Utils.StringToTxt("wxOAuth_wxLogin————学校资源=" + decodeurl);
}
decodeurl += "&method=scan";
Response.Redirect(decodeurl);
}
else if (res.group_id == (int)EnumCollection.resource_group.学校资源)//若此资源是学校资源，判断是否是本学校的
{
if (model.school_id != res.school_id)
{
Response.Write("您没有权限查看此资源");
}
else
{
decodeurl += "&method=scan";
Response.Redirect(decodeurl);
}
}
}
else if (res.from_id == (int)EnumCollection.resource_from.课堂)//如果是课堂的资源
{
decodeurl += "&method=scan";
Response.Redirect(decodeurl);
}
}
else
{
decodeurl += "&method=scan";
Response.Redirect(decodeurl);
}
}
}
catch (Exception ex)
{
Utils.StringToTxt("wxOAuth_wxLogin————获取数据库用户信息出现异常：" + ex.Message);
Response.Write("获取数据库用户信息出现异常：" + ex.Message);
return;
}
}
else//不存在
{
if (Utils.GetCookie("wxOAuth_WeChatGrant") == "True")
{
Utils.WriteCookie("wxOAuth_WeChatGrant", "False");
Utils.StringToTxt("wxOAuth_wxLogin————公众号openid不存在，是全新用户");
#region 创建用户
Model.user_info model = new Model.user_info();
model.group_id = (int)EnumCollection.user_group.普通用户;
model.user_name = "";
model.phone = "";
model.salt = Utils.GetCheckCode(6);
model.user_pwd = "";
model.nick_name = userInfo.nickname;
model.avatar = userInfo.headimgurl;
model.integral = 0;
model.school_id = 0;
model.school_name = "";
model.college = "";
model.job = "";
model.course = "";
model.line_way = "";
model.area = userInfo.country + userInfo.province + userInfo.city;
model.address = "";
model.reg_ip = RequestHelper.GetIP();
model.add_time = System.DateTime.Now;
BLL.user_info bll = new BLL.user_info();
int row = bll.Add(model);
if (row > 0)
{
model.id = row;
entity.UserInfo = model;
entity.UserInfo.user_pwd = "";
entity.UserInfo.salt = "";
entity.UserInfo.reg_ip = "";
BLL.user_tree tBll = new BLL.user_tree();
//1 创建code
string tree_code = string.Empty;
do
{
tree_code = Utils.Number(6);
} while (tBll.GetModel(" code = '" + tree_code + "'") != null);
//添加关系
#region 添加关系
Model.user_tree tree = new Model.user_tree();
tree.user_id = row;
tree.code = tree_code;
tree.parent_code = "0";
tree.grand_code = "0";
int treeid = tBll.Add(tree);
if (treeid > 0)
{
tree.id = treeid;
entity.UserTree = tree;
}
#endregion
#region 添加认证信息
Utils.StringToTxt("wxOAuth_wxLogin————用户信息：" + Newtonsoft.Json.JsonConvert.SerializeObject(model));
Model.user_oauths model1 = new Model.user_oauths();
model1.user_id = row;
model1.type = (int)EnumCollection.user_oauths.公众号微信登录;
model1.name = EnumCollection.user_oauths.公众号微信登录.ToString();
model1.appid = userInfo.openid;
model1.unionid = userInfo.unionid;
int oaid = new BLL.user_oauths().Add(model1);
if (row > 0)
{
model1.id = row;
entity.UserOAuths = model1;
Utils.StringToTxt("wxOAuth_wxLogin————新增的认证信息：" + Newtonsoft.Json.JsonConvert.SerializeObject(model1));
}
#endregion
Response.Redirect(decodeurl);
return;
}
else
{
Utils.WriteCookie("wxOAuth_WeChatGrant", "True");
string url = WeChatContext.GetRedirectCode("/html/wxOAuth.aspx", state, true);
Response.Redirect(url);
return;
}
#endregion
}
else
{
Utils.WriteCookie("wxOAuth_WeChatGrant", "True");
string url = WeChatContext.GetRedirectCode("/html/wxOAuth.aspx", state, true);
Response.Redirect(url);
return;
}
}
}
else
{
Response.Write("微信认证失败，请重试");
return;
}
}
else
{
Response.Write("token获取失败");
return;
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.user_tree model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_tree model)
{
return(dal.Add(model));
}
