public IValidateExpression <Data> CreateValidator <Data>() where Data : class
{
ValidateExpression <Data> expression = new ValidateExpression <Data>();
ValidateExpressions.Add(typeof(Data), expression);
return(expression);
}
public WebFiles_TestPlan_TopoEquipment()
{
string serverName = ConfigurationManager.AppSettings["ServerName"].ToString();
string dbName = ConfigurationManager.AppSettings["DbName"].ToString();
string userId = ConfigurationManager.AppSettings["UserId"].ToString();
string pwd = ConfigurationManager.AppSettings["Pwd"].ToString();
pDataIO = null;
pDataIO = new SqlManager(serverName, dbName, userId, pwd);
validExpre = new ValidateExpression();
}
public WebFiles_APPModel_CurrModelParamInfo()
{
string serverName = ConfigurationManager.AppSettings["ServerName"].ToString();
string dbName = ConfigurationManager.AppSettings["DbName"].ToString();
string userId = ConfigurationManager.AppSettings["UserId"].ToString();
string pwd = ConfigurationManager.AppSettings["Pwd"].ToString();
validExpre = new ValidateExpression();
pDataIO = null;
pDataIO = new SqlManager(serverName, dbName, userId, pwd);
}
public override void ReadValidateRule()
{
Hashtable columnHeader = new Hashtable();
Hashtable fillParameters = new Hashtable();
using (Office.Excel.ForwardExcelReader reader = new Office.Excel.ForwardExcelReader(base.ValidateFileName))
{
reader.Open();
Office.Excel.ForwardReadWorksheet sheet = reader.Activate("填报规则") as Office.Excel.ForwardReadWorksheet;
if (sheet != null)
{
object header = null;
if (sheet.ReadNextRow() && sheet.CurrentRowIndex == 1)
{
while (sheet.ReadNextCell(false))
{
header = sheet.GetContent();
columnHeader.Add(sheet.CurrentCell.ColumnIndex, header == null ? "" : header.ToString());
}
}
object content = null;
string key = "", str = "";
while (sheet.ReadNextRow())
{
ValidateExpression expr = new ValidateExpression();
while (sheet.ReadNextCell(false))
{
content = sheet.GetContent();
str = content == null ? "" : content.ToString();
switch (columnHeader[sheet.CurrentCell.ColumnIndex] as string)
{
case "参数编号":
key = str;
break;
case "校验规则":
expr.Expression = str;
break;
case "是否必填":
expr.IsRequired = (str == "是");
break;
}
}
if (string.IsNullOrEmpty(key) == false)
{
rules.Add(key, expr);
}
}
}
}
}
public override bool IsSpecial(string key, string value)
{
if (string.IsNullOrEmpty(value))
{
return(false);
}
ValidateExpression expr = rules[key] as ValidateExpression;
if (expr != null && expr.Expression == "-1" && value.Trim() != "N/A")
{
return(true);
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
IsSessionNull();
string serverName = ConfigurationManager.AppSettings["ServerName"].ToString();
string dbName = "";
string userId = ConfigurationManager.AppSettings["UserId"].ToString();
string pwd = ConfigurationManager.AppSettings["Pwd"].ToString();
if (Session["DB"] == null)
{
Response.Redirect("~/Default.aspx", true);
}
else if (Session["DB"].ToString().ToUpper() == "ATSDB")
{
dbName = ConfigurationManager.AppSettings["DbName"].ToString();
}
else if (Session["DB"].ToString().ToUpper() == "ATSDEBUGDB")
{
dbName = ConfigurationManager.AppSettings["DbName2"].ToString();
}
validExpre = new ValidateExpression();
pDataIO = null;
pDataIO = new SqlManager(serverName, dbName, userId, pwd);
Session["TreeNodeExpand"] = null;
SetSessionBlockType(3);
if (Request.QueryString["uId"] != null)
{
paramID = Request.QueryString["uId"];
}
if (Request.QueryString["ModelID"] != null)
{
ModelID = Request.QueryString["ModelID"];
}
if (Request.QueryString["AddNew"] != null)
{
AddNew = (Request.QueryString["AddNew"].ToLower() == "true" ? true : false);
paramID = "-1";
}
queryStr = "select * from GlobalTestModelParamterList where id =" + paramID;
initPageInfo();
}
public override bool IsValid(string key, string value)
{
ValidateExpression expr = rules[key] as ValidateExpression;
if (expr == null)
{
return(true);
}
else if (string.IsNullOrEmpty(value))
{
return(!expr.IsRequired);
}
else if (string.IsNullOrEmpty(expr.Expression) || value.Trim() == "N/A")
{
return(true);
}
return(System.Text.RegularExpressions.Regex.IsMatch(value, expr.Expression));
}
