bargainlist.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.Bargain
{
	/// <summary>
	/// BargainList1 的摘要说明。
	/// </summary>
	public class BargainList1 : HTMS.Web.CompanySysMange.BasePage
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
	
		public string CompanyID
		{
			get{return Convert.ToString(this.ViewState["CompanyID"]);}
			set{this.ViewState["CompanyID"]=value;}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
				if(!base.CheckUser())
				{return;}
				this.CompanyID=this.Session["CompanyID"].ToString();
			}
		}

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

		}
		#endregion
		private void showData()
		{
			 this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("Sys_Bargain",this.GetWhereString());
			System.Data.DataTable mytable=Common.DataPager.GetPageData("Sys_Bargain","a.*,b.BargainID,b.BargainTile","a.Sys_BargainID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,this.GetWhereString());
			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 string GetWhereString()
		{
			System.Text.StringBuilder mybuilder=new System.Text.StringBuilder();
			mybuilder.Append("((a.CompanyID1='"+this.CompanyID+"' and a.Delete1='0')) or ((a.CompanyID2='"+this.CompanyID+"' and a.Delete1='0')) and a.Param = b.BargainID");
			return mybuilder.ToString();
		}
		private void AspNetPager1_PageChanged(object src, HTMS.Web.AspNetPager.PageChangedEventArgs e)
		{
			this.AspNetPager1.CurrentPageIndex=e.NewPageIndex;
			this.AspNetPager1.PageSize=e.NewPageSize;
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.Item.ItemType == System.Web.UI.WebControls.ListItemType.Item)
			{
				string myid=e.Item.Cells[8].Text == this.CompanyID ? e.Item.Cells[9].Text : e.Item.Cells[8].Text;
				((System.Web.UI.WebControls.HyperLink)e.Item.FindControl("HyperLink1")).NavigateUrl="../CompanyInfo/CompanyInfo.aspx?CompanyID="+myid;				
			}			
		}

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if((e.Item.Cells[10].Text=="1" || e.Item.Cells[11].Text=="1") && (System.DateTime.Parse(e.Item.Cells[5].Text) < System.DateTime.Now))
			{
				this.ShowMessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("Sys_Bargain_DelteByID",e.Item.Cells[0].Text));
			}
			else
			{
				string mycolumnname= this.CompanyID ==e.Item.Cells[10].Text ? "Delete1" : "Delete2";
				this.ShowMessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("Sys_Bargain_Update_Delete_ByID",e.Item.Cells[0].Text,mycolumnname));
			}
		}
		private void ShowMessage(int count)
		{
			if(count<=0)
			{
				Common.Common.ShowMessageBox("操作失败");
			}
			else
			{
				Common.Common.ShowMessageBox("操作成功");
			}
		}
	}
}