public void UpdateSetter(entity.Setter setter)
{
using (var conn = DbUtil.getConn())//更新Setter
{
conn.Execute("update bdl_set set Set_Language=@Set_Language,Set_OrganizationSort=@Set_OrganizationSort,Set_OrganizationName=@Set_OrganizationName,Set_PhotoLocation=@Set_PhotoLocation,Set_OrganizationPhone=@Set_OrganizationPhone,Back_Up=@Back_Up where Pk_Set_Id=@Pk_Set_Id", setter);
}
setter = getSetter();
//插入至上传表
UploadManagementDAO uploadManagementDao1 = new UploadManagementDAO();
uploadManagementDao1.Insert(new UploadManagement(setter.Pk_Set_Id, "bdl_set", 1));
}
public void UpdateStatusByUserId(int userId)
{
//插入至上传表
UploadManagementDAO uploadManagementDao = new UploadManagementDAO();
uploadManagementDao.Insert(new UploadManagement(userId, "bdl_traininfo", 1));
using (var conn = DbUtil.getConn())
{
const string query = "update bdl_traininfo set status = 3 where fk_user_id = @FK_User_Id and status = 0";
conn.Execute(query, new { FK_User_Id = userId });
}
}
public void InsertOneMacAdress(entity.Setter setter)
{
using (var conn = DbUtil.getConn())
{
const string sql = "insert into bdl_set(set_unique_id, set_language,set_photolocation, set_version,back_up) values(@Set_Unique_Id,@Set_Language, @Set_PhotoLocation, @Set_Version,@Back_Up)";
conn.Execute(sql, setter);
}
setter = getSetter();
//插入至上传表
UploadManagementDAO uploadManagementDao1 = new UploadManagementDAO();
uploadManagementDao1.Insert(new UploadManagement(setter.Pk_Set_Id, "bdl_set", 0));
}
/// <summary>
/// 设置某用户所有的暂存状态的信息为nomal状态
/// </summary>
/// <param name="userID"></param>
public void SetTmpToNomal(int userID)
{
//插入至上传表
UploadManagementDAO uploadManagementDao = new UploadManagementDAO();
uploadManagementDao.Insert(new UploadManagement(userID, "bdl_traininfo", 1));
//throw new NotImplementedException();
using (var conn = DbUtil.getConn())
{
const string query = "update bdl_traininfo set status = 0 where fk_user_id = @FK_User_Id and status = 4";
conn.Execute(query, new { FK_User_Id = userID });
}
}