public void CheckToAdd(DataBasic data) { foreach (DataBasic db in all) { if (db.uid == data.uid) { return; } } all.Add(data); }
public RepositoryBase() { switch (DataBaseCategory) { case DataBasic.Ace: { Database = new Access(ConnectionString); ((Access)Database).DbType = Access.DdTypes.Ace; break; } case DataBasic.Jet: { Database = new Access(ConnectionString); ((Access)Database).DbType = Access.DdTypes.JET; break; } case DataBasic.Sql: { Database = new Sql(ConnectionString); break; } case DataBasic.SqlEarly: { Database = new SqlEarly(ConnectionString); break; } case DataBasic.MySql: { Database = new Data.DataBase.MySql(ConnectionString); break; } default: { Database = new Sql(ConnectionString); break; } } ApplicationContext = ServiceLocator.Current.GetInstance <IApplicationContext>(); }
public ScBasic(DataBasic data) { if (data.Sid != null) { Sid = data.Sid; } else { throw new ArgumentException("A script is missing it's SID"); } if (data.Inject != null) { InjectOnFinish = data.Inject; } Active = true; Repeat = false; }
private void button2_Click(object sender, EventArgs e) { using (DocumentLock documentLock = AcadApplication.DocumentManager.MdiActiveDocument.LockDocument()) //锁住文档以便进行写操作 { string connectionString = Uitl.GetConnectionString(); //写连接字符串 string selstring = "SELECT * FROM DataDic"; if (Tools.DataBasic.Create_Dic_table(connectionString)) { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlDataAdapter Adapter = DataBasic.Dic_Initadapter(selstring, connectionString); DataSet dataset = new DataSet(); Adapter.Fill(dataset, "DataDic");//填充Dataset System.Data.DataTable TB = dataset.Tables["DataDic"]; Tools.Uitl uitl = new Uitl(); ArrayList array = new ArrayList(); int count = TB.Rows.Count; #region 将DataTable的代码和名称天然数组 for (int i = 0; i < count; i++) { DataRow row = TB.Rows[i]; string xzdm = row[0].ToString().Trim(); if (xzdm.Length != 12) { return; } array.Add(xzdm + row[1].ToString().Trim()); } #endregion uitl.DrawTree_XZC(this.treeView1, array);//画节点树 Adapter.Dispose(); connection.Close(); } } }
private void button3_Click(object sender, EventArgs e) { string connectionString = Uitl.GetConnectionString();//写连接字符串 string selstring = "SELECT * FROM DataDic"; SqlConnection Connection1 = new SqlConnection(connectionString); try { Connection1.Open(); if (Tools.DataBasic.Create_Dic_table(connectionString))//如果"DataDic"表创建成功或已经存在 { SqlDataAdapter Adapter = DataBasic.Dic_Initadapter(selstring, connectionString); DataSet dataset = new DataSet(); Adapter.Fill(dataset, "DataDic");//填充Dataset GetAllnodes Allnodes = new GetAllnodes(); Allnodes.GetAllnode(this.treeView1.Nodes); ArrayList nm = Allnodes.ArrayNodeText; ArrayList ph = Allnodes.ArrayNodeFullPath; ArrayList nn = Allnodes.ArrayNodeTag; if (MessageBox.Show("数据库中原有内容将被全部覆盖!", "系统提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { for (int i = 0; i < dataset.Tables["DataDic"].Rows.Count; i++) { DataRow Row = dataset.Tables["DataDic"].Rows[i]; Row.Delete(); } System.Data.DataTable TB = dataset.Tables["DataDic"]; DataRowCollection rowCollection = TB.Rows; for (int i = 0; i < nn.Count; i++) { string xzdm = nn[i].ToString(); DataRow row = dataset.Tables["DataDic"].NewRow(); row["ZXDM"] = xzdm; row["MC"] = nm[i].ToString(); row["SJDM"] = xzdm.Substring(0, 2); row["DSDM"] = xzdm.Substring(2, 2); row["XQDM"] = xzdm.Substring(4, 2); row["XZDM"] = xzdm.Substring(6, 3); row["XZCDM"] = xzdm.Substring(9, 3); //row["CMZDM"] = xzdm.Substring(12, 2); row["WZMC"] = ph[i].ToString(); dataset.Tables["DataDic"].Rows.Add(row); } Adapter.Update(dataset, "DataDic"); MessageBox.Show("数据字典上传完毕", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } Connection1.Close(); } catch (System.Exception ex) { MessageBox.Show(ex.Message, "管理系统提示", MessageBoxButtons.OK, MessageBoxIcon.Stop); } finally { if (Connection1.State == ConnectionState.Open) { Connection1.Close(); } } }
void OnUserBasicData(DataBasic data) { print("::::::::::::::::::::::: new user " + data); all.Add(data); }
private void ProccesBentukKekerasan() { var rangetanggal = GetTanggal(); List <Pengaduan> pengaduans; if (this.BasisPeriode <= 1) { pengaduans = DataBasic.DataPengaduan.Where(x => x.TanggalKejadian >= rangetanggal.Item1 && x.TanggalKejadian <= rangetanggal.Item2).ToList(); } else { pengaduans = DataBasic.DataPengaduan.Where(x => x.TanggalLapor >= rangetanggal.Item1 && x.TanggalLapor <= rangetanggal.Item2).ToList(); } var groupbyDistrik = pengaduans.GroupBy(x => x.KodeDistrik); List <Kekerasandll> source = new List <Kekerasandll>(); foreach (var distrik in groupbyDistrik) { var korbans = distrik.SelectMany(x => x.Korban).SelectMany(x => x.ListKekerasanDialami); var groupKekerasan = korbans.GroupBy(x => x); var model = new Kekerasandll(); model.Kasus = distrik.Count(); model.Unit = DataBasic.GetKecamatan().Where(x => x.Id == distrik.Key).FirstOrDefault().Nama; foreach (var item in groupKekerasan) { switch (item.Key) { case "Fisik": model.KekerasanFisik = item.Count(); break; case "Psikis": model.KekerasanFisik = item.Count(); break; case "Seksual": model.KekerasanSeksual = item.Count(); break; case "Eksploitasi": model.KekerasanEksploitasi = item.Count(); break; case "Trafficking": model.KekerasanTrafficing = item.Count(); break; case "Penelantaran": model.KekerasanPenelantaran = item.Count(); break; default: model.KekerasanLainnya += item.Count(); break; } } var pengananas = distrik.SelectMany(x => x.Korban).SelectMany(x => x.DataPenanganan).GroupBy(x => x.Layanan); foreach (var item in pengananas) { switch (item.Key) { case "Bantuan Humum": model.JenisBantuanHukum = item.Count(); break; case "Kesehatan": model.JenisKesehatan = item.Count(); break; case "Pemulangan": model.JenisPemulangan = item.Count(); break; case "Pendampingan Tokoh Agama": model.JenisTokohAgama = item.Count(); break; case "Penegakan Hukum": model.JenisPenegakanHukum = item.Count(); break; case "Pengaduan": model.JenisPengaduan = item.Count(); break; case "Rehabilitasi Sosial": model.JenisRehabilitasi = item.Count(); break; case "Reintegrasi Sosial": model.JenisReintegrasi = item.Count(); break; } } var tempats = distrik.GroupBy(x => x.TempatKejadian); foreach (var item in tempats) { switch (item.Key) { case "Rumah Tangga": model.TempatRumah = item.Count(); break; case "Tempat Kerja": model.TempatKerja = item.Count(); break; case "Sekolah": model.TempatSekolah = item.Count(); break; case "Fasilitas Umum": model.TempatUmum = item.Count(); break; default: model.TempatLainya += item.Count(); break; } } model.Nomor = source.Count() + 1; source.Add(model); } var header = new ReportHeader { Title = "REPORT BENTUK KEKERASAN, TEMPAT KEJADIAN & PELAYANAN", Tahun = Tahun, BaseSelection = GetBaseSelection(), SubSelection1 = GetSub1() }; HelperPrint.PrintWithFormActionTwoSource("Print Preview", new ReportDataSource { Name = "Header", Value = new List <ReportHeader>() { header } }, new ReportDataSource { Name = "DataSet1", Value = source }, "Main.Reports.Layout.Kekerasandll.rdlc", null); }
private void ProccesAnakDewasaTerlayani() { var rangetanggal = GetTanggal(); List <Pengaduan> pengaduans; if (this.BasisPeriode <= 1) { pengaduans = DataBasic.DataPengaduan.Where(x => x.TanggalKejadian >= rangetanggal.Item1 && x.TanggalKejadian <= rangetanggal.Item2).ToList(); } else { pengaduans = DataBasic.DataPengaduan.Where(x => x.TanggalLapor >= rangetanggal.Item1 && x.TanggalLapor <= rangetanggal.Item2).ToList(); } var groupbyDistrik = pengaduans.GroupBy(x => x.KodeDistrik); List <KorbanAnakDewasaTerlayani> source = new List <KorbanAnakDewasaTerlayani>(); foreach (var distrik in groupbyDistrik) { var pengaduanTerlayani = distrik.Where(x => x.Korban.Count > 0); var agesTerlayani = pengaduanTerlayani.GroupByAge(BasisPeriode); var model = new KorbanAnakDewasaTerlayani(); model.Kasus = distrik.Count(); model.Distrik = DataBasic.GetKecamatan().Where(x => x.Id == distrik.Key).FirstOrDefault().Nama; foreach (var item in agesTerlayani) { switch (item.Key) { case "Anak": model.TerlayaniAnak = item.Count(); break; default: model.TerlayaniDewasa = item.Count(); break; } } var pengaduanTakTerlayani = distrik.Where(x => x.Korban.Count <= 0); var agesTakTerlayani = pengaduanTakTerlayani.GroupByAge(BasisPeriode); foreach (var item in agesTakTerlayani) { switch (item.Key) { case "Anak": model.KorbanAnak = item.Count(); break; default: model.KorbanDewasa = item.Count(); break; } } model.Nomor = source.Count + 1; source.Add(model); } var header = new ReportHeader { Title = "REPORT KASUS & KORBAN ANAK DEWASA TERLAYANI", Tahun = Tahun, BaseSelection = GetBaseSelection(), SubSelection1 = GetSub1() }; HelperPrint.PrintWithFormActionTwoSource("Print Preview", new ReportDataSource { Name = "Header", Value = new List <ReportHeader>() { header } }, new ReportDataSource { Name = "DataSet1", Value = source }, "Main.Reports.Layout.DewasaAnakTerlayani.rdlc", null); }
private void ProccesCiriKorban() { var rangetanggal = GetTanggal(); List <Pengaduan> pengaduans; if (this.BasisPeriode <= 1) { pengaduans = DataBasic.DataPengaduan.Where(x => x.TanggalKejadian >= rangetanggal.Item1 && x.TanggalKejadian <= rangetanggal.Item2).ToList(); } else { pengaduans = DataBasic.DataPengaduan.Where(x => x.TanggalLapor >= rangetanggal.Item1 && x.TanggalLapor <= rangetanggal.Item2).ToList(); } List <CiriKorbanDanPelaku> listModel = new List <Models.CiriKorbanDanPelaku>(); var groupbyDistrik = pengaduans.GroupBy(x => x.KodeDistrik); foreach (var list in groupbyDistrik) { var genders = list.ToList().GroupByKorbanGender(); foreach (var gender in genders) { var ages = gender.GroupAgeOfKorban(BasisPeriode); var pendidkans = gender.GroupPendidikan(); var pekerjaans = gender.GroupPekerjaan(); var perkawinans = gender.GroupPernikahan(); var model = new CiriKorbanDanPelaku(); model.Distrik = DataBasic.GetKecamatan().Where(x => x.Id == list.Key).FirstOrDefault().Nama; model.Kasus = list.Count(); foreach (var pekerjaan in pekerjaans) { switch (pekerjaan.Key) { case "NA": model.PekNa = pekerjaan.Count(); break; case "Bekerja": model.PekBekerja = pekerjaan.Count(); break; case "Pelajar": model.PekPelajar = pekerjaan.Count(); break; case "Ibu Rumah Tangga": model.PekIrt = pekerjaan.Count(); break; case "Swasta/Buruh": model.PekSwasta = pekerjaan.Count(); break; case "PNS/TNI/POLRI": model.PekPns = pekerjaan.Count(); break; case "Pedagang/Tani/Nelayan": model.PekPedagang = pekerjaan.Count(); break; case "Tidak Bekerja": model.PekTbekerja = pekerjaan.Count(); break; default: model.PekNa = pekerjaan.Count(); break; } } foreach (var pendidikan in pendidkans) { switch (pendidikan.Key) { case "Tidak Sekolah": model.PendTs = pendidikan.Count(); break; case "Paud": model.PendPaud = pendidikan.Count(); break; case "TK": model.PendTK = pendidikan.Count(); break; case "SD": model.PendSd = pendidikan.Count(); break; case "SLTP": model.PendSmp = pendidikan.Count(); break; case "SLTA": model.PendSlta = pendidikan.Count(); break; case "Perguruan Tinggi": model.PendPt = pendidikan.Count(); break; default: model.PendNa = pendidikan.Count(); break; } } foreach (var item in ages) { model.Gender = gender.Key.ToString(); // var count = model.Count(); switch (item.Key.Item2) { case 5: model.usia5 = item.Count(); break; case 12: model.usia12 = item.Count(); break; case 17: model.usia17 = item.Count(); break; case 24: model.usia24 = item.Count(); break; case 44: model.usia44 = item.Count(); break; case 49: model.usia59 = item.Count(); break; default: model.usia60 = item.Count(); break; } } foreach (var status in perkawinans) { model.Gender = gender.Key.ToString(); // var count = model.Count(); switch (status.Key) { case "Tidak Ada Status Nikah": model.KawinBelum = status.Count(); break; case "Cerai": model.KawinCerai = status.Count(); break; default: model.KawinKawin = status.Count(); break; } } listModel.Add(model); } var header = new ReportHeader { Title = "REPORT CIRI KORBAN", Tahun = Tahun, BaseSelection = GetBaseSelection(), SubSelection1 = GetSub1() }; HelperPrint.PrintWithFormActionTwoSource("Print Preview", new ReportDataSource { Name = "Header", Value = new List <ReportHeader>() { header } }, new ReportDataSource { Name = "DataSet1", Value = listModel }, "Main.Reports.Layout.CiriKorban.rdlc", null); } }