public void DBItemBase_Update(FactoryArgs args, t_BigID ItemID, t_BigID ItemTypeID,
t_String ItemName, t_String ItemMode, t_Float ItemRate,
t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice)
{
_DALDBItemBase.Update(args, ItemID, ItemTypeID, ItemName, ItemMode,
ItemRate, UOMID, Description, IsForbid, ItemPrice);
}
public void InsertInBill(FactoryArgs args, out t_BigID SaleCarInBillID, t_String SaleCarInBillCode, t_BigID CarID,
t_BigID ItemID, t_DTSmall BillDate, t_Float CarTare, t_BigID SupplierID, t_String Description,
t_String CardCode, t_Float TotalWeight, t_Float SuttleWeight)
{
SaleCarInBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillCode", SaleCarInBillCode));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("SupplierID", SupplierID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("CardCode", CardCode));
parms.Add(new LBDbParameter("TotalWeight", TotalWeight));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
string strSQL = @"
insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount,
ItemID, BillDate, BillStatus, CarTare, SupplierID,Description,
IsCancel, CreateBy, CreateTime,CancelByDate,CardCode,TotalWeight,SuttleWeight)
values( @SaleCarInBillCode, @CarID,0,
@ItemID, @BillDate, 1, @CarTare, @SupplierID,@Description,
0,@CreateBy,@BillDate,datetime('now','localtime'),@CardCode,@TotalWeight,@SuttleWeight);
select last_insert_rowid() as SaleCarInBillID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount,
ItemID, BillDate, BillStatus, CarTare, SupplierID,Description,
IsCancel, CreateBy, CreateTime,CancelByDate,CardCode,TotalWeight,SuttleWeight)
values( @SaleCarInBillCode, @CarID,0,
@ItemID, @BillDate, 1, @CarTare, @SupplierID,@Description,
0,@CreateBy,@BillDate,getdate(),@CardCode,@TotalWeight,@SuttleWeight)
select @@identity as SaleCarInBillID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarInBillID.Value = Convert.ToInt64(parms["SaleCarInBillID"].Value);
}
public void Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID,
t_String ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate,
t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice)
{
ItemID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ItemID", ItemID, true));
parms.Add(new LBDbParameter("ItemTypeID", ItemTypeID));
parms.Add(new LBDbParameter("ItemCode", ItemCode));
parms.Add(new LBDbParameter("ItemName", ItemName));
parms.Add(new LBDbParameter("ItemMode", ItemMode));
parms.Add(new LBDbParameter("ItemRate", ItemRate));
parms.Add(new LBDbParameter("UOMID", UOMID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("IsForbid", IsForbid));
parms.Add(new LBDbParameter("ItemPrice", ItemPrice));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
string strSQL = @"
insert into dbo.DbItemBase( ItemTypeID, ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description,
IsForbid, ChangeBy, ChangeTime,ItemPrice)
values( @ItemTypeID, @ItemCode, @ItemName, @ItemMode, @ItemRate, @UOMID, @Description,
@IsForbid, @ChangeBy, @ChangeTime,@ItemPrice);
select last_insert_rowid() as ItemID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.DbItemBase( ItemTypeID, ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description,
IsForbid, ChangeBy, ChangeTime,ItemPrice)
values( @ItemTypeID, @ItemCode, @ItemName, @ItemMode, @ItemRate, @UOMID, @Description,
@IsForbid, @ChangeBy, @ChangeTime,@ItemPrice)
select @@identity as ItemID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ItemID.Value = Convert.ToInt64(parms["ItemID"].Value);
}
public void UpdateInBill(FactoryArgs args, t_BigID SaleCarInBillID, t_BigID CarID, t_BigID SupplierID,
t_Float CarTare, t_Float SuttleWeight)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("SupplierID", SupplierID));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
string strSQL = @"
update dbo.SaleCarInBill
set CarID = @CarID,
SupplierID = @SupplierID,
SuttleWeight = @SuttleWeight,
CarTare = @CarTare
where SaleCarInBillID =@SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Update(FactoryArgs args, t_BigID ItemID, t_BigID ItemTypeID,
t_String ItemName, t_String ItemMode, t_Float ItemRate,
t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("ItemTypeID", ItemTypeID));
parms.Add(new LBDbParameter("ItemName", ItemName));
parms.Add(new LBDbParameter("ItemMode", ItemMode));
parms.Add(new LBDbParameter("ItemRate", ItemRate));
parms.Add(new LBDbParameter("UOMID", UOMID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("IsForbid", IsForbid));
parms.Add(new LBDbParameter("ItemPrice", ItemPrice));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
string strSQL = @"
update dbo.DbItemBase
set ItemTypeID=@ItemTypeID,
ItemName=@ItemName,
ItemMode=@ItemMode,
ItemRate=@ItemRate,
UOMID=@UOMID,
Description=@Description,
IsForbid=@IsForbid,
ItemPrice = @ItemPrice,
ChangeBy=@ChangeBy,
ChangeTime=@ChangeTime
where ItemID = @ItemID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void DBItemBase_Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID,
out t_String ItemCode, t_String K3ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate,
t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice)
{
ItemCode = new t_String();
t_String MaxCode;
_DALDBItemBase.GetMaxCode(args, out MaxCode);
int CodeIndex = MaxCode.Value == null ? 0 : LBConverter.ToInt32(MaxCode.Value.Replace("S", ""));
CodeIndex++;
if (CodeIndex < 10)
{
ItemCode.SetValueWithObject("S00" + CodeIndex.ToString());
}
else if (CodeIndex < 100)
{
ItemCode.SetValueWithObject("S0" + CodeIndex.ToString());
}
else
{
ItemCode.SetValueWithObject("S" + CodeIndex.ToString());
}
_DALDBItemBase.Insert(args, out ItemID, ItemTypeID, ItemCode, K3ItemCode, ItemName, ItemMode,
ItemRate, UOMID, Description, IsForbid, ItemPrice);
}
public void InsertInBill(FactoryArgs args, out t_BigID SaleCarInBillID, t_String SaleCarInBillCode, t_BigID CarID,
t_BigID ItemID, t_DTSmall BillDate, t_ID ReceiveType, t_ID CalculateType, t_Float CarTare, t_BigID CustomerID, t_String Description,
t_ID SaleBillType, t_BigID SaleCarInBillIDFromClient, t_String CreateBy)
{
SaleCarInBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillCode", SaleCarInBillCode));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("ReceiveType", ReceiveType));
parms.Add(new LBDbParameter("CalculateType", CalculateType));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("SaleBillType", SaleBillType));
parms.Add(new LBDbParameter("SaleCarInBillIDFromClient", SaleCarInBillIDFromClient));
parms.Add(new LBDbParameter("CreateBy", CreateBy));
string strSQL = @"
insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount,
ItemID, BillDate, ReceiveType, BillStatus, CalculateType, CarTare, CustomerID,Description,
IsCancel, CreateBy, CreateTime,CancelByDate,SaleBillType,SaleCarInBillIDFromClient)
values( @SaleCarInBillCode, @CarID,0,
@ItemID, @BillDate, @ReceiveType, 1, @CalculateType, @CarTare, @CustomerID,@Description,
0,@CreateBy,@BillDate,null,@SaleBillType,@SaleCarInBillIDFromClient)
set @SaleCarInBillID = @@identity
update dbo.DbCar
set SortLevel = isnull(SortLevel,0)+1
where CarID = @CarID
update dbo.DbCustomer
set SortLevel = isnull(SortLevel,0)+1
where CustomerID = @CustomerID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarInBillID.Value = Convert.ToInt64(parms["SaleCarInBillID"].Value);
}
