public HttpResponseMessage GetTemplate(string model, string userid)
{
string returntxt = "";
try
{
RuletblEQI_Query_Group rule_group = new RuletblEQI_Query_Group();
if (rule.IsNmmber(Convert.ToString(userid)))
{
IList <tblEQI_Query_Group> list = rule_group.GetByUserIDandObject(int.Parse(userid), model);
if (list.Count > 0)
{
returntxt = rule.JsonStr("ok", "成功", list);
}
else
{
returntxt = rule.JsonStr("1", "没有数据", list);
}
}
else
{
returntxt = rule.JsonStr("error", "参数错误", "");
}
}
catch (Exception e)
{
returntxt = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(returntxt, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage AddTremGroup(dynamic obj)
{
string returntxt = "";
try
{
tblEQI_Query_Group query_group = new tblEQI_Query_Group();
query_group.fldName = obj.fldName;
query_group.fldObject = obj.fldObject;
query_group.fldTimeType = obj.fldTimeType;
query_group.fldTimeRange = obj.fldTimeRange;
query_group.fldUserID = obj.fldUserID;
query_group.fldItemGroup = obj.fldItemGroup == "" || obj.fldItemGroup == "0" ? "" : Convert.ToString(obj.fldItemGroup);
query_group.fldItemCode = obj.fldItemCode == "" ? "" : obj.fldItemCode;
query_group.fldPointGroup = obj.fldPointGroup == "" || obj.fldPointGroup == "0" ? "" : obj.fldPointGroup;
query_group.fldPointCode = obj.fldPointCode == "" ? "" : obj.fldPointCode;
query_group.fldSource = obj.fldSource;
query_group.fldDataType = obj.fldDataType;
query_group.fldSampleType = obj.fldSampleType;
RuletblEQI_Query_Group rule_group = new RuletblEQI_Query_Group();
int returnID = rule_group.Insert(query_group);
if (returnID == 9999)
{
returntxt = rule.JsonStr("no", "相同名称的分组已经存在,请输入其它名称", returnID);
}
if (returnID > 0 && returnID != 9999)
{
returntxt = rule.JsonStr("ok", "添加成功！", returnID);
}
if (returnID < 0)
{
returntxt = rule.JsonStr("error", "添加失败！", 0);
}
return(new HttpResponseMessage {
Content = new StringContent(returntxt, System.Text.Encoding.UTF8, "application/json")
});
}
catch (Exception ex)
{
returntxt = rule.JsonStr("error", ex.Message, 0);
return(new HttpResponseMessage {
Content = new StringContent(returntxt, System.Text.Encoding.UTF8, "application/json")
});
}
}
public HttpResponseMessage DelTremGroup(string id)
{
string returntxt = "";
try
{
RuletblEQI_Query_Group rule_group = new RuletblEQI_Query_Group();
if (rule_group.Delete(int.Parse(id)))
{
returntxt = rule.JsonStr("ok", "删除成功！", 0);
}
}
catch (Exception ex)
{
returntxt = rule.JsonStr("error", ex.Message, 1);
}
return(new HttpResponseMessage {
Content = new StringContent(returntxt, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage updateTremGroup(dynamic obj)
{
string returntxt = "";
try
{
RuletblEQI_Query_Group rule_group = new RuletblEQI_Query_Group();
tblEQI_Query_Group query_group_old = rule_group.ByPK(Convert.ToInt32(obj.fldAutoID));
tblEQI_Query_Group query_group = new tblEQI_Query_Group();
query_group.fldName = query_group_old.fldName;
query_group.fldObject = query_group_old.fldObject;
query_group.fldTimeType = obj.fldTimeType;
query_group.fldTimeRange = obj.fldTimeRange;
query_group.fldUserID = obj.fldUserID;
query_group.fldItemGroup = obj.fldItemGroup;
query_group.fldItemCode = obj.fldItemCode;
query_group.fldPointGroup = obj.fldPointGroup;
query_group.fldPointCode = obj.fldPointCode;
query_group.fldSource = obj.fldSource;
query_group.fldDataType = obj.fldDataType;
query_group.fldSampleType = obj.fldSampleType;
if (rule_group.Update(query_group_old, query_group))
{
returntxt = rule.JsonStr("ok", "更新成功！", 0);
}
else
{
returntxt = rule.JsonStr("error", "更新失败！", 0);
}
}
catch (Exception e)
{
returntxt = rule.JsonStr("error", e.Message, 0);
}
return(new HttpResponseMessage {
Content = new StringContent(returntxt, System.Text.Encoding.UTF8, "application/json")
});
}
