/// <summary>
/// 获取行政区域代码集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="code">代码</param>
/// <param name="name">地域名称</param>
/// <returns>实体集合</returns>
internal EList<AreaCode> AreaCodeGetAll(int page, int pageSize, string code, string name)
{
EList<AreaCode> AreaCodes = new EList<AreaCode>();
List<WhereClip> Clips = new List<WhereClip>();
if (code != "")
Clips.Add(DataBases.AreaCode.CodeID.Like("%" + code + "%"));
if (name != "")
Clips.Add(DataBases.AreaCode.CodeName.Like("%" + name + "%"));
SelectSqlSection section = DB.Select(DataBases.AreaCode, DataBases.AreaCode.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
AreaCodes.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.AreaCode);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.AreaCode.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
AreaCode areaCode = ReadRow(reader);
AreaCodes.Items.Add(areaCode);
}
}
}
return AreaCodes;
}
/// <summary>
/// 获取延期（分期）缴纳罚款审批表集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<ContributeFineApproval> ContributeFineApprovalByDate(int page, int pageSize, DateTime beginDate, DateTime endDate)
{
EList<ContributeFineApproval> Objs = new EList<ContributeFineApproval>();
List<WhereClip> Clips = new List<WhereClip>();
Clips.Add(DataBases.ContributeFineApproval.FormDate >= beginDate.Date && DataBases.ContributeFineApproval.FormDate <= endDate.AddDays(1).Date);
SelectSqlSection section = DB.Select(DataBases.ContributeFineApproval, DataBases.ContributeFineApproval.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
Objs.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.ContributeFineApproval);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.ContributeFineApproval.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
ContributeFineApproval Obj = ReadRow(reader);
Objs.Items.Add(Obj);
}
}
}
return Objs;
}
/// <summary>
/// 现场处理措施决定书（6个月内）
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="docTitle">文号</param>
/// <returns>实体集合</returns>
internal EList<SpotHandelDesisionSixtyDay> SpotHandelDesisionSixtyDayGetAll(int page, int pageSize, string docTitle)
{
EList<SpotHandelDesisionSixtyDay> SpotHandelDesisionSixtyDays = new EList<SpotHandelDesisionSixtyDay>();
List<WhereClip> Clips = new List<WhereClip>();
if (docTitle != "")
Clips.Add(DataBases.SpotHandelDesisionSixtyDay.DocTitle.Like("%" + docTitle + "%"));
SelectSqlSection section = DB.Select(DataBases.SpotHandelDesisionSixtyDay, DataBases.SpotHandelDesisionSixtyDay.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
SpotHandelDesisionSixtyDays.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.SpotHandelDesisionSixtyDay);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.SpotHandelDesisionSixtyDay.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
SpotHandelDesisionSixtyDay spotHandelDesisionSixtyDay = ReadRow(reader);
SpotHandelDesisionSixtyDays.Items.Add(spotHandelDesisionSixtyDay);
}
}
}
return SpotHandelDesisionSixtyDays;
}
public void GetDbParaByDataRow(DataRow row, DbList <DbParameter> dbParas, EList <CKeyValue> sqlParaNameList, EList <CKeyValue> tableColumns)
{
dbParas.Clear();
if (null == row)
{
return;
}
CKeyValue kv = null;
Type type = null;
object vObj = null;
string paraTypeStr = "";
foreach (var item in sqlParaNameList)
{
kv = tableColumns[item.Key];
if (null == kv)
{
continue;
}
if (string.IsNullOrEmpty(paraTypeStr))
{
paraTypeStr = item.other.ToString();
}
vObj = row[kv.Value.ToString()];
type = kv.other as Type;
type = null == type ? typeof(string) : type;
GetDbParaByBaseType(type, paraTypeStr, vObj, item.Value.ToString(), dbParas);
}
}
/// <summary>
/// 获取现场照片记录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<SpotShoot> SpotShootGetAll(int page, int pageSize, DateTime beginDate, DateTime endDate)
{
EList<SpotShoot> SpotShoots = new EList<SpotShoot>();
List<WhereClip> Clips = new List<WhereClip>();
Clips.Add(DataBases.SpotShoot.ShootDate >= beginDate.Date && DataBases.SpotShoot.ShootDate <= endDate.AddDays(1).Date);
SelectSqlSection section = DB.Select(DataBases.SpotShoot, DataBases.SpotShoot.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
SpotShoots.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.SpotShoot);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.SpotShoot.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
SpotShoot spotCheck = ReadRow(reader);
SpotShoots.Items.Add(spotCheck);
}
}
}
return SpotShoots;
}
/// <summary>
/// 强制措施决定审批集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="partyName">当事人姓名</param>
/// <returns>实体集合</returns>
internal EList<ForceMeasureDecisionApprove> ForceMeasureDecisionApproveGetAll(int page, int pageSize, string partyName)
{
EList<ForceMeasureDecisionApprove> ForceMeasureDecisionApproves = new EList<ForceMeasureDecisionApprove>();
List<WhereClip> Clips = new List<WhereClip>();
if (partyName != "")
Clips.Add(DataBases.ForceMeasureDecisionApprove.Party.Like("%" + partyName + "%"));
SelectSqlSection section = DB.Select(DataBases.ForceMeasureDecisionApprove, DataBases.ForceMeasureDecisionApprove.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
ForceMeasureDecisionApproves.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.ForceMeasureDecisionApprove);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.ForceMeasureDecisionApprove.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
ForceMeasureDecisionApprove forceMeasureDecisionApprove = ReadRow(reader);
ForceMeasureDecisionApproves.Items.Add(forceMeasureDecisionApprove);
}
}
}
return ForceMeasureDecisionApproves;
}
/// <summary>
/// 行政处罚决定书(单位)记录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="docTitle">文号</param>
/// <returns>实体集合</returns>
internal EList<AdministrativePenaltyCompany> AdministrativePenaltyCompanyGetAll(int page, int pageSize, string docTitle)
{
EList<AdministrativePenaltyCompany> AdministrativePenaltyCompanys = new EList<AdministrativePenaltyCompany>();
List<WhereClip> Clips = new List<WhereClip>();
if (docTitle != "")
Clips.Add(DataBases.AdministrativePenaltyCompany.DocTitle.Like("%" + docTitle + "%"));
SelectSqlSection section = DB.Select(DataBases.AdministrativePenaltyCompany, DataBases.AdministrativePenaltyCompany.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
AdministrativePenaltyCompanys.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.AdministrativePenaltyCompany);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.AdministrativePenaltyCompany.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
AdministrativePenaltyCompany sdministrativePenaltyCompany = ReadRow(reader);
AdministrativePenaltyCompanys.Items.Add(sdministrativePenaltyCompany);
}
}
}
return AdministrativePenaltyCompanys;
}
/// <summary>
/// 获取行政处罚集体讨论记录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="PutOnRecordCaseName">案件名称</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<PunishmentDiscussRecord> PunishmentDiscussRecordGetAll(int page, int pageSize, string PutOnRecordCaseName, DateTime beginDate, DateTime endDate)
{
EList<PunishmentDiscussRecord> PunishmentDiscussRecords = new EList<PunishmentDiscussRecord>();
List<WhereClip> Clips = new List<WhereClip>();
if (PutOnRecordCaseName != "")
Clips.Add(DataBases.PunishmentDiscussRecord.PutOnRecordCaseName.Like("%" + PutOnRecordCaseName + "%"));
Clips.Add(DataBases.PunishmentDiscussRecord.DiscussDate >= beginDate.Date && DataBases.PunishmentDiscussRecord.DiscussDate <= endDate.AddDays(1).Date);
Clips.Add(DataBases.PunishmentDiscussRecord.Status < 2);
SelectSqlSection section = DB.Select(DataBases.PunishmentDiscussRecord, DataBases.PunishmentDiscussRecord.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
PunishmentDiscussRecords.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.PunishmentDiscussRecord);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.PunishmentDiscussRecord.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
PunishmentDiscussRecord putOnRecord = ReadRow(reader);
PunishmentDiscussRecords.Items.Add(putOnRecord);
}
}
}
return PunishmentDiscussRecords;
}
/// <summary>
/// 获取工作人员信息集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="name">工作人员姓名</param>
/// <returns>实体集合</returns>
internal EList<Officers> OfficersGetAll(int page, int pageSize, string name)
{
EList<Officers> Officerss = new EList<Officers>();
List<WhereClip> Clips = new List<WhereClip>();
if (name != "")
Clips.Add(DataBases.Officers.OfficersName.Like("%" + name + "%"));
SelectSqlSection section = DB.Select(DataBases.Officers, DataBases.Officers.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
Officerss.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.Officers);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.Officers.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
Officers officers = ReadRow(reader);
Officerss.Items.Add(officers);
}
}
}
return Officerss;
}
private void _SubItems_ItemRemoveAfter(object sender, EList <FunctionItem> .EListAfterEventArgs args)
{
if (args.Item != null)
{
args.Item.Parent = null;
}
}
/// <summary>
/// 获取勘验笔录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<ExplorationRecord> ExplorationRecordGetAll(int page, int pageSize, string DocTitle)
{
EList<ExplorationRecord> ExplorationRecords = new EList<ExplorationRecord>();
List<WhereClip> Clips = new List<WhereClip>();
if (DocTitle != "")
Clips.Add(DataBases.ExplorationRecord.DocTitle.Like("%" + DocTitle + "%"));
Clips.Add(DataBases.ExplorationRecord.Status < 2);
SelectSqlSection section = DB.Select(DataBases.ExplorationRecord, DataBases.ExplorationRecord.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
ExplorationRecords.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.ExplorationRecord);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.ExplorationRecord.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
ExplorationRecord putOnRecord = ReadRow(reader);
ExplorationRecords.Items.Add(putOnRecord);
}
}
}
return ExplorationRecords;
}
/// <summary>
/// 获取现场检查记录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="docTitle">文号</param>
/// <returns>实体集合</returns>
internal EList<ForceMeasureDecision> ForceMeasureDecisionGetAll(int page, int pageSize, string docTitle)
{
EList<ForceMeasureDecision> ForceMeasureDecisions = new EList<ForceMeasureDecision>();
List<WhereClip> Clips = new List<WhereClip>();
if (docTitle != "")
Clips.Add(DataBases.ForceMeasureDecision.DocTitle.Like("%" + docTitle + "%"));
Clips.Add(DataBases.ForceMeasureDecision.Status < 2);
SelectSqlSection section = DB.Select(DataBases.ForceMeasureDecision, DataBases.ForceMeasureDecision.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
ForceMeasureDecisions.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.ForceMeasureDecision);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.ForceMeasureDecision.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
ForceMeasureDecision forceMeasureDecision = ReadRow(reader);
ForceMeasureDecisions.Items.Add(forceMeasureDecision);
}
}
}
return ForceMeasureDecisions;
}
private void _Items_ItemRemoveAfter(object sender, EList <FunctionGlobalItem> .EListAfterEventArgs args)
{
if (args.Item != null)
{
args.Item.Group = null;
}
}
/// <summary>
/// 行政处罚案件调查终结报告列表
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="docTitle">文号</param>
/// <returns>实体集合</returns>
internal EList<SurveyEndReport> SurveyEndReportGetAll(int page, int pageSize, string docTitle)
{
EList<SurveyEndReport> SurveyEndReports = new EList<SurveyEndReport>();
List<WhereClip> Clips = new List<WhereClip>();
if (docTitle != "")
Clips.Add(DataBases.SurveyEndReport.DocTitle.Like("%" + docTitle + "%"));
SelectSqlSection section = DB.Select(DataBases.SurveyEndReport, DataBases.SurveyEndReport.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
SurveyEndReports.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.SurveyEndReport);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.SurveyEndReport.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
SurveyEndReport surveyEndReport = ReadRow(reader);
SurveyEndReports.Items.Add(surveyEndReport);
}
}
}
return SurveyEndReports;
}
/// <summary>
/// 听证会通知书记录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="docTitle">文号</param>
/// <returns>实体集合</returns>
internal EList<HearingNotice> HearingNoticeGetAll(int page, int pageSize, string docTitle)
{
EList<HearingNotice> HearingNotices = new EList<HearingNotice>();
List<WhereClip> Clips = new List<WhereClip>();
if (docTitle != "")
Clips.Add(DataBases.HearingNotice.DocTitle.Like("%" + docTitle + "%"));
Clips.Add(DataBases.HearingNotice.Status < 2);
SelectSqlSection section = DB.Select(DataBases.HearingNotice, DataBases.HearingNotice.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
HearingNotices.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.HearingNotice);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.HearingNotice.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
HearingNotice hearingNotice = ReadRow(reader);
HearingNotices.Items.Add(hearingNotice);
}
}
}
return HearingNotices;
}
/// <summary>
/// 听证笔录记录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="docTitle">文号</param>
/// <returns>实体集合</returns>
internal EList<PutDown> PutDownGetAll(int page, int pageSize, string caseName)
{
EList<PutDown> PutDowns = new EList<PutDown>();
List<WhereClip> Clips = new List<WhereClip>();
if (caseName != "")
Clips.Add(DataBases.PutDown.CaseName.Like("%" + caseName + "%"));
Clips.Add(DataBases.PutDown.Status < 2);
SelectSqlSection section = DB.Select(DataBases.PutDown, DataBases.PutDown.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
PutDowns.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.PutDown);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.PutDown.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
PutDown putDown = ReadRow(reader);
PutDowns.Items.Add(putDown);
}
}
}
return PutDowns;
}
public void moveEnemiesLeft(object sender, EventArgs e)
{
Random r = new Random();
EList ens = es[this.put];
for (int i = 0; i < ens.Count; i++)
{
ens[i].moveLeft();
int v = r.Next(6);
if (v == 3)
{
ens[i].moveUp();
}
else if (v == 4)
{
ens[i].moveDown();
}
g.DrawImage(enmy, ens[i].x, ens[i].y, 31, 31);
int xr = r.Next(50) * -1 + 30;
int yr = r.Next(50) - r.Next(50);
int y = r.Next(10);
if (y == 0)
{
Lead lead = new Lead(scroller, g, ens[i].x, ens[i].y, soldier, mylead);
lead.ShootLittle();
lead.HurtLots();
lead.DrawBig();
lead.exe(lead.randomizeShiets(lead.Sheut(), xr, yr));
}
}
}
/// <summary>
/// 获取案件终止（撤销）审批表集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<CaseCancel> CaseCancelGetAll(int page, int pageSize, string PutOnRecordDocTitle, DateTime beginDate, DateTime endDate)
{
EList<CaseCancel> CaseCancels = new EList<CaseCancel>();
List<WhereClip> Clips = new List<WhereClip>();
if (PutOnRecordDocTitle != "")
Clips.Add(DataBases.CaseCancel.PutOnRecordDocTitle.Like("%" + PutOnRecordDocTitle + "%"));
Clips.Add(DataBases.CaseCancel.UndertakerData >= beginDate.Date && DataBases.CaseCancel.UndertakerData <= endDate.AddDays(1).Date);
Clips.Add(DataBases.CaseCancel.Status < 2);
SelectSqlSection section = DB.Select(DataBases.CaseCancel, DataBases.CaseCancel.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
CaseCancels.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.CaseCancel);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.CaseCancel.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
CaseCancel putOnRecord = ReadRow(reader);
CaseCancels.Items.Add(putOnRecord);
}
}
}
return CaseCancels;
}
/// <summary>
/// 查封（扣押）决定书
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<SealDecide> SealDecideByDate(int page, int pageSize, DateTime beginDate, DateTime endDate)
{
EList<SealDecide> Objs = new EList<SealDecide>();
List<WhereClip> Clips = new List<WhereClip>();
Clips.Add(DataBases.SealDecide.HandleDate >= beginDate.Date && DataBases.SealDecide.HandleDate <= endDate.AddDays(1).Date);
Clips.Add(DataBases.SealDecide.Status < 2);
SelectSqlSection section = DB.Select(DataBases.SealDecide, DataBases.SealDecide.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
Objs.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.SealDecide);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.SealDecide.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
SealDecide Obj = ReadRow(reader);
Objs.Items.Add(Obj);
}
}
}
return Objs;
}
/// <summary>
/// 获取询问笔录记录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<EnquireQuestion> EnquireQuestionGetAll(int page, int pageSize, DateTime beginDate, DateTime endDate)
{
EList<EnquireQuestion> EnquireQuestions = new EList<EnquireQuestion>();
List<WhereClip> Clips = new List<WhereClip>();
Clips.Add(DataBases.EnquireQuestion.EnquireBeginDate >= beginDate.Date && DataBases.EnquireQuestion.EnquireEndDate <= endDate.AddDays(1).Date);
Clips.Add(DataBases.EnquireQuestion.Status < 2);
SelectSqlSection section = DB.Select(DataBases.EnquireQuestion, DataBases.EnquireQuestion.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
EnquireQuestions.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.EnquireQuestion);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.EnquireQuestion.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
EnquireQuestion enquireQuestion = ReadRow(reader);
EnquireQuestions.Items.Add(enquireQuestion);
}
}
}
return EnquireQuestions;
}
/// <summary>
/// 获取询问笔录集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<InterrogationRecord> InterrogationRecordGetAll(int page, int pageSize, DateTime beginDate, DateTime endDate)
{
EList<InterrogationRecord> InterrogationRecords = new EList<InterrogationRecord>();
List<WhereClip> Clips = new List<WhereClip>();
Clips.Add(DataBases.InterrogationRecord.RecordDate >= beginDate.Date && DataBases.InterrogationRecord.RecordDate <= endDate.AddDays(1).Date);
Clips.Add(DataBases.InterrogationRecord.Status < 2);
SelectSqlSection section = DB.Select(DataBases.InterrogationRecord, DataBases.InterrogationRecord.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
InterrogationRecords.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.InterrogationRecord);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.InterrogationRecord.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
InterrogationRecord putOnRecord = ReadRow(reader);
InterrogationRecords.Items.Add(putOnRecord);
}
}
}
return InterrogationRecords;
}
public void ToArray_EmptyList_IsEmptyArray()
{
int[] arr = new int[] { };
var doublyLinkedList = new EList();
Assert.Equal(arr, doublyLinkedList.ToArray());
}
/// <summary>
/// 获取先行登记保存证据审批表集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<SaveEvidenceAudit> SaveEvidenceAuditGetAll(int page, int pageSize, string PutOnRecordCaseName)
{
EList<SaveEvidenceAudit> SaveEvidenceAudits = new EList<SaveEvidenceAudit>();
List<WhereClip> Clips = new List<WhereClip>();
if (PutOnRecordCaseName != "")
Clips.Add(DataBases.SaveEvidenceAudit.PutOnRecordCaseName.Like("%" + PutOnRecordCaseName + "%"));
Clips.Add(DataBases.SaveEvidenceAudit.Status < 2);
SelectSqlSection section = DB.Select(DataBases.SaveEvidenceAudit, DataBases.SaveEvidenceAudit.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
SaveEvidenceAudits.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.SaveEvidenceAudit);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.SaveEvidenceAudit.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
SaveEvidenceAudit putOnRecord = ReadRow(reader);
SaveEvidenceAudits.Items.Add(putOnRecord);
}
}
}
return SaveEvidenceAudits;
}
/// <summary>
/// 获取文书送达回执集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<DocumentsServiceReply> DocumentsServiceReplyGetAll(int page, int pageSize, string DocTitle)
{
EList<DocumentsServiceReply> DocumentsServiceReplys = new EList<DocumentsServiceReply>();
List<WhereClip> Clips = new List<WhereClip>();
if (DocTitle != "")
Clips.Add(DataBases.DocumentsServiceReply.DocTitle.Like("%" + DocTitle + "%"));
SelectSqlSection section = DB.Select(DataBases.DocumentsServiceReply, DataBases.DocumentsServiceReply.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
DocumentsServiceReplys.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.DocumentsServiceReply);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.DocumentsServiceReply.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
DocumentsServiceReply putOnRecord = ReadRow(reader);
DocumentsServiceReplys.Items.Add(putOnRecord);
}
}
}
return DocumentsServiceReplys;
}
/// <summary>
/// 获取案件来源表集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="name">名称</param>
/// <returns>实体集合</returns>
internal EList<CaseSource> CaseSourceGetAll(int page, int pageSize, string SourceName)
{
EList<CaseSource> CaseSources = new EList<CaseSource>();
List<WhereClip> Clips = new List<WhereClip>();
if (SourceName != "")
Clips.Add(DataBases.CaseSource.SourceName.Like("%" + SourceName + "%"));
SelectSqlSection section = DB.Select(DataBases.CaseSource, DataBases.CaseSource.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
CaseSources.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.CaseSource);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.CaseSource.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
CaseSource illegalType = ReadRow(reader);
CaseSources.Items.Add(illegalType);
}
}
}
return CaseSources;
}
static void init()
{
if (string.IsNullOrEmpty(rootPath))
{
return;
}
matchRules = MatchRules();
TempImpl tempImpl = new TempImpl();
tempImpl.SetRootPath(rootPath);
tempImpl.IsShowCodeOfDataResourceDLL = dbInfo.IsShowCode;
DataAdapter.SetConfig(dbInfo.ConnectionString, dbInfo.DatabaseType);
assemblies = DJTools.GetAssemblyCollection(rootPath);
AutoCall.AssemblyCollection = assemblies;
AutoCall.SetDataProviderAssemble(dbInfo.SqlProviderRelativePathOfDll);
AutoCall.RootPath = rootPath;
AutoCall.GetDllAbsolutePathByRelativePath = GetDllAbsolutePathByRelativePath;
DbList <Data.Common.DbParameter> .dataServerProvider = dataServerProvider;
if (null != DbHelper)
{
DbHelper.connectString = dbInfo.ConnectionString;
DbHelper.optByBatchMaxNumber = dbInfo.optByBatchMaxNumber;
DbHelper.optByBatchWaitSecond = dbInfo.optByBatchWaitSecond;
DbHelper.sqlMaxLengthForBatch = dbInfo.sqlMaxLengthForBatch;
DbHelper.disposableAndClose = dbInfo.close;
}
}
/// <summary>
/// Zajistí akce před odebráním prvku
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
void _ItemList_ItemRemoveBefore(object sender, EList <IInteractiveItem> .EListBeforeEventArgs args)
{
this.OnItemRemoveBefore(args);
if (this.ItemRemoveBefore != null)
{
this.ItemRemoveBefore(this, args);
}
}
public void ClearEmptyList_Cleared()
{
var doublyLinkedList = new EList();
doublyLinkedList.Clear();
Assert.Equal(0, doublyLinkedList.Size());
}
public void InvalidListInit_OnEmptyArray_EmptyListCreated()
{
var doublyLinkedList = new EList();
doublyLinkedList.Init(new int[] { });
Assert.Equal(0, doublyLinkedList.Size());
}
/// <summary>
/// Zajistí akce po přidání prvku
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
void _ItemList_ItemAddAfter(object sender, EList <IInteractiveItem> .EListAfterEventArgs args)
{
this.OnItemAddAfter(args);
if (this.ItemAddAfter != null)
{
this.ItemAddAfter(this, args);
}
}
/// <summary>
/// Create an HTML LIST
/// </summary>
/// <param name="html">Current HTML helper object</param>
/// <param name="type">List type</param>
/// <param name="listItems">A collection of list items</param>
/// <param name="htmlAttributes">[Optional] Extra HTML attributes</param>
/// <returns>A HTML LIST</returns>
public static HtmlList List(
this HtmlHelper html,
EList type,
IEnumerable <HtmlListItem> listItems,
object htmlAttributes = null)
{
return(new HtmlList(type, listItems, htmlAttributes));
}
public void MaxValueNode_InitializedList_Value()
{
var initArray = new[] { 3, 7, 111, 33, 222 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray.Max(), doublyLinkedList.Max());
}
public void GetNode_ZeroIndex_Exception()
{
var initArray = new[] { 1, 7, 48, 33, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Throws <InvalidOperationException>(() => doublyLinkedList.Get(0));
}
public void SortInitializedList_ZeroElements_NoError()
{
var arrayToCompare = new int[] { };
var doublyLinkedList = new EList();
doublyLinkedList.Sort();
Assert.Equal(arrayToCompare, doublyLinkedList.ToArray());
}
public void GetNode_InsideListNode_ReturnedNodeValue()
{
var initArray = new[] { 1, 7, 48, 33, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[2], doublyLinkedList.Get(3));
}
public void GetNode_FirstNode_OneNodeInList_ReturnedNodeValue()
{
var initArray = new[] { 1 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[0], doublyLinkedList.Get(1));
}
public void AddPosNode_ExceedingIndex_Exception()
{
var initArray = new[] { 1, 7, 48, 33, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Throws <InvalidOperationException>(() => doublyLinkedList.AddPos(initArray.Length + 2, 77));
}
public void AddPosNode_AsSizePlusOnePosition_EmptyList_Added()
{
var valToAdd = 123;
var doublyLinkedList = new EList();
doublyLinkedList.AddPos(doublyLinkedList.Size() + 1, valToAdd);
Assert.Equal(valToAdd, doublyLinkedList.Get(doublyLinkedList.Size()));
}
public void AddPosNode_FirstPosition_UninitializedList_Added()
{
var valToAdd = 777;
var doublyLinkedList = new EList();
doublyLinkedList.AddPos(1, valToAdd);
Assert.Equal(valToAdd, doublyLinkedList.MinPos());
}
public void AddEndNode_EmptyList_Added()
{
var valueToAdd = 555;
var doublyLinkedList = new EList();
doublyLinkedList.AddEnd(valueToAdd);
Assert.Equal(valueToAdd, doublyLinkedList.MaxPos());
}
public void MaxValueNode_TwoNodesList_Value()
{
var initArray = new[] { 99, 3 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray.Max(), doublyLinkedList.Max());
}
public void GetNode_LastNode_ReturnedNodeValue()
{
var initArray = new[] { 1, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[initArray.Length - 1], doublyLinkedList.Get(doublyLinkedList.Size()));
}
public void DeleteNodeByPosition_ExceedingIndex_Exception()
{
var initArray = new[] { 1, 7, 48, 33, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Throws <InvalidOperationException>(() => doublyLinkedList.DelPos(10));
}
public void DeleteNodeByPosition_LastNode_Deleted()
{
var initArray = new[] { 1, 7, 48, 33, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[4], doublyLinkedList.DelPos(5));
}
public void MinValueNode_InitializedList_Value()
{
var doublyLinkedList = new EList();
int[] initArray = new[] { 3, 7, -111, 33, 222 };
doublyLinkedList.Init(initArray);
Assert.Equal(initArray.Min(), doublyLinkedList.Min());
}
public void DeleteEndNode_InitializedList_Deleted()
{
var initArray = new[] { 1, 7, 48, 33, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[initArray.Length - 1], doublyLinkedList.DelEnd());
}
public void DeleteEndNode_OneNodeList_Deleted()
{
var initArray = new[] { 187 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[initArray.Length - 1], doublyLinkedList.DelEnd());
}
public void DeleteStartNode_TwoNodesList_Deleted()
{
var initArray = new[] { 35, 99 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[0], doublyLinkedList.DelStart());
}
public void DeleteStartNode_InitializedList_Deleted()
{
var initArray = new[] { 1, 7, 48, 33, 55 };
var doublyLinkedList = new EList();
doublyLinkedList.Init(initArray);
Assert.Equal(initArray[0], doublyLinkedList.DelStart());
}
public void MinValueNode_TwoNodesList_Value()
{
var doublyLinkedList = new EList();
int[] initArray = new[] { 551, -11 };
doublyLinkedList.Init(initArray);
Assert.Equal(initArray.Min(), doublyLinkedList.Min());
}
/// <summary>
/// 历史文书的文件夹集合
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="ParentType"></param>
/// <param name="ChildType"></param>
/// <param name="Year"></param>
/// <param name="Month"></param>
/// <returns></returns>
internal EList<InstrumentsHistoryFolder> InstrumentsHistoryFolderGetAll(int page, int pageSize, int ParentType, int ChildType, int Year, int Month)
{
EList<InstrumentsHistoryFolder> InstrumentsHistoryFolders = new EList<InstrumentsHistoryFolder>();
List<WhereClip> Clips = new List<WhereClip>();
if (ParentType >= (int)SOA.ORM.InstrumentsExample.EInstrumentsType.现场检查)
{
Clips.Add(DataBases.InstrumentsHistoryFolder.InstrumentsParentType == ParentType);
}
if (ChildType >= (int)SOA.ORM.InstrumentsExample.ESiteInspectionType.现场检查记录)
{
Clips.Add(DataBases.InstrumentsHistoryFolder.InstrumentsChildType == ChildType);
}
if (Year >= -1)
{
Clips.Add(DataBases.InstrumentsHistoryFolder.InstrumentsYear == Year);
}
if (Month >= -1)
{
Clips.Add(DataBases.InstrumentsHistoryFolder.InstrumentsMonth == Month);
}
SelectSqlSection section = DB.Select(DataBases.InstrumentsHistoryFolder, DataBases.InstrumentsHistoryFolder.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
InstrumentsHistoryFolders.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.InstrumentsHistoryFolder);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.InstrumentsHistoryFolder.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
InstrumentsHistoryFolder InstrumentsHistoryFolder = ReadRow(reader);
InstrumentsHistoryFolders.Items.Add(InstrumentsHistoryFolder);
}
}
}
return InstrumentsHistoryFolders;
}
/// <summary>
/// 获取公司信息集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="name">单位名称</param>
/// <returns>实体集合</returns>
internal EList<Company> CompanyGetAll(int page, int pageSize,string name,int CompanyType)
{
EList<Company> Companys = new EList<Company>();
List<WhereClip> Clips = new List<WhereClip>();
if (name != "")
{
Clips.Add(DataBases.Company.CompanyName.Like("%" + name + "%"));
}
if (CompanyType != 0)
{
Clips.Add(DataBases.Company.CompanyType == CompanyType);
}
SelectSqlSection section = DB.Select(DataBases.Company, DataBases.Company.CompanyID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
Companys.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.Company);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.Company.CompanyID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
Company areaCode = ReadRow(reader);
if (reader["CompanyType"].ToString() == "-1")
{
areaCode.CompanyTypeName = "无";
}
else
{
areaCode.CompanyTypeName = ((Company.ECompanyType)Convert.ToInt32(reader["CompanyType"])).ToString();
}
Companys.Items.Add(areaCode);
}
}
}
return Companys;
}
/// <summary>
/// 历史文书文件集合
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="Title">标题</param>
/// <param name="CompanyName">当事人</param>
/// <param name="TabelName">所属表名</param>
/// <param name="TableID">所属表中的ID</param>
/// <returns></returns>
internal EList<InstrumentsHistoryFile> InstrumentsHistoryFileGetAll(int page, int pageSize, string Title,string CompanyName,string TabelName,int TableID)
{
EList<InstrumentsHistoryFile> InstrumentsHistoryFiles = new EList<InstrumentsHistoryFile>();
List<WhereClip> Clips = new List<WhereClip>();
if (Title != "")
{
Clips.Add(DataBases.InstrumentsHistoryFile.InstrumentsTitle.Like("%" + Title + "%"));
}
if (CompanyName != "")
{
Clips.Add(DataBases.InstrumentsHistoryFile.CompanyName.Like("%" + CompanyName + "%"));
}
if (TabelName != "")
{
Clips.Add(DataBases.InstrumentsHistoryFile.TableName == TableName);
}
if (TableID >= 0)
{
Clips.Add(DataBases.InstrumentsHistoryFile.TableID == TableID);
}
SelectSqlSection section = DB.Select(DataBases.InstrumentsHistoryFile, DataBases.InstrumentsHistoryFile.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
InstrumentsHistoryFiles.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.InstrumentsHistoryFile);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.InstrumentsHistoryFile.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
InstrumentsHistoryFile InstrumentsHistoryFile = ReadRow(reader);
InstrumentsHistoryFiles.Items.Add(InstrumentsHistoryFile);
}
}
}
return InstrumentsHistoryFiles;
}
internal EList<ArchiveExtEntity> ArchiveExtGetAll(int archiveID)
{
EList<ArchiveExtEntity> archiveExts = new EList<ArchiveExtEntity>();
List<WhereClip> clips = new List<WhereClip>();
clips.Add(DataBases.ArchiveExt.ArchiveID == archiveID);
SelectSqlSection section = DB.Select(DataBases.ArchiveExt);
section.Where(clips);
section.OrderBy(new OrderByClip(new ExpressionClip("createtime", DbType.DateTime), true));
using (IDataReader reader = section.ToDataReader()) {
while (reader.Read()) {
ArchiveExtEntity entity = ReadRow(reader);
entity.CreateTime = (DateTime)reader["CreateTime"];
archiveExts.Items.Add(entity);
}
}
return archiveExts;
}
/// <summary>
/// 地区集合
/// </summary>
/// <returns>实体集合</returns>
internal EList<CompanyArea> CompanyAreaGetAll()
{
EList<CompanyArea> CompanyAreas = new EList<CompanyArea> { };
SelectSqlSection section = DB.Select(DataBases.CompanyArea, DataBases.CompanyArea.ID.Count());
int count = Convert.ToInt32(section.ToScalar());
if (count > 0)
{
section = DB.Select(DataBases.CompanyArea);
//section.SetSelectRange(1, 100, DataBases.CompanyArea.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
CompanyArea area = ReadRow(reader);
CompanyAreas.Items.Add(area);
}
}
}
return CompanyAreas;
}
/// <summary>
/// 剧毒化学品目录
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="ChemicalName">化学名</param>
/// <param name="ChemicalAlias">别名</param>
/// <returns></returns>
internal EList<ChemicalsHighlyToxic> ChemicalsHighlyToxicGetAll(int page, int pageSize, string ChemicalName, string ChemicalAlias)
{
EList<ChemicalsHighlyToxic> ChemicalsHighlyToxics = new EList<ChemicalsHighlyToxic>();
List<WhereClip> Clips = new List<WhereClip>();
if (ChemicalName != "")
{
Clips.Add(DataBases.ChemicalsHighlyToxic.ChemicalName.Like("%" + ChemicalName + "%"));
}
if (ChemicalAlias != "")
{
Clips.Add(DataBases.ChemicalsHighlyToxic.ChemicalAlias.Like("%" + ChemicalAlias + "%"));
}
SelectSqlSection section = DB.Select(DataBases.ChemicalsHighlyToxic, DataBases.ChemicalsHighlyToxic.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
ChemicalsHighlyToxics.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.ChemicalsHighlyToxic);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.ChemicalsHighlyToxic.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
ChemicalsHighlyToxic ChemicalsHighlyToxic = ReadRow(reader);
ChemicalsHighlyToxics.Items.Add(ChemicalsHighlyToxic);
}
}
}
return ChemicalsHighlyToxics;
}
/// <summary>
/// 获取权力清单集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="Name">权力名称</param>
/// <param name="PowerType">权力类型</param>
/// <returns>实体集合</returns>
internal EList<PowerInventory> PowerGetAll(int page, int pageSize, string Name, int PowerType)
{
EList<PowerInventory> Powers = new EList<PowerInventory>();
List<WhereClip> Clips = new List<WhereClip>();
if (Name != "")
{
Clips.Add(DataBases.PowerInventory.PowerName.Like("%" + Name + "%"));
}
if (PowerType != -1)
{
Clips.Add(DataBases.PowerInventory.PowerType == PowerType);
}
SelectSqlSection section = DB.Select(DataBases.PowerInventory, DataBases.PowerInventory.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
Powers.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.PowerInventory);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.PowerInventory.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
PowerInventory areaCode = ReadRow(reader);
Powers.Items.Add(areaCode);
}
}
}
return Powers;
}
/// <summary>
/// 法律法规
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="beginDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <returns>实体集合</returns>
internal EList<LawFile> LawFileGetAll(int page, int pageSize, string LawFileTitle,int LawType)
{
EList<LawFile> LawFiles = new EList<LawFile>();
List<WhereClip> Clips = new List<WhereClip>();
if (LawFileTitle != "")
{
Clips.Add(DataBases.LawFile.LawTitle.Like("%" + LawFileTitle + "%"));
}
if (LawType >= (int)SOA.ORM.LawFile.ELawType.综合)
{
Clips.Add(DataBases.LawFile.LawType == LawType);
}
SelectSqlSection section = DB.Select(DataBases.LawFile, DataBases.LawFile.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
LawFiles.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.LawFile);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.LawFile.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
LawFile LawFile = ReadRow(reader);
LawFiles.Items.Add(LawFile);
}
}
}
return LawFiles;
}
internal EList<Archive> ArchiveGetAll()
{
EList<Archive> archives = new EList<Archive>();
SelectSqlSection section = DB.Select(DataBases.Archive);
section.OrderBy(new OrderByClip(new ExpressionClip("CreateTimes", DbType.DateTime), true));
using (IDataReader reader = section.ToDataReader()) {
while (reader.Read()) {
Archive entity = ReadRow(reader);
entity.CreateTimes = (DateTime)reader["CreateTimes"];
entity.Status = (Byte)reader["Status"];
archives.Items.Add(entity);
}
}
// 获取所有顶级目录
// SELECT * FROM archive WHERE parent = 0;
// 根据顶级ID获取子集
// SELECT * FROM archive WHERE parent = [PARENT_ID];
return archives;
}
/// <summary>
/// 获取鉴定委托书集合
/// </summary>
/// <param name="page">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="DocTitle">文号</param>
/// <param name="PutOnRecordCaseName">案件名称</param>
/// <returns>实体集合</returns>
internal EList<InCaseOfTable> InCaseOfTableGetAll(int page, int pageSize, string DocTitle, string PutOnRecordCaseName)
{
EList<InCaseOfTable> InCaseOfTables = new EList<InCaseOfTable>();
List<WhereClip> Clips = new List<WhereClip>();
if (DocTitle != "")
Clips.Add(DataBases.InCaseOfTable.DocTitle.Like("%" + DocTitle + "%"));
if (PutOnRecordCaseName != "")
Clips.Add(DataBases.InCaseOfTable.PutOnRecordCaseName.Like("%" + PutOnRecordCaseName + "%"));
Clips.Add(DataBases.InCaseOfTable.Status < 2);
SelectSqlSection section = DB.Select(DataBases.InCaseOfTable, DataBases.InCaseOfTable.ID.Count());
if (Clips.Count > 0)
section.Where(Clips);
int count = Convert.ToInt32(section.ToScalar());
InCaseOfTables.TotalCount = count;
if (count > 0)
{
section = DB.Select(DataBases.InCaseOfTable);
if (Clips.Count > 0)
section.Where(Clips);
section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.InCaseOfTable.ID);
using (IDataReader reader = section.ToDataReader())
{
while (reader.Read())
{
InCaseOfTable inCaseOfTable = ReadRow(reader);
InCaseOfTables.Items.Add(inCaseOfTable);
}
}
}
return InCaseOfTables;
}
