public static int Delete(SysKeys model,object trans)
{
if(model != null && trans !=null )
return baseOperate.Delete(model,trans);
else
throw new ApplicationException("在dbo.sys_keys中删除一条记录时,传递的参数model,trans有错误！");
}
public static int Delete(SysKeys model)
{
if(model != null)
return baseOperate.Delete(model);
else
throw new ApplicationException("在dbo.sys_keys中删除一条记录时,传递的参数model为Null！");;
}
public static int Insert(SysKeys model)
{
if(model != null)
return baseOperate.Insert(model);
else
throw new ApplicationException("在dbo.sys_keys中增加一条记录时,传递的参数model为Null！");
}
protected void btnInsertKeySysKey_Click(object sender, EventArgs e)
{
SysKeys sk = new SysKeys();
sk.Keytableid = "";
sk.Keytablename = "NotTable";
sk.Keytablenamech = "无字典";
sk.Keytableselect = "";
sk.Sort = 0;
BizSysKeys.Insert(sk);
sk.Keytableid = Guid.NewGuid().ToString();
sk.Keytablename = "key_grade";
sk.Keytablenamech = "学历字典表";
sk.Keytableselect = "SELECT keyName, keyCode FROM key_grade ORDER BY sort";
sk.Sort = 1;
BizSysKeys.Insert(sk);
sk.Keytableid = Guid.NewGuid().ToString();
sk.Keytablename = "key_regexType";
sk.Keytablenamech = "验证类型字典表";
sk.Keytableselect = "SELECT keyName, keyCode FROM key_regexType ORDER BY sort";
sk.Sort = 2;
BizSysKeys.Insert(sk);
sk.Keytableid = Guid.NewGuid().ToString();
sk.Keytablename = "key_sex";
sk.Keytablenamech = "性别字典表";
sk.Keytableselect = "SELECT keyName, keyCode FROM key_sex ORDER BY sort";
sk.Sort = 3;
BizSysKeys.Insert(sk);
sk.Keytableid = Guid.NewGuid().ToString();
sk.Keytablename = "key_editType";
sk.Keytablenamech = "编辑类型字典表";
sk.Keytableselect = "SELECT keyName, keyCode FROM key_editType ORDER BY sort";
sk.Sort = 4;
BizSysKeys.Insert(sk);
LABMsg.Text = "插入字典管理表成功";
}
public static bool Exists(SysKeys model)
{
if(model != null )
return baseOperate.Exists(model);
else
throw new ApplicationException("在dbo.sys_keys中查询某条记录是否存在时,传递的参数model为Null！");
}
public static SysKeys GetModel(SysKeys model)
{
if(model != null )
return baseOperate.GetModel(model);
else
throw new ApplicationException("根据主键获取dbo.sys_keys中的一条记录时,传递的参数model为Null！");
}