protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.IsValid)
{
IBasicService service = ServiceFactory.GetService<IBasicService>();
BasicOrganization entity = null;
if (this.IsInsert)
{
entity = new BasicOrganization()
{
OrgNumber = this.txtOrgNumber.Text.Trim(),
OrgName = this.txtOrgName.Text.Trim(),
OrgAddress = this.txtOrgAddress.Text.Trim(),
OrgParentId = this.hfOrgParentId.Value.Trim().ToInt(0),
OrgFullPath = ""
};
if (service.CheckExists_Organization(entity))
{
this.JscriptMsg("网点机构号码已存在", null, "Error");
return;
}
}
else
{
entity = service.GetObject_Organization(this.PkId);
if (entity != null)
{
entity.OrgName = this.txtOrgName.Text.Trim();
entity.OrgAddress = this.txtOrgAddress.Text.Trim();
entity.OrgParentId = this.hfOrgParentId.Value.Trim().ToInt(0);
}
}
service.Save_Organization(entity);
if (this.IsInsert)
{
entity.OrgFullPath = entity.OrgParentId.ToString().GetOrgFullPath() + "[" + entity.PkId + "]";
service.Save_Organization(entity);
}
if (this.IsInsert && (sender as Button).CommandName == "SubmitContinue")
{
this.ReturnUrl = this.Request.Url.AbsolutePath;
}
this.JscriptMsg("数据保存成功", this.ReturnUrl, "Success");
}
BasicConvert.ClearCache();
}
public bool CheckExists(BasicOrganization objBasicOrganization)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
sql = " select count(1) from tbl_basic_organization where OrgNumber=:OrgNumber ";
parameterList.Add(new OracleParameter(":OrgNumber", objBasicOrganization.OrgNumber));
return int.Parse(DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString()) > 0;
}
public bool CheckExists_Organization(BasicOrganization objBasicOrganization)
{
var repository = ServiceFactory.GetService<IBasicOrganizationRepository>();
return repository.CheckExists(objBasicOrganization);
}
public void Save_Organization(BasicOrganization objBasicOrganization)
{
var repository = ServiceFactory.GetService<IBasicOrganizationRepository>();
repository.Save(objBasicOrganization);
}
public void Save(BasicOrganization objBasicOrganization)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objBasicOrganization.PkId == 0)
{
sql = " insert into tbl_basic_organization(PkId, OrgNumber, OrgName, OrgAddress, OrgParentId, OrgFullPath) " +
" values(TBO_PKID.NEXTVAL, :OrgNumber, :OrgName, :OrgAddress, :OrgParentId, :OrgFullPath) " +
" RETURNING PkId INTO :PkId ";
parameterList.Add(new OracleParameter(":OrgNumber", objBasicOrganization.OrgNumber));
parameterList.Add(new OracleParameter(":OrgName", objBasicOrganization.OrgName));
parameterList.Add(new OracleParameter(":OrgAddress", objBasicOrganization.OrgAddress));
parameterList.Add(new OracleParameter(":OrgParentId", objBasicOrganization.OrgParentId));
parameterList.Add(new OracleParameter(":OrgFullPath", objBasicOrganization.OrgFullPath));
var p = new OracleParameter(":PkId", OracleDbType.Int32, 0, ParameterDirection.Output);
parameterList.Add(p);
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
objBasicOrganization.PkId = Convert.ToInt32(((OracleDecimal)p.Value).Value);
}
else
{
sql = " update tbl_basic_organization set OrgName=:OrgName, OrgAddress=:OrgAddress, OrgFullPath=:OrgFullPath where PkId=:PkId ";
parameterList.Add(new OracleParameter(":OrgName", objBasicOrganization.OrgName));
parameterList.Add(new OracleParameter(":OrgAddress", objBasicOrganization.OrgAddress));
parameterList.Add(new OracleParameter(":OrgFullPath", objBasicOrganization.OrgFullPath));
parameterList.Add(new OracleParameter(":PkId", objBasicOrganization.PkId));
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
}
private void InitData()
{
IBasicService basicService = ServiceFactory.GetService<IBasicService>();
IDeviceService deviceService = ServiceFactory.GetService<IDeviceService>();
int orgCount = this.txtOrgCount.Text.Trim().ToInt();
int relevanceDeviceCount = this.txtRelevanceDeviceCount.Text.Trim().ToInt();
int deviceGroup = this.txtDeviceGroup.Text.Trim().ToInt();
int perGroupOrgCount = orgCount / deviceGroup;
this.BeginInvoke(new EventHandler((a, b) =>
{
this.pbFinish.Minimum = 0;
this.pbFinish.Maximum = orgCount * relevanceDeviceCount;
this.pbFinish.Value = 0;
})).AsyncWaitHandle.WaitOne(10);
for (int i = 1; i <= deviceGroup; i++)
{
int deviceIndex = 0;
for (int j = 1; j <= perGroupOrgCount; j++)
{
int orgId = (i - 1) * perGroupOrgCount + j;
BasicOrganization org = new BasicOrganization()
{
OrgNumber = "ORG" + orgId.ToString().PadLeft(4, '0'),
OrgName = "网点机构" + orgId.ToString().PadLeft(4, '0'),
OrgAddress = "网点机构" + orgId.ToString().PadLeft(4, '0'),
OrgParentId = 0
};
basicService.Save_Organization(org);
org.OrgFullPath = org.OrgParentId.ToString().GetOrgFullPath() + "[" + org.PkId + "]";
basicService.Save_Organization(org);
for (int k = 1; k <= relevanceDeviceCount; k++)
{
deviceIndex += 1;
string deviceNumber = "ABCD" + (int.Parse(i + "00000000") + deviceIndex).ToString();
DeviceInfo device = new DeviceInfo()
{
DeviceNumber = deviceNumber,
SoftwareVersion = "000000",
RegisterIp = "127.0.0.1",
KindCode = 1,
ModelCode = 1,
OrgId = org.PkId,
OnLineTime = DateTime.Now,
DeviceStatus = 1
};
deviceService.Save_Info(device);
this.BeginInvoke(new EventHandler((a, b) => { this.pbFinish.PerformStep(); }));
}
}
}
this.BeginInvoke(new EventHandler((a, b) => { this.btnInit.Enabled = true; }));
MessageBox.Show("数据初始化完毕", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void Save(BasicOrganization objBasicOrganization)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objBasicOrganization.PkId == 0)
{
sql = " insert into tbl_basic_organization(OrgNumber, OrgName, OrgAddress, OrgParentId, OrgFullPath) " +
" values(@OrgNumber, @OrgName, @OrgAddress, @OrgParentId, @OrgFullPath); " +
" select LAST_INSERT_ID(); ";
parameterList.Add(new MySqlParameter("@OrgNumber", objBasicOrganization.OrgNumber));
parameterList.Add(new MySqlParameter("@OrgName", objBasicOrganization.OrgName));
parameterList.Add(new MySqlParameter("@OrgAddress", objBasicOrganization.OrgAddress));
parameterList.Add(new MySqlParameter("@OrgParentId", objBasicOrganization.OrgParentId));
parameterList.Add(new MySqlParameter("@OrgFullPath", objBasicOrganization.OrgFullPath));
objBasicOrganization.PkId = DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString().ToInt();
}
else
{
sql = " update tbl_basic_organization set OrgName=@OrgName, OrgAddress=@OrgAddress, OrgFullPath=@OrgFullPath where PkId=@PkId ";
parameterList.Add(new MySqlParameter("@PkId", objBasicOrganization.PkId));
parameterList.Add(new MySqlParameter("@OrgName", objBasicOrganization.OrgName));
parameterList.Add(new MySqlParameter("@OrgAddress", objBasicOrganization.OrgAddress));
parameterList.Add(new MySqlParameter("@OrgFullPath", objBasicOrganization.OrgFullPath));
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
}