private bool DoEdit(int id)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(id);
model.from_id = (int)EnumCollection.resource_from.课堂;
model.group_id = (int)EnumCollection.resource_group.公共资源;
model.type = (int)EnumCollection.resource_type.图文资源;
model.school_id = 0;
model.school_name = "";
model.data_id = class_id;
model.user_id = user_id;
model.title = Convert.ToString(txttitle.Text.Trim());
model.cover = "";
model.path = Convert.ToString(txtcontents.Text.Trim());
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
model.file_name = "";
model.extend = "";
model.likn_url = "";
model.share_user = "";
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改课堂知识点信息，主键:" + id); //记录日志
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得Model
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public Model.common_resource GetModel(string whereStr)
{
DataTable dt = dal.GetList(whereStr).Tables[0];
Model.common_resource model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
private bool DoEdit(int id)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(id);
model.from_id = (int)EnumCollection.resource_from.课堂;
model.group_id = (int)EnumCollection.resource_group.公共资源;
model.type = (int)EnumCollection.resource_type.视频资源;
model.school_id = 0;
model.school_name = "";
model.data_id = class_id;
model.user_id = admin_info.id;
model.title = getStr(this.hdfVal.Value, 1);
model.cover = this.txtcover.Text.Trim();
model.path = this.txtpath.Text.Trim();
model.file_name = this.hdfVal.Value;
model.extend = getStr(this.hdfVal.Value, 2);
model.likn_url = "";
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
model.share_user = "";
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改课堂视频资源信息，主键:" + id); //记录日志
return(true);
}
else
{
return(false);
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_common_resource", EnumCollection.ActionEnum.Modify.ToString()); //检查权限
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(this.id);
model.from_id = Convert.ToInt32(txtfrom_id.Text);
model.group_id = Convert.ToInt32(txtgroup_id.Text);
model.type = Convert.ToInt32(txttype.Text);
model.school_id = Convert.ToInt32(txtschool_id.Text);
model.school_name = Convert.ToString(txtschool_name.Text);
model.data_id = Convert.ToInt32(txtdata_id.Text);
model.user_id = Convert.ToInt32(txtuser_id.Text);
model.title = Convert.ToString(txttitle.Text);
model.cover = Convert.ToString(txtcover.Text);
model.path = Convert.ToString(txtpath.Text);
model.qrcode = Convert.ToString(txtqrcode.Text);
model.file_name = Convert.ToString(txtfile_name.Text);
model.extend = Convert.ToString(txtextend.Text);
model.likn_url = Convert.ToString(txtlikn_url.Text);
model.share_user = Convert.ToString(txtshare_user.Text);
model.sort = Convert.ToInt32(txtsort.Text);
model.add_time = Convert.ToDateTime(txtadd_time.Text);
model.is_del = Convert.ToInt32(txtis_del.Text);
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改资源信息信息，主键:" + id); //记录日志
JscriptMsg("修改资源信息信息成功！", "Manage.aspx");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
private void SaveClassroomResource()
{
int class_id = RequestHelper.GetFormInt("class_id");
string ids = RequestHelper.GetFormString("ids");
string[] idArr = ids.Split(',');
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = null;
Model.common_resource newModel = null;
for (int i = 0; i < idArr.Length; i++)
{
int id = Convert.ToInt32(idArr[i]);
model = bll.GetModel(id);
if (model != null)
{
newModel = model;
newModel.id = 0;
newModel.from_id = (int)EnumCollection.resource_from.课堂;
newModel.data_id = class_id;
bll.Add(newModel);
}
}
writeMsgSuccess("成功");
}
private void SetCaseIsShow()
{
int id = RequestHelper.GetFormInt("id");
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(id);
if (model != null)
{
if (model.is_del == (int)EnumCollection.YesOrNot.是)
{
model.is_del = (int)EnumCollection.YesOrNot.否;
}
else
{
model.is_del = (int)EnumCollection.YesOrNot.是;
}
bll.Update(model);
HttpContext.Current.Response.Write("1");
HttpContext.Current.Response.End();
}
else
{
HttpContext.Current.Response.Write("0");
HttpContext.Current.Response.End();
}
}
private void BindInfo()
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
txtfrom_id.Text = model.from_id + "";
txtgroup_id.Text = model.group_id + "";
txttype.Text = model.type + "";
txtschool_id.Text = model.school_id + "";
txtschool_name.Text = model.school_name + "";
txtdata_id.Text = model.data_id + "";
txtuser_id.Text = model.user_id + "";
txttitle.Text = model.title + "";
txtcover.Text = model.cover + "";
txtpath.Text = model.path + "";
txtqrcode.Text = model.qrcode + "";
txtfile_name.Text = model.file_name + "";
txtextend.Text = model.extend + "";
txtlikn_url.Text = model.likn_url + "";
txtshare_user.Text = model.share_user + "";
txtsort.Text = model.sort + "";
txtadd_time.Text = model.add_time + "";
txtis_del.Text = model.is_del + "";
}
/// <summary>
/// 获得Model
/// </summary>
/// <param name="Top">大于0取前几行数据，否则取全部</param>
/// <param name="whereStr">where条件</param>
/// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param>
/// <returns></returns>
public Model.common_resource GetModel(int Top, string whereStr, string filedOrder)
{
DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0];
Model.common_resource model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
private void ShowInfo(int _id)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
this.txtpath.Text = model.path + "";
this.hdfVal.Value = model.title + "." + model.extend;
}
private void ShowInfo(int _id)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
this.txttitle.Text = model.title + "";
this.txtcontents.Text = model.path + "";
}
private bool DoAdd()
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = new Model.common_resource();
model.from_id = (int)EnumCollection.resource_from.课堂;
model.group_id = (int)EnumCollection.resource_group.公共资源;
model.type = (int)EnumCollection.resource_type.图文资源;
model.school_id = 0;
model.school_name = "";
model.data_id = class_id;
model.user_id = user_id;
model.title = Convert.ToString(txttitle.Text.Trim());
model.cover = "";
model.path = Convert.ToString(txtcontents.Text.Trim());
model.qrcode = "";
model.file_name = "";
model.extend = "";
model.likn_url = "";
model.share_user = "";
model.add_time = System.DateTime.Now;
Model.common_resource maxModel = bll.GetModel(" from_id = " + model.from_id + " and group_id = " + model.group_id + " and type = " + model.type + " and data_id = " + class_id + " order by sort desc ");
if (maxModel != null)
{
model.sort = maxModel.sort + 1;
}
else
{
model.sort = 1;
}
int id = bll.Add(model);
if (id > 0)
{
model.id = id;
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
bll.Update(model);
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加课堂知识点信息，主键:" + id); //记录日志
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int _id)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
this.rbtnGroup.SelectedValue = model.group_id + "";
this.rbtnType.SelectedValue = model.type + "";
if (model.type == (int)EnumCollection.resource_type.图文资源)
{
this.txttitle.Text = model.title + "";
this.txtcontents.Text = model.path + "";
}
else
{
this.txtpath.Text = model.path + "";
this.hdfVal.Value = model.title + "." + model.extend;
}
if (model.group_id == (int)EnumCollection.resource_group.共享资源)
{
string[] uidArr = model.share_user.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < this.ckbUser.Items.Count; i++)
{
for (int n = 0; n < uidArr.Length; n++)
{
if (uidArr[n] == this.ckbUser.Items[i].Value)
{
this.ckbUser.Items[i].Selected = true;
}
}
}
}
}
private bool DoEdit(int id)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(id);
model.from_id = (int)EnumCollection.resource_from.课堂;
model.group_id = (int)EnumCollection.resource_group.公共资源;
model.type = (int)EnumCollection.resource_type.文档资源;
model.school_id = 0;
model.school_name = "";
model.data_id = class_id;
model.user_id = user_id;
string fileNames = Utils.DelLastChar(this.hdfVal.Value, "|");
string path = Utils.DelLastChar(this.txtpath.Text, "|");
string[] files = fileNames.Split('|');
string[] paths = path.Split('|');
model.title = getStr(files[0], 1);
model.cover = "";
model.path = paths[0];
model.file_name = files[0];
model.extend = getStr(files[0], 2);
model.likn_url = "";
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
model.share_user = "";
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改资源信息，主键:" + id); //记录日志
return(true);
}
else
{
return(false);
}
}
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 int Add(Model.common_resource model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert Into ybd_common_resource(
from_id
,group_id
,type
,school_id
,school_name
,data_id
,user_id
,title
,cover
,path
,qrcode
,file_name
,extend
,likn_url
,share_user
,sort
,add_time
,is_del
) Values (
@from_id
,@group_id
,@type
,@school_id
,@school_name
,@data_id
,@user_id
,@title
,@cover
,@path
,@qrcode
,@file_name
,@extend
,@likn_url
,@share_user
,@sort
,@add_time
,@is_del
);
SELECT @@IDENTITY;");
SqlParameter[] parameters =
{
new SqlParameter("@from_id", SqlDbType.Int, 4)
, new SqlParameter("@group_id", SqlDbType.Int, 4)
, new SqlParameter("@type", SqlDbType.Int, 4)
, new SqlParameter("@school_id", SqlDbType.Int, 4)
, new SqlParameter("@school_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@data_id", SqlDbType.Int, 4)
, new SqlParameter("@user_id", SqlDbType.Int, 4)
, new SqlParameter("@title", SqlDbType.NVarChar, 50)
, new SqlParameter("@cover", SqlDbType.NVarChar, 255)
, new SqlParameter("@path", SqlDbType.NText)
, new SqlParameter("@qrcode", SqlDbType.NVarChar, 500)
, new SqlParameter("@file_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@extend", SqlDbType.NVarChar, 50)
, new SqlParameter("@likn_url", SqlDbType.NVarChar, 500)
, new SqlParameter("@share_user", SqlDbType.NText)
, new SqlParameter("@sort", SqlDbType.Int, 4)
, new SqlParameter("@add_time", SqlDbType.DateTime, 8)
, new SqlParameter("@is_del", SqlDbType.Int, 4)
};
parameters[0].Value = model.from_id;
parameters[1].Value = model.group_id;
parameters[2].Value = model.type;
parameters[3].Value = model.school_id;
parameters[4].Value = model.school_name;
parameters[5].Value = model.data_id;
parameters[6].Value = model.user_id;
parameters[7].Value = model.title;
parameters[8].Value = model.cover;
parameters[9].Value = model.path;
parameters[10].Value = model.qrcode;
parameters[11].Value = model.file_name;
parameters[12].Value = model.extend;
parameters[13].Value = model.likn_url;
parameters[14].Value = model.share_user;
parameters[15].Value = model.sort;
parameters[16].Value = model.add_time;
parameters[17].Value = model.is_del;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.common_resource model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"UPDATE ybd_common_resource SET
from_id = @from_id
,group_id = @group_id
,type = @type
,school_id = @school_id
,school_name = @school_name
,data_id = @data_id
,user_id = @user_id
,title = @title
,cover = @cover
,path = @path
,qrcode = @qrcode
,file_name = @file_name
,extend = @extend
,likn_url = @likn_url
,share_user = @share_user
,sort = @sort
,add_time = @add_time
,is_del = @is_del
WHERE id = @id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
, new SqlParameter("@from_id", SqlDbType.Int, 4)
, new SqlParameter("@group_id", SqlDbType.Int, 4)
, new SqlParameter("@type", SqlDbType.Int, 4)
, new SqlParameter("@school_id", SqlDbType.Int, 4)
, new SqlParameter("@school_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@data_id", SqlDbType.Int, 4)
, new SqlParameter("@user_id", SqlDbType.Int, 4)
, new SqlParameter("@title", SqlDbType.NVarChar, 50)
, new SqlParameter("@cover", SqlDbType.NVarChar, 255)
, new SqlParameter("@path", SqlDbType.NText)
, new SqlParameter("@qrcode", SqlDbType.NVarChar, 500)
, new SqlParameter("@file_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@extend", SqlDbType.NVarChar, 50)
, new SqlParameter("@likn_url", SqlDbType.NVarChar, 500)
, new SqlParameter("@share_user", SqlDbType.NText)
, new SqlParameter("@sort", SqlDbType.Int, 4)
, new SqlParameter("@add_time", SqlDbType.DateTime, 8)
, new SqlParameter("@is_del", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.from_id;
parameters[2].Value = model.group_id;
parameters[3].Value = model.type;
parameters[4].Value = model.school_id;
parameters[5].Value = model.school_name;
parameters[6].Value = model.data_id;
parameters[7].Value = model.user_id;
parameters[8].Value = model.title;
parameters[9].Value = model.cover;
parameters[10].Value = model.path;
parameters[11].Value = model.qrcode;
parameters[12].Value = model.file_name;
parameters[13].Value = model.extend;
parameters[14].Value = model.likn_url;
parameters[15].Value = model.share_user;
parameters[16].Value = model.sort;
parameters[17].Value = model.add_time;
parameters[18].Value = model.is_del;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.common_resource DataRowToModel(DataRow row)
{
Model.common_resource model = new Model.common_resource();
if (row != null)
{
if (row["id"] != null) //&& row["id"].ToString() != ""
{
model.id = Convert.ToInt32(row["id"]);
}
if (row["from_id"] != null) //&& row["from_id"].ToString() != ""
{
model.from_id = Convert.ToInt32(row["from_id"]);
}
if (row["group_id"] != null) //&& row["group_id"].ToString() != ""
{
model.group_id = Convert.ToInt32(row["group_id"]);
}
if (row["type"] != null) //&& row["type"].ToString() != ""
{
model.type = Convert.ToInt32(row["type"]);
}
if (row["school_id"] != null) //&& row["school_id"].ToString() != ""
{
model.school_id = Convert.ToInt32(row["school_id"]);
}
if (row["school_name"] != null) //&& row["school_name"].ToString() != ""
{
model.school_name = Convert.ToString(row["school_name"]);
}
if (row["data_id"] != null) //&& row["data_id"].ToString() != ""
{
model.data_id = Convert.ToInt32(row["data_id"]);
}
if (row["user_id"] != null) //&& row["user_id"].ToString() != ""
{
model.user_id = Convert.ToInt32(row["user_id"]);
}
if (row["title"] != null) //&& row["title"].ToString() != ""
{
model.title = Convert.ToString(row["title"]);
}
if (row["cover"] != null) //&& row["cover"].ToString() != ""
{
model.cover = Convert.ToString(row["cover"]);
}
if (row["path"] != null) //&& row["path"].ToString() != ""
{
model.path = Convert.ToString(row["path"]);
}
if (row["qrcode"] != null) //&& row["qrcode"].ToString() != ""
{
model.qrcode = Convert.ToString(row["qrcode"]);
}
if (row["file_name"] != null) //&& row["file_name"].ToString() != ""
{
model.file_name = Convert.ToString(row["file_name"]);
}
if (row["extend"] != null) //&& row["extend"].ToString() != ""
{
model.extend = Convert.ToString(row["extend"]);
}
if (row["likn_url"] != null) //&& row["likn_url"].ToString() != ""
{
model.likn_url = Convert.ToString(row["likn_url"]);
}
if (row["share_user"] != null) //&& row["share_user"].ToString() != ""
{
model.share_user = Convert.ToString(row["share_user"]);
}
if (row["sort"] != null) //&& row["sort"].ToString() != ""
{
model.sort = Convert.ToInt32(row["sort"]);
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = Convert.ToDateTime(row["add_time"]);
}
if (row["is_del"] != null) //&& row["is_del"].ToString() != ""
{
model.is_del = Convert.ToInt32(row["is_del"]);
}
return(model);
}
else
{
return(null);
}
}
private void saveWordVoice()
{
int id = RequestHelper.GetFormInt("id");
int group = RequestHelper.GetFormInt("group");
int school = RequestHelper.GetFormInt("school");
string school_name = RequestHelper.GetFormString("school_name");
int chapter = RequestHelper.GetFormInt("chapter");
string title = RequestHelper.GetFormString("title");
string userids = RequestHelper.GetFormString("userids");
string words = RequestHelper.GetFormString("words");
Appoa.Web.UI.ManagePage mngPage = new Web.UI.ManagePage();
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(id);
if (model != null)
{
model.group_id = group;
if (model.group_id == (int)EnumCollection.resource_group.公共资源)
{
model.school_id = 0;
model.school_name = "";
}
else
{
model.school_id = school;
model.school_name = school_name;
}
model.data_id = chapter;
model.user_id = mngPage.GetAdminInfo().id;
model.title = title;
model.path = words;
model.share_user = userids;
if (bll.Update(model))
{
mngPage.AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改英文发音资源信息，主键:" + id); //记录日志
writeMsgSuccess("保存成功");
}
else
{
writeMsgError("保存失败");
}
}
else
{
model = new Model.common_resource();
model.from_id = (int)EnumCollection.resource_from.精品微课;
model.group_id = group;
model.type = (int)EnumCollection.resource_type.英文发音;
if (model.group_id == (int)EnumCollection.resource_group.公共资源)
{
model.school_id = 0;
model.school_name = "";
}
else
{
model.school_id = school;
model.school_name = school_name;
}
model.data_id = chapter;
model.user_id = mngPage.GetAdminInfo().id;
model.title = title;
model.cover = "";
model.path = words;
model.qrcode = "";
model.file_name = "";
model.extend = "";
model.likn_url = "";
model.add_time = System.DateTime.Now;
model.share_user = userids;
int row = bll.Add(model);
if (row > 0)
{
model.id = row;
model.qrcode = "/QrCode.aspx?type=re&id=" + row;
bll.Update(model);
mngPage.AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加英文发音资源信息，主键:" + row); //记录日志
writeMsgSuccess("保存成功");
}
else
{
writeMsgError("保存失败");
}
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_common_resource", EnumCollection.ActionEnum.Add.ToString()); //检查权限
#region
string strError = string.Empty;
if (txtfrom_id.Text.Trim() == "" || txtfrom_id.Text.Trim().Length > 4)
{
strError += "归属 1微课 2课堂为空或超出长度![br]";
}
if (txtgroup_id.Text.Trim() == "" || txtgroup_id.Text.Trim().Length > 4)
{
strError += "分组ID为空或超出长度![br]";
}
if (txttype.Text.Trim() == "" || txttype.Text.Trim().Length > 4)
{
strError += "分类ID为空或超出长度![br]";
}
if (txtschool_id.Text.Trim() == "" || txtschool_id.Text.Trim().Length > 4)
{
strError += "学校ID为空或超出长度![br]";
}
if (txtschool_name.Text.Trim() == "" || txtschool_name.Text.Trim().Length > 50)
{
strError += "学校名称为空或超出长度![br]";
}
if (txtdata_id.Text.Trim() == "" || txtdata_id.Text.Trim().Length > 4)
{
strError += "数据关联ID为空或超出长度![br]";
}
if (txtuser_id.Text.Trim() == "" || txtuser_id.Text.Trim().Length > 4)
{
strError += "上传者为空或超出长度![br]";
}
if (txttitle.Text.Trim() == "" || txttitle.Text.Trim().Length > 50)
{
strError += "标题为空或超出长度![br]";
}
if (txtcover.Text.Trim() == "" || txtcover.Text.Trim().Length > 255)
{
strError += "封面图为空或超出长度![br]";
}
if (txtpath.Text.Trim() == "" || txtpath.Text.Trim().Length > 16)
{
strError += "路径为空或超出长度![br]";
}
if (txtqrcode.Text.Trim() == "" || txtqrcode.Text.Trim().Length > 500)
{
strError += "二维码为空或超出长度![br]";
}
if (txtfile_name.Text.Trim() == "" || txtfile_name.Text.Trim().Length > 50)
{
strError += "文件名为空或超出长度![br]";
}
if (txtextend.Text.Trim() == "" || txtextend.Text.Trim().Length > 50)
{
strError += "扩展名为空或超出长度![br]";
}
if (txtlikn_url.Text.Trim() == "" || txtlikn_url.Text.Trim().Length > 500)
{
strError += "链接为空或超出长度![br]";
}
if (txtshare_user.Text.Trim() == "" || txtshare_user.Text.Trim().Length > 16)
{
strError += "要分享给的用户ID为空或超出长度![br]";
}
if (txtsort.Text.Trim() == "" || txtsort.Text.Trim().Length > 4)
{
strError += "排序为空或超出长度![br]";
}
if (txtadd_time.Text.Trim() == "" || txtadd_time.Text.Trim().Length > 8)
{
strError += "上传时间为空或超出长度![br]";
}
if (txtis_del.Text.Trim() == "" || txtis_del.Text.Trim().Length > 4)
{
strError += "是否删除为空或超出长度![br]";
}
if (strError != string.Empty)
{
JscriptMsg(strError, "", "Error");
return;
}
#endregion
Model.common_resource model = new Model.common_resource();
BLL.common_resource bll = new BLL.common_resource();
model.from_id = Convert.ToInt32(txtfrom_id.Text);
model.group_id = Convert.ToInt32(txtgroup_id.Text);
model.type = Convert.ToInt32(txttype.Text);
model.school_id = Convert.ToInt32(txtschool_id.Text);
model.school_name = Convert.ToString(txtschool_name.Text);
model.data_id = Convert.ToInt32(txtdata_id.Text);
model.user_id = Convert.ToInt32(txtuser_id.Text);
model.title = Convert.ToString(txttitle.Text);
model.cover = Convert.ToString(txtcover.Text);
model.path = Convert.ToString(txtpath.Text);
model.qrcode = Convert.ToString(txtqrcode.Text);
model.file_name = Convert.ToString(txtfile_name.Text);
model.extend = Convert.ToString(txtextend.Text);
model.likn_url = Convert.ToString(txtlikn_url.Text);
model.share_user = Convert.ToString(txtshare_user.Text);
model.sort = Convert.ToInt32(txtsort.Text);
model.add_time = Convert.ToDateTime(txtadd_time.Text);
model.is_del = Convert.ToInt32(txtis_del.Text);
int id = bll.Add(model);
if (id > 0)
{
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加资源信息信息，主键:" + id); //记录日志
JscriptMsg("添加资源信息信息成功！", "Manage.aspx", "");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.common_resource model)
{
return(dal.Update(model));
}
private bool DoEdit(int id)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = bll.GetModel(id);
model.from_id = (int)EnumCollection.resource_from.精品微课;
model.group_id = Convert.ToInt32(this.rbtnGroup.SelectedValue);
model.type = Convert.ToInt32(this.rbtnType.SelectedValue);
if (model.group_id != (int)EnumCollection.resource_group.学校资源)
{
model.school_id = 0;
model.school_name = "";
}
else
{
model.school_id = Convert.ToInt32(this.ddlSchool.SelectedValue);
model.school_name = this.ddlSchool.SelectedItem.Text;
}
model.data_id = chapter;
model.user_id = admin_info.id;
if (model.type == (int)EnumCollection.resource_type.图文资源)
{
model.title = Convert.ToString(txttitle.Text.Trim());
model.cover = "";
model.path = Convert.ToString(txtcontents.Text.Trim());
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
model.file_name = "";
model.extend = "";
model.likn_url = "";
}
else
{
string fileNames = Utils.DelLastChar(this.hdfVal.Value, "|");
string path = Utils.DelLastChar(this.txtpath.Text, "|");
string[] files = fileNames.Split('|');
string[] paths = path.Split('|');
model.title = getStr(files[0], 1);
model.cover = "";
model.path = paths[0];
model.file_name = files[0];
model.extend = getStr(files[0], 2);
model.likn_url = "";
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
}
string userids = string.Empty;
for (int i = 0; i < ckbUser.Items.Count; i++)
{
if (ckbUser.Items[i].Selected)
{
userids += "," + ckbUser.Items[i].Value + ",";
}
}
model.share_user = userids;
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改资源信息，主键:" + id); //记录日志
return(true);
}
else
{
return(false);
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = null;
if (action == EnumCollection.ActionEnum.Add.ToString()) //添加
{
ChkAdminLevel("_classroom_video_materials", EnumCollection.ActionEnum.Add.ToString()); //检查权限
#region 添加操作
string[] files = this.hdfVal.Value.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
string[] thumbs = this.hdfThumb.Value.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
string[] paths = this.txtpath.Text.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
int count = 0;
Model.common_resource maxModel = null;
for (int i = 0; i < files.Length; i++)
{
model = new Model.common_resource();
model.from_id = (int)EnumCollection.resource_from.课堂;
model.group_id = (int)EnumCollection.resource_group.公共资源;
model.type = (int)EnumCollection.resource_type.视频资源;
model.school_id = 0;
model.school_name = "";
model.data_id = class_id;
model.user_id = admin_info.id;
string file = files[i];
model.title = getStr(file, 1);
model.cover = thumbs[i];
model.path = paths[i];
model.qrcode = "";
model.file_name = file;
model.extend = getStr(file, 2);
model.likn_url = "";
model.share_user = "";
model.add_time = System.DateTime.Now;
maxModel = bll.GetModel(" from_id = " + model.from_id + " and group_id = " + model.group_id + " and type = " + model.type + " and data_id = " + class_id + " order by sort desc ");
if (maxModel != null)
{
model.sort = maxModel.sort + 1;
}
else
{
model.sort = 1;
}
int id = bll.Add(model);
if (id > 0)
{
model.id = id;
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
bll.Update(model);
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加" + Enum.GetName(typeof(EnumCollection.resource_type), model.type) + "资源信息，主键:" + id); //记录日志
count++;
}
JscriptMsg("添加" + Enum.GetName(typeof(EnumCollection.resource_type), model.type) + "资源成功！总文件" + files.Length + "个，成功" + count + "个", "video_list.aspx?class_id=" + this.class_id);
}
#endregion
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
BLL.common_resource bll = new BLL.common_resource();
Model.common_resource model = null;
if (action == EnumCollection.ActionEnum.Modify.ToString()) //修改
{
ChkAdminLevel("_resource_list", EnumCollection.ActionEnum.Modify.ToString()); //检查权限
if (!DoEdit(this.id))
{
JscriptMsg("保存过程中发生错误！", "");
return;
}
JscriptMsg("修改资源成功！", "resource_list.aspx?page=" + this.page + "&chapter=" + this.chapter + "&course_id=" + this.course_id);
}
else //添加
{
ChkAdminLevel("_resource_list", EnumCollection.ActionEnum.Add.ToString()); //检查权限
#region 添加操作
if (Convert.ToInt32(this.rbtnType.SelectedValue) == (int)EnumCollection.resource_type.图文资源)
{
model = new Model.common_resource();
model.from_id = (int)EnumCollection.resource_from.精品微课;
model.group_id = Convert.ToInt32(this.rbtnGroup.SelectedValue);
model.type = Convert.ToInt32(this.rbtnType.SelectedValue);
if (model.group_id != (int)EnumCollection.resource_group.学校资源)
{
model.school_id = 0;
model.school_name = "";
}
else
{
model.school_id = Convert.ToInt32(this.ddlSchool.SelectedValue);
model.school_name = this.ddlSchool.SelectedItem.Text;
}
model.data_id = chapter;
model.user_id = admin_info.id;
model.title = Convert.ToString(txttitle.Text.Trim());
model.cover = "";
model.path = Convert.ToString(txtcontents.Text.Trim());
model.qrcode = "";
model.file_name = "";
model.extend = "";
model.likn_url = "";
model.add_time = System.DateTime.Now;
Model.common_resource maxModel = bll.GetModel(" from_id = " + (int)EnumCollection.resource_from.精品微课 + " and data_id = " + chapter + " order by sort desc ");
if (maxModel != null)
{
model.sort = maxModel.sort + 1;
}
else
{
model.sort = 1;
}
string userids = string.Empty;
for (int i = 0; i < ckbUser.Items.Count; i++)
{
if (ckbUser.Items[i].Selected)
{
userids += "," + ckbUser.Items[i].Value + ",";
}
}
model.share_user = userids;
int id = bll.Add(model);
if (id > 0)
{
model.id = id;
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
bll.Update(model);
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加图文资源信息，主键:" + id); //记录日志
JscriptMsg("添加图文资源成功！", "resource_list.aspx?chapter=" + this.chapter + "&course_id=" + this.course_id);
}
else
{
JscriptMsg("保存过程中发生错误！", "");
return;
}
}
else
{
string fileNames = Utils.DelLastChar(this.hdfVal.Value, "|");
string path = Utils.DelLastChar(this.txtpath.Text, "|");
string[] files = fileNames.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
string[] paths = path.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
int count = 0;
Model.common_resource maxModel = null;
for (int i = 0; i < files.Length; i++)
{
model = new Model.common_resource();
model.from_id = (int)EnumCollection.resource_from.精品微课;
model.group_id = Convert.ToInt32(this.rbtnGroup.SelectedValue);
model.type = Convert.ToInt32(this.rbtnType.SelectedValue);
if (model.group_id == (int)EnumCollection.resource_group.公共资源)
{
model.school_id = 0;
model.school_name = "";
}
else
{
model.school_id = Convert.ToInt32(this.ddlSchool.SelectedValue);
model.school_name = this.ddlSchool.SelectedItem.Text;
}
model.data_id = chapter;
model.user_id = admin_info.id;
string file = files[i];
model.title = getStr(file, 1);
model.cover = "";
model.path = paths[i];
model.qrcode = "";
model.file_name = file;
model.extend = getStr(file, 2);
model.likn_url = "";
model.add_time = System.DateTime.Now;
maxModel = bll.GetModel(" from_id = " + (int)EnumCollection.resource_from.精品微课 + " and data_id = " + chapter + " order by sort desc ");
if (maxModel != null)
{
model.sort = maxModel.sort + 1;
}
else
{
model.sort = 1;
}
string userids = string.Empty;
for (int j = 0; j < ckbUser.Items.Count; j++)
{
if (ckbUser.Items[j].Selected)
{
userids += "," + ckbUser.Items[j].Value + ",";
}
}
model.share_user = userids;
int id = bll.Add(model);
if (id > 0)
{
model.id = id;
model.qrcode = "/QrCode.aspx?type=re&id=" + id;
bll.Update(model);
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加" + Enum.GetName(typeof(EnumCollection.resource_type), model.type) + "资源信息，主键:" + id); //记录日志
count++;
}
}
JscriptMsg("添加" + Enum.GetName(typeof(EnumCollection.resource_type), model.type) + "资源成功！总文件" + files.Length + "个，成功" + count + "个", "resource_list.aspx?chapter=" + this.chapter + "&course_id=" + this.course_id);
}
#endregion
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.common_resource model)
{
return(dal.Add(model));
}
