/// <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));
}
}
