private void SetRibbonTheme(C1Theme ribbonTheme, C1AvailableThemes selectedThemeItem)
{
switch (selectedThemeItem)
{
case C1AvailableThemes.Cosmopolitan:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonCosmopolitan();
break;
case C1AvailableThemes.CosmopolitanDark:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonCosmopolitanDark();
break;
case C1AvailableThemes.Office2013White:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonOffice2013White();
break;
case C1AvailableThemes.Office2013LightGray:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonOffice2013LightGray();
break;
case C1AvailableThemes.Office2013DarkGray:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonOffice2013DarkGray();
break;
case C1AvailableThemes.Office2016Colorful:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonOffice2016Colorful();
break;
case C1AvailableThemes.Office2016DarkGray:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonOffice2016DarkGray();
break;
case C1AvailableThemes.Office2016White:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonOffice2016White();
break;
case C1AvailableThemes.Office2016Black:
ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonOffice2016Black();
break;
default:
break;
}
if (ribbonTheme != null)
{
ribbonTheme.Apply(ribbon);
ribbonTheme.Apply(this);
}
}
// apply theme to the FlexPivot page
private void cbTheme_SelectedIndexChanged(object sender, EventArgs e)
{
C1Theme theme = C1ThemeController.GetThemeByName(cbTheme.Text, false);
if (theme != null)
{
C1ThemeController.ApplyThemeToObject(_c1FlexPivotPage, theme);
}
}
// loads theme from the specified file.
private void appLoad_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
C1Theme theme = new C1Theme();
theme.Load(openFileDialog1.FileName);
Helper.SetTheme(theme);
}
}
private void CustomTheme_Load(object sender, EventArgs e)
{
c1FlexGrid1.DataSource = DemoDataSource("Products");
// load and apply custom theme
C1Theme customTheme = new C1Theme();
customTheme.Load(_themePath);
customTheme.ApplyThemeToControlTree(this);
}
private void AppyTheme()
{
string fileName = THEME_PATH;
C1Theme customTheme = new C1Theme();
customTheme.Load(fileName);
customTheme.ApplyThemeToControlTree(this, (x) => x != connectionPropertyGrid);
customTheme.ApplyThemeToObject(connectionPropertyGrid);
customTheme.ApplyThemeToObject(connectionPropertyGrid.C1ScrollBar);
}
private void ApplyTheme(ToggleButton button, C1Theme theme)
{
if (_lastSelected != null)
{
_lastSelected.IsChecked = false;
}
_lastSelected = button;
theme.Apply(LayoutRoot);
LayoutRoot.Background = (Brush)C1Theme.GetCurrentThemeResources(theme)["MouseOverGradientBrush"];
}
public MainWindow()
{
InitializeComponent();
var theme = new C1.WPF.Theming.Cosmopolitan.C1ThemeCosmopolitan();
var ribbonTheme = new C1.WPF.Theming.Ribbon.C1ThemeRibbonCosmopolitan();
ribbonTheme.Apply(this);
root.Style = TryFindResource(typeof(Window)) as Style;
this.Resources.MergedDictionaries.Add(C1Theme.GetCurrentThemeResources(theme));
Application.Current.Resources.MergedDictionaries.Add(theme.GetNewResourceDictionary());
Application.Current.Resources.MergedDictionaries.Add(ribbonTheme.GetNewResourceDictionary());
}
//----------------------------------------
#region ** Settings
private void themeList_SelectionChanged(object sender, C1.WPF.SelectionChangedEventArgs <int> e)
{
if (themeList.SelectedItem == null)
{
return;
}
themeDropDown.IsDropDownOpen = false;
scheduler.BeginUpdate();
C1Theme theme = null;
switch (themeList.SelectedItem.ToString())
{
case "Black":
theme = new C1.WPF.Theming.Office2016.C1ThemeOffice2016Black();
break;
case "White":
theme = new C1.WPF.Theming.Office2016.C1ThemeOffice2016White();
break;
case "Colorful":
theme = new C1.WPF.Theming.Office2016.C1ThemeOffice2016Colorful();
break;
case "Dark Gray":
theme = new C1.WPF.Theming.Office2016.C1ThemeOffice2016DarkGray();
break;
}
C1Theme.ApplyTheme(this, theme);
var rd = theme.GetNewResourceDictionary();
scheduler.Theme = calendar.Theme = rd;
// apply themed FlexGrid style to inherited controls
var flexGridStyle = rd[typeof(C1.WPF.FlexGrid.C1FlexGrid)] as Style;
if (flexGridStyle != null)
{
agendaView.Style = flexGridStyle;
tableView.Style = flexGridStyle;
}
var adornerLayer = AdornerLayer.GetAdornerLayer(this);
if (adornerLayer != null)
{
// this will aplly theme to everything displayed in adorner, including any C1Window instances
C1Theme.ApplyTheme(adornerLayer, theme);
}
// scheduler_LayoutUpdated(null, null);
scheduler.EndUpdate();
}
private void cmbTheme_SelectedItemChanged(object sender, PropertyChangedEventArgs <object> e)
{
var theme = C1ThemeFactory.GetTheme((C1AvailableThemes)cmbTheme.SelectedItem);
C1Theme.ApplyTheme(LayoutRoot, theme);
var adornerLayer = AdornerLayer.GetAdornerLayer(LayoutRoot);
if (adornerLayer != null)
{
C1Theme.ApplyTheme(adornerLayer, theme);
}
}
private void SetTheme()
{
var theme = C1ThemeFactory.GetTheme(C1AvailableThemes.Office2016Colorful);
C1Theme.ApplyTheme(LayoutRoot, theme);
var adornerLayer = AdornerLayer.GetAdornerLayer(LayoutRoot);
if (adornerLayer != null)
{
// this will aplly theme to everything displayed in adorner, including any C1Window instances
C1Theme.ApplyTheme(adornerLayer, theme);
}
}
private void initGrfInterpret()
{
grfInt = new C1FlexGrid();
grfInt.Font = fEdit;
grfInt.Dock = System.Windows.Forms.DockStyle.Fill;
grfInt.Location = new System.Drawing.Point(0, 0);
grfInt.ChangeEdit += GrfInt_ChangeEdit;
//FilterRow fr = new FilterRow(grfPosi);
gbInterpret.Controls.Add(this.grfInt);
C1Theme theme = C1ThemeController.GetThemeByName("Office2013Red", false);
C1ThemeController.ApplyThemeToObject(grfInt, theme);
}
private void cmbTheme_SelectedItemChanged(object sender, PropertyChangedEventArgs <object> e)
{
var theme = C1ThemeFactory.GetTheme((C1AvailableThemes)cmbTheme.SelectedItem);
C1Theme.ApplyTheme(LayoutRoot, theme);
var adornerLayer = AdornerLayer.GetAdornerLayer(LayoutRoot);
if (adornerLayer != null)
{
// this will apply theme to everything displayed in adorner, including any C1Window instances
C1Theme.ApplyTheme(adornerLayer, theme);
}
CurrentTheme = theme;
}
private void initGrfDept()
{
grfDept.Font = fEdit;
grfDept.Dock = System.Windows.Forms.DockStyle.Fill;
grfDept.Location = new System.Drawing.Point(0, 0);
FilterRow fr = new FilterRow(grfDept);
grfDept.AfterRowColChange += new C1.Win.C1FlexGrid.RangeEventHandler(this.grfDept_AfterRowColChange);
grfDept.CellButtonClick += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfDept_CellButtonClick);
grfDept.CellChanged += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfDept_CellChanged);
this.Controls.Add(this.grfDept);
C1Theme theme = C1ThemeController.GetThemeByName("Office2013Red", false);
C1ThemeController.ApplyThemeToObject(grfDept, theme);
}
private void initGrfContH()
{
grfCont = new C1FlexGrid();
grfCont.Font = fEdit;
grfCont.Dock = System.Windows.Forms.DockStyle.Fill;
grfCont.Location = new System.Drawing.Point(0, 0);
FilterRow fr = new FilterRow(grfCont);
grfCont.DoubleClick += new System.EventHandler(this.grfCont_DoubleClick);
//grfBank.CellButtonClick += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfBank_CellButtonClick);
panel2.Controls.Add(this.grfCont);
C1Theme theme = C1ThemeController.GetThemeByName("Office2013Red", false);
C1ThemeController.ApplyThemeToObject(grfCont, theme);
}
private void initGrfDiag()
{
grfReq = new C1FlexGrid();
grfReq.Font = fEdit;
grfReq.Dock = System.Windows.Forms.DockStyle.Fill;
grfReq.Location = new System.Drawing.Point(0, 0);
//FilterRow fr = new FilterRow(grfPosi);
grfReq.AfterRowColChange += new C1.Win.C1FlexGrid.RangeEventHandler(this.grfPosi_AfterRowColChange);
//grfAgn.CellButtonClick += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfPosi_CellButtonClick);
//grfAgn.CellChanged += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfPosi_CellChanged);
panel5.Controls.Add(this.grfReq);
C1Theme theme = C1ThemeController.GetThemeByName("Office2013Red", false);
C1ThemeController.ApplyThemeToObject(grfReq, theme);
}
private void ribbonStyleCombo_ChangeCommitted(object sender, EventArgs e)
{
this.SuspendPainting();
C1Theme theme = null;
try
{
theme = C1ThemeController.GetThemeByName(ribbonStyleCombo.Text, false);
}
catch
{
}
if (theme != null)
{
C1ThemeController.ApplyThemeToControlTree(this, theme);
}
this.ResumePainting();
this.Activate();
}
// sets accent color to the current Theme and applies Theme to the controls
private void SetAccentColors(Color primary, Color secondary)
{
if (!_updating)
{
_updating = true;
// get C1Theme
C1Theme theme = Helper.C1Theme;
// Create C1ThemeSettings containing the desired theme settings
C1MaterialThemeSettings settings = new C1MaterialThemeSettings()
{
PrimaryColor = primary, SecondaryColor = secondary
};
// Apply settings to the C1Theme
theme.ApplySettings(settings);
// Apply new Theme to the controls
((IThemeable)this).ThemeChanged();
_updating = false;
}
}
private void initGrfStockDrug()
{
grfDrug = new C1FlexGrid();
grfDrug.Font = fEdit;
grfDrug.Dock = System.Windows.Forms.DockStyle.Fill;
grfDrug.Location = new System.Drawing.Point(0, 0);
//FilterRow fr = new FilterRow(grfPosi);
grfDrug.AfterRowColChange += GrfPkg_AfterRowColChange;
//grfAgn.CellButtonClick += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfPosi_CellButtonClick);
//grfAgn.CellChanged += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfPosi_CellChanged);
panel1.Controls.Add(this.grfDrug);
FilterRow fr = new FilterRow(grfDrug);
grfDrug.AllowFiltering = true;
grfDrug.AfterFilter += GrfDrug_AfterFilter;
C1Theme theme = C1ThemeController.GetThemeByName("Office2013Red", false);
C1ThemeController.ApplyThemeToObject(grfDrug, theme);
}
private void initGrfMatr()
{
grfMatr = new C1FlexGrid();
grfMatr.Font = fEdit;
grfMatr.Dock = System.Windows.Forms.DockStyle.Fill;
grfMatr.Location = new System.Drawing.Point(0, 0);
//FilterRow fr = new FilterRow(grfPosi);
//grfMatr.AfterRowColChange += new C1.Win.C1FlexGrid.RangeEventHandler(this.grfPosi_AfterRowColChange);
//grfMatr.CellButtonClick += new C1.Win.C1FlexGrid.RowColEventHandler(this.grfPosi_CellButtonClick);
//grfMatr.CellChanged += GrfMatr_CellChanged;
grfMatr.AfterEdit += GrfMatr_AfterEdit;
grfMatr.ComboCloseUp += GrfMatr_ComboCloseUp;
panel2.Controls.Add(this.grfMatr);
setControl();
C1Theme theme = C1ThemeController.GetThemeByName("Office2013Red", false);
C1ThemeController.ApplyThemeToObject(grfMatr, theme);
}
public MainWindow()
{
InitializeComponent();
this.DataContext = ViewModel.ChartViewModel.Instance;
this.Loaded += (o, e) =>
{
var theme = new C1ThemeExpressionDark();
C1Theme.ApplyTheme(this, theme);
ViewModel.ChartViewModel.Instance.MainChart = financialChart1;
ViewModel.ChartViewModel.Instance.MainSeries = mainSeries;
ViewModel.ChartViewModel.Instance.MainMovingAverage = mainMovingAverage;
ViewModel.ChartViewModel.Instance.VolumeSeries = volumeSeries;
ViewModel.ChartViewModel.Instance.RangeSelector = rangeSelector;
ViewModel.ChartViewModel.Instance.AnnotationLayer = annotationLayer;
ViewModel.ChartViewModel.Instance.LineMarker = lineMarker;
this.rangeSelector.UpperValue = DateTime.Now.ToOADate();
this.rangeSelector.LowerValue = DateTime.Parse(string.Format("01-01-{0}", DateTime.Now.Year)).ToOADate();
this.financialChart2.AxisX.Min = new DateTime(2007, 12, 31).ToOADate();
};
//Change Line marker color.
this.lineMarker.Loaded += (o, e) =>
{
Brush whiteBrush = new SolidColorBrush(Colors.White);
IEnumerable <DependencyObject> visuals = GetLineVisual(this.lineMarker);
foreach (var item in visuals)
{
var line = item as Line;
line.Fill = line.Stroke = whiteBrush;
}
};
}
public static C1Theme GetTheme(C1AvailableThemes pickedTheme)
{
C1Theme theme = null;
switch (pickedTheme)
{
case C1AvailableThemes.BureauBlack:
if (_bureauBlack == null)
{
_bureauBlack = new C1ThemeBureauBlack();
}
theme = _bureauBlack;
break;
case C1AvailableThemes.ExpressionDark:
if (_expDark == null)
{
_expDark = new C1ThemeExpressionDark();
}
theme = _expDark;
break;
case C1AvailableThemes.ExpressionLight:
if (_expLight == null)
{
_expLight = new C1ThemeExpressionLight();
}
theme = _expLight;
break;
case C1AvailableThemes.ShinyBlue:
if (_shinyBlue == null)
{
_shinyBlue = new C1ThemeShinyBlue();
}
theme = _shinyBlue;
break;
case C1AvailableThemes.WhistlerBlue:
if (_whistlerBlue == null)
{
_whistlerBlue = new C1ThemeWhistlerBlue();
}
theme = _whistlerBlue;
break;
case C1AvailableThemes.Cosmopolitan:
if (_cosmopolitan == null)
{
_cosmopolitan = new C1ThemeCosmopolitan();
}
theme = _cosmopolitan;
break;
case C1AvailableThemes.CosmopolitanDark:
if (_cosmopolitanDark == null)
{
_cosmopolitanDark = new C1ThemeCosmopolitanDark();
}
theme = _cosmopolitanDark;
break;
//#if !CLR40
case C1AvailableThemes.Office2007Blue:
if (_office2007Blue == null)
{
_office2007Blue = new C1ThemeOffice2007Blue();
}
theme = _office2007Blue;
break;
case C1AvailableThemes.Office2007Black:
if (_office2007Black == null)
{
_office2007Black = new C1ThemeOffice2007Black();
}
theme = _office2007Black;
break;
case C1AvailableThemes.Office2007Silver:
if (_office2007Silver == null)
{
_office2007Silver = new C1ThemeOffice2007Silver();
}
theme = _office2007Silver;
break;
case C1AvailableThemes.Office2010Blue:
if (_office2010Blue == null)
{
_office2010Blue = new C1ThemeOffice2010Blue();
}
theme = _office2010Blue;
break;
case C1AvailableThemes.Office2010Black:
if (_office2010Black == null)
{
_office2010Black = new C1ThemeOffice2010Black();
}
theme = _office2010Black;
break;
case C1AvailableThemes.Office2010Silver:
if (_office2010Silver == null)
{
_office2010Silver = new C1ThemeOffice2010Silver();
}
theme = _office2010Silver;
break;
case C1AvailableThemes.Office2013White:
if (_office2013White == null)
{
_office2013White = new C1ThemeOffice2013White();
}
theme = _office2013White;
break;
case C1AvailableThemes.Office2013LightGray:
if (_office2013LightGray == null)
{
_office2013LightGray = new C1ThemeOffice2013LightGray();
}
theme = _office2013LightGray;
break;
case C1AvailableThemes.Office2013DarkGray:
if (_office2013DarkGray == null)
{
_office2013DarkGray = new C1ThemeOffice2013DarkGray();
}
theme = _office2013DarkGray;
break;
//#endif
case C1AvailableThemes.C1Blue:
if (_c1Blue == null)
{
_c1Blue = new C1ThemeC1Blue();
}
theme = _c1Blue;
break;
case C1AvailableThemes.Office2016Colorful:
if (_office2016Colorful == null)
{
_office2016Colorful = new C1ThemeOffice2016Colorful();
}
theme = _office2016Colorful;
break;
case C1AvailableThemes.Office2016Black:
if (_office2016Black == null)
{
_office2016Black = new C1ThemeOffice2016Black();
}
theme = _office2016Black;
break;
case C1AvailableThemes.Office2016DarkGray:
if (_office2016DarkGray == null)
{
_office2016DarkGray = new C1ThemeOffice2016DarkGray();
}
theme = _office2016DarkGray;
break;
case C1AvailableThemes.Office2016White:
if (_office2016White == null)
{
_office2016White = new C1ThemeOffice2016White();
}
theme = _office2016White;
break;
default:
break;
}
return(theme);
}
// Sets current C1Theme
public void SetTheme(C1Theme theme)
{
C1Theme = theme;
OnThemeChanged();
}
public static C1Theme GetTheme(C1AvailableThemes pickedTheme)
{
C1Theme theme = null;
switch (pickedTheme)
{
case C1AvailableThemes.BureauBlack:
if (_bureauBlack == null) _bureauBlack = new C1ThemeBureauBlack();
theme = _bureauBlack;
break;
case C1AvailableThemes.ExpressionDark:
if (_expDark == null) _expDark = new C1ThemeExpressionDark();
theme = _expDark;
break;
case C1AvailableThemes.ExpressionLight:
if (_expLight == null) _expLight = new C1ThemeExpressionLight();
theme = _expLight;
break;
//case C1AvailableThemes.RainerOrange:
// if (_rainerOrange == null) _rainerOrange = new C1ThemeRainierOrange();
// theme = _rainerOrange;
// break;
case C1AvailableThemes.ShinyBlue:
if (_shinyBlue == null) _shinyBlue = new C1ThemeShinyBlue();
theme = _shinyBlue;
break;
case C1AvailableThemes.WhistlerBlue:
if (_whistlerBlue == null) _whistlerBlue = new C1ThemeWhistlerBlue();
theme = _whistlerBlue;
break;
case C1AvailableThemes.Cosmopolitan:
if (_cosmopolitan == null) _cosmopolitan = new C1ThemeCosmopolitan();
theme = _cosmopolitan;
break;
case C1AvailableThemes.CosmopolitanDark:
if (_cosmopolitanDark == null) _cosmopolitanDark = new C1ThemeCosmopolitanDark();
theme = _cosmopolitanDark;
break;
//#if !CLR40
case C1AvailableThemes.Office2007Blue:
if (_office2007Blue == null) _office2007Blue = new C1ThemeOffice2007Blue();
theme = _office2007Blue;
break;
case C1AvailableThemes.Office2007Black:
if (_office2007Black == null) _office2007Black = new C1ThemeOffice2007Black();
theme = _office2007Black;
break;
case C1AvailableThemes.Office2007Silver:
if (_office2007Silver == null) _office2007Silver = new C1ThemeOffice2007Silver();
theme = _office2007Silver;
break;
case C1AvailableThemes.Office2010Blue:
if (_office2010Blue == null) _office2010Blue = new C1ThemeOffice2010Blue();
theme = _office2010Blue;
break;
case C1AvailableThemes.Office2010Black:
if (_office2010Black == null) _office2010Black = new C1ThemeOffice2010Black();
theme = _office2010Black;
break;
case C1AvailableThemes.Office2010Silver:
if (_office2010Silver == null) _office2010Silver = new C1ThemeOffice2010Silver();
theme = _office2010Silver;
break;
case C1AvailableThemes.Office2013White:
if (_office2013White == null) _office2013White = new C1ThemeOffice2013White();
theme = _office2013White;
break;
case C1AvailableThemes.Office2013LightGray:
if (_office2013LightGray == null) _office2013LightGray = new C1ThemeOffice2013LightGray();
theme = _office2013LightGray;
break;
case C1AvailableThemes.Office2013DarkGray:
if (_office2013DarkGray == null) _office2013DarkGray = new C1ThemeOffice2013DarkGray();
theme = _office2013DarkGray;
break;
//#endif
case C1AvailableThemes.C1Blue:
if (_c1Blue == null) _c1Blue = new C1ThemeC1Blue();
theme = _c1Blue;
break;
default:
break;
}
return theme;
}
private void BtnCheck2_Click(object sender, EventArgs e)
{
int cnt = 0, cntErr = 0;
Decimal sum = 0, price1 = 0, net = 0, minus = 0;
//throw new NotImplementedException();
pB2.Show();
pB2.Minimum = 0;
pB2.Maximum = lItm.Count;
ConnectDB conn;
conn = new ConnectDB(bc.iniC);
lItmC = new List <string>();
lItmE = new List <string>();
label11.Text = chkBn1.Checked ? "bangna1" : chkBn2.Checked ? "bangna2" : chkBn5.Checked ? "bangna5" : "";
label12.Text = cboYear.Text;
label13.Text = cboMonth.Text;
label14.Text = cboPeriod.Text;
Application.DoEvents();
//foreach (String str in lItm)
foreach (DataRow str in dtChk.Rows)
{
try
{
//String[] itm = str.Split('|');
//String[] itm = str.Split('|');
String col1 = "", date = "", hn = "", name = "", fntype = "", col6 = "", labname = "", labcode = "", labdate1 = "", labdate = "", labdateOld = "", price = "";
//col1 = itm[0];
//date = itm[1];
//hn = itm[2];
//name = itm[3];
//fntype = itm[4];
//col6 = itm[5];
//price = itm[6];
//labcode = itm[7];
//labname = itm[8];
col1 = str["col1"].ToString();
date = str["date"].ToString();
hn = str["hn"].ToString();
name = str["ptt_name"].ToString();
fntype = str["paidtype"].ToString();
col6 = str["net_price"].ToString();
price = str["price"].ToString();
labcode = str["lab_code"].ToString();
labname = str["lab_name"].ToString();
labdate1 = (int.Parse(date.Substring(6)) - 543) + "-" + date.Substring(3, 2) + "-" + date.Substring(0, 2);
price1 = 0;
if (Decimal.TryParse(price, out price1))
{
sum += price1;
}
String sql = "";
DataTable dt = new DataTable();
//sql = "select lab_t05.MNC_req_no,LAB_T01.MNC_PRE_NO " +
// "from PATIENT_T01 " +
// "inner join LAB_T01 on LAB_T01.mnc_hn_no = PATIENT_T01.mnc_hn_no " +
// "and LAB_T01.mnc_pre_no = PATIENT_T01.mnc_pre_no " +
// "and LAB_T01.mnc_date = PATIENT_T01.MNC_DATE " +
// "inner join LAB_T05 on lab_t05.MNC_REQ_YR = lab_t01.MNC_REQ_YR " +
// "and lab_t05.MNC_REQ_no = lab_t01.MNC_REQ_no " +
// "and lab_t05.MNC_REQ_dat = lab_t01.MNC_REQ_dat " +
// "where lab_t05.MNC_REQ_DAT >= '" + labdate1 + "' " +
// "and lab_t05.MNC_REQ_DAT <= '" + labdate1 + "' " +
// //"and patient_t01.MNC_STS = 'f' " +
// //"and LAB_T01.MNC_REQ_STS = 'Q' " +
// "and LAB_T01.mnc_hn_no ='" + hn + "' " +
// "and lab_t05.mnc_lb_cd ='" + labcode + "'";
sql = "select lab_t02.MNC_req_no,LAB_T01.MNC_PRE_NO " +
"from PATIENT_T01 " +
"inner join LAB_T01 on LAB_T01.mnc_hn_no = PATIENT_T01.mnc_hn_no " +
"and LAB_T01.mnc_pre_no = PATIENT_T01.mnc_pre_no " +
"and LAB_T01.mnc_date = PATIENT_T01.MNC_DATE " +
"inner join lab_t02 on lab_t02.MNC_REQ_YR = lab_t01.MNC_REQ_YR " +
"and lab_t02.MNC_REQ_no = lab_t01.MNC_REQ_no " +
"and lab_t02.MNC_REQ_dat = lab_t01.MNC_REQ_dat " +
"where lab_t02.MNC_REQ_DAT >= '" + labdate1 + "' " +
"and lab_t02.MNC_REQ_DAT <= '" + labdate1 + "' " +
//"and patient_t01.MNC_STS = 'f' " +
//"and LAB_T01.MNC_REQ_STS = 'Q' " +
"and LAB_T01.mnc_hn_no ='" + hn + "' " +
"and lab_t02.mnc_lb_cd ='" + labcode + "'";
dt = conn.selectData(conn.connMainHIS, sql);
if (dt.Rows.Count > 0)
{
//itm[8] = dt.Rows[0]["MNC_PRE_NO"].ToString();
//itm[9] = dt.Rows[0]["MNC_req_no"].ToString();
str["status_chk"] = "1";
listBox2.Items.Add(date + " " + hn + " " + name + " " + labcode + " " + labname);
lItmC.Add(col1 + "|" + date + "|" + hn + "|" + name + "|" + fntype + "|" + col6 + "|" + price + "|" + labcode + "|" + labname + "|" + dt.Rows[0]["MNC_PRE_NO"].ToString() + "|" + dt.Rows[0]["MNC_req_no"].ToString());
cnt++;
net += price1;
if ((cnt % 100) == 0)
{
Application.DoEvents();
}
}
else
{
cntErr++;
minus += price1;
listBox3.Items.Add(date + " " + hn + " " + name + " " + labcode + " " + labname);
lItmC.Add(col1 + "|" + date + "|" + hn + "|" + name + "|" + fntype + "|" + col6 + "|" + price + "|" + labcode + "|" + labname + "|0|0|-" + "|-");
lItmE.Add(col1 + "|" + date + "|" + hn + "|" + name + "|" + fntype + "|" + col6 + "|" + price + "|" + labcode + "|" + labname + "|0|0|-" + "|-");
int cnt1 = 0;
foreach (String paid in lPaid)
{
if (paid.Equals(fntype))
{
//int cnt2 = 0;
lPaidCntErr[cnt1]++;
//int.TryParse(lPaidCnt[cnt1],out cnt2);
}
cnt1++;
}
//itm[8] = dt.Rows[0]["MNC_PRE_NO"].ToString();
//itm[9] = dt.Rows[0]["MNC_req_no"].ToString();
//listBox2.Items.Add(itm.ToString());
}
pB2.Value++;
}
catch (Exception ex)
{
MessageBox.Show("ex" + ex.Message, "");
}
}
//Control ctn = this.GetControl("listBoxSum3");
ListBox listsum = new ListBox();
foreach (Control ctl in this.Controls)
{
if ((ctl is C1DockingTab) && (ctl.Name.Equals("tC")))
{
foreach (Control ctl1 in ctl.Controls)
{
if ((ctl1 is C1DockingTabPage) && (ctl1.Name.Equals("tab3")))
{
foreach (Control ctl2 in ctl1.Controls)
{
if ((ctl2 is Panel) && (ctl2.Name.Equals("panel3")))
{
foreach (Control ctl3 in ctl2.Controls)
{
if ((ctl3 is C1DockingTab) && (ctl3.Name.Equals("tC3")))
{
foreach (Control ctl4 in ctl3.Controls)
{
if ((ctl4 is C1DockingTabPage) && (ctl4.Name.Equals("tabsum")))
{
foreach (Control ctl5 in ctl4.Controls)
{
if ((ctl5 is ListBox) && (ctl5.Name.Equals("listBoxSum3")))
{
listsum = (ListBox)ctl5;
listsum.Items.Clear();
int i = 0;
foreach (String txt in lPaid)
{
listsum.Items.Add(txt + " จำนวน " + lPaidCnt[i] + " ไม่พบ จำนวน " + lPaidCntErr[i]);
i++;
}
}
}
}
}
}
}
}
}
}
}
}
}
//listsum.Items.Clear();
//int i = 0;
//foreach (String txt in lPaid)
//{
// listsum.Items.Add(txt + " จำนวน " + lPaidCnt[i]+" ไม่พบ จำนวน "+ lPaidCntErr[i]);
// i++;
//}
pB1.Hide();
label18.Text = lItm.Count.ToString();
label17.Text = cnt.ToString();
label16.Text = cntErr.ToString();
label15.Text = sum.ToString("#,###.00");
label23.Text = net.ToString("#,###.00");
label26.Text = minus.ToString("#,###.00");
btnTab3.Enabled = true;
pB2.Hide();
tC.SelectedTab = tab3;
setGrf();
//DataTable dt11 = new DataTable();
dtChkGrp = GroupBy("paidtype", "paidtype", dtChk);
setGrf11(dtChkGrp);
if (dtChkGrp.Rows.Count > 0)
{
foreach (DataRow row in dtChkGrp.Rows)
{
C1DockingTabPage tab1 = new C1DockingTabPage();
tab1.Text = row["paidtype"].ToString();
tC3.TabPages.Add(tab1);
C1FlexGrid grf = new C1FlexGrid();
grf.Font = fEdit;
grf.Dock = System.Windows.Forms.DockStyle.Fill;
grf.Location = new System.Drawing.Point(0, 0);
tab1.Controls.Add(grf);
DataRow[] result = dtChk.Select("paidtype = '" + row["paidtype"].ToString() + "'");
DataTable dt1 = new DataTable();
addColumn(dt1);
foreach (DataRow row1 in result)
{
DataRow row2 = dt1.NewRow();
///row2 = row1;
row2["row1"] = int.Parse(row1["row1"].ToString()) + 1;
row2["lab_code"] = row1["lab_code"];
row2["lab_name"] = row1["lab_name"];
row2["qty"] = row1["qty"];
row2["price"] = row1["price"];
row2["net_price"] = row1["net_price"];
row2["amount"] = row1["amount"];
row2["paidtype"] = row1["paidtype"];
row2["status_chk"] = row1["status_chk"];
row2["ptt_name"] = row1["ptt_name"];
row2["date"] = row1["date"];
row2["hn"] = row1["hn"];
row2["col1"] = row1["col1"];
dt1.Rows.Add(row2);
}
DataTable dt2 = new DataTable();
dt2 = GroupBy1("lab_code", "lab_code", dt1);
foreach (DataRow row3 in dt2.Rows)
{
DataRow[] result1 = dtChk.Select("lab_code = '" + row3 ["lab_code"].ToString() + "'");
if (result.Length > 0)
{
row3["lab_name"] = result1[0]["lab_name"].ToString();
}
Console.WriteLine("{0}, {1}", row[0], row[1]);
}
//dt1.ad
grf.DataSource = dt2;
grf.Cols["price"].Visible = false;
grf.Cols["net_price"].Visible = false;
grf.Cols["amount"].Visible = false;
grf.Cols["lab_code"].Width = 100;
grf.Cols["lab_name"].Width = 300;
C1Theme theme = C1ThemeController.GetThemeByName("Office2013Red", false);
C1ThemeController.ApplyThemeToObject(grf, theme);
}
}
//pB1.Show();
}
