public bool Update(UserInfo user, WaterMeterInfo water, List <AttachmentInfo> list) { var sb = new StringBuilder(); if (water != null) { sb.AppendFormat("update WaterService.WaterMeterInfo set GenreId={0},TypeId={1},Caliber={2},Lat={3},Lon={4},Modify='{5}',ModifyDate='{6}',WaterCode='{7}',WaterName='{8}',Acreage={10} where WaterId={9};", water.GenreId, water.TypeId, water.Caliber, water.Lat, water.Lon, water.Modify, water.ModifyDate.ToString("yyyy-MM-dd HH:mm:ss"), water.WaterMeterCode, water.WaterMeterName, water.WaterMeterId, water.Acreage); new AttachmentManager().AddList(list, water.WaterMeterId, water.Create, DateTime.Now, water.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, WaterMeterInfo water, List <AttachmentInfo> list) { var sb = new StringBuilder(); sb.AppendFormat("insert into WaterService.WaterMeterInfo(WaterCode,WaterName,TypeId,GenreId,Caliber,Lat,Lon,`Create`,CreateDate,Acreage) values('{0}','{1}',{2},{3},{4},{5},{6},'{7}','{8}',{9});select @@IDENTITY;", water.WaterMeterCode, water.WaterMeterName, water.TypeId, water.GenreId, water.Caliber, water.Lat, water.Lon, user.Create, water.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), water.Acreage); 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, water.GenreId); new MaintenanceManager().Add(new MaintenanceInfo() { MeterId = int.Parse(id.ToString()), GenreId = water.GenreId, TypeId = water.TypeId, Create = user.Create, CreateDate = DateTime.Now, InstallTime = DateTime.Now, }); return(id); }
public bool Update(UserInfo user, WaterMeterInfo water, List <AttachmentInfo> list) { return(_dal.Update(user, water, list)); }
public int Add(UserInfo user, WaterMeterInfo water, List <AttachmentInfo> list) { return(_dal.Add(user, water, list)); }