⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 dbmanager.rc

📁 利用OLEDB以数据库的方式打开Excell文件
💻 RC
📖 第 1 页 / 共 2 页
字号:
//Microsoft Developer Studio generated resource script.
//
#include "resource.h"

#define APSTUDIO_READONLY_SYMBOLS
/////////////////////////////////////////////////////////////////////////////
//
// Generated from the TEXTINCLUDE 2 resource.
//
#include "afxres.h"

/////////////////////////////////////////////////////////////////////////////
#undef APSTUDIO_READONLY_SYMBOLS

/////////////////////////////////////////////////////////////////////////////
// Chinese (P.R.C.) resources

#if !defined(AFX_RESOURCE_DLL) || defined(AFX_TARG_CHS)
#ifdef _WIN32
LANGUAGE LANG_CHINESE, SUBLANG_CHINESE_SIMPLIFIED
#pragma code_page(936)
#endif //_WIN32

#ifdef APSTUDIO_INVOKED
/////////////////////////////////////////////////////////////////////////////
//
// TEXTINCLUDE
//

1 TEXTINCLUDE DISCARDABLE 
BEGIN
    "resource.h\0"
END

2 TEXTINCLUDE DISCARDABLE 
BEGIN
    "#include ""afxres.h""\r\n"
    "\0"
END

3 TEXTINCLUDE DISCARDABLE 
BEGIN
    "#define _AFX_NO_SPLITTER_RESOURCES\r\n"
    "#define _AFX_NO_OLE_RESOURCES\r\n"
    "#define _AFX_NO_TRACKER_RESOURCES\r\n"
    "#define _AFX_NO_PROPERTY_RESOURCES\r\n"
    "\r\n"
    "#if !defined(AFX_RESOURCE_DLL) || defined(AFX_TARG_CHS)\r\n"
    "#ifdef _WIN32\r\n"
    "LANGUAGE 4, 2\r\n"
    "#pragma code_page(936)\r\n"
    "#endif //_WIN32\r\n"
    "#include ""res\\DBManager.rc2""  // non-Microsoft Visual C++ edited resources\r\n"
    "#include ""l.chs\\afxres.rc""          // Standard components\r\n"
    "#endif\r\n"
    "\0"
END

#endif    // APSTUDIO_INVOKED


/////////////////////////////////////////////////////////////////////////////
//
// Icon
//

// Icon with lowest ID value placed first to ensure application icon
// remains consistent on all systems.
IDR_MAINFRAME           ICON    DISCARDABLE     "res\\DBManager.ico"

/////////////////////////////////////////////////////////////////////////////
//
// Dialog
//

IDD_ABOUTBOX DIALOG DISCARDABLE  0, 0, 235, 55
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "关于 DBManager"
FONT 9, "宋体"
BEGIN
    ICON            IDR_MAINFRAME,IDC_STATIC,11,17,20,20
    LTEXT           "CDMA 手机收费管理系统   1.0 测试版",IDC_STATIC,37,11,
                    138,8,SS_NOPREFIX
    LTEXT           "版权所有 (C) 2003  北京正有网络通信技术股份有限公司  系统集成部",
                    IDC_STATIC,38,25,128,23
    DEFPUSHBUTTON   "确定",IDOK,178,7,50,14,WS_GROUP
END

IDD_DBMANAGER_DIALOG DIALOGEX 0, 0, 463, 379
STYLE DS_MODALFRAME | WS_MINIMIZEBOX | WS_POPUP | WS_VISIBLE | WS_CAPTION | 
    WS_SYSMENU
