control_db.h

LINUX下POS收银系统,可以对货物及工作人员进行管理.近本实现增删改查的功能

#ifndef _CONTROL_DB_H
#define _CONTROL_DB_H
#include <stdio.h>
#include <string.h>
#include <malloc.h>
#include "link.h"


typedef struct employee
{
	char emp_id[7];
	char emp_name[16];
	char emp_passwd[17];
	int emp_style;
	int delete_sign;
	char remark[31];
}EMP;

typedef struct commodity
{
	int num;
	char bar_code[9];
	char commodity_name[31];
	char unti[17];
	char spec[17];
	float sell_price;
	float stock_price;
	int stock_number;
	float agio;
	int delete_sign;
}GOODS;

typedef struct under_sell
{
	int num;
	char bar_code[9];
	char commodity_name[31];
	char unti[17];
	char spec[17];
	float sell_price;
	int total_count;
	float total_pay;
}UNS;


typedef struct sell_list
{
	int sell_ID;
    char employee_ID[7];
    char list_num[19];
    char sell_date[15];
    float payment_money;
    float must_pay_money;
    float fact_money;
    float give_change;
	int sell_fettle;
}SELL_LIST;

typedef struct sell_goods_list
{
	int sell_list_id;
    char bar_code[9];
	int sell_ID;
    int total_count;
	float sell_price;

}SELL_GOODS_LIST;

void sql_error();
void del_blank(char *str);
char *find_first_not_of(char *str,char ch);
char *find_last_not_of(char *str,char ch);
void connect_db(char *name,char *pass);
void insert_db(EMP emp);
int select_db_goods(char *str);
NODE * select_all_goods(LINK *link,char *str,int count);
int cmp_tow_uns(NODE *node,char *key);
int copy_str(char *source_str,char *aim_str,int num,int start_space);

void updata_goods_from_link(LINK *link,char *str,int count);
void get_business_number(char *number);

int login(char *id,char *password,EMP *emp);
int land(EMP *e);
void quit_db();
NODE *  subm_bar(LINK *link,char *str,int count);
int  isdigital(char *str);
int jiemian(EMP *e);
void manage(EMP *e);
int get_sell_id();
int insert_sell_list(SELL_LIST *s);
int get_tuihuo_id();
int get_putong_id();
int get_sell_list_id();

int select_user(EMP *e,char *str);

void update_user_table(EMP *e);
void del_user(EMP *e);
int select_exist_goods(char *str,GOODS *g);
int get_goods_code();
void update_goods_table(GOODS *g);

int select_note_by_date(char *date_s,char *date_e,LINK *note);
int select_note_by_user_id(char *userID,LINK *note);
int select_sell_list_by_ID(SELL_GOODS_LIST *s,char *str,LINK *note);
void insert_sell_goods_list(SELL_GOODS_LIST *sgl);
void del_sell_list_by_sell_id(int sell_id);
void del_sell_list_by_bar_code(char *bar_code);
int read_config_file();
void del_table_sq_constraint();
#endif /*_CONTROL_DB_H*/