/// <summary> /// 添加实体信息 /// </summary> /// <param name="t"></param> /// <param name="strCols">插入列名字符串,若为空,则全插入</param> /// <returns></returns> public int Add(T t, string strCols, int isReturn) { if (t == null) { return(0); } //获取生成的sql和参数列表 SqlModel insert = CreateSql.GetInsertSqlAndParas <T>(t, strCols, isReturn); //执行sql命令 if (isReturn == 0) { return(SqlHelper.ExecuteNonQuery(insert.Sql, 1, insert.SqlParaArray)); } else { object oId = SqlHelper.ExecuteScalar(insert.Sql, 1, insert.SqlParaArray); if (oId != null && oId.ToString() != "") { return(oId.GetInt()); } else { return(0); } } }
/// <summary> /// 批量插入 /// </summary> /// <param name="list"></param> /// <param name="strCols"></param> /// <returns></returns> public bool AddList(List <T> list, string strCols) { if (list == null || list.Count == 0) { return(false); } List <CommandInfo> comList = new List <CommandInfo>(); foreach (T t in list) { SqlModel insert = CreateSql.GetInsertSqlAndParas <T>(t, strCols, 0); CommandInfo com = new CommandInfo(insert.Sql, false, insert.SqlParaArray); comList.Add(com); } return(SqlHelper.ExecuteTrans(comList)); }
/// <summary> /// 修改信息实体 /// </summary> /// <param name="t"></param> /// <param name="strCols">要修改的列</param> /// <param name="strWhere">条件 </param> /// <returns></returns> public bool Update(T t, string strCols, string strWhere, params SqlParameter[] paras) { if (t == null) { return(false); } //获取生成的sql和参数列表 SqlModel update = CreateSql.GetUpdateSqlAndParas <T>(t, strCols, strWhere); List <SqlParameter> listParas = update.SqlParaArray.ToList(); if (paras != null && paras.Length > 0) { listParas.AddRange(paras); } //执行sql命令 return(SqlHelper.ExecuteNonQuery(update.Sql, 1, listParas.ToArray()) > 0); }