public ResultModel <DeliveryCompanyResultModel> Add(DeliveryCompanyModel deliveryCompanyModel)
{
DeliveryCompanyModel sModel = dao.GetByName(deliveryCompanyModel.DeliveryCompanyName.Trim());
if (sModel == null)
{
int addId = dao.Add(deliveryCompanyModel);
DeliveryCompanyResultModel dcrm = new DeliveryCompanyResultModel();
if (addId > 0)
{
dcrm.Id = addId;
return(ResultModel <DeliveryCompanyResultModel> .Conclude(DeliveryStatus.Success, dcrm));
}
else
{
return(ResultModel <DeliveryCompanyResultModel> .Conclude(DeliveryStatus.Fail, null));
}
}
else
{
return(ResultModel <DeliveryCompanyResultModel> .Conclude(DeliveryStatus.HadExist, null));
}
}
public int Modify(DeliveryCompanyModel deliveryCompanyModel)
{
StringBuilder upSql = new StringBuilder(@"
update dbo.DeliveryCompany
set DeliveryCompanyName = @DeliveryCompanyName ,
IsEnable = @IsEnable ,
SettleType = @SettleType ,
ModifyName = @ModifyName");
if (deliveryCompanyModel.SettleType == 1)
{
upSql.Append(@" ,ClienterSettleRatio = @ClienterSettleRatio,DeliveryCompanyRatio = @DeliveryCompanyRatio ");
}
else
{
upSql.Append(@" ,ClienterFixMoney = @ClienterFixMoney,DeliveryCompanySettleMoney = @DeliveryCompanySettleMoney ");
}
if (deliveryCompanyModel.ClienterSettleRatio != 0 || deliveryCompanyModel.ClienterFixMoney != 0)
{
deliveryCompanyModel.IsDisplay = 1;
}
else
{
deliveryCompanyModel.IsDisplay = 0;
}
upSql.Append(@" ,IsDisplay = @IsDisplay ");
upSql.Append(@"where Id = @Id;");
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.Add("@DeliveryCompanyName", DbType.String).Value = deliveryCompanyModel.DeliveryCompanyName;
dbParameters.Add("@DeliveryCompanyCode", DbType.String).Value = deliveryCompanyModel.DeliveryCompanyCode;
dbParameters.Add("@SettleType", DbType.Int16).Value = deliveryCompanyModel.SettleType;
dbParameters.Add("@IsDisplay", DbType.Int16).Value = deliveryCompanyModel.IsDisplay;
if (deliveryCompanyModel.SettleType == 1)
{
dbParameters.Add("@ClienterSettleRatio", DbType.Decimal).Value = deliveryCompanyModel.ClienterSettleRatio;
dbParameters.Add("@DeliveryCompanyRatio", DbType.Decimal).Value = deliveryCompanyModel.DeliveryCompanyRatio;
dbParameters.Add("@ClienterFixMoney", DbType.Decimal).Value = 0;
dbParameters.Add("@DeliveryCompanySettleMoney", DbType.Decimal).Value = 0;
}
else
{
dbParameters.Add("@ClienterFixMoney", DbType.Decimal).Value = deliveryCompanyModel.ClienterFixMoney;
dbParameters.Add("@DeliveryCompanySettleMoney", DbType.Decimal).Value = deliveryCompanyModel.DeliveryCompanySettleMoney;
dbParameters.Add("@ClienterSettleRatio", DbType.Decimal).Value = 0;
dbParameters.Add("@DeliveryCompanyRatio", DbType.Decimal).Value = 0;
}
dbParameters.Add("@CreateName", DbType.String).Value = deliveryCompanyModel.CreateName;
return(ParseHelper.ToInt(DbHelper.ExecuteNonQuery(SuperMan_Write, upSql.ToString(), dbParameters)));
}
public int Add(DeliveryCompanyModel deliveryCompanyModel)
{
const string insertSql = @"
insert into dbo.DeliveryCompany
( DeliveryCompanyName ,
DeliveryCompanyCode ,
SettleType ,
ClienterFixMoney ,
ClienterSettleRatio ,
DeliveryCompanySettleMoney ,
DeliveryCompanyRatio ,
CreateName ,
IsDisplay
)
values(
@DeliveryCompanyName ,
@DeliveryCompanyCode ,
@SettleType ,
@ClienterFixMoney ,
@ClienterSettleRatio ,
@DeliveryCompanySettleMoney ,
@DeliveryCompanyRatio ,
@CreateName ,
@IsDisplay
)
select @@IDENTITY ";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.Add("@DeliveryCompanyName", DbType.String).Value = deliveryCompanyModel.DeliveryCompanyName;
dbParameters.Add("@DeliveryCompanyCode", DbType.String).Value = deliveryCompanyModel.DeliveryCompanyCode;
dbParameters.Add("@SettleType", DbType.Int16).Value = deliveryCompanyModel.SettleType;
dbParameters.Add("@IsDisplay", DbType.Int16).Value = deliveryCompanyModel.IsDisplay;
if (deliveryCompanyModel.SettleType == 1)
{
dbParameters.Add("@ClienterSettleRatio", DbType.Decimal).Value = deliveryCompanyModel.ClienterSettleRatio;
dbParameters.Add("@DeliveryCompanyRatio", DbType.Decimal).Value = deliveryCompanyModel.DeliveryCompanyRatio;
dbParameters.Add("@ClienterFixMoney", DbType.Decimal).Value = 0;
dbParameters.Add("@DeliveryCompanySettleMoney", DbType.Decimal).Value = 0;
}
else
{
dbParameters.Add("@ClienterFixMoney", DbType.Decimal).Value = deliveryCompanyModel.ClienterFixMoney;
dbParameters.Add("@DeliveryCompanySettleMoney", DbType.Decimal).Value = deliveryCompanyModel.DeliveryCompanySettleMoney;
dbParameters.Add("@ClienterSettleRatio", DbType.Decimal).Value = 0;
dbParameters.Add("@DeliveryCompanyRatio", DbType.Decimal).Value = 0;
}
dbParameters.Add("@CreateName", DbType.String).Value = deliveryCompanyModel.CreateName;
return(ParseHelper.ToInt(DbHelper.ExecuteScalar(SuperMan_Write, insertSql, dbParameters)));
}
public ResultModel <DeliveryCompanyResultModel> Modify(DeliveryCompanyModel deliveryCompanyModel)
{
int modifyResult = dao.Modify(deliveryCompanyModel);
DeliveryCompanyResultModel dcrm = new DeliveryCompanyResultModel();
if (modifyResult > 0)
{
return(ResultModel <DeliveryCompanyResultModel> .Conclude(DeliveryStatus.Success, null));
}
else
{
return(ResultModel <DeliveryCompanyResultModel> .Conclude(DeliveryStatus.Fail, null));
}
}
public ActionResult AddDeliveryCompany(DeliveryCompanyModel deliveryCompanyModel)
{
TryUpdateModel(deliveryCompanyModel);
deliveryCompanyModel.CreateName = UserContext.Current.Name;
if (deliveryCompanyModel.ClienterSettleRatio != 0 || deliveryCompanyModel.ClienterFixMoney != 0)
{
deliveryCompanyModel.IsDisplay = 1;
}
else
{
deliveryCompanyModel.IsDisplay = 0;
}
var result = deliveryCompanyProvider.Add(deliveryCompanyModel);
if (result.Status == 0)
{
return(Json(new ResultModel(true, "成功!"), JsonRequestBehavior.DenyGet));
}
return(Json(new ResultModel(false, result.Message), JsonRequestBehavior.DenyGet));
}
