/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbDel_Click(object sender, CommandEventArgs e) { int pwid = Convert.ToInt32(e.CommandArgument); Daiv_OA.Entity.PlanEntity model = new Daiv_OA.Entity.PlanEntity(); model = new Daiv_OA.BLL.PlanBLL().GetEntity(pwid); string islock = model.Locked; if (islock == "未锁定") { new Daiv_OA.BLL.PlanBLL().Delete(Convert.ToInt32(e.CommandArgument)); string dirpath = Server.MapPath("~/Worddoc"); if (Directory.Exists(dirpath) == false) { Directory.CreateDirectory(dirpath); } string FileName = Path.GetFileName(model.Pwpath); string lastpath = dirpath + @"\" + FileName; File.Delete(lastpath); Selectinfo(" and uid = " + UserId + ""); } else { System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('该文件已锁定!');</script>"); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Daiv_OA.Entity.PlanEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [OA_Plan] set "); strSql.Append("Uid=@Uid,"); strSql.Append("Pwtitle=@Pwtitle,"); strSql.Append("Pwdate=@Pwdate,"); strSql.Append("Pwpath=@Pwpath,"); strSql.Append("Locked=@Locked,"); strSql.Append("Manager=@Manager"); strSql.Append(" where Pwid=@Pwid "); SqlParameter[] parameters = { new SqlParameter("@Pwid", SqlDbType.Int, 4), new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@Pwtitle", SqlDbType.VarChar, 80), new SqlParameter("@Pwdate", SqlDbType.DateTime), new SqlParameter("@Pwpath", SqlDbType.VarChar, 50), new SqlParameter("@Locked", SqlDbType.VarChar, 10), new SqlParameter("@Manager", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Pwid; parameters[1].Value = model.Uid; parameters[2].Value = model.Pwtitle; parameters[3].Value = model.Pwdate; parameters[4].Value = model.Pwpath; parameters[5].Value = model.Locked; parameters[6].Value = model.Manager; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 下载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbDown_Click(object sender, CommandEventArgs e) { string path = ""; Daiv_OA.Entity.PlanEntity model = new Daiv_OA.Entity.PlanEntity(); model = new Daiv_OA.BLL.PlanBLL().GetEntity(Convert.ToInt32(e.CommandArgument)); path = model.Pwpath; DownloadFile(path); }
//插入信息 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { string dirpath = Server.MapPath("~/Worddoc"); if (Directory.Exists(dirpath) == false) { Directory.CreateDirectory(dirpath); } Random ro = new Random(); int name = 1; string FileName = ""; string FileExtention = ""; FileName = Path.GetFileName(this.fuFile.FileName); string stro = ro.Next(100, 100000000).ToString() + name.ToString();//产生一个随机数用于新命名的文件 string NewName = DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + stro; if (FileName.Length > 0)//有文件才执行上传操作再保存到数据库 { FileExtention = Path.GetExtension(this.fuFile.FileName); string ppath = dirpath + @"\" + NewName + FileExtention; this.fuFile.SaveAs(ppath); Daiv_OA.Entity.PlanEntity model = new Daiv_OA.Entity.PlanEntity(); model.Uid = UserId; model.Pwtitle = this.txtTitle.Text; model.Pwdate = DateTime.Now; model.Manager = this.ddlManager.SelectedValue; model.Pwpath = "Worddoc/" + NewName + FileExtention; model.Locked = "未锁定"; int i = new Daiv_OA.BLL.PlanBLL().Add(model); if (i > 0) { FinalMessage("操作成功", "My_Plan_List.aspx", 0); } else { System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('对不起,操作失败!');</script>"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Daiv_OA.Entity.PlanEntity GetEntity(int Pwid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Pwid,Uid,Pwtitle,Pwdate,Pwpath,Locked,Manager from [OA_Plan] "); strSql.Append(" where Pwid=@Pwid "); SqlParameter[] parameters = { new SqlParameter("@Pwid", SqlDbType.Int, 4) }; parameters[0].Value = Pwid; Daiv_OA.Entity.PlanEntity model = new Daiv_OA.Entity.PlanEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Pwid"].ToString() != "") { model.Pwid = int.Parse(ds.Tables[0].Rows[0]["Pwid"].ToString()); } if (ds.Tables[0].Rows[0]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString()); } model.Pwtitle = ds.Tables[0].Rows[0]["Pwtitle"].ToString(); if (ds.Tables[0].Rows[0]["Pwdate"].ToString() != "") { model.Pwdate = DateTime.Parse(ds.Tables[0].Rows[0]["Pwdate"].ToString()); } model.Pwpath = ds.Tables[0].Rows[0]["Pwpath"].ToString(); model.Locked = ds.Tables[0].Rows[0]["Locked"].ToString(); model.Manager = ds.Tables[0].Rows[0]["Manager"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Daiv_OA.Entity.PlanEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [OA_Plan]("); strSql.Append("Uid,Pwtitle,Pwdate,Pwpath,Locked,Manager)"); strSql.Append(" values ("); strSql.Append("@Uid,@Pwtitle,@Pwdate,@Pwpath,@Locked,@Manager)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@Pwtitle", SqlDbType.VarChar, 80), new SqlParameter("@Pwdate", SqlDbType.DateTime), new SqlParameter("@Pwpath", SqlDbType.VarChar, 50), new SqlParameter("@Locked", SqlDbType.VarChar, 10), new SqlParameter("@Manager", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Uid; parameters[1].Value = model.Pwtitle; parameters[2].Value = model.Pwdate; parameters[3].Value = model.Pwpath; parameters[4].Value = model.Locked; parameters[5].Value = model.Manager; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }