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