4S店汽车销售及服务管理系统的设计与实现毕业论文

{

SqlDataBase MyDB = new SqlDataBase();//调用SqlDataBase类

int CheckNum = Convert.ToInt32(MyDB.ReturnSQL(\count(*) from UserList where UserName = '\+ UserNam + \PassWord = '\

if (CheckNum > 0) {

MyDB.NoreturnSql(\NewPwd + \

return true; } else {

return false; } }

public bool UserAdd(string UserNam , string Pwd ,string AlignK , string Types)

{

SqlDataBase MyDB = new SqlDataBase();

int CheckNum = Convert.ToInt32(MyDB.ReturnSQL(\count(*) from UserList where UserName = '\

if (CheckNum > 0) {

return false; } else {

19

MyDB.NoreturnSql(\into UserList(UserName , PassWord , Controls , GoodsType) values('\\

return true; } }

public DataTable GiveSysC()//返回通知列表 {

SqlDataBase MyDb = new SqlDataBase();

return MyDb.DT(\= 0 order By ID desc\

}

public DataTable GiveSysX(string ID) {

SqlDataBase MyDb = new SqlDataBase();

return MyDb.DT(\ID + \

}

public static DataTable GetBigClass() //返回产品大类 {

SqlDataBase MyDb = new SqlDataBase(); return MyDb.DT(\ }

public static DataTable GetSmaGoods(string ID)//返回大类所属的产品列表

{

SqlDataBase MyDb = new SqlDataBase();

return MyDb.DT(\AllGood where AlignType = '\

20

}

#region //产品入库

public int InsertGoods(int AlignGoods, string GoodCost, int GoodNum, string GoodMake, string GoodsBZ, string InputTime)

{

SqlParameter[] prams = {

IntParam(\ IntParam(\SqlDbType.VarChar, 50, GoodCost), IntParam(\ IntParam(\IntParam(\

IntParam(\ OutParam(\ };

RunInsert(\ return Convert.ToInt32(prams[6].Value); //return Convert.ToInt32(prams[0].Value); }

#endregion

public static void UpdateBigGodNum(int Num,int GodID) //入库产品大类数量更新

{

SqlDataBase MyDb = new SqlDataBase();

MyDb.NoreturnSql(\AllGood set NowNum = NowNum + \+ Num + \

//return \+ \

}

public static void OutPut(int Num, int GodID) //出库产品大

21

类数量更新

{

SqlDataBase MyDb = new SqlDataBase();

MyDb.NoreturnSql(\AllGood set NowNum = NowNum - \+ Num + \

}

public static void InsertGodPaper(int GodsID ,int GodsNum , string GetUser,string InputUser,string InputTime,string PaperType)

{//单据表

SqlDataBase MyDb = new SqlDataBase();

MyDb.NoreturnSql(\Into GoodPapers(GoodsID , GoodsNum , GetUser , InputUser , GetTime , PaperType)Values('\GodsID + \+ GodsNum + \+ GetUser + \+ InputUser + \+ InputTime + \

}

public static void InsertRecordList(string InputUser, int GodsID, int GodsNum, string PaperType, string InputTime)

{//操作日志表

SqlDataBase MyDb = new SqlDataBase();

MyDb.NoreturnSql(\Into RecordList(UserName , GoodID , GoodNum , TypesID , RecordTime ) Values('\+ InputUser + \+ GodsID + \\

}

public static int GetBigGID(int GoodsID)//返回仓库产品所对应的大类产品ID

{

SqlDataBase MyDb = new SqlDataBase();

Return Convert . ToInt32( MyDb . ReturnSQL ( \

22