예제 #1
0
        private void InsertOrderDetailRecord(OrderDetailRow paOrderDetailRow)
        {
            QueryClass lcQuery;

            lcQuery = new QueryClass(QueryClass.QueryType.InsertOrderDetailRecord);
            lcQuery.ReplaceRowPlaceHolder(paOrderDetailRow.Row);

            lcQuery.ExecuteNonQuery();
        }
예제 #2
0
        private void UpdateOrderDetailRecord(OrderDetailRow paOrderDetailRow)
        {
            QueryClass lcQuery;

            lcQuery = new QueryClass(QueryClass.QueryType.UpdateOrderDetailRecord);
            lcQuery.ReplaceRowPlaceHolder(paOrderDetailRow.Row);
            ApplicationFrame.GetInstance().ActiveFormInfoManager.ReplaceQueryPlaceHolder(lcQuery);

            lcQuery.ExecuteNonQuery();
        }
예제 #3
0
        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();
        }
예제 #4
0
        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);
        }
예제 #5
0
        public bool InsertRecord()
        {
            QueryClass lcQuery;

            if (clNewRecord)
            {
                lcQuery = new QueryClass(QueryClass.QueryType.InsertSessionRow);
                lcQuery.ReplaceRowPlaceHolder(clActiveRow.Row);

                return(lcQuery.ExecuteNonQuery() > 0);
            }
            else
            {
                return(false);
            }
        }
예제 #6
0
        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);
            }
        }