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);
}
}
