//根据记录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));
}
