public override void ReplaceContent(ref VelocityContext vltContext)
{
if (this.LoginUserModel == null)
{
base.Redirect("/Login.aspx?flag=logout");
}
vltContext.Put("webName", this.SiteName);
vltContext.Put("pageTitle", "欢迎页面");
vltContext.Put("UserName", this.LoginUserModel.UserName);
vltContext.Put("Sex", this.LoginUserModel.Sex);
string value;
if (this.LoginUserModel.LastLoginTime.HasValue)
{
value = Convert.ToDateTime(this.LoginUserModel.LastLoginTime.ToString()).ToString("yyyy年MM月dd日 HH:mm");
}
else
{
value = "首次登陆";
}
vltContext.Put("LastLoginTime", value);
vltContext.Put("ClientIP", Public.GetClientIP());
if (this.LoginUserModel.SectionID.HasValue && !string.IsNullOrEmpty(this.LoginUserModel.SectionID.ToString()))
{
PEIS.Model.SYSSection modelByCache = PEIS.BLL.SYSSection.Instance.GetModelByCache(int.Parse(this.LoginUserModel.SectionID.ToString()));
if (modelByCache != null)
{
vltContext.Put("UserSectionName", modelByCache.SectionName);
}
}
}
protected void GetEditSectionInfo(int SectionID, ref VelocityContext vltContext)
{
PEIS.Model.SYSSection model = PEIS.BLL.SYSSection.Instance.GetModel(SectionID);
vltContext.Put("SectionID", model.SectionID);
vltContext.Put("SectionName", model.SectionName);
vltContext.Put("FunctionType", model.FunctionType);
vltContext.Put("IsAutoApprove", model.IsAutoApprove);
vltContext.Put("IsOwnInterface", model.IsOwnInterface);
vltContext.Put("InterfaceType", model.InterfaceType);
vltContext.Put("PacsInterfaceFlag", model.PacsInterfaceFlag);
vltContext.Put("ImageType", model.ImageType);
vltContext.Put("IsNonPrintSectSummary", model.IsNonPrintSectSummary);
vltContext.Put("IsNotSamePage", model.IsNotSamePage);
vltContext.Put("PicPrintSetup", model.PicPrintSetup);
vltContext.Put("SummaryName", model.SummaryName);
vltContext.Put("DispOrder", model.DispOrder);
vltContext.Put("DefaultSummary", model.DefaultSummary);
vltContext.Put("SepBetweenExamItems", model.SepBetweenExamItems);
vltContext.Put("SepBetweenSymptoms", model.SepBetweenSymptoms);
vltContext.Put("TerminalSymbol", model.TerminalSymbol);
vltContext.Put("SepExamAndValue", model.SepExamAndValue);
vltContext.Put("NoBetweenExamItems", model.NoBetweenExamItems);
vltContext.Put("NoBetweenSympotms", model.NoBetweenSympotms);
vltContext.Put("IsNoEntryFinalSummary", model.IsNoEntryFinalSummary);
vltContext.Put("IsNonPrintInReport", model.IsNonPrintInReport);
vltContext.Put("IsDel", model.IsDel);
vltContext.Put("DisplayMenu", model.DisplayMenu);
vltContext.Put("Note", model.Note);
}
protected void GetNatSectionModel(ref VelocityContext vltContext, int SectionID, long CustomerID)
{
PEIS.Model.SYSSection modelByCache = PEIS.BLL.SYSSection.Instance.GetModelByCache(SectionID);
if (modelByCache != null)
{
vltContext.Put("SYSSectionModel", modelByCache);
}
}
protected void GetNatSectionModel(ref VelocityContext vltContext, int ID_Section, long CustomerID)
{
PEIS.Model.SYSSection modelByCache = PEIS.BLL.SYSSection.Instance.GetModelByCache(ID_Section);
if (modelByCache != null)
{
if (modelByCache.IsOwnInterface == true && modelByCache.InterfaceType == "LAB")
{
string url = string.Concat(new string[]
{
"/System/Exam/LabExamOperSingle.aspx?txtSectionID=",
ID_Section.ToString(),
"&txtCustomerID=",
CustomerID.ToString(),
"&date=",
base.Server.UrlEncode(DateTime.Now.ToString())
});
base.Redirect(url);
}
vltContext.Put("NatSectionModel", modelByCache);
}
}
public PEIS.Model.SYSSection GetModel(int SectionID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SectionID,SectionName,FunctionType,DisplayMenu,IsDel,InterfaceType,IsNotSamePage,IsNonPrintSectSummary,IsOwnInterface,IsAutoApprove,ImageType,PicPrintSetup,PacsInterfaceFlag,InputCode,DispOrder,SummaryName,DefaultSummary,SepBetweenExamItems,SepBetweenSymptoms,TerminalSymbol,SepExamAndValue,NoBetweenExamItems,NoBetweenSympotms,Note,IsNoEntryFinalSummary,IsNonPrintInReport,IsPrintBarCode from SYSSection ");
strSql.Append(" where SectionID=@SectionID");
SqlParameter[] parameters =
{
new SqlParameter("@SectionID", SqlDbType.Int, 4)
};
parameters[0].Value = SectionID;
PEIS.Model.SYSSection model = new PEIS.Model.SYSSection();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public int SaveSection(PEIS.Model.SYSSection SectionModel)
{
return(CommonConfig.dal.SaveSection(SectionModel));
}
public int Add(PEIS.Model.SYSSection model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SYSSection(");
strSql.Append("SectionName,FunctionType,DisplayMenu,IsDel,InterfaceType,IsNotSamePage,IsNonPrintSectSummary,IsOwnInterface,IsAutoApprove,ImageType,PicPrintSetup,PacsInterfaceFlag,InputCode,DispOrder,SummaryName,DefaultSummary,SepBetweenExamItems,SepBetweenSymptoms,TerminalSymbol,SepExamAndValue,NoBetweenExamItems,NoBetweenSympotms,Note,IsNoEntryFinalSummary,IsNonPrintInReport,IsPrintBarCode)");
strSql.Append(" values (");
strSql.Append("@SectionName,@FunctionType,@DisplayMenu,@IsDel,@InterfaceType,@IsNotSamePage,@IsNonPrintSectSummary,@IsOwnInterface,@IsAutoApprove,@ImageType,@PicPrintSetup,@PacsInterfaceFlag,@InputCode,@DispOrder,@SummaryName,@DefaultSummary,@SepBetweenExamItems,@SepBetweenSymptoms,@TerminalSymbol,@SepExamAndValue,@NoBetweenExamItems,@NoBetweenSympotms,@Note,@IsNoEntryFinalSummary,@IsNonPrintInReport,@IsPrintBarCode)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SectionName", SqlDbType.VarChar, 20),
new SqlParameter("@FunctionType", SqlDbType.Bit, 1),
new SqlParameter("@DisplayMenu", SqlDbType.VarChar, 80),
new SqlParameter("@IsDel", SqlDbType.Bit, 1),
new SqlParameter("@InterfaceType", SqlDbType.VarChar, 8),
new SqlParameter("@IsNotSamePage", SqlDbType.Bit, 1),
new SqlParameter("@IsNonPrintSectSummary", SqlDbType.Bit, 1),
new SqlParameter("@IsOwnInterface", SqlDbType.Bit, 1),
new SqlParameter("@IsAutoApprove", SqlDbType.Bit, 1),
new SqlParameter("@ImageType", SqlDbType.VarChar, 8),
new SqlParameter("@PicPrintSetup", SqlDbType.VarChar, 8),
new SqlParameter("@PacsInterfaceFlag", SqlDbType.VarChar, 8),
new SqlParameter("@InputCode", SqlDbType.VarChar, 10),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@SummaryName", SqlDbType.VarChar, 20),
new SqlParameter("@DefaultSummary", SqlDbType.Text),
new SqlParameter("@SepBetweenExamItems", SqlDbType.VarChar, 20),
new SqlParameter("@SepBetweenSymptoms", SqlDbType.VarChar, 20),
new SqlParameter("@TerminalSymbol", SqlDbType.VarChar, 20),
new SqlParameter("@SepExamAndValue", SqlDbType.VarChar, 20),
new SqlParameter("@NoBetweenExamItems", SqlDbType.VarChar, 20),
new SqlParameter("@NoBetweenSympotms", SqlDbType.VarChar, 20),
new SqlParameter("@Note", SqlDbType.VarChar, 50),
new SqlParameter("@IsNoEntryFinalSummary", SqlDbType.Bit, 1),
new SqlParameter("@IsNonPrintInReport", SqlDbType.Bit, 1),
new SqlParameter("@IsPrintBarCode", SqlDbType.Int, 4)
};
parameters[0].Value = model.SectionName;
parameters[1].Value = model.FunctionType;
parameters[2].Value = model.DisplayMenu;
parameters[3].Value = model.IsDel;
parameters[4].Value = model.InterfaceType;
parameters[5].Value = model.IsNotSamePage;
parameters[6].Value = model.IsNonPrintSectSummary;
parameters[7].Value = model.IsOwnInterface;
parameters[8].Value = model.IsAutoApprove;
parameters[9].Value = model.ImageType;
parameters[10].Value = model.PicPrintSetup;
parameters[11].Value = model.PacsInterfaceFlag;
parameters[12].Value = model.InputCode;
parameters[13].Value = model.DispOrder;
parameters[14].Value = model.SummaryName;
parameters[15].Value = model.DefaultSummary;
parameters[16].Value = model.SepBetweenExamItems;
parameters[17].Value = model.SepBetweenSymptoms;
parameters[18].Value = model.TerminalSymbol;
parameters[19].Value = model.SepExamAndValue;
parameters[20].Value = model.NoBetweenExamItems;
parameters[21].Value = model.NoBetweenSympotms;
parameters[22].Value = model.Note;
parameters[23].Value = model.IsNoEntryFinalSummary;
parameters[24].Value = model.IsNonPrintInReport;
parameters[25].Value = model.IsPrintBarCode;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public PEIS.Model.SYSSection DataRowToModel(DataRow row)
{
PEIS.Model.SYSSection model = new PEIS.Model.SYSSection();
if (row != null)
{
if (row["SectionID"] != null && row["SectionID"].ToString() != "")
{
model.SectionID = int.Parse(row["SectionID"].ToString());
}
if (row["SectionName"] != null)
{
model.SectionName = row["SectionName"].ToString();
}
if (row["FunctionType"] != null && row["FunctionType"].ToString() != "")
{
if ((row["FunctionType"].ToString() == "1") || (row["FunctionType"].ToString().ToLower() == "true"))
{
model.FunctionType = true;
}
else
{
model.FunctionType = false;
}
}
if (row["DisplayMenu"] != null)
{
model.DisplayMenu = row["DisplayMenu"].ToString();
}
if (row["IsDel"] != null && row["IsDel"].ToString() != "")
{
if ((row["IsDel"].ToString() == "1") || (row["IsDel"].ToString().ToLower() == "true"))
{
model.IsDel = true;
}
else
{
model.IsDel = false;
}
}
if (row["InterfaceType"] != null)
{
model.InterfaceType = row["InterfaceType"].ToString();
}
if (row["IsNotSamePage"] != null && row["IsNotSamePage"].ToString() != "")
{
if ((row["IsNotSamePage"].ToString() == "1") || (row["IsNotSamePage"].ToString().ToLower() == "true"))
{
model.IsNotSamePage = true;
}
else
{
model.IsNotSamePage = false;
}
}
if (row["IsNonPrintSectSummary"] != null && row["IsNonPrintSectSummary"].ToString() != "")
{
if ((row["IsNonPrintSectSummary"].ToString() == "1") || (row["IsNonPrintSectSummary"].ToString().ToLower() == "true"))
{
model.IsNonPrintSectSummary = true;
}
else
{
model.IsNonPrintSectSummary = false;
}
}
if (row["IsOwnInterface"] != null && row["IsOwnInterface"].ToString() != "")
{
if ((row["IsOwnInterface"].ToString() == "1") || (row["IsOwnInterface"].ToString().ToLower() == "true"))
{
model.IsOwnInterface = true;
}
else
{
model.IsOwnInterface = false;
}
}
if (row["IsAutoApprove"] != null && row["IsAutoApprove"].ToString() != "")
{
if ((row["IsAutoApprove"].ToString() == "1") || (row["IsAutoApprove"].ToString().ToLower() == "true"))
{
model.IsAutoApprove = true;
}
else
{
model.IsAutoApprove = false;
}
}
if (row["ImageType"] != null)
{
model.ImageType = row["ImageType"].ToString();
}
if (row["PicPrintSetup"] != null)
{
model.PicPrintSetup = row["PicPrintSetup"].ToString();
}
if (row["PacsInterfaceFlag"] != null)
{
model.PacsInterfaceFlag = row["PacsInterfaceFlag"].ToString();
}
if (row["InputCode"] != null)
{
model.InputCode = row["InputCode"].ToString();
}
if (row["DispOrder"] != null && row["DispOrder"].ToString() != "")
{
model.DispOrder = int.Parse(row["DispOrder"].ToString());
}
if (row["SummaryName"] != null)
{
model.SummaryName = row["SummaryName"].ToString();
}
if (row["DefaultSummary"] != null)
{
model.DefaultSummary = row["DefaultSummary"].ToString();
}
if (row["SepBetweenExamItems"] != null)
{
model.SepBetweenExamItems = row["SepBetweenExamItems"].ToString();
}
if (row["SepBetweenSymptoms"] != null)
{
model.SepBetweenSymptoms = row["SepBetweenSymptoms"].ToString();
}
if (row["TerminalSymbol"] != null)
{
model.TerminalSymbol = row["TerminalSymbol"].ToString();
}
if (row["SepExamAndValue"] != null)
{
model.SepExamAndValue = row["SepExamAndValue"].ToString();
}
if (row["NoBetweenExamItems"] != null)
{
model.NoBetweenExamItems = row["NoBetweenExamItems"].ToString();
}
if (row["NoBetweenSympotms"] != null)
{
model.NoBetweenSympotms = row["NoBetweenSympotms"].ToString();
}
if (row["Note"] != null)
{
model.Note = row["Note"].ToString();
}
if (row["IsNoEntryFinalSummary"] != null && row["IsNoEntryFinalSummary"].ToString() != "")
{
if ((row["IsNoEntryFinalSummary"].ToString() == "1") || (row["IsNoEntryFinalSummary"].ToString().ToLower() == "true"))
{
model.IsNoEntryFinalSummary = true;
}
else
{
model.IsNoEntryFinalSummary = false;
}
}
if (row["IsNonPrintInReport"] != null && row["IsNonPrintInReport"].ToString() != "")
{
if ((row["IsNonPrintInReport"].ToString() == "1") || (row["IsNonPrintInReport"].ToString().ToLower() == "true"))
{
model.IsNonPrintInReport = true;
}
else
{
model.IsNonPrintInReport = false;
}
}
if (row["IsPrintBarCode"] != null && row["IsPrintBarCode"].ToString() != "")
{
model.IsPrintBarCode = int.Parse(row["IsPrintBarCode"].ToString());
}
}
return(model);
}
public bool Update(PEIS.Model.SYSSection model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SYSSection set ");
strSql.Append("SectionName=@SectionName,");
strSql.Append("FunctionType=@FunctionType,");
strSql.Append("DisplayMenu=@DisplayMenu,");
strSql.Append("IsDel=@IsDel,");
strSql.Append("InterfaceType=@InterfaceType,");
strSql.Append("IsNotSamePage=@IsNotSamePage,");
strSql.Append("IsNonPrintSectSummary=@IsNonPrintSectSummary,");
strSql.Append("IsOwnInterface=@IsOwnInterface,");
strSql.Append("IsAutoApprove=@IsAutoApprove,");
strSql.Append("ImageType=@ImageType,");
strSql.Append("PicPrintSetup=@PicPrintSetup,");
strSql.Append("PacsInterfaceFlag=@PacsInterfaceFlag,");
strSql.Append("InputCode=@InputCode,");
strSql.Append("DispOrder=@DispOrder,");
strSql.Append("SummaryName=@SummaryName,");
strSql.Append("DefaultSummary=@DefaultSummary,");
strSql.Append("SepBetweenExamItems=@SepBetweenExamItems,");
strSql.Append("SepBetweenSymptoms=@SepBetweenSymptoms,");
strSql.Append("TerminalSymbol=@TerminalSymbol,");
strSql.Append("SepExamAndValue=@SepExamAndValue,");
strSql.Append("NoBetweenExamItems=@NoBetweenExamItems,");
strSql.Append("NoBetweenSympotms=@NoBetweenSympotms,");
strSql.Append("Note=@Note,");
strSql.Append("IsNoEntryFinalSummary=@IsNoEntryFinalSummary,");
strSql.Append("IsNonPrintInReport=@IsNonPrintInReport,");
strSql.Append("IsPrintBarCode=@IsPrintBarCode");
strSql.Append(" where SectionID=@SectionID");
SqlParameter[] parameters =
{
new SqlParameter("@SectionName", SqlDbType.VarChar, 20),
new SqlParameter("@FunctionType", SqlDbType.Bit, 1),
new SqlParameter("@DisplayMenu", SqlDbType.VarChar, 80),
new SqlParameter("@IsDel", SqlDbType.Bit, 1),
new SqlParameter("@InterfaceType", SqlDbType.VarChar, 8),
new SqlParameter("@IsNotSamePage", SqlDbType.Bit, 1),
new SqlParameter("@IsNonPrintSectSummary", SqlDbType.Bit, 1),
new SqlParameter("@IsOwnInterface", SqlDbType.Bit, 1),
new SqlParameter("@IsAutoApprove", SqlDbType.Bit, 1),
new SqlParameter("@ImageType", SqlDbType.VarChar, 8),
new SqlParameter("@PicPrintSetup", SqlDbType.VarChar, 8),
new SqlParameter("@PacsInterfaceFlag", SqlDbType.VarChar, 8),
new SqlParameter("@InputCode", SqlDbType.VarChar, 10),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@SummaryName", SqlDbType.VarChar, 20),
new SqlParameter("@DefaultSummary", SqlDbType.Text),
new SqlParameter("@SepBetweenExamItems", SqlDbType.VarChar, 20),
new SqlParameter("@SepBetweenSymptoms", SqlDbType.VarChar, 20),
new SqlParameter("@TerminalSymbol", SqlDbType.VarChar, 20),
new SqlParameter("@SepExamAndValue", SqlDbType.VarChar, 20),
new SqlParameter("@NoBetweenExamItems", SqlDbType.VarChar, 20),
new SqlParameter("@NoBetweenSympotms", SqlDbType.VarChar, 20),
new SqlParameter("@Note", SqlDbType.VarChar, 50),
new SqlParameter("@IsNoEntryFinalSummary", SqlDbType.Bit, 1),
new SqlParameter("@IsNonPrintInReport", SqlDbType.Bit, 1),
new SqlParameter("@IsPrintBarCode", SqlDbType.Int, 4),
new SqlParameter("@SectionID", SqlDbType.Int, 4)
};
parameters[0].Value = model.SectionName;
parameters[1].Value = model.FunctionType;
parameters[2].Value = model.DisplayMenu;
parameters[3].Value = model.IsDel;
parameters[4].Value = model.InterfaceType;
parameters[5].Value = model.IsNotSamePage;
parameters[6].Value = model.IsNonPrintSectSummary;
parameters[7].Value = model.IsOwnInterface;
parameters[8].Value = model.IsAutoApprove;
parameters[9].Value = model.ImageType;
parameters[10].Value = model.PicPrintSetup;
parameters[11].Value = model.PacsInterfaceFlag;
parameters[12].Value = model.InputCode;
parameters[13].Value = model.DispOrder;
parameters[14].Value = model.SummaryName;
parameters[15].Value = model.DefaultSummary;
parameters[16].Value = model.SepBetweenExamItems;
parameters[17].Value = model.SepBetweenSymptoms;
parameters[18].Value = model.TerminalSymbol;
parameters[19].Value = model.SepExamAndValue;
parameters[20].Value = model.NoBetweenExamItems;
parameters[21].Value = model.NoBetweenSympotms;
parameters[22].Value = model.Note;
parameters[23].Value = model.IsNoEntryFinalSummary;
parameters[24].Value = model.IsNonPrintInReport;
parameters[25].Value = model.IsPrintBarCode;
parameters[26].Value = model.SectionID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(PEIS.Model.SYSSection model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.SYSSection model)
{
return(this.dal.Add(model));
}
