/// <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); } }