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;
}
}
