//根据记录id修改状态和备注 public int updateStatusAndRemarkById(string _id, string _status, string _remark, string _operate) { string sql = "update changeRecord set status = '" + _status + "',remark = '" + _remark + "',operate ='" + _operate + "' where id =" + _id; return(DBOperater.executeSql(sql)); }
//新增一条排班表修改记录 public int insertChangeRecord(int _arrangementId_self, int _arrangementId_others, string _remark, string _status) { string sql = "insert into changeRecord(arrangementId_self,arrangementId_others,remark,status) values ('" + _arrangementId_self + "','" + _arrangementId_others + "','" + _remark + "','" + _status + "')"; return(DBOperater.executeSql(sql)); }
/// <summary> /// 按照id修改排班表记录 /// </summary> /// <param name="_id">string id</param> /// <param name="_beginTime">DateTime begibTime</param> /// <param name="_finishTime">DateTime finshTime</param> /// <param name="_doctorId">string doctorId</param> /// <param name="_office">string office</param> /// <param name="_doctorName"> string doctorName</param> /// <param name="_doctorJobTitle">string doctorJobTitle</param> /// <returns>int flag</returns> public int updateAllById(string _id, DateTime _beginTime, DateTime _finishTime, string _doctorId, string _office, string _doctorName, string _doctorJobTitle) { string sql = "update arrangement set beginTime = '" + _beginTime + "',finishTime = '" + _finishTime + "',doctorId = " + _doctorId + ",office = '" + _office + "',doctorName = '" + _doctorName + "',doctorJobTitle = '" + _doctorJobTitle + "' where id = " + _id; return(DBOperater.executeSql(sql)); }
/// <summary> /// 新增排班表记录 /// </summary> /// <param name="_id"></param> /// <param name="_beginTime"></param> /// <param name="_finishTime"></param> /// <param name="_doctorId"></param> /// <param name="_office"></param> /// <param name="_doctorName"></param> /// <param name="_doctorJobTitle"></param> /// <returns>int flag</returns> public int insertArrangement(DateTime _beginTime, DateTime _finishTime, string _doctorId, string _office, string _doctorName, string _doctorJobTitle) { string sql = "insert into arrangement(beginTime,finishTime,doctorId,office,doctorName,doctorJobTitle) values ( '" + _beginTime + "','" + _finishTime + "'," + _doctorId + ",'" + _office + "','" + _doctorName + "','" + _doctorJobTitle + "')"; return(DBOperater.executeSql(sql)); }
/// <summary> /// 按照排班表id删除排班记录 /// </summary> /// <param name="_id">string id</param> /// <returns>int flag</returns> public int deleteAllById(string _id) { string sql = "delete from arrangement where id = " + _id; return(DBOperater.executeSql(sql)); }