FilesExpand file tree

 master

/

GoodsAction.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

81 lines (70 loc) · 2.42 KB

 master

/

GoodsAction.java

Copy path

Top

File metadata and controls

• Code
• Blame

81 lines (70 loc) · 2.42 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

package com.webtier;

import java.util.List;

import com.dao.CarDao;

import com.dao.GoodsAndLogDao;

import com.form.GoodsForm;

import com.tools.MyPagination;

public class GoodsAction extends GoodsForm {

private static GoodsAndLogDao goodsAndLogDao = null;

private static CarDao carDao = null;

static {

goodsAndLogDao = new GoodsAndLogDao();

carDao=new CarDao();

}

public String queryGoodsId(){

GoodsForm goodsForm = goodsAndLogDao.queryGoodsForm(request.getParameter("goods_id"));

request.setAttribute("goodsForm", goodsForm);

return SUCCESS;

}

public String queryCar(){

List list = carDao.queryCarList(null);

request.setAttribute("list", list);

return SUCCESS;

}

public String insertGoods() {

String sql1 = "insert into tb_operationgoods (car_id,customer_id,goods_id,goods_name,goods_tel,goods_address,goods_sure) value ("

+ this.car_id

+ ","

+ this.customer_id

+ ",'"

+ this.goods_id

+ "','"

+ this.goods_name

+ "','"

+ this.goods_tel + "','" + this.goods_address + "',1)";

String startTime = request.getParameter("startTime");

String endTime = request.getParameter("endTime");

String describer = request.getParameter("describer");

String sql2 = "insert into tb_carlog (goods_id,car_id,startTime,endTime,describer) value ('"

+ goods_id

+ "','"

+ car_id

+ "','"

+ startTime

+ "','" + endTime + "','" + describer + "')";

this.goodsAndLogDao.operationGoodsAndLog(sql1);

this.goodsAndLogDao.operationGoodsAndLog(sql2);

request.setAttribute("goodsSuccess", "<br><br>您添加订货单成功");

return SUCCESS;

}

public String changeOperation(){

String goods_id=request.getParameter("goods_id");

String sql1="update tb_operationgoods set goods_sure=0 where goods_id='"+goods_id+"'";

String sql2="delete from tb_carlog where goods_id='"+goods_id+"'";

this.goodsAndLogDao.operationGoodsAndLog(sql1);

this.goodsAndLogDao.operationGoodsAndLog(sql2);

request.setAttribute("goods_id", goods_id);

return SUCCESS;

}

public String queryGoodsList(){

List list = goodsAndLogDao.queryGoodsList();

request.setAttribute("list", list);

return SUCCESS;

}

public String deleteGoods(){

String id=request.getParameter("id");

String sql="delete from tb_operationgoods where id='"+id+"'";

this.goodsAndLogDao.operationGoodsAndLog(sql);

return "deleteSuccess";

}

}