/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.TB_Family model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_Family(");
strSql.Append("PatientID,PatientName,SexFlag,Birthday,PFamilyID,PFamilyName,FamilyNeuxs)");
strSql.Append(" values (");
strSql.Append("@PatientID,@PatientName,@SexFlag,@Birthday,@PFamilyID,@PFamilyName,@FamilyNeuxs)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PatientID", SqlDbType.Int,4),
new SqlParameter("@PatientName", SqlDbType.VarChar,50),
new SqlParameter("@SexFlag", SqlDbType.VarChar,50),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@PFamilyID", SqlDbType.Int,4),
new SqlParameter("@PFamilyName", SqlDbType.VarChar,50),
new SqlParameter("@FamilyNeuxs", SqlDbType.VarChar,50)};
parameters[0].Value = model.PatientID;
parameters[1].Value = model.PatientName;
parameters[2].Value = model.SexFlag;
parameters[3].Value = model.Birthday;
parameters[4].Value = model.PFamilyID;
parameters[5].Value = model.PFamilyName;
parameters[6].Value = model.FamilyNeuxs;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.TB_CONSENT_FORM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_CONSENT_FORM(");
strSql.Append("Path,PatientName,PatientID,Consent_From,date)");
strSql.Append(" values (");
strSql.Append("@Path,@PatientName,@PatientID,@Consent_From,@date)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Path", SqlDbType.NVarChar,200),
new SqlParameter("@PatientName", SqlDbType.VarChar,50),
new SqlParameter("@PatientID", SqlDbType.Int,4),
new SqlParameter("@Consent_From", SqlDbType.NVarChar,150),
new SqlParameter("@date",SqlDbType.DateTime)
};
parameters[0].Value = model.Path;
parameters[1].Value = model.PatientName;
parameters[2].Value = model.PatientID;
parameters[3].Value = model.Consent_From;
parameters[4].Value = model.Date;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.ZSSY.LabTestResult model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into LabTestResult(");
strSql.Append("ReportItemName,ReportItemCode,AbnormalIndicator,Result,Units,ResultDateTime,ReferenceResult)");
strSql.Append(" values (");
strSql.Append("@ReportItemName,@ReportItemCode,@AbnormalIndicator,@Result,@Units,@ResultDateTime,@ReferenceResult)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ReportItemName", SqlDbType.NVarChar,50),
new SqlParameter("@ReportItemCode", SqlDbType.NVarChar,50),
new SqlParameter("@AbnormalIndicator", SqlDbType.NChar,10),
new SqlParameter("@Result", SqlDbType.NVarChar,2048),
new SqlParameter("@Units", SqlDbType.NVarChar,50),
new SqlParameter("@ResultDateTime", SqlDbType.NVarChar,50),
new SqlParameter("@ReferenceResult", SqlDbType.NVarChar,50)};
parameters[0].Value = model.ReportItemName;
parameters[1].Value = model.ReportItemCode;
parameters[2].Value = model.AbnormalIndicator;
parameters[3].Value = model.Result;
parameters[4].Value = model.Units;
parameters[5].Value = model.ResultDateTime;
parameters[6].Value = model.ReferenceResult;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.EmployeeInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EmployeeInfo(");
strSql.Append("EmployeeName,EmployeeNo,EmployeeID)");
strSql.Append(" values (");
strSql.Append("@EmployeeName,@EmployeeNo,@EmployeeID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@EmployeeName", SqlDbType.NVarChar,30),
new SqlParameter("@EmployeeNo", SqlDbType.NVarChar,10),
new SqlParameter("@EmployeeID", SqlDbType.Int,4)};
parameters[0].Value = model.EmployeeName;
parameters[1].Value = model.EmployeeNo;
parameters[2].Value = model.EmployeeID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.EmpiInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EmpiInfo(");
strSql.Append("PatientName,Sex,Birthday,CardId,isDel)");
strSql.Append(" values (");
strSql.Append("@PatientName,@Sex,@Birthday,@CardId,@isDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PatientName", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NVarChar,50),
new SqlParameter("@Birthday", SqlDbType.NVarChar,50),
new SqlParameter("@CardId", SqlDbType.NVarChar,50),
new SqlParameter("@isDel", SqlDbType.Bit,1)};
parameters[0].Value = model.PatientName;
parameters[1].Value = model.Sex;
parameters[2].Value = model.Birthday;
parameters[3].Value = model.CardId;
parameters[4].Value = model.isDel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Add(RuRo.Model.TB_Disease model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TB_Disease(");
strSql.Append("ID,DiseaseID,DiseaseName,MnemonicCode,ICDCode)");
strSql.Append(" values (");
strSql.Append("@ID,@DiseaseID,@DiseaseName,@MnemonicCode,@ICDCode)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@DiseaseID", SqlDbType.Int,4),
new SqlParameter("@DiseaseName", SqlDbType.VarChar,-1),
new SqlParameter("@MnemonicCode", SqlDbType.VarChar,-1),
new SqlParameter("@ICDCode", SqlDbType.VarChar,-1)};
parameters[0].Value = model.ID;
parameters[1].Value = model.DiseaseID;
parameters[2].Value = model.DiseaseName;
parameters[3].Value = model.MnemonicCode;
parameters[4].Value = model.ICDCode;
int rows=DbHelperSQL_SY.ExecuteSqlSY(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.QueryRecoder model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into QueryRecoder(");
strSql.Append("Uname,AddDate,LastQueryDate,Code,CodeType,QueryType,QueryResult)");
strSql.Append(" values (");
strSql.Append("@Uname,@AddDate,@LastQueryDate,@Code,@CodeType,@QueryType,@QueryResult)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Uname", SqlDbType.NVarChar,50),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@LastQueryDate", SqlDbType.DateTime),
new SqlParameter("@Code", SqlDbType.NVarChar,50),
new SqlParameter("@CodeType", SqlDbType.NVarChar,50),
new SqlParameter("@QueryType", SqlDbType.NVarChar,50),
new SqlParameter("@QueryResult", SqlDbType.NVarChar,-1)};
parameters[0].Value = model.Uname;
parameters[1].Value = model.AddDate;
parameters[2].Value = model.LastQueryDate;
parameters[3].Value = model.Code;
parameters[4].Value = model.CodeType;
parameters[5].Value = model.QueryType;
parameters[6].Value = model.QueryResult;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.ZSSY.SpecimenRt model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SpecimenRt(");
strSql.Append("PatientId,PatientName,VisitId,SampleId,SampleName,OtherInfo)");
strSql.Append(" values (");
strSql.Append("@PatientId,@PatientName,@VisitId,@SampleId,@SampleName,@OtherInfo)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PatientId", SqlDbType.NVarChar,50),
new SqlParameter("@PatientName", SqlDbType.NVarChar,50),
new SqlParameter("@VisitId", SqlDbType.NVarChar,50),
new SqlParameter("@SampleId", SqlDbType.NVarChar,50),
new SqlParameter("@SampleName", SqlDbType.NVarChar,50),
new SqlParameter("@OtherInfo", SqlDbType.NVarChar,-1)};
parameters[0].Value = model.PatientId;
parameters[1].Value = model.PatientName;
parameters[2].Value = model.VisitId;
parameters[3].Value = model.SampleId;
parameters[4].Value = model.SampleName;
parameters[5].Value = model.OtherInfo;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.TB_SAMPLE_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_SAMPLE_LOG(");
strSql.Append("PatientID,BASE_MSG,CLINICAL_MSG,MSG,STATE,LOG_DATE,type,LOG_UP)");
strSql.Append(" values (");
strSql.Append("@PatientID,@BASE_MSG,@CLINICAL_MSG,@MSG,@STATE,@LOG_DATE,@type,@LOG_UP)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PatientID", SqlDbType.Int,4),
new SqlParameter("@BASE_MSG", SqlDbType.VarChar,100),
new SqlParameter("@CLINICAL_MSG", SqlDbType.VarChar,100),
new SqlParameter("@MSG", SqlDbType.VarChar,-1),
new SqlParameter("@STATE", SqlDbType.NChar,10),
new SqlParameter("@LOG_DATE", SqlDbType.DateTime),
new SqlParameter("@type", SqlDbType.VarChar,50),
new SqlParameter("@LOG_UP", SqlDbType.VarChar,50)};
parameters[0].Value = model.PatientID;
parameters[1].Value = model.BASE_MSG;
parameters[2].Value = model.CLINICAL_MSG;
parameters[3].Value = model.MSG;
parameters[4].Value = model.STATE;
parameters[5].Value = model.LOG_DATE;
parameters[6].Value = model.type;
parameters[7].Value = model.LOG_UP;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.Fp_UserFields_Match model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Fp_UserFields_Match(");
strSql.Append("Fpudf_Id,MatchFields,IsSearch)");
strSql.Append(" values (");
strSql.Append("@Fpudf_Id,@MatchFields,@IsSearch)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Fpudf_Id", SqlDbType.Int,4),
new SqlParameter("@MatchFields", SqlDbType.NVarChar,20),
new SqlParameter("@IsSearch", SqlDbType.NVarChar,10)};
parameters[0].Value = model.Fpudf_Id;
parameters[1].Value = model.MatchFields;
parameters[2].Value = model.IsSearch;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.ClinicalInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ClinicalInfo(");
strSql.Append("DiagnoseTypeFlag,DiagnoseDateTime,RegisterID,InPatientID,ICDCode,DiseaseName,Description)");
strSql.Append(" values (");
strSql.Append("@DiagnoseTypeFlag,@DiagnoseDateTime,@RegisterID,@InPatientID,@ICDCode,@DiseaseName,@Description)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@DiagnoseTypeFlag", SqlDbType.NVarChar,20),
new SqlParameter("@DiagnoseDateTime", SqlDbType.DateTime),
new SqlParameter("@RegisterID", SqlDbType.Int,4),
new SqlParameter("@InPatientID", SqlDbType.Int,4),
new SqlParameter("@ICDCode", SqlDbType.NVarChar,30),
new SqlParameter("@DiseaseName", SqlDbType.NVarChar,100),
new SqlParameter("@Description", SqlDbType.NVarChar,100)};
parameters[0].Value = model.DiagnoseTypeFlag;
parameters[1].Value = model.DiagnoseDateTime;
parameters[2].Value = model.RegisterID;
parameters[3].Value = model.InPatientID;
parameters[4].Value = model.ICDCode;
parameters[5].Value = model.DiseaseName;
parameters[6].Value = model.Description;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.ExamineInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ExamineInfo(");
strSql.Append("ExamineRequestID,ItemSetNo,Description,ItemSetID)");
strSql.Append(" values (");
strSql.Append("@ExamineRequestID,@ItemSetNo,@Description,@ItemSetID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ExamineRequestID", SqlDbType.Int,4),
new SqlParameter("@ItemSetNo", SqlDbType.NVarChar,20),
new SqlParameter("@Description", SqlDbType.NVarChar,20),
new SqlParameter("@ItemSetID", SqlDbType.Int,4)};
parameters[0].Value = model.ExamineRequestID;
parameters[1].Value = model.ItemSetNo;
parameters[2].Value = model.Description;
parameters[3].Value = model.ItemSetID;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.FP_LINKAGE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FP_LINKAGE(");
strSql.Append("fromid,name)");
strSql.Append(" values (");
strSql.Append("@fromid,@name)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@fromid", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.NVarChar,50)
};
parameters[0].Value = model.fromid;
parameters[1].Value = model.name;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RuRo.Model.SurgeryInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SurgeryInfo(");
strSql.Append("id,SurgeryRequestID,ICDCode,SurgeryName,RequestExecutiveDateTime,RequestDoctorEmployeeID)");
strSql.Append(" values (");
strSql.Append("@id,@SurgeryRequestID,@ICDCode,@SurgeryName,@RequestExecutiveDateTime,@RequestDoctorEmployeeID)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@SurgeryRequestID", SqlDbType.Int,4),
new SqlParameter("@ICDCode", SqlDbType.NVarChar,30),
new SqlParameter("@SurgeryName", SqlDbType.NVarChar,50),
new SqlParameter("@RequestExecutiveDateTime", SqlDbType.SmallDateTime),
new SqlParameter("@RequestDoctorEmployeeID", SqlDbType.Int,4)};
parameters[0].Value = model.id;
parameters[1].Value = model.SurgeryRequestID;
parameters[2].Value = model.ICDCode;
parameters[3].Value = model.SurgeryName;
parameters[4].Value = model.RequestExecutiveDateTime;
parameters[5].Value = model.RequestDoctorEmployeeID;
int rows=DbHelperSQL_SY.ExecuteSqlSY(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Add(RuRo.Model.TB_IMGPATH model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TB_IMGPATH(");
strSql.Append("IMGNAME,KESHI,DATE,IMGPATH)");
strSql.Append(" values (");
strSql.Append("@IMGNAME,@KESHI,@DATE,@IMGPATH)");
SqlParameter[] parameters = {
new SqlParameter("@IMGNAME", SqlDbType.VarChar,50),
new SqlParameter("@KESHI", SqlDbType.VarChar,50),
new SqlParameter("@DATE", SqlDbType.DateTime),
new SqlParameter("@IMGPATH", SqlDbType.VarChar,-1)};
parameters[0].Value = model.IMGNAME;
parameters[1].Value = model.KESHI;
parameters[2].Value = model.DATE;
parameters[3].Value = model.IMGPATH;
int rows=DbHelperSQL_SY.ExecuteSqlSY(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.TB_SETTING_VALUE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_SETTING_VALUE(");
strSql.Append("SETTING_TYPE,SETTING_VALUE,DEPARTMENTS,ADD_TIME)");
strSql.Append(" values (");
strSql.Append("@SETTING_TYPE,@SETTING_VALUE,@DEPARTMENTS,@ADD_TIME)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@SETTING_TYPE", SqlDbType.VarChar,50),
new SqlParameter("@SETTING_VALUE", SqlDbType.VarChar,-1),
new SqlParameter("@DEPARTMENTS", SqlDbType.VarChar,30),
new SqlParameter("@ADD_TIME", SqlDbType.DateTime)};
parameters[0].Value = model.SETTING_TYPE;
parameters[1].Value = model.SETTING_VALUE;
parameters[2].Value = model.DEPARTMENTS;
parameters[3].Value = model.ADD_TIME;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public void HF(RuRo.BLL.WebService.SpecimenRt specimenRt)
{
#region 正式代码
Thread.Sleep(100);//休眠1秒钟
//检查当前数据是否需要回发——数据库中不存在当前样本id的数据或者数据库中的数据和当前样本id的样本数据不一样
//a、数据库中存在数据——更新
//b、数据库中不存在数据——添加
bool exist = false;
//检查数据是否存在 true存在
bool checkSpecimenRtResult = CheckSpecimenRt(specimenRt, ref exist);
if (!checkSpecimenRtResult)
{
string result = "";
//数据库中不存在当前样本Id的数据
try
{
RuRo.BLL.WebService.ForCenterLabService CenterLab = new RuRo.BLL.WebService.ForCenterLabService();
result = CenterLab.StoreSpecimenInfo(specimenRt);
}
catch (Exception ex)
{
result = ex.Message;
}
//保存日志：a、直接保存SpecimenRtLog；b、成功之后保存详细的SpecimenRt
bool SaveSpecimenRtLogResult = AddToSpecimenRtLog(specimenRt, result);
if (result == "0^成功")//此处需要判断回发数据之后保存是否成功——判断回发之后返回的状态。
{
//保存当前记录到数据库
bool SaveSpecimenRtResult = AddToSpecimenRt(specimenRt);
}
//检查当前的数据是否和数据库中的数据一直
}
else//数据库中存在当前样本id的数据
{
if (exist)//数据不一样
{
string result = "";
try
{
RuRo.BLL.WebService.ForCenterLabService CenterLab = new RuRo.BLL.WebService.ForCenterLabService();
result = CenterLab.StoreSpecimenInfo(specimenRt);//回发数据
}
catch (Exception ex)
{
result = ex.Message;
}
//保存日志：a、直接保存SpecimenRtLog；b、成功之后保存详细的SpecimenRt
bool SaveSpecimenRtLogResult = AddToSpecimenRtLog(specimenRt, result);
if (result == "0^成功")//此处需要判断回发数据之后保存是否成功——判断回发之后返回的状态。
{
//更新当前记录到数据库
bool SaveSpecimenRtResult = UpdateSpecimenRt(specimenRt);
}
}
}
#endregion
}
/// <summary>
/// 手术申请单信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataSet GetSY_HC_GetSurgeryRequest(RuRo.Model.FP_SY_HIS_IP_PublicInterface model)
{
SqlParameter[] parameters = {
new SqlParameter("@In_RegisterID", SqlDbType.Int),
new SqlParameter("@In_InPatientID", SqlDbType.Int)
};
parameters[0].Value = model.In_RegisterID;
parameters[1].Value = model.In_InPatientID;
return DbHelperSQL.RunProcedure("SY_HC_GetSurgeryRequest", parameters, "ds");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.NormalLisReport model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into NormalLisReport(");
strSql.Append("hospnum,patname,sex,age,age_month,ext_mthd,chinese,result,units,ref_flag,lowvalue,highvalue,print_ref,check_date,check_by_name,prnt_order,isDel)");
strSql.Append(" values (");
strSql.Append("@hospnum,@patname,@sex,@age,@age_month,@ext_mthd,@chinese,@result,@units,@ref_flag,@lowvalue,@highvalue,@print_ref,@check_date,@check_by_name,@prnt_order,@isDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@hospnum", SqlDbType.NVarChar,50),
new SqlParameter("@patname", SqlDbType.NVarChar,50),
new SqlParameter("@sex", SqlDbType.NChar,10),
new SqlParameter("@age", SqlDbType.NChar,10),
new SqlParameter("@age_month", SqlDbType.NChar,10),
new SqlParameter("@ext_mthd", SqlDbType.NVarChar,50),
new SqlParameter("@chinese", SqlDbType.NVarChar,50),
new SqlParameter("@result", SqlDbType.NVarChar,-1),
new SqlParameter("@units", SqlDbType.NChar,10),
new SqlParameter("@ref_flag", SqlDbType.NChar,10),
new SqlParameter("@lowvalue", SqlDbType.NVarChar,50),
new SqlParameter("@highvalue", SqlDbType.NVarChar,50),
new SqlParameter("@print_ref", SqlDbType.NVarChar,50),
new SqlParameter("@check_date", SqlDbType.NVarChar,50),
new SqlParameter("@check_by_name", SqlDbType.NVarChar,50),
new SqlParameter("@prnt_order", SqlDbType.NVarChar,50),
new SqlParameter("@isDel", SqlDbType.Bit,1)};
parameters[0].Value = model.hospnum;
parameters[1].Value = model.patname;
parameters[2].Value = model.sex;
parameters[3].Value = model.age;
parameters[4].Value = model.age_month;
parameters[5].Value = model.ext_mthd;
parameters[6].Value = model.chinese;
parameters[7].Value = model.result;
parameters[8].Value = model.units;
parameters[9].Value = model.ref_flag;
parameters[10].Value = model.lowvalue;
parameters[11].Value = model.highvalue;
parameters[12].Value = model.print_ref;
parameters[13].Value = model.check_date;
parameters[14].Value = model.check_by_name;
parameters[15].Value = model.prnt_order;
parameters[16].Value = model.isDel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.BasedInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BasedInfo(");
strSql.Append("PatientName,IPSeqNoText,PatientCardNo,SexFlag,Birthday,BloodTypeFlag,Phone,ContactPhone,ContactPerson,NativePlace,RegisterSeqNO,PatientID,RegisterID,InPatientID,IdentityCardNo,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@PatientName,@IPSeqNoText,@PatientCardNo,@SexFlag,@Birthday,@BloodTypeFlag,@Phone,@ContactPhone,@ContactPerson,@NativePlace,@RegisterSeqNO,@PatientID,@RegisterID,@InPatientID,@IdentityCardNo,@ADDTIME)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PatientName", SqlDbType.NVarChar,30),
new SqlParameter("@IPSeqNoText", SqlDbType.NVarChar,14),
new SqlParameter("@PatientCardNo", SqlDbType.NVarChar,30),
new SqlParameter("@SexFlag", SqlDbType.NVarChar,10),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@BloodTypeFlag", SqlDbType.NChar,10),
new SqlParameter("@Phone", SqlDbType.NVarChar,20),
new SqlParameter("@ContactPhone", SqlDbType.NVarChar,50),
new SqlParameter("@ContactPerson", SqlDbType.NVarChar,30),
new SqlParameter("@NativePlace", SqlDbType.NVarChar,20),
new SqlParameter("@RegisterSeqNO", SqlDbType.NVarChar,30),
new SqlParameter("@PatientID", SqlDbType.Int,4),
new SqlParameter("@RegisterID", SqlDbType.Int,4),
new SqlParameter("@InPatientID", SqlDbType.Money,8),
new SqlParameter("@IdentityCardNo",SqlDbType.NVarChar,50),
new SqlParameter("@ADDTIME", SqlDbType.DateTime)};
parameters[0].Value = model.PatientName;
parameters[1].Value = model.IPSeqNoText;
parameters[2].Value = model.PatientCardNo;
parameters[3].Value = model.SexFlag;
parameters[4].Value = model.Birthday;
parameters[5].Value = model.BloodTypeFlag;
parameters[6].Value = model.Phone;
parameters[7].Value = model.ContactPhone;
parameters[8].Value = model.ContactPerson;
parameters[9].Value = model.NativePlace;
parameters[10].Value = model.RegisterSeqNO;
parameters[11].Value = model.PatientID;
parameters[12].Value = model.RegisterID;
parameters[13].Value = model.InPatientID;
parameters[14].Value = model.IdentityCardNo;
parameters[15].Value = model.ADDTIME;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 患者门诊住院信息
/// </summary>
/// <returns></returns>
public DataSet GetSY_HC_GetPatientInfo(RuRo.Model.FP_SY_HIS_IP_PublicInterface model)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlParameter[] parameters =
{
new SqlParameter("@In_CodeType", SqlDbType.Int),
new SqlParameter("@In_Code", SqlDbType.NVarChar,50)
};
parameters[0].Value = model.In_CodeType;
parameters[1].Value = model.In_Code;
ds = DbHelperSQL.RunProcedure("SY_HC_GetPatientInfo", parameters, "ds");
return ds;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RuRo.Model.ZSSY.LabTestMaster model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into LabTestMaster(");
strSql.Append("Id,TestNo,priorityIndicator,WorkingId,TestCause,RelevantClinicDiag,Specimen,SpcmReceivedDateTime,OrderingDept,orderingProvider,PerformedBy,ResultStatus,ResultsRptDateTime,transcriptionist,VerifiedBy)");
strSql.Append(" values (");
strSql.Append("@Id,@TestNo,@priorityIndicator,@WorkingId,@TestCause,@RelevantClinicDiag,@Specimen,@SpcmReceivedDateTime,@OrderingDept,@orderingProvider,@PerformedBy,@ResultStatus,@ResultsRptDateTime,@transcriptionist,@VerifiedBy)");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4),
new SqlParameter("@TestNo", SqlDbType.NVarChar,50),
new SqlParameter("@priorityIndicator", SqlDbType.NVarChar,50),
new SqlParameter("@WorkingId", SqlDbType.NVarChar,50),
new SqlParameter("@TestCause", SqlDbType.NVarChar,50),
new SqlParameter("@RelevantClinicDiag", SqlDbType.NVarChar,-1),
new SqlParameter("@Specimen", SqlDbType.NVarChar,50),
new SqlParameter("@SpcmReceivedDateTime", SqlDbType.NVarChar,50),
new SqlParameter("@OrderingDept", SqlDbType.NVarChar,50),
new SqlParameter("@orderingProvider", SqlDbType.NVarChar,50),
new SqlParameter("@PerformedBy", SqlDbType.NVarChar,50),
new SqlParameter("@ResultStatus", SqlDbType.NVarChar,50),
new SqlParameter("@ResultsRptDateTime", SqlDbType.NVarChar,50),
new SqlParameter("@transcriptionist", SqlDbType.NVarChar,50),
new SqlParameter("@VerifiedBy", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Id;
parameters[1].Value = model.TestNo;
parameters[2].Value = model.priorityIndicator;
parameters[3].Value = model.WorkingId;
parameters[4].Value = model.TestCause;
parameters[5].Value = model.RelevantClinicDiag;
parameters[6].Value = model.Specimen;
parameters[7].Value = model.SpcmReceivedDateTime;
parameters[8].Value = model.OrderingDept;
parameters[9].Value = model.orderingProvider;
parameters[10].Value = model.PerformedBy;
parameters[11].Value = model.ResultStatus;
parameters[12].Value = model.ResultsRptDateTime;
parameters[13].Value = model.transcriptionist;
parameters[14].Value = model.VerifiedBy;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RuRo.Model.PatientDiagnose model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into PatientDiagnose(");
strSql.Append("id,Cardno,Csrq00,PatientName,Sex,Brithday,CardId,Tel,RegisterNo,Icd,Diagnose,Type,Flag,DiagnoseDate,isDel)");
strSql.Append(" values (");
strSql.Append("@id,@Cardno,@Csrq00,@PatientName,@Sex,@Brithday,@CardId,@Tel,@RegisterNo,@Icd,@Diagnose,@Type,@Flag,@DiagnoseDate,@isDel)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@Cardno", SqlDbType.NVarChar,50),
new SqlParameter("@Csrq00", SqlDbType.NVarChar,50),
new SqlParameter("@PatientName", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NChar,10),
new SqlParameter("@Brithday", SqlDbType.DateTime),
new SqlParameter("@CardId", SqlDbType.NVarChar,50),
new SqlParameter("@Tel", SqlDbType.NVarChar,50),
new SqlParameter("@RegisterNo", SqlDbType.NVarChar,50),
new SqlParameter("@Icd", SqlDbType.NVarChar,50),
new SqlParameter("@Diagnose", SqlDbType.NVarChar,50),
new SqlParameter("@Type", SqlDbType.NVarChar,50),
new SqlParameter("@Flag", SqlDbType.NVarChar,50),
new SqlParameter("@DiagnoseDate", SqlDbType.NVarChar,50),
new SqlParameter("@isDel", SqlDbType.Bit,1)};
parameters[0].Value = model.id;
parameters[1].Value = model.Cardno;
parameters[2].Value = model.Csrq00;
parameters[3].Value = model.PatientName;
parameters[4].Value = model.Sex;
parameters[5].Value = model.Brithday;
parameters[6].Value = model.CardId;
parameters[7].Value = model.Tel;
parameters[8].Value = model.RegisterNo;
parameters[9].Value = model.Icd;
parameters[10].Value = model.Diagnose;
parameters[11].Value = model.Type;
parameters[12].Value = model.Flag;
parameters[13].Value = model.DiagnoseDate;
parameters[14].Value = model.isDel;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.NormalLisItems model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into NormalLisItems(");
strSql.Append("hospnum,patname,sex,age,age_month,ext_mthd,location,DOC_NAME0,test_date,check_by_name,check_date,IsDel)");
strSql.Append(" values (");
strSql.Append("@hospnum,@patname,@sex,@age,@age_month,@ext_mthd,@location,@DOC_NAME0,@test_date,@check_by_name,@check_date,@IsDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@hospnum", SqlDbType.NVarChar,50),
new SqlParameter("@patname", SqlDbType.NVarChar,50),
new SqlParameter("@sex", SqlDbType.NChar,10),
new SqlParameter("@age", SqlDbType.NChar,10),
new SqlParameter("@age_month", SqlDbType.NChar,10),
new SqlParameter("@ext_mthd", SqlDbType.NVarChar,50),
new SqlParameter("@location", SqlDbType.NVarChar,50),
new SqlParameter("@DOC_NAME0", SqlDbType.NVarChar,50),
new SqlParameter("@test_date", SqlDbType.DateTime),
new SqlParameter("@check_by_name", SqlDbType.NVarChar,50),
new SqlParameter("@check_date", SqlDbType.DateTime),
new SqlParameter("@IsDel", SqlDbType.Bit,1)};
parameters[0].Value = model.hospnum;
parameters[1].Value = model.patname;
parameters[2].Value = model.sex;
parameters[3].Value = model.age;
parameters[4].Value = model.age_month;
parameters[5].Value = model.ext_mthd;
parameters[6].Value = model.location;
parameters[7].Value = model.DOC_NAME0;
parameters[8].Value = model.test_date;
parameters[9].Value = model.check_by_name;
parameters[10].Value = model.check_date;
parameters[11].Value = model.IsDel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RuRo.Model.FP_Users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into FP_Users(");
strSql.Append("userID,id,obj_id,username,fullname,email,created_at,disabled,active,role,samples)");
strSql.Append(" values (");
strSql.Append("@userID,@id,@obj_id,@username,@fullname,@email,@created_at,@disabled,@active,@role,@samples)");
SqlParameter[] parameters = {
new SqlParameter("@userID", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@obj_id", SqlDbType.Int,4),
new SqlParameter("@username", SqlDbType.NChar,10),
new SqlParameter("@fullname", SqlDbType.NChar,10),
new SqlParameter("@email", SqlDbType.NChar,10),
new SqlParameter("@created_at", SqlDbType.NChar,10),
new SqlParameter("@disabled", SqlDbType.NChar,10),
new SqlParameter("@active", SqlDbType.NChar,10),
new SqlParameter("@role", SqlDbType.NChar,10),
new SqlParameter("@samples", SqlDbType.NChar,10)};
parameters[0].Value = model.userID;
parameters[1].Value = model.id;
parameters[2].Value = model.obj_id;
parameters[3].Value = model.username;
parameters[4].Value = model.fullname;
parameters[5].Value = model.email;
parameters[6].Value = model.created_at;
parameters[7].Value = model.disabled;
parameters[8].Value = model.active;
parameters[9].Value = model.role;
parameters[10].Value = model.samples;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.FP_UserFields model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into FP_UserFields(");
strSql.Append("id,obj_id,display_name,name,type,values,show,created_at,updated_at,inuse)");
strSql.Append(" values (");
strSql.Append("@id,@obj_id,@display_name,@name,@type,@values,@show,@created_at,@updated_at,@inuse)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@userFieldId", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@obj_id", SqlDbType.Int,4),
new SqlParameter("@display_name", SqlDbType.NVarChar,128),
new SqlParameter("@name", SqlDbType.NVarChar,128),
new SqlParameter("@type", SqlDbType.NVarChar,128),
new SqlParameter("@values", SqlDbType.NVarChar,-1),
new SqlParameter("@show", SqlDbType.NVarChar,128),
new SqlParameter("@created_at", SqlDbType.NVarChar,128),
new SqlParameter("@updated_at", SqlDbType.NVarChar,128),
new SqlParameter("@inuse", SqlDbType.NVarChar,128)};
parameters[0].Value = model.userFieldId;
parameters[1].Value = model.id;
parameters[2].Value = model.obj_id;
parameters[3].Value = model.display_name;
parameters[4].Value = model.name;
parameters[5].Value = model.type;
parameters[6].Value = model.values;
parameters[7].Value = model.show;
parameters[8].Value = model.created_at;
parameters[9].Value = model.updated_at;
parameters[10].Value = model.inuse;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 患者门诊住院信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string GetSY_HC_GetPatientInfoJson(RuRo.Model.FP_SY_HIS_IP_PublicInterface model)
{
DataSet ds = dal.GetSY_HC_GetPatientInfo(model);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++)
{
if (i == ds.Tables[0].Rows.Count - 1)
{
break;
}
ds.Tables[0].Rows[i].Delete();
}
ds.AcceptChanges();
model.In_InPatientID = Convert.ToInt32(ds.Tables[0].Rows[0]["InPatientID"]);
model.In_CodeType = Convert.ToInt32(ds.Tables[0].Rows[0]["InPatientID"]);
string res = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(ds);
return res;
}
else
{
return FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(dal.GetSY_HC_GetPatientInfo(model));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.Log_Import model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Log_Import(");
strSql.Append("PatientID,Import_Date,Import_State,Import_Date_Msg,Import_User_Id,Import_User_Department,Import_Type,Others)");
strSql.Append(" values (");
strSql.Append("@PatientID,@Import_Date,@Import_State,@Import_Date_Msg,@Import_User_Id,@Import_User_Department,@Import_Type,@Others)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PatientID", SqlDbType.NVarChar,50),
new SqlParameter("@Import_Date", SqlDbType.DateTime),
new SqlParameter("@Import_State", SqlDbType.Bit,1),
new SqlParameter("@Import_Date_Msg", SqlDbType.NVarChar,-1),
new SqlParameter("@Import_User_Id", SqlDbType.NVarChar,50),
new SqlParameter("@Import_User_Department", SqlDbType.NVarChar,50),
new SqlParameter("@Import_Type", SqlDbType.NVarChar,50),
new SqlParameter("@Others", SqlDbType.NVarChar,-1)};
parameters[0].Value = model.PatientID;
parameters[1].Value = model.Import_Date;
parameters[2].Value = model.Import_State;
parameters[3].Value = model.Import_Date_Msg;
parameters[4].Value = model.Import_User_Id;
parameters[5].Value = model.Import_User_Department;
parameters[6].Value = model.Import_Type;
parameters[7].Value = model.Others;
object obj = DbHelperSQL_SY.GetSingleSY(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(RuRo.Model.TB_CONSENT_FORM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TB_CONSENT_FORM set ");
strSql.Append("Path=@Path,");
strSql.Append("PatientName=@PatientName,");
strSql.Append("PatientID=@PatientID");
strSql.Append("Consent_From=@Consent_From");
strSql.Append(" where Consent_ID=@Consent_ID");
SqlParameter[] parameters = {
new SqlParameter("@Path", SqlDbType.NVarChar,200),
new SqlParameter("@PatientName", SqlDbType.VarChar,50),
new SqlParameter("@PatientID", SqlDbType.Int,4),
new SqlParameter("@Consent_ID", SqlDbType.Int,4),
new SqlParameter("@Consent_From", SqlDbType.NVarChar,150)
};
parameters[0].Value = model.Path;
parameters[1].Value = model.PatientName;
parameters[2].Value = model.PatientID;
parameters[3].Value = model.Consent_ID;
parameters[4].Value = model.Consent_From;
int rows = DbHelperSQL_SY.ExecuteSqlSY(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 查询是否存在唯一标识
/// </summary>
/// <param name="name"></param>
/// <param name="id"></param>
/// <returns></returns>
public DataSet GetTB_CONSENT_FORM(RuRo.Model.TB_CONSENT_FORM model)
{
string strsql = "SELECT * FROM TB_CONSENT_FORM WHERE PatientName='" + model.PatientName + "' AND PatientID=" + model.PatientID;
return DbHelperSQL_SY.QuerySY(strsql);
}
