public bool Add_WaterService_UserInfo(Model.WaterService.UserInfo user, object id)
{
var sb = new StringBuilder();
sb.AppendFormat("insert into WaterService.UserInfo(UserName,UserAddress,UserPhone,MeterId,Remark,`Create`,CreateDate,UserCode) values('{0}','{1}','{2}',{6},'{3}','{4}','{5}','{7}');", user.UserName, user.UserAddress, user.UserPhone, user.Remark, user.Create, user.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), id, user.UserCode);
return(new MySqlHelper().ExcuteNonQuery(sb.ToString()) > 0);
}
public bool UpDate_WaterService_UserInfo(Model.WaterService.UserInfo user)
{
bool flag = false;
if (user != null)
{
var sb = new StringBuilder();
sb.AppendFormat("update WaterService.UserInfo set UserCode='{7}', UserName='******',UserAddress='{1}',UserPhone='{2}',Remark ='{3}',Modify='{4}',ModifyDate='{5}' where UserId={6};", user.UserName, user.UserAddress, user.UserPhone, user.Remark, user.Modify, user.ModifyDate.ToString("yyyy-MM-dd HH:mm:ss"), user.UserId, user.UserCode);
flag = new MySqlHelper().ExcuteNonQuery(sb.ToString()) > 0;
}
return(flag);
}
public int Add(Model.WaterService.UserInfo user, Model.WaterService.FireFightingInfo fireFightingInfo, List <Model.WaterService.AttachmentInfo> list)
{
return(_dal.Add(user, fireFightingInfo, list));
}
public int Add(Model.WaterService.UserInfo user, Model.WaterService.ValveInfo valve, List <Model.WaterService.AttachmentInfo> list)
{
return(_dal.Add(user, valve, list));
}
public int Add(Model.WaterService.UserInfo user, Model.WaterService.ExhaustInfo exhaust, List <Model.WaterService.AttachmentInfo> list)
{
return(dal.Add(user, exhaust, list));
}
