|
6）查询 -- 按分类卷号
#region
public DataSet Find_Scroll_ByScl_1(ClsScroll TmpScroll, string tbName) //模糊查询
{
SqlParameter[] prams = {
data.MakeInParam("@Scl_1", SqlDbType.VarChar, 20, "%" + TmpScroll.MyScl_1+"%"),
};
return (data.RunProcReturn("select Id,Scl_1,Scl_2,Scl_3,Scl_4,Scl_5," +
"Scl_6,Scl_7,Scl_17,Scl_18,Scl_19,Scl_20,Scl_21,Creator,Ctime,Mender,Mtime" +
" from tb_Scroll where Scl_1 like @Scl_1" +
" order by Id", prams, tbName));
}
#endregion
7）查询 -- 按装订代号
#region
public DataSet Find_Scoll_ByScl_2(ClsScroll TmpScroll, string tbName) //模糊查询
{
SqlParameter[] prams = {
data.MakeInParam("@Scl_2", SqlDbType.VarChar, 20, "%" + TmpScroll.MyScl_2 + "%"),
};
return (data.RunProcReturn("select Id,Scl_1,Scl_2,Scl_3,Scl_4,Scl_5," +
"Scl_6,Scl_7,Scl_17,Scl_18,Scl_19,Scl_20,Scl_21,Creator,Ctime,Mender,Mtime" +
" from tb_Scroll where Scl_2 like @Scl_2" +
" order by Id", prams, tbName));
}
#endregion
8）查询 -- 按姓名年月 – 模糊查询
#region
public DataSet Find_Scroll_Name_YM(string TmpName, string TmpYM, string tbName) //不显示重复记录distinct
{
return (data.RunProcReturn("select distinct Id,Scl_1,Scl_2,Scl_3,Scl_4,Scl_5,Scl_6,Scl_7,Scl_8,Scl_9,Scl_10,Scl_11," +
"Scl_12,Scl_13,Scl_14,Scl_15,Scl_16,Scl_17,Scl_18,Scl_19,Scl_20,Scl_21,Creator,Ctime,Mender,Mtime" +
" from tb_Scroll" +
" where (Creator like '%" + TmpName + "%' and Ctime like '%" + TmpYM + "%')" +
" Or (Mender like '%" + TmpName + "%' and Mtime like '%" + TmpYM + "%')" +
" order by Id", tbName));
}
#endregion
7 功能模块设计
1．系统登录设计
系统登录主要用于对进入科技档案管理系统的用户进行安全性检查，以防止非法用户进入系统。只有合法的用户，才可以进入系统，同时根据管理员分配的权限，给予操作员相应的操作权限。本系统开发模式采用隔离驱动模式，验证操作员及其密码，主要通过业务层的Login方法，如果操作员符合则允许登录，并给予相应的权限，否则提示用户非法登录。
（1）系统登录运行结果如图5所示。
图5 系统登录窗体
|
