private void LoadMahiat()
{
try
{
cmbAmountMahiat.Items.Clear();
cmbAmountMahiat.Items.Add(EnumMahiatAshkhas.BiHesab.GetDisplay());
cmbAmountMahiat.Items.Add(EnumMahiatAshkhas.Bedehkar.GetDisplay());
cmbAmountMahiat.Items.Add(EnumMahiatAshkhas.Bestankar.GetDisplay());
cmbAmountMahiat.SelectedIndex = 0;
}
catch (Exception ex)
{
frmMessage f = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, ex.Message);
f.ShowDialog();
}
}
private void CmbGroup_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
lblCode.Text = AccountGroupBussines.Get((Guid)cmbGroup.SelectedValue).Aouth_Code.ToString();
if (cmbGroup.Focused || account.Guid == Guid.Empty)
{
NewCode((Guid)cmbGroup.SelectedValue);
}
}
catch (Exception ex)
{
frmMessage f = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, ex.Message);
f.ShowDialog();
}
}
private void MnuInsert_Click(object sender, EventArgs e)
{
try
{
frmKol frmKol = new frmKol();
if (frmKol.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
catch (Exception exception)
{
frmMessage frm = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, exception.Message);
frm.ShowDialog();
}
}
private void mnuShow_Winners_Click(object sender, EventArgs e)
{
try
{
frmLottery_Winners f = new frmLottery_Winners();
f.Display_Winners(Convert.ToInt32(dgvStore.CurrentRow.Cells["Guid1"].Value));
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "جشنواره انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void btnFinish_Click(object sender, EventArgs e)
{
if ((clsFunction.Error_Provider(txtCode, errorProvider1, "این فیلد نمی تواند خالی باشد") == true) || (clsFunction.Error_Provider(txtName, errorProvider1, "این فیلد نمی تواند خالی باشد") == true))
{
txtName.Focus();
}
else
{
errorProvider1.Clear();
if (op == "Add")
{
if (Check_Group_Name() == true)
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "گروه " + txtName.Text + " " + "از پیش در سیستم تعریف شده است";
f.ShowDialog();
}
else
{
string query = "INSERT INTO tbl_Customer_Group (ID, Name) VALUES ('" + txtCode.Text.Trim() + "',N'" + txtName.Text.Trim() + "')";
if (clsFunction.Execute(dataconnection, query) == true)
{
this.Close();
}
}
}
else if (op == "Edit")
{
if (Check_Group_Name_ForEdit() == true)
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "گروه " + txtName.Text + " " + "از پیش در سیستم تعریف شده است";
f.ShowDialog();
}
else
{
string query = "UPDATE tbl_Customer_Group SET Name = N'" + txtName.Text.Trim() + "' WHERE ID = '" + txtCode.Text + "'";
if (clsFunction.Execute(dataconnection, query) == true)
{
this.Close();
}
}
}
}
}
private void btnFinish_Click(object sender, EventArgs e)
{
if (clsFunction.Error_Provider(txtDescription, errorProvider1, "این فیلد نمی تواند خالی باشد") == true || clsFunction.Error_Provider(txtBedehkar, errorProvider1, "این فیلد نمی تواند خالی باشد") || clsFunction.CMB_Error_Provider(cmbAccount, errorProvider1, "ابتدا نسبت به درج گروه های درآمدی اقدام نمایید") == true)
{
}
else
{
errorProvider1.Clear();
if (op == "Add")
{
if (Check_Account_Number() == true)
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = txtDescription.Text + " " + " از پیش تعریف شده است";
f.ShowDialog();
}
else
{
string query = "INSERT INTO tbl_Income (ID, Inc_Name, Group_ID, Price) VALUES ('" + Convert.ToInt32(txtAccCode.Text) + "',N'" + txtDescription.Text + "','" + Group_Code + "','" + Convert.ToInt64(txtBedehkar.Text) + "')";
if (clsFunction.Execute(dataconnection, query) == true)
{
this.Close();
}
}
}
else if (op == "Edit")
{
if (Check_Type_Name_ForEdit() == true)
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "درآمد با نام " + txtDescription.Text + " " + "از پیش تعریف شده است";
f.ShowDialog();
}
else
{
dataconnection.Close();
string query = "UPDATE tbl_Income SET Inc_Name = N'" + txtDescription.Text.Trim() + "', Group_ID = '" + Group_Code + "', Price = '" + Convert.ToInt64(txtBedehkar.Text) + "' WHERE ID = '" + Convert.ToInt32(txtAccCode.Text) + "'";
if (clsFunction.Execute(dataconnection, query) == true)
{
this.Close();
}
}
}
}
}
private void btnAlterar_Click(object sender, EventArgs e)
{
try
{
EstadoDTO dto = cboUF.SelectedItem as EstadoDTO;
ClienteDTO dta = new ClienteDTO();
dta.id = this.cliente.id;
dta.Nome = txtNome.Text;
dta.Email = txtEmail.Text;
dta.DataNascimento = mkbNascimento.Text;
dta.Rg = mkbRG.Text;
dta.Cpf = mkbCPF.Text;
dta.Telefone = mkbTelefone.Text;
dta.Cidade = txtCidade.Text;
dta.DataCadastro = mkbCadastro.Text;
dta.Cep = txtCEP.Text;
dta.Rua = txtRua.Text;
dta.Numero = txtNumero.Text;
dta.EstadoId = Convert.ToInt32(dto.Id);
dta.Complemento = txtComplemento.Text;
ClienteBusiness business = new ClienteBusiness();
business.Alterar(dta);
string msg = "Cliente Cadastrado com sucesso";
frmMessage tela = new frmMessage();
tela.LoadScreen(msg);
tela.ShowDialog();
}
catch (ValidacaoException vex)
{
frmAlert tela = new frmAlert();
tela.LoadScreen(vex.Message);
tela.ShowDialog();
}
catch (Exception ex)
{
string msg = "Ocorreu um erro: " + ex.Message;
frmException tela = new frmException();
tela.LoadScreen(msg);
tela.ShowDialog();
}
}
private void mnuDelete_Click(object sender, EventArgs e)
{
try
{
SqlDataAdapter da = new SqlDataAdapter("SELECT Parent FROM tbl_Transaction WHERE Parent_Code='" + dgvProduct.CurrentRow.Cells["ID"].Value.ToString() + "'", dataconnection);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0].ItemArray[0].ToString() != "7" && dt.Rows[0].ItemArray[0].ToString() != "8")
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "این عملیات مختص فاکتور بوده و باید از همان طریق نسبت به حذف آن اقدام نمایید";
f.ShowDialog();
}
else
{
string query2 = "DELETE FROM tbl_Pay_Recive_Info WHERE ID='" + dgvProduct.CurrentRow.Cells["ID"].Value.ToString() + "'";
frmMessage f = new frmMessage();
if (dgvProduct.CurrentRow.Cells["Bedehkar"].Value.ToString() != "")
{
query1 = "DELETE FROM tbl_Transaction WHERE Parent=7 AND Parent_Code='" + dgvProduct.CurrentRow.Cells["ID"].Value.ToString() + "'";
f.lblMessage.Text = "آیا از حذف دریافت نقدی به مبلغ " + dgvProduct.CurrentRow.Cells["Bedehkar"].Value.ToString() + " " + "ریال، اطمینان دارید؟";
}
else if (dgvProduct.CurrentRow.Cells["Bestankar"].Value.ToString() != "")
{
query1 = "DELETE FROM tbl_Transaction WHERE Parent=8 AND Parent_Code='" + dgvProduct.CurrentRow.Cells["ID"].Value.ToString() + "'";
f.lblMessage.Text = "آیا از حذف پرداخت نقدی به مبلغ " + dgvProduct.CurrentRow.Cells["Bestankar"].Value.ToString() + " " + "ریال، اطمینان دارید؟";
}
f.flag = 1;
f.ShowDialog();
if (f.Resault == 0)
{
if (clsFunction.Execute(dataconnection, query1) == true && clsFunction.Execute(dataconnection, query2) == true)
{
Fill_Data();
}
}
}
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "عملیات انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void mnuDelete_Click(object sender, EventArgs e)
{
try
{
SqlDataAdapter da = new SqlDataAdapter("SELECT Type, Validation FROM tbl_Header_WareTransfer WHERE ID= '" + Convert.ToInt64(dgvStore.CurrentRow.Cells["ID"].Value.ToString()) + "'", dataconnection);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0].ItemArray[0].ToString() == "1")
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "بر روی این حواله انبار، فاکتور فروش و سند حسابداری تنظیم شده و از طریق فاکتورهای فروش قابل ویرایش است";
f.ShowDialog();
}
else if (dt.Rows[0].ItemArray[1].ToString() == "بله")
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "این سند تایید شده و شما مجاز به حذف اسناد تایید شده نمی باشید";
f.ShowDialog();
}
else
{
string query1 = "DELETE FROM tbl_Tour_Of_Product WHERE Parent=13 AND Parent_Code = '" + Convert.ToInt32(dgvStore.CurrentRow.Cells["ID"].Value.ToString()) + "'";
string query2 = "DELETE FROM tbl_Body_WareTransfer WHERE ID = '" + Convert.ToInt64(dgvStore.CurrentRow.Cells["ID"].Value.ToString()) + "'";
string query3 = "DELETE FROM tbl_Header_WareTransfer WHERE ID='" + Convert.ToInt64(dgvStore.CurrentRow.Cells["ID"].Value.ToString()) + "'";
frmMessage f = new frmMessage();
f.lblMessage.Text = "آیا از حذف حواله انبار به شماره " + dgvStore.CurrentRow.Cells["ID"].Value.ToString() + " " + "اطمینان دارید؟";
f.flag = 1;
f.ShowDialog();
if (f.Resault == 0)
{
if (clsFunction.Execute(dataconnection, query1) == true && clsFunction.Execute(dataconnection, query2) == true && clsFunction.Execute(dataconnection, query3) == true)
{
frmShow_Warehouse_Transfer_Activated(null, null);
}
}
}
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "حواله انبار انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void Get_Product()
{
dgvStore.EndEdit();
try
{
int P_ID = Convert.ToInt32(dgvStore.CurrentRow.Cells["Code"].Value);
SqlDataAdapter da = new SqlDataAdapter("SELECT P_Show_Name FROM tbl_Product WHERE P_Code='" + P_ID + "'", dataconnection);
DataTable dt = new DataTable();
da.Fill(dt);
dgvStore["P_Name", dgvStore.CurrentRow.Index].Value = dt.Rows[0].ItemArray[0].ToString();
dgvStore["Entity", dgvStore.CurrentRow.Index].Value = "1";
int Counter = 0;
for (int i = 0; i < dgvStore.Rows.Count; i++)
{
if (Convert.ToInt32(dgvStore.Rows[i].Cells["Code"].Value) == P_ID)
{
Counter++;
}
}
if (Counter > 1)
{
frmMessage f = new frmMessage();
f.lblMessage.Text = "از این کالا در سفارش خرید استفاده شده است. برای تغییر مقدار به ستون مورد نظر مراجعه نمایید";
f.flag = 0;
f.ShowDialog();
mnuDelete_Click(null, null);
}
return;
}
catch
{
try
{
frmAllProduct f = new frmAllProduct();
f.op = "All";
f.Fill_All_Product();
f.txtSearch.Text = dgvStore["Code", dgvStore.CurrentRow.Index].Value.ToString();
f.ShowDialog();
dgvStore["Code", dgvStore.CurrentRow.Index].Value = null;
dgvStore["Code", dgvStore.CurrentRow.Index].Value = f.Product_Code;
Get_Product();
}
catch
{
}
}
}
private void mnuDaryaft_Click(object sender, EventArgs e)
{
if (dgvStore.CurrentRow.Cells["State_Name"].Value.ToString() != "پاس نشده")
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "شما فقط مجاز به پاس کردن اسناد پاس نشده می باشید";
f.ShowDialog();
}
else
{
DateTime Check_Date = Convert.ToDateTime(dgvStore.CurrentRow.Cells["Date_Of_Arrivall"].Value.ToString());
DateTime Today = Convert.ToDateTime(clsFunction.M2SH(DateTime.Now));
if (Check_Date > Today)
{
string Distance = (Check_Date - Today).TotalDays.ToString();
frmMessage f = new frmMessage();
f.lblMessage.Text = "هنوز " + Distance + " " + "روز به تاریخ سررسید چک زمان باقی مانده است.";
f.flag = 0;
f.ShowDialog();
}
else
{
SqlDataAdapter da = new SqlDataAdapter("SELECT Code FROM tbl_Bank WHERE ID ='" + Convert.ToInt32(dgvStore.CurrentRow.Cells["ID_Bank"].Value.ToString()) + "'", dataconnection);
DataTable dt = new DataTable();
da.Fill(dt);
string Ass_Code = dt.Rows[0].ItemArray[0].ToString();
frmMessage f = new frmMessage();
f.lblMessage.Text = "آیا از وصول چک به شماره ی " + dgvStore.CurrentRow.Cells["Check_Number"].Value.ToString() + " " + "به مبلغ " + dgvStore.CurrentRow.Cells["Price"].Value.ToString() + " " + "اطمینان دارید؟";
f.flag = 1;
f.ShowDialog();
if (f.Resault == 0)
{
Get_Max_Doc_Number();
string query1 = "INSERT INTO tbl_Transaction (Code, Bedehkar, Notice, Date, Time, Doc_Number, Moeen, Parent, Parent_Code) VALUES ('" + Ass_Code + "','" + Convert.ToInt64(dgvStore.CurrentRow.Cells["Price"].Value) + "',N'" + "وصول چک شماره " + dgvStore.CurrentRow.Cells["Check_Number"].Value.ToString() + " " + "به مبلغ " + dgvStore.CurrentRow.Cells["Price"].Value.ToString() + "','" + clsFunction.M2SH(DateTime.Now) + "','" + System.DateTime.Now.ToLongTimeString() + "','" + Doc_Number + "','" + "30101" + "',19,'" + dgvStore.CurrentRow.Cells["ID"].Value.ToString() + "')";
string query2 = "INSERT INTO tbl_Transaction (Code, Bestankar, Notice, Date, Time, Doc_Number, Moeen, Parent, Parent_Code) VALUES ('" + Ass_Code + "','" + Convert.ToInt64(dgvStore.CurrentRow.Cells["Price"].Value) + "',N'" + "وصول چک شماره " + dgvStore.CurrentRow.Cells["Check_Number"].Value.ToString() + " " + "به مبلغ " + dgvStore.CurrentRow.Cells["Price"].Value.ToString() + "','" + clsFunction.M2SH(DateTime.Now) + "','" + System.DateTime.Now.ToLongTimeString() + "','" + Doc_Number + "','" + "10101" + "',19,'" + dgvStore.CurrentRow.Cells["ID"].Value.ToString() + "')";
string query4 = "UPDATE tbl_Check_Page SET State=0 WHERE ID='" + Convert.ToInt32(dgvStore.CurrentRow.Cells["ID_Check"].Value) + "' AND Check_Number='" + Convert.ToInt32(dgvStore.CurrentRow.Cells["Check_Number"].Value) + "'";
string query3 = "UPDATE tbl_Check_Pardakht SET State=0 WHERE ID='" + Convert.ToInt64(dgvStore.CurrentRow.Cells["ID"].Value) + "'";
if (clsFunction.Execute(dataconnection, query1) == true && clsFunction.Execute(dataconnection, query2) == true && clsFunction.Execute(dataconnection, query3) == true && clsFunction.Execute(dataconnection, query4) == true)
{
frmShow_Check_Pardakht_Activated(null, null);
}
}
}
}
}
private void BtnSearchGroup_Click(object sender, EventArgs e)
{
try
{
frmShow_PerssonelGroup f = new frmShow_PerssonelGroup(true);
if (f.ShowDialog() == DialogResult.OK)
{
LoadGroups();
cmbGroup.SelectedValue = f.SelectedGuid;
}
}
catch (Exception ex)
{
frmMessage f = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, ex.Message);
f.ShowDialog();
}
}
private void mnuEdit_Click(object sender, EventArgs e)
{
try
{
frmLottery f = new frmLottery();
f.op = "Edit";
f.Fill_Data((Convert.ToInt32(dgvStore.CurrentRow.Cells["Guid1"].Value.ToString())));
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "جشنواره انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void mnuEdit_Click(object sender, EventArgs e)
{
try
{
frmCus_Group f = new frmCus_Group();
f.op = "Edit";
f.FillData(Convert.ToInt32(dgvStore.CurrentRow.Cells["ID"].Value));
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "گروه انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void mnuInsert_Click(object sender, EventArgs e)
{
try
{
var frm = new frmCustomer();
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
LoadData();
}
catch (Exception ex)
{
var f = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, ex.Message);
f.ShowDialog();
}
}
private void mnuEdit_Click(object sender, EventArgs e)
{
try
{
frmCustomer f = new frmCustomer();
f.op = "Edit";
f.FillData(dgvStore.CurrentRow.Cells["Code"].Value.ToString());
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "مشتری انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void mnuEdit_Click(object sender, EventArgs e)
{
try
{
frmProduct_Type f = new frmProduct_Type();
f.op = "Edit";
f.FillData(trvP_Type.SelectedNode.Text);
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "طبقه بندی انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void mnuEdit_Click(object sender, EventArgs e)
{
try
{
frmPer_Leave f = new frmPer_Leave();
f.op = "Edit";
f.Fill_Data((Guid.Parse(dgvStore.CurrentRow.Cells["Guid_1"].Value.ToString())));
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "مرخصی انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void mnuShow_Tour_Click(object sender, EventArgs e)
{
try
{
frmShow_Cus_Club_Tour f = new frmShow_Cus_Club_Tour();
f.Fill_Data(dgvStore.CurrentRow.Cells["Code"].Value.ToString());
f.lblName.Text = dgvStore.CurrentRow.Cells["Perssonel_Name"].Value.ToString();
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "مشتری انتخابی فاقد گردش امتیاز می باشد";
f.ShowDialog();
}
}
private void mnuDelete_Click(object sender, EventArgs e)
{
string query1 = "DELETE FROM tbl_Body_Prd WHERE ID='" + Convert.ToInt32(dgvStore.CurrentRow.Cells["ID"].Value.ToString()) + "'";
string query2 = "DELETE FROM tbl_Header_Prd WHERE ID='" + Convert.ToInt32(dgvStore.CurrentRow.Cells["ID"].Value.ToString()) + "'";
frmMessage f = new frmMessage();
f.lblMessage.Text = "آیا از حذف فرمول " + dgvStore.CurrentRow.Cells["Prd_Name"].Value.ToString() + " " + "اطمینان دارید؟";
f.flag = 1;
f.ShowDialog();
if (f.Resault == 0)
{
if (clsFunction.Execute(dataconnection, query1) == true && clsFunction.Execute(dataconnection, query2) == true)
{
frmShow_Production_Activated(null, null);
}
}
}
private string LoadFromFile()
{
try
{
OpenFileDialog FD = new OpenFileDialog();
FD.Multiselect = false;
FD.InitialDirectory = Application.StartupPath + "\\pictures\\Customer";
if (!System.IO.Directory.Exists(FD.InitialDirectory))
{
System.IO.Directory.CreateDirectory(FD.InitialDirectory);
}
FD.Filter = @"*.JPG;*.GIF;*.PNG|*.JPG;*.GIF;*.PNG";
if (FD.ShowDialog() != DialogResult.OK)
{
return(null);
}
var aa = new System.IO.FileInfo(FD.FileName);
var attache = 1;
if (Application.StartupPath + "\\Pictures\\Customer\\" + aa.Name != aa.FullName)
{
string newName = "";
newName = aa.Name;
while (System.IO.File.Exists(Application.StartupPath + "\\Pictures\\Customer\\" + newName))
{
string nameLen = aa.Name.Length.ToString();
var extentionLength = aa.Extension.Length;
newName = aa.Name.Substring(0, Convert.ToInt32(double.Parse(nameLen) - extentionLength));
newName = newName + attache.ToString() + aa.Extension;
attache++;
}
System.IO.File.Copy(aa.FullName, Application.StartupPath + "\\Pictures\\Customer\\" + newName);
return(newName);
}
else
{
return(aa.Name);
}
}
catch (Exception ex)
{
frmMessage f = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, ex.Message);
f.ShowDialog();
return(null);
}
}
private void mnuEdit_Click(object sender, EventArgs e)
{
try
{
frmTransfer_BedBes f = new frmTransfer_BedBes();
f.op = "Edit";
f.Fill_Data(Guid.Parse(dgvProduct.CurrentRow.Cells["Guid1"].Value.ToString()));
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = " انتقال انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void mnuEdit_Click(object sender, EventArgs e)
{
try
{
frmBuy_Order f = new frmBuy_Order();
f.op = "Edit";
f.FillData(Convert.ToInt32(dgvStore.CurrentRow.Cells["ID"].Value.ToString()));
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = "سفارش خرید انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
private void dgOut_KeyUp(object sender, KeyEventArgs e)
{
if (curRow >= 0)
{
string make = dtOut.Rows[curRow]["Make"].ToString();
string jhh = dtOut.Rows[curRow]["JHH"].ToString();
string zfh = dtOut.Rows[curRow]["ZFH"].ToString();
string clh = dtOut.Rows[curRow]["CLH"].ToString();
string qa = dtOut.Rows[curRow]["QA"].ToString();
if (e.KeyCode == Keys.Enter)
{
if (dtOut.Rows[curRow]["WCFlag"].ToString() == "" || dtOut.Rows[curRow]["WCFlag"].ToString() == "0")
{
string now = DateTime.Now.ToString("yyyyMMddHHmmss");
dtOut.Rows[curRow]["SCANTIME"] = now;
dtOut.Rows[curRow]["WCFlag"] = 1;
Storage.SetExpScanStatus(jhh, make, zfh, clh, now);
//SqlCe.ExecuteNonQuery("update ExportStorageAcceptOrder set WCFlag=1,SCANTIME='" + dtOut.Rows[curRow]["SCANTIME"].ToString() + "' where CLH='" + dtOut.Rows[curRow]["CLH"].ToString() + "' and ZFH='" + dtOut.Rows[curRow]["ZFH"].ToString() + "' and JHH='" + dtOut.Rows[curRow]["JHH"].ToString() + "'");
PsionTeklogix.Sound.Beeper.Beeper.PlayTone(5000, 500, 100);
}
else if (dtOut.Rows[curRow]["WCFlag"].ToString() == "1")
{
frmMessage frm = new frmMessage();
frm.ShowDialog("是否取消消帐材料" + clh, "提示");
if (frm.ret)
{
Storage.ClearExpScanStatus(jhh, make, zfh, clh);
//SqlCe.ExecuteNonQuery("update ExportStorageAcceptOrder set WCFlag=0,SCANTIME='' where CLH='" + dtOut.Rows[curRow]["CLH"].ToString() + "' and ZFH='" + dtOut.Rows[curRow]["ZFH"].ToString() + "' and JHH='" + dtOut.Rows[curRow]["JHH"].ToString() + "'");
dtOut.Rows[curRow]["WCFlag"] = 0;
dtOut.Rows[curRow]["SCANTIME"] = "";
}
frm.Dispose();
}
RefreshJS();
}
if (e.KeyCode == Keys.F22 || e.KeyCode == Keys.F23)
{
frmQuality frmQuality = new frmQuality();
Global.frmCurrent = frmQuality;
frmQuality.Owner = this;
this.Hide();
frmQuality.Show(clh, qa);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
EstadoDTO estado = cboEstado.SelectedItem as EstadoDTO;
FornecedoresDTO dto = new FornecedoresDTO();
dto.Id = this.fornecedor.Id;
dto.Nome = txtNome.Text;
dto.Email = txtEmail.Text;
dto.CNPJ = txtCnpj.Text;
dto.Cidade = txtCidade.Text;
dto.CEP = mkbCep.Text;
dto.Telefone = txtTelefone.Text;
dto.IdEstado = estado.Id;
dto.Rua = txtRua.Text;
dto.Numero = txtNumero.Text;
FornecedoresBusiness business = new FornecedoresBusiness();
business.Alterar(dto);
string msg = "Fornecedor alterado com sucesso!";
frmMessage tela = new frmMessage();
tela.LoadScreen(msg);
tela.ShowDialog();
}
catch (ValidacaoException vex)
{
string msg = vex.Message;
frmAlert tela = new frmAlert();
tela.LoadScreen(msg);
tela.ShowDialog();
}
catch (Exception ex)
{
string msg = "Ocorreu um erro: " + ex.Message;
frmException tela = new frmException();
tela.LoadScreen(msg);
tela.ShowDialog();
}
}
private bool LoadNextSlipPaper(bool firstSlip)
{
bool result = true;
bool tryAgain;
NetTracer.Information("Peripheral [Printer] - Load next slip paper");
if (!firstSlip)
{
RemoveSlipPaper();
}
do
{
tryAgain = false;
NewStatusWindow(98);
oposPrinter.BeginInsertion(LSRetailPosis.Settings.HardwareProfiles.Printer.DocInsertRemovalTimeout * 1000);
if (oposPrinter.ResultCode == (int)OPOS_Constants.OPOS_SUCCESS)
{
NewStatusWindow(99);
oposPrinter.EndInsertion();
linesLeftOnCurrentPage = totalNumberOfLines;
PrintArray(headerLines);
}
else
{
CloseExistingMessageWindow();
using (frmMessage errDialog = new frmMessage(13051, MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
POSFormsManager.ShowPOSForm(errDialog);
if (errDialog.DialogResult == DialogResult.Yes)
{
tryAgain = true;
}
else
{
result = false;
}
}
}
} while (tryAgain);
return(result);
}
private void btnFinish1_Click(object sender, EventArgs e)
{
string query;
if (rbtnBarcode.Checked)
{
Identification = 0;
}
else if (rbtnCode.Checked)
{
Identification = 1;
}
else if (rbtnTec_Code.Checked)
{
Identification = 2;
}
SqlDataAdapter da = new SqlDataAdapter("SELECT Count (ID) FROM tbl_Product_Setting", dataconnection);
DataTable dt = new DataTable();
da.Fill(dt);
frmMessage f = new frmMessage();
f.lblMessage.Text = "تنظیمات کالا ست شده است." + "\n" + "ادامه می دهید؟";
f.flag = 1;
f.ShowDialog();
if (f.Resault == 0)
{
if (Convert.ToInt32(dt.Rows[0].ItemArray[0]) <= 0)
{
query = "INSERT INTO tbl_Product_Setting (ID, Pic_Patch, Current_Unit, Identification, Type_Name) VALUES (1,'" + txtPatch.Text + "',N'" + cmbUnit.Text + "','" + Identification + "','" + chbType_Name.Checked + "')";
if (clsFunction.Execute(dataconnection, query) == true)
{
this.Close();
}
}
else
{
query = "UPDATE tbl_Product_Setting SET Pic_Patch = '" + txtPatch.Text + "', Current_Unit = N'" + cmbUnit.Text + "', Identification = '" + Identification + "', Type_Name = '" + chbType_Name.Checked + "' WHERE ID=1";
if (clsFunction.Execute(dataconnection, query) == true)
{
this.Close();
}
}
}
}
public void Back()
{
try
{
top--;
if (top <= 0)
{
btnBack.Text = "خروج";
}
btnNext.Text = "مرحله بعد";
LoadNewForm(listForms[top]);
}
catch (Exception ex)
{
frmMessage f = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, ex.Message);
f.ShowDialog();
}
}
public void Next()
{
try
{
top++;
if (top >= Count - 1)
{
btnNext.Text = "ثبت اطلاعات";
}
btnBack.Text = "مرحله قبل";
LoadNewForm(listForms[top]);
}
catch (Exception ex)
{
frmMessage f = new frmMessage(EnumMessageFlag.ShowFlag, Color.Red, ex.Message);
f.ShowDialog();
}
}
private void mnuView_Click(object sender, EventArgs e)
{
try
{
frmTransfer_BedBes f = new frmTransfer_BedBes();
f.Fill_Data(Guid.Parse(dgvProduct.CurrentRow.Cells["Guid1"].Value.ToString()));
f.grpAccount.Enabled = false;
f.btnFinish.Enabled = false;
f.ShowDialog();
}
catch
{
frmMessage f = new frmMessage();
f.flag = 0;
f.lblMessage.Text = " انتقال انتخابی معتبر نمی باشد";
f.ShowDialog();
}
}
/// <summary>
/// Đăng ký làm thêm giờ
/// </summary>
public void RegDepartmentOverTime(DateTime workingDay)
{
frmMessage frmMessage = new frmMessage();
string OverTimeMessage = "";
int STT = 0;
for (int i = 0; i < lvwListEmployee.SelectedIndicies.Length; i++)
{
// chỉ số hàng được chọn
int rowIndex = (int)lvwListEmployee.SelectedItems[i].Tag;
DataRow drEmployee = dsEmployee.Tables[0].Rows[rowIndex];
// dr.BeginEdit();
// foreach (DataRow drEmployee in dsEmployee.Tables[0].Rows)
// {
int ret = 0;
try
{
DataRow dr = dsRegOverTime.Tables[0].NewRow();
// dr.BeginEdit();
dr.BeginEdit();
dr["EmployeeID"] = drEmployee["EmployeeID"];
ShiftDO shiftDO = new ShiftDO();
DataSet dsShiftOver = shiftDO.GetShiftOverByID(int.Parse(cboShift.SelectedValue.ToString()));
dr["ShiftOverID"] = dsShiftOver.Tables[0].Rows[0]["ShiftOverID"].ToString();
dr["StartOverTime"] = dsShiftOver.Tables[0].Rows[0]["TimeIn"].ToString();
DateTime startTime = Convert.ToDateTime(dsShiftOver.Tables[0].Rows[0]["TimeIn"].ToString());
DateTime stopTime = Convert.ToDateTime(dsShiftOver.Tables[0].Rows[0]["TimeOut"].ToString());
DateTime startLunch = Convert.ToDateTime(dsShiftOver.Tables[0].Rows[0]["LunchStart"].ToString());
DateTime stopLunch = Convert.ToDateTime(dsShiftOver.Tables[0].Rows[0]["LunchStop"].ToString());
DateTime startDinner = Convert.ToDateTime(dsShiftOver.Tables[0].Rows[0]["DinnerStart"].ToString());
DateTime stopDinner = Convert.ToDateTime(dsShiftOver.Tables[0].Rows[0]["DinnerStop"].ToString());
TimeSpan leng = stopTime - startTime - (stopLunch - startLunch) - (stopDinner - startDinner);
DateTime length = Convert.ToDateTime("12/12/2005 " + leng.Hours + ":" + leng.Minutes + ":" + leng.Milliseconds);
dr["Length"] = Convert.ToDateTime(length).ToShortTimeString();
//Convert.ToDateTime(stopTime - startTime - (stopLunch - startLunch) - (stopDinner - startDinner))
// .ToShortTimeString();
dr["WorkingDay"] = workingDay.ToShortDateString();
dr["WorkOverTimeInfo"] = txtWorkOverTimeInfo.Text;
if (ckHaveDinner.Checked)
{
dr["DinnerAmount"] = Double.Parse(cboDinnnerAmount.Text);
}
else
{
dr["DinnerAmount"] = DBNull.Value;
}
dr.EndEdit();
dsRegOverTime.Tables[0].Rows.Add(dr);
ret = regOverTimeDO.AddRegOverTime(dsRegOverTime);
}
catch
{
}
if (ret == EmployeeStatus.EMPLOYEE_LEAVE)
{
OverTimeMessage = drEmployee["CardID"] + " - " + drEmployee["EmployeeName"] + " đã đi công tác";
STT++;
frmMessage.AddMessage(STT.ToString() + ". " + OverTimeMessage);
}
if (ret == EmployeeStatus.EMPLOYEE_REST)
{
OverTimeMessage = drEmployee["CardID"] + " - " + drEmployee["EmployeeName"] + " đã đăng ký nghỉ";
STT++;
frmMessage.AddMessage(STT.ToString() + ". " + OverTimeMessage);
}
//else if (ret == EmployeeStatus.EMPLOYEE_ABSENT)
//{
// OverTimeMessage = drEmployee["CardID"] + " - " + drEmployee["EmployeeName"] + " vắng mặt";
// STT++;
// frmMessage.AddMessage(STT.ToString() + ". " + OverTimeMessage);
//}
}
if (STT != 0)
{
frmMessage.Show();
}
else
{
frmMessage.Close();
string str = WorkingContext.LangManager.GetString("frmRegOverTime1_DangKyOT_Messa1");
string str1 = WorkingContext.LangManager.GetString("frmRegOverTime1_DangKyOT_Title");
//MessageBox.Show("Không thể đăng ký làm thêm giờ cho nhân viên này", "Đăng ký làm thêm giờ", MessageBoxButtons.OK, MessageBoxIcon.Error);
MessageBox.Show(str, str1, MessageBoxButtons.OK, MessageBoxIcon.Information);
// if ((this.Text =="Thêm đăng ký làm thêm giờ" )|| (this.Text == "Sửa đăng ký làm thêm giờ"))
// {
// MessageBox.Show("Đăng ký làm thêm giờ cho bộ phận " + departmentTreeView.SelectedNode.Text + " thành công!", "Đăng ký làm thêm giờ", MessageBoxButtons.OK, MessageBoxIcon.Information);
// }
// else
// {
// MessageBox.Show(departmentTreeView.SelectedNode.Text +" の部門の残業登録が正常に完了しました !","",MessageBoxButtons.OK, MessageBoxIcon.Information);
//
// }
}
}
