public int AddPatientInfo(Patient patientInfo) { int strResult = 0; #region 插入数据语句 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Patient]("); strSql.Append("Name,IDCode,SignDate) "); strSql.Append(" values ("); strSql.Append("@name,@idcode,@signdate)"); OleDbParameter[] parameters = { new OleDbParameter("@name", OleDbType.WChar, 50), new OleDbParameter("@idcode", OleDbType.WChar, 50), new OleDbParameter("@signdate", OleDbType.Date) }; parameters[0].Value = patientInfo.Name; parameters[1].Value = patientInfo.IDCode; parameters[2].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); #endregion try { strResult = OLEDBHelper.ExecuteSql(strSql.ToString(), parameters); return(strResult); } catch (Exception ex) { return(strResult); } }
public int EditPatientInfo(Patient patientInfo) { int strResult = 0; #region 更新数据语句 StringBuilder strSql = new StringBuilder(); strSql.Append("update [Patient] "); strSql.Append("set Name=@name,IDCode=@idcode,ModifyDate=@modifydate "); strSql.Append(" where ID=@id "); OleDbParameter[] parameters = { new OleDbParameter("@name", OleDbType.WChar, 50), new OleDbParameter("@idcode", OleDbType.WChar, 50), new OleDbParameter("@modifydate", OleDbType.Date), new OleDbParameter("@id", OleDbType.Integer) }; parameters[0].Value = patientInfo.Name; parameters[1].Value = patientInfo.IDCode; parameters[2].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); parameters[3].Value = patientInfo.ID; #endregion try { strResult = OLEDBHelper.ExecuteSql(strSql.ToString(), parameters); return(strResult); } catch (Exception ex) { return(strResult); } }
public System.Data.DataTable GetPatientByID(string PatientID) { string strSql = "select * from [Patient] where id=" + PatientID; try { DataSet ds = OLEDBHelper.Query(strSql); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } } catch (Exception ex) { throw ex; return(null); } }
public DataTable GetPatientList() { string strSql = "select * from [Patient] "; try { DataSet ds = OLEDBHelper.Query(strSql); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } } catch (Exception ex) { throw ex; return(null); } }