private void load_items_donvi()
{
try
{
using (_khieunaitocaoContext = new khieunaitocaoContextDataContext())
{
var look = (from f in _khieunaitocaoContext.tb_donvis
select new
{
f.ma_donvi,
f.kyhieu_donvi,
f.ten_donvi
}).ToList();
look_donvinhan.Properties.DataSource = look;
look_donvinhan.Properties.DisplayMember = "ten_donvi";
look_donvinhan.Properties.ValueMember = "ma_donvi";
}
}
catch (Exception)
{
//throw;
XtraMessageBox.Show("Vui lòng kiểm tra lại kết nối mạng");
}
}
public void Cambiarsemana(int origen, int destino)
{
int cantidad;
DialogResult respuesta;
string mensaje;
var q = from p in EntidadAdminpaq.mmovimientos where p.cCalClave == origen select p;
q.ToList().ForEach(x => x.cCalClave = destino);
cantidad = q.Count();
mensaje = "Realmente quieres cambiar " + Convert.ToString(cantidad) + " Registros";
Cursor.Current = Cursors.Default;
respuesta = XtraMessageBox.Show(mensaje, "Cambiar Semana", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (respuesta == DialogResult.Yes)
{
Cursor.Current = Cursors.WaitCursor;
EntidadAdminpaq.SaveChanges();
XtraMessageBox.Show("Semana Cambiada", "Semanas");
Cursor.Current = Cursors.Default;
}
else
{
XtraMessageBox.Show("Cancelado", "Semanas");
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (iTN.DateTime < iDN.DateTime && iCS.EditValue != null)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("ChinhSachID", iCS.EditValue);
if (XuLyGiaoDien.ThongBao("Chi tiết chính sách sửa", _SODU_DAILYD.CapNhat(dic, IDDaiLy, "WHERE DAILYID= {0} and convert(date,Ngay) between '" + iTN.DateTime.ToString("yyyyMMdd") + "' and '" + iDN.DateTime.ToString("yyyyMMdd") + "'") > 0))
{
if (DateTime.Now.ToString("ddMMyyyy") == iDN.DateTime.ToString("ddMMyyyy"))
{
(Owner as frmDaiLyThem).iChinhSach.EditValue = iCS.EditValue;
dic = new Dictionary <string, object>();
dic.Add("ChinhSach", iCS.EditValue);
DaiLyD.CapNhat(dic, IDDaiLy);
}
DaiLyD.ChayLaiPhi(iTN.DateTime);
Close();
}
}
else
{
XtraMessageBox.Show("Thông tin nhập không hợp lệ. Vui lòng kiểm tra lại", "Thông báo");
}
}
private void ExportExcel(object sender, ItemClickEventArgs e)
{
SaveFileDialog dialog = new SaveFileDialog {
RestoreDirectory = true, Filter = @"Excel Files (*.xlsx)|*.xlsx"
};
if (dialog.ShowDialog() == DialogResult.OK)
{
XlsxExportOptionsEx advOptions = new XlsxExportOptionsEx {
ExportType = DevExpress.Export.ExportType.DataAware,
TextExportMode = TextExportMode.Value,
SheetName = Settings.ActiveHost.Server
};
try {
grid.ExportToXlsx(dialog.FileName, advOptions);
Output.Current.Add($"Export to Excel: {dialog.FileName}");
}
catch (Exception ex) {
Output.Current.Add("Export to Excel failed", ex.Message);
XtraMessageBox.Show(ex.Message.Replace(". ", "." + Environment.NewLine), ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnActivate_Click(object sender, EventArgs e)
{
try
{
var check = calc();
if (Convert.ToInt32(txtCode.Text) == Convert.ToInt32(check))
{
Properties.Settings.Default.isPaid = true;
Properties.Settings.Default.Save();
XtraMessageBox.Show("تم التفعيل بنجاح", "التفعيل", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
}
else
{
XtraMessageBox.Show("من فضلك أدخل رقم سيريال صحيح", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtCode.Text = string.Empty;
}
}
catch
{
XtraMessageBox.Show("من فضلك أدخل رقم سيريال صحيح", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
private void pictureEditFile_EditValueChanged(object sender, EventArgs e)
{
try
{
var bitmap = pictureEditFile.Image as Bitmap;
if (bitmap == null)
{
throw new Exception("Нет изображения");
}
using (var image = new Image <Bgr, byte>(bitmap))
{
var length = image.Data.Length;
var bytes = new byte[length];
var handle = GCHandle.Alloc(image.Data, GCHandleType.Pinned);
Marshal.Copy(handle.AddrOfPinnedObject(), bytes, 0, bytes.Length);
handle.Free();
var average = bytes.Average(x => (double)x);
var delta = Math.Sqrt(bytes.Average(x => (double)x * x) - average * average);
var minValue = bytes.Min(x => (double)x);
var maxValue = bytes.Max(x => (double)x);
var sb = new StringBuilder();
sb.AppendLine(string.Format("Length {0}", length));
sb.AppendLine(string.Format("Average {0}", average));
sb.AppendLine(string.Format("Delta {0}", delta));
sb.AppendLine(string.Format("minValue {0}", minValue));
sb.AppendLine(string.Format("maxValue {0}", maxValue));
siInfo.Caption = sb.ToString();
}
}
catch (Exception exception)
{
XtraMessageBox.Show(exception.Message);
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
//blinding dữ liệu tương ứng từ cột mã loại khi nhập vào các cell mã vật tư, tên vt, loại từ bảng Vật tư
GridView view = sender as GridView;
// nếu cột không có giá trị thì trả về....
if (view == null) return;
{
switch (e.Column.Caption.ToString())
{
case "Model":
string sql2 = @"select tensp,dvt from VatTu where model = '" + view.GetRowCellValue(e.RowHandle, view.Columns[0]).ToString() + "' ";
// thực thi câu lệnh sql thành dạng bảng
DataTable tb = Connect.getTable(sql2);
//blinding dvt
view.SetRowCellValue(e.RowHandle, view.Columns[2], "");
string cellValue2 = "" + tb.Rows[0]["dvt"].ToString().Trim() + "" + view.GetRowCellValue(e.RowHandle, view.Columns[2]).ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[2], cellValue2);
//blinding tenvt
view.SetRowCellValue(e.RowHandle, view.Columns[1], "");
string cellValue1 = "" + tb.Rows[0]["tensp"].ToString().Trim() + "" + view.GetRowCellValue(e.RowHandle, view.Columns[1]).ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[1], cellValue1);
break;
}
}
}
catch
{
XtraMessageBox.Show("Vui lòng kiểm tra lại dữ liệu nhập!!");
}
}
/// <summary>
/// Prints the data.
/// </summary>
protected virtual void PrintData()
{
try
{
ActionMode = ActionModeEnum.None;
Cursor.Current = Cursors.WaitCursor;
var reportHelper = new ReportHelper();
_reportList = _reportListPresenter.GetAllReportList();
if (_reportList == null)
{
return;
}
reportHelper.ReportLists = _reportList;
reportHelper.PrintPreviewReport(null, ReportID, false);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void simpleButton3_Click(object sender, EventArgs e)
{
DialogResult dr = XtraMessageBox.Show("Voulez-vous vraiment supprimer?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dr == DialogResult.OK)
{
try
{
etudiantBindingSource.RemoveCurrent();
update();
}
catch (Exception ex)
{
XtraMessageBox.Show("Erreur : " + ex.Message);
}
finally
{
etudiantBindingSource.CancelEdit();
//etudiantBindingSource.EndEdit();
this.etudiantTableAdapter.Fill(this.gestionCiteDataSet.Etudiant);
//etudiantGridControl.DataSource = etudiantBindingSource;
}
}
}
protected override void OnSaving()
{
if (_editTaskTimeHistory == null)
{
return;
}
if (_editTaskTimeHistory.Overtime > _editTaskTimeHistory.Effort)
{
View.ValidateResult = false;
XtraMessageBox.Show(Properties.Resources.OverTimeTip,
Properties.Resources.Katrin,
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1);
return;
}
if (_editTaskTimeHistory.ActualInput == 0)
{
View.ValidateResult = false;
XtraMessageBox.Show(Properties.Resources.ActualInputIsZero,
Properties.Resources.Katrin,
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1);
return;
}
dynamic taskEntity = DynamicDataServiceContext.GetOrNew("ProjectTask", _editTaskTimeHistory.TaskId);
if (!UpdateTask(taskEntity, _editTaskTimeHistory))
{
return;
}
SetHistory(_editTaskTimeHistory);
View.ValidateResult = true;
}
private async void Apagar_Registro()
{
Cursor = Cursors.WaitCursor;
try
{
if (!PermissoesIdTextEdit.Text.Equals(string.Empty))
{
if (MessageBox.Show("Estas preste a apagar o (" + GrupoIdLookUpEdit.Text + ")! pretendes continuar?", "Alteração de dados", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
var curs = new Permissoes
{
PermissoesId = (int)PermissoesIdTextEdit.EditValue,
};
if ((await PermissoesPermissaoControllers.GetInstacia().Delete(curs)).IsSucess)
{
XtraMessageBox.Show("Serviço Apagado com Sucesso!...", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Information);
ListGeral();
limpar_Campos();
}
else
{
XtraMessageBox.Show("Este Valor já existe tente novamente", "Má conclusão", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
catch (System.Exception exe)
{
MessageBox.Show(exe.Message, "Erro de SQL", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
//public void upFolder(string webpath, string localpath, ArrayList foldername, UserInformation userinformation, RefreshListViewSuccess refresh, UpYunLibrary.UpYun.SetProgressBar setprogressbar)
//{
//}
public void upFileByUpYun(string localpath, string webpath, ArrayList filenamelist, UserInformation userinformation, RefreshListViewSuccess refresh, UpYunLibrary.UpYun.SetProgressBar setprogressbar)
{
int SelectNum = filenamelist.Count;
try
{
for (int i = 0; i < SelectNum; i++)
{
string localpath_up = localpath + filenamelist[i];
FileStream fs = new FileStream(localpath_up, FileMode.Open, FileAccess.Read);
BinaryReader r = new BinaryReader(fs);
byte[] postArray = r.ReadBytes((int)fs.Length);
string webpath_up = webpath + filenamelist[i];
userinformation.upYun.writeFile(webpath_up, postArray, true, setprogressbar);
fs.Close();
}
}
catch (Exception ex)
{
refresh(false);
XtraMessageBox.Show(ex.ToString(), "错误信息");
}
refresh(true);
}
private void simpleButton3_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Title = "Joindre un fichier";
if (ofd.CheckFileExists == true)
{
ofd.Filter = "";
ofd.ShowDialog();
if (ofd.FileName != "")
{
// 5MO max pour un fichier
FileInfo fi = new FileInfo(ofd.FileName);
if (fi.Length < 5000000)
{
textEdit2.Text = ofd.FileName;
}
else
{
XtraMessageBox.Show("Le fichier selectionné dépasse la taille autorisée(5 MO)", "Attention", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
private async void MenuApagar_Click(object sender, System.EventArgs e)
{
var userdelete = alunoModelsBindingSource.Current as AlunoModels;
if (userdelete != null)
{
if (MessageBox.Show("Tens a certeza de que queres mesmo apagar esta infromação?",
"Perda de Dados Permanente", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
try
{
if (await alunoModels.Delete(userdelete))
{
XtraMessageBox.Show("Apagado com Exito", "Apagar infromação", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (System.Exception exe)
{
XtraMessageBox.Show(MessageCaption.ErrorRelacionalShipe + exe.Message,
"Apagar infromação", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void FrmGetMateriasCursos_Load(object sender, EventArgs e)
{
try
{
MateriasCurso mtC = new MateriasCurso();
mtC.Curso.CodigoCurso = CodCurso;
DataTable dt1 = new DataTable();
if (Modo != "E")
{
dt1 = CtrlMateriasCursos.GetMateNoAsigNadas(mtC).Tables[0];
}
else
{
dt1 = CtrlMateriasCursos.GetMateAsigNadas(mtC).Tables[0];
LueMateria.Enabled = false;
}
LueMateria.Properties.DataSource = dt1;
LueMateria.Properties.DisplayMember = "Nombre";
LueMateria.Properties.ValueMember = "CodMateria";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LueMateria.Properties.Columns.Add(col);
LueMateria.ItemIndex = -1;
CargarDatos(Modo);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
return;
}
TxtNombre.Focus();
}
private void simpleButton18_Click(object sender, EventArgs e)
{
string s_retstr = TaxInvoice.WrapData("FPKJ", memoEdit2.Text, memoEdit1.Text);
//分析返回结果
Object obj = JsonConvert.DeserializeObject(s_retstr);
Newtonsoft.Json.Linq.JObject js = obj as Newtonsoft.Json.Linq.JObject;
if (js["code"].ToString() == "00000") //成功
{
string data = js["data"].ToString();
//解密 返回数据
string resultText = Tools.AesDecrypt(data, Envior.TAX_PRIVATE_KEY);
//解析真正的业务数据
Object obj2 = JsonConvert.DeserializeObject(resultText);
Newtonsoft.Json.Linq.JObject js2 = obj2 as Newtonsoft.Json.Linq.JObject;
XtraMessageBox.Show("发票开具成功!");
}
else
{
XtraMessageBox.Show("发票开具失败!\r\n" + js["msg"].ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LueMateria_EditValueChanged(object sender, EventArgs e)
{
if (LueMateria.EditValue != null)
{
LueProfesor.Enabled = true;
codMateria = LueMateria.EditValue.ToString();
Materia mat = new Materia();
mat.CodMateria = codMateria;
DataSet ds = CtrlMaterias.GetMateriaOneCod(mat);
TxtNombreArea.Text = ds.Tables[0].Rows[0]["NombreArea"].ToString();
codArea = ds.Tables[0].Rows[0]["CodArea"].ToString();
try
{
ProfesorMaterias prMat = new ProfesorMaterias();
prMat.Materia.CodMateria = codMateria;
DataTable dt2 = CtrlProfesorMaterias.GetProfesorMat(prMat).Tables[0];
LueProfesor.Properties.DataSource = dt2;
LueProfesor.Properties.DisplayMember = "Nombre";
LueProfesor.Properties.ValueMember = "CodigoProfesor";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col1;
col1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LueProfesor.Properties.Columns.Clear();
LueProfesor.Properties.Columns.Add(col1);
LueProfesor.ItemIndex = -1;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
return;
}
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!string.IsNullOrEmpty(_Id))
{
var score = _resultService.GetResultById(_Id);
if (score != null)
{
dynamic mboxResult = XtraMessageBox.Show($"Bạn có thực sự muốn xóa '{score.FullName}' không? \n'Yes' để xóa. \n'No' hủy bỏ.",
"THÔNG BÁO",
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (mboxResult == DialogResult.Yes)
{
try
{
_resultService.Delete(_Id);
LoadData();
EnableButtonEditAndDelete(false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Vui lòng chọn lại!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Vui lòng chọn một người cần sửa!", "THÔNG BÁO", MessageBoxButtons.YesNo,
MessageBoxIcon.Error);
}
}
private void LoadDanhSachNhaCungCapByKey(DataTable dataNhaCungCap)
{
if (dataNhaCungCap == null)
{
XtraMessageBox.Show("ĐÃ CÓ LỖI XẢY RA KHI TẢI DỮ LIỆU!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataGridViewNhaCungCap.Columns.Clear();
dataGridViewNhaCungCap.DataSource = null;
dataGridViewNhaCungCap.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridViewNhaCungCap.AutoGenerateColumns = false;
//dataGridViewNhaCungCap.AllowUserToAddRows = false;
dataGridViewNhaCungCap.DataSource = dataNhaCungCap;
CreatedataGridViewNhaCungCap();
// dgvLoadSach.Sort(dgvLoadSach.Columns[0], ListSortDirection.Ascending);
CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[dataGridViewNhaCungCap.DataSource];
myCurrencyManager.Refresh();
}
private void barBtnImport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
open.Filter = "All Excel Files(*.xls,*.xlsx)|*.xls;*.xlsx";
open.Title = "Chọn tập tin để Import";
if (open.ShowDialog() == DialogResult.OK)
{
DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this.ParentForm, typeof(WaitForm1), true, true, false);
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Đang Import...");
if (PTB_GUI.Libraries.ExcelDataBaseHelper.ImportViTri(open.FileName, "ViTri"))
{
DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm(false);
XtraMessageBox.Show("Import thành công!");
loadData();
}
else
{
DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm(false);
XtraMessageBox.Show("Import không thành công!");
loadData();
}
}
}
//Evento utilizado para obtener las dosis aplicadas a la cerda
private void ibuDosis_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try {
//Recuperamos la fila seleccionada e instanciamos con la clase detalle parto
clsGraPartoDet objFila = (clsGraPartoDet)this.grvListado.GetRow(this.grvListado.FocusedRowHandle);
//Verificamos si existe una chapeta seleccionada
if (objFila.AnmCodigo.Equals(0))
{
return;
}
xfrmGraAuxDosis objFormulario;
if (objFila.EstCodigo.Equals(""))
{
objFormulario = new xfrmGraAuxDosis(objFila.AnmCodigo, objFila.AnmAlternativo, objFila.IteNombre, true, true, 0);
}
else
{
objFormulario = new xfrmGraAuxDosis(objFila.AnmCodigo, objFila.AnmAlternativo, objFila.IteNombre, true, false, int.Parse(this.txtCodigo.Text));
}
objFormulario.StartPosition = FormStartPosition.CenterParent;
objFormulario.ShowDialog();
}
catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
private void btnNhapds_Click(object sender, EventArgs e)
{
if (cmbHealthExam.SelectedValue == null)
{
XtraMessageBox.Show("Mời bạn chọn đợt khám sức khỏe", "Thông báo");
}
else if (cmbLopHoc.SelectedValue == null)
{
XtraMessageBox.Show("Mời bạn chọn lớp học", "Thông báo");
}
else
{
frmNewHealthExamDetail m_frmNewHealth = new frmNewHealthExamDetail();
m_frmNewHealth.iFunction = 1;
m_frmNewHealth.healthExamination = new HealthExaminationDAO().GetByID(int.Parse(cmbHealthExam.SelectedValue.ToString()));
m_frmNewHealth.Class = new ClassDAO().GetByClassID(int.Parse(cmbLopHoc.SelectedValue.ToString()));
m_frmNewHealth.ShowDialog();
if (m_frmNewHealth.DialogResult == DialogResult.OK)
{
FillGridControl(int.Parse(cmbLopHoc.SelectedValue.ToString()), int.Parse(cmbHealthExam.SelectedValue.ToString()));
}
}
}
protected override void BtnSave_Click(object sender, EventArgs e)
{
List <DepartmentVo> staffOldInfoList = SelectDao.SelectData <DepartmentVo>();
List <DepartmentVo> changeList = GenericUtil.GetChanges(departmentVoList, staffOldInfoList);
int result = 0;
if (!CheckParam(changeList))
{
return;
}
foreach (DepartmentVo vo in changeList)
{
if (SelectDao.IsRepeatedDepartmentId(vo.Id))
{
//更新
result = UpdateDao.UpdateByID(vo);
if (result <= 0)
{
XtraMessageBox.Show(vo.Id + "更新失败！");
break;
}
}
else
{
vo.CompanyId = SystemConst.companyId;
result = InsertDao.InsertData(vo);
if (result <= 0)
{
XtraMessageBox.Show(vo.Id + "保存失败！");
break;
}
}
}
EventBus.PublishEvent("UpdateDepartment");
XtraMessageBox.Show("保存成功！");
}
public static string FindingFileName(string path, string name, bool showMessage)
{
string str = "\\";
for (int i = 0; i <= 10; i++)
{
if (File.Exists(string.Concat(path, str, name)))
{
return(Path.GetFullPath(string.Concat(path, str, name)));
}
str = string.Concat(str, "..\\");
}
string currentDirectory = Environment.CurrentDirectory;
if (currentDirectory != path)
{
return(FindingFileName(currentDirectory, name, showMessage));
}
if (showMessage)
{
XtraMessageBox.Show(string.Concat("Archivo ", name, " no se existe"), "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
return("");
}
public void tsbtdeletepctmvt(DevExpress.XtraGrid.Views.Grid.GridView view, Form1 F)
{
try
{
string name = view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString();
if (gen.GetString("select Posted from SUCAPayment where RefID='" + name + "'") == "True")
{
XtraMessageBox.Show("Phiếu đã được ghi sổ không thể xóa.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (XtraMessageBox.Show("Bạn có chắc muốn xóa phiếu thu tiền mặt bán vật tư " + view.GetRowCellValue(view.FocusedRowHandle, "Số chứng từ").ToString() + "?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
gen.ExcuteNonquery("delete from SUCAPayment where RefID='" + name + "'");
gen.ExcuteNonquery("delete from SUCAPaymentDetail where RefID='" + name + "'");
gen.ExcuteNonquery("delete HACHTOAN where RefID='" + name + "'");
view.DeleteRow(view.FocusedRowHandle);
/*gen.ExcuteNonquery("update SUCAPayment set Cancel='True', Posted='True' where RefID='" + name + "'");
* view.SetRowCellValue(view.FocusedRowHandle, view.Columns["Hủy"], "True");
* view.SetRowCellValue(view.FocusedRowHandle, view.Columns["Số tiền"], "0");*/
}
}
catch { XtraMessageBox.Show("Vui lòng chọn phiếu chi tiền mặt mua vật tư trước khi xóa.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); }
}
private void onClickEnter()
{
if (CheckInput())
{
textUser.Enabled = false;
textPass.Enabled = false;
this.labelMsg.Visible = true;
this.labelMsg.Text = "正在连接服务器";
this.progressBarControl1.Visible = true;
this.progressBarControl1.EditValue = 0;
this.bLogin.Visible = false;
this.bSet.Visible = false;
this.Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
initThread = new Thread(new ThreadStart(Login));
initThread.IsBackground = true;
initThread.Start();
}
else
{
XtraMessageBox.Show("请输入用户名和口令!");
}
}
private void gridControl2_Click(object sender, EventArgs e)
{
try
{
foreach (int i in this.gridView2.GetSelectedRows())
{
DataRow row = this.gridView2.GetDataRow(i);
textIdDomicilio.Text = row["Id_Domicilio"].ToString();
textCalle.Text = row["Calle"].ToString();
textNoInterior.Text = row["NoInterior"].ToString();
textNoExterior.Text = row["NoExterior"].ToString();
textCodigoPostal.Text = row["Codigo_Postal"].ToString();
textColonia.Text = row["Colonia"].ToString();
textEstado.Tag = row["Id_Estado"].ToString();
textEstado.Text = row["Nombre_Estado"].ToString();
textTipoDomicilio.Tag = row["Id_TipoDomicilio"].ToString();
textTipoDomicilio.Text = row["Nombre_TipoDomicilio"].ToString();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
//nut luu
private void simpleButton4_Click(object sender, EventArgs e)
{
obj.MaTheLoai = txtMaTL.Text;
obj.TenTheLoai = txtTen.Text;
obj.MoTa = txtMota.Text;
if (IsInsert == true)
{
//insert
bus.Insert(obj);
XtraMessageBox.Show("Thêm thành công!");
HienThi();
XoaText();
KhoaDieuKhien();
}
else
{
//update
bus.Update(obj);
XtraMessageBox.Show("Sửa thành công!");
HienThi();
XoaText();
KhoaDieuKhien();
}
}
private void Button11_Click(object sender, EventArgs e)
{
if (dateTimePicker11.CustomFormat == " ")
{
XtraMessageBox.Show("Tarih Alanı Boş Bırakılamaz");
return;
}
else
{
islemsırası = 11;
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.ShowDialog();
openFileDialog1.Title = "Servis Formu Yükleyiniz";
if (openFileDialog1.FileName != "")
{
servisformu = openFileDialog1.FileName;
DökümanVeritabanıYükle();
label11.Text = "11.Servis Formu Yüklendi✔";
label11.ForeColor = Color.Green;
dateTimePicker12.Enabled = true;
button12.Enabled = true;
}
}
}
//[DllImport("nkpjk.dll", EntryPoint = "PLoginSuccess")]
//private extern static int PLoginSuccess();
//[DllImport("nkpjk.dll", EntryPoint = "PGetCurPh", CallingConvention = CallingConvention.StdCall, CharSet = CharSet.Ansi)]
//private extern static int GetCurPh(string ptype, [MarshalAs(UnmanagedType.LPStr)]StringBuilder res);
//[DllImport("nkpjk.dll", EntryPoint = "PZrPj", CallingConvention = CallingConvention.StdCall, CharSet = CharSet.Ansi)]
//private extern static int PZrPj(string invdata,int ifprt,string pjlx,string bz, [MarshalAs(UnmanagedType.LPStr)]StringBuilder res);
//[DllImport("nkpjk.dll", EntryPoint = "PDelPj", CallingConvention = CallingConvention.StdCall, CharSet = CharSet.Ansi)]
//private extern static int PDelPj(string pjh, [MarshalAs(UnmanagedType.LPStr)]StringBuilder res);
//[DllImport("nkpjk.dll", EntryPoint = "PZrTkkp", CallingConvention = CallingConvention.StdCall, CharSet = CharSet.Ansi)]
//private extern static int PZrTkkp(string oldph,string oldpjlx,string oldzch,string newpjlx,string tkitem,string aqt, [MarshalAs(UnmanagedType.LPStr)]StringBuilder res);
///// <summary>
///// 连接开票服务器
///// </summary>
///// <returns></returns>
//public static int Connect()
//{
// int result = ConnectKp();
// return result;
//}
///// <summary>
///// 连接开票服务器
///// </summary>
///// <param name="user"></param>
///// <param name="pwd"></param>
///// <param name="zt"></param>
///// <returns></returns>
//public static int AdvConnect(string user,string pwd,string zt)
//{
// return AdvConnectKp(user, pwd, zt);
//}
///// <summary>
///// 断开开票服务器
///// </summary>
///// <returns></returns>
//public static int DisConnect()
//{
// return DisconnectKp();
//}
///// <summary>
///// 判断是否连接博思开票服务器
///// </summary>
///// <returns></returns>
//public static bool IsConnect()
//{
// if (PLoginSuccess() == 1)
// return true;
// else
// return false;
//}
/// <summary>
/// 获取当前下张票号
/// </summary>
/// <param name="batch_code"></param>
/// <param name="bill_no"></param>
/// <returns></returns>
public static int GetCurrentPh()
{
//业务数据
Dictionary <string, object> bdata = new Dictionary <string, object>();
Dictionary <string, Dictionary <string, object> > msg = new Dictionary <string, Dictionary <string, object> >();
bdata.Add("place_code", Envior.FIN_BILL_SITE); //开票点编码
bdata.Add("bill_batch_code", Envior.FIN_BATCH_CODE); //票据代码(注册号)
msg.Add("message", bdata);
string s_json = Tools.ConvertObjectToJson(msg);
string s_ret = SendRequest("stock.billno.get", s_json);
Dictionary <string, object> retdata = JsonConvert.DeserializeObject <Dictionary <string, object> >(s_ret);
if (retdata != null)
{
if (retdata.ContainsKey("message"))
{
Dictionary <string, string> success_msg = JsonConvert.DeserializeObject <Dictionary <string, string> >(retdata["message"].ToString());
Envior.FIN_NEXT_BATCH_CODE = success_msg["bill_batch_code"];
Envior.FIN_NEXT_BILL_NO = success_msg["bill_no"];
return(1);
}
else
{
Dictionary <string, string> error_msg = JsonConvert.DeserializeObject <Dictionary <string, string> >(retdata["error_message"].ToString());
XtraMessageBox.Show("获取票据号错误!" + error_msg["error_msg"] + "\r\n" + "错误代码:" + error_msg["error_code"], "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(-1);
}
}
else
{
XtraMessageBox.Show("未获取到数据!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(-1);
}
}
