companyrelclass.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.CompanySysMange
{
	/// <summary>
	/// CompanyRelClass 的摘要说明。
	/// </summary>
	public class CompanyRelClass :  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.Label Label1;
		protected System.Web.UI.HtmlControls.HtmlInputButton btAdd;
		protected System.Web.UI.WebControls.TextBox des;
		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)
		{
			//this.CompanyID="0000000001";
			if(!base.CheckUser())
			{
				return;
			}
			if(!this.Page.IsPostBack)
			{			
				this.CompanyID=Convert.ToString(this.Session["CompanyID"]);
				showdata();
				//Common.Common.ShowMessageBox(Common.GetNextId.getNextID("CompanyRelClass","RelClassID"));
			}
		}
		private void showdata()
		{
			//param 排序作用
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyRelClass","CompanyID = '"+this.CompanyID+"'");
			//System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyRelClass","*","Param",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,"");
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyRelClass","*","Param",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,1,"CompanyID = '"+this.CompanyID+"'");
			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.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
			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_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName =="up" || e.CommandName=="down")
			{
				string classID="";
				int currentIndex=e.Item.ItemIndex;//e.Item.Cells[7].Text.Trim();
				string nextIndex="0";
				if(e.CommandName=="up")
				{
					if(e.Item.Cells[0].Text.Trim()=="" )
					{Common.ShowMessageBox.ShowMessage("请先取消编辑操作,再重新尝试");return;}
					if(currentIndex==0)
					{Common.Common.ShowMessageBox("已经是最上面了");return;}
					nextIndex=this.DataGrid1.Items[e.Item.ItemIndex-1].Cells[7].Text;	
					classID=this.DataGrid1.Items[e.Item.ItemIndex-1].Cells[0].Text;
				}
				else if(e.CommandName=="down")
				{
					if(e.Item.Cells[0].Text.Trim()=="" )
					{Common.ShowMessageBox.ShowMessage("请先取消编辑操作,再重新尝试");return;}
					if(currentIndex==this.DataGrid1.Items.Count-1)
					{Common.Common.ShowMessageBox("已经是最下面了");return;}
					nextIndex=this.DataGrid1.Items[e.Item.ItemIndex+1].Cells[7].Text;
					classID=this.DataGrid1.Items[e.Item.ItemIndex+1].Cells[0].Text;
				}
				string sqlstring="update CompanyRelClass set Param = '"+nextIndex+"' where RelClassID ='"+e.Item.Cells[0].Text+"' ";
				sqlstring+="  update CompanyRelClass set param ='"+e.Item.Cells[7].Text+"' where RelClassID ='"+classID+"'";
			//	this.Label1.Text=sqlstring;
				//this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring));
				HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring);
				this.showdata();
			}
		}

		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)
				{}
			}
			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_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 DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.Item.Cells[0].Text.Trim()=="")
			{Common.ShowMessageBox.ShowMessage("请先取消编辑操作,再重新尝试");return;}
			HTMS.BLL.CompanyRelClass temp=new HTMS.BLL.CompanyRelClass();
			this.showMessage(temp.Delete(e.Item.Cells[0].Text));
		}

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

		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			HTMS.BLL.CompanyRelClass temp=new HTMS.BLL.CompanyRelClass();
			HTMS.Model.CompanyRelClass myclass=new HTMS.Model.CompanyRelClass();
			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("CompanyRelClass_Update",this.ClassID,name,des));
		}

		private void btAdd_ServerClick(object sender, System.EventArgs e)
		{
			HTMS.BLL.CompanyRelClass temp=new HTMS.BLL.CompanyRelClass();
			HTMS.Model.CompanyRelClass myclass=new HTMS.Model.CompanyRelClass();
			myclass.RelClassID=Common.GetNextId.getNextID("CompanyRelClass","RelClassID");
			myclass.RelClassName=this.Name.Text;
			myclass.RelClassDes=this.des.Text;

			/////
			///###########################################
			///可以换成一个dropdownlist来给用户展现这个东东
			//////
			myclass.Param=Common.GetNextId.getNextID("CompanyRelClass","Param");
			myclass.CompanyID=this.CompanyID;
			this.showMessage(temp.Add(myclass));
		}
		private void showMessage(int count)
		{
			if(count<=0)
			{
				Common.Common.ShowMessageBox("操作失败");
			}
			else
			{
				this.showdata();
				Common.Common.ShowMessageBox("操作成功");
			}
		}

		private void AspNetPager1_PageChanged(object src, HTMS.Web.AspNetPager.PageChangedEventArgs e)
		{
			this.AspNetPager1.PageSize=e.NewPageSize;
			this.AspNetPager1.CurrentPageIndex=e.NewPageIndex;
		}
	}
}