companyclass.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>
	/// CompanyClass 的摘要说明。
	/// </summary>
	public class CompanyClass : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.DropDownList Actived;
		protected System.Web.UI.WebControls.TextBox des;
		protected System.Web.UI.HtmlControls.HtmlInputButton btAdd;
		protected System.Web.UI.WebControls.TextBox Name;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.HtmlControls.HtmlInputHidden myid;
		private int pageCount
		{
			get{return Convert.ToInt32(this.ViewState["pageCount"]);}
			set{this.ViewState["pageCount"]=value;}
		}
		private string ClassID
		{
			get{return Convert.ToString(this.ViewState["ClassID"]);}
			set{this.ViewState["ClassID"]=value;}
		}
		private string ClassName
		{
			get{return Convert.ToString(this.ViewState["ClassName"]);}
			set{this.ViewState["ClassName"]=value;}
		}
		private string Des
		{
			get{return Convert.ToString(this.ViewState["Des"]);}
			set{this.ViewState["Des"]=value;}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
                this.ShowData();
			}
		}

		#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_1);
			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 ShowData()
		{			
//Common.Common.ShowMessageBox("ShowData");
			this.pageCount=Common.DataPager.GetPageCount("CompanyClass","");
			this.AspNetPager1.RecordCount=this.pageCount;
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyClass","*","CompanyClassID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,"");
			//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>";
		}
		private void btAdd_ServerClick(object sender, System.EventArgs e)
		{
			HTMS.BLL.CompanyClass temp=new HTMS.BLL.CompanyClass();
			HTMS.Model.CompanyClass commpanyclass=new HTMS.Model.CompanyClass();
			commpanyclass.CompanyClassID=Common.GetNextId.getNextID("CompanyClass","CompanyClassID");
			commpanyclass.CompanyClassName=this.Name.Text;
			commpanyclass.CompanyClassDes=this.des.Text;
			commpanyclass.Param=this.Actived.SelectedValue;
			this.showmessage(temp.Add(commpanyclass));
			this.ShowData();
		}
		private void showmessage(int count)
		{
			if(count<=0)
				Common.Common.ShowMessageBox("操作失败");
			else
			{	
				Common.Common.ShowMessageBox("操作成功");
			}
		}

		

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{//Common.Common.ShowMessageBox("DataGrid1_ItemCommand");
			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 CompanyClass set param='"+isFreeze+"' where CompanyClassID='"+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 SetView(bool enable)
		{
			
		}

		private void AspNetPager1_PageChanged(object src, HTMS.Web.AspNetPager.PageChangedEventArgs e)
		{
			//if(!Page.IsPostBack)
			{
				//Common.Common.ShowMessageBox("AspNetPager1_PageChanged");
				this.AspNetPager1.CurrentPageIndex=e.NewPageIndex;
				this.AspNetPager1.PageSize=e.NewPageSize;			
				//this.ShowData();
			}
		}

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

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

		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//Common.Common.ShowMessageBox("DataGrid1_UpdateCommand");
			//Common.ShowMessageBox.ShowMessage(((System.Web.UI.WebControls.TextBox)e.Item.Cells[0].Controls[0]).Text);
			HTMS.BLL.CompanyClass temp=new HTMS.BLL.CompanyClass();
			HTMS.Model.CompanyClass commpanyclass=new HTMS.Model.CompanyClass();
			
			//temp.Update(
			// Common.ShowMessageBox.ShowMessage(e.Item.Cells[2].Controls.Count.ToString());
			commpanyclass.CompanyClassID=this.ClassID;
			commpanyclass.CompanyClassName=((System.Web.UI.WebControls.TextBox)e.Item.Cells[2].Controls[0]).Text;
			commpanyclass.CompanyClassDes=((System.Web.UI.WebControls.TextBox)e.Item.Cells[3].Controls[0]).Text;
			//Common.ShowMessageBox.ShowMessage(commpanyclass.CompanyClassName);
			//this.showmessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("CompanyClass_Update",commpanyclass.CompanyClassID,commpanyclass.CompanyClassName,commpanyclass.CompanyClassDes));
			this.showmessage(HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery("update CompanyClass set CompanyClassName='"+commpanyclass.CompanyClassName+"',CompanyClassDes='"+commpanyclass.CompanyClassDes+"' where CompanyClassID='"+commpanyclass.CompanyClassID+"'"));
			//Common.ShowMessageBox.ShowMessage("update CompanyClass set CompanyClassName='"+commpanyclass.CompanyClassName+"',CompanyClassDes='"+commpanyclass.CompanyClassDes+"' where CompanyClassID='"+commpanyclass.CompanyClassID+"'");
			//this.Label1.Text="update CompanyClass set CompanyClassName='"+commpanyclass.CompanyClassName+"',CompanyClassDes='"+commpanyclass.CompanyClassDes+"' where CompanyClassID='"+commpanyclass.CompanyClassID+"'";
			this.DataGrid1.EditItemIndex=-1;
			this.ShowData();			
		}

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

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			
		}

		private void DataGrid1_ItemDataBound_1(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('你确定要删除吗?');");
			}
		}
	}
}