public bool Update(UserInfo user, Model.WaterService.FireFightingInfo fireFighting, List <AttachmentInfo> list)
{
var sb = new StringBuilder();
if (fireFighting != null)
{
sb.AppendFormat("update WaterService.fireFightingInfo set GenreId={0},TypeId={1},Caliber={2},Lat={3},Lon={4},Modify='{5}',ModifyDate='{6}',fireFightingCode='{7}',fireFightingName='{8}' where fireFightingId={9};", fireFighting.GenreId, fireFighting.TypeId, fireFighting.Caliber, fireFighting.Lat, fireFighting.Lon, fireFighting.Modify, fireFighting.ModifyDate.ToString("yyyy-MM-dd HH:mm:ss"), fireFighting.FireFightingCode, fireFighting.FireFightingName, fireFighting.FireFightingId);
new AttachmentManager().AddList(list, fireFighting.FireFightingId, fireFighting.Create, fireFighting.CreateDate, fireFighting.GenreId);
}
new UserManage().UpDate_WaterService_UserInfo(user);
if (sb.Length > 1)
{
return(new MySqlHelper().ExcuteNonQuery(sb.ToString()) > 0);
}
else
{
return(false);
}
}
public int Add(UserInfo user, Model.WaterService.FireFightingInfo fireFighting, List <AttachmentInfo> list)
{
var sb = new StringBuilder();
sb.AppendFormat("insert into WaterService.fireFightingInfo(fireFightingCode,fireFightingName,TypeId,GenreId,Caliber,Lat,Lon,`Create`,CreateDate) values('{0}','{1}',{2},{3},{4},{5},{6},'{7}','{8}');select @@IDENTITY;", fireFighting.FireFightingCode, fireFighting.FireFightingName, fireFighting.TypeId, fireFighting.GenreId, fireFighting.Caliber, fireFighting.Lat, fireFighting.Lon, user.Create, fireFighting.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"));
var id = int.Parse(new MySqlHelper().ExecuteScalar(sb.ToString()).ToString());
new UserManage().Add_WaterService_UserInfo(user, id);
new AttachmentManager().AddList(list, id, user.Create, user.CreateDate, fireFighting.GenreId);
new MaintenanceManager().Add(new MaintenanceInfo()
{
MeterId = int.Parse(id.ToString()),
GenreId = fireFighting.GenreId,
TypeId = fireFighting.TypeId,
Create = user.Create,
CreateDate = DateTime.Now,
InstallTime = DateTime.Now,
});
return(id);
}
public int Add(Model.WaterService.UserInfo user, Model.WaterService.FireFightingInfo fireFightingInfo, List <Model.WaterService.AttachmentInfo> list)
{
return(_dal.Add(user, fireFightingInfo, list));
}