public VagSendOthSt(VagWaitAdmiss vo) // for Transit { base.Create(vo); //this.id_oper = vo.id_oper; //this.num_vag_on_way = vo.num_vag_on_way; //this.dt_amkr = vo.dt_amkr; //this.id_vag = vo.id_vag; //this.num_vag = vo.num_vag; //this.rod = vo.rod; //this.dt_on_way = vo.dt_on_way; //this.owner = vo.owner; //this.own_country = vo.own_country; //this.id_godn = vo.id_godn; //this.godn = vo.godn; //this.id_gruz = vo.id_gruz; //this.gruz = vo.gruz; //this.id_gruz_amkr = vo.id_gruz_amkr; //this.gruz_amkr = vo.gruz_amkr; //this.weight_gruz = vo.weight_gruz; //this.id_ceh_gruz = vo.id_ceh_gruz; //this.ceh_gruz = vo.ceh_gruz; //this.id_tupik = vo.id_tupik; //this.tupik = vo.tupik; //this.id_gdstait = vo.id_gdstait; //this.gdstait = vo.gdstait; //this.id_nazn_country = vo.id_nazn_country; //this.nazn_country = vo.nazn_country; //this.note = vo.note; //this.outer_station = vo.outer_station; //this.cond = vo.cond; }
/// <summary> /// Отправка вагона на другую станцию, цех,тупик /// </summary> /// <param name="vagWaitAdmiss"></param> /// <param name="stat"></param> /// <param name="way"></param> /// <param name="dt_arriv"></param> /// <param name="locom1"></param> /// <param name="locom2"></param> /// <returns></returns> public int execAdmissOthStat(VagWaitAdmiss vagWaitAdmiss, Station stat, Way way, DateTime?dt_arriv, int locom1, int locom2) { string query = string.Format("RailCars.ExecOtherStation_"); SqlParameter[] sqlParameters = base.paramsForInsert((VagOperations)vagWaitAdmiss, way, 6); int i = sqlParameters.Length; if (vagWaitAdmiss.cond.Id == -1) { sqlParameters[i - 6] = new SqlParameter("@id_cond2", DBNull.Value); } else { sqlParameters[i - 6] = new SqlParameter("@id_cond2", vagWaitAdmiss.cond.Id); } if (dt_arriv < DateTime.Parse("1900-01-01 00:00") | dt_arriv == null) { sqlParameters[i - 5] = new SqlParameter("@dt_on_stat", DBNull.Value); sqlParameters[i - 4] = new SqlParameter("@dt_on_way", DBNull.Value); } else { sqlParameters[i - 5] = new SqlParameter("@dt_on_stat", dt_arriv); sqlParameters[i - 4] = new SqlParameter("@dt_on_way", dt_arriv); } if (locom1 == -1) { sqlParameters[i - 3] = new SqlParameter("@id_locom1", DBNull.Value); } else { sqlParameters[i - 3] = new SqlParameter("@id_locom1", locom1); } if (locom2 == -1) { sqlParameters[i - 2] = new SqlParameter("@id_locom2", DBNull.Value); } else { sqlParameters[i - 2] = new SqlParameter("@id_locom2", locom2); } sqlParameters[i - 1] = new SqlParameter("@new_identity", SqlDbType.Int); sqlParameters[i - 1].Direction = ParameterDirection.Output; Conn.executeScalarCommand(query, sqlParameters, true); if (sqlParameters[i - 1].Value != null) { return(int.Parse(sqlParameters[i - 1].Value.ToString())); } else { return(-1); } }
private void changeGruz(VagWaitAdmiss vag, bool isShop, SendingPoint sp, DateTime dtFromStat) { if (vag.gruz.Contains("порож") && isShop) { getLoadingData(vag, (Shop)sp, dtFromStat); } else { vag.id_gruz = 6; vag.gruz = "порож"; } }
public void getLoadingData(VagWaitAdmiss vagWaitAdmiss, Shop shop, DateTime dtFromStat) { string query = string.Format("SELECT a.*, b.id_gruz " + "FROM Loading_data_SAP a " + "left join GRUZS b on a.rodU = b.name_full and b.id_ora is not null " + "where a.vagu = @vag and @ceh like a.cehu+'%' and a.dat_dsdu >= @dt_from_way"); SqlParameter[] sqlParameters = new SqlParameter[3]; sqlParameters[0] = new SqlParameter("@vag", vagWaitAdmiss.num_vag); sqlParameters[1] = new SqlParameter("@ceh", shop.Name); if (dtFromStat < DateTime.Parse("1900-01-01 00:00")) { sqlParameters[2] = new SqlParameter("@dt_from_way", DBNull.Value); } else { sqlParameters[2] = new SqlParameter("@dt_from_way", dtFromStat.Date); } DataTable table = Conn.executeSelectQuery(query, sqlParameters).Tables[0]; try { vagWaitAdmiss.id_gruz = Int32.Parse(table.Rows[0]["id_gruz"].ToString()); vagWaitAdmiss.gruz = table.Rows[0]["rodu"].ToString(); vagWaitAdmiss.gdstait = table.Rows[0]["stnu"].ToString(); vagWaitAdmiss.weight_gruz = Double.Parse(table.Rows[0]["tonu5"].ToString()); vagWaitAdmiss.grvuSAP = table.Rows[0]["grvu"].ToString(); vagWaitAdmiss.ngruSAP = table.Rows[0]["ngru"].ToString(); } catch (Exception) { } query = string.Format("declare @id_str int " + "select @id_str = id_gdstait from GDSTAIT where name=@name " + "if (@id_str is null) " + " begin " + " insert into GDSTAIT (name) values (@name) " + " select @@IDENTITY; " + " end " + "else select @id_str"); SqlParameter[] sqlParameters2 = new SqlParameter[1]; sqlParameters2[0] = new SqlParameter("@name", vagWaitAdmiss.gdstait); try { table = Conn.executeSelectQuery(query, sqlParameters2).Tables[0]; vagWaitAdmiss.id_gdstait = Int32.Parse(table.Rows[0][0].ToString()); } catch (Exception) { } }
/// <summary> /// Выбран вагон для зачисления /// </summary> public void onVagSelect() { try { if (view.selVagCount != 0) { //if (bs2P2.DataSource == null) bs2P2.DataSource = new List<VagWaitAdmiss>(); if (view.selVagCount > 1) { for (int i = 0; i <= view.listWaitAdmiss.Count - 1; i++) { if (view.isVagSelected(i)) { if (!view.isVagColored(i)) { view.addVagToAdmFromVags(i); view.setVagColor(i, Color.Yellow); } } else { if (view.listToAdmiss()[view.listToAdmiss().Count - 1] == view.listWaitAdmiss[i]) { VagWaitAdmiss vagon = view.listWaitAdmiss[i]; view.removeFromVagToAdm(vagon); view.setVagColor(i, Color.Empty); } } } } else //if (dgv.SelectedRows.Count == 1) { if (!view.isVagColored(view.idxFirstSelVag)) { view.addVagToAdmFromVags(view.idxFirstSelVag); view.setVagColor(view.idxFirstSelVag, Color.Yellow); } } placeInRightOrder(); } } catch (Exception ex) { main.showErrorMessage(ex.Message); } }
private void getLoadingData(VagWaitAdmiss vag, Shop shop, DateTime dtFromStat) { vagWaitAdmissDB.getLoadingData(vag, shop, dtFromStat); }