public string Update(UpdateClip updateClip, WhereClip whereClip)
{
IEnumerable <T> lst = EntityGenerics <DB, T> .Instance.Select().SetWhereClip(whereClip).ToList();
int num = EntityGenerics <DB, T> .Instance.Update(updateClip, whereClip);
return((num > 0) ? "" : "更新失败");
}
public string Update(UpdateClip updateClip, WhereClip whereClip, string userName)
{
//先用IEnumerable获取list，然后再进行 update操作
IEnumerable <T> lst = EntityGenerics <DB, T> .Instance.Select().SetWhereClip(whereClip).ToList();
int num = EntityGenerics <DB, T> .Instance.Update(updateClip, whereClip);
return((num > 0) ? "" : "更新失败");
}
public int Update(UpdateClip updateClip, WhereClip whereClip, DBtransaction dbtran)
{
List <DbParameter> parameters = new List <DbParameter>();
string updateSql = "";
string whereSql = "";
updateClip.GetParamString(excuteImport, ref updateSql, ref parameters);
whereClip.GetPartmerStrings(excuteImport, ref whereSql, ref parameters);
string sqlStr = "UPDATE " + TableName + " " + updateSql + " WHERE " + whereSql;
return(excuteImport.ExcuteNotQuery(sqlStr, parameters, dbtran));
}
public void ClearCondition()
{
SelectName = new SelectName();
InsertClip = new InsertClip();
UpdateClip = new UpdateClip();
OrderByClip = new OrderByClip();
GroupByClip = new GroupByClip();
WhereClip = new WhereClip();
OtherT = new List <string>();
SKipNum = 0;
TakeNum = 0;
lstDbParmeters = new List <DbParameter>();
}