sale.rc

基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码

                    WS_VSCROLL | WS_TABSTOP
    LTEXT           "合同号",IDC_STATIC,151,49,34,11
    GROUPBOX        "",IDC_STATIC,7,1,414,33
    CONTROL         "DateTimePicker1",IDC_formDate,"SysDateTimePick32",
                    DTS_RIGHTALIGN | WS_TABSTOP,188,119,85,14
    EDITTEXT        IDC_companyContractPerson,59,65,76,12,ES_AUTOHSCROLL
    EDITTEXT        IDC_clientContractPerson,327,66,82,12,ES_AUTOHSCROLL
    LTEXT           "订单号",IDC_STATIC,286,51,30,11
    EDITTEXT        IDC_orderFormID,327,49,82,13,ES_AUTOHSCROLL
END

IDD_CONSIGNMENTINVOICE_DIALOG DIALOG DISCARDABLE  0, 0, 414, 311
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "发货单"
FONT 8, "MS Sans Serif"
BEGIN
    PUSHBUTTON      "首张",IDC_firstPage,10,10,28,17
    PUSHBUTTON      "上张",IDC_prevPage,39,10,28,17
    PUSHBUTTON      "下张",IDC_nextPage,68,10,28,17
    PUSHBUTTON      "末张",IDC_lastPage,97,10,28,17
    PUSHBUTTON      "新单",IDC_new,132,10,28,17
    PUSHBUTTON      "修改",IDC_modify,161,10,28,17
    PUSHBUTTON      "删除",IDC_delete,190,10,28,17
    PUSHBUTTON      "增行",IDC_addLine,224,10,28,17
    PUSHBUTTON      "删行",IDC_deleteLine,252,10,28,17
    PUSHBUTTON      "存盘",IDC_save,286,10,28,17
    PUSHBUTTON      "作废",IDC_cancellation,314,10,28,17
    PUSHBUTTON      "关闭",IDC_exit,374,10,28,17
    LTEXT           "发货单号",IDC_STATIC,18,45,34,11
    LTEXT           "制单日期",IDC_STATIC,272,45,36,11
    EDITTEXT        IDC_consignmentFormID,60,42,91,14,ES_AUTOHSCROLL
    LTEXT           "销售类型",IDC_STATIC,273,79,32,12
    LTEXT           "运输方式",IDC_STATIC,17,63,33,12
    COMBOBOX        IDC_saleType,310,77,76,50,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_transportType,59,61,76,58,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    LTEXT           "付款条件",IDC_STATIC,17,81,36,12
    LTEXT           "销售员",IDC_STATIC,150,79,28,9
    COMBOBOX        IDC_seller,188,76,76,48,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    LTEXT           "部门",IDC_STATIC,18,98,20,9
    COMBOBOX        IDC_department,59,93,76,47,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    LTEXT           "发货地址",IDC_STATIC,149,96,36,12
    EDITTEXT        IDC_remark,58,110,333,15,ES_AUTOHSCROLL
    LTEXT           "备注",IDC_STATIC,17,113,28,13
    GROUPBOX        "",IDC_STATIC,7,30,399,104
    CONTROL         "List1",IDC_LIST1,"SysListView32",LVS_REPORT | WS_BORDER | 
                    WS_TABSTOP,7,137,400,143
    LTEXT           "审核：",IDC_STATIC,156,290,86,12
    LTEXT           "制单：",IDC_STATIC,297,289,106,18
    PUSHBUTTON      "审核",IDC_auditing,346,10,28,17
    LTEXT           "承运单位",IDC_STATIC,149,62,32,11
    LTEXT           "客户",IDC_STATIC,273,61,29,11
    COMBOBOX        IDC_transportCompany,188,59,76,40,CBS_DROPDOWN | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_payCondition,59,76,76,48,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    EDITTEXT        IDC_consignmentAddress,188,93,78,14,ES_AUTOHSCROLL
    COMBOBOX        IDC_clientName,310,60,76,45,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_orderFormID,187,42,76,43,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    LTEXT           "订单号",IDC_STATIC,149,44,34,11
    LTEXT           "仓库",IDC_STATIC,273,95,34,14
    CONTROL         "DateTimePicker1",IDC_formDate,"SysDateTimePick32",
                    DTS_RIGHTALIGN | WS_TABSTOP,310,41,74,14
    COMBOBOX        IDC_storeHouse,310,92,76,54,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    GROUPBOX        "",IDC_STATIC,7,1,400,30
