11

#region 获取WCINNER 所有数据
List<WCINNER> WCINNER_GetWCINNERAllList = null;
public List<WCINNER> WCINNER_GetWCINNERAll()
{
string SqlWCINNER_GetWCINNERAllList = "from WCINNER order by id ";
WCINNER_GetWCINNERAllList = dao.query(SqlWCINNER_GetWCINNERAllList).Cast<WCINNER>().ToList<WCINNER>();
return WCINNER_GetWCINNERAllList;
}
#endregion

#region 插入WCINNER 关联表
public int InsertWCINNEREntity(WCINNER WCINNER)
{
IComparable id = dao.Save(WCINNER);
if (id.Equals(-1))
{
return -1;
}
else
{
return Convert.ToInt32(id);
}
}
#endregion

#region 更新
public WCINNER UpdateWCINNERById(int ID, string JID, int GID)
{
try
{
WCINNER WCINNERUpdate = (WCINNER)dao.load("WCINNER", Convert.ToInt64(ID));
WCINNERUpdate.JID = JID;
WCINNERUpdate.GID = GID;

BaseEntity BaseEntity = dao.update(WCINNERUpdate);
WCINNER WCINNER = (WCINNER)BaseEntity;
//dao.update(CWWERINNERUpdate);
return WCINNER;
}
catch
{
return null;
}
}
#endregion

#region 查询 通过语句WCINNER实体
WCINNER WCINNER = null;
public WCINNER SelectWCINNERByWid(string str)
{

IList hqlList = dao.sqlSelect(str);
List<Object> ObjList = hqlList.Cast<Object>().ToList<Object>();
for (int i = 0; i < ObjList.Count; i++)
{
WCINNER = new WCINNER();
WCINNER.Id = Convert.ToInt32(ObjList[0]);
}
return WCINNER;
}
#endregion

#region 删除 WCINNER水厂公司关联表数据
public int DelWCINNERById(int ID)
{
try
{
dao.delete("WCINNER", Convert.ToInt64(ID));
return 1;
}
catch
{
return 0;
}
}
#endregion

return basestandardDao.getEm().createQuery("delete from Basestandard where id=?1").setParameter(1, id).executeUpdate()>0?true:false;

原文地址:https://www.cnblogs.com/meimao5211/p/3615106.html