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);
}
}
