/// <summary>
/// 读取要显示的公告信息
/// </summary>
private void log_display()
{
try
{
fg1.Cols.Fixed = 0;
DataSet ds = new CommonClass.ProcQuery("LOG_FIND", new ArrayList()).CreateDataSet(false);
if (ds.Tables[0].Rows.Count > 0)
{
fg1.DataSource = ds.Tables[0];
}
fg1.Cols.Fixed = 0;
}
catch //(System.Exception e)
{
}
}
/// <summary>
/// 检查权限
/// </summary>
private void Chk_Authority()
{
ArrayList TempParamAry = new ArrayList();
TempParamAry.Add(GeneralCommon.sUserID);
CommonClass.ProcQuery TempProcQuery = new CommonClass.ProcQuery("PKG_MAIN.P_AUTHORITY", TempParamAry);
DataSet ds = TempProcQuery.CreateDataSet();
try
{
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "0")
{
cmd_f.Enabled = false;
menuItem1.Enabled = false;
}
if (ds.Tables[0].Rows[0].ItemArray[1].ToString() == "0")
{
cmd_z.Enabled = false;
menuItem9.Enabled = false;
}
if (ds.Tables[0].Rows[0].ItemArray[2].ToString() == "0")
{
cmd_a.Enabled = false;
menuItem11.Enabled = false;
}
if (ds.Tables[0].Rows[0].ItemArray[3].ToString() == "0")
{
cmd_d.Enabled = false;
menuItem10.Enabled = false;
}
}
}
catch (Exception ex)
{
GeneralCommon.Gp_MsgBoxDisplay("获取权限错误!" + ex.ToString());
return;
}
}
private TableLayoutPanel CreateField(int colIndex)
{
//Create TableLayoutPanel
TableLayoutPanel tlp = new TableLayoutPanel();
tlp.ColumnCount = 2;
tlp.RowCount = 1;
tlp.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 36.0F));
tlp.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 64.0F));
tlp.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100.0F));
//Create Label
Label lbl = new Label();
lbl.BorderStyle = BorderStyle.Fixed3D;
lbl.TextAlign = ContentAlignment.MiddleRight;
lbl.Text = (string)((Collection )Sc["CHTitle"])[colIndex];
tlp.Controls.Add(lbl, 0, 0);
lbl.Dock = System.Windows.Forms.DockStyle.Fill;
string sType = ((string)((Collection )Sc["ColType"])[colIndex]).ToUpper();
object ctl = null;
switch (sType)
{
case "E": //'TextEdit,Password
case "P":
TextBox ctl_t = new TextBox();
if (sType == "P")
{
ctl_t.PasswordChar = '*';
}
if (((Collection)Sc["ColLength"])[colIndex] == "")
{
ctl_t.MaxLength = 200;
}
else
{
ctl_t.MaxLength = (int)((Collection)Sc["ColLength"])[colIndex];
}
//ctl_t.MaxLength = ги((Collection)Sc["ColLength"])[colIndex] == "" ? 200 : ((Collection)Sc["ColLength"])[colIndex]));
tlp.Controls.Add(ctl_t, 1, 0);
ctl_t.Dock = DockStyle.Fill;
ctl_t.Text = (string)Record[colIndex];
ctl = ctl_t;
break;
case "N": //'NumberEdit
ctl = new System.Windows.Forms.MaskedTextBox();
MaskedTextBox ctl_m = new MaskedTextBox();
string[] Ass_1 = new string[3];
Ass_1 = ((Collection)Sc["ColLength"])[colIndex].ToString().Split(',');
ctl_m.Mask = " ".PadLeft(int.Parse(Ass_1[0])).Trim() + "." + " ".PadLeft(int.Parse(Ass_1[1])).Trim();
tlp.Controls.Add(ctl_m, 1, 0);
ctl_m.Dock = DockStyle.Fill;
ctl_m.Text = (string)Record[colIndex];
ctl = ctl_m;
break;
case "ON":
case "OE":
//'Combox not editable ''Combox Editable
ctl = new ComboBox();
ComboBox ctl_c = new ComboBox();
string[] splitCom = ((Collection)Sc["ComCode"])[colIndex].ToString().Split(';');
string[] splitProc = ((Collection)Sc["Filter"])[colIndex].ToString().Split(';');
string[] splitCus = ((Collection)Sc["CustQuery"])[colIndex].ToString().Split(';');
DataSet ds = null;
if (splitCom[0].Trim() != "")
{
ds = new CdQuery(splitCom[0].Trim(), "").CreateDataSet(true);
ctl_c.DataSource = ds;
}
else if (splitProc[0].Trim() != "")
{
ds = new ProcQuery(splitProc[0].Trim(), new ArrayList()).CreateDataSet(true);
ctl_c.DataSource = ds;
}
else if (splitCus[0].Trim() != "")
{
ds = new Query(splitCus[0].Trim()).CreateDataSet(true);
ctl_c.DataSource = ds;
}
ctl_c.DataSource = ds.Tables[0].DefaultView;
ctl_c.DisplayMember = ds.Tables[0].Columns[0].ToString();
ctl_c.ValueMember = ds.Tables[0].Columns[1].ToString();
ctl_c.SelectedValue = "";
if (sType == "ON")
{
ctl_c.DropDownStyle = ComboBoxStyle.DropDownList;
}
else
{
ctl_c.DropDownStyle = ComboBoxStyle.DropDown;
}
tlp.Controls.Add(ctl_c, 1, 0);
ctl_c.Dock = DockStyle.Fill;
ctl_c.Text = (string)Record[colIndex];
ctl = ctl_c;
break;
case "C": //'Checkbox
CheckBox ctl_c2 = new CheckBox();
tlp.Controls.Add(ctl_c2, 1, 0);
ctl_c2.Dock = DockStyle.Fill;
ctl_c2.Text = (string)Record[colIndex];
ctl = ctl_c2;
break;
case "D": //'Date ,Time
case "T":
DateTimePicker ctl_d = new DateTimePicker();
ctl_d.Format = DateTimePickerFormat.Custom;
if (sType == "D")
{
ctl_d.CustomFormat = "yyyy-MM-dd";
}
else
{
ctl_d.CustomFormat = "HH:mm:ss";
}
tlp.Controls.Add(ctl_d, 1, 0);
ctl_d.Dock = DockStyle.Fill;
ctl_d.Text = (string)Record[colIndex];
ctl = ctl_d;
break;
case "COMR": //'TextEdit with F4 Event return Common code and name
ctl = new F4COMR();
F4COMR ctl_f = new F4COMR();
ctl_f.sKey = ((Collection)Sc["ComCode"])[colIndex].ToString();
ctl_f.sJoin = ((Collection)Sc["Filter"])[colIndex].ToString();
ctl_f.sMax = 20;
tlp.Controls.Add(ctl_f, 1, 0);
ctl_f.Dock = DockStyle.Fill;
ctl_f.Text = (string)Record[colIndex];
ctl = ctl_f;
break;
case "COMN": //'TextEdit with F4 Event return Common code only
F4COMN ctl_f2 = new F4COMN();
ctl_f2.sKey = ((Collection)Sc["ComCode"])[colIndex].ToString();
ctl_f2.sJoin = ((Collection)Sc["Filter"])[colIndex].ToString();
tlp.Controls.Add(ctl_f2, 1, 0);
ctl_f2.Dock = DockStyle.Fill;
ctl_f2.Text = (string)Record[colIndex];
ctl = ctl_f2;
break;
case "ETCR": //'TextEdit with F4 Event return code and name
break;
case "ETCN": //'TextEdit with F4 Event return code only
F4ETCN ctl_f3 = new F4ETCN();
ctl_f3.sJoin = ((Collection)Sc["Filter"])[colIndex].ToString();
string[] Ass = new string[3];
Ass = (((Collection)Sc["CustQuery"])[colIndex]).ToString().Split(';');
ctl_f3.sSqletc = Ass[0];
ctl_f3.sFcontrol = Ass[1];
tlp.Controls.Add(ctl_f3, 1, 0);
ctl_f3.Dock = DockStyle.Fill;
ctl_f3.Text = (string)Record[colIndex];
ctl = ctl_f3;
break;
}
string sAttr = (string)(((Collection)Sc["ColAttr"])[colIndex].ToString().ToUpper());
if (sAttr.IndexOf("P") > -1)
{
((Collection)m_Master["pControl"]).Add(ctl);
}
else if (sAttr.IndexOf("N") > -1)
{
((Collection)m_Master["nControl"]).Add(ctl);
}
else if (sAttr.IndexOf("M") > -1)
{
((Collection)m_Master["mControl"]).Add(ctl);
}
else if (sAttr.IndexOf("I") > -1)
{
((Collection)m_Master["iControl"]).Add(ctl);
}
else if (sAttr.IndexOf("L") > -1)
{
((Collection)m_Master["lControl"]).Add(ctl);
}
return(tlp);
}