form1.cs

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

			pr.ColorOrBlack = 1;
			pr.MainFont.Size = 9;
			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"为插入一个回车换行符，相当于VB的vbCrLf
			pr.ListScale = 1.7;
			pr.RowH = 600;
			pr.LineWidth = 2;
			axlgxgrid1.PrinterInfoSet(pr);
			axlgxgrid1. PrintYes();

		}

		private void cs_Closing(object sender, System.ComponentModel.CancelEventArgs e)
		{
			mysjk.Close();
		}


		private void axlgxgrid1_IntoEdit(object sender, AxLgxgridV10.__lgxgrid_IntoEditEvent e)
		{
			if(chok)textBox1.Text ="IntoEdit事件发生，参数返回值：row="+e.row+"，list="+e.list+"，oldData="+e.olddata+(char)13+"\n"+textBox1.Text;
			if(e.list ==2)
			{
				string sqltxt;
				sqltxt="SELECT 姓名 FROM cjb WHERE 班别='"+axlgxgrid1.GetData(e.row,1)+"';";
				axlgxgrid1.ComAdd(2,"sql",sqltxt);
 
			}
		}

		private void axlgxgrid1_ClickEvent(object sender, System.EventArgs e)
		{
			if(chok)textBox1.Text ="ClickEvent事件发生，无参数返回值"+(char)13+"\n"+textBox1.Text;
			axlgxgrid2.Visible =false;
		}

		private void axlgxgrid1_MouseMoveEvent(object sender, AxLgxgridV10.__lgxgrid_MouseMoveEvent e)
		{
			//if(pdr!=e.row || pdl!=e.list)	
			//{
			//if(chok)textBox1.Text ="MouseMove事件发生，参数返回值：row="+e.row+"，list="+e.list+(char)13+"\n"+textBox1.Text;
			//  pdr=e.row;pdl=e.list;
			//}
		}

		private void axlgxgrid1_ExitEdit(object sender, AxLgxgridV10.__lgxgrid_ExitEditEvent e)
		{
			if(chok)textBox1.Text ="ExitEdit事件发生，参数返回值：row="+e.row+"，list="+e.list+"，oldData="+e.olddata+"，newData="+e.newData+"，cancel="+e.cancel+(char)13+"\n"+textBox1.Text;

		}

		private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
		{
			textBox1.Text ="";
		}

		private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
		{
			if (checkBox1.Checked ==true)
			{
				chok=true;
			}
			else
			{
				chok=false;
			}
		}

		private void axlgxgrid1_RowShow(object sender, AxLgxgridV10.__lgxgrid_RowShowEvent e)
		{
			if(chok)textBox1.Text ="RowShow事件发生，参数返回值：rowBegin="+e.rowBegin+"，rowEnd="+e.rowEnd+(char)13+"\n"+textBox1.Text;
		}

		private void axlgxgrid1_KeyPressEvent(object sender, AxLgxgridV10.__lgxgrid_KeyPressEvent e)
		{
			if(chok)textBox1.Text ="KeyPressEvent事件发生，参数返回值：keyAscii="+e.keyAscii+(char)13+"\n"+textBox1.Text;
		}

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

		private void menuItem43_Click(object sender, System.EventArgs e)
		{
			if(axlgxgrid1.Nrow!=axlgxgrid1.rows)
			{axlgxgrid1.SetNowGrid(axlgxgrid1.rows,axlgxgrid1.lists);}
			else
			{axlgxgrid1.SetNowGrid(1,1);}
		}

		private void axlgxgrid1_GotoNewRow(object sender, AxLgxgridV10.__lgxgrid_GotoNewRowEvent e)
		{
			if(chok)textBox1.Text ="GotoNewLine事件发生，参数返回值：oldRow="+e.oldRow+"，oldList="+e.oldList+"，e.newRow="+e.newRow+"，e.newList="+e.newList+(char)13+"\n"+textBox1.Text;
		}


		private void axlgxgrid1_ExitEditAll(object sender, AxLgxgridV10.__lgxgrid_ExitEditAllEvent e)
		{
			if(chok)textBox1.Text ="ExitEditAll事件发生，参数返回值：row="+e.row +"，list="+e.list +(char)13+"\n"+textBox1.Text;
		}

		private void axlgxgrid1_AddNewRow(object sender, AxLgxgridV10.__lgxgrid_AddNewRowEvent e)
		{
			axlgxgrid1.SbackColor(e.newRow,8,0xf8e8d8);
			axlgxgrid1.SbackColor(e.newRow,9,0xe8d8f8);
			if(chok)textBox1.Text ="AddNewRow事件发生，参数返回值：newRow="+e.newRow +(char)13+"\n"+textBox1.Text;
		}

		private void menuItem44_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.SetData (30000,1,null);
		}

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

		private void menuItem45_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++)
				{  
					if(axlgxgrid1.GetGridEditStyle(i,j)!=true)
					{axlgxgrid1.SetGridEditStyle(i ,j ,true);}
					else
					{
						axlgxgrid1.SetGridEditStyle(i,j,false);
					}			 
				}
			}
		}

		private void menuItem46_Click(object sender, System.EventArgs e)
		{
			stdole.StdFont hf=new stdole.StdFontClass();
			hf.Name ="隶书";
			hf.Size =12;
			axlgxgrid1.SetHeadText(1,1,"班级"+(char)13+"名称",hf);
		}

		private void menuItem47_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show(axlgxgrid1.GetHeadText(1,axlgxgrid1.Nlist));
		}

		private void menuItem48_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.SetListWidth (axlgxgrid1.Nlist,axlgxgrid1.GetListWidth(axlgxgrid1.Nlist)+100);
		}

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

		private void menuItem50_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.SetArea(1,axlgxgrid1.Nlist,axlgxgrid1.rows,axlgxgrid1.Nlist );
		}

		private void menuItem51_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.SetLAlignment(axlgxgrid1.Nrow ,axlgxgrid1.Nlist ,(short)(axlgxgrid1.GetLAlignment (axlgxgrid1.Nrow ,axlgxgrid1.Nlist)+1));
		}

		private void menuItem52_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.SetTAlignment(axlgxgrid1.Nrow ,axlgxgrid1.Nlist ,(short)(axlgxgrid1.GetTAlignment (axlgxgrid1.Nrow ,axlgxgrid1.Nlist)+1));
		}

		private void menuItem22_Click(object sender, System.EventArgs e)
		{
			this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
			axlgxgrid1.RowsAdd(30000);
			this.Cursor = System.Windows.Forms.Cursors.Default;
		}

		private void menuItem44_Click_1(object sender, System.EventArgs e)
		{
			axlgxgrid1.ListLineAdd(axlgxgrid1.Nlist,1,0x0000ff);
		}

		private void menuItem53_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.ListLineUnload (axlgxgrid1.Nlist);
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			if(axlgxgrid1.EditRow >0)
			{MessageBox.Show("正在编辑第"+axlgxgrid1.EditRow +"行第"+axlgxgrid1.EditList +"列的单元格。");}
			else
			{MessageBox.Show ("当前处于非编辑状态。");}
		}

		private void menuItem55_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.DelList();
		}

		private void menuItem54_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.AddList ("新增列",1,800,true,null);
			axlgxgrid1.Unite("新增列",0,(short)(axlgxgrid1.lists -1),1,(short)(axlgxgrid1.lists -1),2,null);		}

		private void menuItem56_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);
				axlgxgrid1.SetdRows(Hs);
				
				
			}
			catch(Exception error)
			{ MessageBox.Show(error.Message,"出错啦！");}
			
		}

		private void menuItem57_Click(object sender, System.EventArgs e)
		{
			try
			{
				Fors.Ef =this;
				Form2 Nf=new Form2();
				int Hs;
				int olists;
				Nf.Text ="请输入要设置的列数：";
				Nf.ShowDialog();
				Hs=int.Parse(Nf.textBox1.Text);
				olists=axlgxgrid1.lists;
				axlgxgrid1.SetLists (Hs,1,800,true);
				for(int i=olists+1;i<=axlgxgrid1.lists;i++)
				{
					axlgxgrid1.Unite(""+i,0,(short)(i-1),1,(short)(i-1),2,null);
				}
			}
			catch(Exception error)
			{ MessageBox.Show(error.Message,"出错啦！");}
		}

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

		private void menuItem59_Click(object sender, System.EventArgs e)
		{
			if(axlgxgrid1.EditAspect==0)
			{axlgxgrid1.EditAspect =1;}
			else
			{axlgxgrid1.EditAspect =0;}

		}

		private void menuItem61_Click(object sender, System.EventArgs e)
		{
			new cs().Show();
		}

		private void menuItem62_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.PrintView();
		}

		private void menuItem63_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);
				axlgxgrid1.SetSonTable(Hs);
				
				
			}
			catch(Exception error)
			{ MessageBox.Show(error.Message,"出错啦！");}
		}

		private void axlgxgrid1_SonTableClick(object sender, AxLgxgridV10.__lgxgrid_SonTableClickEvent e)
		{
			axlgxgrid2.Visible = false;
			axlgxgrid2.SetLists (0, 1, 100, false);
			axlgxgrid2.SetLists (10, 1, 1000, false);
			 
			axlgxgrid2.Left = (int)e.x+10;
			axlgxgrid2.Top = (int)e.y +60;
			if (axlgxgrid2.Top + axlgxgrid2.Height>this.Height)
			{
				axlgxgrid2.Top = (int)e.y+60- axlgxgrid2.Height;
			}
			if (axlgxgrid2.Left + axlgxgrid2.Width>this.Width)
			{
				axlgxgrid2.Left = (int)e.x -10- axlgxgrid2.Width;
			}
			axlgxgrid2.Visible = true;
			for (int i = 1;i<=50;i++)
			{
				for (int j = 1;j<=10;j++)
				{axlgxgrid2.SetData(i, j, axlgxgrid1.GetData (e.row ,e.list ) + i);}
			}
        

		}

		private void axlgxgrid1_HChange(object sender, AxLgxgridV10.__lgxgrid_HChangeEvent e)
		{
			axlgxgrid2.Visible =false;
		}

		private void axlgxgrid1_VChange(object sender, AxLgxgridV10.__lgxgrid_VChangeEvent e)
		{
			axlgxgrid2.Visible =false;
		}

		private void menuItem66_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.SetFunc(7,3,"sum(grid(1:6,3))");
		}

		private void menuItem64_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.CopyFunc();
		}

		private void menuItem65_Click(object sender, System.EventArgs e)
		{
			axlgxgrid1.PlasterFunc();
		}


	}

}