public int LoadStartStatusPID(string entityprefix, int defaultB02ID)
{
BO.COM.GetInteger c = _db.Load <BO.COM.GetInteger>("SELECT b02ID as Value FROM b02Status WHERE b02StartFlag=1 AND b02Entity like @prefix", new { prefix = entityprefix });
if (c == null || c.Value == 0)
{
return(defaultB02ID);
}
return(c.Value);
}
public bool UpdateCloudID(int intP28ID, string strCloudID)
{
if (string.IsNullOrEmpty(strCloudID) == false)
{
BO.COM.GetInteger c = _db.Load <BO.COM.GetInteger>("select p28ID as Value FROM p28Company WHERE p28CloudID=@cloudid AND p28ID<>@pid", new { cloudid = strCloudID, pid = intP28ID });
if (c != null)
{
_mother.CurrentUser.AddMessage("Zadané cloud-id je již obsazenou jiným subjektem.");
return(false);
}
}
if (strCloudID == "-1")
{
strCloudID = null;
}
return(_db.RunSql("UPDATE p28Company SET p28CloudID=@cloudid WHERE p28ID=@pid", new { cloudid = strCloudID, pid = intP28ID }));
}
