public string QueryResentPatientCount(string DPID, string CreateDate, string DPType)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[3];
sqlpar[0] = new SQLiteParameter("1", DPID);
sqlpar[1] = new SQLiteParameter("2", CreateDate);
sqlpar[2] = new SQLiteParameter("3", DPType);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
string str = sqldb.QueryScalar(SqlTools.SqlQueryRecentPatientCount, sqlpar).ToString();
return(TypeChange.StringToXml("RecentPatientCount", str));
}
}
public string InsertDoctorPatients(string DPID, string DoctorID, string InhosID, string DPType, string CreateDate)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[5];
sqlpar[0] = new SQLiteParameter("1", DPID);
sqlpar[1] = new SQLiteParameter("2", DoctorID);
sqlpar[2] = new SQLiteParameter("3", InhosID);
sqlpar[3] = new SQLiteParameter("4", DPType);
sqlpar[4] = new SQLiteParameter("5", CreateDate);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
string str = sqldb.Execute(SqlTools.SqlInsertDoctorPatients, sqlpar) > 0 ? "true" : "false";
//string a = TypeChange.StringToXml("isInsert", str);
return(TypeChange.StringToXml("isInsert", str));
}
}