/// <summary> /// 执行插入人员信息方法 /// </summary> /// <param name="obj"></param> /// <returns>影响行数</returns> public int Insert(material_category obj) { try { string sql = "insert into fimp.material_category(type_code,type_name,unit_no,line_id,remark,createtime)values('{0}','{1}','{2}',{3},'{4}','{5}')"; sql = string.Format(sql, obj.type_code, obj.type_name, obj.unit_no, obj.line_id, obj.remark, DateTime.Now.AddHours(GlobalDefine.SysTimeZone)); int count = PostgreHelper.ExecuteNonQuery(sql); return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新信息 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Update(material_category obj) { try { int count = 0; string sql = "update fimp.material_category set type_code='{0}',type_name='{1}',unit_no='{2}',line_id={3},remark='{4}',createtime='{5}' where id={6}"; sql = string.Format(sql, obj.type_code, obj.type_name, obj.unit_no, obj.line_id, obj.remark, DateTime.Now.AddHours(GlobalDefine.SysTimeZone), obj.id); count = PostgreHelper.ExecuteNonQuery(sql); return(count); } catch (Exception ex) { throw ex; } }
public material_category SelectSingleID(int area_id) { try { material_category obj = new material_category(); string sql = "select * from fimp.material_category where id={0}"; sql = string.Format(sql, area_id); obj = PostgreHelper.GetSingleEntity <material_category>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public int Update(material_category obj) { int count = AIS.Update(obj); return(count); }
public int Insert(material_category obj) { int count = AIS.Insert(obj); return(count); }
public material_category SelectSingleID(int id) { material_category obj = AIS.SelectSingleID(id); return(obj); }