/// <summary>
/// 修改活动报备单基本信息
/// </summary>
/// <param name="activityFilingInfo"></param>
/// <returns></returns>
public bool UpdateFilingBaseInfo(ActivityFilingInfo activityFilingInfo)
{
const string SQL =
@"UPDATE ActivityFiling SET ActivityFilingTitle=@ActivityFilingTitle, FilingCompanyID=@FilingCompanyID, FilingCompanyName=@FilingCompanyName,
GoodsID=@GoodsID, GoodsCode=@GoodsCode, GoodsName=@GoodsName, ActivityStateDate=@ActivityStateDate, ActivityEndDate=@ActivityEndDate, ActivityFilingState=@ActivityFilingState,
ProspectSaleNumber=@ProspectSaleNumber, NormalSaleNumber=@NormalSaleNumber, FilingTerraceID=@FilingTerraceID, FilingTerraceName=@FilingTerraceName, WarehouseID=@WarehouseID
WHERE id=@ID ";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
ActivityFilingTitle = activityFilingInfo.ActivityFilingTitle,
FilingCompanyID = activityFilingInfo.FilingCompanyID,
FilingCompanyName = activityFilingInfo.FilingCompanyName,
GoodsID = activityFilingInfo.GoodsID,
GoodsCode = activityFilingInfo.GoodsCode,
GoodsName = activityFilingInfo.GoodsName,
ActivityStateDate = activityFilingInfo.ActivityStateDate,
ActivityEndDate = activityFilingInfo.ActivityEndDate,
ProspectSaleNumber = activityFilingInfo.ProspectSaleNumber,
NormalSaleNumber = activityFilingInfo.NormalSaleNumber,
FilingTerraceID = activityFilingInfo.FilingTerraceID,
FilingTerraceName = activityFilingInfo.FilingTerraceName,
WarehouseID = activityFilingInfo.WarehouseID,
ID = activityFilingInfo.ID,
ActivityFilingState = activityFilingInfo.ActivityFilingState,
}) > 0);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="activityFilingInfo"></param>
/// <returns></returns>
public bool InsertActivityFiling(ActivityFilingInfo activityFilingInfo)
{
const string SQL = @"
INSERT into ActivityFiling(ID, ActivityFilingTitle, FilingCompanyID, FilingCompanyName, ActivityFilingState, GoodsID,
GoodsCode, GoodsName, ActivityStateDate, ActivityEndDate, ProspectSaleNumber, ProspectReadyNumber, ActualSaleNumber, NormalSaleNumber,
PurchasePersonnelID, PurchasePersonnelName, CreateDate, FilingTerraceID, FilingTerraceName, OperatePersonnelID, OperatePersonnelName, ErrorProbability,WarehouseID)
VALUES(@ID, @ActivityFilingTitle, @FilingCompanyID, @FilingCompanyName, @ActivityFilingState, @GoodsID, @GoodsCode, @GoodsName, @ActivityStateDate,
@ActivityEndDate, @ProspectSaleNumber, @ProspectReadyNumber, @ActualSaleNumber, @NormalSaleNumber, @PurchasePersonnelID, @PurchasePersonnelName,
@CreateDate, @FilingTerraceID, @FilingTerraceName, @OperatePersonnelID, @OperatePersonnelName, @ErrorProbability,@WarehouseID)";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new {
ID = activityFilingInfo.ID,
ActivityFilingTitle = activityFilingInfo.ActivityFilingTitle,
FilingCompanyID = activityFilingInfo.FilingCompanyID,
FilingCompanyName = activityFilingInfo.FilingCompanyName,
ActivityFilingState = activityFilingInfo.ActivityFilingState,
GoodsID = activityFilingInfo.GoodsID,
GoodsCode = activityFilingInfo.GoodsCode,
GoodsName = activityFilingInfo.GoodsName,
ActivityStateDate = activityFilingInfo.ActivityStateDate,
ActivityEndDate = activityFilingInfo.ActivityEndDate,
ProspectSaleNumber = activityFilingInfo.ProspectSaleNumber,
ProspectReadyNumber = activityFilingInfo.ProspectReadyNumber,
ActualSaleNumber = activityFilingInfo.ActualSaleNumber,
NormalSaleNumber = activityFilingInfo.NormalSaleNumber,
PurchasePersonnelID = activityFilingInfo.PurchasePersonnelID,
PurchasePersonnelName = activityFilingInfo.PurchasePersonnelName,
CreateDate = activityFilingInfo.CreateDate,
FilingTerraceID = activityFilingInfo.FilingTerraceID,
FilingTerraceName = activityFilingInfo.FilingTerraceName,
OperatePersonnelID = activityFilingInfo.OperatePersonnelID,
OperatePersonnelName = activityFilingInfo.OperatePersonnelName,
ErrorProbability = activityFilingInfo.ErrorProbability,
WarehouseID = activityFilingInfo.WarehouseID,
}) > 0);
}
}
