public DataTable SearchOutstanding(string invoiceNo, string customer, DateTime dateFrom, DateTime dateTo, DateTime dateEnd, string outstandingType) { //outstandingType:AR/AP/ALL if (outstandingType == "AR") { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_QueryOutstandingAR"); sp.AddParam("@InvoiceNo", SqlDbType.VarChar, 20, invoiceNo); sp.AddParam("@CustomerCode", SqlDbType.VarChar, 20, customer); sp.AddParam("@FromDate", SqlDbType.VarChar, 8, ConvertEx.ToCharYYYYMMDD(dateFrom)); sp.AddParam("@ToDate", SqlDbType.VarChar, 8, ConvertEx.ToCharYYYYMMDD(dateTo)); sp.AddParam("@EndDate", SqlDbType.VarChar, 8, ConvertEx.ToCharYYYYMMDD(dateEnd)); return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, "Outstanding" + outstandingType)); } if (outstandingType == "AP") { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_QueryOutstandingAP"); sp.AddParam("@InvoiceNo", SqlDbType.VarChar, 20, invoiceNo); sp.AddParam("@SupplierCode", SqlDbType.VarChar, 20, customer); sp.AddParam("@FromDate", SqlDbType.VarChar, 8, ConvertEx.ToCharYYYYMMDD(dateFrom)); sp.AddParam("@ToDate", SqlDbType.VarChar, 8, ConvertEx.ToCharYYYYMMDD(dateTo)); sp.AddParam("@EndDate", SqlDbType.VarChar, 8, ConvertEx.ToCharYYYYMMDD(dateEnd)); return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, "Outstanding" + outstandingType)); } return(null); }
/// <summary> /// 获取物理表的字段 /// </summary> /// <param name="tableName">物理表名</param> /// <returns></returns> public DataTable GetTableFields(string tableName) { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_sys_GetTableFieldType"); sp.AddParam("@TableName", SqlDbType.VarChar, 50, tableName); return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, "tb_TableFieldTypeData")); }
/// <summary> /// 还原数据库 /// </summary> /// <param name="BKFILE">备份的文件。如:C:\CSFramework22.Normal_2010.bak</param> /// <param name="DBNAME">数据名称。如:CSFramework22.Normal</param> public bool RestoreDatabase(string BKFILE, string DBNAME) { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("p_RestoreDB"); sp.AddParam("@BKFILE", SqlDbType.NVarChar, 1000, BKFILE); sp.AddParam("@DBNAME", SqlDbType.NVarChar, 100, DBNAME); DataProvider.Instance.ExecuteNoQuery(Globals.DEF_MASTER_DB, sp.SqlCommand); return(true); }
/// <summary> /// 删除用户组 /// </summary> /// <param name="groupCode">用户组编号</param> /// <returns></returns> public bool DeleteGroupByKey(string groupCode) { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_MyDeleteGroupData"); sp.AddParam("@GroupCode", SqlDbType.VarChar, groupCode); object o = DataProvider.Instance.ExecuteNoQuery(_Loginer.DBName, sp.SqlCommand); return(ConvertEx.ToInt(o) != 0); }
/// <summary> /// 获取当前用户的系统权限 /// </summary> /// <param name="user">当前用户</param> /// <returns></returns> public DataTable GetUserAuthorities(Loginer user) { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_MyGetAuthorities"); sp.AddParam("@UserOrGroup", SqlDbType.VarChar, user.Account); sp.AddParam("@Type", SqlDbType.Int, 1); DataTable dt = DataProvider.Instance.GetTable(user.DBName, sp.SqlCommand, TUserRole.__TableName); return(dt); }
/// <summary> /// 获取窗体的可用权限值 /// </summary> /// <param name="account">登录帐号</param> /// <param name="moduleID">模块编号</param> /// <param name="menuName">菜单名称</param> /// <returns></returns> public int GetFormAuthority(string account, int moduleID, string menuName) { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_GetFormAuthority"); sp.AddParam("@account", SqlDbType.VarChar, account); sp.AddParam("@moduleID", SqlDbType.Int, moduleID); sp.AddParam("@menuName", SqlDbType.VarChar, menuName); object o = DataProvider.Instance.ExecuteScalar(_Loginer.DBName, sp.SqlCommand); return(ConvertEx.ToInt(o)); }
/// <summary> /// 获取用户组的权限信息,包括组的用户,组的权限 /// </summary> /// <param name="groupCode">用户组编号</param> /// <returns></returns> public DataSet GetUserGroup(string groupCode) { SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_MyGetGroupData"); sp.AddParam("@GroupCode", SqlDbType.VarChar, groupCode); DataSet ds = DataProvider.Instance.GetDataSet(_Loginer.DBName, sp.SqlCommand); ds.Tables[BusinessDataSetIndex.Groups].TableName = TUserGroup.__TableName; ds.Tables[BusinessDataSetIndex.GroupUsers].TableName = TUserGroupRe.__TableName; ds.Tables[BusinessDataSetIndex.GroupAuthorities].TableName = TUserRole.__TableName; ds.Tables[BusinessDataSetIndex.GroupAvailableUser].TableName = "GroupAvailableUser"; return(ds); }