/// <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(C1.Win.C1FlexGrid.Column F4, string sBackTableName, string sKeyName, string sKeyValue, string sJoin, string sOrderBy, string sCusSql, string sPrcoCode, int iMaxLength)
{
F4COMN f4_temp = new F4COMN();
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();
}
F4.Editor = f4_temp;
//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);
//}
}
/// <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);
}
}
