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