/// <summary>
/// 往条件表中塞入having条件语句
/// </summary>
/// <param name="Where"></param>
/// <returns></returns>
public TableModelHelper <T> Having(string Where, ORMParameter[] Parameters)
{
DataRow drNew = _dt_Condition.NewRow();
drNew["Condition"] = "having";
drNew["Value"] = Where;
drNew["Parameters"] = ORMParameter.ToDALParameter(Parameters).ToArray();
_dt_Condition.Rows.Add(drNew);
return(this);
}
public bool Update(string Where = null, ORMParameter[] Parameters = null, Transaction Transaction = null)
{
bool blResult = true;
StringBuilder sbSQL = new StringBuilder();
IDBHelper objHelper = null;
if (null != Transaction && null != Transaction.DBHelper)
{
objHelper = Transaction.DBHelper;
}
else
{
objHelper = DBFactory.CreateDBHelper();
}
DataTable dtProperties = Reflection.GetClassValues(this, _dt_ClassDef);
if (dtProperties != null && dtProperties.Columns.Count > 0 && dtProperties.Rows.Count > 0)
{
DataRow drProperty = dtProperties.Rows[0];
sbSQL.Append(" UPDATE ");
sbSQL.Append(_cad_TableDef.GetFullTableName(DBExString));
sbSQL.Append(" SET ");
for (int i = 0, x = 0; i < _dt_ClassDef.Columns.Count; i++)
{
if (x == 0)
{
if (drProperty[_dt_ClassDef.Columns[i].ColumnName] != DBNull.Value && _dt_ClassDef.Rows[0][i].ToString() == "0")
{
sbSQL.Append(_dt_ClassDef.Columns[i].ColumnName + "=@" + _dt_ClassDef.Columns[i].ColumnName);
x++;
}
}
else
{
if (drProperty[_dt_ClassDef.Columns[i].ColumnName] != DBNull.Value && _dt_ClassDef.Rows[0][i].ToString() == "0")
{
sbSQL.Append("," + _dt_ClassDef.Columns[i].ColumnName + "=@" + _dt_ClassDef.Columns[i].ColumnName);
x++;
}
}
}
sbSQL.Append(" WHERE ");
if (!string.IsNullOrEmpty(Where))
{
sbSQL.Append((" " + Where.ToLower()).Replace(" where ", ""));//È¥µôÀïÃæµÄwhere
}
else
{
for (int i = 0, x = 0; i < _dt_ClassDef.Columns.Count; i++)
{
if (_dt_ClassDef.Rows[0][i].ToString() == "1")
{
if (x == 0)
{
if (drProperty[_dt_ClassDef.Columns[i].ColumnName] != DBNull.Value)
{
sbSQL.Append(_dt_ClassDef.Columns[i].ColumnName + "=@" + _dt_ClassDef.Columns[i].ColumnName + "");
x++;
}
}
else
{
if (drProperty[_dt_ClassDef.Columns[i].ColumnName] != DBNull.Value)
{
sbSQL.Append(" AND " + _dt_ClassDef.Columns[i].ColumnName + "=@" + _dt_ClassDef.Columns[i].ColumnName + "");
x++;
}
}
}
}
}
}
if (!string.IsNullOrEmpty(sbSQL.ToString()))
{
List <Parameter> lstParameter = new List <Parameter>();
if (dtProperties != null && dtProperties.Rows.Count > 0 && dtProperties.Columns.Count > 0)
{
for (int i = 0; i < dtProperties.Columns.Count; i++)
{
Parameter objParameter = new Parameter();
objParameter.Name = "@" + dtProperties.Columns[i].ColumnName;
objParameter.Value = dtProperties.Rows[0][i];
lstParameter.Add(objParameter);
}
}
lstParameter.AddRange(ORMParameter.ToDALParameter(Parameters));
objHelper.ExecNoneQueryWithSQL(sbSQL.ToString(), lstParameter.ToArray());
}
return(blResult);
}