EXSTYLE WS_EX_APPWINDOW
CAPTION "CDMA手机收费管理系统-----系统集成部制作"
FONT 9, "宋体"
BEGIN
    PUSHBUTTON      "打开配置文件",IDC_OPEN_CONFIG,253,207,63,17,NOT 
                    WS_VISIBLE | WS_DISABLED
    PUSHBUTTON      "打开数据库",IDC_OPEN_DB,22,27,56,31
    LISTBOX         IDC_LIST_DB,87,27,136,32,LBS_SORT | LBS_NOINTEGRALHEIGHT | 
                    WS_VSCROLL | WS_HSCROLL | WS_TABSTOP
    CONTROL         "",IDC_RSGRIDCTRL_VIEW,
                    "{314D6246-9F2F-11D2-88D1-00805FB6680E}",WS_TABSTOP,22,
                    228,65,64
    EDITTEXT        IDC_EDIT_SQL,231,208,122,12,ES_MULTILINE | NOT 
                    WS_VISIBLE | WS_DISABLED | WS_VSCROLL
    CONTROL         "",IDC_RSGRIDCTRL_RESULT,
                    "{314D6246-9F2F-11D2-88D1-00805FB6680E}",WS_TABSTOP,21,
                    79,416,113
    PUSHBUTTON      "保存成数据文件",IDC_EXECUTE,245,214,95,6,NOT WS_VISIBLE | 
                    WS_DISABLED
    PUSHBUTTON      "关   闭",IDCANCEL,290,324,146,42
    PUSHBUTTON      "查询",IDOK,24,354,115,14
    PUSHBUTTON      "∧",IDC_BUT_VIEW1,277,212,26,6,NOT WS_VISIBLE | 
                    WS_DISABLED
    PUSHBUTTON      "↑",IDC_BUT_VIEW2,283,212,26,6,NOT WS_VISIBLE | 
                    WS_DISABLED
    PUSHBUTTON      "↓",IDC_BUT_VIEW3,271,213,26,6,NOT WS_VISIBLE | 
                    WS_DISABLED
    PUSHBUTTON      "∨",IDC_BUT_VIEW4,286,213,26,6,NOT WS_VISIBLE | 
                    WS_DISABLED
    LISTBOX         IDC_LIST1,261,210,48,9,LBS_SORT | LBS_NOINTEGRALHEIGHT | 
                    NOT WS_VISIBLE | WS_DISABLED | WS_VSCROLL | WS_TABSTOP
    LISTBOX         IDC_LIST2,275,211,48,9,LBS_SORT | LBS_NOINTEGRALHEIGHT | 
                    NOT WS_VISIBLE | WS_DISABLED | WS_VSCROLL | WS_TABSTOP
    LISTBOX         IDC_LIST3,245,210,78,9,LBS_SORT | LBS_NOINTEGRALHEIGHT | 
                    NOT WS_VISIBLE | WS_DISABLED | WS_VSCROLL | WS_TABSTOP
    EDITTEXT        IDC_PHONE_NUM,60,324,57,12,ES_AUTOHSCROLL
    LTEXT           "总表字段名",IDC_STATIC,22,214,41,8
    LTEXT           "临时表 字段名",IDC_STATIC,113,214,53,8
    LTEXT           "对应于",IDC_STATIC,89,248,25,8
    CONTROL         "",IDC_RSGRIDCTRL_VIEW2,
                    "{314D6246-9F2F-11D2-88D1-00805FB6680E}",WS_TABSTOP,115,
                    227,63,64
    PUSHBUTTON      "添加 ->",IDC_ADDTOLIST,182,243,31,19
    CONTROL         "List4",IDC_LIST_Correspond,"SysListView32",LVS_REPORT | 
                    WS_BORDER | WS_TABSTOP,216,225,220,64
    PUSHBUTTON      "删除",IDC_BUTTON1,216,293,112,14
    PUSHBUTTON      "临时表有用数据导入总表",IDC_TempToWhole,22,293,99,14
    PUSHBUTTON      "系统使用说明",IDC_BUTTON_HELP,361,27,76,32
    LISTBOX         IDC_LIST_DB2,227,27,132,32,LBS_SORT | 
                    LBS_NOINTEGRALHEIGHT | WS_VSCROLL | WS_HSCROLL | 
                    WS_TABSTOP
    PUSHBUTTON      "删除所有",IDC_BUTTON2,329,293,106,14
    LTEXT           "选择主表",IDC_STATIC,89,16,33,8
    LTEXT           "选择从表(有用数据所在表)",IDC_STATIC,227,17,97,8
    GROUPBOX        "打开EXCEL",IDC_STATIC,18,4,424,60
    GROUPBOX        "数据显示",IDC_STATIC,18,68,424,129
    GROUPBOX        "数据导入",IDC_STATIC,18,200,424,109
    GROUPBOX        "数据查询",IDC_STATIC,17,313,424,58
    LTEXT           "手机号:",IDC_STATIC,24,326,29,8
    LTEXT           "用户名:",IDC_STATIC,24,340,29,8
    EDITTEXT        IDC_PHONE_USER_NAME,60,338,58,12,ES_AUTOHSCROLL
    LTEXT           "担保公司:",IDC_STATIC,125,327,37,8
    COMBOBOX        IDC_COMBO_ASSURE_COMPANY,163,323,115,71,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    LTEXT           "费    用:",IDC_STATIC,241,210,37,8,NOT WS_VISIBLE
    COMBOBOX        IDC_FEIYONG,303,207,16,84,CBS_DROPDOWN | CBS_SORT | NOT 
                    WS_VISIBLE | WS_DISABLED | WS_VSCROLL | WS_TABSTOP
    PUSHBUTTON      "复合查询",IDC_BUTTON_QUERY,163,354,116,14
    PUSHBUTTON      "更新总表各项总计",IDC_UPDATETOTAL,130,294,67,14
