Ejemplo n.º 1
0
        /// <summary>
        /// 获取只取主键的SQL语句
        /// </summary>
        internal string BuildKeyStringForRetrieve()
        {
            this._sqlString = SqlCommander.BuildForConditions(_conditions);
            string tempre = "";

            //如果不能使用Where从句
            if (_classMap.SuperClass == null && _sqlString == null)
            {
                tempre = this.GetSelectKeyClause();
            }
            else
            {
                //如果未指定过滤条件,且_classMap.SuperClass !=null
                if (_sqlString == null)
                {
                    tempre = GetSelectKeyClause() + " WHERE " + _classMap.StringForInherit;
                }
                //如果指定了过滤条件(_sqlString!= null)
                else
                {
                    tempre = GetSelectKeyClause() + " WHERE " + _sqlString;
                }
            }
            //Order by
            if (this._orderList != null)
            {
                tempre += SelectCommander.GetOrderSql(_orderList, _classMap);
            }
            return(tempre);
        }
Ejemplo n.º 2
0
        internal void BuildStringForRetrieve()
        {
            this._sqlString = SqlCommander.BuildForConditions(_conditions);

            //如果不能使用Where从句
            if (_classMap.SuperClass == null && _sqlString == null)
            {
                _sqlString = GetSelectClause();
            }
            else
            {
                //如果未指定过滤条件,且_classMap.SuperClass !=null
                if (_sqlString == null)
                {
                    _sqlString = GetSelectClause() + " WHERE " + _classMap.StringForInherit;
                }
                //如果指定了过滤条件(_sqlString!= null)
                else
                {
                    _sqlString = GetSelectClause() + " WHERE " + _sqlString;
                    //且有父类
                    if (_classMap.SuperClass != null)
                    {
                        _sqlString += " AND " + _classMap.StringForInherit;
                    }
                }
            }
            //Order by
            if (this._orderList != null)
            {
                this._sqlString += SelectCommander.GetOrderSql(_orderList, _classMap);
            }
        }
Ejemplo n.º 3
0
        internal void BuildStringForDelete()
        {
            this._sqlString = _classMap.DeleteFromClause;

            string where = SqlCommander.BuildForConditions(this._conditions);
            if (where != null)
            {
                _sqlString += " WHERE " + where;
            }
        }
Ejemplo n.º 4
0
 //构造Query的条件 返回string
 private string GetSqlForConditions()
 {
     string where = SqlCommander.BuildForConditions(this.m_Conditions);
     if (where == null)
     {
         return(" 1=1 " + this.whereClause);
     }
     else
     {
         return("( " + where + this.whereClause + " )");
     }
 }
Ejemplo n.º 5
0
        internal void BuildStringForUpdate()
        {
            string where = SqlCommander.BuildForConditions(this._conditions);

            this._sqlString  = "UPDATE ";
            this._sqlString += this.classMap.RelationalDatabase.QuotationMarksStart + this.classMap.Table.Name + this.classMap.RelationalDatabase.QuotationMarksEnd;
            this._sqlString += " SET ";
            int i = 0;

            foreach (object key in this.m_ForUpdateCollection.Keys)
            {
                this._sqlString += this._classMap.RelationalDatabase.QuotationMarksStart + this._classMap.GetAttributeMap(key.ToString()).Column.Name + this._classMap.RelationalDatabase.QuotationMarksEnd + "=";
                this._sqlString += this._classMap.RelationalDatabase.GetStringParameter(key.ToString(), i);
                this._sqlString += ",";
                i++;
            }

//			//tintown added at 2005-3-22 添加对timestamp的更新
            //由于在更新标准时不进行timestamp判断,所以不需要更新timestamp值,要不然,会导致事务中的同一表更新不成功。
//			if(_classMap.TimestampAttribute!=null)
//			{
//				ColumnMap cm=_classMap.TimestampAttribute.Column ;
//				this._sqlString+=cm.Name+"=";
//				this._sqlString+=this._classMap.RelationalDatabase.GetStringParameter("Update"+cm.Name,i);
//				this._sqlString+=",";
//			}


            char[] chars = new char[] { ',' };
            this._sqlString = this._sqlString.TrimEnd(chars);



            if (where != null)
            {
                _sqlString += " WHERE " + where;
            }
        }