/// <summary>
/// 在SqlCommand加入UPDATE用的參數
/// </summary>
/// <param name="dtoBase">DTO物件</param>
/// <param name="sqlCmd">要加入參數的SqlCommand</param>
protected void FillSqlCommmandParameterForUpdate(DataTransferObject.DataTransferObjectBase dtoBase, ref SqlCommand sqlCmd)
{
foreach (PropertyInfo _property in dtoBase.GetUpdatePropertyList())
{
if (_property.Name != "RowStatus")
{
sqlCmd.Parameters.AddWithValue("@" + _property.Name + FOR_UPDATE_PARAMETER_TRAILER, _property.GetValue(dtoBase, null));
}
}
foreach (PropertyInfo _property in dtoBase.GetAccumulatePropertyList())
{
if (_property.Name != "RowStatus")
{
sqlCmd.Parameters.AddWithValue("@" + _property.Name + FOR_UPDATE_PARAMETER_TRAILER, _property.GetValue(dtoBase, null));
}
}
}
/// <summary>
/// 產生DTO更新欄位的SQL字串，用於UPDATE的語法
/// </summary>
/// <param name="dtoBase">要使用UPDATE語法的DTO物件</param>
/// <returns>UPDATE欄位的SQL字串</returns>
protected string CreateUpdatePropertySQL(DataTransferObject.DataTransferObjectBase dtoBase)
{
string _strSQL = "";
foreach (PropertyInfo _property in dtoBase.GetUpdatePropertyList())
{
if (_property.Name != "RowStatus")
{
if (_strSQL != "")
{
_strSQL = _strSQL + " , ";
}
_strSQL = _strSQL + _property.Name + "=" + "@" + _property.Name + FOR_UPDATE_PARAMETER_TRAILER;
}
}
foreach (PropertyInfo _property in dtoBase.GetAccumulatePropertyList())
{
if (_property.Name != "RowStatus")
{
if (_strSQL != "")
{
_strSQL = _strSQL + " , ";
}
switch (_property.PropertyType.Name)
{
case "Int32":
case "Double":
case "Decimal":
case "String":
_strSQL = _strSQL + _property.Name + "=" + _property.Name + "+" + "@" + _property.Name + FOR_UPDATE_PARAMETER_TRAILER;
break;
default:
_strSQL = _strSQL + _property.Name + "=" + "@" + _property.Name + FOR_UPDATE_PARAMETER_TRAILER;
break;
}
}
}
return(_strSQL);
}