private void InsertOrderDetailRecord(OrderDetailRow paOrderDetailRow)
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.InsertOrderDetailRecord);
lcQuery.ReplaceRowPlaceHolder(paOrderDetailRow.Row);
lcQuery.ExecuteNonQuery();
}
private void UpdateOrderDetailRecord(OrderDetailRow paOrderDetailRow)
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.UpdateOrderDetailRecord);
lcQuery.ReplaceRowPlaceHolder(paOrderDetailRow.Row);
ApplicationFrame.GetInstance().ActiveFormInfoManager.ReplaceQueryPlaceHolder(lcQuery);
lcQuery.ExecuteNonQuery();
}
public void UpdateSessionAccessInfo()
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.UpdateSessionAccessInfo);
lcQuery.ReplacePlaceHolder("$SUBSCRIPTIONID", ActiveRow.SubscriptionID, true);
lcQuery.ReplacePlaceHolder("$LASTACCESSTIME", General.ConvertUTCToSystemLocalTime(DateTime.UtcNow).ToString("yyyy-MM-dd HH:mm:ss"), true);
lcQuery.ReplacePlaceHolder("$LOGINID", ActiveRow.LoginID, true);
lcQuery.ExecuteNonQuery();
}
public bool UpdateOrderInfoRemark(String paOrderRemark)
{
QueryClass lcQueryClass;
lcQueryClass = new QueryClass(QueryClass.QueryType.UpdateOrderInfoRemark);
lcQueryClass.ReplacePlaceHolder("$ORDERNO", clOrderNo.ToString(), false);
lcQueryClass.ReplacePlaceHolder("$ORDERREMARK", paOrderRemark, true);
lcQueryClass.ReplacePlaceHolder("$SUBSCRIPTIONID", ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.SubscriptionID, true);
lcQueryClass.ExecuteNonQuery();
return(true);
}
public bool InsertRecord()
{
QueryClass lcQuery;
if (clNewRecord)
{
lcQuery = new QueryClass(QueryClass.QueryType.InsertSessionRow);
lcQuery.ReplaceRowPlaceHolder(clActiveRow.Row);
return(lcQuery.ExecuteNonQuery() > 0);
}
else
{
return(false);
}
}
private bool UpdatDataRecord(Dictionary <String, String> paActiveDataList)
{
QueryClass lcQuery;
try
{
lcQuery = new QueryClass(clUpdateQuery, clConnectionMode);
lcQuery.ReplaceDictionaryPlaceHolder(paActiveDataList);
lcQuery.ReplacePlaceHolder("$COLUMNLIST", "N\'(" + paActiveDataList.GetData(ctKEYDataColumnList) + ")\'", false);
lcQuery.ReplacePlaceHolder("$VALUELIST", BuildSQLValueString(paActiveDataList, ctKEYDataColumnList, ctComma), false);
lcQuery.ReplacePlaceHolder("$UPDATEDATASTRING", BuildSQLColumnValueString(paActiveDataList, ctKEYDataColumnList, ctComma), false);
lcQuery.ReplacePlaceHolder("$CONDITIONSTRING", BuildSQLColumnValueString(paActiveDataList, ctKEYKeyColumnList, " And "), false);
return(lcQuery.ExecuteNonQuery() > 0);
}
catch (Exception paException)
{
General.WriteExceptionLog(paException, "UPDATEDATA : " + ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.SubscriptionID);
return(false);
}
}