public int Bus_FeeticketInsertOrUpdate(Bus_Feeticket businfo)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalBus_Feeticket(sql);
int result = internalData.Bus_FeeticketInsertOrUpdate(businfo);
return(result);
}
catch
{
throw;
}
}
}
//编辑大巴车免费券
internal int Bus_FeeticketInsertOrUpdate(Bus_Feeticket businfo)
{
string sql = "insert Bus_Feeticket (comid,Title,Feeday,Stardate,Enddate,Iuse)values(@comid,@Title,@Feeday,@Startime,@Endtime,@Iuse)";
if (businfo.Id != 0)//如果有ID不为0则为修改
{
sql = "update Bus_Feeticket set Title=@Title,Feeday=@Feeday,Stardate=@Startime,Enddate=@Endtime,Iuse=@Iuse where id =@id ";
}
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", businfo.Id);
cmd.AddParam("@Title", businfo.Title);
cmd.AddParam("@Feeday", businfo.Feeday);
cmd.AddParam("@Startime", businfo.Startime);
cmd.AddParam("@Endtime", businfo.Endtime);
cmd.AddParam("@comid", businfo.Comid);
cmd.AddParam("@Iuse", businfo.Iuse);
return(cmd.ExecuteNonQuery());
}