END

IDD_DEPARTMENTSALEPLAN_DIALOG DIALOG DISCARDABLE  0, 0, 419, 266
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "部门销售计划单"
FONT 8, "MS Sans Serif"
BEGIN
    LTEXT           "计划单号",IDC_STATIC,17,50,34,12
    LTEXT           "制单日期",IDC_STATIC,236,50,34,12
    LTEXT           "计划年度",IDC_STATIC,124,50,32,11
    LTEXT           "备注",IDC_STATIC,17,72,28,12
    EDITTEXT        IDC_planID,56,48,58,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_formDate,278,47,110,13,ES_AUTOHSCROLL
    EDITTEXT        IDC_planYear,164,48,58,12,ES_AUTOHSCROLL
    EDITTEXT        IDC_remark,56,69,332,13,ES_AUTOHSCROLL
    CONTROL         "List1",IDC_LIST1,"SysListView32",LVS_REPORT | WS_BORDER | 
                    WS_TABSTOP,7,100,400,152
    PUSHBUTTON      "首张",IDC_firstPage,11,12,28,17
    PUSHBUTTON      "上张",IDC_prevPage,40,12,28,17
    PUSHBUTTON      "下张",IDC_nextPage,69,12,28,17
    PUSHBUTTON      "末张",IDC_lastPage,98,12,28,17
    PUSHBUTTON      "新单",IDC_new,133,12,28,17
    PUSHBUTTON      "修改",IDC_modify,162,12,28,17
    PUSHBUTTON      "删除",IDC_delete,191,12,28,17
    PUSHBUTTON      "增行",IDC_addLine,225,12,28,17
    PUSHBUTTON      "删行",IDC_deleteLine,254,12,28,17
    PUSHBUTTON      "存盘",IDC_save,289,12,28,17
    PUSHBUTTON      "作废",IDC_cancellation,318,12,28,17
    PUSHBUTTON      "关闭",IDC_exit,378,12,28,17
    PUSHBUTTON      "审核",IDC_auditing,351,12,28,17
    GROUPBOX        "",IDC_STATIC,7,37,389,53
    GROUPBOX        "",IDC_STATIC,7,3,406,32
END

IDD_STAFFSALEPLAN_DIALOG DIALOG DISCARDABLE  0, 0, 420, 263
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "销售员销售计划"
FONT 8, "MS Sans Serif"
BEGIN
    LTEXT           "计划单号",IDC_STATIC,17,50,34,12
    LTEXT           "制单日期",IDC_STATIC,236,50,34,12
    LTEXT           "计划年度",IDC_STATIC,124,50,32,11
    LTEXT           "备注",IDC_STATIC,17,72,34,12
    EDITTEXT        IDC_planID,56,48,58,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_formDate,278,47,110,13,ES_AUTOHSCROLL
    EDITTEXT        IDC_planYear,164,48,58,12,ES_AUTOHSCROLL
    EDITTEXT        IDC_remark,57,69,331,13,ES_AUTOHSCROLL
    CONTROL         "List1",IDC_LIST1,"SysListView32",LVS_REPORT | WS_BORDER | 
                    WS_TABSTOP,7,100,400,152
    PUSHBUTTON      "首张",IDC_firstPage,11,12,28,17
    PUSHBUTTON      "上张",IDC_prevPage,40,12,28,17
    PUSHBUTTON      "下张",IDC_nextPage,69,12,28,17
    PUSHBUTTON      "末张",IDC_lastPage,98,12,28,17
    PUSHBUTTON      "新单",IDC_new,133,12,28,17
    PUSHBUTTON      "修改",IDC_modify,162,12,28,17
    PUSHBUTTON      "删除",IDC_delete,191,12,28,17
    PUSHBUTTON      "增行",IDC_addLine,225,12,28,17
    PUSHBUTTON      "删行",IDC_deleteLine,254,12,28,17
    PUSHBUTTON      "存盘",IDC_save,289,12,28,17
    PUSHBUTTON      "作废",IDC_cancellation,318,12,28,17
    PUSHBUTTON      "关闭",IDC_exit,378,12,28,17
    PUSHBUTTON      "审核",IDC_auditing,351,12,28,17
    GROUPBOX        "",IDC_STATIC,7,37,389,53
    GROUPBOX        "",IDC_STATIC,7,3,406,32
