public override void Read(AssetReader reader) { base.Read(reader); Rect.Read(reader); Offset.Read(reader); if (HasBorder(reader.Version)) { Border.Read(reader); } PixelsToUnits = reader.ReadSingle(); if (HasPivot(reader.Version)) { Pivot.Read(reader); } Extrude = reader.ReadUInt32(); if (HasPolygon(reader.Version)) { IsPolygon = reader.ReadBoolean(); reader.AlignStream(); } #if UNIVERSAL if (HasAtlasName(reader.Flags)) { AtlasName = reader.ReadString(); PackingTag = reader.ReadString(); } #endif if (HasRendererData(reader.Version)) { RenderDataKey = reader.ReadTupleTLong <GUID>(); AtlasTags = reader.ReadStringArray(); SpriteAtlas.Read(reader); } RD.Read(reader); #if UNIVERSAL if (HasAtlasRD(reader.Version, reader.Flags)) { AtlasRD.Read(reader); } #endif reader.AlignStream(); if (HasPhysicsShape(reader.Version)) { PhysicsShape = reader.ReadAssetArrayArray <Vector2f>(); } if (HasBones(reader.Version)) { Bones = reader.ReadAssetArray <SpriteBone>(); } #if UNIVERSAL if (HasSpriteID(reader.Version, reader.Flags)) { SpriteID = reader.ReadString(); } #endif }
private void Frm_Load(object sender, EventArgs e) //加载ComboBox的一些选项 { LinkSQL linksql = new LinkSQL(); //创建数据库连接对象 System.Data.SqlClient.SqlDataReader RD; //创建一个对像接收查询的返回数据 linksql.OpenSQL(); //打开数据库 linksql.SQLSelect(@"select ID from department"); //查询部门编号 RD = linksql.Comm.ExecuteReader(); while (RD.Read()) { department_ID.Items.Add(Convert.ToString(RD[0])); //将查询的结果添加到department_ID上 } sex.Items.Add("男"); sex.Items.Add("女"); linksql.CloseSQL(); //关闭数据库 linksql.OpenSQL(); //打开数据库 linksql.SQLSelect(@"select name from post"); //查询职位 RD = linksql.Comm.ExecuteReader(); while (RD.Read()) { post.Items.Add(Convert.ToString(RD[0])); //将查询的结果添加到post上 } linksql.CloseSQL(); //关闭数据库 }
private void DepartmentTextChange_Click(object sender, EventArgs e) { post.Items.Clear(); LinkSQL linksql = new LinkSQL(); //创建数据库连接对象 System.Data.SqlClient.SqlDataReader RD; //创建一个对像接收查询的返回数据 linksql.OpenSQL(); //打开数据库 linksql.SQLSelect(@"select name from post where department_ID='" + department_ID.Text + "'"); //查询职位 RD = linksql.Comm.ExecuteReader(); while (RD.Read()) { post.Items.Add(Convert.ToString(RD[0])); //将查询的结果添加到post上 } linksql.CloseSQL(); //关闭数据库 }
public override void Read(AssetReader reader) { base.Read(reader); Rect.Read(reader); Offset.Read(reader); if (IsReadBorder(reader.Version)) { Border.Read(reader); } PixelsToUnits = reader.ReadSingle(); if (IsReadPivot(reader.Version)) { Pivot.Read(reader); } Extrude = reader.ReadUInt32(); if (IsReadPolygon(reader.Version)) { IsPolygon = reader.ReadBoolean(); reader.AlignStream(AlignType.Align4); } if (IsReadRendererData(reader.Version)) { RenderDataKey = reader.ReadTupleTLong <EngineGUID>(); m_atlasTags = reader.ReadStringArray(); SpriteAtlas.Read(reader); } RD.Read(reader); reader.AlignStream(AlignType.Align4); if (IsReadPhysicsShape(reader.Version)) { int count = reader.ReadInt32(); m_physicsShape = new Vector2f[count][]; for (int i = 0; i < count; i++) { m_physicsShape[i] = reader.ReadArray <Vector2f>(); } } if (IsReadBones(reader.Version)) { m_bones = reader.ReadArray <SpriteBone>(); } }
public override void Read(AssetStream stream) { base.Read(stream); Rect.Read(stream); Offset.Read(stream); if (IsReadBorder(stream.Version)) { Border.Read(stream); } PixelsToUnits = stream.ReadSingle(); if (IsReadPivot(stream.Version)) { Pivot.Read(stream); } Extrude = stream.ReadUInt32(); if (IsReadPolygon(stream.Version)) { IsPolygon = stream.ReadBoolean(); stream.AlignStream(AlignType.Align4); } if (IsReadRendererData(stream.Version)) { RenderDataKey = stream.ReadTupleTLong <UtinyGUID>(); m_atlasTags = stream.ReadStringArray(); SpriteAtlas.Read(stream); } RD.Read(stream); stream.AlignStream(AlignType.Align4); if (IsReadPhysicsShape(stream.Version)) { int count = stream.ReadInt32(); m_physicsShape = new Vector2f[count][]; for (int i = 0; i < count; i++) { m_physicsShape[i] = stream.ReadArray <Vector2f>(); } } }
private void Alter2_Click(object sender, EventArgs e) //应到签到修改按钮事件 { Initial_Data(); foreach (Label a in tableHead) { a.Visible = true; } putIn.Visible = true; callOff.Visible = true; LinkSQL linksql = new LinkSQL(); System.Data.SqlClient.SqlDataReader RD; int z = 0; //行控制 count = 0; //清空记录 //AlterSelect(); //根据部门选择查询 if (((Button)sender).Name == "alter2") { //linksql.OpenSQL(); label12.Text = ((Button)sender).Name.ToString(); RD = AlterSelect(); while (RD.Read()) { count++; if (count <= 8) { for (int i = 0; i < RD.FieldCount; i++) { tableLabel1[i + z].Visible = true; switch (i) { case 0: case 1: tableLabel1[i + z].Visible = true; tableLabel1[i + z].Text = Convert.ToString(RD[i]); break; case 2: tableTextBox1[(count - 1) * 2].Visible = true; tableTextBox1[(count - 1) * 2].Text = Convert.ToString(RD[i]); tableLabel1[i + z].Visible = false; break; case 3: switch (Convert.ToInt16(RD[i])) //判断上班的值:0为不用上班,1为正常上班,2为特殊情况 签到:0为未签到,1为已签到,2为请假 { //tableLabel1[i + z].Visible = true; case 0: tableLabel1[i + z].Text = "×"; break; case 1: tableLabel1[i + z].Text = "√"; break; case 2: tableLabel1[i + z].Text = "○"; break; } break; case 4: tableLabel1[i + z].Text = Convert.ToString(RD[i]); break; } } } if (count % 8 == 0) //新的一页重置格式控制 { z = -5; } if (count > 8 && count <= 16) { for (int i = 0; i < RD.FieldCount; i++) { //tableLabel2[i + z].Visible = true; switch (i) { case 0: case 1: //tableLabel1[i + z].Visible = true; tableLabel2[i + z].Text = Convert.ToString(RD[i]); break; case 2: case 3: switch (Convert.ToInt16(RD[i])) //判断上班的值:0为不用上班,1为正常上班,2为特殊情况 签到:0为未签到,1为已签到,2为请假 { //tableLabel1[i + z].Visible = true; case 0: tableLabel2[i + z].Text = "×"; break; case 1: tableLabel2[i + z].Text = "√"; break; case 2: tableLabel2[i + z].Text = "○"; break; } break; case 4: tableLabel2[i + z].Text = Convert.ToString(RD[i]); break; } } } z += 5; } linksql.CloseSQL(); } if (((Button)sender).Name == "alter3") { label12.Text = ((Button)sender).Name.ToString(); count = 0; linksql.OpenSQL(); RD = AlterSelect(); //int j = 0; while (RD.Read()) { count++; if (count <= 8) { for (int i = 0; i < RD.FieldCount; i++) { tableLabel1[i + z].Visible = true; switch (i) { case 0: case 1: tableLabel1[i + z].Visible = true; tableLabel1[i + z].Text = Convert.ToString(RD[i]); break; case 2: switch (Convert.ToInt16(RD[i])) //判断上班的值:0为不用上班,1为正常上班,2为特殊情况 签到:0为未签到,1为已签到,2为请假 { //tableLabel1[i + z].Visible = true; case 0: tableLabel1[i + z].Text = "×"; break; case 1: tableLabel1[i + z].Text = "√"; break; case 2: tableLabel1[i + z].Text = "○"; break; } tableLabel1[i + z].Visible = true; break; case 3: tableLabel1[i + z].Visible = false; tableTextBox1[count * 2 - 1].Visible = true; tableTextBox1[count * 2 - 1].Text = Convert.ToString(RD[i]); //j++; break; case 4: tableLabel1[i + z].Text = Convert.ToString(RD[i]); break; } } } if (count % 8 == 0) //新的一页重置格式控制 { z = -5; } if (count > 8 && count <= 16) { //j = 0; for (int i = 0; i < RD.FieldCount; i++) { //tableLabel2[i + z].Visible = true; switch (i) { case 0: case 1: //tableLabel1[i + z].Visible = true; tableLabel2[i + z].Text = Convert.ToString(RD[i]); break; case 2: switch (Convert.ToInt16(RD[i])) //判断上班的值:0为不用上班,1为正常上班,2为特殊情况 签到:0为未签到,1为已签到,2为请假 { //tableLabel1[i + z].Visible = true; case 0: tableLabel2[i + z].Text = "×"; break; case 1: tableLabel2[i + z].Text = "√"; break; case 2: tableLabel2[i + z].Text = "○"; break; } break; case 3: case 4: tableLabel2[i + z].Text = Convert.ToString(RD[i]); break; } } } z += 5; } linksql.CloseSQL(); } pageNow.Text = "1"; //当前页码 pageAll.Text = ((count / 9) + 1).ToString(); //总页面数量 if (int.Parse(pageAll.Text) > 1) { pageUp.Visible = true; pageDown.Visible = true; //MessageBox.Show("共" + pageAll.Text + "页"); } foreach (TextBox a in tableTextBox1) { a.TextChanged += TextBoxChange_Click; } }
private void LookUp2_Click(object sender, EventArgs e) //应到、签到人数查看按钮事件 { Initial_Data(); foreach (Label a in tableHead) { a.Visible = true; } int z = 0; count = 0; //z格式控制,count数据的行数 //--------------------------------------以上为初始化---------------------------// LinkSQL linksql = new LinkSQL(); //创建数据库连接对像linksql System.Data.SqlClient.SqlDataReader RD; linksql.OpenSQL(); switch (((Button)sender).Name) //判断引发事件的按钮 { case "callOff": case "lookUp2": //应到人员 switch (label4.Text) //根据部门选择查询 { case "采购部": linksql.SQLSelect(@"select a.employee_ID,a.employee_Name,a.shc,a.sign_in,b.post from sign as a,employee as b where a.employee_ID=b.ID and b.department_ID = 'PU0001' and (shc=1 or shc=2)"); break; case "仓储部": linksql.SQLSelect(@"select a.employee_ID,a.employee_Name,a.shc,a.sign_in,b.post from sign as a,employee as b where a.employee_ID=b.ID and b.department_ID = 'ST0001' and (shc=1 or shc=2)"); break; } break; case "lookUp3": //实到人员 switch (label4.Text) //根据部门选择查询 { case "采购部": linksql.SQLSelect(@"select a.employee_ID,a.employee_Name,a.shc,a.sign_in,b.post from sign as a,employee as b where a.employee_ID=b.ID and b.department_ID = 'PU0001' and (sign_in=1 or sign_in=2)"); break; case "仓储部": linksql.SQLSelect(@"select a.employee_ID,a.employee_Name,a.shc,a.sign_in,b.post from sign as a,employee as b where a.employee_ID=b.ID and b.department_ID = 'ST0001' and (sign_in=1 or sign_in=2)"); break; } break; } RD = linksql.Comm.ExecuteReader(); while (RD.Read()) { count++; if (count <= 8) { for (int i = 0; i < RD.FieldCount; i++) { tableLabel1[i + z].Visible = true; switch (i) { case 0: case 1: //tableLabel1[i + z].Visible = true; tableLabel1[i + z].Text = Convert.ToString(RD[i]); break; case 2: case 3: switch (Convert.ToInt16(RD[i])) //判断上班的值:0为不用上班,1为正常上班,2为特殊情况 签到:0为未签到,1为已签到,2为请假 { //tableLabel1[i + z].Visible = true; case 0: tableLabel1[i + z].Text = "×"; break; case 1: tableLabel1[i + z].Text = "√"; break; case 2: tableLabel1[i + z].Text = "○"; break; } break; case 4: tableLabel1[i + z].Text = Convert.ToString(RD[i]); break; } } } if (count % 8 == 0) //新的一页重置格式控制 { z = -5; } if (count > 8 && count <= 16) { for (int i = 0; i < RD.FieldCount; i++) { tableLabel2[i + z].Visible = false; //tableLabel2[i + z].Text = Convert.ToString(RD[i]); switch (i) { case 0: case 1: //tableLabel1[i + z].Visible = true; tableLabel2[i + z].Text = Convert.ToString(RD[i]); break; case 2: case 3: switch (Convert.ToInt16(RD[i])) //判断上班的值:0为不用上班,1为正常上班,2为特殊情况 签到:0为未签到,1为已签到,2为请假 { //tableLabel1[i + z].Visible = true; case 0: tableLabel2[i + z].Text = "×"; break; case 1: tableLabel2[i + z].Text = "√"; break; case 2: tableLabel2[i + z].Text = "○"; break; } break; case 4: tableLabel2[i + z].Text = Convert.ToString(RD[i]); break; } } } z += 5; } linksql.CloseSQL(); //闭关数据库 pageNow.Text = "1"; //当前页码 pageAll.Text = ((count / 9) + 1).ToString(); //总页面数量 if (int.Parse(pageAll.Text) > 1) { pageUp.Visible = true; pageDown.Visible = true; MessageBox.Show("共" + pageAll.Text + "页"); } if (((Button)sender).Name == "alter2") { putIn.Visible = true; callOff.Visible = true; } }
private void LookUp1_Click(object sender, EventArgs e) //部门人数查看,修改按钮事件 { int z = 0; count = 0; //z格式控制,count数据的行数 Initial_Data(); //初始化表格 tableHead[0].Text = ""; tableHead[1].Text = "员工编号"; tableHead[2].Text = "姓名"; tableHead[3].Text = "姓别"; tableHead[4].Text = "职位"; foreach (Label a in tableHead) { a.Visible = true; } LinkSQL linksql = new LinkSQL(); //创建数据库连接对像linksql System.Data.SqlClient.SqlDataReader RD; linksql.OpenSQL(); //打开数据库 switch (label4.Text) //根据部门选择查询 { case "采购部": linksql.SQLSelect(@"select ID,Name,sex,post from employee where department_Id = 'PU0001'"); break; case "仓储部": linksql.SQLSelect(@"select ID,Name,sex,post from employee where department_Id = 'ST0001'"); break; } RD = linksql.Comm.ExecuteReader(); //接收查询结果 while (RD.Read()) //输入查询结果 TODO:暂时只能输出十六条数据 { count++; if (count <= 8) //小于8行,用表1记录 { for (int i = 0; i < RD.FieldCount; i++) { tableLabel1[z].Text = ((z / 5) + 1).ToString(); tableLabel1[z].Visible = true; tableLabel1[i + z + 1].Text = Convert.ToString(RD[i]); tableLabel1[i + z + 1].Visible = true; } } if (count % 8 == 0) { z = 0; } if (count > 8 && count <= 16) //8-16行用表2记录 { z = 0; for (int i = 0; i < RD.FieldCount; i++) { tableLabel2[z].Text = (((z / 5) + 1) + 8).ToString(); tableLabel2[z].Visible = false; tableLabel2[i + z + 1].Text = Convert.ToString(RD[i]); tableLabel2[i + z + 1].Visible = false; } } z += 5; } pageNow.Text = "1"; //当前页码 pageAll.Text = ((count / 9) + 1).ToString(); //总页面数量 linksql.CloseSQL(); //闭关数据库 //if (((Button)sender).Name == "lookUp1") //{ if (int.Parse(pageAll.Text) > 1) { pageUp.Visible = true; pageDown.Visible = true; MessageBox.Show("共" + pageAll.Text + "页"); } //} if (((Button)sender).Name == "alter1") { add.Visible = true; callOff.Visible = true; } }