void OnPointerReleased(object sender, PointerRoutedEventArgs e)
{
if (e.IsTouch())
{
// 触摸模式只支持列排序
if (_pointerID == e.Pointer.PointerId)
{
ReleasePointerCapture(e.Pointer);
_pointerID = null;
ChangedSortState();
}
return;
}
if (_isDragging)
{
if (_dragTgtCol != null)
{
// 拖拽结束
_owner.FinishedDrag();
Cols cols = _owner.Lv.Cols;
int index = cols.IndexOf(_dragTgtCol);
cols.Remove(Col);
cols.Insert(index, Col);
cols.Invalidate();
}
else
{
// 列排序
ChangedSortState();
}
}
ResetMouseState();
}
/// <summary>
/// Returns Second Part of Query format;
/// for Select --> ""
/// for Insert --> Values({0})
/// for Update Or Delete Where IdColumn=@IdColumn
/// </summary>
/// <returns></returns>
private string getSecondPart()
{
string _secondPart = "";
string paramPrefix = GetParameterPrefix();
string prefix = GetPrefix();
string suffix = GetSuffix();
StringBuilder strBuilder;
List <string> Cols;
switch (_queryType)
{
case QueryTypes.Select:
break;
case QueryTypes.InsertAndGetId:
case QueryTypes.Insert:
{
Cols = _baseBO.GetColumnChangeList();
Cols.Remove(_baseBO.GetIdColumn());
if (Cols.Count == 0)
{
return("");
}
strBuilder = new StringBuilder();
foreach (string col in Cols)
{
strBuilder.AppendFormat("{0}{1},", paramPrefix, col);
}
_secondPart = strBuilder.ToString();
return(_secondPart.Substring(0, _secondPart.Length - 1));
}
case QueryTypes.SelectWhereId:
case QueryTypes.Delete:
case QueryTypes.Update:
_secondPart = string.Format("{0}{1}{2}={3}{1}", prefix,
_baseBO.GetIdColumn(), suffix, paramPrefix);
break;
case QueryTypes.SelectWhereChangeColumns:
{
strBuilder = new StringBuilder();
Cols = _baseBO.GetColumnChangeList();
if (Cols.Count == 0)
{
return("");
}
foreach (string col in _baseBO.GetColumnChangeList())
{
strBuilder.AppendFormat("{0}{1}{2}={3}{1} And ",
prefix, col, suffix, paramPrefix);
}
_secondPart = strBuilder.ToString();
return(_secondPart.Substring(0, _secondPart.Length - 5));
}
default:
break;
}
return(_secondPart);
}
/// <summary>
/// Returns Second Part of Query format;
/// for Select Or Delete --> ""
/// for Insert --> Table({0})
/// for Update Set Column=@Column
/// </summary>
/// <returns></returns>
private String GetFirstPart()
{
String _firstPart = "";
String paramPrefix = GetParameterPrefix();
String prefix = GetPrefix();
String suffix = GetSuffix();
StringBuilder strBuilder;
List <String> Cols;
switch (_queryType)
{
case QueryTypes.SelectWhereId:
case QueryTypes.SelectWhereChangeColumns:
case QueryTypes.SelectChangeColumns:
case QueryTypes.Select:
case QueryTypes.Delete:
break;
case QueryTypes.InsertAndGetId:
case QueryTypes.InsertAnyChange:
case QueryTypes.Insert:
{
Cols = _baseBO.GetColumnChangeList();
if (_queryType != QueryTypes.InsertAnyChange)
{
Cols.Remove(_baseBO.GetIdColumn());
}
if (Cols.Count == 0)
{
return("");
}
strBuilder = new StringBuilder();
foreach (String col in Cols)
{
strBuilder.AppendFormat("{0}{1}{2},", prefix, col, suffix);
}
_firstPart = strBuilder.ToString();
return(_firstPart.Substring(0, _firstPart.Length - 1));
}
case QueryTypes.Update:
{
strBuilder = new StringBuilder();
Cols = _baseBO.GetColumnChangeList();
Cols.Remove(_baseBO.GetIdColumn());
if (Cols.Count == 0)
{
return("");
}
if (_ConnType != ConnectionTypes.Odbc)
{
foreach (String col in _baseBO.GetColumnChangeList())
{
strBuilder.AppendFormat("{0}{1}{2}={3}{1}, ",
prefix, col, suffix, paramPrefix);
}
}
else
{
foreach (String col in _baseBO.GetColumnChangeList())
{
strBuilder.AppendFormat("{0}={1}, ",
col, paramPrefix);
}
}
_firstPart = strBuilder.ToString();
return(_firstPart.Substring(0, _firstPart.Length - 2));
}
default:
break;
}
return(_firstPart);
}
