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); } }