END

IDD_DIALOG1 DIALOG DISCARDABLE  0, 0, 439, 335
STYLE DS_MODALFRAME | WS_MINIMIZEBOX | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "编辑数据"
FONT 9, "宋体"
BEGIN
    DEFPUSHBUTTON   "保存",IDOK,204,314,50,14
    PUSHBUTTON      "取消",IDCANCEL,298,314,50,14
    LTEXT           "序号",IDC_STATIC,45,20,17,8
    LTEXT           "UIM卡号",IDC_STATIC,45,47,29,8
    LTEXT           "手机品牌",IDC_STATIC,45,74,33,8
    LTEXT           "CDMA手机型号",IDC_STATIC,45,101,49,8
    LTEXT           "月最低消费标准(元/月)",IDC_STATIC,45,128,85,8
    LTEXT           "用户姓名",IDC_STATIC,45,155,33,8
    LTEXT           "担保公司",IDC_STATIC,249,90,33,8
    LTEXT           "合同编号",IDC_STATIC,249,114,33,8
    LTEXT           "联系人",IDC_STATIC,249,137,25,8
    LTEXT           "身份证号码",IDC_STATIC,45,182,41,8
    LTEXT           "付费方式",IDC_STATIC,249,18,33,8
    LTEXT           "领机日期",IDC_STATIC,249,41,33,8
    LTEXT           "机号",IDC_STATIC,249,67,17,8
    EDITTEXT        IDC_ID,135,17,103,14,ES_AUTOHSCROLL | WS_DISABLED
    EDITTEXT        IDC_UIM,135,44,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_TYPE,135,71,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_CDMA_TYPE,135,98,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_LOWEST,135,125,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_NAME,135,152,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_PERSON_ID,135,179,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_GIVEMONEY,312,15,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_GETPHONE,312,39,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_PHONE_ID,312,63,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY,312,87,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_CONTRACT_ID,312,111,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_PERSON,312,135,103,14,ES_AUTOHSCROLL
    LTEXT           "入网佣金",IDC_STATIC,249,156,33,8
    LTEXT           "在网三个月佣金",IDC_STATIC,248,179,57,8
    LTEXT           "在网六个月佣金",IDC_STATIC,45,203,57,8
    EDITTEXT        IDC_MONEY,312,156,104,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_THREE,312,176,104,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_SIX,135,201,103,14,ES_AUTOHSCROLL
    LTEXT           "佣金分成",IDC_STATIC,249,223,33,8
    COMBOBOX        IDC_DATATIME,312,219,104,113,CBS_DROPDOWNLIST | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    PUSHBUTTON      "修改",ID_XIUGAI,102,314,50,14
    PUSHBUTTON      "删除",ID_DELETE,153,314,50,14,NOT WS_VISIBLE | 
                    WS_DISABLED
    LTEXT           "使用费",IDC_STATIC,45,239,25,8
    LTEXT           "欠费",IDC_STATIC,250,259,17,8
    COMBOBOX        IDC_USE_MONEY,135,238,104,100,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_QIANFEI,312,255,104,129,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    EDITTEXT        IDC_USE_MONEY1,135,255,104,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_YONGJIN1,312,237,104,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_QIANFEI1,312,272,104,14,ES_AUTOHSCROLL
    LTEXT           "六个月佣金说明",IDC_STATIC,45,221,57,8
    LTEXT           "三个月佣金说明",IDC_STATIC,248,205,57,8
    EDITTEXT        IDC_SIX_SHUOMING,135,219,103,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_THREE_SHUOMING,311,201,103,14,ES_AUTOHSCROLL
