private NZDecimal GetOnHandQty()
{
NZDecimal dOnHandQty = new NZDecimal();
try
{
IssueByItemUIDM uidm = dmcIssueByItem.SaveData(new IssueByItemUIDM());
if (uidm.ITEM_CD.IsNull || uidm.FROM_LOC_CD.IsNull)
{
return(new NZDecimal());
}
IssueConsumptionController ctlIssue = new IssueConsumptionController();
dOnHandQty = ctlIssue.GetOnHandQty(uidm);
if (dOnHandQty.IsNull)
{
return(new NZDecimal());
}
return(dOnHandQty);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
return(new NZDecimal());
}
private void OpenIssueScreen(bool CanEdit)
{
int activeRow = shtView.ActiveRowIndex;
IssueByItemUIDM uidm = new IssueByItemUIDM();
uidm.TRANS_ID.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_NO].Text;
uidm.REF_NO.Value = shtView.Cells[activeRow, (int)eColView.REF_NO].Text;
uidm.ITEM_CD.Value = shtView.Cells[activeRow, (int)eColView.PART_NO].Text;
uidm.ITEM_DESC.Value = shtView.Cells[activeRow, (int)eColView.PART_NAME].Text;
uidm.FROM_LOC_CD.Value = shtView.Cells[activeRow, (int)eColView.FROM_LOC].Text;
uidm.TO_LOC_CD.Value = shtView.Cells[activeRow, (int)eColView.TO_LOC].Text;
uidm.LOT_NO.Value = shtView.Cells[activeRow, (int)eColView.LOT_NO].Text;
// uidm.ONHAND_QTY.Value = shtView.Cells[activeRow, (int) eColView.TRANS_ID].Text;
uidm.QTY.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_QTY].Text;
uidm.REMARK.Value = shtView.Cells[activeRow, (int)eColView.REMARK].Text;
uidm.TRANS_DATE.Value = Convert.ToDateTime(shtView.Cells[activeRow, (int)eColView.ISSUE_DATE].Value);
uidm.TRANS_CLS.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_TYPE].Text;
uidm.REF_SLIP_NO.Value = shtView.Cells[activeRow, (int)eColView.REF_SLIP_NO].Text;
uidm.REF_SLIP_NO2.Value = shtView.Cells[activeRow, (int)eColView.REF_SLIP_NO2].Text;
uidm.FOR_CUSTOMER.Value = shtView.Cells[activeRow, (int)eColView.FOR_CUSTOMER].Text;
uidm.FOR_MACHINE.Value = shtView.Cells[activeRow, (int)eColView.FOR_MACHINE].Text;
uidm.TRAN_SUB_CLS.Value = shtView.Cells[activeRow, (int)eColView.TRAN_SUB_CLS].Text;
TRN140 frmTRN140 = new TRN140(uidm, CanEdit);
frmTRN140.ShowDialog();
}
internal NZDecimal GetOnHandQty(IssueByItemUIDM uidmIssue)
{
InventoryBIZ bizInv = new InventoryBIZ();
ActualOnhandViewDTO dtoInvOnHand;
dtoInvOnHand = bizInv.LoadActualInventoryOnHand(uidmIssue.ITEM_CD, uidmIssue.FROM_LOC_CD, uidmIssue.LOT_NO);
if (dtoInvOnHand != null)
{
return(dtoInvOnHand.ONHAND_QTY);
}
return(new NZDecimal());
}
public TRN140(IssueByItemUIDM uidm, bool CanEdit)
{
InitializeComponent();
if (CanEdit)
{
m_Mode = eSaveMode.UPDATE;
}
else
{
m_Mode = eSaveMode.VIEW;
}
m_uidm = uidm;
}
internal NZDecimal GetOnHandQty(IssueByItemUIDM uidmIssue)
{
InventoryBIZ bizInv = new InventoryBIZ();
ActualOnhandViewDTO dtoInvOnHand;
//InventoryPeriodBIZ bizPeriod = new InventoryPeriodBIZ();
//NZString YearMonth = bizPeriod.LoadCurrentPeriod().YEAR_MONTH; //new NZString(null, CommonLib.Common.GetDatabaseDateTime().ToString("yyyyMM"));
//InventoryPeriodDTO dtoPeriod = bizPeriod.LoadCurrentPeriod();
//if (dtoPeriod == null) return new NZDecimal();
dtoInvOnHand = bizInv.LoadActualInventoryOnHand(uidmIssue.ITEM_CD, uidmIssue.FROM_LOC_CD, uidmIssue.LOT_NO);
if (dtoInvOnHand != null)
{
return(dtoInvOnHand.ONHAND_QTY);
}
return(new NZDecimal());
}
private bool SaveData()
{
try
{
IssueConsumptionController ctlIssue = new IssueConsumptionController();
IssueByItemUIDM uidmIssue = dmcIssueByItem.SaveData(new IssueByItemUIDM());
switch (m_Mode)
{
case eSaveMode.ADD:
ctlIssue.SaveAddIssue(uidmIssue);
break;
case eSaveMode.UPDATE:
uidmIssue.REF_NO.Value = m_REF_NO;
uidmIssue.LOT_NO.Value = txtLotNo.Text;
ctlIssue.SaveUpdateIssue(uidmIssue);
break;
}
return(true);
}
catch (ValidateException err)
{
for (int i = 0; i < err.ErrorResults.Count; i++)
{
MessageDialog.ShowBusiness(this, err.ErrorResults[i].Message.MessageDescription);
err.ErrorResults[i].FocusOnControl();
}
}
catch (BusinessException err)
{
MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription);
err.Error.FocusOnControl();
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
return(false);
}
internal void SaveAddIssue(IssueByItemUIDM uidmIssue)
{
List <InventoryTransactionDTO> dtoInvTrnsList = new List <InventoryTransactionDTO>();
InventoryTransactionDTO dtoInvTrns; // = new InventoryTransactionDTO();
InventoryBIZ bizInv = new InventoryBIZ();
//20100311 add by pichet
CommonLib.Common.CurrentDatabase.KeepConnection = true;
CommonLib.Common.CurrentDatabase.BeginTransaction(IsolationLevel.Serializable);
//20100311 end add
#region Add New Trans Record
RunningNumberBIZ bizRunning = new RunningNumberBIZ();
NZString TransID = bizRunning.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR"));
NZString RefID = bizRunning.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR"));
NZString ConsumptionID = bizRunning.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR"));
// up
dtoInvTrns = new InventoryTransactionDTO();
dtoInvTrns.TRANS_ID = TransID;
dtoInvTrns.REF_NO = RefID;
dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD;
dtoInvTrns.LOC_CD = uidmIssue.FROM_LOC_CD;
dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO;
dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE;
if (dtoInvTrns.TRANS_DATE.IsNull)
{
dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
}
dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString();
dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out);
dtoInvTrns.QTY = uidmIssue.QTY;
dtoInvTrns.REMARK = uidmIssue.REMARK;
dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue);
dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO;
dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2;
dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS;
dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER;
dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE;
dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString();
dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString();
dtoInvTrnsList.Add(dtoInvTrns);
// down
dtoInvTrns = new InventoryTransactionDTO();
dtoInvTrns.TRANS_ID = RefID;
dtoInvTrns.REF_NO = TransID;
dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD;
dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD;
dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO;
dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE;
if (dtoInvTrns.TRANS_DATE.IsNull)
{
dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
}
dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString();
dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.In);
dtoInvTrns.QTY = uidmIssue.QTY;
dtoInvTrns.REMARK = uidmIssue.REMARK;
dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue);
dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO;
dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2;
dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS;
dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER;
dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE;
dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString();
dtoInvTrnsList.Add(dtoInvTrns);
// consumption
dtoInvTrns = new InventoryTransactionDTO();
dtoInvTrns.TRANS_ID = ConsumptionID;
dtoInvTrns.REF_NO = TransID;
dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD;
dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD;
dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO;
dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE;
if (dtoInvTrns.TRANS_DATE.IsNull)
{
dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
}
dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Consumption).ToNZString();
dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out);
dtoInvTrns.QTY = uidmIssue.QTY;
dtoInvTrns.REMARK = uidmIssue.REMARK;
dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue);
dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO;
dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2;
//dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS;
dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER;
dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE;
dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString();
dtoInvTrnsList.Add(dtoInvTrns);
#endregion
try
{
// REWRITE UPDATE STOCK ONHAND METHOD
// CHANGE TO USE THE COMMON FUNCTION
bizInv.AddInventoryTransactions(CommonLib.Common.CurrentDatabase, dtoInvTrnsList, false);
CommonLib.Common.CurrentDatabase.Commit();
}
catch (Exception ex)
{
CommonLib.Common.CurrentDatabase.Rollback();
throw;
}
finally
{
if (CommonLib.Common.CurrentDatabase.DBConnectionState == ConnectionState.Open)
{
CommonLib.Common.CurrentDatabase.Close();
}
}
}
internal void SaveUpdateIssue(IssueByItemUIDM uidmIssue)
{
List <InventoryTransactionDTO> dtoInvTrnsList = new List <InventoryTransactionDTO>();
InventoryTransactionDTO dtoInvTrns; // = new InventoryTransactionDTO();
InventoryBIZ bizInv = new InventoryBIZ();
//20100311 add by pichet
CommonLib.Common.CurrentDatabase.KeepConnection = true;
CommonLib.Common.CurrentDatabase.BeginTransaction(IsolationLevel.Serializable);
//20100311 end add
#region Add New Trans Record
// up
dtoInvTrns = new InventoryTransactionDTO();
dtoInvTrns.TRANS_ID = uidmIssue.TRANS_ID;
dtoInvTrns.REF_NO = uidmIssue.REF_NO;
dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD;
dtoInvTrns.LOC_CD = uidmIssue.FROM_LOC_CD;
dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO;
dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE;
if (dtoInvTrns.TRANS_DATE.IsNull)
{
dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
}
dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString();
dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out);
dtoInvTrns.QTY = uidmIssue.QTY;
dtoInvTrns.REMARK = uidmIssue.REMARK;
dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue);
dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO;
dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2;
dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS;
dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER;
dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE;
dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString();
dtoInvTrnsList.Add(dtoInvTrns);
// down
dtoInvTrns = new InventoryTransactionDTO();
dtoInvTrns.TRANS_ID = uidmIssue.REF_NO;
dtoInvTrns.REF_NO = uidmIssue.TRANS_ID;
dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD;
dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD;
dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO;
dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE;
if (dtoInvTrns.TRANS_DATE.IsNull)
{
dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
}
dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString();
dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.In);
dtoInvTrns.QTY = uidmIssue.QTY;
dtoInvTrns.REMARK = uidmIssue.REMARK;
dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue);
dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO;
dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2;
dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS;
dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER;
dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE;
dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString();
dtoInvTrnsList.Add(dtoInvTrns);
// consumption
dtoInvTrns = new InventoryTransactionDTO();
dtoInvTrns.TRANS_ID = GetConsumptionTransID(uidmIssue.TRANS_ID);//uidmIssue.REF_NO;
dtoInvTrns.REF_NO = uidmIssue.TRANS_ID;
dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD;
dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD;
dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO;
dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE;
if (dtoInvTrns.TRANS_DATE.IsNull)
{
dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
}
dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Consumption).ToNZString();
dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out);
dtoInvTrns.QTY = uidmIssue.QTY;
dtoInvTrns.REMARK = uidmIssue.REMARK;
dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime();
dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue);
dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO;
dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2;
//dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS;
dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER;
dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE;
dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString();
dtoInvTrnsList.Add(dtoInvTrns);
#endregion
#region Update OnHand Stock
#endregion
try
{
bizInv.UpdateInventoryTransactions(CommonLib.Common.CurrentDatabase, dtoInvTrnsList);//, dtoInvOnHandList);
CommonLib.Common.CurrentDatabase.Commit();
}
catch (Exception err)
{
CommonLib.Common.CurrentDatabase.Rollback();
throw;
}
finally
{
if (CommonLib.Common.CurrentDatabase.DBConnectionState == ConnectionState.Open)
{
CommonLib.Common.CurrentDatabase.Close();
}
}
}
