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)); }