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