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