companyoperationclass.aspx.cs

合同管理 合同管理 合同管理

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace HTMS.Web.SysManage.CompanyManage
{
	/// <summary>
	/// CompanyOperationClass 的摘要说明。
	/// </summary>
	public class CompanyOperationClass : HTMS.Web.CompanySysMange.BasePage
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		protected System.Web.UI.WebControls.TextBox Name;
		protected System.Web.UI.WebControls.DropDownList Actived;
		protected System.Web.UI.WebControls.TextBox des;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.HtmlControls.HtmlInputButton btAdd;
		protected System.Web.UI.HtmlControls.HtmlInputHidden myid;
	
		private string ClassID
		{
			get{return Convert.ToString(this.ViewState["ClassID"]);}
			set{this.ViewState["ClassID"]=value;}
		}
		private string CompanyID
		{
			get{return Convert.ToString(this.ViewState["CompanyID"]);}
			set{this.ViewState["CompanyID"]=value;}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!base.CheckUser())
			{
				return;
			}
			if(!this.Page.IsPostBack)
			{
				//if((this.CompanyID=Convert.ToString(this.Session["CompanyID"])=="")
				this.CompanyID=Convert.ToString(this.Session["CompanyID"]);
				this.ShowData();
			}
		}
		private void ShowData()
		{
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyOperationClass","CompanyID = '"+this.CompanyID+"'");
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyOperationClass","*","OperationClassID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,"CompanyID = '"+this.CompanyID+"'");
			//this.DataGrid1.EditItemIndex=-1;				 
			this.DataGrid1.DataSource=mytable;
			this.DataGrid1.DataBind();
			AspNetPager1.CustomInfoText = "记录总数：<font color=\"blue\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";
			AspNetPager1.CustomInfoText += " 总页数：<font color=\"blue\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";
			AspNetPager1.CustomInfoText += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
			this.AspNetPager1.PageChanged += new HTMS.Web.AspNetPager.PageChangedEventHandler(this.AspNetPager1_PageChanged);
			this.btAdd.ServerClick += new System.EventHandler(this.btAdd_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="freeze")
			{
				System.Web.UI.WebControls.LinkButton temp=(System.Web.UI.WebControls.LinkButton)e.CommandSource;
				string isFreeze="";
				if(temp.Text.Trim()=="点击冻结类型")
				{
					isFreeze="1";
					temp.Text="点击解冻类型";
				}
				else
				{
					isFreeze="0";
					temp.Text="点击冻结类型";
				}
				string sqlstring="update CompanyOperationClass set param='"+isFreeze+"' where OperationClassID='"+e.Item.Cells[0].Text.Trim()+"'";	
				int count=HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring);
				if(count<=0)
				{
					Common.ShowMessageBox.ShowMessage("操作错误!");
				}
				else
				{
					//Common.ShowMessageBox.ShowMessage("操作成功!");
				}
			}
		}

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType == System.Web.UI.WebControls.ListItemType.EditItem)
			{
				try
				{
					TextBox temp=(TextBox)e.Item.Cells[2].Controls[0];				
					temp.Width=System.Web.UI.WebControls.Unit.Pixel(72);
					temp.MaxLength=100;
					temp.Style.Add("width","100%"); 
				}
				catch(Exception er)
				{}
				try
				{				
					TextBox temp=(TextBox)e.Item.Cells[3].Controls[0];
					temp.Width=System.Web.UI.WebControls.Unit.Pixel(175);
					temp.MaxLength=200;	
					temp.Style.Add("width","100%");
				}
				catch(Exception e1)
				{}
				//	temp.Attributes.Add("onclick","window.alert('fdsfds');");
			}
			System.Web.UI.WebControls.ListItemType mytype=e.Item.ItemType;
			if(mytype==ListItemType.EditItem || mytype==ListItemType.Item || mytype==ListItemType.SelectedItem || mytype==ListItemType.AlternatingItem)
			{
				LinkButton tempbutton=(System.Web.UI.WebControls.LinkButton)e.Item.Cells[6].Controls[0];
				tempbutton.Attributes.Add("onclick","return window.confirm('你确定要删除吗?');");
			}
		}

		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			HTMS.BLL.CompanyOperationClass temp=new HTMS.BLL.CompanyOperationClass();
			HTMS.Model.CompanyOperationClass myclass=new HTMS.Model.CompanyOperationClass();
			//string myid=((TextBox)e.Item.Cells[2].Controls[0]).Text;
			string name=((TextBox)e.Item.Cells[2].Controls[0]).Text;
			string Des=((TextBox)e.Item.Cells[3].Controls[0]).Text;
			this.DataGrid1.EditItemIndex=-1;
			this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("CompanyOperationClass_Update",this.ClassID,name,Des));
		}

		private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.DataGrid1.EditItemIndex=-1;
			this.ShowData();
		}

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.Item.Cells[0].Text.Trim()=="")
			{Common.ShowMessageBox.ShowMessage("请先取消编辑操作,再重新尝试");return;}
			HTMS.BLL.CompanyOperationClass temp=new HTMS.BLL.CompanyOperationClass();
			//Common.Common.ShowMessageBox(e.Item.Cells[0].Text);
			this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery("Delete CompanyOperationClass where OperationClassID = '"+e.Item.Cells[0].Text+"'"));
		}

		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.ClassID=e.Item.Cells[0].Text;
			this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
			this.ShowData();
		}

		private void btAdd_ServerClick(object sender, System.EventArgs e)
		{
			HTMS.BLL.CompanyOperationClass temp=new HTMS.BLL.CompanyOperationClass();
			HTMS.Model.CompanyOperationClass myclass=new HTMS.Model.CompanyOperationClass();
			myclass.OperationClassID=Common.GetNextId.getNextID("CompanyOperationClass","OperationClassID");
			string myid=Common.GetNextId.getNextID("CompanyOperationClass","OperationClassID");
			string myid1=myid;
			myclass.OperationName=this.Name.Text;
			myclass.OperationDes=this.des.Text;
			myclass.Param=this.Actived.SelectedValue;
			myclass.CompanyID=this.CompanyID;
			this.showMessage(temp.Add(myclass));
		}

		private void AspNetPager1_PageChanged(object src, HTMS.Web.AspNetPager.PageChangedEventArgs e)
		{
			this.AspNetPager1.CurrentPageIndex=e.NewPageIndex;
			this.AspNetPager1.PageSize=e.NewPageSize;
		}
		private void showMessage(int count)
		{
			if(count<=0)
			{
				Common.Common.ShowMessageBox("操作失败");
			}
			else
			{
				this.ShowData();
				Common.Common.ShowMessageBox("操作成功");
			}
		}
	}
}