protected void GridBind()//第一次进入、查询、添加、删除和排序时使用
{
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ordername = ViewState["SortExpression"].ToString();
note.orderMenthod = ViewState["SortDirection"].ToString();
note.UnitCode = _user.UnitCode;
note.DYear = DDL_Year.SelectedValue;
note.DMonth = DDL_Month.SelectedValue;
if (DDL_State.SelectedValue != "")
{
note.State = int.Parse(DDL_State.SelectedValue);
}
GridSource = note.getOriginDataTableWithPublish(GridView1.PageSize, currentPage);
if (GridSource.Rows.Count == 0 && currentPage > 1)
{
currentPage--;
GridSource = note.getOriginDataTableWithPublish(GridView1.PageSize, currentPage);
}
total = note.total;
GridView1.DataSource = GridSource;
GridView1.DataKeyNames = new string[] { "tableid", "name", "state", "islocked", "unitcode" };
GridView1.DataBind();
GridView1.SelectedIndex = -1;
HF_Key.Value = "";
HF_State.Value = "";
//给HF和Session赋值
HF_total.Value = total.ToString();
HF_currentPage.Value = currentPage.ToString();
Session["GridSource"] = GridSource;
}
protected void Lbtn_finish_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ChgPerson = User.Identity.Name;
result = note.Finish();
if (result == 0)
{
//if (GridSource.Rows[GridView1.SelectedIndex]["ID"].ToString() == HF_Key.Value)
// {
GridSource.Rows[GridView1.SelectedIndex]["state"] = "2";
GridSource.Rows[GridView1.SelectedIndex]["chgDate"] = note.ChgDate;
// break;
//}
Lb_result.Text = "提交完毕";
GridBindFAPR();
}
else
{
Lb_result.Text = "提交完成失败";
}
}
protected void Lbtn_approve_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ApprovePerson = User.Identity.Name;
string app = Request["__EVENTARGUMENT"];
if (app == "0")
{
note.IsApproved = true;
}
else
{
note.IsApproved = false;
}
note.log_moduleName = ModuleName;
note.log_userName = _user.UserName;
result = note.Approve();
if (result == 0)
{
//for (int i = 0; i < GridSource.Rows.Count; i++)
//{
// if (GridSource.Rows[i]["ID"].ToString() == HF_Key.Value)
// {
if (app == "0")
{
GridSource.Rows[GridView1.SelectedIndex]["state"] = "4";
}
else
{
GridSource.Rows[GridView1.SelectedIndex]["state"] = "3";
}
GridSource.Rows[GridView1.SelectedIndex]["chgDate"] = note.ChgDate;
//break;
// }
//}
GridBindFAPR();
Lb_result.Text = "审批完毕";
}
else
{
Lb_result.Text = "审批失败";
}
}
protected void PagerButtonClick(object sender, EventArgs e)
{
try
{
int pagenum = total / (GridView1.PageSize);
if (GridView1.PageSize * pagenum < total)
{
pagenum += 1;
}
if (txt_page.Text == "0")
{
txt_page.Text = "1";
}
else if (int.Parse(txt_page.Text) > pagenum)
{
txt_page.Text = pagenum.ToString();
}
GridView1.SelectedIndex = -1;
HF_Key.Value = "";
HF_State.Value = "";
linkBtnPage.CommandName = txt_page.Text;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ordername = ViewState["SortExpression"].ToString();
note.orderMenthod = ViewState["SortDirection"].ToString();
note.UnitCode = _user.UnitCode;
note.DYear = DDL_Year.SelectedValue;
note.DMonth = DDL_Month.SelectedValue;
if (DDL_State.SelectedValue != "")
{
note.State = int.Parse(DDL_State.SelectedValue);
}
currentPage = Convert.ToInt32(((LinkButton)sender).CommandName);
GridSource = note.getOriginDataTableWithPublish(GridView1.PageSize, currentPage);
GridBindFAPR();
//给HF和Session赋值
HF_total.Value = total.ToString();
HF_currentPage.Value = currentPage.ToString();
Session["GridSource"] = GridSource;
}
catch
{
Lb_result.Text = "输入页码非法！";
}
}
protected void Lbtn_OK_Click(object sender, EventArgs e)
{
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
int result = -1;
note.Name = TB_name.Value;
note.UnitCode = _user.UnitCode;
note.IsApproved = false;
//note.Memo = "";
try
{
Stream myStream = File1.PostedFile.InputStream;
int imgDataLen = File1.PostedFile.ContentLength;
byte[] imgData = new byte[imgDataLen];
myStream.Read(imgData, 0, imgDataLen);
note.File = imgData;
note.ContentType = File1.PostedFile.ContentType;
string fielName = File1.PostedFile.FileName;
int i = fielName.LastIndexOf('.');
note.FileType = fielName.Substring(i + 1, fielName.Length - i - 1);
}
catch
{
}
note.log_moduleName = ModuleName;
note.log_userName = _user.UserName;
note.Memo = TA_Memo.Value;
if (HF_Operate.Value == "add")
{
note.AddPerson = User.Identity.Name;
note.DYear = Request["year"].ToString();
note.DMonth = Request["month"].ToString();
result = note.Insert();
}
if (HF_Operate.Value == "edit")
{
note.ChgPerson = User.Identity.Name;
note.ID = Int32.Parse(HF_ID.Value);
result = note.Update();
}
Response.Write("<script language='javascript'>javascript:var s=new Object();s.success=true;s.data='" + result + "';window.returnValue=s;self.close();</script>");
}
protected void Lbtn_publish_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ChgPerson = User.Identity.Name;
string state = Request["__EVENTARGUMENT"];
result = note.Publish(state);
if (result == 0)
{
//for (int i = 0; i < GridSource.Rows.Count; i++)
//{
// if (GridSource.Rows[i]["ID"].ToString() == HF_Key.Value)
// {
GridSource.Rows[GridView1.SelectedIndex]["state"] = state;
GridSource.Rows[GridView1.SelectedIndex]["chgDate"] = note.ChgDate;
// break;
// }
//}
GridBindFAPR();
if (state == "6")
{
Lb_result.Text = "发布成功";
}
else
{
Lb_result.Text = "取消发布成功";
}
}
else
{
if (state == "6")
{
Lb_result.Text = "发布失败";
}
else
{
Lb_result.Text = "取消发布失败";
}
}
}
protected void Lbtn_OK_Click(object sender, EventArgs e)
{
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
int result = -1;
note.Name = TB_name.Value;
note.UnitCode = _user.UnitCode;
note.IsApproved = false;
//note.Memo = "";
try
{
Stream myStream = File1.PostedFile.InputStream;
int imgDataLen = File1.PostedFile.ContentLength;
byte[] imgData = new byte[imgDataLen];
myStream.Read(imgData, 0, imgDataLen);
note.File = imgData;
note.ContentType = File1.PostedFile.ContentType;
string fielName = File1.PostedFile.FileName;
int i = fielName.LastIndexOf('.');
note.FileType = fielName.Substring(i + 1, fielName.Length - i - 1);
}
catch
{
}
note.log_moduleName = ModuleName;
note.log_userName = _user.UserName;
note.Memo = TA_Memo.Value;
if (HF_Operate.Value == "add")
{
note.AddPerson = User.Identity.Name;
note.DYear = Request["year"].ToString();
note.DMonth = Request["month"].ToString();
result = note.Insert();
}
if (HF_Operate.Value == "edit")
{
note.ChgPerson = User.Identity.Name;
note.ID = Int32.Parse(HF_ID.Value);
result = note.Update();
}
Response.Write("<script language='javascript'>javascript:var s=new Object();s.success=true;s.data='"+result+"';window.returnValue=s;self.close();</script>");
}
protected void Lbtn_del_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ChgPerson = User.Identity.Name;
note.log_moduleName = ModuleName;
note.log_userName = _user.UserName;
result = note.Delete();
if (result == 0)
{
GridBind();
Lb_result.Text = "删除成功";
}
else
{
Lb_result.Text = "删除失败";
}
}
public void UpdateGridSource()
{
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
DataTable dt = note.getCoulmnNamesByID();
int j;
if (dt.Rows.Count > 0)
{
//for (i = 0; i < GridSource.Rows.Count; i++)
//{
// if (GridSource.Rows[i]["ID"].ToString() == dt.Rows[0]["ID"].ToString())
// {
for (j = 0; j < dt.Columns.Count; j++)
{
GridSource.Rows[GridView1.SelectedIndex][j] = dt.Rows[0][j];
}
// break;
// }
//}
}
}
public void UpdateGridSource()
{
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
DataTable dt = note.getCoulmnNamesByID();
int j;
if (dt.Rows.Count > 0)
{
//for (i = 0; i < GridSource.Rows.Count; i++)
//{
// if (GridSource.Rows[i]["ID"].ToString() == dt.Rows[0]["ID"].ToString())
// {
for (j = 0; j < dt.Columns.Count; j++)
{
GridSource.Rows[GridView1.SelectedIndex][j] = dt.Rows[0][j];
}
// break;
// }
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ModuleKey = "010101";
ModuleName = "日常办公－通知通告";
Response.Cache.SetExpires(DateTime.Now);
Response.Cache.SetCacheability(HttpCacheability.Public);
Response.Cache.SetValidUntilExpires(true);
if (!IsPostBack)
{
string operate = Request["code"].ToString();
HF_Operate.Value = operate;
if (operate != "add")
{
string id = Request["id"].ToString();
HF_ID.Value = id;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(id);
DataTable table = note.getOriginTableByID();
TB_name.Value = table.Rows[0]["name"].ToString();
TA_Memo.Value = table.Rows[0]["memo"].ToString();
this.Title = "修改通知通告";
}
}
}
public void DownContent(int ID)
{
Lb_result.Text = "";
EnterpriseOpration.Notification filePub = new EnterpriseOpration.Notification();
filePub.ID = ID;
DataTable dt = filePub.getOriginTableByID();
if (dt.Rows[0]["thefile"] != System.DBNull.Value)
{
byte[] thefile = (byte[])dt.Rows[0]["thefile"];
string fileName = dt.Rows[0]["name"].ToString() + "." + dt.Rows[0]["filetype"].ToString();
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
this.Response.ContentType = dt.Rows[0]["ContentType"].ToString();
this.Response.AppendHeader("Content-Disposition", "attachment;filename = " + fileName);
this.Response.OutputStream.Write(thefile, 0, thefile.Length);
this.Response.OutputStream.Close();
HttpContext.Current.Response.End();
}
else
{
Lb_result.Text = "本记录没有文件！";
}
}
protected void Page_Load(object sender, EventArgs e)
{
ModuleKey = "010101";
ModuleName = "日常办公－通知通告";
Response.Cache.SetExpires(DateTime.Now);
Response.Cache.SetCacheability(HttpCacheability.Public);
Response.Cache.SetValidUntilExpires(true);
if (!IsPostBack)
{
string operate = Request["code"].ToString();
HF_Operate.Value = operate;
if (operate != "add")
{
string id = Request["id"].ToString();
HF_ID.Value = id;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(id);
DataTable table = note.getOriginTableByID();
TB_name.Value = table.Rows[0]["name"].ToString();
TA_Memo.Value = table.Rows[0]["memo"].ToString();
this.Title = "修改通知通告";
}
}
}
protected void Lbtn_newsContent_Click(object sender, EventArgs e)
{
Lb_result.Text = "";
EnterpriseOpration.Notification filePub = new EnterpriseOpration.Notification();
filePub.ID = Convert.ToInt32(Request["__EVENTARGUMENT"]);
DataTable dt = filePub.getOriginTableByID();
if (dt.Rows[0]["thefile"] != System.DBNull.Value)
{
byte[] thefile = (byte[])dt.Rows[0]["thefile"];
string fileName = dt.Rows[0]["name"].ToString() + "." + dt.Rows[0]["filetype"].ToString();
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
this.Response.ContentType = dt.Rows[0]["ContentType"].ToString();
this.Response.AppendHeader("Content-Disposition", "attachment;filename = " + fileName);
this.Response.OutputStream.Write(thefile, 0, thefile.Length);
this.Response.OutputStream.Close();
HttpContext.Current.Response.End();
}
else
{
Lb_result.Text = "本记录没有文件！";
}
}
public void DownContent(int ID)
{
Lb_result.Text = "";
EnterpriseOpration.Notification filePub = new EnterpriseOpration.Notification();
filePub.ID = ID;
DataTable dt = filePub.getOriginTableByID();
if (dt.Rows[0]["thefile"] != System.DBNull.Value)
{
byte[] thefile = (byte[])dt.Rows[0]["thefile"];
string fileName = dt.Rows[0]["name"].ToString() + "." + dt.Rows[0]["filetype"].ToString();
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
this.Response.ContentType = dt.Rows[0]["ContentType"].ToString();
this.Response.AppendHeader("Content-Disposition", "attachment;filename = " + fileName);
this.Response.OutputStream.Write(thefile, 0, thefile.Length);
this.Response.OutputStream.Close();
HttpContext.Current.Response.End();
}
else
{
Lb_result.Text = "本记录没有文件！";
}
}
protected void PagerButtonClick(object sender, EventArgs e)
{
try
{
int pagenum = total / (GridView1.PageSize);
if (GridView1.PageSize * pagenum < total)
pagenum += 1;
if (txt_page.Text == "0")
txt_page.Text = "1";
else if (int.Parse(txt_page.Text) > pagenum)
txt_page.Text = pagenum.ToString();
GridView1.SelectedIndex = -1;
HF_Key.Value = "";
HF_State.Value = "";
linkBtnPage.CommandName = txt_page.Text;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ordername = ViewState["SortExpression"].ToString();
note.orderMenthod = ViewState["SortDirection"].ToString();
note.UnitCode = _user.UnitCode;
note.DYear = DDL_Year.SelectedValue;
note.DMonth = DDL_Month.SelectedValue;
if (DDL_State.SelectedValue != "")
note.State = int.Parse(DDL_State.SelectedValue);
currentPage = Convert.ToInt32(((LinkButton)sender).CommandName);
GridSource = note.getOriginDataTableWithPublish(GridView1.PageSize, currentPage);
GridBindFAPR();
//给HF和Session赋值
HF_total.Value = total.ToString();
HF_currentPage.Value = currentPage.ToString();
Session["GridSource"] = GridSource;
}
catch
{
Lb_result.Text = "输入页码非法！";
}
}
protected void Lbtn_publish_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ChgPerson = User.Identity.Name;
string state = Request["__EVENTARGUMENT"];
result = note.Publish(state);
if (result == 0)
{
//for (int i = 0; i < GridSource.Rows.Count; i++)
//{
// if (GridSource.Rows[i]["ID"].ToString() == HF_Key.Value)
// {
GridSource.Rows[GridView1.SelectedIndex]["state"] = state;
GridSource.Rows[GridView1.SelectedIndex]["chgDate"] = note.ChgDate;
// break;
// }
//}
GridBindFAPR();
if (state == "6")
Lb_result.Text = "发布成功";
else
Lb_result.Text = "取消发布成功";
}
else
{
if (state == "6")
Lb_result.Text = "发布失败";
else
Lb_result.Text = "取消发布失败";
}
}
protected void Lbtn_newsContent_Click(object sender, EventArgs e)
{
Lb_result.Text = "";
EnterpriseOpration.Notification filePub = new EnterpriseOpration.Notification();
filePub.ID = Convert.ToInt32(Request["__EVENTARGUMENT"]);
DataTable dt = filePub.getOriginTableByID();
if (dt.Rows[0]["thefile"] != System.DBNull.Value)
{
byte[] thefile = (byte[])dt.Rows[0]["thefile"];
string fileName = dt.Rows[0]["name"].ToString() + "." + dt.Rows[0]["filetype"].ToString();
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
this.Response.ContentType = dt.Rows[0]["ContentType"].ToString();
this.Response.AppendHeader("Content-Disposition", "attachment;filename = " + fileName);
this.Response.OutputStream.Write(thefile, 0, thefile.Length);
this.Response.OutputStream.Close();
HttpContext.Current.Response.End();
}
else
{
Lb_result.Text = "本记录没有文件！";
}
}
protected void Lbtn_finish_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ChgPerson = User.Identity.Name;
result = note.Finish();
if (result == 0)
{
//if (GridSource.Rows[GridView1.SelectedIndex]["ID"].ToString() == HF_Key.Value)
// {
GridSource.Rows[GridView1.SelectedIndex]["state"] = "2";
GridSource.Rows[GridView1.SelectedIndex]["chgDate"] = note.ChgDate;
// break;
//}
Lb_result.Text = "提交完毕";
GridBindFAPR();
}
else
Lb_result.Text = "提交完成失败";
}
protected void Lbtn_del_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ChgPerson = User.Identity.Name;
note.log_moduleName = ModuleName;
note.log_userName = _user.UserName;
result = note.Delete();
if (result == 0)
{
GridBind();
Lb_result.Text = "删除成功";
}
else
Lb_result.Text = "删除失败";
}
protected void Lbtn_approve_Click(object sender, EventArgs e)
{
int result = -1;
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ID = Int32.Parse(HF_Key.Value);
note.ApprovePerson = User.Identity.Name;
string app = Request["__EVENTARGUMENT"];
if (app == "0")
note.IsApproved = true;
else
note.IsApproved = false;
note.log_moduleName = ModuleName;
note.log_userName = _user.UserName;
result = note.Approve();
if (result == 0)
{
//for (int i = 0; i < GridSource.Rows.Count; i++)
//{
// if (GridSource.Rows[i]["ID"].ToString() == HF_Key.Value)
// {
if (app == "0")
GridSource.Rows[GridView1.SelectedIndex]["state"] = "4";
else
GridSource.Rows[GridView1.SelectedIndex]["state"] = "3";
GridSource.Rows[GridView1.SelectedIndex]["chgDate"] = note.ChgDate;
//break;
// }
//}
GridBindFAPR();
Lb_result.Text = "审批完毕";
}
else
Lb_result.Text = "审批失败";
}
//第一次进入、查询、添加、删除和排序时使用
protected void GridBind()
{
EnterpriseOpration.Notification note = new EnterpriseOpration.Notification();
note.ordername = ViewState["SortExpression"].ToString();
note.orderMenthod = ViewState["SortDirection"].ToString();
note.UnitCode = _user.UnitCode;
note.DYear = DDL_Year.SelectedValue;
note.DMonth = DDL_Month.SelectedValue;
if (DDL_State.SelectedValue != "")
note.State = int.Parse(DDL_State.SelectedValue);
GridSource = note.getOriginDataTableWithPublish(GridView1.PageSize, currentPage);
if (GridSource.Rows.Count == 0 && currentPage > 1)
{
currentPage--;
GridSource = note.getOriginDataTableWithPublish(GridView1.PageSize, currentPage);
}
total = note.total;
GridView1.DataSource = GridSource;
GridView1.DataKeyNames = new string[] { "tableid", "name", "state", "islocked", "unitcode" };
GridView1.DataBind();
GridView1.SelectedIndex = -1;
HF_Key.Value = "";
HF_State.Value = "";
//给HF和Session赋值
HF_total.Value = total.ToString();
HF_currentPage.Value = currentPage.ToString();
Session["GridSource"] = GridSource;
}