/// <summary> /// 插入数据 /// </summary> /// <param name="student"></param> /// <returns></returns> public bool insert(Student student) { string sql = "insert into student (classId, birthday, img, studentName, sex) values ('{0}', '{1}', '{2}', '{3}', '{4}')"; sql = string.Format(sql, student.classId, student.birthday, student.img, student.studentName, student.sex); List <string> sqlList = new List <string>(); sqlList.Add(sql); bool isSuccess = SQLHelper.ExecuteTransaction(sqlList); return(isSuccess); }
/// <summary> /// 结账 /// </summary> /// <param name="objSaleList"></param> /// <param name="member"></param> /// <returns></returns> public bool SaveSaleInfo(SalesListMain objSaleList, SMMembers member) { List <string> sqlList = new List <string>(); //【1】组合sql语句(插入主表) string mainSql = "insert into SalesList(SerialNum, TotalMoney, RealReceive, ReturnMoney, SalesPersonId) values('{0}',{1},{2},{3},{4})"; mainSql = string.Format(mainSql, objSaleList.SeriaINum, objSaleList.TotalMoney, objSaleList.RealRecieve, objSaleList.ReturnMoney, objSaleList.SalesPersonId); sqlList.Add(mainSql); //【2】组合sql语句(插入明细表以及更新库存) foreach (SalesListDetail detail in objSaleList.ListDetail) { //插入明细表 string detailSql = "insert into SalesListDetail(SerialNum, ProductId, ProductName, UnitPrice, Discount, Quantity, SubTotalMoney)"; detailSql += " values('{0}','{1}','{2}',{3},{4},{5},{6})"; detailSql = string.Format(detailSql, detail.SeriaINum, detail.ProductId, detail.ProductName, detail.UnitPrice, detail.Discount, detail.Quantity, detail.SubTotalMoney); sqlList.Add(detailSql); //跟新库存 string updateSql = $"update ProductInventory set TotalCount=TotalCount-{detail.Quantity} where ProductId='{detail.ProductId}'"; sqlList.Add(updateSql); } //【3】更新客户积分 if (member != null) { string pointSql = "update SMMembers set Points=Points+{0} where MemberId={1}"; pointSql = string.Format(pointSql, member.Points, member.MemeberId); sqlList.Add(pointSql); } try { //【4】启用事务,返回结果 return(SQLHelper.ExecuteTransaction(sqlList)); } catch (Exception ex) { throw ex; } }
public bool Import(List <StudentExt> studentList) { string sql = "insert into Students(StudentName, Gender, Birthday, StudentIdNo, CardNo, Age, PhoneNumber, StudentAddress, ClassId)"; sql += " values('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}',{8});"; List <string> sqlList = new List <string>(); foreach (var student in studentList) { string sql1 = string.Format(sql, student.StudentName, student.Gender, student.Birthday, student.StudentIdNo, student.CardNo, student.Age, student.PhoneNumber, student.StudentAddress, student.ClassId); sqlList.Add(sql1); } //将Slq语句提交到数据库 try { //返回学号 return(SQLHelper.ExecuteTransaction(sqlList)); } catch (Exception ex) { throw ex; } }