private CacheManager()
{
EquipmentDAO equipmentDAO = DataManager.getEquipmentDAO();
HelpDAO helpDAO = DataManager.getHelpDAO();
StandardUnitMeasurementDAO sumDAO = DataManager.getStandardUnitMeasurementDAO();
SignalDAO signalDAO = DataManager.getSignalDAO();
LookupTablesDAO lookupTablesDAO = DataManager.getLookupTablesDAO();
loadCacheItem <dbConnector>(equipmentDAO, LuConnectorBean._TABLE_NAME,
"getConnectors", LuConnectorBean._CONNECTOR_TYPE);
loadCacheItem <LuNamespaceBean>(lookupTablesDAO, LuNamespaceBean._TABLE_NAME,
"getNamespaceLookup", LuNamespaceBean._XMLNS);
loadCacheItem <HelpMessageBean>(helpDAO, HelpMessageBean._TABLE_NAME,
"getHelpMessages", HelpMessageBean._MESSAGE_KEY);
loadCacheItem <StandardUnitMeasurementBean>(sumDAO, StandardUnitMeasurementBean._TABLE_NAME,
"getLimitsActiveStandardUnitMeasurementBeans", StandardUnitMeasurementBean._ID);
loadCacheItem <StandardUnitPrefixBean>(sumDAO, StandardUnitPrefixBean._TABLE_NAME,
"getAllStandardUnitPrefixBeans", StandardUnitPrefixBean._ID);
loadCacheItem <dbSignal>(signalDAO, SignalMasterBean._TABLE_NAME,
"getAllSignals", SignalMasterBean._SIGNAL_ID);
loadCacheItem <dbSignal>(signalDAO, TestSignalLibraryBean._TABLE_NAME,
"GetAllTsfSignals", SignalMasterBean._SIGNAL_ID);
loadCacheItem <dbCountry>(lookupTablesDAO, LuCountryBean._TABLE_NAME,
"getActiveCountries", LuCountryBean._COUNTRY_CODE);
loadCacheItem <DocumentType>(lookupTablesDAO, LuDocumentTypeBean._TABLE_NAME,
"getDocumentTypes", LuDocumentTypeBean._TYPE_ID);
}
/// <summary>
/// 비품 수정
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnModification_Click(object sender, EventArgs e)
{
DialogResult mbResult = MessageBox.Show("정말로 수정하시겠습니까? 수정기록은 남지 않습니다.", "비품수정", MessageBoxButtons.YesNo);
if (mbResult == DialogResult.Yes)
{
if (tempEquipment.DetailName != txtDetailName.Text || tempEquipment.Location != txtLocation.Text || tempEquipment.PurchasePrice != float.Parse(txtPrice.Text) || tempEquipment.PurchaseDate != dtpPurchaseDate.Value.Date || tempEquipment.Note != txtNote.Text ||
tempEquipment.State != cbState.Text)
{
EquipmentDAO dAO = new EquipmentDAO();
tempEquipment.DetailName = txtDetailName.Text;
tempEquipment.Location = txtLocation.Text;
tempEquipment.PurchasePrice = float.Parse(txtPrice.Text);
tempEquipment.PurchaseDate = dtpPurchaseDate.Value.Date;
tempEquipment.Note = txtNote.Text;
tempEquipment.State = cbState.Text;
if (dAO.UpdateEquipment(tempEquipment))
{
MessageBox.Show("성공적으로 업데이트 했습니다.");
}
else
{
MessageBox.Show("업데이트에 실패했습니다.");
}
}
}
btnSearch_Click(null, null);
}
/// <summary>
/// DB로 저장
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
if (txtDetailName.Text == "")
{
MessageBox.Show("품목명을 입력해주세요");
return;
}
EquipmentVO equipmentVO = new EquipmentVO()
{
DetailName = txtDetailName.Text,
Location = txtLocation.Text,
PurchasePrice = float.Parse(txtPrice.Text.Replace(",", "")),
PurchaseDate = dtpPurchaseDate.Value.Date,
Note = txtNote.Text
};
EquipmentDAO dAO = new EquipmentDAO();
try
{
DialogResult resurt = MessageBox.Show("저장하시겠습니까?", "비품저장", MessageBoxButtons.YesNo);
if (resurt == DialogResult.Yes)
{
if (dAO.InsertEquipment(equipmentVO))
{
MessageBox.Show("성공적으로 저장되었습니다");
}
}
}
catch (Exception ex)
{
MessageBox.Show("저장실패" + ex.Message);
}
}
List <EquipmentVO> tempEquipmentLst = new List <EquipmentVO>(); //페이지당 담을 데이터
private void UcEquipment_Load(object sender, EventArgs e)
{
EquipmentDAO dAO = new EquipmentDAO();
dgvEquipmentList.AllowUserToAddRows = false;
chbDate.CheckState = CheckState.Unchecked;
dgvEquipmentList.DataSource = SetDataTable(dAO.AllequipmentVOsList());
Paging();
}
private void FrmEquipment_Load(object sender, EventArgs e)
{
UcEquipment ucEquipment = new UcEquipment();
ucEquipment.Location = new Point(0, 0);
this.Controls.Add(ucEquipment);
this.WindowState = FormWindowState.Maximized;
EquipmentDAO dAO = new EquipmentDAO();
}
private DataManager()
{
equpmentDAO = new EquipmentDAO();
signalDAO = new SignalDAO();
helpDAO = new HelpDAO();
standardUnitMeasurementDAO = new StandardUnitMeasurementDAO();
lookupTablesDAO = new LookupTablesDAO();
documentDAO = new DocumentDAO();
schemaDAO = new SchemaDAO();
}
public IHttpActionResult Delete([FromUri] int id)
{
var rs = new EquipmentDAO().DeleteEquiptment(id);
if (rs)
{
return(Ok());
}
return(Conflict());
}
public override void save()
{
base.save();
EquipmentDAO dao = new EquipmentDAO();
dao.deleteConnectorPins(ID);
foreach (dbConnectorPin pin in pins)
{
pin.IncludeKeyOnInsert = true;
pin.DataState = eDataState.DS_ADD;
pin.save();
}
}
private void SaveCapabilities(IAtmlObject atmlObject, Capabilities capabilities)
{
var dao = new EquipmentDAO();
dao.ClearEquipmentCapabilities(Guid.Parse(atmlObject.GetAtmlId()));
if (!atmlObject.IsDeleted() && capabilities != null && capabilities.Items != null)
{
foreach (object item in capabilities.Items)
{
var capability = item as Capability;
if (capability != null)
{
Save(atmlObject, capability);
}
}
}
}
public IHttpActionResult CheckQuantityAvailble(int id, int quantity)
{
string messError = "";
bool rs = new EquipmentDAO().isAvailbleQuantity(id, quantity);
Equipment e = new EquipmentDAO().GetEquipmentById(id);
if (e != null)
{
messError = " Only " + e.Quantity + " items left in stock!";
}
if (rs)
{
return(Ok());
}
return(Content(HttpStatusCode.Conflict, messError));
}
private dbConnector PromptForNewConnector(String type, ComboBox cbPrimary, ComboBox cbSecondary)
{
dbConnector conn = null;
if (type != null && cbPrimary.SelectedIndex == -1)
{
var dao = new EquipmentDAO();
conn = dao.getConnector(type);
if (conn == null)
{
if (DialogResult.Yes ==
MessageBox.Show(
string.Format(
"Connector type \"{0}\" does not exist in the Connector Database, would you like to add it?",
type),
@"Add Connector",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question))
{
conn = new dbConnector();
conn.DataState = BASEBean.eDataState.DS_ADD;
conn.connectorType = type;
conn.ID = Guid.NewGuid();
conn.IncludeKeyOnInsert = true;
conn.pinCount = string.IsNullOrWhiteSpace(edtConnectorPinCount.Text)
? 0
: int.Parse(edtConnectorPinCount.Text);
conn.save();
}
}
if (conn != null)
{
cbPrimary.SelectedIndex = cbPrimary.Items.Add(conn);
cbSecondary.Items.Add(conn);
}
}
else
{
conn = cbPrimary.SelectedItem as dbConnector;
}
return(conn);
}
/// <summary>
/// 선택된 데이터 삭제
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
if (tempEquipment is null)
{
return;
}
EquipmentDAO dAO = new EquipmentDAO();
DialogResult mbResult = MessageBox.Show("정말로 삭제하시겠습니까? 삭제하면 기록에 남지 않습니다.", "비품삭제", MessageBoxButtons.YesNo);
if (mbResult == DialogResult.Yes)
{
try
{
dAO.DeleteEquipment(tempEquipment);
}
catch (Exception)
{
MessageBox.Show("삭제하는데 실패 하였습니다", "삭제 실패", MessageBoxButtons.OK);
}
}
btnSearch_Click(null, null);
}
private void ConnectorConfigurationForm_Saved(object sender, EventArgs e)
{
bool added = false;
Guid? uuid = _connector.ID;
EquipmentDAO dao = new EquipmentDAO();
_configuration = dao.getConnectorConfiguration(uuid, edtConfigurationName.Text);
if (_configuration == null)
{
_configuration = new dbConnectorConfiguration();
_configuration.ID = Guid.NewGuid();
_configuration.connectorId = uuid;
_configuration.configName = edtConfigurationName.Text;
_configuration.DataState = BASEBean.eDataState.DS_ADD;
_configuration.IncludeKeyOnInsert = true;
added = true;
}
Configuration.Pins.Clear();
int i = 1;
if (_pins != null)
{
foreach (ConnectorPin connectorPin in _pins)
{
dbConnectorPin pin = new dbConnectorPin();
pin.configId = _configuration.ID;
pin.pinIdx = i++;
pin.pinName = connectorPin.name;
if (connectorPin.Definition != null)
{
pin.pinDescription = connectorPin.Definition.Description;
}
Configuration.Pins.Add(pin);
}
}
Configuration.save();
LogManager.Info("Connector Pin Configuration \"{0}\" has been {1}", _configuration.configName, added ? "Added" : "Saved");
}
public NewCheckoutCreator()
{
_equipmentDAO = new EquipmentDAO();
}
public EquipmentsService()
{
lObjEquipmentDAO = new EquipmentDAO();
}
public static void Save(IAtmlObject atmlObject, Capability capability)
{
string id = atmlObject.GetAtmlId();
var dao = new EquipmentDAO();
if (capability.SignalDescription != null)
{
List <Signal> signals = SignalManager.ExtractSignalsFromExtension(capability.SignalDescription);
foreach (Signal signal in signals)
{
string signalName = signal.name;
string signalNameSpace = signal.GetSignalNameSpace();
string capabilityName = capability.name;
object[] items = signal.Items;
foreach (object item in items)
{
var element = item as XmlElement;
if (element != null)
{
XmlSchemaComplexType complexType;
string elementName = element.Name;
string localName = element.LocalName;
XmlSchema schema = SchemaManager.GetSchema(element.NamespaceURI);
SchemaManager.GetComplexType(element.NamespaceURI, localName, out complexType);
var xmlSchemaObjects =
new Dictionary <string, XmlSchemaObject>();
SchemaManager.ExtractAttributes(complexType, xmlSchemaObjects);
foreach (XmlAttribute attribute in element.Attributes)
{
string propertyName = attribute.Name;
string value = attribute.Value;
try
{
XmlSchemaAttribute schemaAttribute;
SchemaManager.FindAttribute(element.NamespaceURI, localName, propertyName,
out schemaAttribute);
bool isPhysicalType = false;
string typeName = "";
if (schemaAttribute != null)
{
XmlSchemaSimpleType simpleType = schemaAttribute.AttributeSchemaType;
XmlQualifiedName qn = schemaAttribute.SchemaTypeName;
isPhysicalType = SchemaManager.IsPhysicalType(simpleType);
if (!isPhysicalType)
{
isPhysicalType = SchemaManager.IsPhysicalType(qn);
}
}
Physical physical;
try
{
physical = new Physical(value);
}
catch (Exception)
{
continue;
}
RangingInformation range = physical.GetMergedRange();
//TODO: need SignalType, SignalNamespace
if (range != null)
{
InstrumentCapabilitiesBean bean =
dao.GetSignalCapabilityAttribute(Guid.Parse(id),
capabilityName,
signalName,
propertyName);
if (bean == null)
{
bean = new InstrumentCapabilitiesBean();
bean.DataState = BASEBean.eDataState.DS_ADD;
}
else
{
bean.DataState = atmlObject.IsDeleted()
? BASEBean.eDataState.DS_DELETE
: BASEBean.eDataState.DS_EDIT;
}
//bean.signalType =;
bean.capabilityName = capabilityName;
bean.signalNamespace = signalNameSpace;
bean.IncludeKeyOnInsert = true;
bean.instrumentUuid = id;
bean.attribute = propertyName;
bean.signalName = signalName;
if (range.FromQuantity != null)
{
bean.lowValue = range.FromQuantity.NominalValue;
bean.lowUnit = range.FromQuantity.Unit.BaseUnitString;
}
if (range.ToQuantity != null)
{
bean.highValue = range.ToQuantity.NominalValue;
bean.highUnit = range.ToQuantity.Unit.BaseUnitString;
}
bean.save();
}
}
catch (Exception)
{
throw;
}
}
}
else
{
string signalFunctionName = item.GetType().Name;
PropertyInfo piName = item.GetType().GetProperty("name");
if (piName != null)
{
object value = piName.GetValue(item, null);
//if (value != null)
// propertyName = value as string;
}
foreach (
PropertyInfo pi in
item.GetType()
.GetProperties(BindingFlags.Public | BindingFlags.Instance |
BindingFlags.DeclaredOnly))
{
string propertyName = pi.Name;
object value = pi.GetValue(item, null);
if (value != null)
{
try
{
//TODO: need SignalType, SignalNamespace
if (
!SchemaManager.IsPhysicalType("urn:IEEE-1641:2010:STDBSC",
signalFunctionName, propertyName))
{
continue;
}
var physicalValue = new Physical(value.ToString());
Console.WriteLine(physicalValue.ToString());
RangingInformation range = physicalValue.GetMergedRange();
InstrumentCapabilitiesBean bean =
dao.GetSignalCapabilityAttribute(Guid.Parse(id),
capabilityName,
signalName,
pi.Name);
if (bean == null)
{
bean = new InstrumentCapabilitiesBean();
bean.DataState = BASEBean.eDataState.DS_ADD;
}
else
{
bean.DataState = atmlObject.IsDeleted()
? BASEBean.eDataState.DS_DELETE
: BASEBean.eDataState.DS_EDIT;
}
//bean.signalType =;
bean.capabilityName = capabilityName;
bean.signalNamespace = signalNameSpace;
bean.IncludeKeyOnInsert = true;
bean.instrumentUuid = id;
bean.attribute = pi.Name;
bean.signalName = signalName;
if (range != null)
{
if (range.FromQuantity != null)
{
bean.lowValue = range.FromQuantity.NominalValue;
bean.lowUnit = range.FromQuantity.Unit.BaseUnitString;
}
if (range.ToQuantity != null)
{
bean.highValue = range.ToQuantity.NominalValue;
bean.highUnit = range.ToQuantity.Unit.BaseUnitString;
}
}
bean.save();
}
catch (Exception err)
{
LogManager.Error(err,
"Error Saving Capability [{0}] - Item:{1}, Value:{2}",
capability.name,
item.GetType().Name,
value
);
}
}
}
}
}
}
}
}
public EquipmentViewer()
{
_equipmentDAO = new EquipmentDAO();
}
private static MailMessage MountBusinessPartnerBilling(DataConnector connector, String businessPartnerCode, Boolean enviarDemonstrativo)
{
ContractDAO contractDAO = new ContractDAO(connector.MySqlConnection);
SubContractDAO subContractDAO = new SubContractDAO(connector.MySqlConnection);
ContractItemDAO contractItemDAO = new ContractItemDAO(connector.MySqlConnection);
EquipmentDAO equipmentDAO = new EquipmentDAO(connector.SqlServerConnection);
List <ContractItemDTO> itemList = contractItemDAO.GetItems("businessPartnerCode = '" + businessPartnerCode + "'");
Dictionary <int, List <ContractItemDTO> > itemGroups = new Dictionary <int, List <ContractItemDTO> >();
foreach (ContractItemDTO item in itemList)
{
// Cria um novo grupo caso não encontre um grupo para este subcontrato
if (!itemGroups.ContainsKey(item.subContrato_id))
{
itemGroups.Add(item.subContrato_id, new List <ContractItemDTO>());
}
// Adiciona o item ao grupo do subcontrato
List <ContractItemDTO> group = itemGroups[item.subContrato_id];
group.Add(item);
}
String billingInfo = "Cliente: " + ObterNomeCliente(connector, businessPartnerCode) + "<br/><br/>";
foreach (int subContractId in itemGroups.Keys)
{
List <ContractItemDTO> group = itemGroups[subContractId];
String itemEnumeration = "";
foreach (ContractItemDTO contractItem in group)
{
if (!String.IsNullOrEmpty(itemEnumeration))
{
itemEnumeration += ", ";
}
itemEnumeration += contractItem.codigoCartaoEquipamento;
}
List <EquipmentDTO> equipamentList = equipmentDAO.GetEquipments(itemEnumeration);
String equipmentEnumeration = "";
foreach (EquipmentDTO equipment in equipamentList)
{
if (!String.IsNullOrEmpty(equipmentEnumeration))
{
equipmentEnumeration += ", ";
}
equipmentEnumeration += equipment.ManufSN;
}
SubContractDTO subContract = subContractDAO.GetSubContract(subContractId);
ContractDTO contract = contractDAO.GetContract(subContract.contrato_id);
Boolean activeContract = true;
if ((contract.status == 3) || (contract.status == 4))
{
activeContract = false;
}
if (activeContract) // Não fatura caso o status do contrato seja finalizado ou cancelado
{
String parcela = ObterParcelaContrato(connector, contract);
String vendedor = ObterNomeVendedor(connector, contract);
DateTime dataVencimento = MountDate(contract.diaVencimento, contract.referencialVencimento);
String contractInfo = "Contrato: " + contract.numero + "<br/>" + "Parcela: " + parcela + "<br/>" + "Vendedor: " + vendedor + "<br/>" + "Data Vencimento: " + dataVencimento.ToString("dd/MM/yyyy") + "<br/>";
String subContractInfo = subContract.siglaTipo + " - " + equipmentEnumeration + "<br/>";
billingInfo += contractInfo + subContractInfo + "<br/>";
}
}
List <String> reportFiles = new List <String>();
if (enviarDemonstrativo)
{
reportFiles = BuildReportFiles("faturamentoCliente.php", "businessPartnerCode=" + businessPartnerCode);
}
MailMessage mailMessage = new MailMessage();
mailMessage.Subject = "Faturamento de contrato";
mailMessage.Body = "Email gerado automaticamente, não responder." + "<br/><br/>" + billingInfo;
foreach (String filename in reportFiles)
{
mailMessage.Attachments.Add(new Attachment(filename));
}
return(mailMessage);
}
private static MailMessage MountContractBilling(DataConnector connector, int contractId, int subContractId, Boolean enviarDemonstrativo)
{
ContractDAO contractDAO = new ContractDAO(connector.MySqlConnection);
SubContractDAO subContractDAO = new SubContractDAO(connector.MySqlConnection);
ContractItemDAO contractItemDAO = new ContractItemDAO(connector.MySqlConnection);
EquipmentDAO equipmentDAO = new EquipmentDAO(connector.SqlServerConnection);
ContractDTO contract = contractDAO.GetContract(contractId);
String contractItems = "";
List <SubContractDTO> subContractList = subContractDAO.GetSubContracts("contrato_id=" + contract.id);
foreach (SubContractDTO subContract in subContractList)
{
List <ContractItemDTO> itemList = contractItemDAO.GetItems("subcontrato_id = " + subContract.id);
String equipmentEnumeration = "";
foreach (ContractItemDTO contractItem in itemList)
{
if (!String.IsNullOrEmpty(equipmentEnumeration))
{
equipmentEnumeration += ", ";
}
equipmentEnumeration += contractItem.codigoCartaoEquipamento;
}
List <EquipmentDTO> equipamentList = equipmentDAO.GetEquipments(equipmentEnumeration);
String serialNumbers = "";
foreach (EquipmentDTO equipment in equipamentList)
{
if (!String.IsNullOrEmpty(serialNumbers))
{
serialNumbers += ", ";
}
serialNumbers += equipment.ManufSN;
}
if (String.IsNullOrEmpty(serialNumbers))
{
serialNumbers = "Nenhum item encontrado";
}
contractItems += subContract.siglaTipo + " - " + serialNumbers + "<br/>";
}
String cliente = ObterNomeCliente(connector, contract.pn);
String parcela = ObterParcelaContrato(connector, contract);
String vendedor = ObterNomeVendedor(connector, contract);
DateTime dataVencimento = MountDate(contract.diaVencimento, contract.referencialVencimento);
String billingInfo = "Contrato: " + contract.numero + "<br/>" + "Itens: " + contractItems + "<br/>" + "Cliente: " + cliente + "<br/>" + "Parcela: " + parcela + "<br/>" + "Vendedor: " + vendedor + "<br/>" + "Data Vencimento: " + dataVencimento.ToString("dd/MM/yyyy") + "<br/>";
List <String> reportFiles = new List <String>();
if (enviarDemonstrativo)
{
reportFiles = BuildReportFiles("faturamentoContrato.php", "contractId=" + contractId + "&subContractId=" + subContractId);
}
MailMessage mailMessage = new MailMessage();
mailMessage.Subject = "Faturamento de contrato";
mailMessage.Body = "Email gerado automaticamente, não responder." + "<br/><br/>" + billingInfo;
foreach (String filename in reportFiles)
{
mailMessage.Attachments.Add(new Attachment(filename));
}
return(mailMessage);
}
public HttpResponseMessage Update(Equipment equipment)
{
var rs = new EquipmentDAO().UpdateEquipment(equipment);
return(rs == true ? new HttpResponseMessage(HttpStatusCode.OK) : new HttpResponseMessage(HttpStatusCode.BadRequest));
}
/// <summary>
/// 검색 기능 버튼 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
currentPage = 1;
EquipmentDAO dAO = new EquipmentDAO();
string tempState = "";
if (rbDiscard.Checked)
{
tempState = "폐기";
}
else if (rbUsing.Checked)
{
tempState = "사용중";
}
else if (rbReplacementRequest.Checked)
{
tempState = "교체요망";
}
if (chbDate.Checked)
{
if (!(dtpStartDate.Value < dtpEndDate.Value))
{
DateTime temp = dtpEndDate.Value;
dtpEndDate.Value = dtpStartDate.Value;
dtpStartDate.Value = temp;
}
EquipmentVO equipment = new EquipmentVO()
{
DetailName = txtSearchForName.Text,
Location = txtSearchForLocation.Text,
PurchaseDate = dtpStartDate.Value,
PurchasePrice = float.Parse(txtSearchForPrice.Text),
State = tempState
};
DateTime endDate = dtpEndDate.Value;
try
{
dgvEquipmentList.DataSource = SetDataTable(dAO.SelectSearch(equipment, endDate));
}
catch (Exception)
{
MessageBox.Show("검색오류");
}
}
else
{
EquipmentVO equipment = new EquipmentVO()
{
DetailName = txtSearchForName.Text,
Location = txtSearchForLocation.Text,
PurchaseDate = DateTime.Parse("1753-1-1"),
PurchasePrice = float.Parse(txtSearchForPrice.Text),
State = tempState
};
dgvEquipmentList.DataSource = SetDataTable(dAO.SelectSearch(equipment, DateTime.Parse("1753-1-1")));
}
Paging();
}
