//插入数据 public int Insert(line_info obj) { try { //string sql = "Insert into fimp.line_info(plant_id,dept_id,unit_no,line_name_en,line_name_tw,line_name_cn,story,status_no)values({0},-1,'{1}','{2}',N'{3}',N'{4}',N'{5}','{6}')"; //sql = string.Format(sql, obj.plant_id, obj.unit_no, obj.line_name_en, obj.line_name_tw, obj.line_name_cn, obj.story, obj.status_no); int count = PostgreHelper.InsertSingleEntity <line_info>(obj); return(count); } catch (Exception ex) { throw ex; } }
//更新数据 public int Update(line_info obj) { try { string sql = "Update fimp.line_info set plant_id='{0}',unit_no='{1}',line_name_en='{2}',line_name_tw=N'{3}',line_name_cn=N'{4}',story=N'{5}',status_no='{6}' where line_id={7}"; sql = string.Format(sql, obj.plant_id, obj.unit_no, obj.line_name_en, obj.line_name_tw, obj.line_name_cn, obj.story, obj.status_no, obj.line_id); int count = PostgreHelper.ExecuteNonQuery(sql); return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 通过名称查询单笔数据 /// </summary> /// <param name="line_name_en"></param> /// <returns></returns> public line_info SelectByName(string line_name_en) { try { line_info obj = new line_info(); string sql = "SELECT plant_id,unit_no,line_id,line_name_en,line_name_tw,line_name_cn,story,status_no FROM fimp.line_info where line_name_en='{0}' order by plant_id,unit_no"; sql = string.Format(sql, line_name_en); obj = PostgreHelper.GetSingleEntity <line_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public int Update(line_info obj) { int count = LIS.Update(obj); return(count); }
public int Insert(line_info obj) { int count = LIS.Insert(obj); return(count); }
public line_info SelectSingle(int id) { line_info obj = LIS.SelectSingle(id); return(obj); }