public static Claim2ClaimState GetLastState(int idClaim, string sysName)
{
SqlParameter pIdClaim = new SqlParameter() { ParameterName = "id_claim", SqlValue = idClaim, SqlDbType = SqlDbType.Int };
SqlParameter pSysName = new SqlParameter() { ParameterName = "sys_name", SqlValue = sysName, SqlDbType = SqlDbType.NVarChar };
var dt = Db.Service.ExecuteQueryStoredProcedure("get_claim_last_added_claim_state", pIdClaim, pSysName);
var model = new Claim2ClaimState();
if (dt.Rows.Count > 0)
{
model = new Claim2ClaimState(dt.Rows[0]);
}
return model;
}
public static IEnumerable<Claim2ClaimState> GetList(int idClaim, int? topRows)
{
SqlParameter pIdClaim = new SqlParameter() { ParameterName = "id_claim", SqlValue = idClaim, SqlDbType = SqlDbType.Int };
SqlParameter pTopRows = new SqlParameter() { ParameterName = "top_rows", SqlValue = topRows, SqlDbType = SqlDbType.Int };
var dt = Db.Service.ExecuteQueryStoredProcedure("get_claim2claim_state_list", pIdClaim, pTopRows);
var lst = new List<Claim2ClaimState>();
foreach (DataRow row in dt.Rows)
{
var model = new Claim2ClaimState(row);
lst.Add(model);
}
return lst;
}
public void SaveStateStep(int stateId, string descr = null, bool saveStateInfo = true, int? idZipClaim = null)
{
if (stateId == 0) throw new ArgumentException("Не указан статус для сохранения в лестнице статусов.");
var c2Cs = new Claim2ClaimState();
c2Cs.IdClaim = Id;
c2Cs.IdClaimState = stateId;
c2Cs.CurUserAdSid = CurUserAdSid;
c2Cs.ZipClaimId = idZipClaim;
if (saveStateInfo)
{
//c2Cs.Descr = Descr;
//if (String.IsNullOrEmpty(Descr))
//{
// Descr += "\r\n";
//}
c2Cs.Descr = descr;
if (IdWorkType.HasValue) c2Cs.IdWorkType = IdWorkType.Value;
c2Cs.SpecialistSid = SpecialistSid;
if (ServiceSheet4Save != null && ServiceSheet4Save.Id > 0)
{
c2Cs.IdServiceSheet = ServiceSheet4Save.Id;
}
}
c2Cs.Save();
}
