//更新数据 public int Update(material_request_info obj) { try { int count = 0; if (obj.depot_ack_time < Convert.ToDateTime("2000-01-01 00:00:00")) { string sql = "Update fimp.material_request_info set take_person_id={0}, take_time='{1}' where id={2}"; sql = string.Format(sql, obj.take_person_id, obj.take_time, obj.id); count = PostgreHelper.ExecuteNonQuery(sql); } else { string sql = "Update fimp.material_request_info set depot_ack_time='{0}' where id={1}"; sql = string.Format(sql, obj.depot_ack_time, obj.id); count = PostgreHelper.ExecuteNonQuery(sql); } return(count); } catch (Exception ex) { throw ex; } }
//插入数据 public int Insert(material_request_info obj) { try { string sql = "Insert into fimp.material_request_info(material_id,station_id,request_person_id,work_order,part_num,request_count,take_person_id,take_time,remark,createtime FROM fimp.material_request_info)values({0},{1},{2},N'{3}',N'{4}',{5},{6},'{7}','{8}','{9}')"; sql = string.Format(sql, obj.material_id, obj.station_id, obj.request_person_id, obj.work_order, obj.part_num, obj.request_count, obj.take_person_id, obj.take_time, obj.remark, obj.createtime); //int count = PostgreHelper.ExecuteNonQuery(sql); int count = PostgreHelper.InsertSingleEntity <material_request_info>(obj); return(count); } catch (Exception ex) { throw ex; } }
//查询所有material_request_info public material_request_info SelectById(int id) { try { material_request_info obj = new material_request_info(); string sql = "SELECT id, material_id,station_id,request_person_id,work_order,part_num,request_count,take_person_id,take_time,remark,createtime FROM fimp.material_request_info where id ={0}"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <material_request_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 物料呼叫增加 /// </summary> /// <param name="materialID">物料id</param> /// <param name="count">数量</param> /// <param name="stationId">站位id</param> /// <param name="part_num">机种</param> /// <param name="work_order">工单</param> public bool AddMaterialRequest(int materialID, int count, int stationId, string part_num = "", string work_order = "") { material_request_info request_Info = new material_request_info(); var list = SelectUnfinishedRequestInfo(materialID, stationId); if (list == null || list.Count == 0) { request_Info.station_id = stationId; request_Info.createtime = DateTime.Now.AddHours(GlobalDefine.SysTimeZone); request_Info.request_count = count; request_Info.material_id = materialID; request_Info.part_num = part_num; //机种 request_Info.work_order = work_order; //工单 Insert(request_Info); return(true); } return(false); }
public int Update(material_request_info obj) { int count = MRIS.Update(obj); return(count); }
public int Insert(material_request_info obj) { int count = MRIS.Insert(obj); return(count); }
public material_request_info SelectById(int id) { material_request_info objList = MRIS.SelectById(id); return(objList); }