/// <summary>
/// 功能描述 ： 添加[tblEQI_Query_Group]表的记录
/// 创建者 ： Auto Generator
/// 创建日期 ： 2010-05-28
/// 修改者 ：
/// 修改日期 ：
/// 修改原因 ：
/// </summary>
/// <param name="objInsert">需要添加的实体类</param>
/// <returns>返回新增记录的PK主键的值</returns>
public int Insert(tblEQI_Query_Group objInsert)
{
try
{
usp_tblEQI_Query_Group_Insert uspInsert = new usp_tblEQI_Query_Group_Insert();
uspInsert.ReceiveParameter(objInsert);
uspInsert.ExecNoQuery();
if (uspInsert.fldAutoID > 0)
{
return(uspInsert.fldAutoID);
}
else
{
throw new Exception("插入新记录失败");
}
}
catch (DBOpenException e)
{
throw new InsertException("打开数据库连接失败", "RuletblEQI_Query_Group", "Insert", objInsert.ToString());
}
catch (DBPKException e)
{
throw new InsertPKException("相同的记录已经存在，违反表的唯一键约束", "RuletblEQI_Query_Group", "Insert", objInsert.ToString());
}
catch (DBQueryException e)
{
throw new InsertException("执行Sql语句失败", "RuletblEQI_Query_Group", "Insert", objInsert.ToString());
}
catch (Exception e)
{
throw new InsertException(e.Message, "RuletblEQI_Query_Group", "Insert", objInsert.ToString());
}
}
/// <summary>
/// 功能描述 ： 根据主键取得[tblEQI_Query_Group]表的记录
/// 创建者 ： Auto Generator
/// 创建日期 ： 2010-05-28
/// 修改者 ：
/// 修改日期 ：
/// 修改原因 ：
/// </summary>
/// <param name="iPK">PK主键值</param>
/// <returns>tblEQI_Query_Group</returns>
public tblEQI_Query_Group ByPK(int iPK)
{
try
{
usp_tblEQI_Query_Group_ByPK uspByPK = new usp_tblEQI_Query_Group_ByPK();
uspByPK.fldAutoID = iPK;
DataTable tblData = uspByPK.ExecDataTable();
if (tblData != null)
{
tblEQI_Query_Group objData = new tblEQI_Query_Group();
objData.MetaDataTable = tblData;
return(objData);
}
else
{
throw new Exception("取得单条记录失败，未找到对应的记录");
}
}
catch (DBOpenException e)
{
throw new GetByPKException("打开数据库连接失败", "RuletblEQI_Query_Group", "ByPK", iPK.ToString());
}
catch (DBQueryException e)
{
throw new GetByPKException("执行Sql语句失败", "RuletblEQI_Query_Group", "ByPK", iPK.ToString());
}
catch (Exception e)
{
throw new GetByPKException(e.Message, "RuletblEQI_Query_Group", "ByPK", iPK.ToString());
}
}
/// <summary>
/// 功能描述 ： 更新[tblEQI_Query_Group]表的记录
/// 创建者 ： Auto Generator
/// 创建日期 ： 2010-05-28
/// 修改者 ：
/// 修改日期 ：
/// 修改原因 ：
/// </summary>
/// <param name="objUpdate_old">需要更新的实体类</param>
/// <param name="objUpdate_new">更新后的实体类</param>
/// <returns>true / false</returns>
public bool Update(tblEQI_Query_Group objUpdate_old, tblEQI_Query_Group objUpdate_new)
{
try
{
usp_tblEQI_Query_Group_Update uspUpdate = new usp_tblEQI_Query_Group_Update();
uspUpdate.ReceiveParameter_Old(objUpdate_old);
uspUpdate.ReceiveParameter_New(objUpdate_new);
int iResult = uspUpdate.ExecNoQuery();
if (iResult > 0)
{
return(true);
}
else
{
throw new Exception("更新记录失败，未找到对应的记录");
}
}
catch (DBOpenException e)
{
throw new UpdateException("打开数据库连接失败", "RuletblEQI_Query_Group", "Update",
"objUpdate_old：" + objUpdate_old.ToString() + "；objUpdate_new：" + objUpdate_new.ToString());
}
catch (DBQueryException e)
{
throw new UpdateException("执行Sql语句失败", "RuletblEQI_Query_Group", "Update",
"objUpdate_old：" + objUpdate_old.ToString() + "；objUpdate_new：" + objUpdate_new.ToString());
}
catch (Exception e)
{
throw new UpdateException(e.Message, "RuletblEQI_Query_Group", "Update",
"objUpdate_old：" + objUpdate_old.ToString() + "；objUpdate_new：" + objUpdate_new.ToString());
}
}
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")
});
}
}
/// <summary>
/// 功能描述 ： 根据用户ｉｄ和模块类型取得[tblEQI_Query_Group]表的记录
/// 创建者 ： Auto Generator
/// 创建日期 ： 2010-05-28
/// 修改者 ：
/// 修改日期 ：
/// 修改原因 ：
/// </summary>
/// <param name="iPK">PK主键值</param>
/// <returns>tblEQI_Query_Group</returns>
public IList <tblEQI_Query_Group> GetByUserIDandObject(int UserID, string Object)
{
try
{
DataTable tblData = new DataTable();
usp_tblEQI_Query_Group_ByUserIDandObject uspByUserIDandObject = new usp_tblEQI_Query_Group_ByUserIDandObject();
uspByUserIDandObject.fldUserID = UserID;
uspByUserIDandObject.fldObject = Object;
tblData = uspByUserIDandObject.ExecDataTable();
if (tblData != null)
{
IList <tblEQI_Query_Group> listAll = new List <tblEQI_Query_Group>();
for (int i = 0; i < tblData.Rows.Count; i++)
{
DataTable tblTmp = tblData.Clone();
tblTmp.Rows.Add(tblData.Rows[i].ItemArray);
tblEQI_Query_Group objData = new tblEQI_Query_Group();
objData.MetaDataTable = tblTmp;
listAll.Add(objData);
}
tblData.Dispose();
return(listAll);
}
else
{
throw new Exception("取得记录失败，未找到对应的记录");
}
}
catch (DBOpenException e)
{
throw new GetListException("打开数据库连接失败", "RuletblEQI_Query_Group", "GetByUserIDandObject", "UserID:" + UserID.ToString() + ",Object:" + Object);
}
catch (DBQueryException e)
{
throw new GetListException("执行Sql语句失败", "RuletblEQI_Query_Group", "GetByUserIDandObject", "UserID:" + UserID.ToString() + ",Object:" + Object);
}
catch (Exception e)
{
throw new GetListException(e.Message, "RuletblEQI_Query_Group", "GetByUserIDandObject", "UserID:" + UserID.ToString() + ",Object:" + Object);
}
}
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")
});
}
/// <summary>
/// 功能描述 ： 获得[tblEQI_Query_Group]表的所有记录
/// 创建者 ： Auto Generator
/// 创建日期 ： 2010-05-28
/// 修改者 ：
/// 修改日期 ：
/// 修改原因 ：
/// </summary>
/// <returns>IList<tblEQI_Query_Group></returns>
public IList <tblEQI_Query_Group> GetAllList()
{
try
{
DataTable tblData = new DataTable();
usp_tblEQI_Query_Group_ByAll uspByAll = new usp_tblEQI_Query_Group_ByAll();
tblData = uspByAll.ExecDataTable();
if (tblData != null)
{
IList <tblEQI_Query_Group> listAll = new List <tblEQI_Query_Group>();
for (int i = 0; i < tblData.Rows.Count; i++)
{
DataTable tblTmp = tblData.Clone();
tblTmp.Rows.Add(tblData.Rows[i].ItemArray);
tblEQI_Query_Group objData = new tblEQI_Query_Group();
objData.MetaDataTable = tblTmp;
listAll.Add(objData);
}
return(listAll);
}
else
{
throw new Exception("取得记录失败，未找到对应的记录");
}
}
catch (DBOpenException e)
{
throw new GetListException("打开数据库连接失败", "RuletblEQI_Query_Group", "GetAllList", "");
}
catch (DBQueryException e)
{
throw new GetListException("执行Sql语句失败", "RuletblEQI_Query_Group", "GetAllList", "");
}
catch (Exception e)
{
throw new GetListException(e.Message, "RuletblEQI_Query_Group", "GetAllList", "");
}
}
