/// <summary> /// 增加一条数据 /// </summary> public int Add(ADT.XingZhi.Models.S.File model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO [S_FILE] ("); strSql.Append("F_ID,F_PATH,F_TITLE,F_EXT,F_SIZE,F_OBJECTTYPE,F_CREATEBY,F_CREATETIME,F_IP,F_EXTRA)"); strSql.Append(" VALUES ("); strSql.Append("@id,@path,@title,@ext,@size,@objectType,@createby,@createtime,@ip,@extra)"); SqlParameter[] param = { new SqlParameter("@id", SqlDbType.VarChar, 36), new SqlParameter("@path", SqlDbType.VarChar, 100), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@extension", SqlDbType.VarChar, 10), new SqlParameter("@size", SqlDbType.BigInt), new SqlParameter("@objectType", SqlDbType.VarChar, 30), new SqlParameter("@createby", SqlDbType.NVarChar, 30), new SqlParameter("@createtime", SqlDbType.DateTime), new SqlParameter("@ip", SqlDbType.VarChar, 30), new SqlParameter("@extra", SqlDbType.VarChar, 255) }; param[0].Value = model.Id; param[1].Value = model.Path; param[2].Value = model.Title; param[3].Value = model.Ext; param[4].Value = model.Size; param[5].Value = model.ObjectType; param[6].Value = model.CreateBy; param[7].Value = model.CreateTime; param[8].Value = model.IP; param[9].Value = model.Extra; return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, strSql.ToString(), param)); } catch (ArgumentNullException ex) { logger.Error("调用方法Add(ADT.XingZhi.Models.S.File model)发生ArgumentNullException", ex); } catch (SqlException ex) { logger.Error("调用方法Add(ADT.XingZhi.Models.S.File model)发生SqlException", ex); } catch (Exception ex) { logger.Error("调用方法Add(ADT.XingZhi.Models.S.File model)发生Exception", ex); } return(-1); }
/// <summary> /// 保存一条数据 /// </summary> public int Add(ADT.XingZhi.Models.S.File model) { return(dal.Add(model)); }