public static int Delete(KeyRegextype model,object trans)
{
if(model != null && trans !=null )
return baseOperate.Delete(model,trans);
else
throw new ApplicationException("在dbo.key_regexType中删除一条记录时,传递的参数model,trans有错误！");
}
public static int Delete(KeyRegextype model)
{
if(model != null)
return baseOperate.Delete(model);
else
throw new ApplicationException("在dbo.key_regexType中删除一条记录时,传递的参数model为Null！");;
}
public static int Insert(KeyRegextype model)
{
if(model != null)
return baseOperate.Insert(model);
else
throw new ApplicationException("在dbo.key_regexType中增加一条记录时,传递的参数model为Null！");
}
protected void btnInsertRegexType_Click(object sender, EventArgs e)
{
KeyRegextype krt = new KeyRegextype();
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "all";
krt.Keycode = "";
krt.Keyinfo = "所有";
krt.Sort = 0;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "intege1";
krt.Keycode = "^$|^[1-9]\\d*$";
krt.Keyinfo = "正整数";
krt.Sort = 1;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "intege2";
krt.Keycode = "^$|^-[1-9]\\d*$";
krt.Keyinfo = "负整数";
krt.Sort = 2;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "num";
krt.Keycode = "^[0-9]*$";
krt.Keyinfo = "数字";
krt.Sort = 3;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "num1";
krt.Keycode = "^$|^[1-9]\\d*|0$";
krt.Keyinfo = "正数";
krt.Sort = 4;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "num2";
krt.Keycode = "^$|^-[1-9]\\d*|0$";
krt.Keyinfo = "负数";
krt.Sort = 5;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "decmal";
krt.Keycode = "^$|^([+-]?)\\d*\\.\\d+$";
krt.Keyinfo = "浮点数";
krt.Sort = 6;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "decmal1";
krt.Keycode = "^$|^[1-9]\\d*.\\d*|0.\\d*[1-9]\\d*$";
krt.Keyinfo = "正浮点数";
krt.Sort = 7;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "decmal2";
krt.Keycode = "^$|^-([1-9]\\d*.\\d*|0.\\d*[1-9]\\d*)$";
krt.Keyinfo = "负浮点数";
krt.Sort = 8;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "decmal3";
krt.Keycode = "^$|^[1-9]\\d*.\\d*|0.\\d*[1-9]\\d*|0?.0+|0$";
krt.Keyinfo = "非负浮点数";
krt.Sort = 9;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "decmal4";
krt.Keycode = "^$|^(-([1-9]\\d*.\\d*|0.\\d*[1-9]\\d*))|0?.0+|0$";
krt.Keyinfo = "非正浮点数";
krt.Sort = 10;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "email";
krt.Keycode = "^$|^\\w+((-\\w+)|(\\.\\w+))*\\@[A-Za-z0-9]+((\\.|-)[A-Za-z0-9]+)*\\.[A-Za-z0-9]+$";
krt.Keyinfo = "邮箱地址";
krt.Sort = 11;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "color";
krt.Keycode = "^$|^[a-fA-F0-9]{6}$";
krt.Keyinfo = "颜色";
krt.Sort = 12;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "color";
krt.Keycode = "^$|^[a-fA-F0-9]{6}$";
krt.Keyinfo = "颜色";
krt.Sort = 13;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "url";
krt.Keycode = "^$|^http[s]?:\\/\\/([\\w-]+\\.)+[\\w-]+([\\w-./?%&=]*)?$";
krt.Keyinfo = "URL地址";
krt.Sort = 14;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "chinese";
krt.Keycode = "^$|^[\\u4E00-\\u9FA5\\uF900-\\uFA2D]+$";
krt.Keyinfo = "中文";
krt.Sort = 15;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "ascii";
krt.Keycode = "^$|^[\\x00-\\xFF]+$";
krt.Keyinfo = "仅ACSII字符";
krt.Sort = 16;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "zipcode";
krt.Keycode = "^$|^\\d{6}$";
krt.Keyinfo = "邮编";
krt.Sort = 17;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "mobile";
krt.Keycode = "^$|^(13|15)[0-9]{9}$";
krt.Keyinfo = "手机";
krt.Sort = 18;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "ip4";
krt.Keycode = "^$|^(\\d{1,2}|1\\d\\d|2[0-4]\\d|25[0-5]).(\\d{1,2}|1\\d\\d|2[0-4]\\d|25[0-5]).(d{1,2}|1\\d\\d|2[0-4]\\d|25[0-5]).(\\d{1,2}|1\\d\\d|2[0-4]\\d|25[0-5])$";
krt.Keyinfo = "IP地址";
krt.Sort = 19;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "notempty";
krt.Keycode = "^$|^\\S+$";
krt.Keyinfo = "非空";
krt.Sort = 20;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "picture";
krt.Keycode = "^$|(.*)\\.(jpg|bmp|gif|ico|jpeg|png)$";
krt.Keyinfo = "图片";
krt.Sort = 21;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "rar";
krt.Keycode = "^$|(.*)\\.(rar|zip|7zip|tgz)$";
krt.Keyinfo = "压缩文件";
krt.Sort = 22;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "date";
krt.Keycode = "^(\\d{1,4})(-|\\/)(\\d{1,2})\\2(\\d{1,2})$";
krt.Keyinfo = "日期";
krt.Sort = 23;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "qq";
krt.Keycode = "^$|^[1-9]*[1-9][0-9]*$";
krt.Keyinfo = "QQ号";
krt.Sort = 24;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "tel";
krt.Keycode = "^$|(\\d{3}-|\\d{4}-)?(\\d{8}|\\d{7})";
krt.Keyinfo = "国内电话";
krt.Sort = 25;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "username";
krt.Keycode = "^$|^\\w+$";
krt.Keyinfo = "用户名";
krt.Sort = 26;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "letter";
krt.Keycode = "^$|^[A-Za-z]+$";
krt.Keyinfo = "字母";
krt.Sort = 27;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "letter_u";
krt.Keycode = "^$|^[A-Z]+$";
krt.Keyinfo = "大写字母";
krt.Sort = 28;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "letter_l";
krt.Keycode = "^$|^[a-z]+$";
krt.Keyinfo = "小写字母";
krt.Sort = 29;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "idcard";
krt.Keycode = "^$|^[1-9]([0-9]{14}|[0-9]{17})$";
krt.Keyinfo = "身份证";
krt.Sort = 30;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "charNumber";
krt.Keycode = "^$|^([\u4e00-\u9fa5]|[a-zA-Z0-9]|[_ ()])*$";
krt.Keyinfo = "一般性字符";
krt.Sort = 31;
BizKeyRegextype.Insert(krt);
krt.Keyid = Guid.NewGuid().ToString();
krt.Keyname = "intege";
krt.Keycode = "^$|^-?[1-9]\\d*$";
krt.Keyinfo = "整数";
krt.Sort = 32;
BizKeyRegextype.Insert(krt);
LABMsg.Text = "插入验证类型字典表成功";
}
public static bool Exists(KeyRegextype model)
{
if(model != null )
return baseOperate.Exists(model);
else
throw new ApplicationException("在dbo.key_regexType中查询某条记录是否存在时,传递的参数model为Null！");
}
public static KeyRegextype GetModel(KeyRegextype model)
{
if(model != null )
return baseOperate.GetModel(model);
else
throw new ApplicationException("根据主键获取dbo.key_regexType中的一条记录时,传递的参数model为Null！");
}
