public void Update(FactoryArgs args, t_BigID ModifyBillDetailID, t_BigID ItemID, t_BigID CarID,
t_Decimal Price, t_ID CalculateType, t_BigID UOMID, t_String Description, t_Decimal MaterialPrice, t_Decimal FarePrice,
t_Decimal TaxPrice, t_Decimal BrokerPrice)
{
_DALModifyBillDetail.Update(args, ModifyBillDetailID, ItemID, CarID, Price, CalculateType, UOMID, Description,
MaterialPrice, FarePrice, TaxPrice, BrokerPrice);
}
public void UpdateOutBillPurchase(FactoryArgs args, t_BigID SaleCarInBillID, t_Decimal SuttleWeight,
t_Decimal Price, t_Decimal Amount, t_String SaleCarOutBillCode)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("Amount", Amount));
parms.Add(new LBDbParameter("SaleCarOutBillCode", SaleCarOutBillCode));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
string strSQL = @"
update dbo.SaleCarOutBill
set SuttleWeight = @SuttleWeight,
CreateBy = @CreateBy,
BillDate = getdate(),
CreateTime = getdate(),
Price = @Price,
Amount = @Amount,
SaleCarOutBillCode = @SaleCarOutBillCode
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Update(FactoryArgs args, t_BigID SaleCarReturnBillID,
t_Decimal CarTare, t_Decimal SuttleWeight, t_ID ReturnType, t_String Description, t_ID ReturnReason,
t_BigID NewSaleCarInBillID)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarReturnBillID", SaleCarReturnBillID));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
parms.Add(new LBDbParameter("ReturnType", ReturnType));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReturnReason", ReturnReason));
parms.Add(new LBDbParameter("NewSaleCarInBillID", NewSaleCarInBillID));
string strSQL = @"
update SaleCarReturnBill
set ReturnStatus=1,
CarTare = @CarTare,
SuttleWeight = @SuttleWeight,
ReturnType = @ReturnType,
Description = @Description,
CarOutTime = getdate(),
ReturnReason = @ReturnReason,
NewSaleCarInBillID = @NewSaleCarInBillID
where SaleCarReturnBillID = @SaleCarReturnBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Customer_UpdateFromService(FactoryArgs args, t_BigID CustomerID, t_String CustomerName, t_String Contact, t_String Phone, t_String Address,
t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType,
t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul,
t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_Decimal TotalReceivedAmount, t_Decimal SalesReceivedAmount, t_String K3CustomerCode,
t_BigID CustomerTypeID)
{
DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans)
{
this.Customer_Update(argsInTrans, CustomerID, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description,
ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough,
K3CustomerCode, CustomerTypeID);
_DALDbCustomer.UpdateAmount(argsInTrans, CustomerID, TotalReceivedAmount, SalesReceivedAmount);
IsForbid.IsNullToZero();
if (IsForbid.Value == 1)
{
_DALDbCustomer.Forbid(args, CustomerID);
}
else
{
_DALDbCustomer.UnForbid(args, CustomerID);
}
};
DBHelper.ExecInTrans(args, exec);
}
public void UpdateInOutBill(FactoryArgs args, t_BigID SaleCarInBillID, t_BigID CarID, t_BigID ItemID, t_BigID CustomerID, t_Decimal Price,
t_Decimal Amount, t_String Description, t_String ChangeDetail)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("Amount", Amount));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ChangeDetail", ChangeDetail));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
string strSQL = @"
update dbo.SaleCarInBill
set ItemID = @ItemID,
CarID = @CarID,
CustomerID = @CustomerID
where SaleCarInBillID = @SaleCarInBillID
update dbo.SaleCarOutBill
set Price = @Price,
Amount = @Amount,
Description = @Description,
ChangedBy = @ChangedBy,
ChangeTime = getdate(),
ChangeDetail = @ChangeDetail
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void GetTodayTotalWeight(FactoryArgs args, out t_Decimal SalesTotalWeight, out t_ID TotalCar)
{
DateTime dtFrom = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime dtTo = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1);
SalesTotalWeight = new t_Decimal(0);
TotalCar = new t_ID(0);
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SalesTotalWeight", SalesTotalWeight, true));
parms.Add(new LBDbParameter("TotalCar", TotalCar, true));
parms.Add(new LBDbParameter("DTFrom", new t_DTSmall(dtFrom)));
parms.Add(new LBDbParameter("DTTo", new t_DTSmall(dtTo)));
string strSQL = @"
select @SalesTotalWeight = sum(SuttleWeight/1000.0), @TotalCar = count(1)
from dbo.SaleCarOutBill o
inner join SaleCarInBill i on
i.SaleCarInBillID = o.SaleCarInBillID
where i.BillStatus = 2 and
o.BillDate>=@DTFrom and o.BillDate<@DTTo
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SalesTotalWeight.SetValueWithObject(parms["SalesTotalWeight"].Value);
TotalCar.SetValueWithObject(parms["TotalCar"].Value);
}
public void UpdateInOutBill(FactoryArgs args, t_BigID SaleCarInBillID, t_BigID ItemID, t_BigID CustomerID, t_Decimal Price,
t_Decimal Amount)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("Amount", Amount));
string strSQL = @"
update dbo.SaleCarInBill
set ItemID = @ItemID,
CustomerID = @CustomerID
where SaleCarInBillID = @SaleCarInBillID
update dbo.SaleCarOutBill
set Price = @Price,
Amount = @Amount
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID,
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)
{
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("K3ItemCode", K3ItemCode));
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,K3ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description,
IsForbid, ChangeBy, ChangeTime,ItemPrice)
values( @ItemTypeID, @ItemCode,@K3ItemCode, @ItemName, @ItemMode, @ItemRate, @UOMID, @Description,
@IsForbid, @ChangeBy, @ChangeTime,@ItemPrice)
set @ItemID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ItemID.Value = Convert.ToInt64(parms["ItemID"].Value);
}
public void Customer_Insert(FactoryArgs args, out t_BigID CustomerID, t_String CustomerCode, t_String CustomerName, t_String Contact, t_String Phone, t_String Address,
t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_ID ReceiveType,
t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul,
t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_String K3CustomerCode, t_BigID CustomerTypeID)
{
CustomerTypeID.NullIfZero();
CarIsLimit.IsNullToZero();
IsDisplayPrice.IsNullToZero();
IsDisplayAmount.IsNullToZero();
IsPrintAmount.IsNullToZero();
IsAllowOverFul.IsNullToZero();
CreditAmount.IsNullToZero();
CreditAmount.IsNullToZero();
CustomerID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CustomerID", CustomerID, true));
parms.Add(new LBDbParameter("CustomerCode", CustomerCode));
parms.Add(new LBDbParameter("CustomerName", CustomerName));
parms.Add(new LBDbParameter("CustomerTypeID", CustomerTypeID));
parms.Add(new LBDbParameter("Contact", Contact));
parms.Add(new LBDbParameter("Phone", Phone));
parms.Add(new LBDbParameter("Address", Address));
parms.Add(new LBDbParameter("CarIsLimit", CarIsLimit));
parms.Add(new LBDbParameter("AmountType", AmountType));
parms.Add(new LBDbParameter("LicenceNum", LicenceNum));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReceiveType", ReceiveType));
parms.Add(new LBDbParameter("CreditAmount", CreditAmount));
parms.Add(new LBDbParameter("IsDisplayPrice", IsDisplayPrice));
parms.Add(new LBDbParameter("IsDisplayAmount", IsDisplayAmount));
parms.Add(new LBDbParameter("IsPrintAmount", IsPrintAmount));
parms.Add(new LBDbParameter("IsAllowOverFul", IsAllowOverFul));
parms.Add(new LBDbParameter("IsAllowEmptyIn", IsAllowEmptyIn));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("CreateTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("AmountNotEnough", AmountNotEnough));
parms.Add(new LBDbParameter("K3CustomerCode", K3CustomerCode));
string strSQL = @"
insert into dbo.DbCustomer(CustomerCode,CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum,
Description, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul,
CreateBy, CreateTime, ChangeBy, ChangeTime,IsAllowEmptyIn,AmountNotEnough,K3CustomerCode, CustomerTypeID)
values(@CustomerCode, @CustomerName, @Contact, @Phone, @Address, @CarIsLimit, @AmountType, @LicenceNum,
@Description, @ReceiveType, @CreditAmount, @IsDisplayPrice, @IsDisplayAmount, @IsPrintAmount, @IsAllowOverFul,
@CreateBy, @CreateTime, @ChangeBy, @ChangeTime,@IsAllowEmptyIn,@AmountNotEnough,@K3CustomerCode, @CustomerTypeID)
set @CustomerID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
CustomerID.Value = Convert.ToInt64(parms["CustomerID"].Value);
}
public void Car_Insert(FactoryArgs args, out t_BigID CarID, out t_String CarCode, t_String CarNum,
t_BigID CustomerID, t_String Description, t_Decimal DefaultCarWeight)
{
CarCode = new t_String();
CarID = new t_BigID();
DefaultCarWeight.IsNullToZero();
using (DataTable dtCar = _DALDbCar.GetCarByName(args, CarID, CarNum))
{
if (dtCar.Rows.Count > 0)
{
throw new Exception("该车牌号码已存在！");
}
}
t_BigID CarID_temp = new t_BigID();
t_String CarCode_temp = new t_String();
DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans)
{
t_String MaxCode;
_DALDbCar.GetMaxCarCode(argsInTrans, out MaxCode);
int CodeIndex = MaxCode.Value == null?0:LBConverter.ToInt32(MaxCode.Value.Replace("C", ""));
CodeIndex++;
if (CodeIndex < 10)
{
CarCode_temp.SetValueWithObject("C000" + CodeIndex.ToString());
}
else if (CodeIndex < 100)
{
CarCode_temp.SetValueWithObject("C00" + CodeIndex.ToString());
}
else if (CodeIndex < 1000)
{
CarCode_temp.SetValueWithObject("C0" + CodeIndex.ToString());
}
else
{
CarCode_temp.SetValueWithObject("C" + CodeIndex.ToString());
}
_DALDbCar.Car_Insert(argsInTrans, out CarID_temp, CarCode_temp, CarNum, Description, DefaultCarWeight);
if (CustomerID.Value > 0)
{
_DALDbCar.InsertCustomerCar(argsInTrans, CarID_temp, CustomerID);
}
};
DBHelper.ExecInTrans(args, exec);
CarID.Value = CarID_temp.Value;
CarCode.Value = CarCode_temp.Value;
}
public void UpdateCustomerSalesAmount(FactoryArgs args, t_BigID CustomerID, t_Decimal SalesReceivedAmount)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("SalesReceivedAmount", SalesReceivedAmount));
string strSQL = @"
update dbo.DbCustomer
set SalesReceivedAmount = isnull(SalesReceivedAmount,0)+isnull(@SalesReceivedAmount,0)
where CustomerID = @CustomerID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Car_Update(FactoryArgs args, t_BigID CarID, t_String CarNum,
t_BigID CustomerID, t_String Description, t_Decimal DefaultCarWeight)
{
DefaultCarWeight.IsNullToZero();
using (DataTable dtCar = _DALDbCar.GetCarByName(args, CarID, CarNum))
{
if (dtCar.Rows.Count > 0)
{
throw new Exception("该车牌号码已存在！");
}
}
_DALDbCar.Car_Update(args, CarID, CarNum, Description, DefaultCarWeight);
}
public void UpdateOutBillAmount(FactoryArgs args, t_BigID SaleCarInBillID,
t_Decimal Price, t_Decimal Amount)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("Amount", Amount));
string strSQL = @"
update dbo.SaleCarOutBill
set Price = @Price,
Amount = @Amount
where SaleCarInBillID = @SaleCarInBillID";
}
public void UpdateSMItemPrice(FactoryArgs args, t_BigID ItemPriceID, t_Decimal ItemPrice)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ItemPriceID", ItemPriceID));
parms.Add(new LBDbParameter("ItemPrice", ItemPrice));
string strSQL = @"
update dbo.SMItemPrice
set ItemPrice = @ItemPrice
where ItemPriceID = @ItemPriceID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Insert(FactoryArgs args, t_BigID CarID, t_Decimal CarWeight, t_String Description)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("CarWeight", CarWeight));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("CreateTime", new t_DTSmall(DateTime.Now)));
string strSQL = @"
insert into dbo.DbCarWeight(CarID,CarWeight,Description,CreateBy, CreateTime)
values( @CarID, @CarWeight, @Description, @CreateBy, @CreateTime)
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void UpdateOutBillAmount(FactoryArgs args, t_BigID SaleCarInBillID,
t_Decimal Price, t_Decimal Amount)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("Amount", Amount));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
string strSQL = @"
update dbo.SaleCarOutBill
set Price = @Price,
Amount = @Amount,
ChangedBy = @ChangedBy,
ChangeTime=getdate()
where SaleCarInBillID = @SaleCarInBillID";
}
public void Customer_Update(FactoryArgs args, t_BigID CustomerID, t_String CustomerName, t_String Contact, t_String Phone, t_String Address,
t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType,
t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul,
t_Bool IsAllowEmptyIn)
{
IsAllowEmptyIn.IsNullToZero();
using (DataTable dtCustomer = _DALDbCustomer.GetCustomerByName(args, CustomerID, CustomerName))
{
if (dtCustomer.Rows.Count > 0)
{
throw new Exception("该客户名称已存在！");
}
}
_DALDbCustomer.Customer_Update(args, CustomerID, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description,
IsForbid, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn);
}
public void InsertOutBill(FactoryArgs args, out t_BigID SaleCarOutBillID, t_String SaleCarOutBillCode, t_BigID SaleCarInBillID, t_BigID CarID, t_DTSmall BillDate,
t_Decimal TotalWeight, t_Decimal SuttleWeight, t_Decimal Price, t_Decimal Amount, t_ID ReceiveType, t_ID CalculateType, t_String Description,
t_String CreateBy, t_BigID SaleCarOutBillIDFromClient, t_Decimal MaterialPrice, t_Decimal FarePrice,
t_Decimal TaxPrice, t_Decimal BrokerPrice)
{
SaleCarOutBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarOutBillID", SaleCarOutBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("SaleCarOutBillCode", SaleCarOutBillCode));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("TotalWeight", TotalWeight));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("Amount", Amount));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReceiveType", ReceiveType));
parms.Add(new LBDbParameter("CalculateType", CalculateType));
parms.Add(new LBDbParameter("CreateBy", CreateBy));
parms.Add(new LBDbParameter("SaleCarOutBillIDFromClient", SaleCarOutBillIDFromClient));
parms.Add(new LBDbParameter("MaterialPrice", MaterialPrice));
parms.Add(new LBDbParameter("FarePrice", FarePrice));
parms.Add(new LBDbParameter("TaxPrice", TaxPrice));
parms.Add(new LBDbParameter("BrokerPrice", BrokerPrice));
string strSQL = @"
insert into dbo.SaleCarOutBill( SaleCarInBillID,SaleCarOutBillCode, BillDate, CarID,TotalWeight,
SuttleWeight, Price, Amount, Description,CreateBy, CreateTime,SaleCarOutBillIDFromClient,
MaterialPrice,FarePrice,TaxPrice,BrokerPrice,ChangedBy,ChangeTime)
values( @SaleCarInBillID,@SaleCarOutBillCode, @BillDate, @CarID, @TotalWeight,
@SuttleWeight, @Price, @Amount, @Description,@CreateBy,@BillDate,@SaleCarOutBillIDFromClient,
@MaterialPrice,@FarePrice,@TaxPrice,@BrokerPrice,@CreateBy,getdate())
set @SaleCarOutBillID = @@identity
update dbo.SaleCarInBill
set ReceiveType = @ReceiveType,
CalculateType = @CalculateType
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarOutBillID.Value = Convert.ToInt64(parms["SaleCarOutBillID"].Value);
}
public void Customer_Insert(FactoryArgs args, out t_BigID CustomerID, out t_String CustomerCode, t_String CustomerName, t_String Contact, t_String Phone, t_String Address,
t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_ID ReceiveType,
t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul,
t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_String K3CustomerCode, t_BigID CustomerTypeID)
{
CustomerTypeID.NullIfZero();
CustomerCode = new t_String();
CustomerID = new t_BigID();
IsAllowEmptyIn.IsNullToZero();
using (DataTable dtCustomer = _DALDbCustomer.GetCustomerByName(args, CustomerID, CustomerName))
{
if (dtCustomer.Rows.Count > 0)
{
throw new Exception("该客户名称已存在！");
}
}
t_String MaxCode;
_DALDbCustomer.GetMaxCode(args, out MaxCode);
int CodeIndex = MaxCode.Value == null ? 0 : LBConverter.ToInt32(MaxCode.Value.Replace("K", ""));
CodeIndex++;
if (CodeIndex < 10)
{
CustomerCode.SetValueWithObject("K000" + CodeIndex.ToString());
}
else if (CodeIndex < 100)
{
CustomerCode.SetValueWithObject("K00" + CodeIndex.ToString());
}
else if (CodeIndex < 1000)
{
CustomerCode.SetValueWithObject("K0" + CodeIndex.ToString());
}
else
{
CustomerCode.SetValueWithObject("K" + CodeIndex.ToString());
}
_DALDbCustomer.Customer_Insert(args, out CustomerID, CustomerCode, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description,
ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough,
K3CustomerCode, CustomerTypeID);
}
public void UpdateInBillPurchase(FactoryArgs args, t_BigID SaleCarInBillID, t_Decimal CarTare)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
string strSQL = @"
update dbo.SaleCarInBill
set CarTare = @CarTare,
CreateBy = @CreateBy,
BillDate = getdate(),
CreateTime = getdate()
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void UnApprove(FactoryArgs args, t_BigID ReceiveBillHeaderID)
{
t_Decimal ReceiveAmount = new t_Decimal(0);
t_BigID CustomerID = new t_BigID();
t_Decimal SalesReceiveAmountAdd = new t_Decimal(0);
t_Decimal SalesReceiveAmountReduce = new t_Decimal(0);
using (DataTable dtHeader = _DALRPReceiveBillHeader.GetRPReceiveBillHeader(args, ReceiveBillHeaderID))
{
if (dtHeader.Rows.Count > 0)
{
DataRow drHeader = dtHeader.Rows[0];
bool bolIsApprove = LBConverter.ToBoolean(drHeader["IsApprove"]);
bool bolIsCancel = LBConverter.ToBoolean(drHeader["IsCancel"]);
ReceiveAmount.SetValueWithObject(drHeader["ReceiveAmount"]);
SalesReceiveAmountAdd.SetValueWithObject(drHeader["SalesReceiveAmountAdd"]);
SalesReceiveAmountReduce.SetValueWithObject(drHeader["SalesReceiveAmountReduce"]);
CustomerID.SetValueWithObject(drHeader["CustomerID"]);
if (!bolIsApprove)
{
throw new Exception("该充值单未审核，无法执行取消审核！");
}
if (bolIsCancel)
{
throw new Exception("该充值单已作废，无法执行取消审核！");
}
}
else
{
throw new Exception("该充值单已删除，无法执行取消审核！");
}
}
DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans)
{
_DALRPReceiveBillHeader.UnApprove(argsInTrans, ReceiveBillHeaderID);
//扣减客户收款金额
ReceiveAmount.SetValueWithObject(-ReceiveAmount.Value);
SalesReceiveAmountAdd.SetValueWithObject(-SalesReceiveAmountAdd.Value);
SalesReceiveAmountReduce.SetValueWithObject(-SalesReceiveAmountReduce.Value);
_DALRPReceiveBillHeader.UpdateCustomerReceiveAmount(argsInTrans, CustomerID, ReceiveAmount, SalesReceiveAmountAdd, SalesReceiveAmountReduce);
};
DBHelper.ExecInTrans(args, exec);
}
public void UpdateAmount(FactoryArgs args, t_BigID CustomerID, t_Decimal TotalReceivedAmount, t_Decimal SalesReceivedAmount)
{
TotalReceivedAmount.IsNullToZero();
SalesReceivedAmount.IsNullToZero();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("TotalReceivedAmount", TotalReceivedAmount));
parms.Add(new LBDbParameter("SalesReceivedAmount", SalesReceivedAmount));
string strSQL = @"
update dbo.DbCustomer
set TotalReceivedAmount = @TotalReceivedAmount,
SalesReceivedAmount=@SalesReceivedAmount
where CustomerID = @CustomerID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Insert(FactoryArgs args, out t_BigID ReceiveBillHeaderID, t_String ReceiveBillCode, t_DTSmall BillDate, t_BigID CustomerID, t_Decimal ReceiveAmount,
t_String Description, t_BigID SaleCarInBillID, t_BigID ReceiveBankID, t_ID RPReceiveType,
t_Decimal SalesReceiveAmountAdd, t_Decimal SalesReceiveAmountReduce, t_Decimal OriginalAmount,
t_BigID ChargeTypeID)
{
ReceiveBillHeaderID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReceiveBillHeaderID", ReceiveBillHeaderID, true));
parms.Add(new LBDbParameter("ReceiveBillCode", ReceiveBillCode));
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("ReceiveAmount", ReceiveAmount));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReceiveBankID", ReceiveBankID));
parms.Add(new LBDbParameter("RPReceiveType", RPReceiveType));
parms.Add(new LBDbParameter("CreatedBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("CreateTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("SalesReceiveAmountAdd", SalesReceiveAmountAdd));
parms.Add(new LBDbParameter("SalesReceiveAmountReduce", SalesReceiveAmountReduce));
parms.Add(new LBDbParameter("OriginalAmount", OriginalAmount));
parms.Add(new LBDbParameter("ChargeTypeID", ChargeTypeID));
string strSQL = @"
insert into dbo.RPReceiveBillHeader( ReceiveBillCode, BillDate, CustomerID, ReceiveAmount,
Description,CreatedBy,CreateTime,ChangedBy,ChangeTime,IsApprove,IsCancel,SaleCarInBillID,
ReceiveBankID,RPReceiveType,SalesReceiveAmountAdd,SalesReceiveAmountReduce,OriginalAmount,ChargeTypeID)
values( @ReceiveBillCode, @BillDate, @CustomerID, @ReceiveAmount,
@Description,@CreatedBy,@CreateTime,@ChangedBy,@ChangeTime,0,0,@SaleCarInBillID,
@ReceiveBankID,@RPReceiveType,@SalesReceiveAmountAdd,@SalesReceiveAmountReduce,@OriginalAmount,@ChargeTypeID)
set @ReceiveBillHeaderID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReceiveBillHeaderID.SetValueWithObject(parms["ReceiveBillHeaderID"].Value);
}
public void UpdateCustomerReceiveAmount(FactoryArgs args, t_BigID CustomerID, t_Decimal ReceiveAmount,
t_Decimal SalesReceiveAmountAdd, t_Decimal SalesReceiveAmountReduce)
{
SalesReceiveAmountAdd.IsNullToZero();
SalesReceiveAmountReduce.IsNullToZero();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("ReceiveAmount", ReceiveAmount));
parms.Add(new LBDbParameter("SalesReceiveAmountAdd", SalesReceiveAmountAdd));
parms.Add(new LBDbParameter("SalesReceiveAmountReduce", SalesReceiveAmountReduce));
string strSQL = @"
update dbo.DbCustomer
set TotalReceivedAmount = isnull(TotalReceivedAmount,0)+isnull(@ReceiveAmount,0),
SalesReceivedAmount= isnull(SalesReceivedAmount,0)+@SalesReceiveAmountAdd-@SalesReceiveAmountReduce,
ChangeBy = getdate()
where CustomerID = @CustomerID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Insert(FactoryArgs args, out t_BigID SaleCarReturnBillID, t_String SaleCarReturnBilCode, t_BigID SaleCarInBillID,
t_Decimal TotalWeight)
{
SaleCarReturnBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarReturnBillID", SaleCarReturnBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("TotalWeight", TotalWeight));
parms.Add(new LBDbParameter("SaleCarReturnBilCode", SaleCarReturnBilCode));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
string strSQL = @"
insert SaleCarReturnBill(SaleCarInBillID,SaleCarReturnBilCode,ReturnStatus,TotalWeight,BillDate,CarInTime,CreateBy,CreateTime)
values(@SaleCarInBillID,@SaleCarReturnBilCode,0,@TotalWeight,getdate(),getdate(),@CreateBy,getdate())
set @SaleCarReturnBillID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarReturnBillID.Value = Convert.ToInt64(parms["SaleCarReturnBillID"].Value);
}
public void Update(FactoryArgs args, t_BigID ReceiveBillHeaderID, t_DTSmall BillDate, t_Decimal ReceiveAmount,
t_String Description, t_BigID ReceiveBankID, t_ID RPReceiveType,
t_Decimal SalesReceiveAmountAdd, t_Decimal SalesReceiveAmountReduce, t_Decimal OriginalAmount,
t_BigID ChargeTypeID)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReceiveBillHeaderID", ReceiveBillHeaderID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("ReceiveAmount", ReceiveAmount));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReceiveBankID", ReceiveBankID));
parms.Add(new LBDbParameter("RPReceiveType", RPReceiveType));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("SalesReceiveAmountAdd", SalesReceiveAmountAdd));
parms.Add(new LBDbParameter("SalesReceiveAmountReduce", SalesReceiveAmountReduce));
parms.Add(new LBDbParameter("OriginalAmount", OriginalAmount));
parms.Add(new LBDbParameter("ChargeTypeID", ChargeTypeID));
string strSQL = @"
update dbo.RPReceiveBillHeader
set BillDate = @BillDate,
ReceiveAmount = @ReceiveAmount,
Description = @Description,
ChangedBy = @ChangedBy,
ChangeTime = @ChangeTime,
ReceiveBankID = @ReceiveBankID,
RPReceiveType = @RPReceiveType,
SalesReceiveAmountAdd = @SalesReceiveAmountAdd,
SalesReceiveAmountReduce = @SalesReceiveAmountReduce,
OriginalAmount = @OriginalAmount,
ChargeTypeID = @ChargeTypeID
where ReceiveBillHeaderID = @ReceiveBillHeaderID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Update(FactoryArgs args, t_BigID ModifyBillDetailID, t_BigID ItemID, t_BigID CarID,
t_Decimal Price, t_ID CalculateType, t_BigID UOMID, t_String Description, t_Decimal MaterialPrice, t_Decimal FarePrice,
t_Decimal TaxPrice, t_Decimal BrokerPrice)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ModifyBillDetailID", ModifyBillDetailID));
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("CalculateType", CalculateType));
parms.Add(new LBDbParameter("UOMID", UOMID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("MaterialPrice", MaterialPrice));
parms.Add(new LBDbParameter("FarePrice", FarePrice));
parms.Add(new LBDbParameter("TaxPrice", TaxPrice));
parms.Add(new LBDbParameter("BrokerPrice", BrokerPrice));
string strSQL = @"
update dbo.ModifyBillDetail
set ItemID = @ItemID,
CarID = @CarID,
Price = @Price,
Description = @Description,
CalculateType = @CalculateType,
UOMID = @UOMID,
ChangeBy = @ChangeBy,
ChangeTime = @ChangeTime,
MaterialPrice = @MaterialPrice,
FarePrice = @FarePrice,
TaxPrice = @TaxPrice,
BrokerPrice = @BrokerPrice
where ModifyBillDetailID = @ModifyBillDetailID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Customer_InsertFromService(FactoryArgs args, out t_BigID CustomerID, out t_String CustomerCode, t_String CustomerName, t_String Contact, t_String Phone, t_String Address,
t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType,
t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul,
t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_Decimal TotalReceivedAmount, t_Decimal SalesReceivedAmount, t_String K3CustomerCode,
t_BigID CustomerTypeID)
{
CustomerID = new t_BigID();
CustomerCode = new t_String();
t_BigID CustomerIDTemp = new t_BigID();
t_String CustomerCodeTemp = new t_String();
DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans)
{
this.Customer_Insert(argsInTrans, out CustomerIDTemp, out CustomerCodeTemp, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description,
ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough, K3CustomerCode, CustomerTypeID);
_DALDbCustomer.UpdateAmount(argsInTrans, CustomerIDTemp, TotalReceivedAmount, SalesReceivedAmount);
};
DBHelper.ExecInTrans(args, exec);
CustomerID.Value = CustomerIDTemp.Value;
CustomerCode.Value = CustomerCodeTemp.Value;
}
public void Update(FactoryArgs args, t_BigID ItemID, t_BigID ItemTypeID,
t_String K3ItemCode, 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("K3ItemCode", K3ItemCode));
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,
K3ItemCode = @K3ItemCode,
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 Car_Update(FactoryArgs args, t_BigID CarID, t_String CarNum,
t_BigID CustomerID, t_String Description, t_Decimal DefaultCarWeight,
t_BigID SupplierID, t_BigID CardID)
{
DefaultCarWeight.IsNullToZero();
using (DataTable dtCar = _DALDbCar.GetCarByName(args, CarID, CarNum))
{
if (dtCar.Rows.Count > 0)
{
throw new Exception("该车牌号码已存在！");
}
}
DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans)
{
if (CardID.Value > 0)//取消卡片的车辆关联
{
CancelRefCard(argsInTrans, CardID);
}
_DALDbCar.Car_Update(argsInTrans, CarID, CarNum, Description, DefaultCarWeight, SupplierID, CardID);
};
DBHelper.ExecInTrans(args, exec);
}
