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>(); }