📄 bargainsearch.aspx.cs

📁 合同管理合同管理合同管理
💻 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>
	/// BargainSearch 的摘要说明。
	/// </summary>
	public class BargainSearch : HTMS.Web.CompanySysMange.BasePage
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Label Label1;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		protected System.Web.UI.HtmlControls.HtmlInputText startdate;
		protected System.Web.UI.HtmlControls.HtmlInputText enddate;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit2;
		protected System.Web.UI.WebControls.DropDownList bClass;
		protected System.Web.UI.WebControls.DropDownList bEffe;
		protected System.Web.UI.HtmlControls.HtmlInputText bDes;
		protected System.Web.UI.HtmlControls.HtmlInputText title;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
	
		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(!Page.IsPostBack)
			{
				if(!base.CheckUser())
				{return;}
				this.CompanyID=this.Session["CompanyID"].ToString();				
				this.showClass();
				this.showData();
			}
		}
		
		private void showClass()
		{
			System.Data.DataTable mytable=HTMS.SQLServerDAL.DAL.DAI.RunProcTable("BargainClass_GetClassIDNameByCompanyID",this.CompanyID);
			this.bClass.DataTextField="ClassName";
			this.bClass.DataValueField="ClassID";
			this.bClass.DataSource=mytable;
			this.bClass.DataBind();
			this.bClass.Items.Insert(0,new System.Web.UI.WebControls.ListItem("为选择","-1"));
		}
		private void showData()
		{
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyBargainInfo as a ,CompanyBargainRel as b,BargainClass as c,CompanyBadge as d",this.GetWhereString());
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyBargainInfo as a ,CompanyBargainRel as b,BargainClass as c,CompanyBadge as d","a.*,b.*,c.ClassName,d.BadgeName","a.BargainID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,this.GetWhereString());
			if(mytable==null)return;		
			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>";
			this.Label1.Text=this.GetWhereString();
		}

		private string GetWhereString()
		{
			System.Text.StringBuilder mybuilder=new System.Text.StringBuilder();
			if(this.title.Value!="")
			{
				mybuilder.Append(" a.BargainTitle like '%"+this.title.Value.Replace(" ","%")+"%' and ");				
			}

			//CompanyBargainInfo as a ,CompanyBargainRel as b,BargainClass as c,CompanyBadge as d","*","a.BargainID"

			if(this.bClass.SelectedValue!="-1")
			{
				mybuilder.Append(" b.BargainClassID ='"+this.bClass.SelectedValue+"' and");
			}
			if(this.bEffe.SelectedValue!="-1")
			{
				mybuilder.Append(" a.IsEfficacy ='"+this.bEffe.SelectedValue+"' and");
			}
			if(this.startdate.Value!="" && this.enddate.Value!="" )
			{
				mybuilder.Append("( BargainStartTime >= '"+this.startdate.Value+"' and BargainOverTime =<'"+this.enddate.Value+"') and )");
			}
			else
			{
				if(this.startdate.Value!="" && this.enddate.Value=="")
				{
					mybuilder.Append("(BargainStartTime >='"+this.startdate.Value+"') and ");
				}
				if(this.enddate.Value!="" && this.startdate.Value=="")
				{
					mybuilder.Append(" BargainOverTime <= '"+this.enddate.Value+"' and ");
				}
			}
			if(this.bDes.Value!="")
			{
				mybuilder.Append(" BargainDes like '%"+this.bDes.Value.Replace(" ","%")+"%' and ");
			}

			mybuilder.Append("a.BargainID = b.BargainID and isDelete='0' and c.ClassID = b.BargainClassID and c.CompanyID=b.CompanyID and d.CompanyBadgeID=b.CompanyBadgeID  and b.CompanyID='"+this.CompanyID+"'");
			return mybuilder.ToString();
		}

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType == System.Web.UI.WebControls.ListItemType.Item)
				SetSubmit(e.Item);
		}

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void SetSubmit(System.Web.UI.WebControls.DataGridItem myitem)
		{	
			if(myitem.Cells[10].Text=="1" && myitem.Cells[11].Text=="0")
			{
				System.Web.UI.WebControls.HyperLink myLink=(System.Web.UI.WebControls.HyperLink)myitem.Cells[6].FindControl("HyperLink3");
				myLink.Text="点击签章";myLink.NavigateUrl="_blank";myLink.NavigateUrl="Bargain.aspx?BargainID="+myitem.Cells[0].Text;
			}
			else
			{
				System.Web.UI.WebControls.HyperLink myLink=(System.Web.UI.WebControls.HyperLink)myitem.Cells[6].FindControl("HyperLink3");
				myLink.Text="已经签章";
			}
			if(myitem.Cells[10].Text=="1" && myitem.Cells[18].Text=="0")
			{
				System.Web.UI.WebControls.HyperLink myLink=(System.Web.UI.WebControls.HyperLink)myitem.Cells[6].FindControl("HyperLink5");
				myLink.Text="提交到  ";myLink.NavigateUrl="_blank";myLink.NavigateUrl="BargainDetails.aspx?BargainID="+myitem.Cells[0].Text;
			}
			else
			{
				System.Web.UI.WebControls.HyperLink myLink=(System.Web.UI.WebControls.HyperLink)myitem.Cells[6].FindControl("HyperLink5");
				myLink.Text="已经提交";
			}
			if(myitem.Cells[13].Text=="2")
			{
				System.Web.UI.WebControls.HyperLink myLink=(System.Web.UI.WebControls.HyperLink)myitem.Cells[6].FindControl("HyperLink4");
				myLink.Text="通过对方签章";
			}
			else
			{
				System.Web.UI.WebControls.HyperLink myLink=(System.Web.UI.WebControls.HyperLink)myitem.Cells[6].FindControl("HyperLink4");
				myLink.Text="对方尝未签章";
			}
			if(myitem.Cells[14].Text=="1")
			{
				((System.Web.UI.WebControls.Label)myitem.Cells[7].FindControl("Label4")).Text="生效日期:"+DateTime.Parse(myitem.Cells[16].Text).ToLongDateString()+">>";
			}
			else
			{
				((System.Web.UI.WebControls.Label)myitem.Cells[7].FindControl("Label4")).Text="起草日期:"+DateTime.Parse(myitem.Cells[17].Text).ToLongDateString()+">>";
			}
			if(myitem.Cells[14].Text!="1")
			{
				myitem.Cells[12].Controls[1].Visible=false;
			}
			else
			{
				((System.Web.UI.WebControls.HyperLink)myitem.Cells[12].Controls[1]).NavigateUrl="DownLoadBargain.aspx?BargainID='"+myitem.Cells[0].Text+"'";
			}
		}
		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string sqlstring="update CompanyBargainRel set IsDelete='1' where  BargainID='"+e.Item.Cells[0].Text+"' and CompanyID ='"+this.CompanyID+"'";
			this.Showessage(HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring));
			this.showData();
		}

		private void Showessage(int count)
		{
			if(count<=0)
				Common.Common.ShowMessageBox("操作失败");
			else
				Common.Common.ShowMessageBox("操作成功");

		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			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.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.Submit2.ServerClick += new System.EventHandler(this.Submit2_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Submit2_ServerClick(object sender, System.EventArgs e)
		{
			this.Response.Redirect("Bargain.aspx");
		}

		private void Submit1_ServerClick(object sender, System.EventArgs e)
		{
			this.Label1.Text=this.GetWhereString();
			this.showData();
		}

		private void DataGrid2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

	}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -