public FrmEditOperation()
{
InitializeComponent();
OperationValue = new OperationInfo
{
OperationDate = DateTime.Now
};
}
public long AddOperationInfo(OperationInfo model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into OperationInfo(");
stringBuilder.Append("PatientId,OperationDate,Surgeon,Note,OperationName)");
stringBuilder.Append(" values (");
stringBuilder.Append("@PatientId,@OperationDate,@Surgeon,@Note,@OperationName)");
stringBuilder.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@PatientId", DbType.Int64),
new SQLiteParameter("@OperationDate", DbType.Date),
new SQLiteParameter("@Surgeon", DbType.String),
new SQLiteParameter("@Note", DbType.String),
new SQLiteParameter("@OperationName", DbType.String)
};
array[0].Value = model.PatientId;
array[1].Value = model.OperationDate;
array[2].Value = model.Surgeon;
array[3].Value = model.Note;
array[4].Value = model.OperationName;
object single = DbHelperSQLite.GetSingle(stringBuilder.ToString(), array);
return Convert.ToInt64(single);
}
public List<OperationInfo> QueryOperationInfo(long patientId)
{
List<OperationInfo> list = new List<OperationInfo>();
string strSQL = string.Format("SELECT * FROM OperationInfo where PatientId={0}", patientId);
using (DbDataReader dbDataReader = DbHelperSQLite.ExecuteReader(strSQL))
{
while (dbDataReader.Read())
{
OperationInfo operationInfo = new OperationInfo();
object obj = dbDataReader["OperationId"];
if (obj != null && obj != DBNull.Value)
{
operationInfo.OperationId = Convert.ToInt64(obj);
}
obj = dbDataReader["PatientId"];
if (obj != null && obj != DBNull.Value)
{
operationInfo.PatientId = Convert.ToInt64(obj);
}
obj = dbDataReader["OperationDate"];
if (obj != null && obj != DBNull.Value)
{
operationInfo.OperationDate = (DateTime)obj;
}
operationInfo.Surgeon = dbDataReader["Surgeon"].ToString();
operationInfo.Note = dbDataReader["Note"].ToString();
operationInfo.OperationName = dbDataReader["OperationName"].ToString();
list.Add(operationInfo);
}
}
return list;
}
public bool EditOperationInfo(OperationInfo model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update OperationInfo set ");
stringBuilder.Append("PatientId=@PatientId,");
stringBuilder.Append("OperationDate=@OperationDate,");
stringBuilder.Append("Surgeon=@Surgeon,");
stringBuilder.Append("Note=@Note,");
stringBuilder.Append("OperationName=@OperationName");
stringBuilder.Append(" where OperationId=@OperationId");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@PatientId", DbType.Int64),
new SQLiteParameter("@OperationDate", DbType.Date),
new SQLiteParameter("@Surgeon", DbType.String),
new SQLiteParameter("@Note", DbType.String),
new SQLiteParameter("@OperationName", DbType.String),
new SQLiteParameter("@OperationId", DbType.Int64)
};
array[0].Value = model.PatientId;
array[1].Value = model.OperationDate;
array[2].Value = model.Surgeon;
array[3].Value = model.Note;
array[4].Value = model.OperationName;
array[5].Value = model.OperationId;
int num = DbHelperSQLite.ExecuteSql(stringBuilder.ToString(), array);
return num > 0;
}