END

IDD_DIALOG2 DIALOG DISCARDABLE  0, 0, 282, 197
STYLE DS_MODALFRAME | WS_MINIMIZEBOX | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "公司情况"
FONT 9, "宋体"
BEGIN
    DEFPUSHBUTTON   "修改",IDOK,83,176,50,14
    PUSHBUTTON      "取消",IDCANCEL,149,176,50,14
    LTEXT           "单位名称",IDC_STATIC,10,42,33,8
    LTEXT           "负责人",IDC_STATIC,10,84,25,8
    LTEXT           "联系电话",IDC_STATIC,10,103,33,8
    LTEXT           "地址",IDC_STATIC,10,119,17,8
    LTEXT           "注册资本",IDC_STATIC,10,160,33,8
    LTEXT           "法定代表人",IDC_STATIC,10,137,41,8
    LTEXT           "手机总数",IDC_STATIC,10,64,33,8
    LTEXT           "营业期限",IDC_STATIC,138,64,33,8
    LTEXT           "银行帐号",IDC_STATIC,138,119,33,8
    LTEXT           "注册号",IDC_STATIC,138,42,25,8
    LTEXT           "成立日期",IDC_STATIC,138,84,33,8
    LTEXT           "开户日期",IDC_STATIC,138,137,33,8
    LTEXT           "企业类型",IDC_STATIC,138,22,33,8
    LTEXT           "开户银行",IDC_STATIC,138,103,33,8
    EDITTEXT        IDC_COMPANY_NAME,53,39,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_MOBILE_NUM,53,60,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_PERSON,53,79,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_PHONE,53,97,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_ADDRESS,53,117,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_LEADER,53,136,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_MONEY,53,158,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_TYPE,177,19,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_REGISTER_ID,177,39,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_AREA,177,60,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_BEGIN_DATE,177,79,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_BANK,177,97,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_ACCOUNT,177,117,82,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_COMPANY_KAIHU_DATE,177,136,82,14,ES_AUTOHSCROLL
    LTEXT           "序号",IDC_STATIC,12,22,17,8
    EDITTEXT        IDC_COMPANY_ID,53,19,82,14,ES_AUTOHSCROLL | WS_DISABLED
END

