public virtual CriminalDetailDomain CreateCriminalDetailDomain()
{
CriminalDetailEntity entity = new CriminalDetailEntity();
entity.CriminalDetailId = Guid.NewGuid().ToString();
return new CriminalDetailDomain(entity);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!this.fudCriminal.HasFile)
{
base.AlertMessage("Please select file.");
this.fudCriminal.Focus();
return;
}
BPSC.Common.ExcelTemplate excelTemplate = new BPSC.Common.ExcelTemplate("Criminal_Template.xls");
bool isValid = true;
DataTable dt = excelTemplate.GetDataFromExcel(fudCriminal, out isValid);
if (!isValid)
{
AlertMessage("The format of criminal file is error. Please check it, try again later.");
return;
}
#region 验证所有数据的格式正确性
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j][1].ToString().Trim() == "")
{
AlertMessage("Data empty, 'Action NO.'.");
this.fudCriminal.Focus();
return;
}
if (!CheckActionNOIsExist(dt.Rows[j][1].ToString().Trim()))
{
AlertMessage("'Action NO.' doesn't exist ");
this.fudCriminal.Focus();
return;
}
try
{
Convert.ToDateTime(dt.Rows[j][8]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Raid Date'.");
this.fudCriminal.Focus();
return;
}
#region 模板更新
//模板更新，取消Length Of Sentence probation、Length Of Sentence imprisonment、Punished with Criminal Fine、Confiscate illegal gains，新增Result
//try
//{
// Convert.ToInt32(dt.Rows[j][17]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Length Of Sentence probation'.");
// this.fudCriminal.Focus();
// return;
//}
//try
//{
// Convert.ToInt32(dt.Rows[j][18]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Length Of Sentence imprisonment'.");
// this.fudCriminal.Focus();
// return;
//}
//try
//{
// Convert.ToDouble(dt.Rows[j][19]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Punished with Criminal Fine'.");
// this.fudCriminal.Focus();
// return;
//}
//try
//{
// Convert.ToDouble(dt.Rows[j][20]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Confiscate illegal gains'.");
// this.fudCriminal.Focus();
// return;
//}
#endregion
try
{
Convert.ToDateTime(dt.Rows[j][18]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Conviction Date'.");
this.fudCriminal.Focus();
return;
}
try
{
Convert.ToDateTime(dt.Rows[j][22]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Criminal Date'.");
this.fudCriminal.Focus();
return;
}
try
{
Convert.ToDateTime(dt.Rows[j][23]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Report Received Date'.");
this.fudCriminal.Focus();
return;
}
}
#endregion
CriminalDetailEntity criminalDetailEntity = null;
List<CriminalDetailEntity> lstCriminalDetailEntity = new List<CriminalDetailEntity>();
#region Insert Data
for (int i = 0; i < dt.Rows.Count; i++)
{
criminalDetailEntity = new CriminalDetailEntity();
criminalDetailEntity.CriminalDetailId = Guid.NewGuid().ToString();
criminalDetailEntity.ActionNo = dt.Rows[i][1].ToString();
criminalDetailEntity.Sequence = dt.Rows[i][0].ToString();
criminalDetailEntity.Province = dt.Rows[i][2].ToString();
criminalDetailEntity.City = dt.Rows[i][3].ToString();
criminalDetailEntity.WholesalerManufacturer = dt.Rows[i][4].ToString();
criminalDetailEntity.PngBrand = dt.Rows[i][5].ToString();
criminalDetailEntity.OtherBrand = dt.Rows[i][6].ToString();
criminalDetailEntity.Defendant = dt.Rows[i][7].ToString();
criminalDetailEntity.RaidDate = Convert.ToDateTime(dt.Rows[i][8]);
criminalDetailEntity.Seizure = dt.Rows[i][9].ToString();
criminalDetailEntity.EstimatedValueUsd = dt.Rows[i][10].ToString();
criminalDetailEntity.PsbUnit = dt.Rows[i][11].ToString();
criminalDetailEntity.PpUnit = dt.Rows[i][12].ToString();
criminalDetailEntity.CourtUnit = dt.Rows[i][13].ToString();
criminalDetailEntity.BasisOfConviction = dt.Rows[i][14].ToString();
criminalDetailEntity.LawFirm = dt.Rows[i][15].ToString();
criminalDetailEntity.FirmNameAndDate = dt.Rows[i][16].ToString();
#region 模板更新， 一下index重排
//模板更新，取消Length Of Sentence probation、Length Of Sentence imprisonment、Punished with Criminal Fine、Confiscate illegal gains，新增Result
//criminalDetailEntity.Lengthofsentenceprobation = Convert.ToInt32(dt.Rows[i][17]);
//criminalDetailEntity.Lengthofsentenceofimprisonment = Convert.ToInt32(dt.Rows[i][18]);
//criminalDetailEntity.Punishedwidthcriminalfine = Convert.ToDecimal(dt.Rows[i][19]);
//criminalDetailEntity.ConfiscateIllegalGains = Convert.ToDecimal(dt.Rows[i][20]);
#endregion
criminalDetailEntity.Result = dt.Rows[i][17].ToString();
criminalDetailEntity.ConvictionDate = Convert.ToDateTime(dt.Rows[i][18]);
criminalDetailEntity.AllAssistingUnits = dt.Rows[i][19].ToString();
criminalDetailEntity.KeyPoints = dt.Rows[i][20].ToString();
criminalDetailEntity.Document = dt.Rows[i][21].ToString();
criminalDetailEntity.CreateDate = DateTime.Now;
criminalDetailEntity.CreateUser = base.CurrentUser.SecUserEntity.UserId;
//新增Criminal Date列
criminalDetailEntity.CriminalDate = Convert.ToDateTime(dt.Rows[i][22]);
//新增Report Received Date列
criminalDetailEntity.Reportreceivedday = Convert.ToDateTime(dt.Rows[i][23]);
lstCriminalDetailEntity.Add(criminalDetailEntity);
}
#endregion
int total_success_import = 0;
int total_valid_product = lstCriminalDetailEntity.Count;
foreach (CriminalDetailEntity entity in lstCriminalDetailEntity)
{
if (MainService.CriminalDetailBLLService.InsertCriminalRaid(entity, ddlAgency.SelectedItem.Text, ddlAgency.SelectedValue.Trim(), true,ddlUser.SelectedItem.Text,ddlUser.SelectedValue.Trim()))
total_success_import += 1;
}
if (total_success_import > 0)
{
base.AlertMessage(total_success_import.ToString() + " criminals is valid, and import successfully!");
}
else
{
base.AlertMessage("All criminals is invalid. Please check, try it later.");
}
}
public virtual void UpdateCriminalDetailEntity(CriminalDetailEntity entity, DataAccessBroker broker)
{
DataAccess.Update(entity, broker);
}
public virtual void InsertCriminalDetailEntity(CriminalDetailEntity entity, DataAccessBroker broker)
{
DataAccess.Insert(entity, broker);
}
public virtual bool IsCriminalDetailExist(string actionNo)
{
WhereBuilder wb = WhereBuilder.SelectAll(CriminalDetailTable.Current.TableName);
CriminalDetailEntity criminalDetailEntity = new CriminalDetailEntity();
if (!string.IsNullOrEmpty(actionNo))
{
criminalDetailEntity.ActionNo = actionNo;
}
EntityCollection<CriminalDetailEntity> criminalDetailEntityList = DataAccess.Select<CriminalDetailEntity>(criminalDetailEntity);
if (criminalDetailEntityList != null && criminalDetailEntityList.Count > 0)
{
return true;
}
return false;
}
public bool InsertCriminalRaid(CriminalDetailEntity criminalEntity, string agency,string agencyID, bool isInsert,string userName,string userID)
{
Suzsoft.Smart.EntityCore.DataAccessParameterCollection dpc1 = new Suzsoft.Smart.EntityCore.DataAccessParameterCollection();
dpc1.AddWithValue("@actionNO", criminalEntity.ActionNo);
dpc1.AddWithValue("@agency", agency);
dpc1.AddWithValue("@AgencyID", agencyID);
dpc1.AddWithValue("@User_ID", userID);
dpc1.AddWithValue("@User_Name", userName);
string strOtherSql = @" INSERT INTO Criminal (Action_NO,Agency,Conviction_Report_Upload_Date,Agency_ID,User_ID,User_Name) values (@actionNO,@agency,'" + DateTime.Now + "',@AgencyID,@User_ID,@User_Name)";
using (DataAccessBroker objBroker = DataAccessFactory.Instance())
{
try
{
objBroker.BeginTransaction();
WhereBuilder wb = WhereBuilder.SelectAll(CriminalTable.Current.TableName);
wb.AddAndCondition(CriminalTable.C_Action_NO, criminalEntity.ActionNo);
//wb.AddAndCondition(CriminalTable.C_Agency, agency); //原系统逻辑
bool flag = DataAccess.Select<CriminalEntity>(wb).Count > 0;
if (!flag)
{
objBroker.ExecuteSQL(strOtherSql, dpc1);
}
if (isInsert)
{
DataAccess.Insert(criminalEntity, objBroker);
//Insert(criminalEntity, objBroker);
}
else
{
DataAccess.Update(criminalEntity, objBroker);
}
objBroker.Commit();
return true;
}
catch (Exception ex)
{
//WhereBuilder wb = WhereBuilder.SelectAll(CriminalTable.Current.TableName);
//wb.AddAndCondition(CriminalTable.C_Action_NO, criminalEntity.ActionNO);
//wb.AddAndCondition(CriminalTable.C_Agency, agency);
//bool flag = DataAccess.Select<CriminalEntity>(wb).Count > 0;
//if (flag)
//{
// CriminalEntity criminalDelEntity = new CriminalEntity();
// criminalDelEntity.ActionNO = criminalEntity.ActionNO;
// DataAccess.Delete(criminalDelEntity);
//}
objBroker.RollBack();
return false;
}
}
}
public CriminalDetailDomain(CriminalDetailEntity entity)
: base(entity)
{
masterEntity = entity;
}