//更新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);
}
