#ifndef ZXSHDB_H
#define ZXSHDB_H

#include <QtCore>
#include "sncdatabase_global.h"

class SNCDATABASESHARED_EXPORT ZxshDB
{
public:
    ZxshDB();
    static int addShkjZxshTask(QString ssid, QString userCode, QString province,QString city,
                               QString inserttime,QString finishtime,int updatedays,
                               QString isp,QString slttype, QString packnolist,QString seglist,
                               int neednum,int rpnum);
    static int updateZxshDealStatus(QString id,QString state);
    static QMultiMap<QString,QString> getShkjZxshTasksByUser(QString userCode, QString isdown);
    static int updateShkjZxshTaskInfos(QMultiMap<QString,QString> maps,QString userCode);
    static int updateShkjZxshSltPacknos(QMultiMap<QString,QString> maps,QString userCode);
    static int delShkjZxshTaskByID(QString ssid);
    static void updateSegRealPnum(QString upday,QString areacode,QString filename);
    static void updatePackRealPnum(QString upday,QString areacode,QString filename);
    static QStringList getShkjZxshSegRealPnum(int updatedays,QString corp,QString city);
    static QStringList getShkjZxshPackRealPnum(int updatedays,QString corp,QString city,QString usercode,QString isdown);
    static bool validatePacknoSelected(QString packno,QString usercode);
    static bool validateExistUserPackno(QString usercode);
    static bool deletePackRealPnum();
};

#endif // ZXSHDB_H