private void EnviarAUiCommandManager_CommandClick(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
switch (e.Command.Key)
{
case "Impresora":
Cedeira.SV.Fun.ImprimirGrilla(this, ListaGridEX, Aplicacion.Titulo, true);
break;
case "Planilla":
try
{
Cedeira.SV.Export planilla = new Cedeira.SV.Export();
Cursor = Cursors.WaitCursor;
planilla.ExportDetails(ListaGridEX, Cedeira.SV.Export.ExportFormat.Excel, this.Text + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");
}
catch (Exception ex)
{
Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(ex);
}
finally
{
Cursor = Cursors.Default;
}
break;
}
}
private void buttonCommand1_Click(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
if (panel1.Size.Height == 23)
panel1.Size = new Size(panel1.Size.Width, 100);
else
panel1.Size = new Size(panel1.Size.Width, 23);
}
public static void ExportGridEx(Janus.Windows.GridEX.GridEX gridEx )
{
Stream sw = null;
try
{
var sd = new SaveFileDialog { Filter = "Excel File (*.xml)|*.xml" };
if (sd.ShowDialog() == DialogResult.OK)
{
//sw = new FileStream(sd.FileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);
sw = new FileStream(sd.FileName, FileMode.Create);
GridEXExporter grdListExporter = new GridEXExporter();
grdListExporter.IncludeExcelProcessingInstruction = true;
grdListExporter.IncludeFormatStyle = true;
grdListExporter.IncludeHeaders = true;
grdListExporter.GridEX = gridEx;
grdListExporter.Export(sw);
Utility.ShowMsg("Xuất dữ liệu thành công");
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
finally
{
if (sw != null)
{
sw.Flush();
sw.Close();
sw.Dispose();
}
}
}
void grdVTTH_CellUpdated(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e)
{
try
{
decimal BHYT_PTRAM_TRAITUYENNOITRU = Utility.DecimaltoDbnull(THU_VIEN_CHUNG.Laygiatrithamsohethong("BHYT_PTRAM_TRAITUYENNOITRU", "0", false), 0m);
new Update(KcbDonthuocChitiet.Schema).Set(KcbDonthuocChitiet.Columns.SoLuong).EqualTo(Utility.Int32Dbnull(Utility.getValueOfGridCell(grdVTTH, KcbDonthuocChitiet.Columns.SoLuong)))
.Where(KcbDonthuocChitiet.Columns.IdChitietdonthuoc).IsEqualTo(Utility.Int32Dbnull(Utility.getValueOfGridCell(grdVTTH, KcbDonthuocChitiet.Columns.IdChitietdonthuoc))).Execute();
DataRow row = ((DataRowView)grdVTTH.CurrentRow.DataRow).Row;
// if (!Utility.Byte2Bool(row[KcbDonthuocChitiet.Columns.TuTuc]))
// {
// decimal BHCT = 0m;
// if (objLuotkham.TrangthaiNoitru <= 0)
// BHCT = Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0) / 100);
// else//Nội trú cần tính=đơn giá * % đầu thẻ * % tuyến
// BHCT = Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100) * (BHYT_PTRAM_TRAITUYENNOITRU / 100);
// //decimal num2 = (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0) * Utility.DecimaltoDbnull(this.objLuotkham.PtramBhyt, 0)) / 100M;
// decimal num3 = Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0) - BHCT;
// row[KcbDonthuocChitiet.Columns.BhytChitra] = BHCT;
// row[KcbDonthuocChitiet.Columns.BnhanChitra] = num3;
// }
// else
// {
// row[KcbDonthuocChitiet.Columns.PtramBhyt] = 0;
// row[KcbDonthuocChitiet.Columns.BhytChitra] = 0;
// row[KcbDonthuocChitiet.Columns.BnhanChitra] = Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0);
// }
//row["TT_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]);
//row["TT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu]));
//row["TT_BHYT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BhytChitra]);
//row["TT_BN"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0));
//row["TT_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0);
//row["TT_BN_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0);
if (Utility.Byte2Bool(row[KcbDonthuocChitiet.Columns.TrongGoi]))
{
row[KcbDonthuocChitiet.Columns.DonGia] = 0;
row[KcbDonthuocChitiet.Columns.BnhanChitra] = 0;
row[KcbDonthuocChitiet.Columns.BhytChitra] = 0;
row[KcbDonthuocChitiet.Columns.PhuThu] = 0;
row["TT_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]);
row["TT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu]));
row["TT_BHYT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BhytChitra]);
row["TT_BN"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0));
row["TT_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0);
row["TT_BN_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0);
}
m_dtVTTH.AcceptChanges();
m_blnCancel = false;
}
catch (Exception ex)
{
Utility.SetMsg(lblMsg, ex.Message, true);
}
}
private static void SetConditionColumns(ConditionSerializationContext context, GridEXFilterConditionCollection conditions, Janus.Windows.GridEX.GridEX grid)
{
if (conditions != null)
{
Logger.Log.DebugFormat("conditions={0}", conditions.Count);
foreach (GridEXFilterCondition condition in conditions)
{
ColumnInfo key = context.NextColumnKey();
if (key != null)
{
condition.Column = grid.Tables[key.TableKey].Columns[key.ColumnKey];
SetConditionColumns(context, condition.Conditions, grid);
}
}
}
}
private void grdListDrug_CellValueChanged(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e)
{
try
{
if (!AllowedChanged) return;
if (Utility.isValidGrid(grdListDrug))
{
RowIndex = 1;
_OnCellValueChanged(Utility.sDbnull(grdListDrug.GetValue("ten_thuoc"), ""), Utility.Int32Dbnull(grdListDrug.CurrentRow.Cells["id_thuockho"].Value, -1), Utility.sDbnull(grdListDrug.GetValue("gia_ban"), "0"), Utility.sDbnull(grdListDrug.GetValue("ten_donvitinh"), "0"));
}
}
catch (Exception ex)
{
Utility.CatchException("_CellValueChanged Error", ex);
}
}
public void ExportDetails(Janus.Windows.GridEX.GridEX Grilla, ExportFormat FormatType, string FileName)
{
System.Diagnostics.Process loProcess = System.Diagnostics.Process.GetCurrentProcess();
loProcess.MaxWorkingSet = (IntPtr)10000000;
loProcess.MinWorkingSet = (IntPtr)5000000;
try
{
DataSet dsExport = Cedeira.SV.Fun.GetDataSetFromJanusGridEx(Grilla, FileName);
dsExport.DataSetName = "Export";
dsExport.Tables[0].TableName = "Values";
string[] sHeaders = new string[dsExport.Tables[0].Columns.Count];
string[] sFileds = new string[dsExport.Tables[0].Columns.Count];
for (int i = 0; i < dsExport.Tables[0].Columns.Count; i++)
{
dsExport.Tables[0].Columns[i].ColumnName = Convert.ToString(i);
}
for (int i = 0; i < dsExport.Tables[0].Columns.Count; i++)
{
sHeaders[i] = ReemplazarEspaciosyAcentos(dsExport.Tables[0].Columns[i].Caption);
dsExport.Tables[0].Columns[i].ColumnName = sHeaders[i];
sFileds[i] = sHeaders[i];
}
for (int l = 0; l < dsExport.Tables[0].Rows.Count; l++)
{
for (int i = 0; i < dsExport.Tables[0].Columns.Count; i++)
{
string aux = ReemplazarXPath(Convert.ToString(dsExport.Tables[0].Rows[l].ItemArray[i]));
dsExport.Tables[0].Rows[l][i] = aux;
dsExport.Tables[0].Rows[l].AcceptChanges();
}
}
string dir = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal) + "\\CedForecast\\";
if (!System.IO.Directory.Exists(dir))
{
System.IO.Directory.CreateDirectory(dir);
}
FileName = dir + ReemplazarCaracteresMalos(FileName);
Export_with_XSLT_Windows(dsExport, sHeaders, sFileds, FormatType, FileName);
System.Diagnostics.Process.Start(FileName);
}
catch (Exception Ex)
{
throw Ex;
}
}
private void grdDocuments_RowDoubleClick(object sender, Janus.Windows.GridEX.RowActionEventArgs e)
{
var document = grdDocuments.GetRow().DataRow as Document;
using (var sfd = new SaveFileDialog())
{
sfd.FileName = document.Name;
sfd.ShowDialog();
var cursor = this.Cursor;
this.Cursor = Cursors.WaitCursor;
_portalService.DownloadDocument(document, sfd.FileName);
this.Cursor = cursor;
}
}
void grdList_UpdatingCell(object sender, Janus.Windows.GridEX.UpdatingCellEventArgs e)
{
try
{
if (e.Column.Key == SysSystemParameter.Columns.SValue)
{
int id = Utility.Int32Dbnull(grdList.CurrentRow.Cells[SysSystemParameter.Columns.Id].Value);
new Update(SysSystemParameter.Schema)
.Set(SysSystemParameter.Columns.SValue).EqualTo(e.Value)
.Where(SysSystemParameter.Columns.Id).IsEqualTo(id)
.Execute();
}
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
private void gridEX1_InitCustomEdit(object sender, Janus.Windows.GridEX.InitCustomEditEventArgs e)
{
//For the sample, we will use BackColor Yellow in the textbox
//if the cell is in a new row
if (e.Row.RowType == RowType.NewRecord)
{
txtCustom.BackColor = Color.Yellow;
}
else
{
txtCustom.BackColor = e.FormatStyle.BackColor;
}
//When the user start edition by pressing a key,
//the EditChar property holds the char that
//started the edition. If edition was started
//because the user clicked in the cell the
//EditChar returns (char)0
if (Char.IsLetterOrDigit(e.EditChar))
{
txtCustom.Text = e.EditChar.ToString();
txtCustom.SelectionStart = txtCustom.Text.Length;
}
else
{
if (e.Value == null)
{
txtCustom.Text = "";
}
else
{
txtCustom.Text = e.Value.ToString();
}
txtCustom.SelectionLength = txtCustom.Text.Length;
}
//Set the EditControl property to let the GridEX control
//know which control to position in the cell.
e.EditControl = txtCustom;
}
private void GridEX1_LoadingRow(object sender, Janus.Windows.GridEX.RowLoadEventArgs e)
{
if (e.Row.RowType == RowType.Record)
{
decimal result = 0;
//You can get the values directly from the GridEXRow object
short quantity = (short)e.Row.Cells["Quantity"].Value;
decimal unitPrice = (decimal)e.Row.Cells["UnitPrice"].Value;
float discount = (float)e.Row.Cells["Discount"].Value;
result = Convert.ToDecimal(quantity) * unitPrice * Convert.ToDecimal(1 - discount);
/*
//or you can get the values from the Order_DetailsRow this GridEXRow represents.
System.Data.DataRowView rowView = (System.Data.DataRowView)e.Row.DataRow;
NorthWind.Order_DetailsRow detail = (NorthWind.Order_DetailsRow)rowView.Row;
result = Convert.ToDecimal(detail.Quantity) * detail.UnitPrice * Convert.ToDecimal(((float)1-detail.Discount));
*/
e.Row.Cells["Total"].Value = result;
}
}
private void gridEX1_LinkClicked(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e)
{
//MessageBox.Show(sender.ToString());
frmMain frm = (frmMain)this.ParentForm;
int hid = int.Parse(this.gridEX1.CurrentRow.Cells[0].Value.ToString());
int yid = int.Parse(this.gridEX1.CurrentRow.Cells[3].Value.ToString());
frm.cboHospital.ComboBox.SelectedValue=hid;
frm.cboYear.ComboBox.SelectedValue=yid;
if (e.Column.Caption == "主观评分")
{
foreach (Form frmTemp in frm.MdiChildren)
{
if (frmTemp.Name == "frmObjectEval" && MessageBox.Show(this, "主观评分窗口当前已打开，要重新载入数据吗？\n\r重新载入可能丢失您当前尚未保存的数据，建议手工保存后再执行此操作。", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
frmTemp.Dispose();
}
}
frmObjectEval frmObjectEval = new frmObjectEval();
frmObjectEval.MdiParent = frm;
frmObjectEval.Show();
}
else
{
foreach (Form frmTemp in frm.MdiChildren)
{
if (frmTemp.Name == "frmSubjectEval" && MessageBox.Show(this, "客观评分窗口当前已打开，要重新载入数据吗？\n\r重新载入可能丢失您当前尚未保存的数据，建议手工保存后再执行此操作。", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
frmTemp.Dispose();
}
}
frmSubjectEval frmSubjectEval = new frmSubjectEval();
frmSubjectEval.MdiParent = frm;
frmSubjectEval.Show();
}
}
private void stopClicked(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
detach = false;
StopDebuggee();
}
private void stepOutClicked(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
if (NuGenDebugEventHandler.Instance.State == DebuggerState.DebuggeeStopped)
{
ilEditor1.SetBreakpointOnFirstInstruction();
}
else
{
NuGenBreakpointHandler.Instance.Step(StepType.StepOut);
}
}
private void detachClick(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
detach = true;
NuGenDebugEventHandler.Instance.Detach();
}
private void regMonClick(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
NuGenRegistryMonitorMainForm f = new NuGenRegistryMonitorMainForm();
AddTabbedForm("Registry Monitor", f);
}
private void runButtonClicked(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
attach = false;
ilEditor1.RunDebuggee();
}
public UITabPage GetTab(Janus.Windows.Ribbon.RibbonTab tab)
{
switch (tab.Name)
{
case "homeRibbonTab": return homeTab;
case "ilRibbonTab": return ilTab;
case "eventLogRibbonTab": return eventLogTab;
case "metersRibbonTab": return metersTab;
}
return null;
}
private void newAssemblyButton_Click(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
DialogResult result = ofd.ShowDialog();
if (result == DialogResult.OK)
{
NuGenAssemblyLoader.Instance.Start(ofd.FileNames);
}
}
private void uiTab1_ChangingSelectedTab(object sender, Janus.Windows.UI.Tab.TabCancelEventArgs e)
{
if (e.Page.Key == "Mar")
{
ShowMarkTree();
}
else
{
ShowImageTree();
}
}
void ribbon1_SelectedTabChanged(object sender, Janus.Windows.Ribbon.TabEventArgs e)
{
uiTab1.SelectedTab = GetTab(e.Tab);
}
private void gridEX1_FormattingRow(object sender, Janus.Windows.GridEX.RowLoadEventArgs e)
{
}
void tabThongTinCanThanhToan_SelectedTabChanged(object sender, Janus.Windows.UI.Tab.TabEventArgs e)
{
tabThongTinThanhToan.Height = tabThongTinCanThanhToan.SelectedTab == TabpageCauhinh ? 0 : 168;
}
private void RemoveDetail(Janus.Windows.GridEX.GridEXRow gridExRow)
{
try
{
string manhacungcap = "";
string NgayHethan = "";
DateTime dtmNgayHethan = DateTime.Now;
string solo = "";
int id_thuoc = -1;
decimal dongia = 0m;
decimal Giaban = 0m;
decimal GiaBhyt = 0m;
Int32 soluong = 0;
decimal vat = 0m;
int isHetHan = 0;
long IdThuockho = 0;
DateTime NgayNhap = DateTime.Now;
NgayNhap = Convert.ToDateTime(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.NgayNhap].Value).Date;
dtmNgayHethan = Convert.ToDateTime(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.NgayHethan].Value).Date;
NgayHethan = Utility.sDbnull(gridExRow.Cells["NGAY_HET_HAN"].Value);
solo = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoLo].Value);
id_thuoc = Utility.Int32Dbnull(gridExRow.Cells[TThuockho.Columns.IdThuoc].Value, -1);
IdThuockho = Utility.Int32Dbnull(gridExRow.Cells[TThuockho.Columns.IdChuyen].Value, -1);
dongia = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaNhap].Value, 0);
GiaBhyt = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaBhyt].Value, 0);
Giaban = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaBan].Value, 0);
soluong = Utility.Int32Dbnull(gridExRow.Cells["SO_LUONG"].Value, 0);
vat = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.Vat].Value, 0);
isHetHan = Utility.Int32Dbnull(gridExRow.Cells["IsHetHan"].Value, 0);
manhacungcap = Utility.sDbnull(gridExRow.Cells[TThuockho.Columns.MaNhacungcap].Value, 0);
DataRow[] arrDr = m_dtDataThuocKho.Select(TPhieuNhapxuatthuocChitiet.Columns.IdThuockho + "=" + IdThuockho.ToString());
if (arrDr.Length <= 0)
{
DataRow drv = m_dtDataThuocKho.NewRow();
drv[TPhieuNhapxuatthuocChitiet.Columns.IdThuoc] = id_thuoc;
drv["ten_donvitinh"] = Utility.sDbnull(gridExRow.Cells["ten_donvitinh"].Value);
drv["IsHetHan"] = isHetHan;
DmucThuoc objLDrug = DmucThuoc.FetchByID(id_thuoc);
if (objLDrug != null)
{
drv[DmucThuoc.Columns.TenThuoc] = Utility.sDbnull(objLDrug.TenThuoc);
drv[DmucThuoc.Columns.HamLuong] = Utility.sDbnull(objLDrug.HamLuong);
drv[DmucThuoc.Columns.HoatChat] = Utility.sDbnull(objLDrug.HoatChat);
drv[DmucThuoc.Columns.NuocSanxuat] = Utility.sDbnull(objLDrug.NuocSanxuat);
drv[DmucThuoc.Columns.HangSanxuat] = Utility.sDbnull(objLDrug.HangSanxuat);
}
drv[TPhieuNhapxuatthuocChitiet.Columns.Vat] = vat;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaBhyt] = GiaBhyt;
drv[TPhieuNhapxuatthuocChitiet.Columns.NgayNhap] = NgayNhap;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaNhap] = dongia;
drv[TPhieuNhapxuatthuocChitiet.Columns.DonGia] = dongia;
drv[TPhieuNhapxuatthuocChitiet.Columns.MaNhacungcap] = manhacungcap;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoLo] = solo;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoDky] = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoDky].Value);
drv[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau] = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau].Value);
drv[TPhieuNhapxuatthuocChitiet.Columns.IdThuockho] = IdThuockho;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaBan] = Giaban;
drv[TPhieuNhapxuatthuocChitiet.Columns.SluongChia] = Utility.Int32Dbnull(gridExRow.Cells[DmucThuoc.Columns.SluongChia].Value, 0); ;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoLuong] = soluong;
drv[TPhieuNhapxuatthuocChitiet.Columns.ThanhTien] = dongia * soluong;
drv[TPhieuNhapxuatthuocChitiet.Columns.ChietKhau] = 0;
drv["NGAY_HET_HAN"] = NgayHethan;
drv[TPhieuNhapxuatthuocChitiet.Columns.NgayHethan] = dtmNgayHethan;
drv[TPhieuNhapxuatthuocChitiet.Columns.IdPhieu] = -1;
m_dtDataThuocKho.Rows.Add(drv);
}
else
{
arrDr[0]["SO_LUONG"] = Utility.Int32Dbnull(arrDr[0]["SO_LUONG"]) + soluong;
//arrDr[0]["SO_LUONG_THAT"] = Utility.Int32Dbnull(arrDr[0]["SO_LUONG"],0) + Utility.Int32Dbnull(arrDr[0]["sLuongAo"], 0);
m_dtDataThuocKho.AcceptChanges();
}
gridExRow.Delete();
grdPhieuXuatChiTiet.UpdateData();
grdPhieuXuatChiTiet.Refresh();
m_dtDataPhieuChiTiet.AcceptChanges();
m_dtDataThuocKho.AcceptChanges();
ModifyCommand();
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi hủy chuyển thuốc:\n" + ex.Message);
}
}
private void grdCapPhat_ColumnButtonClick(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e)
{
try
{
switch (grdCapPhat.CurrentColumn.Key)
{
case "btnEdit":
SuaCapPhat();
break;
case "btnDel":
XoaCapPhat();
break;
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
private void pauseClicked(object sender, Janus.Windows.Ribbon.CommandEventArgs e)
{
PauseDebuggee();
}
private void explorerBar1_ItemClick(object sender, Janus.Windows.ExplorerBar.ItemEventArgs e)
{
switch (e.Item.Text.ToString())
{
case "修改":
if (this.m_selectNode == "")
{
MessageBox.Show("请先选择数据！");
return;
}
this.m_isEdit = true;
this.richTextBox1.ReadOnly = false;
this.textBox3.ReadOnly = false;
this.textBox6.ReadOnly = false;
this.textBox4.ReadOnly = false;
this.textBox9.ReadOnly = false;
this.textBox10.ReadOnly = false;
this.textBox8.ReadOnly = false;
this.textBox13.ReadOnly = false;
this.textBox12.ReadOnly = false;
this.richTextBox1.BackColor = Color.White;
this.textBox3.BackColor = Color.White;
this.textBox6.BackColor = Color.White;
this.textBox4.BackColor = Color.White;
this.textBox9.BackColor = Color.White;
this.textBox10.BackColor = Color.White;
this.textBox8.BackColor = Color.White;
this.textBox13.BackColor = Color.White;
this.textBox12.BackColor = Color.White;
for (int i = 0; i < m_labelActive.Count; i++)
{
m_textBoxActive[i].ReadOnly = false;
m_textBoxActive[i].BackColor = Color.White;
}
break;
case "保存":
if (this.m_selectNode == "")
{
MessageBox.Show("请先选择数据！");
return;
}
if (this.m_isEdit == false)
{
MessageBox.Show("请先修改数据！");
return;
}
this.richTextBox1.ReadOnly = true;
this.textBox3.ReadOnly = true;
this.textBox6.ReadOnly = true;
this.textBox4.ReadOnly = true;
this.textBox9.ReadOnly = true;
this.textBox10.ReadOnly = true;
this.textBox8.ReadOnly = true;
this.textBox13.ReadOnly = true;
this.textBox12.ReadOnly = true;
this.richTextBox1.BackColor = Color.AliceBlue;
this.textBox3.BackColor = Color.AliceBlue;
this.textBox6.BackColor = Color.AliceBlue;
this.textBox4.BackColor = Color.AliceBlue;
this.textBox9.BackColor = Color.AliceBlue;
this.textBox10.BackColor = Color.AliceBlue;
this.textBox8.BackColor = Color.AliceBlue;
this.textBox13.BackColor = Color.AliceBlue;
this.textBox12.BackColor = Color.AliceBlue;
for (int i = 0; i < m_labelActive.Count; i++)
{
m_textBoxActive[i].ReadOnly = false;
m_textBoxActive[i].BackColor = Color.AliceBlue;
}
string sqlText = "update SHEETMETADATA set SOURCEFORMAT='" + textBox3.Text + "'," + "DESCRIPTION='" + richTextBox1.Text + "'," + "ALIANAME='" + textBox6.Text + "'," + "SOURCE='" + textBox4.Text + "'," + "HEIGHTDATUM='" + textBox10.Text + "'," + "SHEETNO='" + textBox9.Text + "'," + "COOR='" + textBox8.Text + "'," + "SCALE='" + textBox13.Text + "'," + "EDITER='" + textBox12.Text + "' where NAME='" + textBox1.Text + "'";
m_oraCmd.CommandText = sqlText;
m_oraCmd.ExecuteNonQuery();
if (this.m_labelActive.Count > 0)
{
sqlText = "update CUSTOMMETADATA set ";
for (int i = 0; i < this.m_customField.Count; i++)
{
if (i != this.m_customField.Count - 1)
{
sqlText += this.m_customField[i].ToString() + "='" + this.m_textBoxActive[i].Text.Trim().ToString() + "',";
}
else
{
sqlText += this.m_customField[i].ToString() + "='" + this.m_textBoxActive[i].Text.Trim().ToString() + "'";
}
}
sqlText += " where NAME='" + textBox1.Text + "'";
m_oraCmd.CommandText = sqlText;
m_oraCmd.ExecuteNonQuery();
}
this.m_isEdit = false;
MessageBox.Show("更新成功！");
break;
case "按名称":
frmSearchByName frmSearch = new frmSearchByName();
frmSearch.ShowDialog();
string name = frmSearch.Name;
if (name != "")
{
sqlText = "select *from SHEETMETADATA where NAME='" + name + "'";
m_oraCmd.CommandText = sqlText;
OracleDataReader dr = m_oraCmd.ExecuteReader();
if (dr.Read())
{
this.textBox1.Text = dr.GetValue(0).ToString();
this.textBox5.Text = dr.GetValue(2).ToString();
this.textBox7.Text = dr.GetValue(1).ToString();
this.textBox2.Text = dr.GetValue(4).ToString();
this.textBox3.Text = dr.GetValue(3).ToString();
this.textBox4.Text = dr.GetValue(7).ToString();
this.textBox6.Text = dr.GetValue(6).ToString();
this.richTextBox1.Text = dr.GetValue(5).ToString();
this.textBox9.Text = dr.GetValue(6).ToString();
this.textBox10.Text = dr.GetValue(9).ToString();
this.textBox8.Text = dr.GetValue(11).ToString();
this.textBox13.Text = dr.GetValue(12).ToString();
this.textBox12.Text = dr.GetValue(13).ToString();
//this.m_selectNode = e.Node.Text;
}
else
{
this.textBox1.Text = "";
this.textBox5.Text = "";
this.textBox7.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox6.Text = "";
this.richTextBox1.Text = "";
this.textBox9.Text = "";
this.textBox10.Text = "";
this.textBox8.Text = "";
this.textBox13.Text = "";
this.textBox12.Text = "";
//this.m_selectNode = "";
}
}
break;
}
}
private void uiTab1_SelectedTabChanged(object sender, Janus.Windows.UI.Tab.TabEventArgs e)
{
}
private void uiTab2_ClosingTab(object sender, Janus.Windows.UI.Tab.TabCancelEventArgs e)
{
if (e.Page.Text == "Welcome")
{
e.Cancel = true;
}
}
private void AddDetail(Janus.Windows.GridEX.GridEXRow gridExRow)
{
try
{
string manhacungcap = "";
string NgayHethan = "";
DateTime dtmNgayHethan = DateTime.Now;
DateTime NgayNhap = DateTime.Now;
string solo = "";
int id_thuoc = -1;
decimal dongia = 0m;
decimal Giaban = 0m;
decimal GiaBhyt = 0m;
Int32 soluongchuyen = 0;
decimal vat = 0m;
int isHetHan = 0;
long IdThuockho = 0;
int soluongthat = 0;
int tongsoluongchuyen = 0;
tongsoluongchuyen = 0;
int soluongao = Utility.Int32Dbnull(gridExRow.Cells["sLuongAo"].Value,0);
soluongthat = Utility.Int32Dbnull(gridExRow.Cells["SO_LUONG_THAT"].Value);
soluongchuyen = Utility.Int32Dbnull(gridExRow.Cells["SO_LUONG_CHUYEN"].Value, 0);
if (soluongchuyen > 0)
{
NgayHethan = Utility.sDbnull(gridExRow.Cells["NGAY_HET_HAN"].Value);
dtmNgayHethan = Convert.ToDateTime(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.NgayHethan].Value).Date;
NgayNhap = Convert.ToDateTime(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.NgayNhap].Value).Date;
solo = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoLo].Value);
id_thuoc = Utility.Int32Dbnull(gridExRow.Cells[TThuockho.Columns.IdThuoc].Value, -1);
dongia = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaNhap].Value, 0);
Giaban = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaBan].Value, 0);
GiaBhyt = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaBhyt].Value, 0);
vat = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.Vat].Value, 0);
isHetHan = Utility.Int32Dbnull(gridExRow.Cells["IsHetHan"].Value, 0);
manhacungcap = Utility.sDbnull(gridExRow.Cells[TThuockho.Columns.MaNhacungcap].Value, 0);
IdThuockho = Utility.Int32Dbnull(gridExRow.Cells[TThuockho.Columns.IdThuockho].Value, -1);
DataRow[] arrDr = m_dtDataPhieuChiTiet.Select(TPhieuNhapxuatthuocChitiet.Columns.IdChuyen + "=" + IdThuockho.ToString());
if (arrDr.Length <= 0)
{
DataRow drv = m_dtDataPhieuChiTiet.NewRow();
drv[TPhieuNhapxuatthuocChitiet.Columns.MotaThem] = String.Empty;
drv[TPhieuNhapxuatthuocChitiet.Columns.IdThuoc] = id_thuoc;
drv["ten_donvitinh"] = Utility.sDbnull(gridExRow.Cells["ten_donvitinh"].Value);
drv["IsHetHan"] = isHetHan;
DmucThuoc objLDrug = DmucThuoc.FetchByID(id_thuoc);
if (objLDrug != null)
{
drv[DmucThuoc.Columns.TenThuoc] = Utility.sDbnull(objLDrug.TenThuoc);
drv[DmucThuoc.Columns.HamLuong] = Utility.sDbnull(objLDrug.HamLuong);
drv[DmucThuoc.Columns.HoatChat] = Utility.sDbnull(objLDrug.HoatChat);
drv[DmucThuoc.Columns.NuocSanxuat] = Utility.sDbnull(objLDrug.NuocSanxuat);
drv[DmucThuoc.Columns.HangSanxuat] = Utility.sDbnull(objLDrug.HangSanxuat);
}
drv[TPhieuNhapxuatthuocChitiet.Columns.Vat] = vat;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaBhyt] = GiaBhyt;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaPhuthuDungtuyen] = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.PhuthuDungtuyen].Value, 0);
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaPhuthuTraituyen] = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.PhuthuTraituyen].Value, 0);
drv[TPhieuNhapxuatthuocChitiet.Columns.NgayNhap] = NgayNhap;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaNhap] = dongia;
drv[TPhieuNhapxuatthuocChitiet.Columns.DonGia] = dongia;
drv[TPhieuNhapxuatthuocChitiet.Columns.MaNhacungcap] = manhacungcap;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoLo] = solo;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoDky] = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoDky].Value);
drv[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau] = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau].Value);
drv[TPhieuNhapxuatthuocChitiet.Columns.IdThuockho] = IdThuockho;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaBan] = Giaban;
drv[TPhieuNhapxuatthuocChitiet.Columns.IdChuyen] = IdThuockho;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoLuong] = soluongchuyen;
drv[TPhieuNhapxuatthuocChitiet.Columns.ThanhTien] = dongia * soluongchuyen;
drv[TPhieuNhapxuatthuocChitiet.Columns.ChietKhau] = 0;
drv[TPhieuNhapxuatthuocChitiet.Columns.SluongChia] = Utility.Int32Dbnull(gridExRow.Cells[DmucThuoc.Columns.SluongChia].Value, 0);
drv["NGAY_HET_HAN"] = NgayHethan;
drv[TPhieuNhapxuatthuocChitiet.Columns.NgayHethan] = dtmNgayHethan;
drv[TPhieuNhapxuatthuocChitiet.Columns.IdPhieu] = -1;
tongsoluongchuyen = soluongchuyen;
m_dtDataPhieuChiTiet.Rows.Add(drv);
}
else
{
arrDr[0]["SO_LUONG"] = Utility.Int32Dbnull(arrDr[0]["SO_LUONG"]) + soluongchuyen;
tongsoluongchuyen = Utility.Int32Dbnull(arrDr[0]["SO_LUONG"]);
m_dtDataPhieuChiTiet.AcceptChanges();
}
//Update lại dữ liệu từ kho xuất
gridExRow.BeginEdit();
gridExRow.Cells["SO_LUONG"].Value = soluongthat - tongsoluongchuyen - soluongao;
gridExRow.Cells["SO_LUONG_CHUYEN"].Value = 0;
gridExRow.IsChecked = false;
gridExRow.EndEdit();
}
grdKhoXuat.UpdateData();
m_dtDataThuocKho.AcceptChanges();
//UpdateWhenChanged();
//ResetValueInGridEx();
ModifyCommand();
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi chuyển thuốc:\n" + ex.Message);
}
}
