using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using System.Collections; using System.IO; using System.Diagnostics; namespace Core.LZMes.Client.UIB { public partial class UIB030310 : FrmBase { private string directoryPath = "C:\\Temp\\ZBS\\";//质保书临时存放 public UIB030310() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Modify": this.DoModify(); break; case "Add": this.DoAdd(); break; case "Delete": this.DoDelete(); break; case "UpLoad": this.UpLoad(); break; case "DownLoad": this.DownLoad(); break; case "XDownload": this.xmlDownLoadFile(); break; case "XUpLoad": this.XmlUPLoad(); break; } } public void DoQuery() { try { ArrayList al = new ArrayList(); al.Add("UIB030310_01.SELECT"); al.Add(this.textBox1.Text); this.dataSet1.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { al }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); loadConfigFile(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } public void DoModify() { if (MessageBox.Show("确定修改？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; try { ArrayList al = new ArrayList(); al.Add("UIB030310_01.UPDATE"); al.Add(this.tmplNo.Text);//被修改的模板号 al.Add(this.tmplNm.Text);//模板名 al.Add(tmplRang.Value.ToString());//适用范围 al.Add(this.maxCoils.Text);//最大行数 // al.Add(this.UserInfo.GetUserName()); al.Add(this.hideTmplNO.Text);//隐藏的模板号 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBSave"; ccp.MethodName = "doXmlSave"; ccp.ServerParams = new object[] { al }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } public void DoDelete() { try { //Infragistics.Win.UltraWinGrid.UltraGridRow row = this.ultraGrid1.ActiveRow; if (this.ultraGrid1.ActiveRow == null) return; if (this.ultraGrid1.ActiveRow.Delete().ToString() == "False") return; //this.ultraGrid1.ActiveRow.Delete(true); ArrayList al = new ArrayList(); al.Add("UIB030310_01.DELETE"); al.Add(this.tmplNo.Text);//模板号 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBSave"; ccp.MethodName = "doXmlSave"; ccp.ServerParams = new object[] { al }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); }catch(Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } public void DoAdd() { if (MessageBox.Show("确定增加？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; try { ArrayList al = new ArrayList(); al.Add("UIB030310_01.INSERT"); al.Add(this.tmplNo.Text);//模板号 al.Add(this.tmplNm.Text);//模板名 al.Add(tmplRang.Value.ToString());//适用范围 al.Add(this.maxCoils.Text);//最大卷数 al.Add(this.UserInfo.GetUserName()); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBSave"; ccp.MethodName = "doXmlSave"; ccp.ServerParams = new object[] { al }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); DataRow dr = this.dataSet1.Tables[0].NewRow(); dr["TMPL_NO"] = this.tmplNo.Text; dr["TMPL_CFNM"] = this.tmplNm.Text; dr["PROD_LINE"] = tmplRang.Value.ToString(); dr["COIL_ROWS"] = this.maxCoils.Text; this.dataTable1.Rows.Add(dr); this.dataTable1.AcceptChanges(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //模板上传 public void UpLoad() { try { if (this.textBox2.Text == "") { MessageBox.Show("请选择需上传的文件"); return; } if (MessageBox.Show("确定上传？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; FileStream read = new FileStream(this.textBox2.Text.Trim(), FileMode.Open, FileAccess.Read); byte[] byData = new byte[read.Length]; read.Read(byData, 0, (int)read.Length); read.Close(); if (byData == null) { MessageBox.Show("请先选择需要上传的文件！", "提示"); return; } //获取文件扩展名 string[] str = this.textBox2.Text.Trim().Split('.'); string extName = "."+str[str.Length - 1]; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.UIB03.UIB030310"; ccp.MethodName = "upLoadFile"; ccp.ServerParams = new object[] { this.tmplNo.Text, byData, extName, this.UserInfo.GetUserName() }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoQuery(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("上传失败，请选择正确的文件路径", "提示"); } } //模板预览 public void DownLoad() { try { if (this.ultraGrid1.ActiveRow == null) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.UIB03.UIB030310"; ccp.MethodName = "downLoadFile"; ccp.ServerParams = new object[] { this.ultraGrid1.ActiveRow.Cells["TMPL_NO"].Text }; CoreClientParam cx = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); byte[] byData = (byte[])cx.ReturnObject; //判断文件类型 string extFileType = this.ultraGrid1.ActiveRow.Cells["EXT_NAME"].Text; //if (byData[0] + "" + byData[1] == "208207")//xls文件 //{ // extFileType = ".xls"; //} //else if (byData[0] + "" + byData[1] == "8075")//docx文件 //{ // extFileType = ".docx"; //} //else if (byData[0] + "" + byData[1] == "6063")//xml //{ // extFileType = ".xml"; //} //else if (byData[0] + "" + byData[1] == "255216")//jpg文件 //{ // extFileType = ".jpg"; //} //else if (byData[0] + "" + byData[1] == "13780")//png文件 //{ // extFileType = ".png"; //} //else //{ // MessageBox.Show("未知文件类型，无法打开！", "提示"); // return; //} System.DateTime dt = System.DateTime.Now; string TimeNow = string.Format("{0:yyyyMMddHHmmssffff}", dt); string sFile = directoryPath + this.ultraGrid1.ActiveRow.Cells["TMPL_CFNM"].Text + TimeNow + extFileType; FileStream fs = new FileStream(sFile, FileMode.OpenOrCreate, FileAccess.Write); fs.Write(byData, 0, byData.Length); fs.Close(); ProcessStartInfo p = new ProcessStartInfo(sFile); p.WorkingDirectory = Path.GetDirectoryName(sFile); Process.Start(p); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } //配置文件上传 public void XmlUPLoad() { try { if (this.textBox3.Text == "") { MessageBox.Show("请选择需上传的文件"); return; } if (MessageBox.Show("确定上传？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; FileStream read = new FileStream(this.textBox3.Text.Trim(), FileMode.Open, FileAccess.Read); byte[] byData = new byte[read.Length]; read.Read(byData, 0, (int)read.Length); read.Close(); int index_ = this.textBox3.Text.LastIndexOf("\\"); string fName = this.textBox3.Text.Substring(index_+1); if (byData == null) { MessageBox.Show("请先选择需要上传的文件！", "提示"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.UIB03.UIB030310"; ccp.MethodName = "xmlUpLoad"; ccp.ServerParams = new object[] { byData, fName }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("上传失败，请选择正确的文件路径" , "提示"); } } //配置文件下载 public void xmlDownLoadFile() { try { string selectFile = this.listBox1.Text;//被选择的配置文件 if (selectFile == "") { MessageBox.Show("请选择需要下载的文件" , "提示"); return; } this.folderBrowserDialog1.ShowDialog(); string selectPath = this.folderBrowserDialog1.SelectedPath;//选择的路径 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.UIB03.UIB030310"; ccp.MethodName = "xmlDownLoadFile"; ccp.ServerParams = new object[] { selectFile }; CoreClientParam cx = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); byte[] byData = (byte[])cx.ReturnObject; System.DateTime dt = System.DateTime.Now; string TimeNow = string.Format("{0:yyyyMMddHHmmssffff}", dt); string sFile = selectPath +"\\"+ selectFile; FileStream fs = new FileStream(sFile, FileMode.OpenOrCreate, FileAccess.Write); fs.Write(byData, 0, byData.Length); fs.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { try { if (this.ultraGrid1.ActiveRow == null) return; this.tmplNo.Text = this.ultraGrid1.ActiveRow.Cells["TMPL_NO"].Text; this.tmplNm.Text = this.ultraGrid1.ActiveRow.Cells["TMPL_CFNM"].Text; this.tmplRang.Value = this.ultraGrid1.ActiveRow.Cells["PROD_LINE"].Value.ToString(); this.maxCoils.Text = this.ultraGrid1.ActiveRow.Cells["COIL_ROWS"].Text; this.hideTmplNO.Text = this.ultraGrid1.ActiveRow.Cells["TMPL_NO"].Text; } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void tmplNo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.tmplNm.Focus(); } } private void tmplNm_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.tmplRang.Focus(); } } //质保书上传 private void button1_Click(object sender, EventArgs e) { try { OpenFileDialog Ofd = new OpenFileDialog(); Ofd.Title = "选择文件"; Ofd.Filter = "文件 (*.doc;*;docx;*.xls;*.xlsx;*.et;*.png;*.xml;*.jpg)|*.doc;*;docx;*.xls;*.xlsx;*.et;*.png;*.xml;*.jpg"; //Ofd.Filter = "文件 (*.xls)|*.xls"; //Ofd.Filter = "文件 (*.*)|*.*"; if (Ofd.ShowDialog() == DialogResult.OK) { this.textBox2.Text = Ofd.FileName.ToString();//选取文件路径 } } catch(Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void UIB030310_Load(object sender, EventArgs e) { try { loadConfigFile(); if (!Directory.Exists(directoryPath))//若不存在，则创建临时文件夹 { Directory.CreateDirectory(directoryPath); } if (Directory.Exists(directoryPath)) { foreach (string f in Directory.GetFileSystemEntries(directoryPath)) { try { if (File.Exists(f)) File.Delete(f); //直接删除其中的文件 } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); continue;//文件正在使用，则跳过该文件 } } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //载入所有配置文件 public void loadConfigFile() { try { this.listBox1.Items.Clear(); //显示所有配置文件 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.UIB03.UIB030310"; ccp.MethodName = "loadUIB030310"; ccp.ServerParams = new object[] { }; CoreClientParam cx = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); string[] str = (string[])cx.ReturnObject; for (int i = 0; i < str.Length; i++) { this.listBox1.Items.Add(str[i]); } } catch (Exception ex) { } } private void button2_Click(object sender, EventArgs e) { try { OpenFileDialog Ofd = new OpenFileDialog(); Ofd.Title = "选择文件"; // Ofd.Filter = "文件 (*.doc;*.txt;*.htm;*.xls;*.jpg)|*.doc;*.txt;*.htm;*.xls;*.jpg"; Ofd.Filter = "文件 (*.*)|*.*"; if (Ofd.ShowDialog() == DialogResult.OK) { this.textBox3.Text = Ofd.FileName.ToString();//选取文件路径 } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void button3_Click(object sender, EventArgs e) { XmlUPLoad(); } private void button4_Click(object sender, EventArgs e) { this.xmlDownLoadFile(); } //private void button2_Click(object sender, EventArgs e) //{ // try // { // string idName = "UIB030310"; // string value = "123"; // string str; // StreamReader sr = new StreamReader("D:\\Temp\\LzUpdate\\1.txt", false); // str = sr.ReadToEnd(); // if (idName.IndexOf(str) != -1) // { // } // sr.Close(); // StreamWriter sw = new StreamWriter("D:\\Temp\\LzUpdate\\1.txt", true); // // sw.Write(xxx); // sw.WriteLine(xxx); // sw.Flush(); // sw.Close(); // //str = sr.ReadLine().ToString(); // MessageBox.Show(str); // } // catch (Exception ex) // { // MessageBox.Show(ex.ToString()); // } //} //private void button2_Click_1(object sender, EventArgs e) //{ // StreamWriter sw = new StreamWriter("D:\\Temp\\LzUpdate\\1.txt", true); // // sw.Write(xxx); // sw.WriteLine(xxx); // sw.Flush(); // sw.Close(); // string str; // StreamReader sr = new StreamReader("D:\\Temp\\LzUpdate\\1.txt", false); // str = sr.ReadToEnd(); // FileStream fs; //} } }