public void InsertBillType(StockBillType stockBillType, IDbConnection conn, IDbTransaction trans)
{
string sql = @"
INSERT INTO MD_BillType(Name,Actived,IsOut)
VALUES(@Name,@Actived,@IsOut)";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@Name", stockBillType.Name));
paramList.Add(new SqlParameter("@Actived", stockBillType.Actived));
paramList.Add(new SqlParameter("@isOut", stockBillType.IsOutStorehouse));
DataAccessUtil.ExecuteNonQuery(sql, paramList, (SqlTransaction)trans);
}
public void UpdateBillType(StockBillType stockBillType, IDbConnection conn)
{
string sql = @"
UPDATE MD_BillType SET
Name=@Name,Actived=@Actived,IsOut=@IsOut
WHERE ID=@ID";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@Name", stockBillType.Name));
paramList.Add(new SqlParameter("@Actived", stockBillType.Actived));
paramList.Add(new SqlParameter("@isOut", stockBillType.IsOutStorehouse));
paramList.Add(new SqlParameter("@ID", stockBillType.ID));
DataAccessUtil.ExecuteNonQuery(sql, paramList, (SqlConnection)conn);
}
public void UpdateBillType(StockBillType stockBillType, IDbConnection conn, IDbTransaction trans)
{
string sql = @"
UPDATE MD_BillType SET
StockBillTypeCode=@StockBillTypeCode,StockBillTypeName=@StockBillTypeName,
Actived=@Actived
WHERE ID=@ID";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@StockBillTypeCode", stockBillType.Code));
paramList.Add(new SqlParameter("@StockBillTypeName", stockBillType.Name));
paramList.Add(new SqlParameter("@Actived", stockBillType.Actived));
paramList.Add(new SqlParameter("@ID", stockBillType.ID));
DataAccessUtil.ExecuteNonQuery(sql, paramList, (SqlTransaction)trans);
}
public List <StockBillType> SelectAllBillTypes(IDbConnection conn)
{
string sql = "SELECT ID,Name,Actived,IsOut FROM MD_BillType";
SqlDataReader reader = DataAccessUtil.ExecuteReader(sql, new List <SqlParameter>(), (SqlConnection)conn);
List <StockBillType> list = new List <StockBillType>();
while (reader.Read())
{
StockBillType sh = new StockBillType();
sh.ID = reader.GetInt32(0);
sh.Name = reader.GetString(1);
sh.Actived = reader.GetBoolean(2);
sh.IsOutStorehouse = reader.GetBoolean(3);
list.Add(sh);
}
reader.Close();
return(list);
}
/// <summary>
/// 根据给定的一些条件进行票据的模糊查找
/// </summary>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
/// <param name="companyCond"></param>
/// <param name="billMakerCond"></param>
/// <returns></returns>
public List <StockBill> SearchBill(DateTime fromDate, DateTime toDate,
string companyCond, string billMakerCond, string billID, StockBillType billType)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IStockBillDAO dao = DAOFactory.Instance.CreateStockBillDAO();
List <StockBill> bills = dao.SearchBills(fromDate, toDate, companyCond, billMakerCond, conn);
for (int i = bills.Count - 1; i >= 0; i--)
{
StockBill bill = bills[i];
if (!bill.ID.ToString().Contains(billID))
{
bills.Remove(bill);
}
if (billType.Equals(bill.BillType))
{
bills.Remove(bill);
}
}
return(bills);
}
}
