private void FrmVindicatorConfig_Load(object sender, EventArgs e)
{
_paramProcess = new ParamProcess();
foreach (object obj in Enum.GetValues(typeof(HIS.Base_BLL.Enums.FIELD_DB_TYPE)))
{
cboParam.Items.Add(obj.ToString());
}
cboParam.SelectedIndex = 0;
foreach (object obj in Enum.GetValues(typeof(HIS.Report_BLL.ReControlTyp)))
{
cboUC.Items.Add(obj.ToString());
}
cboUC.SelectedIndex = 0;
foreach (object obj in Enum.GetValues(typeof(HIS.Base_BLL.Enums.FIELD_MARK_TYPE)))
{
cboEnume.Items.Add(obj.ToString());
}
cboEnume.Text = HIS.Base_BLL.Enums.FIELD_MARK_TYPE.无.ToString();
DataTable enume = _paramProcess.getEnum();
DataRow dr = enume.NewRow();
dr["ENUMNAME"] = "";
enume.Rows.Add(dr);
this.cboEnume.DataSource = enume;
this.cboEnume.SelectedIndex = -1;
loadReport();
}
/// <summary>
/// 加载窗体
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmReport_Load(object sender, EventArgs e)
{
_currentReport = new Reportdat();
_currentParam = new Paramater();
_reportProcess = new ReportProcess();
_Paramprocess = new ParamProcess();
loadReportdata();
}
private void FrmReportShow_Load(object sender, EventArgs e)
{
_currentReport = new Reportdat();
_currentParam = new Paramater();
_reportProcess = new ReportProcess();
_Paramprocess = new ParamProcess();
loadReportdata();
Reportparamter = _Paramprocess.Getparalist_all(_currentGroupId);
}
/// <summary>
/// 初始化控件
/// </summary>
public void CreateControls()
{
Paramater _para = new Paramater();
ParamProcess _paraProcess = new ParamProcess();
propertyPanel.Controls.Clear();
bool dtbegin = true;
Control ctrl = new Control();
int y_local = 9;
for (int i = 0; i < _paralist.Count; i++)
{
Paramater config = new Paramater();
config = _paralist[i];
#region 设置控件和列样式
if (config.PARAMETER == "V_CURREMPLOYEEID")
{
ctrl = new TextBox();
ctrl.Enabled = false;
ctrl.Text = _employyid.ToString();
}
else if (config.PARAMETER == "V_CURRDEPTID")
{
ctrl = new TextBox();
ctrl.Enabled = false;
ctrl.Text = _deptid.ToString();
}
else if (config.UIC_TYPE == 4)
{
#region quertytext
GWI.HIS.Windows.Controls.QueryTextBox txtDepartment = new QueryTextBox();
txtDepartment.AllowSelectedNullRow = false;
txtDepartment.BackColor = System.Drawing.Color.White;
txtDepartment.DisplayField = "name";
txtDepartment.Location = new System.Drawing.Point(120, 12);
txtDepartment.MatchMode = GWI.HIS.Windows.Controls.MatchModes.ByAnyString;
txtDepartment.MemberField = "id";
txtDepartment.MemberValue = null;
txtDepartment.Name = "txtDepartment";
txtDepartment.NextControl = null;
txtDepartment.NextControlByEnter = false;
txtDepartment.OffsetX = 0;
txtDepartment.OffsetY = 0;
txtDepartment.QueryFields = new string[] {
"PY_CODE"
};
txtDepartment.SelectedValue = null;
txtDepartment.SelectionCardAlternatingRowBackColor = System.Drawing.Color.WhiteSmoke;
txtDepartment.SelectionCardBackColor = System.Drawing.Color.White;
txtDepartment.SelectionCardColumnHeaderHeight = 20;
GWI.HIS.Windows.Controls.SelectionCardColumn selectionCardColumn1 = new GWI.HIS.Windows.Controls.SelectionCardColumn();
GWI.HIS.Windows.Controls.SelectionCardColumn selectionCardColumn2 = new GWI.HIS.Windows.Controls.SelectionCardColumn();
GWI.HIS.Windows.Controls.SelectionCardColumn selectionCardColumn3 = new GWI.HIS.Windows.Controls.SelectionCardColumn();
GWI.HIS.Windows.Controls.SelectionCardColumn selectionCardColumn4 = new GWI.HIS.Windows.Controls.SelectionCardColumn();
selectionCardColumn1.AutoFill = true;
selectionCardColumn1.DataBindField = "name";
selectionCardColumn1.HeaderText = "名称";
selectionCardColumn1.IsNameField = false;
selectionCardColumn1.IsSeachColumn = true;
selectionCardColumn1.TextAlign = System.Windows.Forms.DataGridViewContentAlignment.NotSet;
selectionCardColumn1.Visiable = true;
selectionCardColumn1.Width = 75;
selectionCardColumn2.AutoFill = false;
selectionCardColumn2.DataBindField = "PY_CODE";
selectionCardColumn2.HeaderText = "拼音码";
selectionCardColumn2.IsNameField = false;
selectionCardColumn2.IsSeachColumn = true;
selectionCardColumn2.TextAlign = System.Windows.Forms.DataGridViewContentAlignment.NotSet;
selectionCardColumn2.Visiable = false;
selectionCardColumn2.Width = 75;
selectionCardColumn3.AutoFill = false;
selectionCardColumn3.DataBindField = "id";
selectionCardColumn3.HeaderText = "id";
selectionCardColumn3.IsNameField = false;
selectionCardColumn3.IsSeachColumn = false;
selectionCardColumn3.TextAlign = System.Windows.Forms.DataGridViewContentAlignment.NotSet;
selectionCardColumn3.Visiable = false;
selectionCardColumn3.Width = 75;
DataTable dtSource = new DataTable();
if (config.FOREIGNER_FILTER_SQL != "")
{
dtSource = _para.GetDataSource(config.FOREIGNER_FILTER_SQL);
}
else
{
if (config.ENUMEID != -1)
{
dtSource = _para.GetDataSource(_paraProcess.GetEnumSql(config.ENUMEID).REMARK);
}
}
if (dtSource.Columns.Contains("备注"))
{
selectionCardColumn1.AutoFill = false;
selectionCardColumn4.AutoFill = true;
selectionCardColumn4.DataBindField = "备注";
selectionCardColumn4.HeaderText = "备注";
selectionCardColumn4.IsNameField = false;
selectionCardColumn4.IsSeachColumn = false;
selectionCardColumn4.TextAlign = System.Windows.Forms.DataGridViewContentAlignment.NotSet;
selectionCardColumn4.Visiable = true;
selectionCardColumn4.Width = 200;
txtDepartment.SelectionCardColumns = new GWI.HIS.Windows.Controls.SelectionCardColumn[] {
selectionCardColumn1,
selectionCardColumn2,
selectionCardColumn3,
selectionCardColumn4
};
txtDepartment.SelectionCardWidth = 350;
}
else
{
txtDepartment.SelectionCardColumns = new GWI.HIS.Windows.Controls.SelectionCardColumn[] {
selectionCardColumn1,
selectionCardColumn2,
selectionCardColumn3
};
txtDepartment.SelectionCardWidth = 150;
}
txtDepartment.SelectionCardFont = null;
txtDepartment.SelectionCardHeight = 200;
txtDepartment.SelectionCardInfoLabelBackColor = System.Drawing.Color.Empty;
txtDepartment.SelectionCardRowHeaderWidth = 35;
txtDepartment.SelectionCardRowHeight = 23;
txtDepartment.SelectionCardSelectedRowBackColor = System.Drawing.Color.DarkBlue;
txtDepartment.SelectionCardType = GWI.HIS.Windows.Controls.SelectionCardTypes.List;
// txtDepartment.SelectionCardWidth = 225;
txtDepartment.ShowRowNumber = true;
txtDepartment.ShowSelectionCardAfterEnter = true;
txtDepartment.Size = new System.Drawing.Size(123, 21);
txtDepartment.TabIndex = 0;
txtDepartment.TextFormat = GWI.HIS.Windows.Controls.TextFormatStyle.AnyString;
txtDepartment.Visible = true;
#endregion
if (config.FOREIGNER_FILTER_SQL != "")
{
txtDepartment.SetSelectionCardDataSource(dtSource);
}
else
{
if (config.ENUMEID != -1)
{
txtDepartment.SetSelectionCardDataSource(dtSource);
}
}
txtDepartment.DisplayField = "name";
txtDepartment.MemberField = "id";
txtDepartment.MemberValue = -1;
ctrl = txtDepartment;
}
else if (config.UIC_TYPE == 2)
{
#region checkbox
ctrl = new CheckBox();
((CheckBox)ctrl).Text = config.PARAMETER_CN;
((CheckBox)ctrl).AutoSize = true;
#endregion
}
else if (config.UIC_TYPE == 1)
{
#region combobox
ctrl = new ComboBox();
if (config.FOREIGNER_FILTER_SQL != "")
{
((ComboBox)ctrl).DataSource = _para.GetDataSource(config.FOREIGNER_FILTER_SQL);
}
else
{
if (config.ENUMEID != -1)
{
string sql = _paraProcess.GetEnumSql(config.ENUMEID).REMARK;
if (sql != null && sql != "")
{
((ComboBox)ctrl).DataSource = _para.GetDataSource(sql);
}
else
{
((ComboBox)ctrl).DataSource = _paraProcess.GetEnumOrders(config.ENUMEID);
}
}
}
((ComboBox)ctrl).DisplayMember = "name";
((ComboBox)ctrl).ValueMember = "id";
((ComboBox)ctrl).MaxDropDownItems = 25;
((ComboBox)ctrl).DropDownStyle = ComboBoxStyle.DropDownList;
#endregion
}
else if (config.UIC_TYPE == 0)
{
#region textbox
ctrl = new TextBox();
((TextBox)ctrl).MaxLength = config.DATALENGTH;
#endregion
}
else if (config.UIC_TYPE == 3)
{
#region datetimepicker
DateTimePicker dtpicter = new DateTimePicker();
dtpicter.CustomFormat = "yyyy-MM-dd HH:mm:ss";
dtpicter.Format = DateTimePickerFormat.Custom;
if (dtbegin)
{
dtpicter.Value = Convert.ToDateTime(DateTime.Now.Date.ToString("yyyy-MM-dd") + " 00:00:00");
dtbegin = false;
}
else
{
dtpicter.Value = Convert.ToDateTime(DateTime.Now.Date.ToString("yyyy-MM-dd") + " 23:59:59");
}
ctrl = dtpicter;
#endregion
}
else
{
}
#endregion
#region 创建控件和列
// 定义标签
Label lbl = new Label();
lbl.Text = config.PARAMETER_CN != "" ? config.PARAMETER_CN : config.PARAMETER;
lbl.AutoSize = true;
int lblWidth = 0;
int lblHeight = 0;
using (System.Drawing.Graphics g = propertyPanel.CreateGraphics())
{
System.Drawing.SizeF size = g.MeasureString(lbl.Text, propertyPanel.Font);
lblWidth = Convert.ToInt32(size.Width);
lblHeight = Convert.ToInt32(size.Height);
}
//定义控件
ctrl.Name = config.PARAMETER;
ctrl.Size = new System.Drawing.Size(140, 21);
ctrl.Location = new System.Drawing.Point(117, y_local);
ctrl.Tag = config;
if (config.UIC_TYPE != 2)
{
lbl.Left = ctrl.Left - lblWidth - 4;
lbl.Top = ctrl.Top + (21 - lblHeight);
propertyPanel.Controls.Add(lbl);
}
if (_paralist[i].PARAMETER_TYPE == "OUT")
{
ctrl.Visible = false;
lbl.Visible = false;
}
propertyPanel.Controls.Add(ctrl);
y_local += 27;
#endregion
}
}