private void DeleteInputTag(HttpContext context)
{
HttpRequest Request = context.Request;
HttpResponse Response = context.Response;
Msg msg;
try {
InputTagEntity InputTag = new InputTagEntity {
InputID = Request.Params["InputID"],
InputCode = Request.Params["InputCode"],
InputDesc = Request.Params["InputDesc"],
InputEngunit = Request.Params["InputEngunit"]
};
m_DataAccess.DeleteInputTag(InputTag);
msg = new Msg {
Status = "ok",
Message = "数据删除成功！"
};
}
catch (Exception ex) {
msg = new Msg {
Status = "error",
Message = "数据删除失败！错误信息：" + ex.Message,
StackTrace = ex.StackTrace
};
}
Response.Write(JsonConvert.SerializeObject(msg));
}
///// <summary>
///// 通过主键得到实体对象
///// </summary>
///// <param name="MainID">主键</param>
///// <param name="SetSnapShot">是否设置测点实时值</param>
///// <returns></returns>
//public static string GetTagID(string TagName, string UnitID)
//{
// KPI_InputTagEntity entity = new KPI_InputTagEntity();
// string sql = "select * from KPI_InputTag where TagName='{0}'";
// sql = string.Format(sql, TagName);
// if (UnitID != "")
// {
// sql += " and UnitID='" + UnitID + "' ";
// }
// DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0];
// if (dt.Rows.Count > 0)
// entity.DrToMember(dt.Rows[0]);
// return entity.TagID;
//}
/// <summary>
/// 通过主键得到实体对象
/// </summary>
/// <param name="MainID">主键</param>
/// <param name="SetSnapShot">是否设置测点实时值</param>
/// <returns></returns>
public static InputTagEntity GetEntity(string InputID)
{
InputTagEntity entity = new InputTagEntity();
string sql = "select * from KPI_InputTag where InputID='{0}'";
sql = string.Format(sql, InputID);
DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0];
if (dt.Rows.Count > 0)
{
entity.DrToMember(dt.Rows[0]);
}
return(entity);
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// 获得与主键对应的实体对象
/// </summary>
/// <returns></returns>
public static List <InputTagEntity> GetAllEntity()
{
List <InputTagEntity> ltInputs = new List <InputTagEntity>();
string sql = "select * from KPI_InputTag";
DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
InputTagEntity entity = new InputTagEntity();
entity.DrToMember(dr);
ltInputs.Add(entity);
}
return(ltInputs);
}
private void SaveInputTag(HttpContext context)
{
HttpRequest Request = context.Request;
HttpResponse Response = context.Response;
Msg msg;
try {
InputTagEntity InputTag = new InputTagEntity {
InputID = Request.Params["InputID"],
InputCode = Request.Params["InputCode"],
InputDesc = Request.Params["InputDesc"],
InputEngunit = Request.Params["InputEngunit"],
InputIndex = String.IsNullOrWhiteSpace(Request.Params["InputIndex"]) ? 1 : Convert.ToInt32(Request.Params["InputIndex"]),
InputType = String.IsNullOrWhiteSpace(Request.Params["InputType"]) ? 1 : Convert.ToInt32(Request.Params["InputType"])
};
bool Successed = m_DataAccess.SaveInputTag(InputTag) > 0;
msg = new Msg {
Status = "ok",
Message = "数据保存成功！"
};
if (!Successed)
{
msg = new Msg {
Status = "error",
Message = "数据保存失败！"
};
}
}
catch (Exception ex) {
msg = new Msg {
Status = "error",
Message = "数据保存失败！错误信息：" + ex.Message,
StackTrace = ex.StackTrace
};
}
Response.Write(JsonConvert.SerializeObject(msg));
}
