/*根据传递过来的销售小票号和员工编号实现对应购物车中商品销售信息的登记,然后清空购物车*/ public static bool AddGoodSellInfoInCart(string sellNo, string employeeNo) { bool isSuccessful = true; /*查询该员工的商品销售购物车中信息*/ string sqlString = "select * from [goodCartInfo] where employeeNo='" + employeeNo + "'"; DataSet goodCartInfoDs = DBOperation.GetDataSet(DBOperation.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null); /*将每条商品销售信息登记入商品销售信息表*/ for (int i = 0; i < goodCartInfoDs.Tables[0].Rows.Count; i++) { DataRow dr = goodCartInfoDs.Tables[0].Rows[i]; SellInfoModel sellInfoModel = new SellInfoModel(); sellInfoModel.SellNo = sellNo; sellInfoModel.GoodNo = dr["goodNo"].ToString(); sellInfoModel.Price = Convert.ToSingle(dr["goodPrice"]); sellInfoModel.Number = Convert.ToInt32(dr["goodCount"]); sellInfoModel.TotalPrice = sellInfoModel.Price * sellInfoModel.Number; sellInfoModel.SellTime = DateTime.Now; sellInfoModel.EmployeeNo = employeeNo; if (!SellLogic.AddSellInfo(sellInfoModel)) { isSuccessful = false; } } /*然后清空该员工的商品购物车*/ sqlString = "delete from [goodCartInfo] where employeeNo='" + employeeNo + "'"; if (DBOperation.ExecuteNonQuery(DBOperation.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null) <= 0) { isSuccessful = false; } return(isSuccessful); }
/*传入商品销售信息模型,实现销售信息的登记操作*/ public static bool AddSellInfo(SellInfoModel sellInfoModel) { string sqlString = "insert into [sellInfo] (sellNo,goodNo,price,number,totalPrice,sellTime,employeeNo) values ('"; sqlString += sellInfoModel.SellNo + "','"; sqlString += sellInfoModel.GoodNo + "',"; sqlString += sellInfoModel.Price + ","; sqlString += sellInfoModel.Number + ","; sqlString += sellInfoModel.TotalPrice + ",'"; sqlString += sellInfoModel.SellTime + "','"; sqlString += sellInfoModel.EmployeeNo + "')"; if (DBOperation.ExecuteNonQuery(DBOperation.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null) <= 0) { return(false); } return(true); }