private void Delete_Agency_Yes()
{
Agencies a = (Agencies)Frm.State;
int l = a.dataGridView1.SelectedRows.Count;
string[] arr = new string[l];
for (int i = 0; i < l; i++)
{
arr[i] = a.dataGridView1.SelectedRows[i].Cells[2].Value.ToString();
}
for (int i = 0; i < l; i++)
{
string SQL1 = "DELETE FROM Agency WHERE Login = "******"' + $"{arr[i]}" + '"';
string SQL4 = "DELETE FROM Vpucherpeople WHERE Login = "******"' + $"{arr[i]}" + '"';
string SQL2 = "DELETE FROM Voucher WHERE Login = "******"' + $"{arr[i]}" + '"';
string SQL3 = "DELETE FROM Account WHERE Login = "******"' + $"{arr[i]}" + '"';
c.Open();
MySqlCommand com2 = new MySqlCommand(SQL2, c);
com2.ExecuteNonQuery();
MySqlCommand com1 = new MySqlCommand(SQL1, c);
com1.ExecuteNonQuery();
MySqlCommand com3 = new MySqlCommand(SQL3, c);
com3.ExecuteNonQuery();
string sql = "SELECT Name, Director,Login, DateLicense, Comission FROM Agency";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView1, reader);
c.Close();
}
a.dataGridView1.ClearSelection();
Frm.Update();
Close();
}
private void AppendPacketLogItems(string orientation, byte[] payload)
{
PacketLogLVI pl = new PacketLogLVI()
{
Index = (Frm.lv_packet_log.Items.Count + 1).ToString(),
Orientation = orientation,
CaptureTime = DateTime.Now.ToString(),
PayloadLen = payload.Length.ToString(),
PayloadData = payload.HexDump(),
Tag = new PacketAnalyzer()
{
HexPayload = payload.HexDump()
}
};
if (orientation == "Send")
{
pl.SrcIp = $"{MatchedSrcIp}:{MatchedSrcPort}";
pl.DstIp = $"{MatchedDstIp}:{MatchedDstPort}";
}
else
{
pl.SrcIp = $"{MatchedDstIp}:{MatchedDstPort}";
pl.DstIp = $"{MatchedSrcIp}:{MatchedSrcPort}";
}
Frm.ThreadSafeUpdate(() =>
{
ListViewItem lv = pl.BuildLVI();
lv.ForeColor = orientation == "Send" ? Color.Red : Color.Blue;
Frm.lv_packet_log.Items.Add(lv);
});
}
private void Delete_Hotel_Yes()
{
Hotels a = (Hotels)Frm.State;
int l = a.dataGridView1.SelectedRows.Count;
int[] arr = new int[l];
for (int i = 0; i < l; i++)
{
arr[i] = Convert.ToInt32(a.dataGridView1.SelectedRows[i].Cells[5].Value.ToString());
}
for (int i = 0; i < l; i++)
{
string SQL1 = "DELETE FROM Voucher USING Voucher, Room WHERE Voucher.IdTypeRoom = Room.ID AND Room.IdHotel = " + '"' + $"{arr[i]}" + '"';
string SQL2 = "DELETE FROM Room WHERE Room.IdHotel = " + '"' + $"{arr[i]}" + '"';
string SQL3 = "DELETE FROM Hotel WHERE Hotel.ID = " + '"' + $"{arr[i]}" + '"';
c.Open();
MySqlCommand com2 = new MySqlCommand(SQL1, c);
com2.ExecuteNonQuery();
MySqlCommand com1 = new MySqlCommand(SQL2, c);
com1.ExecuteNonQuery();
MySqlCommand com3 = new MySqlCommand(SQL3, c);
com3.ExecuteNonQuery();
string sql = "SELECT Hotel.Name, Hotel.Stars, Hotel.Food, City.Name, Country.Name, Hotel.ID FROM Hotel, City, Country WHERE Hotel.IdCity = City.ID AND City.IdCountry = Country.ID";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView1, reader);
c.Close();
}
a.dataGridView1.ClearSelection();
Frm.Update();
Close();
}
public void AbrirForm(String NombreForm, string stFormulario)
{
if (ActiveMdiChild != null)
{
ActiveMdiChild.Close();
}
try
{
//Console.WriteLine("NOMBREFORM "+NombreForm+" STFORMULACIO "+stFormulario);
GenerarOBJNavegador(stFormulario);
Form Frm;
if (!Ins.TryGetValue(NombreForm, out Frm) || Frm.IsDisposed)
{
Frm = (Form)Activator.CreateInstance(null, NombreForm).Unwrap();
Ins[NombreForm] = Frm;
}
webBrowser1.Visible = false;
// Console.WriteLine("X= " + Properties.Settings.Default.widthx + " Y=" + Properties.Settings.Default.heighty);
Frm.MdiParent = this;
Frm.Show();
}
catch (Exception e)
{
//throw e;
MessageBox.Show("Aplicacion no asignada favor consultar a soporte");
}
}
public MainWindow()
{
InitializeComponent();
Frames.Frmobj = Frm;
Frm.Navigate(new MainNavigate());
Connectdb.dbobj = new DataFiles.Hire_videotapeEntities();
}
public void mojProfil_Click(object sender, EventArgs e)
{
Frm tempFrm = new Frm(Korisnik);
tempFrm.Show();
ZatvoriTrenutnu();
}
private void Delete_Room_Yes()
{
OneHotel a = (OneHotel)Frm.State;
int l = a.dataGridView1.SelectedRows.Count;
int[] arr = new int[l];
for (int i = 0; i < l; i++)
{
arr[i] = int.Parse(a.dataGridView1.SelectedRows[i].Cells[3].Value.ToString());
}
for (int i = 0; i < l; i++)
{
string SQL1 = "DELETE FROM Room WHERE ID = " + '"' + $"{arr[i]}" + '"';
string SQL2 = "DELETE FROM Voucher WHERE idTypeRoom = " + '"' + $"{arr[i]}" + '"';
c.Open();
MySqlCommand com2 = new MySqlCommand(SQL2, c);
com2.ExecuteNonQuery();
MySqlCommand com1 = new MySqlCommand(SQL1, c);
com1.ExecuteNonQuery();
string sql = $"SELECT TypeRoom, NumPerson, Price , ID FROM Room WHERE idHotel = {a.Hotel.ID}";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView1, reader);
c.Close();
}
a.dataGridView1.ClearSelection();
Frm.Update();
Close();
}
private void Delete_Account_Yes()
{
Accounts a = (Accounts)Frm.State;
if (a.dataGridView1.SelectedRows.Count != 0)
{
int l = a.dataGridView1.SelectedRows.Count;
string[] arr = new string[l];
for (int i = 0; i < l; i++)
{
arr[i] = a.dataGridView1.SelectedRows[i].Cells[1].Value.ToString();
}
for (int i = 0; i < l; i++)
{
string SQL1 = "DELETE FROM Agency WHERE Login = "******"' + $"{arr[i]}" + '"';
string SQL2 = "DELETE FROM Voucher WHERE Login = "******"' + $"{arr[i]}" + '"';
string SQL3 = "DELETE FROM Account WHERE Login = "******"' + $"{arr[i]}" + '"';
c.Open();
MySqlCommand com2 = new MySqlCommand(SQL2, c);
com2.ExecuteNonQuery();
MySqlCommand com1 = new MySqlCommand(SQL1, c);
com1.ExecuteNonQuery();
MySqlCommand com3 = new MySqlCommand(SQL3, c);
com3.ExecuteNonQuery();
string sql = "SELECT Agency.Name, Account.Login, Account.Password FROM Agency, Account WHERE Account.Login = Agency.Login UNION SELECT '-', Account.Login, Account.Password FROM Account WHERE Account.Login NOT IN(SELECT Login From Agency) AND Account.IsAdmin = 0";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView1, reader);
c.Close();
}
}
else
{
int l = a.dataGridView2.SelectedRows.Count;
string[] arr = new string[l];
for (int i = 0; i < l; i++)
{
arr[i] = a.dataGridView2.SelectedRows[i].Cells[0].Value.ToString();
}
for (int i = 0; i < l; i++)
{
string SQL3 = "DELETE FROM Account WHERE Login = "******"' + $"{arr[i]}" + '"';
c.Open();
MySqlCommand com3 = new MySqlCommand(SQL3, c);
com3.ExecuteNonQuery();
string sql = "SELECT Login, Password FROM Account WHERE IsAdmin = 1";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView2, reader);
c.Close();
}
}
a.dataGridView1.ClearSelection();
a.dataGridView2.ClearSelection();
Frm.Update();
Close();
}
private void ContentClick(object obj, EventArgs e)
{
Frm.Show();
if (Frm.WindowState == FormWindowState.Minimized)
{
Frm.WindowState = FormWindowState.Normal;
Frm.TopLevel = true;
}
// ((TaskbarNotifier)(obj)).Hide();
}
private void tu(string NombreFormulario)
{
Form Frm;
if (NombreFormulario != "0")
{
Frm = (Form)Activator.CreateInstance(null, "SIPAA_CS.RecursosHumanos.Catalogos.PlantillasDetalles").Unwrap();
Frm.Show();
}
}
//methoa close All Childen Form
public Boolean Cpub_CloseChildenForm(Form _FrmCtrls, String _sFrmName)
{
foreach (Form Frm in _FrmCtrls.MdiChildren)
{
if (Frm.Name == _sFrmName)
{
Frm.Focus();
return(true);
}
}
return(false);
}
Boolean kiemtratontai(string Frmname)
{
foreach (Form Frm in this.MdiChildren)
{
if (Frm.Name.Equals(Frmname))
{
Frm.Activate();
return(true);
}
}
return(false);
}
void PickUpColorSuccessCall(object data)
{
if (Frm != null)
{
Frm.Close();
}
if (PickUpColorSuccessCallEvent != null)
{
PickUpColorSuccessCallEvent(data);
}
this.Close();
}
private void watcher_Renamed(object sender, RenamedEventArgs e)
{
File file = new File(e.Name, e.FullPath);
ListViewItem lvi = new ListViewItem(file.ToString());
lvi.Tag = file;
Lv.Items.Add(lvi);
lvi.SubItems.AddRange(new string[] { e.ChangeType.ToString(), DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") });
del d = Open;
Frm.Invoke(d, e.Name);
ToPaly();
}
private void Delete_Route_Yes()
{
Routes a = (Routes)Frm.State;
int l = a.dataGridView1.SelectedRows.Count;
string[] arr = new string[l];
for (int i = 0; i < l; i++)
{
arr[i] = a.dataGridView1.SelectedRows[i].Cells[0].Value.ToString();
}
for (int i = 0; i < l; i++)
{
c.Open();
string sql0 = "SELECT DISTINCT Voucherpeople.idVoucher FROM Voucherpeople ";
MySqlCommand command0 = new MySqlCommand(sql0, c);
MySqlDataReader reader0 = command0.ExecuteReader();
string str = "(";
while (reader0.Read())
{
str += "'" + reader0[0].ToString() + "',";
}
c.Close();
str = str.Substring(0, str.Length - 1);
str += ")";
c.Open();
string sql1 = $"UPDATE Voucher SET Status = 'Отменено' WHERE ID IN {str} ";
MySqlCommand command1 = new MySqlCommand(sql1, c);
command1.ExecuteNonQuery();
c.Close();
string SQL2 = "DELETE FROM Route WHERE Route.RouteNum = " + '"' + $"{arr[i]}" + '"';
c.Open();
MySqlCommand com1 = new MySqlCommand(SQL2, c);
com1.ExecuteNonQuery();
string sql = "SELECT Route.RouteNum, Airline.Name , Route.CodeAirportDeparture, Route.CodeAirportArrive, Route.TimeDeparture, Route.days, Route.Price FROM Route, Airline WHERE Route.CodeAirline = Airline.Code";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView1, reader);
c.Close();
}
a.dataGridView1.ClearSelection();
Frm.Update();
Close();
}
private void Btn_stop_httpserver_Click(object sender, EventArgs e)
{
new Thread(() =>
{
if (HttpServer != null && HttpServer.SocketChannel.Open == true)
{
Frm.ThreadSafeUpdate(() => Frm.btn_start_httpserver.Enabled = false);
Frm.ThreadSafeUpdate(() => Frm.btn_stop_httpserver.Enabled = false);
Frm.ThreadSafeUpdate(() => Frm.btn_stop_httpserver.Text = "关闭中");
if (HttpServer.Stop())
{
HttpServerLog("HTTP服务器关闭成功");
Frm.ThreadSafeUpdate(() => Frm.btn_start_httpserver.Enabled = true);
Frm.ThreadSafeUpdate(() => Frm.btn_stop_httpserver.Enabled = true);
Frm.ThreadSafeUpdate(() => Frm.btn_stop_httpserver.Text = "关闭");
}
}
}).Start();
}
private void watcher_Changed(object sender, FileSystemEventArgs e)
{
if (e.ChangeType == WatcherChangeTypes.Changed)
{
watcher.EnableRaisingEvents = false;
watcher.EnableRaisingEvents = true;
}
File file = new File(e.Name, e.FullPath);
ListViewItem lvi = new ListViewItem(file.ToString())
{
Tag = file
};
Lv.Items.Add(lvi);
lvi.SubItems.AddRange(new string[] { e.ChangeType.ToString(), DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") });
del d = Open;
Frm.Invoke(d, e.Name);
ToPaly();
}
private void BarraTareas_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
int FormId = ((int)e.ClickedItem.Tag);
bool Encontre = false;
foreach (Form Frm in this.MdiChildren)
{
Lui.Forms.ChildForm Frm2 = Frm as Lui.Forms.ChildForm;
if (Frm2 != null && Frm2.Uid == FormId)
{
Encontre = true;
Frm.Visible = true;
Frm.Show();
Frm.Activate();
break;
}
}
if (Encontre == false)
{
BarraTareas.Items.Remove(e.ClickedItem);
}
}
/// <summary>
/// view work.
/// </summary>
public void BindTrack_ViewWork()
{
string appPath = this.Request.ApplicationPath;
Track tk = new Track(this.FK_Flow, this.MyPK);
Node nd = new Node(tk.NDFrom);
Work wk = nd.HisWork;
wk.OID = tk.WorkID;
if (wk.RetrieveFromDBSources() == 0)
{
this.UCEn1.AddFieldSet("打开(" + nd.Name + ")错误");
this.UCEn1.AddH1("当前的节点数据已经被删除！！！<br> 造成此问题出现的原因如下。");
this.UCEn1.AddBR("1、当前节点数据被非法删除。");
this.UCEn1.AddBR("2、节点数据是退回人与被退回人中间的节点，这部分节点数据查看不支持。");
this.UCEn1.AddFieldSetEnd();
return;
}
GenerWorkFlow gwf = new GenerWorkFlow();
gwf.WorkID = wk.OID;
if (gwf.RetrieveFromDBSources() == 0)
{
}
else
{
if (gwf.FK_Node == wk.NodeID)
{
this.UCEn1.AddFieldSet(wk.EnDesc);
this.UCEn1.AddH1("当工作(" + nd.Name + ")未完成，您不能查看它的工作日志。");
this.UCEn1.AddFieldSetEnd();
return;
}
}
if (nd.HisFlow.IsMD5 && wk.IsPassCheckMD5() == false)
{
this.UCEn1.AddFieldSet("打开(" + nd.Name + ")错误");
this.UCEn1.AddH1("当前的节点数据已经被篡改，请报告管理员。");
this.UCEn1.AddFieldSetEnd();
return;
}
this.UCEn1.IsReadonly = true;
Frms frms = nd.HisFrms;
if (frms.Count == 0)
{
if (nd.HisFormType == FormType.FreeForm)
{
/* 自由表单 */
this.UCEn1.Add("<div id=divCCForm >");
this.UCEn1.BindCCForm(wk, "ND" + nd.NodeID, true); //, false, false, null);
if (wk.WorkEndInfo.Length > 2)
{
this.UCEn1.Add(wk.WorkEndInfo);
}
this.UCEn1.Add("</div>");
}
if (nd.HisFormType == FormType.FixForm)
{
/*傻瓜表单*/
this.UCEn1.IsReadonly = true;
this.UCEn1.BindColumn4(wk, "ND" + nd.NodeID); //, false, false, null);
if (wk.WorkEndInfo.Length > 2)
{
this.UCEn1.Add(wk.WorkEndInfo);
}
}
BillTemplates bills = new BillTemplates();
bills.Retrieve(BillTemplateAttr.NodeID, nd.NodeID);
if (bills.Count >= 1)
{
string title = "";
foreach (BillTemplate item in bills)
{
title += "<img src='/WF/Img/Btn/Word.gif' border=0/>" + item.Name + "</a>";
}
string urlr = appPath + "WF/WorkOpt/PrintDoc.aspx?FK_Node=" + nd.NodeID + "&FID=" + tk.FID + "&WorkID=" + tk.WorkID + "&FK_Flow=" + tk.FK_Flow;
this.UCEn1.Add("<p><a href=\"javascript:WinOpen('" + urlr + "','dsdd');\" />" + title + "</a></p>");
//this.UCEn1.Add("<a href='' target=_blank><img src='/WF/Img/Btn/Word.gif' border=0/>" + bt.Name + "</a>");
}
}
else
{
/* 涉及到多个表单的情况...*/
if (nd.HisFormType != FormType.DisableIt)
{
Frm myfrm = new Frm();
myfrm.No = "ND" + nd.NodeID;
myfrm.Name = wk.EnDesc;
myfrm.HisFormType = nd.HisFormType;
FrmNode fnNode = new FrmNode();
fnNode.FK_Frm = myfrm.No;
fnNode.IsEdit = true;
fnNode.IsPrint = false;
switch (nd.HisFormType)
{
case FormType.FixForm:
fnNode.HisFrmType = FrmType.Column4Frm;
break;
case FormType.FreeForm:
fnNode.HisFrmType = FrmType.CCForm;
break;
case FormType.SelfForm:
fnNode.HisFrmType = FrmType.Url;
break;
default:
throw new Exception("出现了未判断的异常。");
}
myfrm.HisFrmNode = fnNode;
frms.AddEntity(myfrm, 0);
}
Int64 fid = this.FID;
if (this.FID == 0)
{
fid = tk.WorkID;
}
if (frms.Count == 1)
{
/* 如果禁用了节点表单，并且只有一个表单的情况。*/
Frm frm = (Frm)frms[0];
FrmNode fn = frm.HisFrmNode;
string src = "";
src = fn.FrmUrl + ".aspx?FK_MapData=" + frm.No + "&FID=" + fid + "&IsEdit=0&IsPrint=0&FK_Node=" + nd.NodeID + "&WorkID=" + tk.WorkID;
this.UCEn1.Add("\t\n <DIV id='" + frm.No + "' style='width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left;' >");
this.UCEn1.Add("\t\n <iframe ID='F" + frm.No + "' src='" + src + "' frameborder=0 style='position:absolute;width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left;' leftMargin='0' topMargin='0' /></iframe>");
this.UCEn1.Add("\t\n </DIV>");
}
else
{
#region 载入相关文件.
this.Page.RegisterClientScriptBlock("sg",
"<link href='./Style/Frm/Tab.css' rel='stylesheet' type='text/css' />");
this.Page.RegisterClientScriptBlock("s2g4",
"<script language='JavaScript' src='./Style/Frm/jquery.min.js' ></script>");
this.Page.RegisterClientScriptBlock("sdf24j",
"<script language='JavaScript' src='./Style/Frm/jquery.idTabs.min.js' ></script>");
this.Page.RegisterClientScriptBlock("sdsdf24j",
"<script language='JavaScript' src='./Style/Frm/TabClick.js' ></script>");
#endregion 载入相关文件.
this.UCEn1.Clear();
this.UCEn1.Add("<div style='clear:both' ></div>");
this.UCEn1.Add("\t\n<div id='usual2' class='usual' >"); //begain.
#region 输出标签.
this.UCEn1.Add("\t\n <ul class='abc' style='background:red;border-color: #800000;border-width: 10px;' >");
foreach (Frm frm in frms)
{
FrmNode fn = frm.HisFrmNode;
string src = "";
src = fn.FrmUrl + ".aspx?FK_MapData=" + frm.No + "&FID=" + fid + "&IsEdit=0&IsPrint=0&FK_Node=" + nd.NodeID + "&WorkID=" + tk.WorkID;
this.UCEn1.Add("\t\n<li><a href=\"#" + frm.No + "\" onclick=\"TabClick('" + frm.No + "','" + src + "');\" >" + frm.Name + "</a></li>");
}
this.UCEn1.Add("\t\n </ul>");
#endregion 输出标签.
#region 输出表单 iframe 内容.
foreach (Frm frm in frms)
{
FrmNode fn = frm.HisFrmNode;
this.UCEn1.Add("\t\n <DIV id='" + frm.No + "' style='width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left;' >");
string src = "loading.htm";
this.UCEn1.Add("\t\n <iframe ID='F" + frm.No + "' src='" + src + "' frameborder=0 style='position:absolute;width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left;' leftMargin='0' topMargin='0' /></iframe>");
this.UCEn1.Add("\t\n </DIV>");
}
#endregion 输出表单 iframe 内容.
this.UCEn1.Add("\t\n</div>"); // end usual2
// 设置选择的默认值.
this.UCEn1.Add("\t\n<script type='text/javascript'>");
this.UCEn1.Add("\t\n $(\"#usual2 ul\").idTabs(\"" + frms[0].No + "\");");
this.UCEn1.Add("\t\n</script>");
}
}
}
public static void HttpServerLog(string text)
{
string output = string.Format("{0} {1}{2}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), text, Environment.NewLine);
Frm.ThreadSafeUpdate(() => Frm.richTextBox_httpserver_log.AppendText(output));
}
private void buttonLogin_Click(object sender, EventArgs e)
{
Frm newfrm = new Frm();
}
private void Delete_People_Flight_Yes()
{
OneVoucher a = (OneVoucher)Frm.State;
string[] kk = a.label1.Text.Split(' ');
string id = kk[kk.Length - 1];
int l = a.dataGridView1.SelectedRows.Count;
int l0 = a.dataGridView2.SelectedRows.Count;
if (l == 0)
{
string[] arr = new string[l0];
for (int i = 0; i < l0; i++)
{
arr[i] = a.dataGridView2.SelectedRows[i].Cells[4].Value.ToString();
}
for (int i = 0; i < l0; i++)
{
string SQL2 = $"DELETE FROM VoucherFlight WHERE idVoucher = '{id}' AND idFlight ='{arr[i]}'";
c.Open();
MySqlCommand com1 = new MySqlCommand(SQL2, c);
com1.ExecuteNonQuery();
string sql = $"SELECT Route.RouteNum, Route.CodeAirportDeparture, Route.CodeAirportArrive, Flight.dateTime, Flight.ID " +
$"FROM Route, Flight, Voucherflight, Voucher " +
$"WHERE Voucher.ID ={id} AND VoucherFlight.idVoucher = Voucher.ID AND " +
$"Flight.ID = VoucherFlight.idFlight AND Flight.NumRoute = Route.RouteNum";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView2, reader);
c.Close();
}
a.dataGridView2.ClearSelection();
Frm.Update();
Close();
}
else
{
string[] arr = new string[l];
for (int i = 0; i < l; i++)
{
arr[i] = a.dataGridView1.SelectedRows[i].Cells[2].Value.ToString();
}
for (int i = 0; i < l; i++)
{
string SQL2 = $"DELETE FROM VoucherPeople WHERE idVoucher = '{id}' AND passport ='{arr[i]}'";
c.Open();
MySqlCommand com1 = new MySqlCommand(SQL2, c);
com1.ExecuteNonQuery();
string sql = $"SELECT People.Surname, People.Name, People.Passport, People.Birthday, People.Sex, Country.Name " +
$"FROM People, Voucherpeople, Country " +
$"WHERE People.IdNational=Country.ID AND People.Passport = Voucherpeople.passport AND Voucherpeople.idVoucher ='{id}' ";
MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView1, reader);
c.Close();
}
a.dataGridView1.ClearSelection();
Frm.Update();
Close();
}
}
private void Delete_Voucher_Yes()
{
Vouchers a = (Vouchers)Frm.State;
int l = a.dataGridView1.SelectedRows.Count;
int[] arr = new int[l];
for (int i = 0; i < l; i++)
{
arr[i] = Convert.ToInt32(a.dataGridView1.SelectedRows[i].Cells[0].Value.ToString());
}
for (int i = 0; i < l; i++)
{
string SQL1 = "DELETE FROM Voucher WHERE Voucher.Id = " + '"' + $"{arr[i]}" + '"';
c.Open();
MySqlCommand com2 = new MySqlCommand(SQL1, c);
com2.ExecuteNonQuery();
string sql = "SELECT Voucher.ID, Agency.Name, Hotel.Name, minimal.miin, " +
"Round((Room.Price * Voucher.NumNights + PairSummaVoucher.Summa * Countpeople.c) * 120 * (Agency.Comission + 100) / 10000, 0), " +
"Voucher.Status " +
"FROM Voucher, Agency, Hotel, Room, " +
"(SELECT Min(datetimeflight) AS miin, voucherid " +
"FROM " +
"(SELECT flight.datetime AS datetimeflight, voucher.ID AS voucherid " +
"FROM flight, voucher, voucherflight " +
" WHERE flight.ID = voucherflight.idFlight AND voucher.ID = voucherflight.idVoucher " +
" ) AS PairVoucherData " +
"GROUP BY voucherid " +
") AS minimal, " +
"(SELECT Sum(Flights.price) AS Summa, Flights.voucherid " +
"FROM " +
"(SELECT Voucherflight.idVoucher as voucherid, Route.Price AS price " +
"FROM Voucherflight, Route, Flight " +
"WHERE Voucherflight.idFlight = Flight.ID AND Flight.NumRoute = Route.RouteNum " +
") AS Flights " +
"GROUP BY Flights.voucherid " +
") AS PairSummaVoucher, " +
"(SELECT voucher.ID AS id, Count(voucherpeople.idVoucher) as c " +
"FROM voucher " +
"LEFT JOIN voucherpeople " +
"ON voucherpeople.idVoucher = voucher.Id " +
"GROUP BY voucher.ID) AS CountPeople " +
"WHERE Agency.Login = Voucher.Login AND Voucher.IdTypeRoom = Room.ID AND Room.IdHotel = Hotel.ID AND " +
"minimal.voucherid = Voucher.ID AND PairSummaVoucher.voucherid = Voucher.ID AND CountPeople.id = Voucher.ID " +
"UNION " +
"SELECT Voucher.ID, Agency.Name, Hotel.Name, Voucher.DateHotel , " +
"Round((Room.Price * Voucher.NumNights) * 120 * (Agency.Comission + 100) / 10000, 0), " +
"Voucher.Status " +
"FROM Voucher, Agency, Hotel, Room, Voucherflight, " +
"(SELECT voucher.ID AS id, Count(voucherpeople.idVoucher) as c " +
"FROM voucher " +
"LEFT JOIN voucherpeople " +
"ON voucherpeople.idVoucher = voucher.Id " +
"GROUP BY voucher.ID) AS CountPeople " +
"WHERE Agency.Login = Voucher.Login AND Voucher.IdTypeRoom = Room.ID AND Room.IdHotel = Hotel.ID " +
" AND Voucher.ID NOT IN(Voucherflight.idVoucher) AND Countpeople.id = Voucher.ID"; MySqlCommand command = new MySqlCommand(sql, c);
MySqlDataReader reader = command.ExecuteReader();
f.CreateDataGridView(a.dataGridView1, reader);
c.Close();
}
a.dataGridView1.ClearSelection();
Frm.Update();
Close();
}
/// <summary>
/// 打开工作处理器，仅仅查看，不能修改。
/// </summary>
public void BindTrack_ViewWorkForm()
{
string appPath = this.Request.ApplicationPath;
Node nd = null;
Track tk = new Track();
tk.FK_Flow = this.FK_Flow;
tk.NDFrom = this.FK_Node;
tk.WorkID = this.WorkID;
if (this.MyPK != null)
{
tk = new Track(this.FK_Flow, this.MyPK);
nd = new Node(tk.NDFrom);
}
else
{
nd = new Node(this.FK_Node);
}
Flow fl = new Flow(this.FK_Flow);
Int64 workid = 0;
if (nd.HisRunModel == RunModel.SubThread)
{
workid = tk.FID;
}
else
{
workid = tk.WorkID;
}
Int64 fid = this.FID;
if (this.FID == 0)
{
fid = tk.FID;
}
DataTable ndrpt = DBAccess.RunSQLReturnTable("SELECT PFlowNo,PWorkID FROM " + fl.PTable + " WHERE OID=" + workid);
string urlExt = "&PFlowNo=" + ndrpt.Rows[0]["PFlowNo"] + "&PWorkID=" + ndrpt.Rows[0]["PWorkID"] + "&IsToobar=0&IsHidden=true";
urlExt += "&From=CCFlow&TruckKey=" + tk.GetValStrByKey("MyPK");
if (nd.HisFormType == NodeFormType.SDKForm || nd.HisFormType == NodeFormType.SelfForm)
{
if (nd.FormUrl.Contains("?"))
{
this.Response.Redirect(nd.FormUrl + "&WorkID=" + tk.WorkID + "&FK_Node=" + nd.NodeID + "&FK_Flow=" + nd.FK_Flow + "&FID=" + fid + urlExt, true);
}
else
{
this.Response.Redirect(nd.FormUrl + "?WorkID=" + tk.WorkID + "&FK_Node=" + nd.NodeID + "&FK_Flow=" + nd.FK_Flow + "&FID=" + fid + urlExt, true);
}
if (nd.HisFormType == NodeFormType.SDKForm)
{
if (nd.FormUrl.Contains("?"))
{
this.Response.Redirect(nd.FormUrl + "&WorkID=" + tk.WorkID + "&FK_Node=" + nd.NodeID + "&FK_Flow=" + nd.FK_Flow + "&FID=" + fid + urlExt, true);
}
else
{
this.Response.Redirect(nd.FormUrl + "?WorkID=" + tk.WorkID + "&FK_Node=" + nd.NodeID + "&FK_Flow=" + nd.FK_Flow + "&FID=" + fid + urlExt, true);
}
return;
}
this.Response.Redirect(nd.FormUrl + "&WorkID=" + tk.WorkID + "&FK_Node=" + nd.NodeID + "&FK_Flow=" + nd.FK_Flow + "&FID=" + fid + urlExt, true);
return;
}
Work wk = nd.HisWork;
wk.OID = tk.WorkID;
if (wk.RetrieveFromDBSources() == 0)
{
GERpt rtp = nd.HisFlow.HisGERpt;
rtp.OID = this.WorkID;
if (rtp.RetrieveFromDBSources() == 0)
{
this.UCEn1.AddFieldSet("打开(" + nd.Name + ")错误");
this.UCEn1.AddH1("当前的节点数据已经被删除！！！<br> 造成此问题出现的原因如下。");
this.UCEn1.AddBR("1、当前节点数据被非法删除。");
this.UCEn1.AddBR("2、节点数据是退回人与被退回人中间的节点，这部分节点数据查看不支持。");
this.UCEn1.AddH1("技术信息:表" + wk.EnMap.PhysicsTable + " WorkID=" + this.WorkID);
this.UCEn1.AddFieldSetEnd();
return;
}
wk.Row = rtp.Row;
}
GenerWorkFlow gwf = new GenerWorkFlow();
gwf.WorkID = wk.OID;
if (nd.HisFlow.IsMD5 && wk.IsPassCheckMD5() == false)
{
this.UCEn1.AddFieldSet("打开(" + nd.Name + ")错误");
this.UCEn1.AddH1("当前的节点数据已经被篡改，请报告管理员。");
this.UCEn1.AddFieldSetEnd();
return;
}
this.InitToolbar(false, appPath);
this.UCEn1.IsReadonly = true;
Frms frms = nd.HisFrms;
if (frms.Count == 0)
{
if (nd.HisFormType == NodeFormType.FreeForm)
{
MapData map = new MapData(nd.NodeFrmID);
/* 自由表单 */
Width = map.MaxRight + map.MaxLeft * 2 + 10 + "";
if (float.Parse(Width) < 500)
{
Width = "900";
}
Height = map.MaxEnd + "";
BtnLab btnLab = new BtnLab(FK_Node);
BtnWord = btnLab.WebOfficeEnable + "";
this.UCEn1.Add("<div id=divCCForm style='width:" + Width + "px;height:" + Height + "px' >");
this.UCEn1.BindCCForm(wk, nd.NodeFrmID, true, 0, false); //, false, false, null);
this.UCEn1.Add("</div>");
}
if (nd.HisFormType == NodeFormType.FixForm)
{
MapData map = new MapData(nd.NodeFrmID);
if (map.TableWidth.Contains("px"))
{
Width = map.TableWidth.Replace("px", "");
}
else
{
Width = map.TableWidth + "";
}
if (map.TableWidth.Equals("100%"))
{
Width = "900";
}
this.UCEn1.Add("<div id=divCCForm style='width:" + Width + "px;height:" + map.FrmH + "px;overflow-x:scroll;' >");
/*傻瓜表单*/
this.UCEn1.IsReadonly = true;
this.UCEn1.BindColumn4(wk, nd.NodeFrmID); //, false, false, null);
//if (wk.WorkEndInfo.Length > 2)
// this.UCEn1.Add(wk.WorkEndInfo);
this.UCEn1.Add("</div>");
}
BillTemplates bills = new BillTemplates();
bills.Retrieve(BillTemplateAttr.NodeID, nd.NodeID);
if (bills.Count >= 1)
{
string title = "";
foreach (BillTemplate item in bills)
{
title += "<img src='/WF/Img/Btn/Word.gif' border=0/>" + item.Name + "</a>";
}
string urlr = appPath + "WF/WorkOpt/PrintDoc.aspx?FK_Node=" + nd.NodeID + "&FID=" + fid + "&WorkID=" + tk.WorkID + "&FK_Flow=" + nd.FK_Flow;
this.UCEn1.Add("<p><a href=\"javascript:WinOpen('" + urlr + "','dsdd');\" />" + title + "</a></p>");
//this.UCEn1.Add("<a href='' target=_blank><img src='/WF/Img/Btn/Word.gif' border=0/>" + bt.Name + "</a>");
}
}
else
{
/* 涉及到多个表单的情况...*/
if (nd.HisFormType == NodeFormType.SheetTree)
{
Response.Redirect(appPath + "WF/FlowFormTree/FlowFormTreeView.aspx?WorkID=" + tk.WorkID + "&FK_Flow=" + nd.FK_Flow + "&FID=" + fid + "&FK_Node=" + nd.NodeID + "&CWorkID=" + this.CWorkID);
}
else if (nd.HisFormType != NodeFormType.DisableIt)
{
Frm myfrm = new Frm();
myfrm.No = "ND" + nd.NodeID;
myfrm.Name = wk.EnDesc;
myfrm.HisFormRunType = (FormRunType)(int)nd.HisFormType;
FrmNode fnNode = new FrmNode();
fnNode.FK_Frm = myfrm.No;
fnNode.IsEdit = true;
fnNode.IsPrint = false;
switch (nd.HisFormType)
{
case NodeFormType.FixForm:
fnNode.HisFrmType = FrmType.Column4Frm;
break;
case NodeFormType.FreeForm:
fnNode.HisFrmType = FrmType.FreeFrm;
break;
case NodeFormType.SelfForm:
fnNode.HisFrmType = FrmType.Url;
break;
default:
throw new Exception("出现了未判断的异常。");
}
myfrm.HisFrmNode = fnNode;
frms.AddEntity(myfrm, 0);
}
if (frms.Count == 1)
{
/* 如果禁用了节点表单，并且只有一个表单的情况。*/
Frm frm = (Frm)frms[0];
FrmNode fn = frm.HisFrmNode;
string src = "";
src = fn.FrmUrl + ".aspx?FK_MapData=" + frm.No + "&FID=" + fid + "&IsEdit=0&IsPrint=0&FK_Node=" + nd.NodeID + "&WorkID=" + tk.WorkID + "&CWorkID=" + this.CWorkID;
this.UCEn1.Add("\t\n <DIV id='" + frm.No + "' style='width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left; background-color:white;margin:0;padding:0;' >");
this.UCEn1.Add("\t\n <iframe ID='F" + frm.No + "' src='" + src + "' frameborder=0 style='margin:0;padding:0;width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left;' leftMargin='0' topMargin='0' /></iframe>");
this.UCEn1.Add("\t\n </DIV>");
}
else
{
Frm frmFirst = null;
foreach (Frm frm in frms)
{
if (frmFirst == null)
{
frmFirst = frm;
}
if (frmFirst.FrmW < frm.FrmW)
{
frmFirst = frm;
}
}
#region 载入相关文件.
this.Page.RegisterClientScriptBlock("sg",
"<link href='./Style/Frm/Tab.css' rel='stylesheet' type='text/css' />");
this.Page.RegisterClientScriptBlock("s2g4",
"<script language='JavaScript' src='./Style/Frm/jquery.min.js' ></script>");
this.Page.RegisterClientScriptBlock("sdf24j",
"<script language='JavaScript' src='./Style/Frm/jquery.idTabs.min.js' ></script>");
this.Page.RegisterClientScriptBlock("sdsdf24j",
"<script language='JavaScript' src='./Style/Frm/TabClick.js' ></script>");
#endregion 载入相关文件.
this.UCEn1.Clear();
this.UCEn1.Add("<div style='clear:both' ></div>"); //
this.UCEn1.Add("\t\n<div id='usual2' class='usual' style='width:" + frmFirst.FrmW + "px;height:auto;margin:0 auto;background-color:white;'>"); //begain.
#region 输出标签.
this.UCEn1.Add("\t\n <ul class='abc' style='background:red;border-color: #800000;border-width: 10px;' >");
foreach (Frm frm in frms)
{
FrmNode fn = frm.HisFrmNode;
string src = "";
src = fn.FrmUrl + ".aspx?FK_MapData=" + frm.No + "&FID=" + fid + "&IsEdit=0&IsPrint=0&FK_Node=" + nd.NodeID + "&WorkID=" + tk.WorkID + "&CWorkID=" + this.CWorkID + "&FK_Flow=" + this.FK_Flow;//edited by liuxc,2015-6-17
this.UCEn1.Add("\t\n<li><a href=\"#" + frm.No + "\" onclick=\"TabClick('" + frm.No + "','" + src + "');\" >" + frm.Name + "</a></li>");
}
this.UCEn1.Add("\t\n </ul>");
#endregion 输出标签.
#region 输出表单 iframe 内容.
foreach (Frm frm in frms)
{
FrmNode fn = frm.HisFrmNode;
this.UCEn1.Add("\t\n <DIV id='" + frm.No + "' style='width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left;margin:0px;padding:0px;' >");
string src = "loading.htm";
this.UCEn1.Add("\t\n <iframe ID='F" + frm.No + "' src='" + src + "' frameborder=0 style='margin:0px;padding:0px;width:" + frm.FrmW + "px; height:" + frm.FrmH + "px;text-align: left;' leftMargin='0' topMargin='0' /></iframe>");
this.UCEn1.Add("\t\n </DIV>");
}
#endregion 输出表单 iframe 内容.
this.UCEn1.Add("\t\n</div>"); // end usual2
// 设置选择的默认值.
this.UCEn1.Add("\t\n<script type='text/javascript'>");
this.UCEn1.Add("\t\n $(\"#usual2 ul\").idTabs(\"" + frms[0].No + "\");");
this.UCEn1.Add("\t\n</script>");
}
}
}
public string DoType(string dotype, string v1, string v2, string v3, string v4, string v5)
{
string sql = "";
try
{
switch (dotype)
{
case "CreateCheckGroup":
string gKey = v1;
string gName = v2;
string enName1 = v3;
MapAttr attrN = new MapAttr();
int i = attrN.Retrieve(MapAttrAttr.FK_MapData, enName1, MapAttrAttr.KeyOfEn, gKey + "_Note");
i += attrN.Retrieve(MapAttrAttr.FK_MapData, enName1, MapAttrAttr.KeyOfEn, gKey + "_Checker");
i += attrN.Retrieve(MapAttrAttr.FK_MapData, enName1, MapAttrAttr.KeyOfEn, gKey + "_RDT");
if (i > 0)
{
return("前缀已经使用：" + gKey + " ， 请确认您是否增加了这个审核分组或者，请您更换其他的前缀。");
}
GroupField gf = new GroupField();
gf.Lab = gName;
gf.EnName = enName1;
gf.Insert();
attrN = new MapAttr();
attrN.FK_MapData = enName1;
attrN.KeyOfEn = gKey + "_Note";
attrN.Name = "审核意见";
attrN.MyDataType = DataType.AppString;
attrN.UIContralType = UIContralType.TB;
attrN.UIIsEnable = true;
attrN.UIIsLine = true;
attrN.MaxLen = 4000;
attrN.GroupID = gf.OID;
attrN.UIHeight = 23 * 3;
attrN.IDX = 1;
attrN.Insert();
attrN = new MapAttr();
attrN.FK_MapData = enName1;
attrN.KeyOfEn = gKey + "_Checker";
attrN.Name = "审核人";// "审核人";
attrN.MyDataType = DataType.AppString;
attrN.UIContralType = UIContralType.TB;
attrN.MaxLen = 50;
attrN.MinLen = 0;
attrN.UIIsEnable = true;
attrN.UIIsLine = false;
attrN.DefVal = "@WebUser.Name";
attrN.UIIsEnable = false;
attrN.GroupID = gf.OID;
attrN.IsSigan = true;
attrN.IDX = 2;
attrN.Insert();
attrN = new MapAttr();
attrN.FK_MapData = enName1;
attrN.KeyOfEn = gKey + "_RDT";
attrN.Name = "审核日期"; // "审核日期";
attrN.MyDataType = DataType.AppDateTime;
attrN.UIContralType = UIContralType.TB;
attrN.UIIsEnable = true;
attrN.UIIsLine = false;
attrN.DefVal = "@RDT";
attrN.UIIsEnable = false;
attrN.GroupID = gf.OID;
attrN.IDX = 3;
attrN.Insert();
return(null);
case "NewDtl":
MapDtl dtlN = new MapDtl();
dtlN.No = v1;
if (dtlN.RetrieveFromDBSources() != 0)
{
return("从表已存在");
}
dtlN.Name = v1;
dtlN.FK_MapData = v2;
dtlN.PTable = v1;
dtlN.Insert();
dtlN.IntMapAttrs();
return(null);
case "DelM2M":
MapM2M m2mDel = new MapM2M();
m2mDel.MyPK = v1;
m2mDel.Delete();
//M2M m2mData = new M2M();
//m2mData.Delete(M2MAttr.FK_MapData, v1);
return(null);
case "NewAthM": // 新建 NewAthM.
string fk_mapdataAth = v1;
string athName = v2;
BP.Sys.FrmAttachment athM = new FrmAttachment();
athM.MyPK = athName;
if (athM.IsExits)
{
return("多选名称:" + athName + "，已经存在。");
}
athM.X = float.Parse(v3);
athM.Y = float.Parse(v4);
athM.Name = "多文件上传";
athM.FK_MapData = fk_mapdataAth;
athM.Insert();
return(null);
case "NewM2M":
string fk_mapdataM2M = v1;
string m2mName = v2;
MapM2M m2m = new MapM2M();
m2m.FK_MapData = v1;
m2m.NoOfObj = v2;
if (v3 == "0")
{
m2m.HisM2MType = M2MType.M2M;
m2m.Name = "新建一对多";
}
else
{
m2m.HisM2MType = M2MType.M2MM;
m2m.Name = "新建一对多多";
}
m2m.X = float.Parse(v4);
m2m.Y = float.Parse(v5);
m2m.MyPK = m2m.FK_MapData + "_" + m2m.NoOfObj;
if (m2m.IsExits)
{
return("多选名称:" + m2mName + "，已经存在。");
}
m2m.Insert();
return(null);
case "DelEnum":
// 检查这个物理表是否被使用。
sql = "SELECT * FROM Sys_MapAttr WHERE UIBindKey='" + v1 + "'";
DataTable dtEnum = DBAccess.RunSQLReturnTable(sql);
string msgDelEnum = "";
foreach (DataRow dr in dtEnum.Rows)
{
msgDelEnum += "\n 表单编号:" + dr["FK_MapData"] + " , 字段:" + dr["KeyOfEn"] + ", 名称:" + dr["Name"];
}
if (msgDelEnum != "")
{
return("该枚举已经被如下字段所引用，您不能删除它。" + msgDelEnum);
}
sql = "DELETE FROM Sys_EnumMain WHERE No='" + v1 + "'";
sql += "@DELETE FROM Sys_Enum WHERE EnumKey='" + v1 + "' ";
DBAccess.RunSQLs(sql);
return(null);
case "DelSFTable": /* 删除自定义的物理表. */
// 检查这个物理表是否被使用。
sql = "SELECT * FROM Sys_MapAttr WHERE UIBindKey='" + v1 + "'";
DataTable dt = DBAccess.RunSQLReturnTable(sql);
string msgDel = "";
foreach (DataRow dr in dt.Rows)
{
msgDel += "\n 表单编号:" + dr["FK_MapData"] + " , 字段:" + dr["KeyOfEn"] + ", 名称:" + dr["Name"];
}
if (msgDel != "")
{
return("该数据表已经被如下字段所引用，您不能删除它。" + msgDel);
}
SFTable sfDel = new SFTable();
sfDel.No = v1;
sfDel.DirectDelete();
return(null);
case "SaveSFTable":
string enName = v2;
string chName = v1;
if (string.IsNullOrEmpty(v1) || string.IsNullOrEmpty(v2))
{
return("视图中的中英文名称不能为空。");
}
SFTable sf = new SFTable();
sf.No = enName;
sf.Name = chName;
sf.No = enName;
sf.Name = chName;
sf.FK_Val = enName;
sf.Save();
if (DBAccess.IsExitsObject(enName) == true)
{
/*已经存在此对象，检查一下是否有No,Name列。*/
sql = "SELECT No,Name FROM " + enName;
try
{
DBAccess.RunSQLReturnTable(sql);
}
catch (Exception ex)
{
return("您指定的表或视图(" + enName + ")，不包含No,Name两列，不符合ccflow约定的规则。技术信息:" + ex.Message);
}
return(null);
}
else
{
/*创建这个表，并且插入基础数据。*/
try
{
// 如果没有该表或者视图，就要创建它。
sql = "CREATE TABLE " + enName + "(No varchar(30) NOT NULL,Name varchar(50) NULL)";
DBAccess.RunSQL(sql);
DBAccess.RunSQL("INSERT INTO " + enName + " (No,Name) VALUES('001','Item1')");
DBAccess.RunSQL("INSERT INTO " + enName + " (No,Name) VALUES('002','Item2')");
DBAccess.RunSQL("INSERT INTO " + enName + " (No,Name) VALUES('003','Item3')");
}
catch (Exception ex)
{
sf.DirectDelete();
return("创建物理表期间出现错误,可能是非法的物理表名.技术信息:" + ex.Message);
}
}
return(null); /*创建成功后返回空值*/
case "FrmTempleteExp": //导出表单.
MapData mdfrmtem = new MapData();
mdfrmtem.No = v1;
if (mdfrmtem.RetrieveFromDBSources() == 0)
{
if (v1.Contains("ND"))
{
int nodeId = int.Parse(v1.Replace("ND", ""));
Node nd = new Node(nodeId);
mdfrmtem.Name = nd.Name;
mdfrmtem.PTable = v1;
mdfrmtem.EnPK = "OID";
mdfrmtem.Insert();
}
}
DataSet ds = mdfrmtem.GenerHisDataSet();
string file = System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "\\Temp\\" + v1 + ".xml";
if (System.IO.File.Exists(file))
{
System.IO.File.Delete(file);
}
ds.WriteXml(file);
// BP.PubClass.DownloadFile(file, mdfrmtem.Name + ".xml");
//this.DownLoadFile(System.Web.HttpContext.Current, file, mdfrmtem.Name);
return(null);
case "FrmTempleteImp": //导入表单.
DataSet dsImp = new DataSet();
string fileImp = System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "\\Temp\\" + v1 + ".xml";
dsImp.ReadXml(fileImp); //读取文件.
MapData.ImpMapData(v1, dsImp, true);
return(null);
case "NewHidF":
string fk_mapdataHid = v1;
string key = v2;
string name = v3;
int dataType = int.Parse(v4);
MapAttr mdHid = new MapAttr();
mdHid.MyPK = fk_mapdataHid + "_" + key;
mdHid.FK_MapData = fk_mapdataHid;
mdHid.KeyOfEn = key;
mdHid.Name = name;
mdHid.MyDataType = dataType;
mdHid.HisEditType = EditType.Edit;
mdHid.MaxLen = 100;
mdHid.MinLen = 0;
mdHid.LGType = FieldTypeS.Normal;
mdHid.UIVisible = false;
mdHid.UIIsEnable = false;
mdHid.Insert();
return(null);
case "DelDtl":
MapDtl dtl = new MapDtl(v1);
dtl.Delete();
return(null);
case "DeleteFrm":
string delFK_Frm = v1;
MapData mdDel = new MapData(delFK_Frm);
mdDel.Delete();
sql = "@DELETE FROM Sys_MapData WHERE No='" + delFK_Frm + "'";
sql = "@DELETE FROM WF_FrmNode WHERE FK_Frm='" + delFK_Frm + "'";
DBAccess.RunSQLs(sql);
return(null);
case "FrmUp":
case "FrmDown":
FrmNode myfn = new FrmNode();
myfn.Retrieve(FrmNodeAttr.FK_Node, v1, FrmNodeAttr.FK_Frm, v2);
if (dotype == "FrmUp")
{
myfn.DoUp();
}
else
{
myfn.DoDown();
}
return(null);
case "SaveFlowFrm":
// 转化参数意义.
string vals = v1;
string fk_Node = v2;
string fk_flow = v3;
bool isPrint = false;
if (v5 == "1")
{
isPrint = true;
}
bool isReadonly = false;
if (v4 == "1")
{
isReadonly = true;
}
string msg = this.SaveEn(vals);
if (msg.Contains("Error"))
{
return(msg);
}
string fk_frm = msg;
Frm fm = new Frm();
fm.No = fk_frm;
fm.Retrieve();
FrmNode fn = new FrmNode();
if (fn.Retrieve(FrmNodeAttr.FK_Frm, fk_frm,
FrmNodeAttr.FK_Node, fk_Node) == 1)
{
fn.IsEdit = !isReadonly;
fn.IsPrint = isPrint;
fn.FK_Flow = fk_flow;
fn.Update();
BP.DA.DBAccess.RunSQL("UPDATE Sys_MapData SET FK_FrmSort='01',AppType=1 WHERE No='" + fk_frm + "'");
return(fk_frm);
}
fn.FK_Frm = fk_frm;
fn.FK_Flow = fk_flow;
fn.FK_Node = int.Parse(fk_Node);
fn.IsEdit = !isReadonly;
fn.IsPrint = isPrint;
fn.Idx = 100;
fn.FK_Flow = fk_flow;
fn.Insert();
MapData md = new MapData();
md.No = fm.No;
if (md.RetrieveFromDBSources() == 0)
{
md.Name = fm.Name;
md.EnPK = "OID";
md.Insert();
}
MapAttr attr = new MapAttr();
attr.FK_MapData = md.No;
attr.KeyOfEn = "OID";
attr.Name = "WorkID";
attr.MyDataType = BP.DA.DataType.AppInt;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.DefVal = "0";
attr.HisEditType = BP.En.EditType.Readonly;
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = md.No;
attr.KeyOfEn = "FID";
attr.Name = "FID";
attr.MyDataType = BP.DA.DataType.AppInt;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.DefVal = "0";
attr.HisEditType = BP.En.EditType.Readonly;
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = md.No;
attr.KeyOfEn = "RDT";
attr.Name = "记录日期";
attr.MyDataType = BP.DA.DataType.AppDateTime;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.DefVal = "@RDT";
attr.HisEditType = BP.En.EditType.Readonly;
attr.Insert();
return(fk_frm);
default:
return("Error:" + dotype + " , 未设置此标记.");
}
}
catch (Exception ex)
{
return("Error:" + ex.Message);
}
}
private void Exit_Yes()
{
Frm.Si.Show();
Frm.Close();
Close();
}
public void WriteToLog(LogType LT, string LogMessage)
{
try
{
DateTime DT = DateTime.Today;
string Datum = DT.ToString("dd.MM.yyyy");
string CompMessage = "";
Form Frm;
bool loglevel = true;
switch (LT)
{
case LogType.Error:
CompMessage = "FEHLER: " + LogMessage + "\r\n";
if (Mode != LogMode.Error && Mode != LogMode.All)
{
loglevel = false;
}
break;
case LogType.Warning:
CompMessage = "WARNUNG: " + LogMessage + "\r\n";
if (Mode != LogMode.Warning && Mode != LogMode.All)
{
loglevel = false;
}
break;
case LogType.Info:
CompMessage = "INFO: " + LogMessage + "\r\n";
if (Mode != LogMode.Info && Mode != LogMode.All)
{
loglevel = false;
}
break;
}
if (Datum != aktdate)
{
OpenLogFile();
}
if (fs.CanWrite)
{
if (WType != WindowType.None)
{
switch (WType)
{
case WindowType.RichTextBox:
RichTextBox RTB = (RichTextBox)Window;
//this.Invoke((MethodInvoker)(() => richTextBox1.Text = richTextBox1.Text + CompMessage));
Frm = RTB.FindForm();
Frm.Invoke((MethodInvoker)(() => RTB.Text = RTB.Text + CompMessage));
break;
case WindowType.TextBox:
TextBox TB = (TextBox)Window;
Frm = TB.FindForm();
Frm.Invoke((MethodInvoker)(() => TB.Text = TB.Text + CompMessage));
break;
case WindowType.ComboBox:
ComboBox CB = (ComboBox)Window;
Frm = CB.FindForm();
Frm.Invoke((MethodInvoker)(() => CB.Items.Add(CompMessage)));
break;
case WindowType.ListBox:
ListBox LB = (ListBox)Window;
Frm = LB.FindForm();
Frm.Invoke((MethodInvoker)(() => LB.Items.Add(CompMessage)));
break;
case WindowType.None:
break;
}
}
if (loglevel)
{
fs.WriteAsync(Encoding.ASCII.GetBytes(CompMessage), 0, CompMessage.Length);
fs.FlushAsync();
}
}
}
catch (Exception ex)
{
if (fs.CanWrite)
{
fs.WriteAsync(Encoding.ASCII.GetBytes(ex.Message.ToString()), 0, ex.Message.Length);
fs.FlushAsync();
}
}
}
