private void loadData2()
{
if (_dgv2.Columns.Count == 0)
{
_dgv2.Columns.Add("user_id", "");
_dgv2.Columns.Add("user_name", "ФИО");
_dgv2.Columns.Add("ur_id", "");
_dgv2.Columns.Add("role_name", "Роль");
_dgv2.Columns.Add("user_year1", "");
_dgv2.Columns.Add("user_year2", "");
_dgv2.Columns["user_id"].Visible = false;
_dgv2.Columns["ur_id"].Visible = false;
_dgv2.Columns["user_name"].Width = 150;
_dgv2.Columns["role_name"].Width = 200;
_dgv2.Columns["user_year1"].Visible = false;
_dgv2.Columns["user_year2"].Visible = false;
}
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelUsers2 @p1, @p2, @p3", cbRoles.SelectedValue, cbRegions.SelectedValue, cbSDiv.SelectedItem);
int i = 0;
_dgv2.Rows.Clear();
if (dt1 != null)
{
foreach (DataRow row in dt1.Rows)
{
_dgv2.Rows.Add(row.ItemArray);
if (Convert.ToInt32(row.ItemArray[5].ToString()) < globalData.CurDate.Year)
{
_dgv2.Rows[i].DefaultCellStyle.BackColor = bbgray4;
}
i++;
}
}
}
private void searchRepDist()
{
sql sql1 = new sql();
DataTable dt1 = new DataTable();
dt1 = sql1.GetRecords("exec SelRepDist @p1, @p2, @p3",
cbRepD.SelectedValue,
dateTimePicker1.Value.Year.ToString() + "-" + dateTimePicker1.Value.Month.ToString() + "-01",
dateTimePicker2.Value.Year.ToString() + "-" + dateTimePicker2.Value.Month.ToString() + "-01");
dgvRepDistUpd.DataSource = dt1;
if (dt1 == null)
{
dgvRepDistUpd.Rows.Clear();
return;
}
if (globalData.UserID != 1 && globalData.UserID != 258)
{
dgvRepDistUpd.Columns["rd_id"].Visible = false;
dgvRepDistUpd.Columns["db_id"].Visible = false;
}
else
{
dgvRepDistUpd.Columns["rd_id"].Visible = true;
dgvRepDistUpd.Columns["db_id"].Visible = true;
}
dgvRepDistUpd.Columns["rd_date"].HeaderText = "Дата";
dgvRepDistUpd.Columns["cust_code"].HeaderText = "Код дистрибьютора";
dgvRepDistUpd.Columns["cust_name"].HeaderText = "Название дистрибьютора";
dgvRepDistUpd.Columns["subreg_nameRus"].HeaderText = "Субрегион";
dgvRepDistUpd.Columns["mat_code"].HeaderText = "Артикул";
dgvRepDistUpd.Columns["mat_name"].HeaderText = "Название продукции";
dgvRepDistUpd.Columns["rd_lpu"].HeaderText = "Покупатель";
dgvRepDistUpd.Columns["rd_count"].HeaderText = "Количество";
}
/*sba_code*/
int InsBD(int sbaCode)
{
string _sba = "0";
int _sdiv = 0;
sql sql1 = new sql();
if (sbaCode < 0)
{
if (sbaCode == -1)
{
_sdiv = 1;
}
if (sbaCode == -2)
{
_sdiv = 2;
}
if (sbaCode == -3)
{
_sdiv = 3;
}
}
else
{
if (sbaCode < 10)
{
_sba = "0" + sbaCode.ToString();
}
else
{
_sba = sbaCode.ToString();
}
}
sql1.GetRecords("exec InsMASBA @p1, @p2, @p3, @p4, @p5", index, db, _sba, _sdiv, kvart);
return(1);
}
private void btnSave_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
int count = 1;
double sumEuro = 0, sumRub = 0;
if (globalData.Div == "AE")
{
if (tbPriceEuro.Text != String.Empty)
{
if (tbCount.Text == "0")
{
count = 1;
}
else if (tbCount.Text != String.Empty)
{
count = Convert.ToInt32(tbCount.Text);
}
if (tbPriceEuro.Text != String.Empty)
{
sumEuro = Convert.ToDouble(tbPriceEuro.Text);
}
if (tbPriceRub.Text != String.Empty)
{
sumRub = Convert.ToDouble(tbPriceRub.Text);
}
if (repID == 0)
{
if (cbNom.SelectedValue == null)
{
sql1.GetRecords("exec InsReportKos 0, 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, 0, @p8, @p9, @p10, @p11, @p12, @p13, @p14", globalData.db_id, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString(), globalData.Div);
}
else
{
sql1.GetRecords("exec InsReportKos 0, 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", globalData.db_id, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString(), globalData.Div);
}
MessageBox.Show("Косвенная продажа добавлена", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (cbNom.SelectedValue == null)
{
sql1.GetRecords("exec UpdReportKos @p1, @p2, @p3, @p4, @p5, @p6, @p7, 0, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", repID, idDB, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString());
}
else
{
sql1.GetRecords("exec UpdReportKos @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", repID, idDB, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString());
}
MessageBox.Show("Косвенная продажа обновлена", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
globalData.load = true;
Close();
return;
}
tbDist.Text = "";
if (tbCount.Text != String.Empty)
{
tbCount.Text = "";
}
if (tbPriceEuro.Text != String.Empty)
{
tbPriceEuro.Text = "";
}
if (tbPriceRub.Text != String.Empty)
{
tbPriceRub.Text = "";
}
globalData.load = true;
return;
}
if ((tbPriceRub.Text != String.Empty) && (tbRate.Text != String.Empty))
{
if (tbCount.Text == "0")
{
count = 1;
}
else if (tbCount.Text != String.Empty)
{
count = Convert.ToInt32(tbCount.Text);
}
if (tbPriceEuro.Text != String.Empty)
{
sumEuro = Convert.ToDouble(tbPriceEuro.Text);
}
if (tbPriceRub.Text != String.Empty)
{
sumRub = Convert.ToDouble(tbPriceRub.Text);
}
if (repID == 0)
{
sql1.GetRecords("exec InsReportKos 0, 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", globalData.db_id, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString(), globalData.Div);
}
else
{
sql1.GetRecords("exec UpdReportKos @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16", repID, idDB, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString());
MessageBox.Show("Косвенная продажа обновлена", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
globalData.load = true;
Close();
return;
}
tbDist.Text = "";
if (tbCount.Text != String.Empty)
{
tbCount.Text = "";
}
if (tbPriceEuro.Text != String.Empty)
{
tbPriceEuro.Text = "";
}
if (tbPriceRub.Text != String.Empty)
{
tbPriceRub.Text = "";
}
MessageBox.Show("Косвенная продажа добавлена", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
globalData.load = true;
return;
}
else if (tbPriceRub.Text == String.Empty)
{
MessageBox.Show("Для сохранения необходимо ввести цену.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
if ((tbCount.Text != String.Empty) || (tbPriceEuro.Text != String.Empty))
{
if (tbCount.Text == "0")
{
count = 1;
}
else if (tbCount.Text != String.Empty)
{
count = Convert.ToInt32(tbCount.Text);
}
if (tbPriceEuro.Text != String.Empty)
{
sumEuro = Convert.ToDouble(tbPriceEuro.Text);
}
if (tbPriceRub.Text != String.Empty)
{
sumRub = Convert.ToDouble(tbPriceRub.Text);
}
if (repID == 0)
{
if (globalData.Div == "OM")
{
if (cbNom.SelectedValue == null)
{
sql1.GetRecords("exec InsReportKos 0, 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, 0, @p8, @p9, @p10, @p11, @p12, 0, @p13", globalData.db_id, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, globalData.Div);
}
else
{
sql1.GetRecords("exec InsReportKos 0, 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, 0, @p14", globalData.db_id, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, globalData.Div);
}
}
else
{
if (cbNom.SelectedValue == null)
{
sql1.GetRecords("exec InsReportKos 0, 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, 0, @p8, @p9, @p10, @p11, @p12, @p13, @p14", globalData.db_id, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString(), globalData.Div);
}
else
{
sql1.GetRecords("exec InsReportKos 0, 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", globalData.db_id, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString(), globalData.Div);
}
}
}
else
{
if (globalData.Div == "OM")
{
if (cbNom.SelectedValue == null)
{
sql1.GetRecords("exec UpdReportKos @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, 0, @p10, @p11, @p12, @p13, 0", repID, idDB, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2);
}
else
{
sql1.GetRecords("exec UpdReportKos @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, 0", repID, idDB, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2);
}
}
else
if (cbNom.SelectedValue != null)
{
sql1.GetRecords("exec UpdReportKos @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", repID, idDB, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), cbNom.SelectedValue.ToString(), count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString());
}
else
{
sql1.GetRecords("exec UpdReportKos @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", repID, idDB, dateTimePicker1.Value, cbComp.SelectedValue.ToString(), cbCust.SelectedValue.ToString(), tbDist.Text, cbRegCust.SelectedValue.ToString(), cbSubReg.SelectedValue.ToString(), cbGroup.SelectedValue.ToString(), 0, count, sumEuro, sumRub, globalData.UserID2, cbLPU.SelectedValue.ToString());
}
MessageBox.Show("Косвенная продажа обновлена", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
globalData.load = true;
Close();
return;
}
tbDist.Text = "";
if (tbCount.Text != String.Empty)
{
tbCount.Text = "";
}
if (tbPriceEuro.Text != String.Empty)
{
tbPriceEuro.Text = "";
}
if (tbPriceRub.Text != String.Empty)
{
tbPriceRub.Text = "";
}
MessageBox.Show("Косвенная продажа добавлена", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
globalData.load = true;
}
else if (tbPriceEuro.Text == String.Empty)
{
MessageBox.Show("Для сохранения необходимо ввести цену.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Для сохранения необходимо ввести количество.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static DataTable getDataTable()
{
sql sql1 = new sql();
return(sql1.GetRecords("exec SelActivity"));
}
public static DataTable getDataTable()
{
sql sql1 = new sql();
return(sql1.GetRecords("exec Region_Select"));
}
void UpdPlan()
{
sql sql1 = new sql();
sql1.GetRecords("exec UpdMarkActPlan @p1, @p2, @p3, @p4", index, db, tbSum.Text.Trim(), kvart);
}
private int Connect()
{
globalData.UserID = 0;
globalData.UserID2 = 0;
sql sql1 = new sql();
if (sql1 == null)
{
DialogResult dr = MessageBox.Show("Не удалось подключится к серверу. Проверьте наличие интеренет-соединения.", "Ошибка", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
if (dr == System.Windows.Forms.DialogResult.Retry)
{
return(1);
}
else
{
return(0);
}
}
String s1 = "";
if ((globalData.admin) && (globalData.Login != String.Empty))
{
s1 = globalData.Login;
}
else
{
s1 = WindowsIdentity.GetCurrent().Name.Replace("\\", "-");
String[] s2 = s1.Split('-');
s1 = s2[1];
}
//s1 = "prokekru";
DataTable dt1 = new DataTable();
dt1 = sql1.GetRecords("exec UserLogin @p1, @p2", s1, globalData.UserAccess);
if (dt1.Rows.Count == 0)
{
//MessageBox.Show("Пользователь не найден в системе. Вход будет произведён под учётной записью гостя.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
s1 = "anonimus";
}
if (s1 == "anonimus")
{
dt1 = sql1.GetRecords("exec UserLogin @p1, @p2", s1, globalData.UserAccess);
}
if (dt1.Rows.Count == 0)
{
MessageBox.Show("Не удалось войти в систему.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
else
{
String str = dt1.Rows[0].ItemArray[0].ToString();
globalData.UserID = Convert.ToInt32(str);
str = dt1.Rows[0].ItemArray[1].ToString();
globalData.UserAccess = Convert.ToInt32(str);
globalData.fp = Convert.ToInt32(dt1.Rows[0].ItemArray[4]);
globalData.UserName = dt1.Rows[0].ItemArray[3].ToString();
str = "Здравствуйте, " + globalData.UserName + ".";
if ((globalData.UserAccess == 1) && (globalData.UserID == 1))
{
str = "Рад видеть тебя, мой Создатель.";
}
str += " Последний раз вы были в системе: " + sql1.GetRecordsOne("exec LastEvent @p1", globalData.UserID);
lbUserName.Text = str;
globalData.Login = s1;
}
if (globalData.UserAccess == 1)
{
globalData.admin = true;
btnFR.Enabled = true;
}
if (globalData.UserID == 0)
{
this.Close();
}
return(0);
}
internal void Delete()
{
sql1.GetRecords("exec Answer_Delete @p1", id);
}
private void btnSave_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
globalData.load = true;
DataTable dt1 = new DataTable();
string lpu = String.Empty;
string reg = String.Empty;
if (tbRegion.Visible == false)
{
lpu = "-3";
reg = cbLPU.SelectedValue.ToString();
}
else
{
lpu = cbLPU.SelectedValue.ToString();
reg = tbRegion.Text;
}
if (index == 0)
{
dt1 = sql1.GetRecords("exec InsMarkAct 0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13",
tbName.Text, globalData.UserID2, globalData.Div, reg, lpu, tbPlan1.Text.Replace(",", "."), tbPlan2.Text.Replace(",", "."), tbPlan3.Text.Replace(",", "."), tbPlan4.Text.Replace(",", "."),
tbFact1.Text.Replace(",", "."), tbFact2.Text.Replace(",", "."), tbFact3.Text.Replace(",", "."), tbFact4.Text.Replace(",", "."));
if (dt1 == null)
{
MessageBox.Show("Не удалось добавить маркетинговое мероприятие.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Маркетинговое мероприятие добавлено.", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.Close();
}
else
{
dt1 = sql1.GetRecords("exec UpdMarkAct @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14",
index,
db,
globalData.UserID2,
tbName.Text,
lpu,
reg,
tbPlan1.Text.Replace(",", "."),
tbPlan2.Text.Replace(",", "."),
tbPlan3.Text.Replace(",", "."),
tbPlan4.Text.Replace(",", "."),
tbFact1.Text.Replace(",", "."),
tbFact2.Text.Replace(",", "."),
tbFact3.Text.Replace(",", "."),
tbFact4.Text.Replace(",", "."));
if (dt1 == null)
{
MessageBox.Show("Не удалось отредактировать маркетинговое мероприятие.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Маркетинговое мероприятие обновлено.", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.Close();
}
}
private void loadData2()
{
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelUserByID @p1", globalData.UserID2);
lbUserName.Text = dt1.Rows[0].ItemArray[1].ToString();
label3.Text = "Регион";
cbLPU.DataSource = sql1.GetRecords("exec SelRegPM @p1", globalData.UserID2);
cbLPU.DisplayMember = "reg_nameRus";
cbLPU.ValueMember = "reg_id";
label4.Visible = false;
tbRegion.Visible = false;
tbPlan1.Text = String.Empty;
tbPlan2.Text = String.Empty;
tbPlan3.Text = String.Empty;
tbPlan4.Text = String.Empty;
tbFact1.Text = String.Empty;
tbFact2.Text = String.Empty;
tbFact3.Text = String.Empty;
tbFact4.Text = String.Empty;
if (index != 0)
{
dt1 = sql1.GetRecords("exec SelMarkActByID @p1, @p2", index, db);
tbName.Text = dt1.Rows[0].ItemArray[1].ToString();
cbLPU.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[4]);
if (dt1.Rows[0].ItemArray[15].ToString() == "1")
{
tbPlan1.Enabled = true;
tbPlan2.Enabled = true;
tbPlan3.Enabled = true;
tbPlan4.Enabled = true;
cbLPU.Enabled = true;
}
else
{
tbPlan1.Enabled = false;
tbPlan2.Enabled = false;
tbPlan3.Enabled = false;
tbPlan4.Enabled = false;
cbLPU.Enabled = false;
}
if (dt1.Rows[0].ItemArray[17].ToString() == "1")
{
tbFact1.Enabled = true;
tbFact2.Enabled = true;
tbFact3.Enabled = true;
tbFact4.Enabled = true;
btnSave.Enabled = true;
}
else
{
tbFact1.Enabled = false;
tbFact2.Enabled = false;
tbFact3.Enabled = false;
tbFact4.Enabled = false;
btnSave.Enabled = false;
}
if (dt1.Rows[0].ItemArray[7].ToString() != "0")
{
tbPlan1.Text = dt1.Rows[0].ItemArray[7].ToString();
}
if (dt1.Rows[0].ItemArray[8].ToString() != "0")
{
tbPlan2.Text = dt1.Rows[0].ItemArray[8].ToString();
}
if (dt1.Rows[0].ItemArray[9].ToString() != "0")
{
tbPlan3.Text = dt1.Rows[0].ItemArray[9].ToString();
}
if (dt1.Rows[0].ItemArray[10].ToString() != "0")
{
tbPlan4.Text = dt1.Rows[0].ItemArray[10].ToString();
}
if (dt1.Rows[0].ItemArray[11].ToString() != "0")
{
tbFact1.Text = dt1.Rows[0].ItemArray[11].ToString();
}
if (dt1.Rows[0].ItemArray[12].ToString() != "0")
{
tbFact2.Text = dt1.Rows[0].ItemArray[12].ToString();
}
if (dt1.Rows[0].ItemArray[13].ToString() != "0")
{
tbFact3.Text = dt1.Rows[0].ItemArray[13].ToString();
}
if (dt1.Rows[0].ItemArray[14].ToString() != "0")
{
tbFact4.Text = dt1.Rows[0].ItemArray[14].ToString();
}
//tbRegion.Text = sql1.GetRecordsOne("exec SelRegByLPUid @p1", cbLPU.SelectedValue);
}
else
{
tbName.Text = String.Empty;
//tbRegion.Text = sql1.GetRecordsOne("exec SelRegByLPUid @p1", cbLPU.SelectedValue);
cbLPU.Enabled = true;
}
}
public AddEditUser(string uid, string urid, string sdiv)
{
InitializeComponent();
sdiv_id = sdiv;
loadData();
user_id = uid;
userRight_id = urid;
if (urid == "0")
{
groupBox1.Enabled = false;
groupBox2.Enabled = false;
groupBox3.Enabled = false;
groupBox4.Enabled = false;
cbRD.Enabled = false;
label1.Enabled = false;
}
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelUserByID @p1, @p2", uid, urid);
tbUserName.Text = dt1.Rows[0].ItemArray[1].ToString();
tbLogin.Text = dt1.Rows[0].ItemArray[2].ToString();
cbRole.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[3].ToString());
tbEmail.Text = dt1.Rows[0].ItemArray[4].ToString();
tbYear1.Text = dt1.Rows[0].ItemArray[5].ToString();
tbYear2.Text = dt1.Rows[0].ItemArray[6].ToString();
switch (dt1.Rows[0].ItemArray[7].ToString())
{
case "0":
{
rbAPRead.Checked = true;
break;
}
case "1":
{
rbAPEdit.Checked = true;
break;
}
}
switch (dt1.Rows[0].ItemArray[8].ToString())
{
case "0":
{
rbAccRead.Checked = true;
break;
}
case "1":
{
rbAccEdit.Checked = true;
break;
}
}
switch (dt1.Rows[0].ItemArray[9].ToString())
{
case "0":
{
rbMARead.Checked = true;
break;
}
case "1":
{
rbMAEdit.Checked = true;
break;
}
case "2":
{
rbMAAddEdit.Checked = true;
break;
}
}
if (dt1.Rows[0].ItemArray[10].ToString() == "0")
{
chbPS.Checked = false;
}
else
{
chbPS.Checked = true;
}
if (dt1.Rows[0].ItemArray[11].ToString() == "0")
{
chbDyn.Checked = false;
}
else
{
chbDyn.Checked = true;
}
cbRD.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[12].ToString());
if (dt1.Rows[0].ItemArray[13].ToString() == "0")
{
chbDismissed.Checked = false;
}
else
{
chbDismissed.Checked = true;
}
}
private void loadData()
{
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelUserByID @p1", globalData.UserID2);
lbUserName.Text = dt1.Rows[0].ItemArray[1].ToString();
cbLPU.DataSource = sql1.GetRecords("exec SelLPU_MA @p1, @p2, @p3, @p4", globalData.UserID2, globalData.Region, globalData.Div, globalData.CurDate.Year);
cbLPU.DisplayMember = "lpu_sname";
cbLPU.ValueMember = "ulpu_id";
tbPlan1.Text = String.Empty;
tbPlan2.Text = String.Empty;
tbPlan3.Text = String.Empty;
tbPlan4.Text = String.Empty;
tbFact1.Text = String.Empty;
tbFact2.Text = String.Empty;
tbFact3.Text = String.Empty;
tbFact4.Text = String.Empty;
if (index != 0)
{
dt1 = sql1.GetRecords("exec SelMarkActByID @p1, @p2", index, db);
tbName.Text = dt1.Rows[0].ItemArray[1].ToString();
cbLPU.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[5]);
if (dt1.Rows[0].ItemArray[15].ToString() == "1")
{
tbPlan1.Enabled = true;
tbPlan2.Enabled = true;
tbPlan3.Enabled = true;
tbPlan4.Enabled = true;
cbLPU.Enabled = true;
}
else
{
tbPlan1.Enabled = false;
tbPlan2.Enabled = false;
tbPlan3.Enabled = false;
tbPlan4.Enabled = false;
cbLPU.Enabled = false;
}
if (dt1.Rows[0].ItemArray[17].ToString() == "1")
{
tbFact1.Enabled = true;
tbFact2.Enabled = true;
tbFact3.Enabled = true;
tbFact4.Enabled = true;
btnSave.Enabled = true;
}
else
{
tbFact1.Enabled = false;
tbFact2.Enabled = false;
tbFact3.Enabled = false;
tbFact4.Enabled = false;
btnSave.Enabled = false;
}
if (dt1.Rows[0].ItemArray[7].ToString() != "0")
{
tbPlan1.Text = dt1.Rows[0].ItemArray[7].ToString();
}
if (dt1.Rows[0].ItemArray[8].ToString() != "0")
{
tbPlan2.Text = dt1.Rows[0].ItemArray[8].ToString();
}
if (dt1.Rows[0].ItemArray[9].ToString() != "0")
{
tbPlan3.Text = dt1.Rows[0].ItemArray[9].ToString();
}
if (dt1.Rows[0].ItemArray[10].ToString() != "0")
{
tbPlan4.Text = dt1.Rows[0].ItemArray[10].ToString();
}
if (dt1.Rows[0].ItemArray[11].ToString() != "0")
{
tbFact1.Text = dt1.Rows[0].ItemArray[11].ToString();
}
if (dt1.Rows[0].ItemArray[12].ToString() != "0")
{
tbFact2.Text = dt1.Rows[0].ItemArray[12].ToString();
}
if (dt1.Rows[0].ItemArray[13].ToString() != "0")
{
tbFact3.Text = dt1.Rows[0].ItemArray[13].ToString();
}
if (dt1.Rows[0].ItemArray[14].ToString() != "0")
{
tbFact4.Text = dt1.Rows[0].ItemArray[14].ToString();
}
tbRegion.Text = sql1.GetRecordsOne("exec SelRegByLPUid @p1", cbLPU.SelectedValue);
}
else
{
tbName.Text = String.Empty;
tbRegion.Text = sql1.GetRecordsOne("exec SelRegByLPUid @p1", cbLPU.SelectedValue);
cbLPU.Enabled = true;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
int ap;
if (rbAPRead.Checked)
{
ap = 0;
}
else if (rbAPEdit.Checked)
{
ap = 1;
}
else
{
ap = -1;
}
int acc;
if (rbAccRead.Checked)
{
acc = 0;
}
else if (rbAccEdit.Checked)
{
acc = 1;
}
else
{
acc = -1;
}
int ma;
if (rbMARead.Checked)
{
ma = 0;
}
else if (rbMAEdit.Checked)
{
ma = 1;
}
else if (rbMAAddEdit.Checked)
{
ma = 2;
}
else
{
ma = -1;
}
int ps = 0;
if (chbPS.Checked)
{
ps = 1;
}
int dyn = 0;
if (chbDyn.Checked)
{
dyn = 1;
}
int dis = 0;
if (chbDismissed.Checked)
{
dis = 1;
}
if (user_id == "0")
{
sql1.GetRecords("exec InsUser @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9", tbUserName.Text, tbLogin.Text, cbRole.SelectedValue, tbEmail.Text, tbYear1.Text, tbYear2.Text, ap, acc, ma);
MessageBox.Show("Пользователь добавлен", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbUserName.Text = "";
tbLogin.Text = "";
}
else
{
sql1.GetRecords("exec UpdUser @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15", user_id, tbUserName.Text, tbLogin.Text, cbRole.SelectedValue, tbEmail.Text, cbRD.SelectedValue, tbYear1.Text, tbYear2.Text, userRight_id, ap, acc, ma, ps, dyn, dis);
MessageBox.Show("Информация по пользователю обновлена", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
globalData.update = true;
}
private void loadData()
{
setButtonColor();
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelCustomers @p1", new1);
if (dt1.Rows.Count > 0)
{
SortOrder s1 = SortOrder.None;
SortOrder s2 = SortOrder.None;
SortOrder s3 = SortOrder.None;
SortOrder s4 = SortOrder.None;
SortOrder s5 = SortOrder.None;
SortOrder s6 = SortOrder.None;
if (_dgv1.Columns.Count > 0)
{
s1 = _dgv1.Columns["cust_code"].HeaderCell.SortGlyphDirection;
s2 = _dgv1.Columns["cust_name"].HeaderCell.SortGlyphDirection;
s3 = _dgv1.Columns["cust_ShipTo"].HeaderCell.SortGlyphDirection;
s4 = _dgv1.Columns["cust_payer"].HeaderCell.SortGlyphDirection;
s5 = _dgv1.Columns["cust_plant"].HeaderCell.SortGlyphDirection;
s6 = _dgv1.Columns["cust_DistChan"].HeaderCell.SortGlyphDirection;
}
_dgv1.DataSource = dt1;
if (s1 != SortOrder.None)
{
_dgv1.Columns["cust_code"].HeaderCell.SortGlyphDirection = s1;
if (s1 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["cust_code"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["cust_code"], ListSortDirection.Descending);
}
}
if (s2 != SortOrder.None)
{
_dgv1.Columns["cust_name"].HeaderCell.SortGlyphDirection = s2;
if (s2 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["cust_name"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["cust_name"], ListSortDirection.Descending);
}
}
if (s3 != SortOrder.None)
{
_dgv1.Columns["cust_ShipTo"].HeaderCell.SortGlyphDirection = s3;
if (s3 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["cust_ShipTo"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["cust_ShipTo"], ListSortDirection.Descending);
}
}
if (s4 != SortOrder.None)
{
_dgv1.Columns["cust_payer"].HeaderCell.SortGlyphDirection = s4;
if (s4 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["cust_payer"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["cust_payer"], ListSortDirection.Descending);
}
}
if (s5 != SortOrder.None)
{
_dgv1.Columns["cust_plant"].HeaderCell.SortGlyphDirection = s5;
if (s5 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["cust_plant"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["cust_plant"], ListSortDirection.Descending);
}
}
if (s6 != SortOrder.None)
{
_dgv1.Columns["cust_DistChan"].HeaderCell.SortGlyphDirection = s6;
if (s6 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["cust_DistChan"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["cust_DistChan"], ListSortDirection.Descending);
}
}
format();
}
}
public static DataTable GetDataTableForMonthByUser(int userID, DateTime date)
{
sql sql1 = new sql();
return(sql1.GetRecords("exec VisitPlanDay_Select_ByMonthByUser @p1, @p2", userID, date));
}
public AddRowReport(String rep_id, String db_id, bool edit)
{
InitializeComponent();
repID = Convert.ToInt32(rep_id);
idDB = Convert.ToInt32(db_id);
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec selRepKosByID @p1, @p2", rep_id, db_id);
dateTimePicker1.Value = Convert.ToDateTime(dt1.Rows[0].ItemArray[0].ToString());
loaddata();
cbComp.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[1].ToString());
cbCust.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[2].ToString());
tbDist.Text = dt1.Rows[0].ItemArray[3].ToString();
cbSubReg.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[4].ToString());
if (globalData.Div != "OM")
{
cbLPU.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[5].ToString());
}
if (Convert.ToInt32(dt1.Rows[0].ItemArray[6].ToString()) != 0)
{
cbGroup.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[6].ToString());
cbNom.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[7].ToString());
}
else
{
cbGroup.SelectedValue = Convert.ToInt32(dt1.Rows[0].ItemArray[7].ToString());
}
changeEnable();
load = false;
tbCount.Text = dt1.Rows[0].ItemArray[9].ToString();
tbPriceEuro.Text = dt1.Rows[0].ItemArray[10].ToString();
tbPriceRub.Text = dt1.Rows[0].ItemArray[11].ToString();
load = true;
if (((!edit) || (dateTimePicker1.Value != Convert.ToDateTime(globalData.CurDate))) && (globalData.UserAccess != 1))
{
tbCount.Enabled = false;
tbPriceEuro.Enabled = false;
tbPriceRub.Enabled = false;
cbGroup.Enabled = false;
cbNom.Enabled = false;
}
else
{
tbCount.Enabled = true;
tbPriceEuro.Enabled = true;
tbPriceRub.Enabled = true;
cbGroup.Enabled = true;
cbNom.Enabled = true;
}
}
public privateSales(String UserName, String typeRep)
{
InitializeComponent();
sql sql1 = new sql();
DataTable dt1 = new DataTable();
userID = Convert.ToInt32(sql1.GetRecordsOne("exec GetUserID @p1", UserName));
this.Text = UserName;
if (typeRep == "AP")
{
switch (globalData.Div)
{
case "HC":
{
dt1 = sql1.GetRecords("exec SelAPHCPersSales @p1, 0, @p2", globalData.Region, UserName);
break;
}
case "AE":
{
dt1 = sql1.GetRecords("exec SelAPAEPersSales @p1, 0, @p2", globalData.Region, UserName);
break;
}
case "OM":
{
dt1 = sql1.GetRecords("exec SelAPOMPersSales @p1, 0, @p2", globalData.Region, UserName);
break;
}
}
dataGridView1.DataSource = dt1;
dataGridView1.Columns["rep_id"].Visible = false;
dataGridView1.Columns["reg_id"].Visible = false;
dataGridView1.Columns["ps_count1"].Visible = false;
dataGridView1.Columns["rep_date"].DefaultCellStyle.Format = "MM - yyyy";
dataGridView1.Columns["rep_date"].Width = 60;
dataGridView1.Columns["rep_date"].HeaderText = "Дата";
dataGridView1.Columns["reg_nameRus"].Width = 150;
dataGridView1.Columns["reg_nameRus"].HeaderText = "Регион продаж";
dataGridView1.Columns["rep_RefDoc"].HeaderText = "Счёт-фактура";
dataGridView1.Columns["cust_code"].HeaderText = "код покупателя";
dataGridView1.Columns["cust_name"].Width = 200;
dataGridView1.Columns["cust_name"].HeaderText = "Покупатель";
dataGridView1.Columns["sba_code"].Width = 40;
dataGridView1.Columns["sba_code"].HeaderText = "SBA код";
dataGridView1.Columns["sba_name"].Width = 140;
dataGridView1.Columns["sba_name"].HeaderText = "SBA";
dataGridView1.Columns["mmg_code"].Visible = false;
dataGridView1.Columns["mmg_name"].Visible = false;
dataGridView1.Columns["msg_code"].Visible = false;
dataGridView1.Columns["msg_name"].Visible = false;
dataGridView1.Columns["mat_code"].Width = 120;
dataGridView1.Columns["mat_code"].HeaderText = "Код продукции";
dataGridView1.Columns["mat_name"].Width = 150;
dataGridView1.Columns["mat_name"].HeaderText = "Продукция";
dataGridView1.Columns["cost"].Visible = false;
dataGridView1.Columns["rep_tail"].Visible = false;
dataGridView1.Columns["rep_UnitPrice"].Visible = false;
dataGridView1.Columns["rep_UnitPriceRub"].Visible = false;
dataGridView1.Columns["ps_count"].DefaultCellStyle.Format = "N0";
dataGridView1.Columns["ps_count"].Width = 130;
dataGridView1.Columns["ps_count"].HeaderText = "Количество";
dataGridView1.Columns["cost2"].DefaultCellStyle.Format = "N2";
dataGridView1.Columns["cost2"].HeaderText = "Сумма в Евро";
dataGridView1.Columns["cost3"].DefaultCellStyle.Format = "N2";
dataGridView1.Columns["cost3"].HeaderText = "Сумма в рублях";
dataGridView1.Columns["LPU_name"].HeaderText = "ЛПУ";
}
else
{
DataTable dt2 = new DataTable();
load = false;
dt2 = sql1.GetRecords("exec SelRegionByUserID @p1", userID);
if (dt2 == null)
{
MessageBox.Show("Не найдены регионы пользователя");
return;
}
cbRegion.DataSource = dt2;
cbRegion.DisplayMember = "reg_nameRus";
cbRegion.ValueMember = "reg_id";
dt2 = sql1.GetRecords("exec SelLPUbyRegID @p1, @p2", userID, cbRegion.SelectedValue);
if (dt2 == null)
{
MessageBox.Show("Не найдены ЛПУ пользователя");
return;
}
cbLPU.DataSource = dt2;
cbLPU.DisplayMember = "lpu_sname";
cbLPU.ValueMember = "lpu_id";
load = true;
if (cbLPU.Items.Count > 0)
{
cbLPU.Enabled = true;
}
else
{
cbLPU.Enabled = false;
}
btnHideLPU.Text = "Скрыть ЛПУ";
label13.Visible = true;
cbLPU.Visible = true;
type = typeRep;
}
lbUser.Text = UserName;
}
private void loaddata()
{
sql sql1 = new sql();
DataTable dt = sql1.GetRecords("exec SelUserByID @p1", globalData.UserID2);
lbUserName.Text = dt.Rows[0].ItemArray[1].ToString();
tbRate.Text = sql1.GetRecordsOne("exec GetRate @p1", dateTimePicker1.Value);
cbCust.Items.Clear();
cbRegCust.Items.Clear();
cbSubReg.Items.Clear();
cbLPU.Items.Clear();
cbComp.DataSource = sql1.GetRecords("exec selComp");
cbComp.DisplayMember = "comp_name";
cbComp.ValueMember = "comp_id";
dt = sql1.GetRecords("exec selKosCustByName @p1, @p2", globalData.Region, globalData.Div);
cbCust.DataSource = dt;
cbCust.DisplayMember = "cust_name";
cbCust.ValueMember = "cust_id";
if (cbCust.Items.Count > 0)
{
cbCust.SelectedIndex = 0;
}
cbRegCust.DataSource = dt;
cbRegCust.DisplayMember = "reg_nameRus";
cbRegCust.ValueMember = "reg_id";
cbSubReg.DataSource = sql1.GetRecords("exec selSubRegion @p1", globalData.Region);
cbSubReg.DisplayMember = "subreg_nameRus";
cbSubReg.ValueMember = "subreg_id";
cbLPU.DataSource = sql1.GetRecords("exec selLPUbySubReg @p1, @p2, @p3, @p4", globalData.UserID2, cbSubReg.SelectedValue, globalData.Div, globalData.CurDate.Year);
cbLPU.DisplayMember = "lpu_sname";
cbLPU.ValueMember = "ulpu_id";
load = false;
cbGroup.DataSource = sql1.GetRecords("exec SelGroupProd @p1", globalData.Div);
cbGroup.DisplayMember = "nom_name";
cbGroup.ValueMember = "nom_id";
dt = sql1.GetRecords("exec SelNomProd @p1", cbGroup.SelectedValue);
if (dt != null)
{
cbNom.DataSource = dt;
cbNom.DisplayMember = "nom_name";
cbNom.ValueMember = "nom_id";
}
if (dt.Rows.Count == 0)
{
cbNom.Visible = false;
label22.Visible = false;
}
else
{
cbNom.Visible = true;
label22.Visible = true;
}
load = true;
if (globalData.Div == "AE")
{
label14.Visible = false;
tbCount.Visible = false;
tbCount.TabStop = false;
}
if (globalData.Div == "OM")
{
label14.Visible = true;
tbCount.Visible = true;
tbCount.TabStop = true;
label22.Visible = false;
label10.Visible = false;
cbLPU.Visible = false;
}
}
private void btnSaveCust_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
DataTable dt = sql1.GetRecords("exec InsMergeCust @p1, @p2", textBox6.Text, textBox5.Text);
}
private void btnMoveSales_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
sql1.GetRecords("exec MoveSales @p1, @p2", ulpu_id, cbUserLPU.SelectedValue);
}
public static DataTable getDataTable()
{
sql sql1 = new sql();
return(sql1.GetRecords("exec SelVPStatus"));
}
private void btnSaveMat_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
DataTable dt = sql1.GetRecords("exec InsMergeMat @p1, @p2, @p3", textBox1.Text, textBox2.Text, textBox3.Text);
}
private void loadData()
{
setButtonColor();
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelAllMaterials @p1, @p2", sdiv, btnCur);
if (dt1.Rows.Count > 0)
{
SortOrder s1 = SortOrder.None;
SortOrder s2 = SortOrder.None;
SortOrder s3 = SortOrder.None;
SortOrder s4 = SortOrder.None;
SortOrder s5 = SortOrder.None;
SortOrder s6 = SortOrder.None;
SortOrder s7 = SortOrder.None;
SortOrder s8 = SortOrder.None;
if (_dgv1.Columns.Count > 0)
{
s1 = _dgv1.Columns["mat_code"].HeaderCell.SortGlyphDirection;
s2 = _dgv1.Columns["mat_name"].HeaderCell.SortGlyphDirection;
s3 = _dgv1.Columns["pdiv_code"].HeaderCell.SortGlyphDirection;
s4 = _dgv1.Columns["sba_code"].HeaderCell.SortGlyphDirection;
s5 = _dgv1.Columns["mmg_code"].HeaderCell.SortGlyphDirection;
s6 = _dgv1.Columns["msg_code"].HeaderCell.SortGlyphDirection;
s7 = _dgv1.Columns["nom_name"].HeaderCell.SortGlyphDirection;
s8 = _dgv1.Columns["btn_name"].HeaderCell.SortGlyphDirection;
}
_dgv1.DataSource = dt1;
if (s1 != SortOrder.None)
{
_dgv1.Columns["mat_code"].HeaderCell.SortGlyphDirection = s1;
if (s1 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["mat_code"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["mat_code"], ListSortDirection.Descending);
}
}
if (s2 != SortOrder.None)
{
_dgv1.Columns["mat_name"].HeaderCell.SortGlyphDirection = s2;
if (s2 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["mat_name"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["mat_name"], ListSortDirection.Descending);
}
}
if (s3 != SortOrder.None)
{
_dgv1.Columns["pdiv_code"].HeaderCell.SortGlyphDirection = s3;
if (s3 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["pdiv_code"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["pdiv_code"], ListSortDirection.Descending);
}
}
if (s4 != SortOrder.None)
{
_dgv1.Columns["sba_code"].HeaderCell.SortGlyphDirection = s4;
if (s4 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["sba_code"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["sba_code"], ListSortDirection.Descending);
}
}
if (s5 != SortOrder.None)
{
_dgv1.Columns["mmg_code"].HeaderCell.SortGlyphDirection = s5;
if (s5 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["mmg_code"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["mmg_code"], ListSortDirection.Descending);
}
}
if (s6 != SortOrder.None)
{
_dgv1.Columns["msg_code"].HeaderCell.SortGlyphDirection = s6;
if (s6 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["msg_code"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["msg_code"], ListSortDirection.Descending);
}
}
if (s7 != SortOrder.None)
{
_dgv1.Columns["nom_name"].HeaderCell.SortGlyphDirection = s7;
if (s7 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["nom_name"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["nom_name"], ListSortDirection.Descending);
}
}
if (s8 != SortOrder.None)
{
_dgv1.Columns["btn_name"].HeaderCell.SortGlyphDirection = s8;
if (s8 == SortOrder.Ascending)
{
_dgv1.Sort(_dgv1.Columns["btn_name"], ListSortDirection.Ascending);
}
else
{
_dgv1.Sort(_dgv1.Columns["btn_name"], ListSortDirection.Descending);
}
}
format();
}
}
void UpdFlag(int flag)
{
sql sql1 = new sql();
sql1.GetRecords("exec UpdMarkActFlag @p1, @p2, @p3, @p4", index, db, kvart, flag);
}
internal void Delete()
{
sql1.GetRecords("exec Question_Delete @p1", id);
}
void DelCosts()
{
sql sql1 = new sql();
sql1.GetRecords("exec DeleteCostsMA @p1, @p2, @p3", index, db, kvart);
}
private void AddEditVisitPlanList_Load(object sender, EventArgs e)
{
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelVisitPlanByUser @p1, @p2", userID, date);
int y = 0, i = 0;
visit1 = new Visit[dt1.Rows.Count];
gb1 = new GroupBox[dt1.Rows.Count];
cb1 = new ComboBox[dt1.Rows.Count, 3];
lb1 = new Label[dt1.Rows.Count, 7];
tb1 = new TextBox[dt1.Rows.Count, 4];
btn1 = new Button[dt1.Rows.Count, 2];
check1 = new CheckBox[dt1.Rows.Count];
dateNew1 = new DateTimePicker[dt1.Rows.Count];
tbCommentRD = new string[dt1.Rows.Count];
foreach (DataRow row in dt1.Rows)
{
visit1[i] = new Visit(Convert.ToInt32(row.ItemArray[0]), Convert.ToInt32(userID));
gb1[i] = new GroupBox();
gb1[i].Location = new Point(10, 40 + y);
gb1[i].Size = new Size(807, 320);
gb1[i].Name = "gb" + row[0].ToString();
DateTime date2 = Convert.ToDateTime(row[2]);
if (date2.Hour < 10)
{
gb1[i].Text = "0" + date2.Hour.ToString() + ":00";
}
else
{
gb1[i].Text = date2.Hour.ToString() + ":00";
}
lb1[i, 0] = new Label();
lb1[i, 0].Location = new Point(8, 20);
lb1[i, 0].Text = "Статус:";
lb1[i, 0].Size = new Size(44, 13);
gb1[i].Controls.Add(lb1[i, 0]);
lb1[i, 1] = new Label();
lb1[i, 1].Location = new Point(134, 20);
lb1[i, 1].Text = "Название ЛПУ:";
lb1[i, 1].Size = new Size(87, 13);
gb1[i].Controls.Add(lb1[i, 1]);
lb1[i, 2] = new Label();
lb1[i, 2].Location = new Point(311, 20);
lb1[i, 2].Text = "Вид деятельности:";
lb1[i, 2].Size = new Size(102, 13);
gb1[i].Controls.Add(lb1[i, 2]);
lb1[i, 3] = new Label();
lb1[i, 3].Location = new Point(8, 67);
lb1[i, 3].Text = "1 - План действий:";
lb1[i, 3].Size = new Size(101, 13);
gb1[i].Controls.Add(lb1[i, 3]);
lb1[i, 4] = new Label();
lb1[i, 4].Location = new Point(271, 67);
lb1[i, 4].Text = "2 - Выполнение:";
lb1[i, 4].Size = new Size(88, 13);
gb1[i].Controls.Add(lb1[i, 4]);
lb1[i, 5] = new Label();
lb1[i, 5].Location = new Point(535, 67);
lb1[i, 5].Text = "3 - Последующие шаги:";
lb1[i, 5].Size = new Size(125, 13);
gb1[i].Controls.Add(lb1[i, 5]);
lb1[i, 6] = new Label();
lb1[i, 6].Location = new Point(8, 197);
lb1[i, 6].Text = "Комментарии руководителя:";
lb1[i, 6].Size = new Size(153, 13);
gb1[i].Controls.Add(lb1[i, 6]);
cb1[i, 0] = new ComboBox();
cb1[i, 0].Location = new Point(10, 35);
cb1[i, 0].Size = new Size(105, 21);
cb1[i, 0].DropDownStyle = ComboBoxStyle.DropDownList;
cb1[i, 0].FormattingEnabled = true;
cb1[i, 0].Name = "cmb" + i.ToString();
DataTable dt2 = new DataTable();
dt2 = sql1.GetRecords("exec SelVPStatus");
fillComboBox(dt2, cb1[i, 0], "vpst_name", "vpst_id");
cb1[i, 0].Enabled = canChangeStatus(visit1[i]);
cb1[i, 0].SelectedValueChanged += new EventHandler(valid);
gb1[i].Controls.Add(cb1[i, 0]);
cb1[i, 1] = new ComboBox();
cb1[i, 1].Location = new Point(137, 35);
cb1[i, 1].Size = new Size(171, 21);
cb1[i, 1].DropDownStyle = ComboBoxStyle.DropDownList;
DataTable dt3 = new DataTable();
dt3 = sql1.GetRecords("exec SelULPUbyUserIDVisPlan @p1", userID);
fillComboBox(dt3, cb1[i, 1], "ulpu_sname", "ulpu_id");
cb1[i, 1].Enabled = !readlyOnlyEditPlan(visit1[i]);
gb1[i].Controls.Add(cb1[i, 1]);
cb1[i, 2] = new ComboBox();
cb1[i, 2].Location = new Point(314, 35);
cb1[i, 2].Size = new Size(171, 21);
cb1[i, 2].DropDownStyle = ComboBoxStyle.DropDownList;
DataTable dt4 = new DataTable();
dt4 = sql1.GetRecords("exec SelActivity");
fillComboBox(dt4, cb1[i, 2], "act_name", "act_id");
cb1[i, 2].Enabled = !readlyOnlyEditPlan(visit1[i]);
gb1[i].Controls.Add(cb1[i, 2]);
tb1[i, 0] = new TextBox();
tb1[i, 0].Location = new Point(10, 83);
tb1[i, 0].Multiline = true;
tb1[i, 0].MaxLength = 500;
tb1[i, 0].Size = new Size(258, 110);
tb1[i, 0].Text = row.ItemArray[6].ToString();
tb1[i, 0].Name = "txb0" + i.ToString();
tb1[i, 0].TextChanged += new EventHandler(valid);
tb1[i, 0].MouseDoubleClick += new MouseEventHandler(tbPlan_MouseDoubleClick);
tb1[i, 0].ReadOnly = readlyOnlyEditPlan(visit1[i]);
gb1[i].Controls.Add(tb1[i, 0]);
tb1[i, 1] = new TextBox();
tb1[i, 1].Location = new Point(274, 83);
tb1[i, 1].Multiline = true;
tb1[i, 1].MaxLength = 500;
tb1[i, 1].Size = new Size(258, 110);
tb1[i, 1].Text = row.ItemArray[7].ToString();
tb1[i, 1].Name = "txb1" + i.ToString();
tb1[i, 1].TextChanged += new EventHandler(valid);
tb1[i, 1].MouseDoubleClick += new MouseEventHandler(tbFact_MouseDoubleClick);
tb1[i, 1].ReadOnly = readlyOnlyEditFact(visit1[i]);
gb1[i].Controls.Add(tb1[i, 1]);
tb1[i, 2] = new TextBox();
tb1[i, 2].Location = new Point(538, 83);
tb1[i, 2].Multiline = true;
tb1[i, 2].MaxLength = 500;
tb1[i, 2].Size = new Size(258, 110);
tb1[i, 2].Text = row.ItemArray[8].ToString();
tb1[i, 2].Name = "txb2" + i.ToString();
tb1[i, 2].TextChanged += new EventHandler(valid);
tb1[i, 2].MouseDoubleClick += new MouseEventHandler(tbNext_MouseDoubleClick);
tb1[i, 2].ReadOnly = readlyOnlyEditFact(visit1[i]);
gb1[i].Controls.Add(tb1[i, 2]);
tb1[i, 3] = new TextBox();
tb1[i, 3].Location = new Point(11, 213);
tb1[i, 3].Multiline = true;
tb1[i, 3].MaxLength = 500;
tb1[i, 3].Size = new Size(500, 100);
tb1[i, 3].Text = row.ItemArray[10].ToString();
tb1[i, 3].TextChanged += new EventHandler(valid);
tb1[i, 3].MouseDoubleClick += new MouseEventHandler(tbCom_MouseDoubleClick);
tb1[i, 3].ReadOnly = readlyOnlyAddCommRD(visit1[i]);
tbCommentRD[i] = row.ItemArray[10].ToString().Trim();
gb1[i].Controls.Add(tb1[i, 3]);
check1[i] = new CheckBox();
check1[i].Location = new Point(538, 197);
check1[i].Text = "Назначена новая встреча";
check1[i].Size = new Size(157, 17);
check1[i].Name = "chk" + i.ToString();
if (row.ItemArray[14].ToString() != String.Empty)
{
check1[i].Checked = true;
}
check1[i].CheckedChanged += new EventHandler(checkBox1_CheckedChanged);
gb1[i].Controls.Add(check1[i]);
dateNew1[i] = new DateTimePicker();
dateNew1[i].Location = new Point(538, 220);
dateNew1[i].Name = "date" + i.ToString();
if (row.ItemArray[14].ToString() != String.Empty)
{
dateNew1[i].Value = Convert.ToDateTime(row.ItemArray[14].ToString());
}
else
{
dateNew1[i].Visible = false;
}
dateNew1[i].Size = new Size(139, 20);
dateNew1[i].ValueChanged += new EventHandler(dateNewVisit_ValueChanged);
gb1[i].Controls.Add(dateNew1[i]);
btn1[i, 0] = new Button();
btn1[i, 0].Location = new Point(725, 290);
btn1[i, 0].Size = new Size(75, 23);
btn1[i, 0].Text = "Сохранить";
btn1[i, 0].Name = "btn0" + i.ToString();
btn1[i, 0].Click += new EventHandler(button1_Click);
gb1[i].Controls.Add(btn1[i, 0]);
btn1[i, 1] = new Button();
btn1[i, 1].Location = new Point(690, 215);
btn1[i, 1].Size = new Size(113, 23);
btn1[i, 1].Text = "Создать визит";
btn1[i, 1].Name = "btn1" + i.ToString();
btn1[i, 1].Click += new EventHandler(button2_Click);
if (row.ItemArray[14].ToString() == String.Empty)
{
btn1[i, 1].Visible = false;
}
gb1[i].Controls.Add(btn1[i, 1]);
y += 330;
i++;
}
this.Controls.AddRange(gb1);
}
public void CheckExist()
{
sql sql1 = new sql();
DataTable dt1 = new DataTable();
dt1 = sql1.GetRecords("exec CheckExistMA @p1, @p2, @p3", index, db, kvart);
if (dt1 == null || dt1.Rows.Count == 0)
{
tbSum.Text = price;
return;
}
foreach (DataRow row in dt1.Rows)
{
switch (row.ItemArray[0].ToString())
{
case "":
if (row.ItemArray[1].ToString() == "1")
{
chHC.Checked = true;
}
if (row.ItemArray[1].ToString() == "2")
{
chAE.Checked = true;
}
if (row.ItemArray[1].ToString() == "3")
{
chOM.Checked = true;
}
break;
/*HC*/
case "01":
ch01.Checked = true;
break;
case "02":
ch02.Checked = true;
break;
case "04":
ch04.Checked = true;
break;
case "05":
ch05.Checked = true;
break;
case "07":
ch07.Checked = true;
break;
case "09":
ch09.Checked = true;
break;
case "10":
ch10.Checked = true;
break;
case "12":
ch12.Checked = true;
break;
case "16":
ch16.Checked = true;
break;
case "20":
ch20.Checked = true;
break;
case "21":
ch21.Checked = true;
break;
case "23":
ch23.Checked = true;
break;
case "25":
ch25.Checked = true;
break;
case "26":
ch26.Checked = true;
break;
case "27":
ch27.Checked = true;
break;
case "29":
ch29.Checked = true;
break;
/*AE*/
case "30":
chST.Checked = true;
break;
case "35":
chCT.Checked = true;
break;
case "33":
chOT.Checked = true;
break;
case "31":
chNE.Checked = true;
break;
case "36":
chVS.Checked = true;
break;
case "39":
chAM.Checked = true;
break;
/*OM*/
case "61":
ch61.Checked = true;
break;
case "62":
ch62.Checked = true;
break;
case "63":
ch63.Checked = true;
break;
case "64":
ch64.Checked = true;
break;
case "66":
ch66.Checked = true;
break;
case "69":
ch69.Checked = true;
break;
default:
continue;
}
price = row.ItemArray[2].ToString();
}
}
private DataTable getRegionInfo()
{
sql sql1 = new sql();
return(sql1.GetRecords("exec Region_Select_Info @p1", id));
}
