private void ZoomCurrentMap(byte flag)
{
int index = tabControl1.SelectedIndex;
if (flag == 0)
{
zoom[index] += 0.1;
}
else
{
zoom[index] -= 0.1;
}
int x = 0;
int y = 0;
tabControl1.TabPages[index].Controls[0].Width = Convert.ToInt32(picW[index] * zoom[index]);
tabControl1.TabPages[index].Controls[0].Height = Convert.ToInt32(picH[index] * zoom[index]);
for (int i = 0; i < tabControl1.TabPages[index].Controls[0].Controls.Count; i++)
{
doorInfo = (TMapDoorInfo)tabControl1.TabPages[index].Controls[0].Controls[i].Tag;
tabControl1.TabPages[index].Controls[0].Controls[i].Width = Convert.ToInt32(mapSize * zoom[index]);
tabControl1.TabPages[index].Controls[0].Controls[i].Height = Convert.ToInt32(mapSize * zoom[index]);
x = Convert.ToInt32(doorInfo.X * zoom[index]);
y = Convert.ToInt32(doorInfo.Y * zoom[index]);
tabControl1.TabPages[index].Controls[0].Controls[i].Location = new Point(x, y);
}
}
private void LoadData()
{
button2.Enabled = false;
DataTableReader dr = null;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (!IsAdd)
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "1", SysID }));
if (dr.Read())
{
txtName.Text = dr["MapName"].ToString();
byte[] buff = (byte[])(dr["mapPic"]);
if (buff.Length > 0)
{
MemoryStream ms = new MemoryStream(buff);
picMap.Image = Image.FromStream(ms);
ms.Close();
button2.Enabled = true;
}
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "8", SysID }));
int x = 0;
int y = 0;
while (dr.Read())
{
doorInfo = new TMapDoorInfo(dr["MacDoorSysID"].ToString(), dr["MacSN"].ToString(),
dr["MacDoorID"].ToString(), dr["MacDoorName"].ToString());
int.TryParse(dr["LocationX"].ToString(), out x);
int.TryParse(dr["LocationY"].ToString(), out y);
DrawMapDot(x, y);
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
}
private void button2_Click(object sender, EventArgs e)
{
frmMJMapAddDoor frm = new frmMJMapAddDoor(Title, button2.Text, SysID);
frm.doorList.Clear();
for (int j = 0; j < picMap.Controls.Count; j++)
{
doorInfo = (TMapDoorInfo)picMap.Controls[j].Tag;
frm.doorList.Add(doorInfo);
}
if (frm.ShowDialog() == DialogResult.OK)
{
bool isFind;
int l = 0;
int t = 0;
const int spa = 5;
while (picMap.Controls.Count > 0)
{
picMap.Controls[0].Dispose();
}
for (int i = 0; i < frm.doorList.Count; i++)
{
isFind = false;
for (int j = 0; j < picMap.Controls.Count; j++)
{
doorInfo = (TMapDoorInfo)picMap.Controls[j].Tag;
if (doorInfo.DoorSysID == frm.doorList[i].DoorSysID)
{
isFind = true;
break;
}
}
if (isFind)
{
continue;
}
doorInfo = frm.doorList[i];
DrawMapDot(l, t);
l += mapSize + spa;
if (l + mapSize + spa > picMap.Width)
{
l = 0;
t += mapSize + spa;
}
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
doorList.Clear();
TMapDoorInfo doorInfo;
for (int i = 0; i < dataGrid.RowCount; i++)
{
if (Pub.ValueToBool(dataGrid[0, i].EditedFormattedValue))
{
doorInfo = new TMapDoorInfo(dataGrid[2, i].Value.ToString(), dataGrid[3, i].Value.ToString(),
dataGrid[4, i].Value.ToString(), dataGrid[5, i].Value.ToString());
doorList.Add(doorInfo);
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
protected override void ExecItemRefresh()
{
DateTime StartTime = DateTime.Now;
RefreshMsg(StrReading);
while (tabControl1.TabPages.Count > 0)
{
while (tabControl1.TabPages[0].Controls.Count > 0)
{
tabControl1.TabPages[0].Controls[0].Dispose();
}
tabControl1.TabPages[0].Dispose();
}
tabControl1.TabPages.Clear();
DataTableReader dr = null;
DataTableReader dr1 = null;
TabPage page;
PictureBox pic;
MemoryStream ms;
int w;
int h;
int x = 0;
int y = 0;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "0" }));
while (dr.Read())
{
page = new TabPage();
page.Text = dr["MapName"].ToString();
page.Tag = dr["MapSysID"].ToString();
page.AutoScroll = true;
page.Name = "tabPage" + tabControl1.TabPages.Count.ToString();
pic = new PictureBox();
pic.Name = "pic" + tabControl1.TabPages.Count.ToString();
pic.SizeMode = PictureBoxSizeMode.AutoSize;
byte[] buff = (byte[])(dr["mapPic"]);
if (buff.Length > 0)
{
ms = new MemoryStream(buff);
pic.Image = Image.FromStream(ms);
ms.Dispose();
}
w = pic.Width;
h = pic.Height;
pic.SizeMode = PictureBoxSizeMode.Zoom;
pic.Width = w;
pic.Height = h;
page.Controls.Add(pic);
pic.Left = 0;
pic.Top = 0;
tabControl1.TabPages.Add(page);
dr1 = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "8", page.Tag.ToString() }));
while (dr1.Read())
{
doorInfo = new TMapDoorInfo(dr1["MacDoorSysID"].ToString(), dr1["MacSN"].ToString(),
dr1["MacDoorID"].ToString(), dr1["MacDoorName"].ToString());
int.TryParse(dr1["LocationX"].ToString(), out x);
int.TryParse(dr1["LocationY"].ToString(), out y);
doorInfo.X = x;
doorInfo.Y = y;
doorInfo.MacConnType = dr1["MacConnType"].ToString();
doorInfo.MacIPAddress = dr1["MacIPAddress"].ToString();
doorInfo.MacPort = dr1["MacPort"].ToString();
doorInfo.MacConnPWD = dr1["MacConnPWD"].ToString();
DrawMapDot(pic, x, y);
}
dr1.Close();
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
if (dr1 != null)
{
dr1.Close();
}
dr1 = null;
}
RefreshForm(true);
RefreshMsg(StrReadEnd + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true);
picW = new int[tabControl1.TabPages.Count];
picH = new int[tabControl1.TabPages.Count];
zoom = new double[tabControl1.TabPages.Count];
for (int i = 0; i < zoom.Length; i++)
{
picW[i] = tabControl1.TabPages[i].Controls[0].Width;
picH[i] = tabControl1.TabPages[i].Controls[0].Height;
zoom[i] = 1;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
if (name == "")
{
txtName.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
if (!Pub.CheckTextMaxLength(label1.Text, name, txtName.MaxLength))
{
txtName.Focus();
return;
}
if (picMap.Image == null)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
return;
}
DataTableReader dr = null;
bool IsOk = true;
List <string> sql = new List <string>();
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (IsAdd)
{
if (!db.GetServerGUID(ref SysID))
{
return;
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "2", name }));
if (dr.Read())
{
txtName.Focus();
ShowErrorCannotRepeated(label1.Text);
IsOk = false;
}
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "4", SysID, name }));
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "3", SysID, name }));
if (dr.Read())
{
txtName.Focus();
ShowErrorCannotRepeated(label1.Text);
IsOk = false;
}
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "5", SysID, name }));
}
if (IsOk)
{
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "9", SysID }));
for (int j = 0; j < picMap.Controls.Count; j++)
{
doorInfo = (TMapDoorInfo)picMap.Controls[j].Tag;
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "10", SysID, doorInfo.DoorSysID,
picMap.Controls[j].Location.X.ToString(), picMap.Controls[j].Location.Y.ToString() }));
}
if (db.ExecSQL(sql) != 0)
{
IsOk = false;
}
}
if (IsOk)
{
byte[] buff = new byte[0];
MemoryStream ms = new MemoryStream();
Bitmap t = new Bitmap(picMap.Image);
t.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
buff = ms.ToArray();
db.UpdateByteData(Pub.GetSQL(DBCode.DB_003007, new string[] { "6", SysID }), "mapPic", buff);
}
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
