/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AMS.Model.AMS_Campus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AMS_Campus set ");
strSql.Append("Number=@Number,");
strSql.Append("SchoolId=@SchoolId,");
strSql.Append("Name=@Name,");
strSql.Append("Describe=@Describe");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Number", SqlDbType.NVarChar, 50),
new SqlParameter("@SchoolId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Describe", SqlDbType.NVarChar, 500),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.Number;
parameters[1].Value = model.SchoolId;
parameters[2].Value = model.Name;
parameters[3].Value = model.Describe;
parameters[4].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(AMS.Model.AMS_Campus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMS_Campus(");
strSql.Append("Number,SchoolId,Name,Describe)");
strSql.Append(" values (");
strSql.Append("@Number,@SchoolId,@Name,@Describe)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Number", SqlDbType.NVarChar, 50),
new SqlParameter("@SchoolId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Describe", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.Number;
parameters[1].Value = model.SchoolId;
parameters[2].Value = model.Name;
parameters[3].Value = model.Describe;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 把学校信息转换为可以显示的信息
/// </summary>
/// <param name="campus"></param>
public void ShowCampusDetail(AMS.Model.AMS_Campus campus)
{
CampusInfo campusDetail = new CampusInfo();
campusDetail.Id = campus.Id;
campusDetail.Name = campus.Name;
campusDetail.Number = campus.Number;
campusDetail.Address = campus.Address;
campusDetail.DeviceCount = campus.Device.Count;
this.CampusDetail = campusDetail;
}
/// <summary>
/// 显示设备list信息
/// </summary>
/// <param name="campus"></param>
public void ShowDeviceList(AMS.Model.AMS_Campus campus)
{
List <DeviceInfo> devices = new List <DeviceInfo>();
foreach (AMS.Model.AMS_Device d in campus.Device)
{
DeviceInfo di = new DeviceInfo();
di.Id = d.Id;
di.IsDelete = d.IsDel == true ? "停用" : "启用";
di.Number = d.Number;
di.Status = d.Flag == true ? "未获取" : "已更新";
di.Describe = d.Describe;
di.CaputrePath = d.CaputrePath;
di.CaputreTime = d.CaputreTime;
devices.Add(di);
}
DeviceList = devices;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AMS.Model.AMS_Campus GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Number,SchoolId,Name,Describe from AMS_Campus ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
AMS.Model.AMS_Campus model = new AMS.Model.AMS_Campus();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Number"] != null && ds.Tables[0].Rows[0]["Number"].ToString() != "")
{
model.Number = ds.Tables[0].Rows[0]["Number"].ToString();
}
if (ds.Tables[0].Rows[0]["SchoolId"] != null && ds.Tables[0].Rows[0]["SchoolId"].ToString() != "")
{
model.SchoolId = int.Parse(ds.Tables[0].Rows[0]["SchoolId"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Describe"] != null && ds.Tables[0].Rows[0]["Describe"].ToString() != "")
{
model.Describe = ds.Tables[0].Rows[0]["Describe"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获取实体对象
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public Model.AMS_Campus GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Number,SchoolId,Name,Describe from AMS_Campus ");
if (!string.IsNullOrEmpty(strWhere) && strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
AMS.Model.AMS_Campus model = new AMS.Model.AMS_Campus();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Number"] != null && ds.Tables[0].Rows[0]["Number"].ToString() != "")
{
model.Number = ds.Tables[0].Rows[0]["Number"].ToString();
}
if (ds.Tables[0].Rows[0]["SchoolId"] != null && ds.Tables[0].Rows[0]["SchoolId"].ToString() != "")
{
model.SchoolId = int.Parse(ds.Tables[0].Rows[0]["SchoolId"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Describe"] != null && ds.Tables[0].Rows[0]["Describe"].ToString() != "")
{
model.Describe = ds.Tables[0].Rows[0]["Describe"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 删除校区信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static string DeleteCampusInfo(AMS.Model.AMS_Campus model)
{
AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel();
try
{
return(bllService.DeleteCampusInfo(model));
}
catch (EndpointNotFoundException ex)
{
throw new AMS.Model.CustomerException("连接服务器失败");
}
catch (CommunicationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
ICommunicationObject ICommObjectService = bllService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
public ViewModelDeviceEditWindow(AMS.Model.AMS_Campus campusModel, AMS.Model.AMS_School schoolModel)
{
CampusModel = campusModel;
SchoolModel = schoolModel;
}
