123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262 |
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Linq;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using DevExpress.XtraEditors;
- using Uninpho.DBOperation.Model;
- using System.IO;
- using Uninpho.DBOperation.Operation;
- using System.Text.RegularExpressions;
- using System.Reflection;
- namespace Uninpho.Tools.components.DWForm
- {
- public partial class ImportGLdataForm : DevExpress.XtraEditors.XtraForm
- {
- public ImportGLdataForm()
- {
- InitializeComponent();
- }
- private void labelControl7_Click(object sender, EventArgs e)
- {
- }
- private void labelControl1_Click(object sender, EventArgs e)
- {
- }
- private void xianlumingText_SelectedIndexChanged(object sender, EventArgs e)
- {
- }
- private void zhanmingText_SelectedIndexChanged(object sender, EventArgs e)
- {
- }
- private void groupBox1_Enter(object sender, EventArgs e)
- {
- }
- private void lblShow_Click(object sender, EventArgs e)
- {
- }
- private void txtindir_TextChanged(object sender, EventArgs e)
- {
- }
- private void simpleButton2_Click(object sender, EventArgs e)
- {
-
- OpenFileDialog openFileDialog = new OpenFileDialog
- {
-
- Title = "选择文件",
-
- InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop),
-
- Filter = "所有文件 (*.*)|*.*"
- };
-
- if (openFileDialog.ShowDialog() == DialogResult.OK)
- {
-
- txtindir.Text = openFileDialog.FileName;
- }
- }
- private void newCreateBtnSon_Click(object sender, EventArgs e)
- {
- saveData2PG(txtindir.Text, xianlumingText.Text, zhanmingText.Text);
-
-
-
-
-
-
-
- }
-
-
-
-
-
-
- public static Encoding GetEncoding(string filePath)
- {
- using (var reader = new StreamReader(filePath, Encoding.Default, true))
- {
- if (reader.Peek() >= 0)
- {
- reader.Read();
- }
- Encoding encoding = reader.CurrentEncoding;
- reader.Close();
- return encoding;
- }
- }
-
-
-
-
- private static void readSCV(string url, string xianlu, string chezhan, ref List<T_gonglv_account> gonglvCsvdata)
- {
- StreamReader sr = new StreamReader(url, GetEncoding(url));
- sr.ReadLine();
- sr.ReadLine();
- while (!sr.EndOfStream)
- {
- string origonss = sr.ReadLine();
- origonss = origonss.Replace(" ", " ");
- origonss = origonss.Replace("/t", ",");
- origonss = origonss.Replace(" ", ",");
- var arrayarr = origonss.ToCharArray();
- if (arrayarr[0] == ',' && arrayarr[1] == ',')
- {
-
- continue;
- }
- T_gonglv_account onescvdata = new T_gonglv_account();
- onescvdata.Chezhan = chezhan;
- onescvdata.Xianlu = xianlu;
- onescvdata.Qxxh = arrayarr[0].ToString();
-
- List<string> loopstring = new List<string>();
-
- Regex re = new Regex("(?<=,\").*?(?=\",)", RegexOptions.None);
- MatchCollection mc = re.Matches(origonss);
-
- foreach (var item in mc)
- {
-
- loopstring.Add(item.ToString());
- }
-
- origonss = Regex.Replace(origonss, "(?<=,\").*?(?=\",)", "$$$$$$$$$$$$$yxc$$$$$$$$$$$$$$$");
- string[] looparr = origonss.Split(',');
-
- int ii = 0;
- for (int i = 0; i < looparr.Length; i++)
- {
- if (looparr[i] == "\"$$$$$$$yxc$$$$$$$$\"")
- {
- looparr[i] = loopstring[ii++];
- }
- }
- ii = 0;
-
-
- Type t = onescvdata.GetType();
- foreach (PropertyInfo pi in t.GetProperties())
- {
- if (pi.Name != "Id" && pi.Name != "Qxxh" && pi.Name != "Xianlu" && pi.Name != "Chezhan")
- {
- pi.SetValue(onescvdata, looparr[ii++]);
- }
- }
- gonglvCsvdata.Add(onescvdata);
- }
- sr.Close();
- }
- static string uuid_ = string.Empty;
- public static string saveData2PG(string url, string xianlu, string chezhan)
- {
- string uuid = uuid_;
- List<T_gonglv_account> gonglvCsvdata = new List<T_gonglv_account>();
-
- try
- {
- readSCV(url, xianlu, chezhan, ref gonglvCsvdata);
-
-
-
-
-
-
-
-
-
-
-
- DataAnalysisToPG.Insert_gl_data_CsvData(gonglvCsvdata);
- XtraMessageBox.Show("导入成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- catch (Exception)
- {
- XtraMessageBox.Show("导入失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- return uuid;
- }
- private void NewcancelBtn_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- List<T_daocha_account> daochaData = new List<T_daocha_account>();
-
-
-
- private void ImportGLdataForm_Load(object sender, EventArgs e)
- {
- daochaData = DBOperation.Operation.DataAnalysisToPG.QueryDCTZALL();
-
- var listtgXLMALL = daochaData.GroupBy(c => c.Xlm).Select(c => c.First()).ToList();
- foreach (var item in listtgXLMALL)
- {
- xianlumingText.Properties.Items.Add(item.Xlm);
- }
- }
-
-
-
- private void xianlumingText_TextChanged(object sender, EventArgs e)
- {
- zhanmingText.Properties.Items.Clear();
- var isInputTrueXLM = daochaData.FindAll(delegate (T_daocha_account dc)
- {
- return dc.Xlm == xianlumingText.Text;
- });
-
- if (isInputTrueXLM.Count != 0)
- {
- var listtg = isInputTrueXLM.GroupBy(c => c.Czm).Select(c => c.First()).ToList();
- foreach (var item in listtg)
- {
- zhanmingText.Properties.Items.Add(item.Czm);
- }
- zhanmingText.Enabled = true;
- }
- else
- {
- zhanmingText.Enabled = false;
- }
- zhanmingText.Text = "";
- }
- }
- }
|