public string AccDelete(string rdn, string deletePerson)
{
string result = "";
try
{
SqlConnect conn = new SqlConnect();
SqlParameter p1 = new SqlParameter("@rdn", rdn);
SqlParameter p2 = new SqlParameter("@deletePerson", deletePerson);
string[] paramNames = new string[2];
string[] paramValues = new string[2];
paramNames[0] = "@rdn";
paramNames[1] = "@deletePerson";
paramValues[0] = rdn;
paramValues[1] = deletePerson;
int n = conn.ExcuteUpdateCmd("acc_delete", paramNames, paramValues);
if (n >= 0)
{
result = "ok";
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public string saveBrifeInfo(string checkperson, string checkdate, string checkstair, string tablerdn, string tablename, string tabletype, string tablescore, GridView gv)
{
string[] paramNames = new string[7];
string[] paramValues = new string[7];
paramNames[0] = "@checkPerson";
paramNames[1] = "@checkDate";
paramNames[2] = "@checkStair";
paramNames[3] = "@tableRdn";
paramNames[4] = "@tableName";
paramNames[5] = "@tableType";
paramNames[6] = "@tableScore";
paramValues[0] = checkperson;
paramValues[1] = checkdate;
paramValues[2] = checkstair;
paramValues[3] = tablerdn;
paramValues[4] = tablename;
paramValues[5] = tabletype;
paramValues[6] = tablescore;
try
{
SqlConnect conn = new SqlConnect();
string rdn = conn.ExcuteUpdateCmd("[dbo].[QA_insert_brifeInfo]", paramNames, paramValues).ToString();
saveDetailInfo(rdn, gv);
return("ok");
}
catch (Exception ex)
{
throw;
}
}
public string saveBrifeInfo(string fillperson, string isfirst, string personSex, string regdate, string regdept, string job, string other1, string other2, string tablescore, string payType, string dept, string floorName, string promote, string needImprove, GridView gv)
{
string[] paramNames = new string[17];
string[] paramValues = new string[17];
paramNames[0] = "@fillPerson";
paramNames[1] = "@isFirst";
paramNames[2] = "@personSex";
paramNames[3] = "@regDate";
paramNames[4] = "@regDept";
paramNames[5] = "@job";
paramNames[6] = "@other1";
paramNames[7] = "@other2";
paramNames[8] = "@tableScore";
paramNames[9] = "@tableRdn";
paramNames[10] = "@tableName";
paramNames[11] = "@tableType";
paramNames[12] = "@payType";
paramNames[13] = "@dept";
paramNames[14] = "@floorName";
paramNames[15] = "@promote";
paramNames[16] = "@needImprove";
paramValues[0] = fillperson;
paramValues[1] = isfirst;
paramValues[2] = personSex;
paramValues[3] = regdate;
paramValues[4] = regdept;
paramValues[5] = job;
paramValues[6] = other1;
paramValues[7] = other2;
paramValues[8] = tablescore;
paramValues[9] = this.tableRdn;
paramValues[10] = this.tableName;
paramValues[11] = this.tableType;
paramValues[12] = payType;
paramValues[13] = dept;
paramValues[14] = floorName;
paramValues[15] = promote;
paramValues[16] = needImprove;
try
{
SqlConnect conn = new SqlConnect();
string rdn = conn.ExcuteUpdateCmd("[dbo].[Patient_insert_brifeInfo]", paramNames, paramValues).ToString();
saveDetailInfo(rdn, gv);
return("ok");
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 保存信息到数据库
/// </summary>
/// <param name="filldate">填写时间</param>
/// <param name="filldept">填写人部门</param>
/// <param name="docdept">医生部门</param>
/// <param name="docall">atending医生</param>
/// <param name="fellows">fellow医生</param>
/// <param name="tablerdn">对应的rdn</param>
/// <param name="tablename">table名字</param>
/// <param name="tabletype">table类别</param>
/// <param name="tablescore">table分数</param>
/// <param name="gv">源</param>
/// <returns></returns>
public string saveBrifeInfo(string filldate, string filldept, string docdept, string docall, string fellows, string tablerdn, string tablename, string tabletype, string tablescore, string mrn, string pname, GridView gv)
{
string[] paramNames = new string[15];
string[] paramValues = new string[15];
string[] docs = docall.Split(':');
paramNames[0] = "@fillInDate";
paramNames[1] = "@fillDept";
paramNames[2] = "@docDept";
paramNames[3] = "@doc1";
paramNames[4] = "@doc2";
paramNames[5] = "@doc3";
paramNames[6] = "@doc4";
paramNames[7] = "@doc5";
paramNames[8] = "@fellows";
paramNames[9] = "@tableRdn";
paramNames[10] = "@tableName";
paramNames[11] = "@tableType";
paramNames[12] = "@tableScore";
paramNames[13] = "@mrn";
paramNames[14] = "@pName";
paramValues[0] = filldate;
paramValues[1] = filldept;
paramValues[2] = docdept;
paramValues[3] = docs[0];
paramValues[4] = docs[1];
paramValues[5] = docs[2];
paramValues[6] = docs[3];
paramValues[7] = docs[4];
paramValues[8] = fellows;
paramValues[9] = tablerdn;
paramValues[10] = tablename;
paramValues[11] = tabletype;
paramValues[12] = tablescore;
paramValues[13] = mrn;
paramValues[14] = pname;
try
{
SqlConnect conn = new SqlConnect();
string rr = conn.ExcuteUpdateCmd("[dbo].[insert_brifeInfo]", paramNames, paramValues).ToString();
saveMediTable(gv, rr);
return(rr);
}
catch (Exception ex)
{
throw ex;
}
}
public string saveBrifeInfo(
string stablerdn,
string stablename,
string sreportdept,
string sreportperson,
string spersonphone,
string sreportdate,
string soccurtime,
string soweekday,
string spname,
string page,
string spmrn,
string spssex,
string spoper,
string sptype,
string sgothrough,
string smeasure,
string addcontent,
GridView gv)
{
string[] paramNames = new string[17];
string[] paramValues = new string[17];
paramNames[0] = "@tableRdn";
paramNames[1] = "@tableName";
paramNames[2] = "@reportDept";
paramNames[3] = "@reportPerson";
paramNames[4] = "@personPhone";
paramNames[5] = "@reportDate";
paramNames[6] = "@occurTime";
paramNames[7] = "@oweekday";
paramNames[8] = "@pName";
paramNames[9] = "@pMrn";
paramNames[10] = "@pAge";
paramNames[11] = "@pSex";
paramNames[12] = "@pOper";
paramNames[13] = "@pType";
paramNames[14] = "@goThrough";
paramNames[15] = "@measure";
paramNames[16] = "@addcontent";
paramValues[0] = stablerdn;
paramValues[1] = stablename;
paramValues[2] = sreportdept;
paramValues[3] = sreportperson;
paramValues[4] = spersonphone;
paramValues[5] = sreportdate;
paramValues[6] = soccurtime;
paramValues[7] = soweekday;
paramValues[8] = spname;
paramValues[9] = page;
paramValues[10] = spmrn;
paramValues[11] = spssex;
paramValues[12] = spoper;
paramValues[13] = sptype;
paramValues[14] = sgothrough;
paramValues[15] = smeasure;
paramValues[16] = addcontent;
try
{
SqlConnect conn = new SqlConnect();
string rr = conn.ExcuteUpdateCmd("dbo.acc_insert_brifeInfo", paramNames, paramValues).ToString();
saveDetailInfo(rr, gv);
return("ok");
}
catch (Exception ex)
{
throw ex;
}
}