public bool Update(UserInfo user, ExhaustInfo exhaust, List <AttachmentInfo> list)
{
var sb = new StringBuilder();
if (exhaust != null)
{
sb.AppendFormat("update waterService.exhaustInfo set GenreId={0},TypeId={1},Caliber={2},Lat={3},Lon={4},Modify='{5}',ModifyDate='{6}',ExhaustCode='{7}',ExhaustName='{8}' where ExhaustId={9};", exhaust.GenreId, exhaust.TypeId, exhaust.Caliber, exhaust.Lat, exhaust.Lon, exhaust.Modify, exhaust.ModifyDate.ToString("yyyy-MM-dd HH:mm:ss"), exhaust.ExhaustCode, exhaust.ExhaustName, exhaust.ExhaustId);
new AttachmentManager().AddList(list, exhaust.ExhaustId, exhaust.Create, DateTime.Now, exhaust.GenreId);
}
new UserManage().UpDate_WaterService_UserInfo(user);
return(new MySqlHelper().ExcuteNonQuery(sb.ToString()) > 0);
}
public int Add(UserInfo user, ExhaustInfo exhaust, List <AttachmentInfo> list)
{
var sb = new StringBuilder();
sb.AppendFormat("insert into waterService.exhaustInfo(ExhaustCode,ExhaustName,TypeId,GenreId,Caliber,Lat,Lon,`Create`,CreateDate) values('{0}','{1}',{2},{3},{4},{5},{6},'{7}','{8}');select @@IDENTITY;", exhaust.ExhaustCode, exhaust.ExhaustName, exhaust.TypeId, exhaust.GenreId, exhaust.Caliber, exhaust.Lat, exhaust.Lon, user.Create, exhaust.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, exhaust.GenreId);
new MaintenanceManager().Add(new MaintenanceInfo()
{
MeterId = int.Parse(id.ToString()),
GenreId = exhaust.GenreId,
TypeId = exhaust.TypeId,
Create = user.Create,
CreateDate = DateTime.Now,
InstallTime = DateTime.Now,
});
return(id);
}
public bool Update(UserInfo user, ExhaustInfo exhaust, List <AttachmentInfo> list)
{
return(dal.Update(user, exhaust, list));
}
