public frmSelectService(SqlConnection db_connection, bool add_to_order, string OrderNo)
{
InitializeComponent();
this.Text = "Выбор услуги";
this.db_connection = db_connection;
this.add_to_order = add_to_order;
this.orderno = OrderNo;
ReBild();
fRow = new FilterRow(gridServices);
}
public frmSelectClient(SqlConnection db_connection, UserInfo usr, string title)
{
InitializeComponent();
this.Text = title;
this.db_connection = db_connection;
this.usr = usr;
FilterRow fRow = new FilterRow(GridClient);
//ReBildTable();
}
public frmSelectClient(SqlConnection db_connection, UserInfo usr)
{
InitializeComponent();
this.Text = "Выбор клиента";
this.db_connection = db_connection;
this.usr = usr;
FilterRow fRow = new FilterRow(GridClient);
//ReBildTable();
}
//////////////////////////////////////////////////////////////////////////
public frmStep2()
{
InitializeComponent();
this.Text = "Мастер приемки заказов: шаг 2";
fRow = new FilterRow(GridClient);
}
private void frmPointTable_Load(object sender, EventArgs e)
{
FilterR = new FilterRow(gridData);
LoadData();
}
private void frmPaymentTable_Load(object sender, EventArgs e)
{
if (usr.prmCanEditPayments)
{
btnAddPayment.Enabled = true;
btnDeletePayment.Enabled = true;
btnEditPayment.Enabled = true;
}
else
{
btnAddPayment.Enabled = false;
btnDeletePayment.Enabled = false;
btnEditPayment.Enabled = false;
}
ResetFilter();
FilterR = new FilterRow(GridPayment);
LoadGrid();
if (this.only)
{
txtUser.Enabled = false;
}
else
{
txtUser.Enabled = true;
}
}
private void frmDefectTable_Load(object sender, EventArgs e)
{
FilterR = new FilterRow(gridData);
date1.Value = DateTime.Now.AddMonths(-1);
date2.Value = DateTime.Now.AddDays(5);
SqlCommand t = new SqlCommand("Select [id_user], [name] FROM [user] ORDER BY [name]", db_connection);
DataTable dt1 = new DataTable("t");
DataTable dt2 = new DataTable("t");
SqlDataAdapter tda = new SqlDataAdapter(t);
tda.Fill(dt1);
tda.Fill(dt2);
DataRow _dr1 = dt1.NewRow();
_dr1[0] = "-1";
_dr1[1] = "< не выбрано >";
DataRow _dr2 = dt2.NewRow();
_dr2[0] = "-1";
_dr2[1] = "< не выбрано >";
dt1.Rows.InsertAt(_dr1, 0);
dt2.Rows.InsertAt(_dr2, 0);
txtU2.DataSource = dt1;
txtU1.DataSource = dt2;
txtU2.DisplayMember = "name";
txtU1.DisplayMember = "name";
txtU2.ValueMember = "id_user";
txtU1.ValueMember = "id_user";
t = new SqlCommand("SELECT defect_code, defect_name FROM defect ORDER BY defect_name", db_connection);
tda = new SqlDataAdapter(t);
DataTable dt3 = new DataTable("t");
tda.Fill(dt3);
DataRow _dr3 = dt3.NewRow();
_dr3[0] = "-1";
_dr3[1] = "< не выбрано >";
dt3.Rows.InsertAt(_dr3, 0);
txtType.DataSource = dt3;
txtType.DisplayMember = "defect_name";
txtType.ValueMember = "defect_code";
t = new SqlCommand("SELECT id_good, name FROM good ORDER BY name", db_connection);
tda = new SqlDataAdapter(t);
DataTable dt4 = new DataTable("t");
tda.Fill(dt4);
DataRow _dr4 = dt4.NewRow();
_dr4[0] = "-1";
_dr4[1] = "< не выбрано >";
dt4.Rows.InsertAt(_dr4, 0);
txtServ.DataSource = dt4;
txtServ.DisplayMember = "name";
txtServ.ValueMember = "id_good";
LoadData(0);
}
