社区

京东店铺
淘宝店铺
当当店铺
拼多多店铺

APP下载

扫描下载官方APP

VIP会员

C#图书答疑

+关注

已有57人关注

+发表新帖

所属版块： C#答疑区

givemf

学分:2

+关注

私信

立即签到

版块推荐

，在C#项目开发案例全程实录（第2版）中第9章进销存系统中出现以下问题

发表在C#图书答疑 2016-10-22

是否精华是否

版块置顶: 是否

无法保存进货，提示数据库错误根据报错找到以下代码，帮看看哪里有问题呢，图片在附件里

               string str_Add = "update tb_JhGoodsInfo set ";
               str_Add += "EmpId='" + tbGood.strEmpId + "',JhCompName='" + tbGood.strJhCompName + "',";
               str_Add += "DepotName='" + tbGood.strDepotName + "',GoodsName='" + tbGood.strGoodsName + "',GoodsNum='" + tbGood.strGoodsNum + "',";
               str_Add += "GoodsUnit='" + tbGood.strGoodsUnit + "',GoodsJhPrice=" + tbGood.deGoodsJhPrice + " ,GoodsSellPrice=" + tbGood.deGoodsSellPrice + " ,";
               str_Add += "GoodsNeedPrice=" + tbGood.deGoodsNeedPrice + ",GoodsNoPrice=" + tbGood.deGoodsNoPrice + ",GoodsRemark='" + tbGood.strGoodsRemark + "',";
               str_Add += "GoodTime='" + tbGood.DaGoodTime + "',Falg='" + tbGood.Falg + "' where GoodsID ='" + tbGood.strGoodsID + "'";
               getSqlConnection getConnection = new getSqlConnection();

分享到：

关注

支持(0)

反对(0)

精彩评论 2

givemf

学分：2 LV1

+关注

私信

2016-10-25

沙发

修改后的string str_Add = "insert into tb_JhGoodsInfo values( ";
               str_Add += "'" + tbGood.strGoodsID + "','" + tbGood.strEmpId + "','" + tbGood.strJhCompName + "',";
               str_Add += "'" + tbGood.strDepotName + "','" + tbGood.strGoodsName + "','" + tbGood.strGoodsNum + "',";
               str_Add += "'" + tbGood.strGoodsUnit + "'," + tbGood.deGoodsJhPrice + " ," + tbGood.deGoodsSellPrice + " ,";
               str_Add += "" + tbGood.deGoodsNeedPrice + "" + tbGood.deGoodsNoPrice + " " + tbGood.strGoodsRemark + " ,";
               str_Add += "'" + tbGood.DaGoodTime + "'," + tbGood.Falg + ")";

支持(0)

反对(0)

首页上一页 1 下一页尾页 1 条记录 1/1页