/// <summary>
/// 添加控件至F4的集合
/// </summary>
/// <param name="F4">F4控件</param>
/// <param name="Ctr">数据字典包括的控件</param>
/// <param name="sAttr">控件属性。P:主键;R;查询条件;I:需F4查出来后返回值;B:往后台传的参数</param>
/// <param name="sBackname">对应后台字段名</param>
/// <param name="sColName">前台显示列名</param>
/// <param name="siCol">前台对应的列号。从1开始</param>
public static void Gp_DD_Collection(Control F4, object Ctr, string sAttr, string sBackname, string sColName, int siCol)
{
if (F4 is F4COMN)
{
F4COMN f4_temp = (F4COMN)F4;
f4_temp.Contrl.Add(Ctr);
f4_temp.CtlAttr.Add(sAttr == null ? "" : sAttr.ToUpper());
f4_temp.ColName.Add(sColName == null ? "" : sColName);
f4_temp.BackName.Add(sBackname == null ? "" : sBackname);
f4_temp.iCol.Add(siCol < 1 ? 1 : siCol);
}
else if (F4 is F4COMR)
{
F4COMR f4_temp = (F4COMR)F4;
f4_temp.Contrl.Add(Ctr);
f4_temp.CtlAttr.Add(sAttr == null ? "" : sAttr.ToUpper());
f4_temp.ColName.Add(sColName == null ? "" : sColName);
f4_temp.BackName.Add(sBackname == null ? "" : sBackname);
f4_temp.iCol.Add(siCol < 1 ? 1 : siCol);
}
else
{
throw new System.Exception("Gp_DD_Collection没有找到控件" + F4.Name);
}
}
/// <summary>
/// 设置F4控件的相关属性
/// </summary>
/// <param name="F4">F4控件</param>
/// <param name="sBackTableName">对应的后台表名</param>
/// <param name="sKeyName">代码对应的列名</param>
/// <param name="sKeyValue">代码值</param>
/// <param name="sJoin">限制条件</param>
/// <param name="sOrderBy">排序顺序</param>
/// <param name="sCusSql">自定义SQL语句</param>
/// <param name="sPrcoCode">自定义后台包名.过程名。eg:PKG_QZA1010C.P_AMODIFY1</param>
/// <param name="iMaxLength">F4COMR的长度</param>
public static void Gp_DD_Set(Control F4, string sBackTableName, string sKeyName, string sKeyValue, string sJoin, string sOrderBy, string sCusSql, string sPrcoCode, int iMaxLength)
{
if (F4 is F4COMN)
{
F4COMN f4_temp = (F4COMN)F4;
f4_temp.BackTableName = sBackTableName == null?"TZ_CD":sBackTableName;
f4_temp.KeyName = sKeyName == null?"":sKeyName;
f4_temp.Key = sKeyValue == null?"":sKeyValue;
f4_temp.OrderBy = sOrderBy == null?"":sOrderBy;
f4_temp.Join = sJoin == null?"":sJoin;
f4_temp.CusSql = sCusSql == null?"":sCusSql;
f4_temp.PrcoCode = sPrcoCode == null?"":sPrcoCode;
if (sPrcoCode != null && sPrcoCode.Length > 0)
{
f4_temp.Set_Witch2Cus();
}
}
else if (F4 is F4COMR)
{
F4COMR f4_temp = (F4COMR)F4;
f4_temp.BackTableName = sBackTableName == null ? "TZ_CD" : sBackTableName;
f4_temp.KeyName = sKeyName == null ? "" : sKeyName;
f4_temp.Key = sKeyValue == null ? "" : sKeyValue;
f4_temp.OrderBy = sOrderBy == null ? "" : sOrderBy;
f4_temp.Join = sJoin == null ? "" : sJoin;
f4_temp.CusSql = sCusSql == null ? "" : sCusSql;
f4_temp.PrcoCode = sPrcoCode == null ? "" : sPrcoCode;
f4_temp.MaxLength = iMaxLength < 1 ? 9999 : iMaxLength;
if (sPrcoCode != null && sPrcoCode.Length > 0)
{
f4_temp.Set_Witch2Cus();
}
}
else
{
throw new System.Exception("Gp_DD_Set没有找到控件" + F4.Name);
}
}
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);
}
public static void Gp_F4Find(Control F4)
{
string sWhere = "";
string sQuery = "";
if (F4 is F4COMN)
{
F4COMN f4_temp = (F4COMN)F4;
if (f4_temp.Get_Witch() == "MS" || f4_temp.Get_Witch() == "CUS")
{
if (!string.IsNullOrEmpty(f4_temp.CusSql))
{
sQuery = f4_temp.CusSql;
sWhere = "";
}
else if (!string.IsNullOrEmpty(f4_temp.PrcoCode))
{
string callSql = "{call " + f4_temp.PrcoCode + "(";
string Par = "";
for (int i = 0; i < f4_temp.Contrl.Count; i++)
{
if (f4_temp.CtlAttr[i].ToString().ToUpper().Contains("R"))
{
Par += "'" + MasterCommon.GetControlValue(f4_temp.Contrl[i]).ToString().Replace("'", "''") + "',";
}
}
if (Par.Length > 0)
{
Par = Par.Substring(0, Par.Length - 1);
}
callSql = callSql + Par + ")}";
sQuery = callSql;
sWhere = "";
}
else
{
string sQuery_temp = " ";
string sWhere_after = "";
string sWhere_before = "";
string sOrder_Temp = " ";
if (f4_temp.KeyName.Trim().Length > 0 && f4_temp.Key.Trim().Length > 0)
{
sWhere_before = "where " + f4_temp.KeyName.Trim() + "='" + f4_temp.Key.Trim() + "' and ";
}
else
{
sWhere_before = "where ";
}
sQuery = " SELECT ";
//拼Where 后面的限制条件 和 Select 后的字段
for (int i = 0; i < f4_temp.Contrl.Count; i++)
{
if (!string.IsNullOrEmpty(Convert.ToString(f4_temp.BackName[i])))
{
if (f4_temp.CtlAttr[i].ToString().ToUpper().Contains("R") && !f4_temp.CtlAttr[i].ToString().ToUpper().Contains("P"))
{
sWhere_after += "and nvl(" + f4_temp.BackName[i].ToString().Trim() + ",'') LIKE '%" + MasterCommon.GetControlValue(f4_temp.Contrl[i]).ToString().Trim().Replace("'", "''") + "%' ";
}
else if (f4_temp.CtlAttr[i].ToString().ToUpper().Contains("P"))
{
sWhere_after += "and " + f4_temp.BackName[i].ToString().Trim() + " LIKE '%" + MasterCommon.GetControlValue(f4_temp.Contrl[i]).ToString().Trim().Replace("'", "''") + "%' ";
sOrder_Temp += " " + f4_temp.BackName[i].ToString().Trim() + " Asc ,";
}
if (string.IsNullOrEmpty(Convert.ToString(f4_temp.ColName[i])))
{
sQuery_temp += " " + f4_temp.BackName[i] + " \" " + f4_temp.BackName[i] + " \",";
}
sQuery_temp += " " + f4_temp.BackName[i] + " \" " + f4_temp.ColName[i] + " \",";
}
}
sQuery += sQuery_temp.Substring(0, sQuery_temp.Length - 1) + " FROM " + f4_temp.BackTableName + " ";
sQuery += sWhere_before;
sWhere_after += " ";
// if (!sWhere_before.Contains("="))
{
sWhere_after = sWhere_after.Substring(4);
}
sWhere += sWhere_after + " ";
sWhere += " " + f4_temp.Join;
if (!string.IsNullOrEmpty(f4_temp.OrderBy))
{
sWhere += " " + f4_temp.OrderBy;
}
else
{
sWhere += " order by " + sOrder_Temp.Substring(0, sOrder_Temp.Length - 1);
}
}
}
System.Data.DataTable DataTab = GeneralCommon.Gf_ExecProc2Ref(sQuery + sWhere);
if (DataTab.Rows.Count == 1)
{
int i = 0;
string CtlAtt = "";
for (i = 0; i < f4_temp.Contrl.Count; i++)
{
CtlAtt = f4_temp.CtlAttr[i].ToString().ToUpper();
if (CtlAtt.Contains("I"))
{
Control Ctr = (Control)f4_temp.Contrl[i];
MasterCommon.SetControlValue(Ctr, DataTab.Rows[0][Convert.ToInt32(f4_temp.iCol[i]) - 1]);
}
}
}
}
else if (F4 is F4COMR)
{
F4COMR f4_temp = (F4COMR)F4;
if (f4_temp.Get_Witch() == "MS" || f4_temp.Get_Witch() == "CUS")
{
if (!string.IsNullOrEmpty(f4_temp.CusSql))
{
sQuery = f4_temp.CusSql;
sWhere = "";
}
else if (!string.IsNullOrEmpty(f4_temp.PrcoCode))
{
string callSql = "{call " + f4_temp.PrcoCode + "(";
string Par = "";
for (int i = 0; i < f4_temp.Contrl.Count; i++)
{
if (f4_temp.CtlAttr[i].ToString().ToUpper().Contains("R"))
{
Par += "'" + MasterCommon.GetControlValue(f4_temp.Contrl[i]).ToString().Replace("'", "''") + "',";
}
}
if (Par.Length > 0)
{
Par = Par.Substring(0, Par.Length - 1);
}
callSql = callSql + Par + ")}";
sQuery = callSql;
sWhere = "";
}
else
{
string sQuery_temp = " ";
string sWhere_after = "";
string sWhere_before = "";
string sOrder_Temp = " ";
if (f4_temp.KeyName.Trim().Length > 0 && f4_temp.Key.Trim().Length > 0)
{
sWhere_before = "where " + f4_temp.KeyName.Trim() + "='" + f4_temp.Key.Trim() + "' and ";
}
else
{
sWhere_before = "where ";
}
sQuery = " SELECT ";
//拼Where 后面的限制条件 和 Select 后的字段
for (int i = 0; i < f4_temp.Contrl.Count; i++)
{
if (!string.IsNullOrEmpty(Convert.ToString(f4_temp.BackName[i])))
{
if (f4_temp.CtlAttr[i].ToString().ToUpper().Contains("R") && !f4_temp.CtlAttr[i].ToString().ToUpper().Contains("P"))
{
sWhere_after += "and nvl(" + f4_temp.BackName[i].ToString().Trim() + ",'') LIKE '%" + MasterCommon.GetControlValue(f4_temp.Contrl[i]).ToString().Trim().Replace("'", "''") + "%' ";
}
else if (f4_temp.CtlAttr[i].ToString().ToUpper().Contains("P"))
{
sWhere_after += "and " + f4_temp.BackName[i].ToString().Trim() + " LIKE '%" + MasterCommon.GetControlValue(f4_temp.Contrl[i]).ToString().Trim().Replace("'", "''") + "%' ";
sOrder_Temp += " " + f4_temp.BackName[i].ToString().Trim() + " Asc ,";
}
if (string.IsNullOrEmpty(Convert.ToString(f4_temp.ColName[i])))
{
sQuery_temp += " " + f4_temp.BackName[i] + " \" " + f4_temp.BackName[i] + " \",";
}
sQuery_temp += " " + f4_temp.BackName[i] + " \" " + f4_temp.ColName[i] + " \",";
}
}
sQuery += sQuery_temp.Substring(0, sQuery_temp.Length - 1) + " FROM " + f4_temp.BackTableName + " ";
sQuery += sWhere_before;
sWhere_after += " ";
// if (!sWhere_before.Contains("="))
{
sWhere_after = sWhere_after.Substring(4);
}
sWhere += sWhere_after + " ";
sWhere += " " + f4_temp.Join;
if (!string.IsNullOrEmpty(f4_temp.OrderBy))
{
sWhere += " " + f4_temp.OrderBy;
}
else
{
sWhere += " order by " + sOrder_Temp.Substring(0, sOrder_Temp.Length - 1);
}
}
}
System.Data.DataTable DataTab = GeneralCommon.Gf_ExecProc2Ref(sQuery + sWhere);
if (DataTab.Rows.Count == 1)
{
int i = 0;
string CtlAtt = "";
for (i = 0; i < f4_temp.Contrl.Count; i++)
{
CtlAtt = f4_temp.CtlAttr[i].ToString().ToUpper();
if (CtlAtt.Contains("I"))
{
Control Ctr = (Control)f4_temp.Contrl[i];
MasterCommon.SetControlValue(Ctr, DataTab.Rows[0][Convert.ToInt32(f4_temp.iCol[i]) - 1]);
}
}
}
}
else
{
throw new System.Exception("Gp_DD_Collection没有找到控件" + F4.Name);
}
}