/// <summary> /// 删除数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="entityOfWhere"></param> /// <param name="LoptIsAnd"></param> /// <returns></returns> public string Delete <T>(T entityOfWhere, bool LoptIsAnd) { string result = ""; var conn = OpenConnection(); try { string sql = ModelPropUtils.ModelToDeleteSql(entityOfWhere, LoptIsAnd, out result); if (!result.Equals("0")) { return(result); } //conn.Open(); var res = conn.Execute(sql, entityOfWhere, null, null, null); result = "0";// res.ToString(); conn.Close(); } catch (Exception ex) { result = $"ex=>{ex.ToString()}"; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(result); }
/// <summary> /// 新增数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Insert <T>(T entity, out string result) { result = "0"; int idenId = 0; var conn = OpenConnection(); try { string sql = ModelPropUtils.ModelToInsertSql(entity, out result); if (!result.Equals("0")) { result = "=>" + sql; return(0); } //conn.Open(); sql += "SELECT @@identity;"; idenId = conn.ExecuteScalar <int>(sql, entity); //result = res.ToString(); conn.Close(); } catch (Exception ex) { result = $"ex=>{ex.ToString()}"; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(idenId); }
/// <summary> /// 新增数据(成功返回0) /// </summary> /// <param name="entity"></param> /// <returns></returns> public string Insert <T>(T entity) { string result = ""; var conn = OpenConnection(); try { string sql = ModelPropUtils.ModelToInsertSql(entity, out result); if (!result.Equals("0")) { return(result); } //conn.Open(); var res = conn.Execute(sql, entity); result = "0";// res.ToString(); conn.Close(); } catch (Exception ex) { result = $"ex=>{ex.ToString()}"; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(result); }
/// <summary> /// 更新数据-条件 /// </summary> /// <param name="entityToUpdate"></param> /// <param name="entityOfWhere"></param> /// <param name="LoptIsAnd">逻辑运算符是否为“and”</param> /// <returns></returns> public string Update <T>(T entityToUpdate, T entityOfWhere, bool LoptIsAnd) { string result = ""; var conn = OpenConnection(); try { /*string sql = ModelPropUtils.ModelToUpDateSql(entityToUpdate, entityOfWhere, LoptIsAnd, out result); * if (!result.Equals("0")) * return result; * * //conn.Open(); * var res = conn.Execute(sql, CombineModel<T>(entityToUpdate, entityOfWhere), null, null, null); * result = "0";// res.ToString(); * conn.Close();*/ string sql = ModelPropUtils.ModelToUpDateSql(entityToUpdate, entityOfWhere, LoptIsAnd, out result); if (result.Equals("0")) { //conn.Open(); var res = conn.Execute(sql, CombineModel <T>(entityToUpdate, entityOfWhere), null, null, null); } result = "0";// res.ToString(); conn.Close(); } catch (Exception ex) { result = $"ex=>{ex.ToString()}"; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(result); }
/// <summary> /// 批量Replace数据(成功返回0) /// </summary> /// <param name="entity"></param> /// <returns></returns> public string BatchReplace <T>(List <T> entitys) { string result = ""; var conn = OpenConnection(); IDbTransaction trans = null; try { string sql = ModelPropUtils.ModelToReplaceSqllist(entitys, out result); if (!result.Equals("0")) { return(result); } //conn.Open(); trans = conn.BeginTransaction(); var res = conn.Execute(sql, entitys, trans); trans.Commit(); result = "0";// res.ToString(); conn.Close(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } result = $"ex=>{ex.ToString()}"; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(result); }