/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.TimerMission model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TimerMission("); strSql.Append("id,MissionName,GroupName,SqlStr,TimeCorn,RepeatCount,InveralTime,StartTime,EndTime,CreateTime,MissionExplain,MissionState,IsDel)"); strSql.Append(" values ("); strSql.Append("@id,@MissionName,@GroupName,@SqlStr,@TimeCorn,@RepeatCount,@InveralTime,@StartTime,@EndTime,@CreateTime,@MissionExplain,@MissionState,@IsDel)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@MissionName", SqlDbType.NVarChar, 50), new SqlParameter("@GroupName", SqlDbType.NChar, 50), new SqlParameter("@SqlStr", SqlDbType.NVarChar, -1), new SqlParameter("@TimeCorn", SqlDbType.NChar, 50), new SqlParameter("@RepeatCount", SqlDbType.Int, 4), new SqlParameter("@InveralTime", SqlDbType.Int, 4), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@MissionExplain", SqlDbType.NVarChar, -1), new SqlParameter("@MissionState", SqlDbType.Int, 4), new SqlParameter("@IsDel", SqlDbType.Int, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.MissionName; parameters[2].Value = model.GroupName; parameters[3].Value = model.SqlStr; parameters[4].Value = model.TimeCorn; parameters[5].Value = model.RepeatCount; parameters[6].Value = model.InveralTime; parameters[7].Value = model.StartTime; parameters[8].Value = model.EndTime; parameters[9].Value = model.CreateTime; parameters[10].Value = model.MissionExplain; parameters[11].Value = model.MissionState; parameters[12].Value = model.IsDel; int rows = DbHelper.ExecuteSql(strSql.ToString(), parameters); return(rows); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(Guid id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from TimerMission "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = id; int rows = DbHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(DEV_STANDARD_SDS model) { return(DbHelper.ExecuteSql(Conn, InsertSQL(model))); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(RESULT_OBD model, string p_strWhere) { return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere))); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(RESULT_OBD model) { return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model))); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(INSPECTION_DEV_REG_INFO model, int intID) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID))); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(RESULT_OBD model, int intID) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID))); }
/// <summary> /// 删除一个集合 /// </summary> public bool DeleteRange(string p_strWhere) { return(DbHelper.ExecuteSql(Conn, DeleteRangeSQL(p_strWhere))); }
/// <summary> /// 简单的数据库操作示例 /// </summary> /// <returns></returns> public bool Insert() { string sql = @" insert into TimerTests values('success',getdate())"; return(DbHelper.ExecuteSql(sql) > 0); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(DEV_STANDARD_SDS model, int intID) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID))); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(DEV_STANDARD_SDS model) { return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model))); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(COSTUME_MODEL_LIMIT model) { return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model))); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string strMODEL_NAME) { return(DbHelper.ExecuteSql(Conn, DeleteSQL(strMODEL_NAME))); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(COSTUME_MODEL_LIMIT model, string p_strWhere) { return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere))); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(COSTUME_MODEL_LIMIT model, string strMODEL_NAME) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, strMODEL_NAME))); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(COSTUME_MODEL_LIMIT model) { return(DbHelper.ExecuteSql(Conn, InsertSQL(model))); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(INSPECTION_DEV_REG_INFO model) { return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model))); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(INSPECTION_DEV_REG_INFO model, string p_strWhere) { return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere))); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(DEV_STANDARD_SDS model, string p_strWhere) { return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere))); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(RESULT_ZYJS model, string strJCLSH) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, strJCLSH))); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int intID) { return(DbHelper.ExecuteSql(Conn, DeleteSQL(intID))); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string strJCLSH) { return(DbHelper.ExecuteSql(Conn, DeleteSQL(strJCLSH))); }
/// <summary> /// 删除全部 /// </summary> public bool DeleteAll() { return(DbHelper.ExecuteSql(Conn, DeleteAllSQL())); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(RESULT_OBD model) { return(DbHelper.ExecuteSql(Conn, InsertSQL(model))); }
public bool SqlExecute(string sql) { return(DbHelper.ExecuteSql(sql) > 0); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(INSPECTION_DEV_REG_INFO model) { return(DbHelper.ExecuteSql(Conn, InsertSQL(model))); }