📄 companybadge.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.CompanyInfo
{
	/// <summary>
	/// CompanyBadge 的摘要说明。
	/// </summary>
	public class CompanyBadge :  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.WebControls.TextBox password;
		protected System.Web.UI.HtmlControls.HtmlInputFile file;
		protected System.Web.UI.HtmlControls.HtmlGenericControl mypassworddiv;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl mybodydiv;
		protected System.Web.UI.WebControls.LinkButton LinkButton3;
		protected System.Web.UI.HtmlControls.HtmlInputText passowrd1;
		protected System.Web.UI.HtmlControls.HtmlInputText passowrd;
		protected System.Web.UI.HtmlControls.HtmlInputHidden myid;
		private string UserID
		{
			get{return Convert.ToString(this.ViewState["UserID"]);}
			set{this.ViewState["UserID"]=value;}
		}
		private string BadgeID
		{
			get{return this.ViewState["BadgeID"].ToString();}
			set{this.ViewState["BadgeID"]=value;}
		}

		private string CompanyID
		{
			get{return Convert.ToString(this.ViewState["CompanyID"]);}
			set{this.ViewState["CompanyID"]=value;}
		}
		private string BadgePassword
		{
			get{return Convert.ToString(this.ViewState["BadgePassword"]);}
			set{this.ViewState["BadgePassword"]=value;}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{	
			this.ClearCache();
			if(!base.CheckUser() )
				{
					return;
				}
			if((this.BadgePassword=Convert.ToString(this.Session["BadgePassword"]))=="")
			{
				this.mybodydiv.Visible=false;
			}
			else
			{
				this.mypassworddiv.Visible=false;
			}
			if(!Page.IsPostBack)
			{
				this.CompanyID=this.Session["CompanyID"].ToString();
				this.showData();				
			}
		}

		protected void ClearCache()
		{
			this.Response.Expires=-1;
			this.Response.ExpiresAbsolute=DateTime.Now.AddSeconds(-1);
			this.Response.CacheControl="no-cache";
		}


		#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.PreRender += new System.EventHandler(this.DataGrid1_PreRender);
			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.LinkButton3.Click += new System.EventHandler(this.LinkButton3_Click);
			this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.btAdd.ServerClick += new System.EventHandler(this.btAdd_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

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

		private void showData()
		{
			string myid=this.CompanyID;
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyBadge","CompanyID = '"+this.CompanyID+"'");
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyBadge","*","CompanyBadgeID",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>";
		}
		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;}
			string myid=e.Item.Cells[0].Text;
			this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("UP_CompanyBadge_Delete",myid));
		}

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

		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="";
				string text=temp.Text.Trim();
				if(temp.Text.Trim()=="点击冻结")
				{
					isFreeze="1";
					temp.Text="点击解冻";
				}
				else
				{
					isFreeze="0";
					temp.Text="点击冻结";
				}
				string sqlstring="update CompanyBadge set IsFreeze='"+isFreeze+"' where CompanyBadgeID='"+e.Item.Cells[0].Text.Trim()+"'";	
				int count=HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring);
				if(count<=0)
				{
					Common.ShowMessageBox.ShowMessage("操作错误!");
					temp.Text=text;
				}
				else
				{
					//Common.ShowMessageBox.ShowMessage("操作成功!");
				}
			}
			if(e.CommandName=="Edit")
			{
				/*&int count=e.Item.Cells[2].Controls.Count;
				string text=e.Item.Cells[2].Text;					
				//System.Web.UI.WebControls.Literal my=((System.Web.UI.WebControls.Literal)e.Item.Cells[2].Controls[0]);
				System.Web.UI.WebControls.LinkButton temp=(System.Web.UI.WebControls.LinkButton)e.Item.Cells[2].Controls[1];
				System.Web.UI.WebControls.TextBox mybox=new System.Web.UI.WebControls.TextBox();
				mybox.Text=temp.Text;
				e.Item.Cells[2].Controls.Add(mybox);
				temp.Visible=false;
				Common.Common.ShowMessageBox(e.Item.Cells[2].Controls.Count.ToString());
				//Common.ShowMessageBox.ShowMessage(e.Item.Cells[2].Controls.t*/
			}
			if(e.CommandName=="showImage")
			{
				if(System.Web.HttpUtility.HtmlDecode(e.Item.Cells[0].Text).Trim()=="")
				{Common.ShowMessageBox.ShowMessage("请先取消编辑操作,再重新尝试");return;}
				string BadgeID=e.Item.Cells[0].Text;
				string url="ShowBadge_main.aspx?BadgeID="+BadgeID;
				Common.Windows.OpenModalWindow(this,url,500,500);
			}
		}

		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[4].Controls[0];				
					//temp.Width=System.Web.UI.WebControls.Unit.Pixel(72);
					temp.MaxLength=200;
					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=50;	
					temp.Style.Add("width","100%");
				}
				catch(Exception e1)
				{}
				try
				{
					int count=e.Item.Cells[2].Controls.Count;
					System.Web.UI.WebControls.LinkButton temp=(System.Web.UI.WebControls.LinkButton)e.Item.Cells[2].Controls[1];
					System.Web.UI.WebControls.TextBox mybox=(System.Web.UI.WebControls.TextBox)e.Item.Cells[2].Controls[3];//new System.Web.UI.WebControls.TextBox();
					mybox.Text=temp.Text;
					mybox.Style.Add("width","100%");
					mybox.Visible=true;
					//e.Item.Cells[2].Controls.Add(mybox);
					temp.Visible=false;
					//Common.Common.ShowMessageBox(e.Item.Cells[2].Controls.Count.ToString());
				}
				catch(System.Exception ees)
				{
					throw ees;
				}
			}
			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[8].Controls[0];
				tempbutton.Attributes.Add("onclick","return window.confirm('你确定要删除吗?');");
			}
		}

		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			int count=e.Item.Cells[2].Controls.Count;			
			string name=((TextBox)e.Item.Cells[2].Controls[3]).Text;
			string password=((TextBox)e.Item.Cells[3].Controls[0]).Text;
			string des=((TextBox)e.Item.Cells[4].Controls[0]).Text;
			((TextBox)e.Item.Cells[2].Controls[3]).Visible=false;
			((LinkButton)e.Item.Cells[2].Controls[1]).Visible=true;
			this.DataGrid1.EditItemIndex=-1;
			this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("CompanyBadge_Update",this.BadgeID,name,password,des));
			
		}

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

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

		private void btAdd_ServerClick(object sender, System.EventArgs e)
		{
			//string myid=
			if(this.file.PostedFile.ContentType.ToString().IndexOf("image")==-1)
			{
				Common.Common.ShowMessageBox("请上传图片类型的文件,try Again");return;
			}
			string extendName=System.IO.Path.GetExtension(this.file.PostedFile.FileName);

			this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("ComapnyBadge_Add",Common.GetNextId.getNextID("CompanyBadge","CompanyBadgeID"),this.Name.Text,this.password.Text,this.GetData(),this.des.Text,extendName,this.Actived.SelectedValue,this.CompanyID));
		}

		private byte [] GetData()
		{
			try
			{
				System.Web.HttpPostedFile myfile=this.file.PostedFile;
				int length=myfile.ContentLength;
				byte [] mydata=new byte[length];
				myfile.InputStream.Read(mydata,0,length);
				return mydata;
			}
			catch(System.Exception ee)
			{
				throw new Exception(ee.Message);
			}
		}

		private void  Submit1_ServerClick(object sender, System.EventArgs e)
		{
			this.UserID=this.Session["UserID"].ToString();
			//string password=this.passowrd1.Value;
			System.Data.DataTable mytable=HTMS.SQLServerDAL.DAL.DAI.RunProcTable("Sys_UserGetBadgePwdByUserID",this.UserID,this.passowrd.Value);
			if(mytable==null || mytable.Rows.Count<=0)
			{
				Common.Common.ShowMessageBox("密码不正确");
			}
			else
			{
				this.Session["BadgePassword"]=mytable.Rows[0]["Param"];
				this.Response.Redirect("CompanyBadge.aspx");		
			}
			
		}

		private void LinkButton3_Click(object sender, System.EventArgs e)
		{
			this.Session["BadgePassword"]=null;
			//this.Response.Write("<script language='javascript'>window.location.reload();</script>");
			this.Response.Redirect("CompanyBadge.aspx");
		}
		/*
		 *	System.Drawing.Bitmap temp=new Bitmap(400,400);
			System.Drawing.Graphics mygraphics=System.Drawing.Graphics.FromImage(temp);
			mygraphics.FillRectangle(new System.Drawing.SolidBrush(System.Drawing.Color.YellowGreen),40,40,40,40);
			System.IO.MemoryStream memory=new System.IO.MemoryStream();
			temp.Save(memory,System.Drawing.Imaging.ImageFormat.Gif);
			byte [] buffer=memory.ToArray();
			System.Data.SqlClient.SqlConnection myconnection=new System.Data.SqlClient.SqlConnection("server=localhost;database=ImageTest;uid=sa;pwd=001");
			myconnection.Open();
			System.Windows.Forms.MessageBox.Show(myconnection.)
				System.Data.SqlClient.SqlCommand mycommands=new System.Data.SqlClient.SqlCommand("insert into imagetest(@name,@password,@content) values(@name,@password,@content)");
			mycommands.Parameters.Add("@name",SqlDbType.VarChar,50).Value="ygs";
			mycommands.Parameters.Add("@password",SqlDbType.VarChar,50).Value="ygs";
			mycommands.Parameters.Add("@contentType",SqlDbType.Image).Value=buffer;
			int i=mycommands.ExecuteNonQuery();
			if(i<=0)
			{
				System.Windows.Forms.MessageBox.Show("error");
			}
			else
			{
				System.Windows.Forms.MessageBox.Show("succed");
			}						
		 */
	}
}
⌨️ 快捷键说明

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