IDD_DIALOG3 DIALOG DISCARDABLE  0, 0, 432, 359
STYLE DS_MODALFRAME | WS_MINIMIZEBOX | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "复合查询"
FONT 9, "宋体"
BEGIN
    DEFPUSHBUTTON   "OK",IDOK,123,199,6,6,NOT WS_VISIBLE | WS_DISABLED
    PUSHBUTTON      "关闭",IDCANCEL,335,325,73,20
    CONTROL         "",IDC_RSGRIDCTRL_SHOWDATA,
                    "{314D6246-9F2F-11D2-88D1-00805FB6680E}",WS_TABSTOP,16,
                    19,279,128
    GROUPBOX        "数据显示",IDC_STATIC,12,9,289,142
    GROUPBOX        "催费",IDC_STATIC,11,159,297,50
    GROUPBOX        "对帐",IDC_STATIC,7,320,301,32
    COMBOBOX        IDC_COMBO_PERSON_LIANXI,46,171,54,57,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    LTEXT           "联系人",IDC_STATIC,18,173,25,8
    LTEXT           "起始时间",IDC_STATIC,108,174,33,8
    LTEXT           "终止时间",IDC_STATIC,108,190,33,8
    COMBOBOX        IDC_COMBO_BEGINTIME,141,171,87,66,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_COMBO_ENDTIME,141,187,87,87,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    LTEXT           "金  额",IDC_STATIC,18,248,25,8
    EDITTEXT        IDC_USE_MONEY,46,245,54,14,ES_AUTOHSCROLL
    PUSHBUTTON      "欠费",IDC_BUTTON_QIANFEI,244,184,56,15
    PUSHBUTTON      "使用费",IDC_BUTTON_USE,244,240,56,15
    PUSHBUTTON      "在网三个月",IDC_BUTTON_3,19,332,69,14
    PUSHBUTTON      "在网六个月",IDC_BUTTON_6,118,332,69,14
    PUSHBUTTON      "入网佣金",IDC_BUTTON_RUWANG,217,332,69,14
    GROUPBOX        "个人使用费",IDC_STATIC,11,216,297,50
    LTEXT           "手机号",IDC_STATIC,19,230,25,8
    EDITTEXT        IDC_EDIT_MOBILENUM,46,227,54,12,ES_AUTOHSCROLL
    LTEXT           "起始时间",IDC_STATIC,108,230,33,8
    LTEXT           "终止时间",IDC_STATIC,108,246,33,8
    COMBOBOX        IDC_COMBO_BEGINTIME_USE,141,227,87,86,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_COMBO_ENDTIME_USE,141,244,87,86,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    CONTROL         "",IDC_RSGRIDCTRL_ZIDUAN,
                    "{314D6246-9F2F-11D2-88D1-00805FB6680E}",NOT WS_VISIBLE | 
                    WS_DISABLED | WS_TABSTOP,257,248,14,6
    PUSHBUTTON      "删除",IDC_BUTTON_ADD,368,221,46,14
    CONTROL         "List1",IDC_LIST_ZIDUAN,"SysListView32",LVS_REPORT | 
                    WS_BORDER | WS_TABSTOP,319,128,95,90
    PUSHBUTTON      "打印",IDC_BUTTON_PRINT,335,270,73,20
    CONTROL         "List1",IDC_LIST_ALL_ZIDUAN,"SysListView32",LVS_REPORT | 
                    WS_BORDER | WS_TABSTOP,319,13,95,98
    LTEXT           "金  额",IDC_STATIC,19,299,25,8
    EDITTEXT        IDC_COMMISION_MONEY,47,297,54,14,ES_AUTOHSCROLL
    PUSHBUTTON      "话费分成佣金",IDC_BUTTON_COMMISION,244,293,56,15
    GROUPBOX        "个人话费分成佣金",IDC_STATIC,11,267,297,50
    LTEXT           "手机号",IDC_STATIC,20,281,25,8
    EDITTEXT        IDC_EDIT_MOBILENUM2,47,279,54,12,ES_AUTOHSCROLL
    LTEXT           "起始时间",IDC_STATIC,108,281,33,8
    LTEXT           "终止时间",IDC_STATIC,108,299,33,8
    COMBOBOX        IDC_COMBO_BEGINTIME_COMMISION,141,279,87,73,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_COMBO_ENDTIME_COMMISION,141,297,87,76,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    CONTROL         "",IDC_RSGRIDCTRL_ZIDUAN2,
                    "{314D6246-9F2F-11D2-88D1-00805FB6680E}",NOT WS_VISIBLE | 
                    WS_DISABLED | WS_TABSTOP,263,300,14,6
    LTEXT           "所选的用于显示的字段:",IDC_STATIC,320,117,85,8
END

IDD_DIALOG4 DIALOG DISCARDABLE  0, 0, 187, 87
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "结果"
FONT 9, "宋体"
BEGIN
    DEFPUSHBUTTON   "确定",IDOK,35,61,50,14
    PUSHBUTTON      "取消",IDCANCEL,101,61,50,14
    LTEXT           "结果",IDC_STATIC,30,32,17,8
    EDITTEXT        IDC_EDIT_RESUALT,53,29,103,14,ES_AUTOHSCROLL
END

IDD_DIALOG5 DIALOG DISCARDABLE  0, 0, 193, 73
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "Reg"

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -