namespace CCB_Donet.ClassFolder
{
 public class FieldRuleInfo
 {
 public string gStrFNo;
 public string gStrFName;
 public string gStrFLock;
 public string gStrFCaption;
 public string gStrFType;
 public string gStrFMust;
 public string gStrFMin;
 public string gStrFMax;
 public string gStrFDefault;
 public string gStrFDate;
 public string gStrFDB;
 public string gStrFAllow;
 public string gStrFDisallow;
 public string gStrFSB;
 public string gStrFBig;
 public string gStrFSmall;
 public string gStrFInputMethod;
 public string gStrFCHK;
 public string gStrFRelation;
 public string gStrFDesc;
 public string gStrFSecond;
 public string gStrFQC;
 public string gStrFException;
 public string gStrFASupp;
 public string gStrFYQH;
 public string gStrFPos;
 public string gStrFStar;
 public string gStrFSave;
 public string gStrFAddress;
 public string gStrFLblColor;
 public string gStrFIsCheckList;
 }
}
 
 #region 加載字段規(guī)則
 private bool m_GetRule()
 {
  string strSQL = "";
  DataTable dtGet = null;
#if(DEBUG)
  try
  {
#endif
  if (Common.gIntTypeOrder == 95)
  {
   strSQL = "select A.FNo,A.FName,A.FLock,A.FCaption,A.FType," + 
    "A.FMust,A.FMin,A.FMax,A.FDefault,A.FDate,\r\n" +
   "A.FDB,A.FAllow,A.FDisallow,A.FSB,A.FBig,A.FSmall,A.FInputMethod," + 
   "A.FCHK,A.FRelation,A.FDesc,A.FSecond,\r\n" +
   "A.FQC,A.FException,A.FASupp,A.FYQH,A.FPos,A.FStar,A.FSave,"+
   "A.FAddress,A.FLblColor,A.FIsCheckList from P_Field_Rule95 A \r\n" +
   "INNER JOIN P_Field_Initial B ON A.FNo=B.FNo \r\n" +
   "where A.FormType=1 AND B.FSection='1' AND " + 
    "(B.FRegion95=1 OR B.FRegion95=-1) ORDER BY A.FOrder";
  }
  else
  {
   strSQL = "select A.FNo,A.FName,A.FLock,A.FCaption,A.FType,"+
    "A.FMust,A.FMin,A.FMax,A.FDefault,A.FDate,\r\n" +
    "A.FDB,A.FAllow,A.FDisallow,A.FSB,A.FBig,A.FSmall,"+
    "A.FInputMethod,A.FCHK,A.FRelation,A.FDesc,A.FSecond,\r\n" +
    "A.FQC,A.FException,A.FASupp,A.FYQH,A.FPos,A.FStar,"+
    "A.FSave,A.FAddress,A.FLblColor,A.FIsCheckList "+
    "from P_Field_Rule A \r\n" +
    "INNER JOIN P_Field_Initial B ON A.FNo=B.FNo \r\n" +
    "where A.FormType=" + Common.gIntFormType.ToString() +
    " AND B.FSection='1' AND (B.FRegion=" + Common.gIntRegion.ToString() +
    " OR B.FRegion=-1) ORDER BY A.FOrder";
  }
  dtGet = DB.GetDataTableBySQL(strSQL);
  if (dtGet.Rows.Count <= 0)
  {
   Common.ShowMessage("字段規(guī)則表沒(méi)有數(shù)據(jù),請(qǐng)馬上聯(lián)系軟件工程師!", MessageBoxIcon.Error);
   return false;
  }
  //獲得類信息，為下面的反射調(diào)用做準(zhǔn)備
  Type oType = Type.GetType("CCB_Donet.ClassFolder.FieldRuleInfo");
  //生成類對(duì)象數(shù)組，和數(shù)據(jù)庫(kù)記錄個(gè)數(shù)是一致的
  mMainFieldRule = new FieldRuleInfo[dtGet.Rows.Count];  
  for (int i = 0; i < dtGet.Rows.Count; i++)
  {
   //這里使用反射動(dòng)態(tài)為FieldRuleInfo字段賦值數(shù)據(jù)
   mMainFieldRule[i] = new FieldRuleInfo();
   for (int j = 0; j < dtGet.Columns.Count; j++)
   {
   //這里直接獲取類的字段名稱，然后把數(shù)據(jù)庫(kù)里對(duì)應(yīng)字段的值賦值給它
   FieldInfo fieldInfo = oType.GetField("gStr" + dtGet.Columns[j].ColumnName,
    BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance
     | BindingFlags.Static);
   fieldInfo.SetValue(mMainFieldRule[i], dtGet.Rows[i][j].ToString());
   }
  }
  return true;
#if(DEBUG)
  }
  catch (Exception ex)
  {
  return false;
  MyLog.WriteErrLog("frmDE-m_GetRule", ex.Message);
  }
  finally
  {
  dtGet = null;
  }
#endif
 }
 #endregion