private void frmF3_Load(object sender, EventArgs e)
{
Tag = IdF3;
WithSave = true;
my.RdStream(NMrab, my.Login + "ActsZak1.txt");
RdWr(my.Dostup);
listBox1.SelectedIndex = listBox1.Items.Count - 1;
Edneeis.Controls.MultiColumnComboBox.Column i1 = new Edneeis.Controls.MultiColumnComboBox.Column();
i1.ColumnMember = "PersName";
i1.AutoSize = true;
i1.Header = "";
FromIsp.Columns.Add(i1);
Edneeis.Controls.MultiColumnComboBox.Column i2 = new Edneeis.Controls.MultiColumnComboBox.Column();
i2.ColumnMember = "PostName";
i2.AutoSize = false;
i2.Header = "";
i2.Width = 200;
FromIsp.Columns.Add(i2);
FromIsp.ShowColumnHeader = false;
FromIsp.ShowColumns = true;
Edneeis.Controls.MultiColumnComboBox.Column i3 = new Edneeis.Controls.MultiColumnComboBox.Column();
i3.ColumnMember = "PersName";
i3.AutoSize = true;
i3.Header = "";
FromZak.Columns.Add(i3);
Edneeis.Controls.MultiColumnComboBox.Column i4 = new Edneeis.Controls.MultiColumnComboBox.Column();
i4.ColumnMember = "PostName";
i4.AutoSize = false;
i4.Header = "";
i4.Width = 200;
FromZak.Columns.Add(i4);
FromZak.ShowColumnHeader = false;
FromZak.ShowColumns = true;
}
private void frmActsSub_Load(object sender, EventArgs e)
{
//Set objRowLoop = new clsRowLoop();
string strsql = "";
//SSRow Row1 = null;
//ПриОткрытии = true;
this.Top = 0;
this.Left = 0;
switch (my.Nbut)
{
case 4:
Text = "Субподряд " + my.UpredName;
gp = my.Upred;
break;
case 0:
gp = my.Szap;
break;
default:
my.sc.CommandText = "SELECT Name, pred FROM dbo.VidGPDog WHERE IdVidDog = " + my.Nbut.ToString();
my.cn.Open();
SqlDataReader dr = my.sc.ExecuteReader();
if (!dr.Read())
{
MessageBox.Show(@"Нет данных по выбранному договору!");
my.cn.Close();
}
else
{
Text = "Субподряд " + dr[0].ToString().Substring(10, dr[0].ToString().Length - 10);
gp = dr[1].ToString();
my.cn.Close();
dr.Close();
}
break;
}
//Set rs = null;
//this.ркн_ТекМес = true;
rbTekMes.Checked = true;
strsql = "SELECT iddog,Zak, RegNomer, ZakName, IspName, Date_1,Isp,PredmetDog,Srok FROM v_DogForAktSub WHERE ((Zak='" + ((gp == "1726" | gp == "1725") ? "002" : gp) + "' and Vnut=1)";
strsql = strsql + " or (Zak='" + gp + "' and VneshDog=1)) order by ZakName, IspName,RegNomer";
//rs.CursorLocation = adUseClient;
SqlDataAdapter sda = new SqlDataAdapter(strsql, my.sconn);
DataSet ds = new DataSet();
sda.Fill(ds);
idDog.DataSource = ds.Tables[0];
idDog.ValueMember = "IdDog";
idDog.DisplayMember = "RegNomer";
Edneeis.Controls.MultiColumnComboBox.Column i3 = new Edneeis.Controls.MultiColumnComboBox.Column();
i3.ColumnMember = "RegNomer";
i3.AutoSize = true;
this.idDog.Columns.Add(i3);
Edneeis.Controls.MultiColumnComboBox.Column i4 = new Edneeis.Controls.MultiColumnComboBox.Column();
i4.ColumnMember = "ZakName";
i4.Width = 100;
this.idDog.Columns.Add(i4);
Edneeis.Controls.MultiColumnComboBox.Column i5 = new Edneeis.Controls.MultiColumnComboBox.Column();
i5.ColumnMember = "IspName";
i5.Width = 100;
this.idDog.Columns.Add(i5);
Edneeis.Controls.MultiColumnComboBox.Column i6 = new Edneeis.Controls.MultiColumnComboBox.Column();
i6.ColumnMember = "Date_1";
i6.Width = 100;
this.idDog.Columns.Add(i6);
Edneeis.Controls.MultiColumnComboBox.Column i7 = new Edneeis.Controls.MultiColumnComboBox.Column();
i7.ColumnMember = "PredmetDog";
i7.Width = 400;
this.idDog.Columns.Add(i7);
idDog.ShowColumns = true;
sda.Dispose();
ds.Dispose();
idDog.SelectedValue = 0;
my.FillDC(idIstFin, 18, "");
//DgvActs.DataSource = ds.Tables[0];
SpisokObj();
SpisokUsF2();
SelAkts();
checkBox1_CheckedChanged(null, null);
RdWr(my.Dostup);
}