END

IDD_CLIENTSALEPLAN_FORM DIALOG DISCARDABLE  0, 0, 320, 200
STYLE WS_CHILD
FONT 8, "MS Sans Serif"
BEGIN
    LTEXT           "TODO: layout formview",IDC_STATIC,55,42,74,8
END

IDD_CLIENTSSALEPLAN_DIALOG DIALOG DISCARDABLE  0, 0, 420, 265
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "客户销售计划"
FONT 8, "MS Sans Serif"
BEGIN
    LTEXT           "计划单号",IDC_STATIC,17,50,34,12
    LTEXT           "制单日期",IDC_STATIC,236,50,34,12
    LTEXT           "计划年度",IDC_STATIC,124,50,32,11
    LTEXT           "备注",IDC_STATIC,17,73,34,12
    EDITTEXT        IDC_planID,56,48,58,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_formDate,278,47,110,13,ES_AUTOHSCROLL
    EDITTEXT        IDC_planYear,164,48,58,12,ES_AUTOHSCROLL
    EDITTEXT        IDC_remark,56,69,332,13,ES_AUTOHSCROLL
    CONTROL         "List1",IDC_LIST1,"SysListView32",LVS_REPORT | WS_BORDER | 
                    WS_TABSTOP,7,100,400,152
    PUSHBUTTON      "首张",IDC_firstPage,11,12,28,17
    PUSHBUTTON      "上张",IDC_prevPage,40,12,28,17
    PUSHBUTTON      "下张",IDC_nextPage,69,12,28,17
    PUSHBUTTON      "末张",IDC_lastPage,98,12,28,17
    PUSHBUTTON      "新单",IDC_new,133,12,28,17
    PUSHBUTTON      "修改",IDC_modify,162,12,28,17
    PUSHBUTTON      "删除",IDC_delete,191,12,28,17
    PUSHBUTTON      "增行",IDC_addLine,225,12,28,17
    PUSHBUTTON      "删行",IDC_deleteLine,254,12,28,17
    PUSHBUTTON      "存盘",IDC_save,289,12,28,17
    PUSHBUTTON      "作废",IDC_cancellation,318,12,28,17
    PUSHBUTTON      "关闭",IDC_exit,378,12,28,17
    PUSHBUTTON      "审核",IDC_auditing,351,12,28,17
    GROUPBOX        "",IDC_STATIC,7,37,389,53
    GROUPBOX        "",IDC_STATIC,7,3,406,32
END

IDD_PRODUCTSALEPLAN_DIALOG DIALOG DISCARDABLE  0, 0, 420, 265
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "产品销售计划"
FONT 8, "MS Sans Serif"
BEGIN
    LTEXT           "计划单号",IDC_STATIC,17,50,34,12
    LTEXT           "制单日期",IDC_STATIC,236,50,34,12
    LTEXT           "计划年度",IDC_STATIC,124,50,32,11
    LTEXT           "备注",IDC_STATIC,18,73,34,12
    EDITTEXT        IDC_planFormID,56,48,58,14,ES_AUTOHSCROLL
    EDITTEXT        IDC_formDate,278,47,110,13,ES_AUTOHSCROLL
    EDITTEXT        IDC_planYear,164,48,58,12,ES_AUTOHSCROLL
    EDITTEXT        IDC_remark,56,69,335,13,ES_AUTOHSCROLL
    CONTROL         "List1",IDC_LIST1,"SysListView32",LVS_REPORT | WS_BORDER | 
                    WS_TABSTOP,7,100,400,152
    PUSHBUTTON      "首张",IDC_firstPage,11,12,28,17
    PUSHBUTTON      "上张",IDC_prevPage,40,12,28,17
    PUSHBUTTON      "下张",IDC_nextPage,69,12,28,17
    PUSHBUTTON      "末张",IDC_lastPage,98,12,28,17
    PUSHBUTTON      "新单",IDC_new,133,12,28,17
    PUSHBUTTON      "修改",IDC_modify,162,12,28,17
    PUSHBUTTON      "删除",IDC_delete,191,12,28,17
    PUSHBUTTON      "增行",IDC_addLine,225,12,28,17
    PUSHBUTTON      "删行",IDC_deleteLine,254,12,28,17
    PUSHBUTTON      "存盘",IDC_save,289,12,28,17
    PUSHBUTTON      "作废",IDC_cancellation,318,12,28,17
    PUSHBUTTON      "关闭",IDC_exit,378,12,28,17
    PUSHBUTTON      "审核",IDC_auditing,351,12,28,17
    GROUPBOX        "",IDC_STATIC,7,37,389,53
    GROUPBOX        "",IDC_STATIC,7,3,406,32
