//更新Goodslimit public int UpdateSingleGoodslimit(SingleGoodslimit mi) { //构造要查询的sql语句 string sql = @"update bg_cust_dec_goodslimit_singlewindow set lic_type_code=@p0, lic_type_name=@p1, licence_no=@p2 ,update_date=@p3 where batch = '" + mi.Batch + "' and cust_dec_head_id = '" + mi.CustDecHeadId + "' and cust_dec_detail_id = '" + mi.CustDecDetailId + "' and goods_no = '" + mi.GoodsNo + "' and lic_type_code = '" + mi.LicTypeCode + "'"; //构造sql语句的参数 MySqlParameter[] ps = //使用数组初始化器 { new MySqlParameter("@p0", mi.LicTypeCode), new MySqlParameter("@p1", mi.LicTypeName), new MySqlParameter("@p2", mi.LicenceNo), new MySqlParameter("@p3", mi.UpdateDate) }; //执行插入操作 return(mysqlHelper.ExcuteNonQuery(sql, ps)); }
//查询Goodslimit是否存在 public List <SingleGoodslimit> GetGoodslimitList(SingleGoodslimit mi) { //构造要查询的sql语句 string sql = "select * from bg_cust_dec_goodslimit_singlewindow where batch = '" + mi.Batch + "' and cust_dec_head_id = '" + mi.CustDecHeadId + "' and cust_dec_detail_id = '" + mi.CustDecDetailId + "' and goods_no = '" + mi.GoodsNo + "' and lic_type_code = '" + mi.LicTypeCode + "'"; //使用helper进行查询,得到结果 DataTable dt = mysqlHelper.GetDataTable(sql); //将dt中的数据转存到list中 List <SingleGoodslimit> list = new List <SingleGoodslimit>(); foreach (DataRow row in dt.Rows) { list.Add(new SingleGoodslimit() { Id = row["id"].ToString() }); } //将集合返回 return(list); }
/// <summary> /// 插入许可证数据 /// </summary> /// <param name="mi">ManagerInfo类型的对象</param> /// <returns></returns> public int InsertSingleGoodslimit(SingleGoodslimit mi) { //构造insert语句 string sql = @"insert into bg_cust_dec_goodslimit_singlewindow(goods_no,cust_dec_detail_id,cust_dec_head_id,batch,lic_type_code,lic_type_name,licence_no, create_date,update_date)"; sql += " values(@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8)"; //构造sql语句的参数 MySqlParameter[] ps = //使用数组初始化器 { new MySqlParameter("@p0", mi.GoodsNo), new MySqlParameter("@p1", mi.CustDecDetailId), new MySqlParameter("@p2", mi.CustDecHeadId), new MySqlParameter("@p3", mi.Batch), new MySqlParameter("@p4", mi.LicTypeCode), new MySqlParameter("@p5", mi.LicTypeName), new MySqlParameter("@p6", mi.LicenceNo), new MySqlParameter("@p7", mi.CreateDate), new MySqlParameter("@p8", mi.UpdateDate) }; //执行插入操作 return(mysqlHelper.ExcuteNonQuery(sql, ps)); }
public bool InsertSingleGoodslimit(SingleGoodslimit mi) { //调用dal层的insert方法,完成插入操作 return(miDal.InsertSingleGoodslimit(mi) > 0); }
//查询Goodslimit是否存在 public List <SingleGoodslimit> GetGoodslimitList(SingleGoodslimit singleGoodslimit) { //调用查询方法 return(miDal.GetGoodslimitList(singleGoodslimit)); }
//更新许可证信息 public bool UpdateSingleGoodslimit(SingleGoodslimit singleGoodslimit) { //调用查询方法 return(miDal.UpdateSingleGoodslimit(singleGoodslimit) > 0); }