protected void GetCustomerInfo(long ID_Customer, ref VelocityContext vltContext)
{
DataSet custRelationCustPEInfo = CommonCustExam.Instance.GetCustRelationCustPEInfo(ID_Customer, "", "");
if (custRelationCustPEInfo != null && 0 < custRelationCustPEInfo.Tables[0].Rows.Count)
{
List <PEIS.Model.OnCustRelationCustPEInfo> list = PEIS.BLL.OnCustRelationCustPEInfo.Instance.DataTableToList(custRelationCustPEInfo.Tables[0]);
if (list == null)
{
base.Response.Write("<script> jQuery(document).ready(function () { ReLoginConfirm();}); </script>");
base.Response.End();
}
else
{
vltContext.Put("ExamState", list[0].ExamState);
PEIS.Model.OnCustPhysicalExamInfo onCustPhysicalExamInfo = null;
PEIS.Model.OnArcCust modelByCache = PEIS.BLL.OnArcCust.Instance.GetModelByCache(int.Parse(list[0].ID_ArcCustomer.ToString()));
if (list[0].ExamState == 0)
{
onCustPhysicalExamInfo = PEIS.BLL.OnCustPhysicalExamInfo.Instance.GetModel(list[0].ID_Customer.Value);
}
if (modelByCache != null)
{
vltContext.Put("ExamCardNo", modelByCache.ExamCard);
vltContext.Put("IDCardNo", modelByCache.IDCard);
vltContext.Put("CustomerName", modelByCache.CustomerName);
vltContext.Put("MarriageName", modelByCache.MarriageName);
vltContext.Put("GenderName", modelByCache.GenderName);
vltContext.Put("txtGenderID", (modelByCache.ID_Gender == 1) ? "1" : "0");
vltContext.Put("MobileNo", modelByCache.MobileNo);
int finishedNum = modelByCache.FinishedNum;
int num = (!modelByCache.UnfinishedNum.HasValue) ? 0 : modelByCache.UnfinishedNum.Value;
int num2 = finishedNum + num;
vltContext.Put("totalExamNumber", num2);
}
if (onCustPhysicalExamInfo != null)
{
vltContext.Put("Is_FeeSettled", onCustPhysicalExamInfo.Is_FeeSettled);
vltContext.Put("CustomerSecurityLevel", onCustPhysicalExamInfo.SecurityLevel);
vltContext.Put("DiseaseLevel", onCustPhysicalExamInfo.DiseaseLevel);
vltContext.Put("Is_GuideSheetPrinted", onCustPhysicalExamInfo.Is_GuideSheetPrinted);
vltContext.Put("Is_SectionLock", onCustPhysicalExamInfo.Is_SectionLock);
vltContext.Put("Is_Checked", onCustPhysicalExamInfo.Is_Checked);
vltContext.Put("Is_Paused", onCustPhysicalExamInfo.Is_Paused);
vltContext.Put("Is_ReportReceipted", onCustPhysicalExamInfo.Is_ReportReceipted);
}
}
}
}
public void SaveCustomerDiseaselLevelInformInfo()
{
long @int = base.GetInt64("CustomerID", 0L);
string text = base.GetString("InformContent");
text = Input.URLDecode(text);
PEIS.Model.OnCustPhysicalExamInfo onCustPhysicalExamInfo = new PEIS.Model.OnCustPhysicalExamInfo();
onCustPhysicalExamInfo.Is_DiseaseLevelInformed = new bool?(true);
onCustPhysicalExamInfo.DiseaseLevelInformer = this.LoginUserModel.UserName;
onCustPhysicalExamInfo.ID_DiseaseLevelInformer = new int?(this.LoginUserModel.UserID);
onCustPhysicalExamInfo.DiseaseLevelInformedDate = new DateTime?(DateTime.Now);
onCustPhysicalExamInfo.DiseaseLevelInformNote = text;
onCustPhysicalExamInfo.ID_Customer = @int;
int num = CommonCustExam.Instance.UpdateDiseaselLevelInform(onCustPhysicalExamInfo);
if (num > 0)
{
Log4J.Instance.Info(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",病症级别通知成功 ,体检号：",
@int
}));
}
else
{
Log4J.Instance.Error(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",病症级别通知失败 ,体检号：",
@int
}));
}
this.OutPutMessage(num.ToString());
}
protected void GetCustomerInfo(long ID_Customer, ref VelocityContext vltContext)
{
DataSet custRelationCustPEInfo = CommonCustExam.Instance.GetCustRelationCustPEInfo(ID_Customer, "", "");
if (custRelationCustPEInfo != null && 0 < custRelationCustPEInfo.Tables[0].Rows.Count)
{
List <PEIS.Model.OnCustRelationCustPEInfo> list = PEIS.BLL.OnCustRelationCustPEInfo.Instance.DataTableToList(custRelationCustPEInfo.Tables[0]);
if (list != null)
{
vltContext.Put("ExamState", list[0].ExamState);
PEIS.Model.OnCustPhysicalExamInfo onCustPhysicalExamInfo = null;
PEIS.Model.OnArcCust modelByCache = PEIS.BLL.OnArcCust.Instance.GetModelByCache(int.Parse(list[0].ID_ArcCustomer.ToString()));
if (list[0].ExamState == 0)
{
onCustPhysicalExamInfo = PEIS.BLL.OnCustPhysicalExamInfo.Instance.GetModel(list[0].ID_Customer.Value);
}
if (modelByCache != null)
{
vltContext.Put("ExamCardNo", modelByCache.ExamCard);
vltContext.Put("IDCardNo", modelByCache.IDCard);
vltContext.Put("CustomerName", modelByCache.CustomerName);
vltContext.Put("MarriageName", modelByCache.MarriageName);
vltContext.Put("GenderName", modelByCache.GenderName);
vltContext.Put("MobileNo", modelByCache.MobileNo);
int finishedNum = modelByCache.FinishedNum;
int num = (!modelByCache.UnfinishedNum.HasValue) ? 0 : modelByCache.UnfinishedNum.Value;
int num2 = finishedNum + num;
vltContext.Put("totalExamNumber", num2);
}
if (onCustPhysicalExamInfo != null)
{
vltContext.Put("Is_FeeSettled", onCustPhysicalExamInfo.Is_FeeSettled);
vltContext.Put("CustomerSecurityLevel", onCustPhysicalExamInfo.SecurityLevel);
vltContext.Put("DiseaseLevel", onCustPhysicalExamInfo.DiseaseLevel);
vltContext.Put("Is_GuideSheetPrinted", onCustPhysicalExamInfo.Is_GuideSheetPrinted);
vltContext.Put("Is_SectionLock", onCustPhysicalExamInfo.Is_SectionLock);
vltContext.Put("Is_Checked", onCustPhysicalExamInfo.Is_Checked);
vltContext.Put("ID_FinalDoctor", onCustPhysicalExamInfo.ID_FinalDoctor);
vltContext.Put("FinalDoctor", onCustPhysicalExamInfo.FinalDoctor);
vltContext.Put("FinalDate", onCustPhysicalExamInfo.FinalDate.HasValue ? DateTime.Parse(onCustPhysicalExamInfo.FinalDate.ToString()).ToString("yyyy-MM-dd") : "");
vltContext.Put("FinalDateDetail", onCustPhysicalExamInfo.FinalDate);
vltContext.Put("Is_FinalFinished", onCustPhysicalExamInfo.Is_FinalFinished);
vltContext.Put("Is_GuideSheetReturned", onCustPhysicalExamInfo.Is_GuideSheetReturned);
vltContext.Put("Is_GuideSheetPrinted", onCustPhysicalExamInfo.Is_GuideSheetPrinted);
vltContext.Put("Is_Paused", onCustPhysicalExamInfo.Is_Paused);
vltContext.Put("Is_ReportReceipted", onCustPhysicalExamInfo.Is_ReportReceipted);
vltContext.Put("Is_Checked", onCustPhysicalExamInfo.Is_Checked);
vltContext.Put("ID_Checker", onCustPhysicalExamInfo.ID_Checker);
vltContext.Put("Checker", onCustPhysicalExamInfo.Checker);
vltContext.Put("CheckedDate", onCustPhysicalExamInfo.CheckedDate.HasValue ? DateTime.Parse(onCustPhysicalExamInfo.CheckedDate.ToString()).ToString("yyyy-MM-dd") : "");
vltContext.Put("FinalOverView", onCustPhysicalExamInfo.FinalOverView.Replace("\n", "<br/>"));
vltContext.Put("FinalConclusion", onCustPhysicalExamInfo.FinalConclusion.Replace("\n", "<br/>"));
vltContext.Put("ResultCompare", onCustPhysicalExamInfo.ResultCompare.Replace("\n", "<br/>"));
vltContext.Put("MainDiagnose", onCustPhysicalExamInfo.MainDiagnose.Replace("\n", "<br/>"));
vltContext.Put("FinalDietGuide", onCustPhysicalExamInfo.FinalDietGuide.Replace("\n", "<br/>"));
vltContext.Put("FinalSportGuide", onCustPhysicalExamInfo.FinalSportGuide.Replace("\n", "<br/>"));
vltContext.Put("FinalHealthKnowlage", onCustPhysicalExamInfo.FinalHealthKnowlage.Replace("\n", "<br/>"));
if (onCustPhysicalExamInfo.Is_Checked == false)
{
vltContext.Put("RefuseReason", this.GetCustomerRefuseReason(ID_Customer));
}
}
}
}
}
public PEIS.Model.OnCustPhysicalExamInfo GetModel(long ID_Customer)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_Customer,CustomerName,Is_Team,ID_Team,Is_Paused,Is_SectionLock,ID_ExamType,ExamTypeName,ID_Set,SetName,ID_ExamPlace,ExamPlaceName,ID_GuideNurse,GuideNurse,ID_ReportWay,ReportWayName,ID_FeeWay,FeeWayName,SecurityLevel,DiseaseLevel,Is_FeeSettled,Is_GuideSheetPrinted,Is_GuideSheetReturned,GuideSheetReturnedDate,GuideSheetReturnedby,Is_UseHideCode,Is_FinalFinished,ID_FinalDoctor,FinalDoctor,FinalDate,FinalOverView,FinalConclusion,ResultCompare,MainDiagnose,FinalDietGuide,FinalSportGuide,FinalHealthKnowlage,Is_Checked,ID_Checker,Checker,CheckedDate,Is_ReportReceipted,SubScribDate,OperateDate,ID_Operator,Operator,Note,Is_Subscribed,Invoice,ID_UserGuideSheetReturnedBy,ID_SubScriber,SubScriber,SubScriberOperDate,Is_ExamStarted,TeamName,IndicatorDiagnose,OtherDiagnose,ID_Gender,GenderName,ID_Marriage,MarriageName,ID_Nation,NationName,ID_Cultrul,CultrulName,ID_Vocation,VocationName,IDCard,ExamCard,Photo,BirthDay,Address,MobileNo,Email,SecondaryDiagnose,NormalDiagnose from OnCustPhysicalExamInfo ");
stringBuilder.Append(" where ID_Customer=@ID_Customer ");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Customer", SqlDbType.BigInt)
};
array[0].Value = ID_Customer;
PEIS.Model.OnCustPhysicalExamInfo onCustPhysicalExamInfo = new PEIS.Model.OnCustPhysicalExamInfo();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.OnCustPhysicalExamInfo result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_Customer"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Customer = long.Parse(dataSet.Tables[0].Rows[0]["ID_Customer"].ToString());
}
onCustPhysicalExamInfo.CustomerName = dataSet.Tables[0].Rows[0]["CustomerName"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_Team"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_Team"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_Team"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_Team = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_Team = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_Team"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Team = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Team"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_Paused"].ToString() != "")
{
onCustPhysicalExamInfo.Is_Paused = new int?(int.Parse(dataSet.Tables[0].Rows[0]["Is_Paused"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_SectionLock"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_SectionLock"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_SectionLock"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_SectionLock = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_SectionLock = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_ExamType"].ToString() != "")
{
onCustPhysicalExamInfo.ID_ExamType = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ExamType"].ToString()));
}
onCustPhysicalExamInfo.ExamTypeName = dataSet.Tables[0].Rows[0]["ExamTypeName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Set"].ToString() != "")
{
onCustPhysicalExamInfo.PEPackageID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Set"].ToString()));
}
onCustPhysicalExamInfo.PEPackageName = dataSet.Tables[0].Rows[0]["SetName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_ExamPlace"].ToString() != "")
{
onCustPhysicalExamInfo.ExamPlaceID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ExamPlace"].ToString()));
}
onCustPhysicalExamInfo.ExamPlaceName = dataSet.Tables[0].Rows[0]["ExamPlaceName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_GuideNurse"].ToString() != "")
{
onCustPhysicalExamInfo.ID_GuideNurse = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_GuideNurse"].ToString()));
}
onCustPhysicalExamInfo.GuideNurse = dataSet.Tables[0].Rows[0]["GuideNurse"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_ReportWay"].ToString() != "")
{
onCustPhysicalExamInfo.ID_ReportWay = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportWay"].ToString()));
}
onCustPhysicalExamInfo.ReportWayName = dataSet.Tables[0].Rows[0]["ReportWayName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_FeeWay"].ToString() != "")
{
onCustPhysicalExamInfo.ID_FeeWay = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_FeeWay"].ToString()));
}
onCustPhysicalExamInfo.FeeWayName = dataSet.Tables[0].Rows[0]["FeeWayName"].ToString();
if (dataSet.Tables[0].Rows[0]["SecurityLevel"].ToString() != "")
{
onCustPhysicalExamInfo.SecurityLevel = new int?(int.Parse(dataSet.Tables[0].Rows[0]["SecurityLevel"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["DiseaseLevel"].ToString() != "")
{
onCustPhysicalExamInfo.DiseaseLevel = new int?(int.Parse(dataSet.Tables[0].Rows[0]["DiseaseLevel"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_FeeSettled"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_FeeSettled"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_FeeSettled"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_FeeSettled = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_FeeSettled = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["Is_GuideSheetPrinted"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_GuideSheetPrinted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_GuideSheetPrinted"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_GuideSheetPrinted = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_GuideSheetPrinted = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["Is_GuideSheetReturned"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_GuideSheetReturned"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_GuideSheetReturned"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_GuideSheetReturned = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_GuideSheetReturned = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["GuideSheetReturnedDate"].ToString() != "")
{
onCustPhysicalExamInfo.GuideSheetReturnedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["GuideSheetReturnedDate"].ToString()));
}
onCustPhysicalExamInfo.GuideSheetReturnedby = dataSet.Tables[0].Rows[0]["GuideSheetReturnedby"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_UseHideCode"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_UseHideCode"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_UseHideCode"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_UseHideCode = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_UseHideCode = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["Is_FinalFinished"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_FinalFinished"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_FinalFinished"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_FinalFinished = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_FinalFinished = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_FinalDoctor"].ToString() != "")
{
onCustPhysicalExamInfo.ID_FinalDoctor = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_FinalDoctor"].ToString()));
}
onCustPhysicalExamInfo.FinalDoctor = dataSet.Tables[0].Rows[0]["FinalDoctor"].ToString();
if (dataSet.Tables[0].Rows[0]["FinalDate"].ToString() != "")
{
onCustPhysicalExamInfo.FinalDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["FinalDate"].ToString()));
}
onCustPhysicalExamInfo.FinalOverView = dataSet.Tables[0].Rows[0]["FinalOverView"].ToString();
onCustPhysicalExamInfo.FinalConclusion = dataSet.Tables[0].Rows[0]["FinalConclusion"].ToString();
onCustPhysicalExamInfo.ResultCompare = dataSet.Tables[0].Rows[0]["ResultCompare"].ToString();
onCustPhysicalExamInfo.MainDiagnose = dataSet.Tables[0].Rows[0]["MainDiagnose"].ToString();
onCustPhysicalExamInfo.FinalDietGuide = dataSet.Tables[0].Rows[0]["FinalDietGuide"].ToString();
onCustPhysicalExamInfo.FinalSportGuide = dataSet.Tables[0].Rows[0]["FinalSportGuide"].ToString();
onCustPhysicalExamInfo.FinalHealthKnowlage = dataSet.Tables[0].Rows[0]["FinalHealthKnowlage"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_Checked"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_Checked"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_Checked"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_Checked = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_Checked = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_Checker"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Checker = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Checker"].ToString()));
}
onCustPhysicalExamInfo.Checker = dataSet.Tables[0].Rows[0]["Checker"].ToString();
if (dataSet.Tables[0].Rows[0]["CheckedDate"].ToString() != "")
{
onCustPhysicalExamInfo.CheckedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["CheckedDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_ReportReceipted = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_ReportReceipted = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["SubScribDate"].ToString() != "")
{
onCustPhysicalExamInfo.SubScribDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["SubScribDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["OperateDate"].ToString() != "")
{
onCustPhysicalExamInfo.OperateDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["OperateDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_Operator"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Operator = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Operator"].ToString()));
}
onCustPhysicalExamInfo.Operator = dataSet.Tables[0].Rows[0]["Operator"].ToString();
onCustPhysicalExamInfo.Note = dataSet.Tables[0].Rows[0]["Note"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_Subscribed"].ToString() != "")
{
onCustPhysicalExamInfo.Is_Subscribed = new int?(int.Parse(dataSet.Tables[0].Rows[0]["Is_Subscribed"].ToString()));
}
onCustPhysicalExamInfo.Invoice = dataSet.Tables[0].Rows[0]["Invoice"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_UserGuideSheetReturnedBy"].ToString() != "")
{
onCustPhysicalExamInfo.ID_UserGuideSheetReturnedBy = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_UserGuideSheetReturnedBy"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_SubScriber"].ToString() != "")
{
onCustPhysicalExamInfo.ID_SubScriber = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_SubScriber"].ToString()));
}
onCustPhysicalExamInfo.SubScriber = dataSet.Tables[0].Rows[0]["SubScriber"].ToString();
if (dataSet.Tables[0].Rows[0]["SubScriberOperDate"].ToString() != "")
{
onCustPhysicalExamInfo.SubScriberOperDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["SubScriberOperDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_ExamStarted"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_ExamStarted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_ExamStarted"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_ExamStarted = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_ExamStarted = new bool?(false);
}
}
onCustPhysicalExamInfo.TeamName = dataSet.Tables[0].Rows[0]["TeamName"].ToString();
onCustPhysicalExamInfo.IndicatorDiagnose = dataSet.Tables[0].Rows[0]["IndicatorDiagnose"].ToString();
onCustPhysicalExamInfo.OtherDiagnose = dataSet.Tables[0].Rows[0]["OtherDiagnose"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Gender"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Gender = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Gender"].ToString()));
}
onCustPhysicalExamInfo.GenderName = dataSet.Tables[0].Rows[0]["GenderName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Marriage"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Marriage = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Marriage"].ToString()));
}
onCustPhysicalExamInfo.MarriageName = dataSet.Tables[0].Rows[0]["MarriageName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Nation"].ToString() != "")
{
onCustPhysicalExamInfo.NationID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Nation"].ToString()));
}
onCustPhysicalExamInfo.NationName = dataSet.Tables[0].Rows[0]["NationName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Cultrul"].ToString() != "")
{
onCustPhysicalExamInfo.CultrulID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Cultrul"].ToString()));
}
onCustPhysicalExamInfo.CultrulName = dataSet.Tables[0].Rows[0]["CultrulName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Vocation"].ToString() != "")
{
onCustPhysicalExamInfo.VocationID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Vocation"].ToString()));
}
onCustPhysicalExamInfo.VocationName = dataSet.Tables[0].Rows[0]["VocationName"].ToString();
onCustPhysicalExamInfo.IDCard = dataSet.Tables[0].Rows[0]["IDCard"].ToString();
onCustPhysicalExamInfo.ExamCard = dataSet.Tables[0].Rows[0]["ExamCard"].ToString();
if (dataSet.Tables[0].Rows[0]["Photo"].ToString() != "")
{
onCustPhysicalExamInfo.Photo = (byte[])dataSet.Tables[0].Rows[0]["Photo"];
}
if (dataSet.Tables[0].Rows[0]["BirthDay"].ToString() != "")
{
onCustPhysicalExamInfo.BirthDay = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["BirthDay"].ToString()));
}
onCustPhysicalExamInfo.Address = dataSet.Tables[0].Rows[0]["Address"].ToString();
onCustPhysicalExamInfo.MobileNo = dataSet.Tables[0].Rows[0]["MobileNo"].ToString();
onCustPhysicalExamInfo.Email = dataSet.Tables[0].Rows[0]["Email"].ToString();
onCustPhysicalExamInfo.SecondaryDiagnose = dataSet.Tables[0].Rows[0]["SecondaryDiagnose"].ToString();
onCustPhysicalExamInfo.NormalDiagnose = dataSet.Tables[0].Rows[0]["NormalDiagnose"].ToString();
result = onCustPhysicalExamInfo;
}
else
{
result = null;
}
return(result);
}
public void Add(PEIS.Model.OnCustPhysicalExamInfo model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into OnCustPhysicalExamInfo(");
stringBuilder.Append("ID_Customer,CustomerName,Is_Team,ID_Team,Is_Paused,Is_SectionLock,ID_ExamType,ExamTypeName,PEPackageID,PEPackageName,ExamPlaceID,ExamPlaceName,ID_GuideNurse,GuideNurse,ID_ReportWay,ReportWayName,ID_FeeWay,FeeWayName,SecurityLevel,DiseaseLevel,Is_FeeSettled,Is_GuideSheetPrinted,Is_GuideSheetReturned,GuideSheetReturnedDate,GuideSheetReturnedby,Is_UseHideCode,Is_FinalFinished,ID_FinalDoctor,FinalDoctor,FinalDate,FinalOverView,FinalConclusion,ResultCompare,MainDiagnose,FinalDietGuide,FinalSportGuide,FinalHealthKnowlage,Is_Checked,ID_Checker,Checker,CheckedDate,Is_ReportReceipted,SubScribDate,OperateDate,ID_Operator,Operator,Note,Is_Subscribed,Invoice,ID_UserGuideSheetReturnedBy,ID_SubScriber,SubScriber,SubScriberOperDate,Is_ExamStarted,TeamName,IndicatorDiagnose,OtherDiagnose,ID_Gender,GenderName,ID_Marriage,MarriageName,NationID,NationName,CultrulID,CultrulName,VocationID,VocationName,IDCard,ExamCard,Photo,BirthDay,Address,MobileNo,Email,SecondaryDiagnose,NormalDiagnose)");
stringBuilder.Append(" values (");
stringBuilder.Append("@ID_Customer,@CustomerName,@Is_Team,@ID_Team,@Is_Paused,@Is_SectionLock,@ID_ExamType,@ExamTypeName,@PEPackageID,@PEPackageName,@ExamPlaceID,@ExamPlaceName,@ID_GuideNurse,@GuideNurse,@ID_ReportWay,@ReportWayName,@ID_FeeWay,@FeeWayName,@SecurityLevel,@DiseaseLevel,@Is_FeeSettled,@Is_GuideSheetPrinted,@Is_GuideSheetReturned,@GuideSheetReturnedDate,@GuideSheetReturnedby,@Is_UseHideCode,@Is_FinalFinished,@ID_FinalDoctor,@FinalDoctor,@FinalDate,@FinalOverView,@FinalConclusion,@ResultCompare,@MainDiagnose,@FinalDietGuide,@FinalSportGuide,@FinalHealthKnowlage,@Is_Checked,@ID_Checker,@Checker,@CheckedDate,@Is_ReportReceipted,@SubScribDate,@OperateDate,@ID_Operator,@Operator,@Note,@Is_Subscribed,@Invoice,@ID_UserGuideSheetReturnedBy,@ID_SubScriber,@SubScriber,@SubScriberOperDate,@Is_ExamStarted,@TeamName,@IndicatorDiagnose,@OtherDiagnose,@ID_Gender,@GenderName,@ID_Marriage,@MarriageName,@NationID,@NationName,@CultrulID,@CultrulName,@VocationID,@VocationName,@IDCard,@ExamCard,@Photo,@BirthDay,@Address,@MobileNo,@Email,@SecondaryDiagnose,@NormalDiagnose)");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8),
new SqlParameter("@CustomerName", SqlDbType.VarChar, 30),
new SqlParameter("@Is_Team", SqlDbType.Bit, 1),
new SqlParameter("@ID_Team", SqlDbType.Int, 4),
new SqlParameter("@Is_Paused", SqlDbType.Int, 4),
new SqlParameter("@Is_SectionLock", SqlDbType.Bit, 1),
new SqlParameter("@ID_ExamType", SqlDbType.Int, 4),
new SqlParameter("@ExamTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@PEPackageID", SqlDbType.Int, 4),
new SqlParameter("@PEPackageName", SqlDbType.VarChar, 50),
new SqlParameter("@ExamPlaceID", SqlDbType.Int, 4),
new SqlParameter("@ExamPlaceName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_GuideNurse", SqlDbType.Int, 4),
new SqlParameter("@GuideNurse", SqlDbType.VarChar, 30),
new SqlParameter("@ID_ReportWay", SqlDbType.Int, 4),
new SqlParameter("@ReportWayName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_FeeWay", SqlDbType.Int, 4),
new SqlParameter("@FeeWayName", SqlDbType.VarChar, 50),
new SqlParameter("@SecurityLevel", SqlDbType.Int, 4),
new SqlParameter("@DiseaseLevel", SqlDbType.Int, 4),
new SqlParameter("@Is_FeeSettled", SqlDbType.Bit, 1),
new SqlParameter("@Is_GuideSheetPrinted", SqlDbType.Bit, 1),
new SqlParameter("@Is_GuideSheetReturned", SqlDbType.Bit, 1),
new SqlParameter("@GuideSheetReturnedDate", SqlDbType.DateTime),
new SqlParameter("@GuideSheetReturnedby", SqlDbType.VarChar, 30),
new SqlParameter("@Is_UseHideCode", SqlDbType.Bit, 1),
new SqlParameter("@Is_FinalFinished", SqlDbType.Bit, 1),
new SqlParameter("@ID_FinalDoctor", SqlDbType.Int, 4),
new SqlParameter("@FinalDoctor", SqlDbType.VarChar, 30),
new SqlParameter("@FinalDate", SqlDbType.DateTime),
new SqlParameter("@FinalOverView", SqlDbType.Text),
new SqlParameter("@FinalConclusion", SqlDbType.Text),
new SqlParameter("@ResultCompare", SqlDbType.Text),
new SqlParameter("@MainDiagnose", SqlDbType.Text),
new SqlParameter("@FinalDietGuide", SqlDbType.Text),
new SqlParameter("@FinalSportGuide", SqlDbType.Text),
new SqlParameter("@FinalHealthKnowlage", SqlDbType.Text),
new SqlParameter("@Is_Checked", SqlDbType.Bit, 1),
new SqlParameter("@ID_Checker", SqlDbType.Int, 4),
new SqlParameter("@Checker", SqlDbType.VarChar, 30),
new SqlParameter("@CheckedDate", SqlDbType.DateTime),
new SqlParameter("@Is_ReportReceipted", SqlDbType.Bit, 1),
new SqlParameter("@SubScribDate", SqlDbType.DateTime),
new SqlParameter("@OperateDate", SqlDbType.DateTime),
new SqlParameter("@ID_Operator", SqlDbType.Int, 4),
new SqlParameter("@Operator", SqlDbType.VarChar, 30),
new SqlParameter("@Note", SqlDbType.VarChar, 200),
new SqlParameter("@Is_Subscribed", SqlDbType.Int, 4),
new SqlParameter("@Invoice", SqlDbType.VarChar, 200),
new SqlParameter("@ID_UserGuideSheetReturnedBy", SqlDbType.Int, 4),
new SqlParameter("@ID_SubScriber", SqlDbType.Int, 4),
new SqlParameter("@SubScriber", SqlDbType.VarChar, 30),
new SqlParameter("@SubScriberOperDate", SqlDbType.DateTime),
new SqlParameter("@Is_ExamStarted", SqlDbType.Bit, 1),
new SqlParameter("@TeamName", SqlDbType.VarChar, 50),
new SqlParameter("@IndicatorDiagnose", SqlDbType.Text),
new SqlParameter("@OtherDiagnose", SqlDbType.Text),
new SqlParameter("@ID_Gender", SqlDbType.Int, 4),
new SqlParameter("@GenderName", SqlDbType.VarChar, 8),
new SqlParameter("@ID_Marriage", SqlDbType.Int, 4),
new SqlParameter("@MarriageName", SqlDbType.VarChar, 8),
new SqlParameter("@NationID", SqlDbType.Int, 4),
new SqlParameter("@NationName", SqlDbType.VarChar, 10),
new SqlParameter("@CultrulID", SqlDbType.Int, 4),
new SqlParameter("@CultrulName", SqlDbType.VarChar, 10),
new SqlParameter("@VocationID", SqlDbType.Int, 4),
new SqlParameter("@VocationName", SqlDbType.VarChar, 10),
new SqlParameter("@IDCard", SqlDbType.VarChar, 30),
new SqlParameter("@ExamCard", SqlDbType.VarChar, 30),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@BirthDay", SqlDbType.DateTime),
new SqlParameter("@Address", SqlDbType.VarChar, 360),
new SqlParameter("@MobileNo", SqlDbType.VarChar, 120),
new SqlParameter("@Email", SqlDbType.VarChar, 240),
new SqlParameter("@SecondaryDiagnose", SqlDbType.Text),
new SqlParameter("@NormalDiagnose", SqlDbType.Text)
};
array[0].Value = model.ID_Customer;
array[1].Value = model.CustomerName;
array[2].Value = model.Is_Team;
array[3].Value = model.ID_Team;
array[4].Value = model.Is_Paused;
array[5].Value = model.Is_SectionLock;
array[6].Value = model.ID_ExamType;
array[7].Value = model.ExamTypeName;
array[8].Value = model.PEPackageID;
array[9].Value = model.PEPackageName;
array[10].Value = model.ExamPlaceID;
array[11].Value = model.ExamPlaceName;
array[12].Value = model.ID_GuideNurse;
array[13].Value = model.GuideNurse;
array[14].Value = model.ID_ReportWay;
array[15].Value = model.ReportWayName;
array[16].Value = model.ID_FeeWay;
array[17].Value = model.FeeWayName;
array[18].Value = model.SecurityLevel;
array[19].Value = model.DiseaseLevel;
array[20].Value = model.Is_FeeSettled;
array[21].Value = model.Is_GuideSheetPrinted;
array[22].Value = model.Is_GuideSheetReturned;
array[23].Value = model.GuideSheetReturnedDate;
array[24].Value = model.GuideSheetReturnedby;
array[25].Value = model.Is_UseHideCode;
array[26].Value = model.Is_FinalFinished;
array[27].Value = model.ID_FinalDoctor;
array[28].Value = model.FinalDoctor;
array[29].Value = model.FinalDate;
array[30].Value = model.FinalOverView;
array[31].Value = model.FinalConclusion;
array[32].Value = model.ResultCompare;
array[33].Value = model.MainDiagnose;
array[34].Value = model.FinalDietGuide;
array[35].Value = model.FinalSportGuide;
array[36].Value = model.FinalHealthKnowlage;
array[37].Value = model.Is_Checked;
array[38].Value = model.ID_Checker;
array[39].Value = model.Checker;
array[40].Value = model.CheckedDate;
array[41].Value = model.Is_ReportReceipted;
array[42].Value = model.SubScribDate;
array[43].Value = model.OperateDate;
array[44].Value = model.ID_Operator;
array[45].Value = model.Operator;
array[46].Value = model.Note;
array[47].Value = model.Is_Subscribed;
array[48].Value = model.Invoice;
array[49].Value = model.ID_UserGuideSheetReturnedBy;
array[50].Value = model.ID_SubScriber;
array[51].Value = model.SubScriber;
array[52].Value = model.SubScriberOperDate;
array[53].Value = model.Is_ExamStarted;
array[54].Value = model.TeamName;
array[55].Value = model.IndicatorDiagnose;
array[56].Value = model.OtherDiagnose;
array[57].Value = model.ID_Gender;
array[58].Value = model.GenderName;
array[59].Value = model.ID_Marriage;
array[60].Value = model.MarriageName;
array[61].Value = model.NationID;
array[62].Value = model.NationName;
array[63].Value = model.CultrulID;
array[64].Value = model.CultrulName;
array[65].Value = model.VocationID;
array[66].Value = model.VocationName;
array[67].Value = model.IDCard;
array[68].Value = model.ExamCard;
array[69].Value = model.Photo;
array[70].Value = model.BirthDay;
array[71].Value = model.Address;
array[72].Value = model.MobileNo;
array[73].Value = model.Email;
array[74].Value = model.SecondaryDiagnose;
array[75].Value = model.NormalDiagnose;
DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
}
public bool Update(PEIS.Model.OnCustPhysicalExamInfo model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update OnCustPhysicalExamInfo set ");
stringBuilder.Append("CustomerName=@CustomerName,");
stringBuilder.Append("Is_Team=@Is_Team,");
stringBuilder.Append("ID_Team=@ID_Team,");
stringBuilder.Append("Is_Paused=@Is_Paused,");
stringBuilder.Append("Is_SectionLock=@Is_SectionLock,");
stringBuilder.Append("ID_ExamType=@ID_ExamType,");
stringBuilder.Append("ExamTypeName=@ExamTypeName,");
stringBuilder.Append("PEPackageID=@PEPackageID,");
stringBuilder.Append("PEPackageName=@PEPackageName,");
stringBuilder.Append("ExamPlaceID=@ExamPlaceID,");
stringBuilder.Append("ExamPlaceName=@ExamPlaceName,");
stringBuilder.Append("ID_GuideNurse=@ID_GuideNurse,");
stringBuilder.Append("GuideNurse=@GuideNurse,");
stringBuilder.Append("ID_ReportWay=@ID_ReportWay,");
stringBuilder.Append("ReportWayName=@ReportWayName,");
stringBuilder.Append("ID_FeeWay=@ID_FeeWay,");
stringBuilder.Append("FeeWayName=@FeeWayName,");
stringBuilder.Append("SecurityLevel=@SecurityLevel,");
stringBuilder.Append("DiseaseLevel=@DiseaseLevel,");
stringBuilder.Append("Is_FeeSettled=@Is_FeeSettled,");
stringBuilder.Append("Is_GuideSheetPrinted=@Is_GuideSheetPrinted,");
stringBuilder.Append("Is_GuideSheetReturned=@Is_GuideSheetReturned,");
stringBuilder.Append("GuideSheetReturnedDate=@GuideSheetReturnedDate,");
stringBuilder.Append("GuideSheetReturnedby=@GuideSheetReturnedby,");
stringBuilder.Append("Is_UseHideCode=@Is_UseHideCode,");
stringBuilder.Append("Is_FinalFinished=@Is_FinalFinished,");
stringBuilder.Append("ID_FinalDoctor=@ID_FinalDoctor,");
stringBuilder.Append("FinalDoctor=@FinalDoctor,");
stringBuilder.Append("FinalDate=@FinalDate,");
stringBuilder.Append("FinalOverView=@FinalOverView,");
stringBuilder.Append("FinalConclusion=@FinalConclusion,");
stringBuilder.Append("ResultCompare=@ResultCompare,");
stringBuilder.Append("MainDiagnose=@MainDiagnose,");
stringBuilder.Append("FinalDietGuide=@FinalDietGuide,");
stringBuilder.Append("FinalSportGuide=@FinalSportGuide,");
stringBuilder.Append("FinalHealthKnowlage=@FinalHealthKnowlage,");
stringBuilder.Append("Is_Checked=@Is_Checked,");
stringBuilder.Append("ID_Checker=@ID_Checker,");
stringBuilder.Append("Checker=@Checker,");
stringBuilder.Append("CheckedDate=@CheckedDate,");
stringBuilder.Append("Is_ReportReceipted=@Is_ReportReceipted,");
stringBuilder.Append("SubScribDate=@SubScribDate,");
stringBuilder.Append("OperateDate=@OperateDate,");
stringBuilder.Append("ID_Operator=@ID_Operator,");
stringBuilder.Append("Operator=@Operator,");
stringBuilder.Append("Note=@Note,");
stringBuilder.Append("Is_Subscribed=@Is_Subscribed,");
stringBuilder.Append("Invoice=@Invoice,");
stringBuilder.Append("ID_UserGuideSheetReturnedBy=@ID_UserGuideSheetReturnedBy,");
stringBuilder.Append("ID_SubScriber=@ID_SubScriber,");
stringBuilder.Append("SubScriber=@SubScriber,");
stringBuilder.Append("SubScriberOperDate=@SubScriberOperDate,");
stringBuilder.Append("Is_ExamStarted=@Is_ExamStarted,");
stringBuilder.Append("TeamName=@TeamName,");
stringBuilder.Append("IndicatorDiagnose=@IndicatorDiagnose,");
stringBuilder.Append("OtherDiagnose=@OtherDiagnose,");
stringBuilder.Append("ID_Gender=@ID_Gender,");
stringBuilder.Append("GenderName=@GenderName,");
stringBuilder.Append("ID_Marriage=@ID_Marriage,");
stringBuilder.Append("MarriageName=@MarriageName,");
stringBuilder.Append("NationID=@NationID,");
stringBuilder.Append("NationName=@NationName,");
stringBuilder.Append("CultrulID=@CultrulID,");
stringBuilder.Append("CultrulName=@CultrulName,");
stringBuilder.Append("VocationID=@VocationID,");
stringBuilder.Append("VocationName=@VocationName,");
stringBuilder.Append("IDCard=@IDCard,");
stringBuilder.Append("ExamCard=@ExamCard,");
stringBuilder.Append("Photo=@Photo,");
stringBuilder.Append("BirthDay=@BirthDay,");
stringBuilder.Append("Address=@Address,");
stringBuilder.Append("MobileNo=@MobileNo,");
stringBuilder.Append("Email=@Email,");
stringBuilder.Append("SecondaryDiagnose=@SecondaryDiagnose,");
stringBuilder.Append("NormalDiagnose=@NormalDiagnose");
stringBuilder.Append(" where ID_Customer=@ID_Customer ");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@CustomerName", SqlDbType.VarChar, 30),
new SqlParameter("@Is_Team", SqlDbType.Bit, 1),
new SqlParameter("@ID_Team", SqlDbType.Int, 4),
new SqlParameter("@Is_Paused", SqlDbType.Int, 4),
new SqlParameter("@Is_SectionLock", SqlDbType.Bit, 1),
new SqlParameter("@ID_ExamType", SqlDbType.Int, 4),
new SqlParameter("@ExamTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@PEPackageID", SqlDbType.Int, 4),
new SqlParameter("@PEPackageName", SqlDbType.VarChar, 50),
new SqlParameter("@ExamPlaceID", SqlDbType.Int, 4),
new SqlParameter("@ExamPlaceName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_GuideNurse", SqlDbType.Int, 4),
new SqlParameter("@GuideNurse", SqlDbType.VarChar, 30),
new SqlParameter("@ID_ReportWay", SqlDbType.Int, 4),
new SqlParameter("@ReportWayName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_FeeWay", SqlDbType.Int, 4),
new SqlParameter("@FeeWayName", SqlDbType.VarChar, 50),
new SqlParameter("@SecurityLevel", SqlDbType.Int, 4),
new SqlParameter("@DiseaseLevel", SqlDbType.Int, 4),
new SqlParameter("@Is_FeeSettled", SqlDbType.Bit, 1),
new SqlParameter("@Is_GuideSheetPrinted", SqlDbType.Bit, 1),
new SqlParameter("@Is_GuideSheetReturned", SqlDbType.Bit, 1),
new SqlParameter("@GuideSheetReturnedDate", SqlDbType.DateTime),
new SqlParameter("@GuideSheetReturnedby", SqlDbType.VarChar, 30),
new SqlParameter("@Is_UseHideCode", SqlDbType.Bit, 1),
new SqlParameter("@Is_FinalFinished", SqlDbType.Bit, 1),
new SqlParameter("@ID_FinalDoctor", SqlDbType.Int, 4),
new SqlParameter("@FinalDoctor", SqlDbType.VarChar, 30),
new SqlParameter("@FinalDate", SqlDbType.DateTime),
new SqlParameter("@FinalOverView", SqlDbType.Text),
new SqlParameter("@FinalConclusion", SqlDbType.Text),
new SqlParameter("@ResultCompare", SqlDbType.Text),
new SqlParameter("@MainDiagnose", SqlDbType.Text),
new SqlParameter("@FinalDietGuide", SqlDbType.Text),
new SqlParameter("@FinalSportGuide", SqlDbType.Text),
new SqlParameter("@FinalHealthKnowlage", SqlDbType.Text),
new SqlParameter("@Is_Checked", SqlDbType.Bit, 1),
new SqlParameter("@ID_Checker", SqlDbType.Int, 4),
new SqlParameter("@Checker", SqlDbType.VarChar, 30),
new SqlParameter("@CheckedDate", SqlDbType.DateTime),
new SqlParameter("@Is_ReportReceipted", SqlDbType.Bit, 1),
new SqlParameter("@SubScribDate", SqlDbType.DateTime),
new SqlParameter("@OperateDate", SqlDbType.DateTime),
new SqlParameter("@ID_Operator", SqlDbType.Int, 4),
new SqlParameter("@Operator", SqlDbType.VarChar, 30),
new SqlParameter("@Note", SqlDbType.VarChar, 200),
new SqlParameter("@Is_Subscribed", SqlDbType.Int, 4),
new SqlParameter("@Invoice", SqlDbType.VarChar, 200),
new SqlParameter("@ID_UserGuideSheetReturnedBy", SqlDbType.Int, 4),
new SqlParameter("@ID_SubScriber", SqlDbType.Int, 4),
new SqlParameter("@SubScriber", SqlDbType.VarChar, 30),
new SqlParameter("@SubScriberOperDate", SqlDbType.DateTime),
new SqlParameter("@Is_ExamStarted", SqlDbType.Bit, 1),
new SqlParameter("@TeamName", SqlDbType.VarChar, 50),
new SqlParameter("@IndicatorDiagnose", SqlDbType.Text),
new SqlParameter("@OtherDiagnose", SqlDbType.Text),
new SqlParameter("@ID_Gender", SqlDbType.Int, 4),
new SqlParameter("@GenderName", SqlDbType.VarChar, 8),
new SqlParameter("@ID_Marriage", SqlDbType.Int, 4),
new SqlParameter("@MarriageName", SqlDbType.VarChar, 8),
new SqlParameter("@NationID", SqlDbType.Int, 4),
new SqlParameter("@NationName", SqlDbType.VarChar, 10),
new SqlParameter("@CultrulID", SqlDbType.Int, 4),
new SqlParameter("@CultrulName", SqlDbType.VarChar, 10),
new SqlParameter("@VocationID", SqlDbType.Int, 4),
new SqlParameter("@VocationName", SqlDbType.VarChar, 10),
new SqlParameter("@IDCard", SqlDbType.VarChar, 30),
new SqlParameter("@ExamCard", SqlDbType.VarChar, 30),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@BirthDay", SqlDbType.DateTime),
new SqlParameter("@Address", SqlDbType.VarChar, 360),
new SqlParameter("@MobileNo", SqlDbType.VarChar, 120),
new SqlParameter("@Email", SqlDbType.VarChar, 240),
new SqlParameter("@SecondaryDiagnose", SqlDbType.Text),
new SqlParameter("@NormalDiagnose", SqlDbType.Text),
new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8)
};
array[0].Value = model.CustomerName;
array[1].Value = model.Is_Team;
array[2].Value = model.ID_Team;
array[3].Value = model.Is_Paused;
array[4].Value = model.Is_SectionLock;
array[5].Value = model.ID_ExamType;
array[6].Value = model.ExamTypeName;
array[7].Value = model.PEPackageID;
array[8].Value = model.PEPackageName;
array[9].Value = model.ExamPlaceID;
array[10].Value = model.ExamPlaceName;
array[11].Value = model.ID_GuideNurse;
array[12].Value = model.GuideNurse;
array[13].Value = model.ID_ReportWay;
array[14].Value = model.ReportWayName;
array[15].Value = model.ID_FeeWay;
array[16].Value = model.FeeWayName;
array[17].Value = model.SecurityLevel;
array[18].Value = model.DiseaseLevel;
array[19].Value = model.Is_FeeSettled;
array[20].Value = model.Is_GuideSheetPrinted;
array[21].Value = model.Is_GuideSheetReturned;
array[22].Value = model.GuideSheetReturnedDate;
array[23].Value = model.GuideSheetReturnedby;
array[24].Value = model.Is_UseHideCode;
array[25].Value = model.Is_FinalFinished;
array[26].Value = model.ID_FinalDoctor;
array[27].Value = model.FinalDoctor;
array[28].Value = model.FinalDate;
array[29].Value = model.FinalOverView;
array[30].Value = model.FinalConclusion;
array[31].Value = model.ResultCompare;
array[32].Value = model.MainDiagnose;
array[33].Value = model.FinalDietGuide;
array[34].Value = model.FinalSportGuide;
array[35].Value = model.FinalHealthKnowlage;
array[36].Value = model.Is_Checked;
array[37].Value = model.ID_Checker;
array[38].Value = model.Checker;
array[39].Value = model.CheckedDate;
array[40].Value = model.Is_ReportReceipted;
array[41].Value = model.SubScribDate;
array[42].Value = model.OperateDate;
array[43].Value = model.ID_Operator;
array[44].Value = model.Operator;
array[45].Value = model.Note;
array[46].Value = model.Is_Subscribed;
array[47].Value = model.Invoice;
array[48].Value = model.ID_UserGuideSheetReturnedBy;
array[49].Value = model.ID_SubScriber;
array[50].Value = model.SubScriber;
array[51].Value = model.SubScriberOperDate;
array[52].Value = model.Is_ExamStarted;
array[53].Value = model.TeamName;
array[54].Value = model.IndicatorDiagnose;
array[55].Value = model.OtherDiagnose;
array[56].Value = model.ID_Gender;
array[57].Value = model.GenderName;
array[58].Value = model.ID_Marriage;
array[59].Value = model.MarriageName;
array[60].Value = model.NationID;
array[61].Value = model.NationName;
array[62].Value = model.CultrulID;
array[63].Value = model.CultrulName;
array[64].Value = model.VocationID;
array[65].Value = model.VocationName;
array[66].Value = model.IDCard;
array[67].Value = model.ExamCard;
array[68].Value = model.Photo;
array[69].Value = model.BirthDay;
array[70].Value = model.Address;
array[71].Value = model.MobileNo;
array[72].Value = model.Email;
array[73].Value = model.SecondaryDiagnose;
array[74].Value = model.NormalDiagnose;
array[75].Value = model.ID_Customer;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
public int UpdateCustomerNotFinalFinished(PEIS.Model.OnCustPhysicalExamInfo OCPEIModel)
{
return(CommonConclusion.dal.UpdateCustomerNotFinalFinished(OCPEIModel));
}
public int LockCustomerFinalCheck(PEIS.Model.OnCustPhysicalExamInfo OCPEIModel)
{
return(CommonConclusion.dal.LockCustomerFinalCheck(OCPEIModel));
}
public int UpdateFinalConclusionSectionLock(PEIS.Model.OnCustPhysicalExamInfo OCPEIModel)
{
return(CommonConclusion.dal.UpdateFinalConclusionSectionLock(OCPEIModel));
}
public int SaveFinalConclusionData(PEIS.Model.OnCustPhysicalExamInfo OCPEIModel, List <PEIS.Model.OnCustConclusion> OnCustConclusionList)
{
return(CommonConclusion.dal.SaveFinalConclusionData(OCPEIModel, OnCustConclusionList));
}
public int UpdateDiseaselLevelInform(PEIS.Model.OnCustPhysicalExamInfo OCPEIModel)
{
return(CommonCustExam.dal.UpdateDiseaselLevelInform(OCPEIModel));
}
public int UpdateGuideSheetReturnState(PEIS.Model.OnCustPhysicalExamInfo OCPEIModel)
{
return(CommonCustExam.dal.UpdateGuideSheetReturnState(OCPEIModel));
}
public List <PEIS.Model.OnCustPhysicalExamInfo> DataTableToList(DataTable dt)
{
List <PEIS.Model.OnCustPhysicalExamInfo> list = new List <PEIS.Model.OnCustPhysicalExamInfo>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.OnCustPhysicalExamInfo onCustPhysicalExamInfo = new PEIS.Model.OnCustPhysicalExamInfo();
if (dt.Rows[i]["ID_Customer"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Customer = long.Parse(dt.Rows[i]["ID_Customer"].ToString());
}
onCustPhysicalExamInfo.CustomerName = dt.Rows[i]["CustomerName"].ToString();
if (dt.Rows[i]["Is_Team"].ToString() != "")
{
if (dt.Rows[i]["Is_Team"].ToString() == "1" || dt.Rows[i]["Is_Team"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_Team = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_Team = new bool?(false);
}
}
if (dt.Rows[i]["ID_Team"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Team = new int?(int.Parse(dt.Rows[i]["ID_Team"].ToString()));
}
if (dt.Rows[i]["Is_Paused"].ToString() != "")
{
onCustPhysicalExamInfo.Is_Paused = new int?(int.Parse(dt.Rows[i]["Is_Paused"].ToString()));
}
if (dt.Rows[i]["Is_SectionLock"].ToString() != "")
{
if (dt.Rows[i]["Is_SectionLock"].ToString() == "1" || dt.Rows[i]["Is_SectionLock"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_SectionLock = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_SectionLock = new bool?(false);
}
}
if (dt.Rows[i]["ID_ExamType"].ToString() != "")
{
onCustPhysicalExamInfo.ID_ExamType = new int?(int.Parse(dt.Rows[i]["ID_ExamType"].ToString()));
}
onCustPhysicalExamInfo.ExamTypeName = dt.Rows[i]["ExamTypeName"].ToString();
if (dt.Rows[i]["PEPackageID"].ToString() != "")
{
onCustPhysicalExamInfo.PEPackageID = new int?(int.Parse(dt.Rows[i]["PEPackageID"].ToString()));
}
onCustPhysicalExamInfo.PEPackageName = dt.Rows[i]["PEPackageName"].ToString();
if (dt.Rows[i]["ExamPlaceID"].ToString() != "")
{
onCustPhysicalExamInfo.ExamPlaceID = new int?(int.Parse(dt.Rows[i]["ExamPlaceID"].ToString()));
}
onCustPhysicalExamInfo.ExamPlaceName = dt.Rows[i]["ExamPlaceName"].ToString();
if (dt.Rows[i]["ID_GuideNurse"].ToString() != "")
{
onCustPhysicalExamInfo.ID_GuideNurse = new int?(int.Parse(dt.Rows[i]["ID_GuideNurse"].ToString()));
}
onCustPhysicalExamInfo.GuideNurse = dt.Rows[i]["GuideNurse"].ToString();
if (dt.Rows[i]["ID_ReportWay"].ToString() != "")
{
onCustPhysicalExamInfo.ID_ReportWay = new int?(int.Parse(dt.Rows[i]["ID_ReportWay"].ToString()));
}
onCustPhysicalExamInfo.ReportWayName = dt.Rows[i]["ReportWayName"].ToString();
if (dt.Rows[i]["ID_FeeWay"].ToString() != "")
{
onCustPhysicalExamInfo.ID_FeeWay = new int?(int.Parse(dt.Rows[i]["ID_FeeWay"].ToString()));
}
onCustPhysicalExamInfo.FeeWayName = dt.Rows[i]["FeeWayName"].ToString();
if (dt.Rows[i]["SecurityLevel"].ToString() != "")
{
onCustPhysicalExamInfo.SecurityLevel = new int?(int.Parse(dt.Rows[i]["SecurityLevel"].ToString()));
}
if (dt.Rows[i]["DiseaseLevel"].ToString() != "")
{
onCustPhysicalExamInfo.DiseaseLevel = new int?(int.Parse(dt.Rows[i]["DiseaseLevel"].ToString()));
}
if (dt.Rows[i]["Is_FeeSettled"].ToString() != "")
{
if (dt.Rows[i]["Is_FeeSettled"].ToString() == "1" || dt.Rows[i]["Is_FeeSettled"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_FeeSettled = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_FeeSettled = new bool?(false);
}
}
if (dt.Rows[i]["Is_GuideSheetPrinted"].ToString() != "")
{
if (dt.Rows[i]["Is_GuideSheetPrinted"].ToString() == "1" || dt.Rows[i]["Is_GuideSheetPrinted"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_GuideSheetPrinted = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_GuideSheetPrinted = new bool?(false);
}
}
if (dt.Rows[i]["Is_GuideSheetReturned"].ToString() != "")
{
if (dt.Rows[i]["Is_GuideSheetReturned"].ToString() == "1" || dt.Rows[i]["Is_GuideSheetReturned"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_GuideSheetReturned = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_GuideSheetReturned = new bool?(false);
}
}
if (dt.Rows[i]["GuideSheetReturnedDate"].ToString() != "")
{
onCustPhysicalExamInfo.GuideSheetReturnedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["GuideSheetReturnedDate"].ToString()));
}
onCustPhysicalExamInfo.GuideSheetReturnedby = dt.Rows[i]["GuideSheetReturnedby"].ToString();
if (dt.Rows[i]["Is_UseHideCode"].ToString() != "")
{
if (dt.Rows[i]["Is_UseHideCode"].ToString() == "1" || dt.Rows[i]["Is_UseHideCode"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_UseHideCode = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_UseHideCode = new bool?(false);
}
}
if (dt.Rows[i]["Is_FinalFinished"].ToString() != "")
{
if (dt.Rows[i]["Is_FinalFinished"].ToString() == "1" || dt.Rows[i]["Is_FinalFinished"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_FinalFinished = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_FinalFinished = new bool?(false);
}
}
if (dt.Rows[i]["ID_FinalDoctor"].ToString() != "")
{
onCustPhysicalExamInfo.ID_FinalDoctor = new int?(int.Parse(dt.Rows[i]["ID_FinalDoctor"].ToString()));
}
onCustPhysicalExamInfo.FinalDoctor = dt.Rows[i]["FinalDoctor"].ToString();
if (dt.Rows[i]["FinalDate"].ToString() != "")
{
onCustPhysicalExamInfo.FinalDate = new DateTime?(DateTime.Parse(dt.Rows[i]["FinalDate"].ToString()));
}
onCustPhysicalExamInfo.FinalOverView = dt.Rows[i]["FinalOverView"].ToString();
onCustPhysicalExamInfo.FinalConclusion = dt.Rows[i]["FinalConclusion"].ToString();
onCustPhysicalExamInfo.ResultCompare = dt.Rows[i]["ResultCompare"].ToString();
onCustPhysicalExamInfo.MainDiagnose = dt.Rows[i]["MainDiagnose"].ToString();
onCustPhysicalExamInfo.FinalDietGuide = dt.Rows[i]["FinalDietGuide"].ToString();
onCustPhysicalExamInfo.FinalSportGuide = dt.Rows[i]["FinalSportGuide"].ToString();
onCustPhysicalExamInfo.FinalHealthKnowlage = dt.Rows[i]["FinalHealthKnowlage"].ToString();
if (dt.Rows[i]["Is_Checked"].ToString() != "")
{
if (dt.Rows[i]["Is_Checked"].ToString() == "1" || dt.Rows[i]["Is_Checked"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_Checked = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_Checked = new bool?(false);
}
}
if (dt.Rows[i]["ID_Checker"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Checker = new int?(int.Parse(dt.Rows[i]["ID_Checker"].ToString()));
}
onCustPhysicalExamInfo.Checker = dt.Rows[i]["Checker"].ToString();
if (dt.Rows[i]["CheckedDate"].ToString() != "")
{
onCustPhysicalExamInfo.CheckedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["CheckedDate"].ToString()));
}
if (dt.Rows[i]["Is_ReportReceipted"].ToString() != "")
{
if (dt.Rows[i]["Is_ReportReceipted"].ToString() == "1" || dt.Rows[i]["Is_ReportReceipted"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_ReportReceipted = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_ReportReceipted = new bool?(false);
}
}
if (dt.Rows[i]["SubScribDate"].ToString() != "")
{
onCustPhysicalExamInfo.SubScribDate = new DateTime?(DateTime.Parse(dt.Rows[i]["SubScribDate"].ToString()));
}
if (dt.Rows[i]["OperateDate"].ToString() != "")
{
onCustPhysicalExamInfo.OperateDate = new DateTime?(DateTime.Parse(dt.Rows[i]["OperateDate"].ToString()));
}
if (dt.Rows[i]["ID_Operator"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Operator = new int?(int.Parse(dt.Rows[i]["ID_Operator"].ToString()));
}
onCustPhysicalExamInfo.Operator = dt.Rows[i]["Operator"].ToString();
onCustPhysicalExamInfo.Note = dt.Rows[i]["Note"].ToString();
if (dt.Rows[i]["Is_Subscribed"].ToString() != "")
{
onCustPhysicalExamInfo.Is_Subscribed = new int?(int.Parse(dt.Rows[i]["Is_Subscribed"].ToString()));
}
onCustPhysicalExamInfo.Invoice = dt.Rows[i]["Invoice"].ToString();
if (dt.Rows[i]["ID_UserGuideSheetReturnedBy"].ToString() != "")
{
onCustPhysicalExamInfo.ID_UserGuideSheetReturnedBy = new int?(int.Parse(dt.Rows[i]["ID_UserGuideSheetReturnedBy"].ToString()));
}
if (dt.Rows[i]["ID_SubScriber"].ToString() != "")
{
onCustPhysicalExamInfo.ID_SubScriber = new int?(int.Parse(dt.Rows[i]["ID_SubScriber"].ToString()));
}
onCustPhysicalExamInfo.SubScriber = dt.Rows[i]["SubScriber"].ToString();
if (dt.Rows[i]["SubScriberOperDate"].ToString() != "")
{
onCustPhysicalExamInfo.SubScriberOperDate = new DateTime?(DateTime.Parse(dt.Rows[i]["SubScriberOperDate"].ToString()));
}
if (dt.Rows[i]["Is_ExamStarted"].ToString() != "")
{
if (dt.Rows[i]["Is_ExamStarted"].ToString() == "1" || dt.Rows[i]["Is_ExamStarted"].ToString().ToLower() == "true")
{
onCustPhysicalExamInfo.Is_ExamStarted = new bool?(true);
}
else
{
onCustPhysicalExamInfo.Is_ExamStarted = new bool?(false);
}
}
onCustPhysicalExamInfo.TeamName = dt.Rows[i]["TeamName"].ToString();
onCustPhysicalExamInfo.IndicatorDiagnose = dt.Rows[i]["IndicatorDiagnose"].ToString();
onCustPhysicalExamInfo.OtherDiagnose = dt.Rows[i]["OtherDiagnose"].ToString();
if (dt.Rows[i]["ID_Gender"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Gender = new int?(int.Parse(dt.Rows[i]["ID_Gender"].ToString()));
}
onCustPhysicalExamInfo.GenderName = dt.Rows[i]["GenderName"].ToString();
if (dt.Rows[i]["ID_Marriage"].ToString() != "")
{
onCustPhysicalExamInfo.ID_Marriage = new int?(int.Parse(dt.Rows[i]["ID_Marriage"].ToString()));
}
onCustPhysicalExamInfo.MarriageName = dt.Rows[i]["MarriageName"].ToString();
if (dt.Rows[i]["NationID"].ToString() != "")
{
onCustPhysicalExamInfo.NationID = new int?(int.Parse(dt.Rows[i]["NationID"].ToString()));
}
onCustPhysicalExamInfo.NationName = dt.Rows[i]["NationName"].ToString();
if (dt.Rows[i]["CultrulID"].ToString() != "")
{
onCustPhysicalExamInfo.CultrulID = new int?(int.Parse(dt.Rows[i]["CultrulID"].ToString()));
}
onCustPhysicalExamInfo.CultrulName = dt.Rows[i]["CultrulName"].ToString();
if (dt.Rows[i]["VocationID"].ToString() != "")
{
onCustPhysicalExamInfo.VocationID = new int?(int.Parse(dt.Rows[i]["VocationID"].ToString()));
}
onCustPhysicalExamInfo.VocationName = dt.Rows[i]["VocationName"].ToString();
onCustPhysicalExamInfo.IDCard = dt.Rows[i]["IDCard"].ToString();
onCustPhysicalExamInfo.ExamCard = dt.Rows[i]["ExamCard"].ToString();
if (dt.Rows[i]["Photo"].ToString() != "")
{
onCustPhysicalExamInfo.Photo = (byte[])dt.Rows[i]["Photo"];
}
if (dt.Rows[i]["BirthDay"].ToString() != "")
{
onCustPhysicalExamInfo.BirthDay = new DateTime?(DateTime.Parse(dt.Rows[i]["BirthDay"].ToString()));
}
onCustPhysicalExamInfo.Address = dt.Rows[i]["Address"].ToString();
onCustPhysicalExamInfo.MobileNo = dt.Rows[i]["MobileNo"].ToString();
onCustPhysicalExamInfo.Email = dt.Rows[i]["Email"].ToString();
onCustPhysicalExamInfo.SecondaryDiagnose = dt.Rows[i]["SecondaryDiagnose"].ToString();
onCustPhysicalExamInfo.NormalDiagnose = dt.Rows[i]["NormalDiagnose"].ToString();
list.Add(onCustPhysicalExamInfo);
}
}
return(list);
}
public bool Update(PEIS.Model.OnCustPhysicalExamInfo model)
{
return(this.dal.Update(model));
}
public void Add(PEIS.Model.OnCustPhysicalExamInfo model)
{
this.dal.Add(model);
}