END

IDD_SEARCHCONDITION_DIALOG DIALOG DISCARDABLE  0, 0, 243, 190
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "查询条件"
FONT 8, "MS Sans Serif"
BEGIN
    LTEXT           "制单日期",IDC_STATIC,15,22,35,11
    LTEXT           "报价单号",IDC_STATIC,15,44,35,11
    LTEXT           "客户名称",IDC_STATIC,16,63,35,11
    LTEXT           "部门名称",IDC_STATIC,15,84,35,11
    LTEXT           "运输方式",IDC_STATIC,16,105,35,11
    LTEXT           "销售员",IDC_STATIC,16,126,35,11
    LTEXT           "至",IDC_STATIC,128,23,11,12
    COMBOBOX        IDC_quoteID,56,42,157,44,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_seller,55,122,159,61,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_clientName,56,63,157,45,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_transportType,55,100,158,48,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_department,55,83,157,48,CBS_DROPDOWN | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    PUSHBUTTON      "确定",IDC_BUTTON1,47,156,62,16
    PUSHBUTTON      "取消",IDC_BUTTON2,131,156,62,16
    CONTROL         "DateTimePicker1",IDC_formDateBegin,"SysDateTimePick32",
                    DTS_RIGHTALIGN | WS_TABSTOP,55,20,66,13
    CONTROL         "DateTimePicker1",IDC_formDateEnd,"SysDateTimePick32",
                    DTS_RIGHTALIGN | WS_TABSTOP,145,20,69,13
END

IDD_BACKMONEYTYPE_DIALOG DIALOG DISCARDABLE  0, 0, 331, 280
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "回款类型"
FONT 8, "MS Sans Serif"
BEGIN
    PUSHBUTTON      "增加",IDC_BUTTON2,15,22,53,17
    PUSHBUTTON      "删除",IDC_BUTTON3,74,22,53,17
    PUSHBUTTON      "修改",IDC_BUTTON4,133,22,53,17
    PUSHBUTTON      "存盘",IDC_BUTTON5,193,22,53,17
    PUSHBUTTON      "关闭",IDC_BUTTON6,255,22,53,17
    GROUPBOX        "",IDC_STATIC,6,9,313,39
    LTEXT           "编码",IDC_STATIC,19,64,21,14
    LTEXT           "回款类型名称",IDC_STATIC,164,64,50,14
    EDITTEXT        IDC_EDIT2,43,61,93,17,ES_AUTOHSCROLL
    EDITTEXT        IDC_EDIT3,219,61,95,17,ES_AUTOHSCROLL
    GROUPBOX        "",IDC_STATIC,6,48,313,63
    CONTROL         "List1",IDC_LIST1,"SysListView32",LVS_REPORT | WS_BORDER | 
                    WS_TABSTOP,6,118,313,148
    LTEXT           "备注",IDC_STATIC,19,89,21,14
    EDITTEXT        IDC_EDIT4,43,86,272,17,ES_AUTOHSCROLL
END

IDD_COMMODITYTYPE_DIALOG DIALOG DISCARDABLE  0, 0, 330, 220
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "商品类别"
FONT 8, "MS Sans Serif"
BEGIN
    PUSHBUTTON      "增加",IDC_add,15,16,53,17
    PUSHBUTTON      "删除",IDC_delete,74,16,53,17
    PUSHBUTTON      "修改",IDC_modify,133,16,53,17