public Users()
{
InitializeComponent();
cbSDiv.SelectedIndex = 0;
globalData.load = false;
globalData.Div = cbSDiv.SelectedItem.ToString();
sql sql1 = new sql();
DataTable dt = sql1.GetRecords("exec SelRole");
if (dt != null)
{
cbRoles.DataSource = dt;
cbRoles.DisplayMember = "role_name";
cbRoles.ValueMember = "role_id";
cbRoles.SelectedIndex = 4;
}
dt = sql1.GetRecords("exec Region_Select");
if (dt != null)
{
cbRegions.DataSource = dt;
cbRegions.DisplayMember = "reg_nameRus";
cbRegions.ValueMember = "reg_id";
}
loadData1();
loadData2();
globalData.load = true;
}
private void fillUsersUlpu()
{
if (dataGridView1.Rows != null)
{
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
}
globalData.load = false;
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelUserByLPUID @p1", cbULPU.SelectedValue);
if (dt1 == null)
{
MessageBox.Show("Ошибка!", "ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
dataGridView1.Columns.Add("user_name", "Региональный представитель");
foreach (DataRow row in dt1.Rows)
{
dataGridView1.Rows.Add(row.ItemArray[1]);
}
dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);
}
globalData.load = true;
}
private void btnOK_Click(object sender, EventArgs e)
{
if (!(cbRP.Checked) && !(cbRM.Checked) && !(cbRD.Checked))
{
MessageBox.Show("Не выбраны получатели", "Отсутствуют получатели", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
sql sql1 = new sql();
DateTime date = dtpDate.Value;
if (cbEnd.Checked)
{
date = Convert.ToDateTime("2023-01-01");
}
if (cbRP.Checked)
{
sql1.GetRecords("exec InsMessageByRoleID @p1, @p2, @p3, @p4, @p5", globalData.UserID, 5, tbHeader.Text, tbText.Text, date);
}
if (cbRM.Checked)
{
sql1.GetRecords("exec InsMessageByRoleID @p1, @p2, @p3, @p4, @p5", globalData.UserID, 6, tbHeader.Text, tbText.Text, date);
}
if (cbRD.Checked)
{
sql1.GetRecords("exec InsMessageByRoleID @p1, @p2, @p3, @p4, @p5", globalData.UserID, 4, tbHeader.Text, tbText.Text, date);
}
this.Close();
}
private void btnAdd_Click(object sender, EventArgs e)
{
int cur = 0;
cur = getCurBtn();
if (cur == -1)
{
MessageBox.Show("Необходимо выбрать подкатегорию.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
sql sql1 = new sql();
String s1 = sql1.GetRecordsOne("exec SetMatBtn @p1, @p2", tbMat.Text, cur);
if (s1 == "notFound")
{
MessageBox.Show("Артикул не найден.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Артикул обновлён.", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbMat.Text = "";
loadData(false, btnCur);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (count < Convert.ToInt32(tbCount.Text))
{
MessageBox.Show("Количество не может быть больше, чем в продаже", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (Convert.ToInt32(tbCount.Text) < 0)
{
MessageBox.Show("Количество не может быть отрицательным", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if ((globalData.Div == "HC") && (cbSubReg.SelectedValue.ToString() != "1"))
{
if (Convert.ToInt32(tbCount.Text) > Convert.ToInt32(tbTail.Text))
{
MessageBox.Show("Количество не может быть больше остатка", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
sql sql1 = new sql();
string res = sql1.GetRecordsOne("exec MoveReport 0, @p1, @p2, @p3, @p4, @p5", idRep, db, cbSubReg.SelectedValue, globalData.UserID, tbCount.Text);
if (res == "1")
{
globalData.update = true;
Close();
}
else
{
MessageBox.Show(res, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public MoveReport(int idRep1, int db1, int count1)
{
InitializeComponent();
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelSubRegionByUserID @p1", globalData.UserID);
globalData.load = false;
cbSubReg.DataSource = dt1;
cbSubReg.DisplayMember = "subreg_nameRus";
cbSubReg.ValueMember = "subreg_id";
globalData.load = true;
tbCount.Text = count1.ToString();
count = count1;
idRep = idRep1;
db = db1;
if (globalData.Div == "HC")
{
tbTail.Visible = true;
label3.Visible = true;
tbTail.Text = sql1.GetRecordsOne("exec TailForRaspNew @p1, @p2, @p3", idRep, db, cbSubReg.SelectedValue);
}
else
{
tbTail.Visible = false;
label3.Visible = false;
}
}
private void loadData(bool mainindex, int index)
{
sql sql1 = new sql();
DataTable dt1 = new DataTable();
if (!mainindex)
{
if (btnAE.BackColor == bbgreen3)
{
index += 4;
}
else if (btnOM.BackColor == bbgreen3)
{
index += 12;
}
}
dt1 = sql1.GetRecords("exec selMatForBtn @p1, @p2", Convert.ToInt16(mainindex), index);
_dgv1.Columns.Clear();
if (dt1.Rows.Count > 0)
{
formatDGV(mainindex);
foreach (DataRow row in dt1.Rows)
{
_dgv1.Rows.Add(row.ItemArray);
}
}
}
private void loaddata()
{
sql sql1 = new sql();
globalData.load = false;
cbSDiv.DataSource = sql1.GetRecords("exec SelSDiv");
cbSDiv.DisplayMember = "sdiv_code";
cbSDiv.ValueMember = "sdiv_id";
globalData.load = true;
loadPDiv();
loadHier();
loadNom();
loadButton();
if (mat_id != "0")
{
DataTable dt1 = sql1.GetRecords("exec selMaterialByID @p1", mat_id);
tbMatCode.Text = dt1.Rows[0].ItemArray[1].ToString();
tbMatName.Text = dt1.Rows[0].ItemArray[2].ToString();
cbSDiv.SelectedValue = dt1.Rows[0].ItemArray[3].ToString();
cbPDiv.SelectedValue = dt1.Rows[0].ItemArray[4].ToString();
cbSBA.SelectedValue = dt1.Rows[0].ItemArray[5].ToString();
cbMMG.SelectedValue = dt1.Rows[0].ItemArray[6].ToString();
cbMSG.SelectedValue = dt1.Rows[0].ItemArray[7].ToString();
cbNom.SelectedValue = dt1.Rows[0].ItemArray[8].ToString();
cbButton.SelectedValue = dt1.Rows[0].ItemArray[9].ToString();
}
}
private void loadData1()
{
sql sql1 = new sql();
DataTable dt1 = new DataTable();
if (_dgv1.Columns.Count == 0)
{
_dgv1.Columns.Add("user_id", "");
_dgv1.Columns.Add("user_name", "ФИО");
_dgv1.Columns.Add("user_year1", "");
_dgv1.Columns.Add("user_year2", "");
_dgv1.Columns["user_id"].Visible = false;
_dgv1.Columns["user_name"].Width = 220;
_dgv1.Columns["user_year1"].Visible = false;
_dgv1.Columns["user_year2"].Visible = false;
}
dt1 = sql1.GetRecords("exec SelUsers2 @p1", cbRoles.SelectedValue);
int i = 0;
_dgv1.Rows.Clear();
foreach (DataRow row in dt1.Rows)
{
_dgv1.Rows.Add(row.ItemArray);
if (Convert.ToInt32(row.ItemArray[3].ToString()) < globalData.CurDate.Year)
{
_dgv1.Rows[i].DefaultCellStyle.BackColor = bbgray4;
}
i++;
}
}
private void btnHideLPU_Click(object sender, EventArgs e)
{
if (btnHideLPU.Text == "Скрыть ЛПУ")
{
btnHideLPU.Text = "Показать ЛПУ";
label13.Visible = false;
cbLPU.Visible = false;
sql sql1 = new sql();
dataGridView1.Columns.Clear();
DataTable dt1 = new DataTable();
if (globalData.Div == "AE")
{
dt1 = sql1.GetRecords("exec SelAccByUser @p1, @p2, @p3, ''", globalData.Div, globalData.CurDate.Year, userID);
}
else
{
dt1 = sql1.GetRecords("exec SelAccHCByUser @p1, @p2, @p3, ''", globalData.Div, globalData.CurDate.Year, userID);
}
dataGridView1.DataSource = dt1;
formatAcc();
}
else
{
loadAccPlanByLPU();
btnHideLPU.Text = "Скрыть ЛПУ";
label13.Visible = true;
cbLPU.Visible = true;
}
}
private void loaddata()
{
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec SelRepDistRight @p1", cbYear.SelectedItem);
format();
bool a1 = false, a2 = false, a3 = false, a4 = false, a5 = false, a6 = false, a7 = false, a8 = false, a9 = false, a10 = false, a11 = false, a12 = false;
foreach (DataRow row in dt1.Rows)
{
a1 = Convert.ToBoolean(row["rdr_allow1"]);
a2 = Convert.ToBoolean(row["rdr_allow2"]);
a3 = Convert.ToBoolean(row["rdr_allow3"]);
a4 = Convert.ToBoolean(row["rdr_allow4"]);
a5 = Convert.ToBoolean(row["rdr_allow5"]);
a6 = Convert.ToBoolean(row["rdr_allow6"]);
a7 = Convert.ToBoolean(row["rdr_allow7"]);
a8 = Convert.ToBoolean(row["rdr_allow8"]);
a9 = Convert.ToBoolean(row["rdr_allow9"]);
a10 = Convert.ToBoolean(row["rdr_allow10"]);
a11 = Convert.ToBoolean(row["rdr_allow11"]);
a12 = Convert.ToBoolean(row["rdr_allow12"]);
_dgv1.Rows.Add(row["cust_id"], row["cust_code"], row["cust_name"], a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12);
}
}
private void loadUserBC()
{
if (_dgv2.RowCount > 0)
{
_dgv2.Rows.Clear();
}
sql sql1 = new sql();
DataTable dt = sql1.GetRecords("exec Rent_Select_UserRent @p1, @p2, @p3, @p4, @p5", 0, 0, 0, comboBox1.SelectedValue.ToString(), "0");
if (dt == null)
{
return;
}
int i = 0;
foreach (DataRow row in dt.Rows)
{
_dgv2.Rows.Add(row.ItemArray[0], row.ItemArray[1], row.ItemArray[2]);
if (Convert.ToInt32(row.ItemArray[2]) == 0)
{
_dgv2.Rows[i].DefaultCellStyle.BackColor = bbgray4;
}
i++;
}
_dgv2.Columns["user_id"].Visible = false;
_dgv2.Columns["user_name"].HeaderText = "Пользователь";
_dgv2.Columns["user_name"].Width = _dgv2.Width;
_dgv2.Columns["flag_enable"].Visible = false;
}
private void cbGroup_SelectedIndexChanged(object sender, EventArgs e)
{
if (load)
{
sql sql1 = new sql();
DataTable dt = new DataTable();
dt = sql1.GetRecords("exec SelNomProd @p1", cbGroup.SelectedValue);
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;
}
if (dt.Rows.Count == 0)
{
changeEnable();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
InputDialog ind = new InputDialog("Дистрибьютор", "Введите код дистр.(Напр.:20440997)\nНе забудьте добавить РЕГИОН!", true);
ind.ShowDialog();
if (ind.DialogResult == DialogResult.Cancel)
{
return;
}
String code = globalData.input;
ind = new InputDialog("Дата начала отчётов", "Введите год", true);
ind.ShowDialog();
if (ind.DialogResult == DialogResult.Cancel)
{
return;
}
String yearR = globalData.input;
ind = new InputDialog("Дата начала отчётов", "Введите месяц в формате 1,2,3..", true);
ind.ShowDialog();
if (ind.DialogResult == DialogResult.Cancel)
{
return;
}
String monthR = globalData.input;
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec InsRepDistRight @p1, @p2", code, yearR + "-" + monthR + "-01");
}
protected override void Query()
{
var ormInstance = new orm();
sql sqlInstance = new sql();
sqlInstance.Select(@"
id,
name,
phone,
certificate_num,
service_area,
ID_card,
army,
r_and_p,
address,
Hukou,
contact_way,
political_status,
part_of_company,
serviceunit,
h_and_w,
sex,
soldier,
approve_time,
date_of_birth,
major_skill,
training_record,
base64FromImage" ).From("guard");
guardList = ormInstance.Fetch <MODEL.guard>(sqlInstance);
dataGridView1.DataSource = guardList;
base.Query();
}
private void loadData()
{
sql sql1 = new sql();
_dgv1.DataSource = sql1.GetRecords("exec SelMaterial2 @p1", cbCustomer.SelectedValue);
format();
}
private void btnSearchCust_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
DataTable dt = sql1.GetRecords("exec SelMergeCust @p1, @p2", textBox6.Text, textBox5.Text);
_dgvMerge.DataSource = dt;
}
private void btnSearchMat_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
DataTable dt = sql1.GetRecords("exec SelMergeMat @p1, @p2, @p3", textBox1.Text, textBox2.Text, textBox3.Text);
_dgvMerge.DataSource = dt;
}
private void loadButton()
{
sql sql1 = new sql();
cbButton.DataSource = sql1.GetRecords("exec SelButton @p1", cbSDiv.SelectedValue);
cbButton.DisplayMember = "btn_name";
cbButton.ValueMember = "btn_id";
}
private void cbSubReg_SelectedIndexChanged(object sender, EventArgs e)
{
if ((globalData.load) && (globalData.Div == "HC"))
{
sql sql1 = new sql();
tbTail.Text = sql1.GetRecordsOne("exec TailForRaspNew @p1, @p2, @p3", idRep, db, cbSubReg.SelectedValue);
}
}
private void loadNom()
{
sql sql1 = new sql();
cbNom.DataSource = sql1.GetRecords("exec SelNom @p1", cbSDiv.SelectedValue);
cbNom.DisplayMember = "nom_name";
cbNom.ValueMember = "nom_id";
}
private void CodeName_Activated(object sender, EventArgs e)
{
sql sql1 = new sql();
dataGridView1.DataSource = sql1.GetRecords(sel);
dataGridView1.Columns[0].Visible = false;
//dataGridView1.FirstDisplayedScrollingRowIndex = clsData.selRow;
}
private void button1_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
sql1.GetRecords("exec Rent_Update_UrtDate @p1", dateRent.Value.Year.ToString() + dateRent.Value.Month.ToString() + "01");
MessageBox.Show("Дата отчета успешно установлена!", "Результат");
}
private void btnDel_Click(object sender, EventArgs e)
{
sql sql1 = new sql();
sql1.GetRecords("exec DelKosCust @p1", dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
loadKosCust();
}
private void getRateDate()
{
sql sql1 = new sql();
dateTimePicker2.Value = Convert.ToDateTime(sql1.GetRecordsOne("exec GetDateCur @p1", dateTimePicker1.Value.Year + "-" + dateTimePicker1.Value.Month + "-01"));
tbRate.Text = sql1.GetRecordsOne("exec GetRate @p1", dateTimePicker2.Value.Year + "-" + dateTimePicker2.Value.Month + "-01");
DataTable dt1 = new DataTable();
dt1 = sql1.GetRecords("exec GetSettings");
if (dt1.Rows[0].ItemArray[0].ToString() == "0")
{
rbAPHCRead.Checked = true;
}
else
{
rbAPHCEdit.Checked = true;
}
if (dt1.Rows[0].ItemArray[1].ToString() == "0")
{
rbAPAERead.Checked = true;
}
else
{
rbAPAEEdit.Checked = true;
}
if (dt1.Rows[0].ItemArray[2].ToString() == "0")
{
rbAPOMRead.Checked = true;
}
else
{
rbAPOMEdit.Checked = true;
}
yearAccPlan.Text = dt1.Rows[0].ItemArray[3].ToString();
if (dt1.Rows[0].ItemArray[4].ToString() == "0")
{
checkBox1.Checked = false;
}
else
{
checkBox1.Checked = true;
}
if (dt1.Rows[0].ItemArray[5].ToString() == "0")
{
checkBox2.Checked = false;
}
else
{
checkBox2.Checked = true;
}
}
private void SaveMA()
{
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);
save = false;
}
else
{
MessageBox.Show("Маркетинговое мероприятие добавлено.", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information);
save = true;
index = Convert.ToInt32(dt1.Rows[0].ItemArray[0]);
db = Convert.ToInt32(dt1.Rows[0].ItemArray[1]);
}
}
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);
}
}
}
public fUser(String fio, String login, String role)
{
InitializeComponent();
sql sql1 = new sql();
DataTable dt1 = new DataTable();
dt1 = sql1.GetRecords("exec GetUserReg @p1", fio);
if (dt1.Rows.Count > 0)
{
_dgv1.DataSource = dt1;
lbNameTable.Visible = true;
_dgv1.Visible = true;
lbRD.Visible = true;
lbRDName.Visible = true;
lbRD.Text = sql1.GetRecordsOne("exec GetRDbyUserName @p1", fio);
_dgv1.Columns["reg_nameRus"].ReadOnly = true;
_dgv1.Columns["reg_nameRus"].Width = 170;
if ((role == "Региональный представитель") || (role == "Региональный менеджер"))
{
lbNameTable.Text = "Регионы продаж";
}
else if (role == "Региональный директор")
{
lbNameTable.Text = "Cписок подведомственных регионов";
}
}
else
{
lbNameTable.Visible = false;
lbRD.Visible = false;
lbRDName.Visible = false;
_dgv1.Visible = false;
}
lbFIO.Text = fio;
lbLogin.Text = login;
lbRole.Text = role;
dt1 = sql1.GetRecords("exec GetDivByUserName @p1", fio);
String temp = "";
foreach (DataRow row in dt1.Rows)
{
if (temp != String.Empty)
{
temp += ", ";
}
temp += row[0].ToString();
}
lbDiv.Text = temp;
}
private void loadData()
{
sql sql1 = new sql();
_dgv1.DataSource = sql1.GetRecords("exec SelUsersByRole");
_dgv1.Columns["user_id"].Visible = false;
_dgv1.Columns["user_name"].HeaderText = "Пользователь";
_dgv1.Columns["user_name"].Width = _dgv1.Width;
}
private void loadRegion()
{
sql sql1 = new sql();
DataTable dt1 = sql1.GetRecords("exec Region_Select '', '', 1");
cbReg.DataSource = dt1;
cbReg.DisplayMember = "reg_nameRus";
cbReg.ValueMember = "reg_id";
}
private void loadUserBC()
{
sql sql1 = new sql();
_dgv2.DataSource = sql1.GetRecords("exec selUserBC");
_dgv2.Columns["user_id"].Visible = false;
_dgv2.Columns["user_name"].HeaderText = "Пользователь";
_dgv2.Columns["user_name"].Width = _dgv2.Width;
}
/// <summary>
/// 转换表达式
/// </summary>
/// <param name="converter">表达式转换器</param>
/// <param name="expression">表达式</param>
private void convertConstant(sql.expression.converter converter, Expression expression)
{
object value = ((ConstantExpression)expression).Value;
if (value != null)
{
func<object, string> toString = constantConverter.Default[value.GetType()];
if (toString != null) converter.Stream.Write(toString(value));
else converter.Stream.Write(constantConverter.convertConstantStringMssql(value.ToString()));
}
else converter.Stream.Write("null");
}
/// <summary>
/// 转换表达式
/// </summary>
/// <param name="converter">表达式转换器</param>
/// <param name="expression">表达式</param>
private void convertInSet(sql.expression.converter converter, Expression expression)
{
charStream stream = converter.Stream;
BinaryExpression binaryExpression = (BinaryExpression)expression;
Expression left = binaryExpression.Left;
converters[(int)left.NodeType](converter, left);
stream.Write(" In(");
func<object, string> toString = null;
int index = -1;
foreach (object value in (IEnumerable)((ConstantExpression)binaryExpression.Right).Value)
{
if (++index == 0) toString = constantConverter.Default[value.GetType()];
else stream.Write(',');
stream.Write(toString != null ? toString(value) : constantConverter.convertConstantStringMssql(value.ToString()));
}
stream.Write(')');
}
cmd = SetupCommand(cnn, transaction, sql, info.ParamReader, (object)param, commandTimeout, commandType);
return ExecuteScaler(cnn, transaction, sql, info.ParamReader, (object)param, commandTimeout, commandType);
