/// <summary> /// 修改时的默认值 /// </summary> protected void loadData() { model = bll.GetModel(AudioVideoIntroId); if (model == null) { return; } else { ddlAudioVideoTypeEnum.SelectedValue = model.AudioVideoTypeEnum; txtAudioVideoUrl.Text = model.AudioVideoName; txtFileName.Text = model.FileName; if (!string.IsNullOrEmpty(model.AudioVideoUrl)) { string fileId = string.Empty; fileId = model.AudioVideoUrl; fileId = fileId.Substring(fileId.LastIndexOf("/") + 1); fileId = fileId.Substring(0, fileId.LastIndexOf(".")); hidFileID.Value = fileId; if (File.Exists(Server.MapPath(model.AudioVideoUrl))) { ltlPriview.Text = "<video src=\"" + model.AudioVideoUrl + "\" controls=\"controls\" style=\"width:100%;\">your browser does not support the video tag</video>"; } } } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(AudioVideoIntroId)) { #region 添加 model = new Model_AudioVideoIntro(); model.FileName = txtFileName.Text.Trim(); model.AudioVideoName = txtAudioVideoUrl.Text.Trim(); model.AudioVideoBookId = AudioVideoBookId; model.AudioVideoIntroId = Guid.NewGuid().ToString(); model.CreateUser = loginUser.SysUser_ID; model.CreateTime = DateTime.Now; model.AudioVideoTypeEnum = ddlAudioVideoTypeEnum.SelectedValue; model.AudioVideoUrl = hidFileUrl.Value; if (bll.Add(model)) { new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS("10401000", "新增音/视频成功,操作人:(" + loginUser.SysUser_ID + ")" + loginUser.SysUser_Name); ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index)});})})</script>"); return; } #endregion } else { #region 修改 model = bll.GetModel(AudioVideoIntroId); model.FileName = txtFileName.Text.Trim(); model.AudioVideoName = txtAudioVideoUrl.Text.Trim(); model.AudioVideoTypeEnum = ddlAudioVideoTypeEnum.SelectedValue; if (!string.IsNullOrEmpty(hidFileUrl.Value)) { model.AudioVideoUrl = hidFileUrl.Value; } if (bll.Update(model)) { new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS("10401000", "修改音/视频成功,操作人:(" + loginUser.SysUser_ID + ")" + loginUser.SysUser_Name); ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});})})</script>"); } #endregion } } catch (Exception ex) { new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS("10401000", "操作异常," + ex + "操作人:(" + loginUser.SysUser_ID + ")" + loginUser.SysUser_Name); ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('操作失败!',{ time: 2000,icon:2},function(){parent.loadData();parent.layer.close(index);});})})</script>"); } }
public List <Model_AudioVideoIntro> DataTableToList(DataTable dt) { List <Model_AudioVideoIntro> list = new List <Model_AudioVideoIntro>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_AudioVideoIntro item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(Model_AudioVideoIntro model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into AudioVideoIntro("); builder.Append("AudioVideoIntroId,AudioVideoBookId,FileName,AudioVideoTypeEnum,AudioVideoName,AudioVideoUrl,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@AudioVideoIntroId,@AudioVideoBookId,@FileName,@AudioVideoTypeEnum,@AudioVideoName,@AudioVideoUrl,@CreateUser,@CreateTime)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@AudioVideoIntroId", SqlDbType.Char, 0x24), new SqlParameter("@AudioVideoBookId", SqlDbType.Char, 0x24), new SqlParameter("@FileName", SqlDbType.NVarChar, 200), new SqlParameter("@AudioVideoTypeEnum", SqlDbType.VarChar, 50), new SqlParameter("@AudioVideoName", SqlDbType.NVarChar, 200), new SqlParameter("@AudioVideoUrl", SqlDbType.NVarChar, 500), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; cmdParms[0].Value = model.AudioVideoIntroId; cmdParms[1].Value = model.AudioVideoBookId; cmdParms[2].Value = model.FileName; cmdParms[3].Value = model.AudioVideoTypeEnum; cmdParms[4].Value = model.AudioVideoName; cmdParms[5].Value = model.AudioVideoUrl; cmdParms[6].Value = model.CreateUser; cmdParms[7].Value = model.CreateTime; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_AudioVideoIntro DataRowToModel(DataRow row) { Model_AudioVideoIntro intro = new Model_AudioVideoIntro(); if (row != null) { if (row["AudioVideoIntroId"] != null) { intro.AudioVideoIntroId = row["AudioVideoIntroId"].ToString(); } if (row["AudioVideoBookId"] != null) { intro.AudioVideoBookId = row["AudioVideoBookId"].ToString(); } if (row["FileName"] != null) { intro.FileName = row["FileName"].ToString(); } if (row["AudioVideoTypeEnum"] != null) { intro.AudioVideoTypeEnum = row["AudioVideoTypeEnum"].ToString(); } if (row["AudioVideoName"] != null) { intro.AudioVideoName = row["AudioVideoName"].ToString(); } if (row["AudioVideoUrl"] != null) { intro.AudioVideoUrl = row["AudioVideoUrl"].ToString(); } if (row["CreateUser"] != null) { intro.CreateUser = row["CreateUser"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { intro.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } } return(intro); }
public bool Update(Model_AudioVideoIntro model) { StringBuilder builder = new StringBuilder(); builder.Append("update AudioVideoIntro set "); builder.Append("AudioVideoBookId=@AudioVideoBookId,"); builder.Append("FileName=@FileName,"); builder.Append("AudioVideoTypeEnum=@AudioVideoTypeEnum,"); builder.Append("AudioVideoName=@AudioVideoName,"); builder.Append("AudioVideoUrl=@AudioVideoUrl,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("CreateTime=@CreateTime"); builder.Append(" where AudioVideoIntroId=@AudioVideoIntroId "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@AudioVideoBookId", SqlDbType.Char, 0x24), new SqlParameter("@FileName", SqlDbType.NVarChar, 200), new SqlParameter("@AudioVideoTypeEnum", SqlDbType.VarChar, 50), new SqlParameter("@AudioVideoName", SqlDbType.NVarChar, 200), new SqlParameter("@AudioVideoUrl", SqlDbType.NVarChar, 500), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@AudioVideoIntroId", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.AudioVideoBookId; cmdParms[1].Value = model.FileName; cmdParms[2].Value = model.AudioVideoTypeEnum; cmdParms[3].Value = model.AudioVideoName; cmdParms[4].Value = model.AudioVideoUrl; cmdParms[5].Value = model.CreateUser; cmdParms[6].Value = model.CreateTime; cmdParms[7].Value = model.AudioVideoIntroId; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Add(Model_AudioVideoIntro model) { return(this.dal.Add(model)); }
public bool Update(Model_AudioVideoIntro model) { return(this.dal.Update(model)); }