form1.cs

lgxgrid控件lgxgrid控件lgxgrid控件lgxgrid控件lgxgrid控件lgxgrid控件

			((System.ComponentModel.ISupportInitialize)(this.axlgxgrid2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		public static cs Mf;
		[STAThread]
		static void Main() 
		{
			
			//Fors.Ef=new cs();
			Application.Run(new cs());
		}

		private void cs_Load(object sender, System.EventArgs e)
		{
			 
			string Pt;
			Pt=Application.StartupPath;
			if (Pt.Length>3)
				Pt=(Pt+"\\");
			string sjkf;
			sjkf = "Driver={Microsoft Access Driver (*.mdb)}; DBQ="+Pt+"cs.mdb;";
			mysjk.Open(sjkf,null,null,0);

			axlgxgrid1.UsDataBase =mysjk; //将数据对象连接到Lgxgrid控件
			
			//为控件添加列,参数依次为:列标题,模式(1为textbox,2为combox),列宽,是否允许编辑
			axlgxgrid1.hadd("班别", 1, 800, true,null);
			axlgxgrid1.hadd ("学生姓名", 2, 820, true,null);
			axlgxgrid1.hadd ("语文", 1, 620, true,null);
			axlgxgrid1.hadd ("数学", 1, 620, true,null);
			axlgxgrid1.hadd ("英语", 1, 620, true,null);
			axlgxgrid1.hadd ("物理", 1, 620, true,null);
			axlgxgrid1.hadd ("化学", 1, 620, true,null);
			axlgxgrid1.hadd ("总分", 1, 800, false,null);
			axlgxgrid1.hadd ("平均分", 1, 800, false,null);
			

			//以下合并表头,参数依次为:列标题,起始行号,起始列号,终止行号,终止列号,标识(首次合并为1)
			
			axlgxgrid1.Unite ("班" +(char)13+"别", 0, 0, 1, 0, 1,null);
			axlgxgrid1.Unite ("学  生"+(char)13+"姓  名", 0, 1, 1, 1, 1,null);
			axlgxgrid1.Unite ("各 科 成 绩", 0, 2, 0, 6, 1,null);
			axlgxgrid1.Unite ("统  计", 0, 7, 0, 8, 1,null);
			axlgxgrid1.Unite ("语文", 1, 2, 1, 2, 1,null);
			axlgxgrid1.Unite ("数学", 1, 3, 1, 3, 1,null);
			axlgxgrid1.Unite ("英语", 1, 4, 1, 4, 1,null);
			axlgxgrid1.Unite ("物理", 1, 5, 1, 5, 1,null);
			axlgxgrid1.Unite ("化学", 1, 6, 1, 6, 1,null);
			axlgxgrid1.Unite ("总分", 1, 7, 1, 7, 1,null);
			axlgxgrid1.Unite ("平均分", 1, 8, 1, 8, 1,null);

			axlgxgrid1.Slwok = true; //使列宽可以拖动
	
			for(int i=1;i<=axlgxgrid1.rows;i++)
			{
				axlgxgrid1.SbackColor(i,8,0xf8e8d8);
			}
			
			for(int i=1;i<=axlgxgrid1.rows;i++)
			{
				axlgxgrid1.SbackColor(i,9,0xe8d8f8);
			}
		
		}



		private void axlgxgrid1_MouseDownEvent(object sender, AxLgxgridV10.__lgxgrid_MouseDownEvent e)
		{
			if(chok)textBox1.Text ="MouseDown事件发生，参数返回值：button="+e.button+"，shift="+e.shift+"，x="+e.x+"，y="+e.y+(char)13+"\n"+textBox1.Text;
			if(e.button ==2)
			{
				Point  t;
				t=new Point();
				t.X=(int)e.x;
				t.Y=(int)e.y+axlgxgrid1.Top;
				this.contextMenu1.Show(this,t);
			}
		}

		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(axlgxgrid1.BackColor.ToString() );
		}

		private void menuItem4_Click(object sender, System.EventArgs e)
		{
			if (axlgxgrid1.CloseAdd ==true)
			{
				axlgxgrid1.CloseAdd=false;
			}
			else
			{
				axlgxgrid1.CloseAdd =true;
			}

		}

		private void menuItem5_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(""+axlgxgrid1.lists);
		}

		private void menuItem6_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.GridUnite((int)axlgxgrid1.Nrow,(short)axlgxgrid1.Nlist,(int)axlgxgrid1.NrowEnd,(short)axlgxgrid1.NlistEnd ,0);
		}

		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(axlgxgrid1.ForeColor.ToString () );

		}

		private void menuItem7_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.HbackColor=Color.FromArgb(100,203, 235,215);
		}

		private void menuItem9_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.HforeColor =Color.Red;
		}

		private void menuItem10_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.LineColor=Color.FromArgb(108,100,100,200);
		}

		private void menuItem11_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.SplitGrid((int)axlgxgrid1.Nrow, (short)axlgxgrid1.Nlist);
		}

		private void menuItem13_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(""+axlgxgrid1.Nlist);
		}

		private void menuItem14_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(""+axlgxgrid1.NlistEnd);
		}

		private void menuItem15_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(""+axlgxgrid1.Nrow);
		}

		private void menuItem16_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(""+axlgxgrid1.NrowEnd);
		}

		private void menuItem17_Click(object sender, System.EventArgs e)
		{
			try
			{
				Fors.Ef =this;
				int Hs;
				Form2 Nf=new Form2();
				Nf.Text ="请输入要设置的行高：";
				Nf.ShowDialog();
				Hs=int.Parse(Nf.textBox1.Text);
				int oldH;
				oldH=axlgxgrid1.Height;
				axlgxgrid1.RowsMode =false;
				axlgxgrid1.RowHeight =Hs;
				axlgxgrid1.Height =oldH;				
			}
			catch(Exception error)
			{ MessageBox.Show(error.Message,"出错啦！");}
			
				
		}

		private void menuItem18_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(""+axlgxgrid1.rows);
		}

		private void menuItem19_Click(object sender, System.EventArgs e)
		{
			if (axlgxgrid1.Slwok ==true)
			{
				axlgxgrid1.Slwok =false;
			}
			else
			{
				axlgxgrid1.Slwok =true;
			}

		}


		private void menuItem23_Click(object sender, System.EventArgs e)
		{
			ADODB.Recordset myre;
			object p=null;
			myre=mysjk.Execute("select * from cjb;",out p,0);
			int i=1;
			int j=0;
			string Dt;
			while(!myre.EOF)
			{
				for(j=0;j<=myre.Fields.Count-1;j++)
				{
					Dt=""+myre.Fields[j].Value;
					axlgxgrid1.SetData(i,j+1,Dt);

				}
				myre.MoveNext();
				i++;
			}
			myre.Close();
		}

		private void axlgxgrid1_DataChang(object sender, AxLgxgridV10.__lgxgrid_DataChangEvent e)
		{
			if (e.olddata!="" && e.olddata !="0" && e.newData !="")
				if(chok)textBox1.Text ="DataChang事件发生，参数返回值：hid="+e.hid+"，lid="+e.lid+"，oldData="+e.olddata+"，newData="+e.newData+(char)13+"\n"+textBox1.Text;
			int ok;
			ok=(int)e.lid;
			if(ok<8)
			{
				float Zf=0;
				float Pjf=0;
				//MessageBox.Show(""+axlgxgrid1.rows);
				for(int i=0;i<=4;i++)
				{
					if(axlgxgrid1.GetData(e.hid,i+3)!="")
						Zf=Zf+float.Parse(axlgxgrid1.GetData(e.hid,i+3));
				}
				Pjf=Zf/5;
				axlgxgrid1.SetData(e.hid,8,""+Zf);
				axlgxgrid1.SetData(e.hid,9,""+Pjf);
				
			}
		}

		private void menuItem25_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.Gridclear();
		}

		private void menuItem27_Click(object sender, System.EventArgs e)
		{
			LgxgridV10.PrinterInfos pr;
			pr = axlgxgrid1.PrinterInfoGet();
			pr.TitleText = "2004年春初中学生成绩表";
			pr.TableHeadFont.Size = 12;
			pr.TableHeadFont.Name = "宋体";
			pr.TableHeadFont.Bold = false;
			pr.ColorOrBlack = 1;
			pr.MainFont.Size = 12;
			pr.Ltext = "填表单位：";
			pr.TableTop = pr.TableTop - 0.6;
			pr.ULtext = "填表人：";
			pr.UBtext = "负责人：";
			pr.URtest = "审批人：         ";
			pr.TellText = "说明：（1）各班主任要在期考后3天内把成绩交教导处。" + (char)13+"\n" + "      （2）各班班主任要写好质量分析。";
			//(char)13+"\n"为插入一个回车换行符
			pr.ListScale = 1.7;
			//pr.RowH = 600;
			pr.LineWidth = 1;
			axlgxgrid1.PrinterInfoSet(pr);
			axlgxgrid1.SetPrintShow();
		}

		private void menuItem28_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.clear();
			for(int i=1;i<=axlgxgrid1.rows;i++)
			{
				axlgxgrid1.SbackColor(i,8,0xf8e8d8);
			}
			
			for(int i=1;i<=axlgxgrid1.rows;i++)
			{
				axlgxgrid1.SbackColor(i,9,0xe8d8f8);
			}
		}

		private void menuItem29_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.InRow(axlgxgrid1.Nrow);
		}

		private void menuItem30_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.DelRow(axlgxgrid1.Nrow);
			for(int i=1;i<=axlgxgrid1.rows;i++)
			{
				axlgxgrid1.SbackColor(i,8,0xf8e8d8);
			}
			
			for(int i=1;i<=axlgxgrid1.rows;i++)
			{
				axlgxgrid1.SbackColor(i,9,0xe8d8f8);
			}
		}

		private void menuItem31_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.OrderList(1,axlgxgrid1.rows,1,LgxgridV10.px.Depress,LgxgridV10.pxmode.CharacterMode);
		}

		private void menuItem32_Click(object sender, System.EventArgs e)
		{
			int r1,r2,l1,l2;
			r1=axlgxgrid1.Nrow;
			r2=axlgxgrid1.NrowEnd;
			l1=axlgxgrid1.Nlist;
			l2=axlgxgrid1.NlistEnd;
			for(int i=r1;i<=r2;i++)
			{
				for(int j=l1;j<=l2;j++)
				{axlgxgrid1.SbackColor(i ,j ,0x7fa8f0);}
			}
		}									

		private void menuItem34_Click(object sender, System.EventArgs e)
		{
			int r1,r2,l1,l2;
			r1=axlgxgrid1.Nrow;
			r2=axlgxgrid1.NrowEnd;
			l1=axlgxgrid1.Nlist;
			l2=axlgxgrid1.NlistEnd;
			for(int i=r1;i<=r2;i++)
			{
				for(int j=l1;j<=l2;j++)
				{axlgxgrid1.SForeColor (i ,j ,0x9f3f00);}
			}
		}

		private void menuItem35_Click(object sender, System.EventArgs e)
		{
			Color ys;
			ys=axlgxgrid1.GetBackColor(axlgxgrid1.Nrow,axlgxgrid1.Nlist);
			MessageBox.Show(""+ys.ToString());
		}

		private void menuItem36_Click(object sender, System.EventArgs e)
		{
			Color ys;
			ys=axlgxgrid1.GetForeColor(axlgxgrid1.Nrow,axlgxgrid1.Nlist);
			MessageBox.Show(""+ys.ToString());
		}

		private void menuItem37_Click(object sender, System.EventArgs e)
		{
			stdole.StdFont zt=new stdole.StdFontClass();
			zt.Name ="隶书";
			zt.Size =14;
			axlgxgrid1.SetFont(axlgxgrid1.Nrow,axlgxgrid1.Nlist,zt);
		}

		private void menuItem38_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.Copy();
		}

		private void menuItem39_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.Plaster();
		}

		private void menuItem41_Click(object sender, System.EventArgs e)
		{
			LgxgridV10.PrinterInfos pr;
			pr = axlgxgrid1.PrinterInfoGet();
			pr.TitleText = "2004年春初中学生成绩表";
			pr.TableHeadFont.Size = 9;
			pr.TableHeadFont.Name = "宋体";
			pr.TableHeadFont.Bold = false;