/// <summary>
/// 获取专业的时间表
/// </summary>
/// <param name="iSpecialtyID"></param>
/// <returns></returns>
public static Dal.Models.Schedule GetSpecialtySchedule(int iSpecialtyID, OleDbConnection conn, OleDbTransaction tran = null)
{
Dal.Models.Specialty specialty = null;
specialty = Specialty.GetSpecialty(iSpecialtyID, conn, tran);
// 默认继承时间节点
if (specialty.IsInheritSchedule == null)
{
specialty.IsInheritSchedule = true;
}
if (specialty.IsInheritSchedule.Value)
{
if (specialty.ParentID.HasValue)
{
return(GetSpecialtySchedule(specialty.ParentID.Value, conn, tran));
}
else
{
return(GetActivitySchedule(specialty.ActivityID.Value, conn, tran));
}
}
else
{
string strSql = "SELECT * FROM Schedule WHERE SpecialtyID = ? ";
IDataReader reader = Dal.OleDbHlper.ExecuteReader(strSql, conn, CommandType.Text, tran
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
});
return(Dal.Models.BaseEntity.GetEntity <Dal.Models.Schedule>(reader));
}
}
protected void ddlParent_SelectedIndexChanged(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
int parentSpecialtyID = Convert.ToInt32(ddlParent.SelectedValue);
Dal.Models.Specialty spl = BLL.Specialty.GetSpecialty(parentSpecialtyID, conn);
hfLevel.Value = spl.SpecialtyLevel;
}
public static void SetOrdinal(Dal.Models.Specialty specialty, OleDbConnection conn, OleDbTransaction trans = null)
{
if (specialty == null || specialty.ActivityID == null || specialty.SpecialtyID == null)
{
throw new Exception("参数错误!");
}
List <Dal.Models.Specialty> lstSpecialty = GetDirectlyChildList(
specialty.ActivityID.Value, specialty.ParentID, conn, trans).Where(s => s.SpecialtyID != specialty.SpecialtyID).ToList();
if (specialty.Ordinal == null || specialty.Ordinal > lstSpecialty.Count)
{
lstSpecialty.Add(specialty);
}
else if (specialty.Ordinal <= 0)
{
lstSpecialty.Insert(0, specialty);
}
else
{
lstSpecialty.Insert(specialty.Ordinal.Value - 1, specialty);
}
string strSql = " UPDATE Specialty set Ordinal = ? where SpecialtyID = ? ";
for (int i = 0; i < lstSpecialty.Count; i++)
{
Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@Ordinal", OleDbType.VarWChar)
{
Value = i + 1
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = lstSpecialty[i].SpecialtyID.Value
});
}
List <Dal.Models.Specialty> lstTotalSpecialty = GetSpecialtyList(specialty.ActivityID.Value, false, conn, trans);
strSql = " UPDATE Specialty set TotalOrdinal = ? where SpecialtyID = ? ";
for (int i = 0; i < lstTotalSpecialty.Count; i++)
{
Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@TotalOrdinal", OleDbType.VarWChar)
{
Value = i + 1
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = lstTotalSpecialty[i].SpecialtyID.Value
});
}
}
/// <summary>
/// 根据专业编号获取该专业所属在的顶层专业
/// </summary>
/// <param name="iPrizeID"></param>
/// <returns></returns>
public static Dal.Models.Specialty GetTopSpecialty(int iSpecialtyID, OleDbConnection conn, OleDbTransaction trans = null)
{
Dal.Models.Specialty specialty = GetSpecialty(iSpecialtyID, conn, trans);
if (specialty.ParentID == null)
{
return(specialty);
}
else
{
return(GetTopSpecialty(specialty.ParentID.Value, conn, trans));
}
}
/// <summary>
/// 设定时间表
/// </summary>
/// <param name="schedule"></param>
/// <param name="trans"></param>
/// <returns></returns>
public static int SetSchedule(Dal.Models.Schedule schedule, OleDbConnection conn, OleDbTransaction trans = null)
{
if (schedule == null ||
(schedule.SpecialtyID == null && schedule.ActivityID == null) ||
(schedule.SpecialtyID != null && schedule.ActivityID != null))
{
return(-1);
}
// 专业一旦设定了时间表，则自动修改其继承状态为否
int iResult = 0;
if (schedule.SpecialtyID != null)
{
Dal.Models.Specialty specialty = Specialty.GetSpecialty(schedule.SpecialtyID.Value, conn, trans);
if (specialty.IsInheritSchedule == null || specialty.IsInheritSchedule.Value)
{
specialty.IsInheritSchedule = false;
Specialty.UpdateSpecialty(specialty, conn, trans);
iResult = CreateSchedule(schedule, conn, trans);
}
else
{
Dal.Models.Schedule sc = GetSpecialtySchedule(schedule.SpecialtyID.Value, conn, trans);
if (sc != null)
{
schedule.ScheduleID = sc.ScheduleID;
iResult = UpdateSchedule(schedule, conn, trans);
}
else
{
iResult = CreateSchedule(schedule, conn, trans);
}
}
}
else
{
Dal.Models.Schedule sc = GetActivitySchedule(schedule.ActivityID.Value, conn, trans);
if (sc != null)
{
schedule.ScheduleID = sc.ScheduleID;
iResult = UpdateSchedule(schedule, conn, trans);
}
else
{
iResult = CreateSchedule(schedule, conn, trans);
}
}
return(iResult);
}
public static string GetSpecialtyCode(int iActivityID, int?iParentID, OleDbConnection conn, OleDbTransaction trans = null)
{
string strSql = " select max(SpecialtyCode) from Specialty where ActivityID = ? ";
object objResult = null;
if (iParentID == null)
{
strSql += " and ParentID is null ";
objResult = Dal.OleDbHlper.ExecuteScalar(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@ActivityID", OleDbType.Integer)
{
Value = iActivityID
});
}
else
{
strSql += " and ParentID = ? ";
objResult = Dal.OleDbHlper.ExecuteScalar(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@ActivityID", OleDbType.Integer)
{
Value = iActivityID
}
, new OleDbParameter("@ParentID", OleDbType.Integer)
{
Value = iParentID
});
}
if (iParentID == null)
{
return((Convert.ToInt32(objResult == null || objResult == DBNull.Value ? "00" : objResult) + 10000).ToString("D6"));
}
else
{
// 获取父专业
Dal.Models.Specialty spec = GetSpecialty(iParentID.Value, conn, trans);
if (spec.ParentID == null)
{
// 二级专业
return((Convert.ToInt32(objResult == null || objResult == DBNull.Value ? spec.SpecialtyCode : objResult) + 100).ToString("D6"));
}
else
{
// 第一个三级专业
return((Convert.ToInt32(objResult == null || objResult == DBNull.Value ? spec.SpecialtyCode : objResult) + 1).ToString("D6"));
}
}
}
public static string GetTempletCode(int iSpecialtyID, OleDbConnection conn, OleDbTransaction tran = null)
{
Dal.Models.Specialty specialty = Specialty.GetSpecialty(iSpecialtyID, conn, tran);
// 默认继承模版
if (specialty.IsInheritTemplet == null)
{
specialty.IsInheritTemplet = true;
}
if (specialty.IsInheritTemplet.Value && specialty.ParentID.HasValue)
{
return(GetTempletCode(specialty.ParentID.Value, conn, tran));
}
return(specialty.TemplateCode);
}
public static string GetPrizeCode(int iSpecialtyID, OleDbConnection conn, OleDbTransaction tran = null)
{
Dal.Models.Specialty specialty = BLL.Specialty.GetSpecialty(iSpecialtyID, conn);
string strSql = "select max(PrizeCode) from Prize where SpecialtyID = ? ";
object objPrizeCode = null;
objPrizeCode = Dal.OleDbHlper.ExecuteScalar(strSql, conn, CommandType.Text, tran
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
});
return((Convert.ToInt32(objPrizeCode == null || objPrizeCode == DBNull.Value
? specialty.SpecialtyCode : objPrizeCode) + 1).ToString("D8"));
}
public static int CheckPrize(Dal.Models.Prize prize, OleDbConnection conn, OleDbTransaction tran)
{
if (string.IsNullOrEmpty(prize.PrizeName) || prize.SpecialtyID == null || prize.SpecialtyID == null)
{
throw new Exception("参数错误！");
}
Dal.Models.Specialty specialty = Specialty.GetSpecialty(prize.SpecialtyID.Value, conn, tran);
// 所选专业不存在
if (specialty == null)
{
throw new Exception("所选专业不存在！");
}
if ((specialty.ChildCount ?? 0) > 0)
{
throw new Exception("奖项创建失败,该专业下已存在子专业,无法创建奖项。");
}
// 同一专业中，奖项不允许重名
Dal.Models.Prize prizeOriginal = GetPrize(prize.PrizeName, prize.SpecialtyID.Value, conn, tran);
if (prize.PrizeID != prizeOriginal.PrizeID)
{
throw new Exception("同一专业中，奖项不允许重名！");
}
//奖项类别为空时，默认类别为综合奖
if (string.IsNullOrEmpty(prize.PrizeTypeCode) ||
!(new string[] { "0301", "0302", "0303", "0304" }).Contains(prize.PrizeTypeCode))
{
prize.PrizeTypeCode = "0301";
}
if (string.IsNullOrEmpty(prize.TemplateCode))
{
prize.TemplateCode = Specialty.GetTempletCode(prize.SpecialtyID.Value, conn, tran);
}
return(specialty.ActivityID.Value);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ActivityType"] == null || Session["UserInfo"] == null)
{
Response.Redirect("../Mutual/UserEntry.aspx");
return;
}
if (!IsPostBack)
{
//根据当前模板状态显示部件
//Dal.Models.TemplateInfo tempInfo = (Dal.Models.TemplateInfo)Session["TemplateInfo"];
Dal.Models.TemplateInfo tempInfo = null;
try
{
tempInfo = ((Declaration)Context.Handler).TempInfo;
}
catch
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
if (tempInfo == null)
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
//显示模板的当前编辑部分
//divfather.FindControl(tempInfo.Anchor).Visible = true;
Dal.Models.Template_10_CivilAirDefence tempCivilAirDefence =
BLL.Declaration.GetDeclarationData <Dal.Models.Template_10_CivilAirDefence>(tempInfo.DeclarationID.Value, conn);
Dal.Models.Declaration decl = BLL.Declaration.GetDeclaration(tempInfo.DeclarationID.Value, conn);
SetDropDownList(DesignCategory, BLL.SysConstant.GetConstantList("14", conn));
SetDropDownList(InvestSource, BLL.SysConstant.GetConstantList("15", conn));
SetDropDownList(ProfessionalCategories, BLL.SysConstant.GetConstantList("28", conn));
//SetDropDownList(DeclarationLevel, BLL.SysConstant.GetConstantList("04", conn));
List <Dal.Models.SysConstant> lstDomesticOrAbord = BLL.SysConstant.GetConstantList("19", conn);
SetDropDownList(DomesticOrAbord1, lstDomesticOrAbord);
SetDropDownList(DomesticOrAbord2, lstDomesticOrAbord);
SetDropDownList(DomesticOrAbord3, lstDomesticOrAbord);
SetDropDownList(DomesticOrAbord4, lstDomesticOrAbord);
List <Dal.Models.SysConstant> lstCollaborativePhase = BLL.SysConstant.GetConstantList("20", conn);
SetDropDownList(CollaborativePhase01, lstCollaborativePhase);
CollaborativePhase01.Items.Insert(0, new ListItem(""));
SetDropDownList(CollaborativePhase02, lstCollaborativePhase);
CollaborativePhase02.Items.Insert(0, new ListItem(""));
SetDropDownList(CollaborativePhase03, lstCollaborativePhase);
CollaborativePhase03.Items.Insert(0, new ListItem(""));
SetDropDownList(CollaborativePhase04, lstCollaborativePhase);
CollaborativePhase04.Items.Insert(0, new ListItem(""));
//为控件赋值
BLL.Common.SetData <Dal.Models.Template_10_CivilAirDefence>(tempCivilAirDefence, divfather);
// 设置参与人员
ucParticipant.ParticipantList = BLL.Declaration.GetParticipant(tempInfo.DeclarationID.Value, conn);
Dal.Models.Organization org = BLL.Organization.GetOrganization(decl.OrganizationID.Value, conn);
DeclarationName.Text = decl.DeclarationName;
DeclarationUnit.Text = org.OrganizationName;
PostalAddress.Text = org.OrganizationAddress;
Linkman.Text = org.Linkman;
TelephoneNumber.Text = org.TelephoneNumber;
FaxNumber.Text = org.FaxNumber;
MobileNumber.Text = org.MobileNumber;
Postcode.Text = org.Postcode;
EmailAddress.Text = org.EmailAddress;;//org.EmailAddress
txtDeclarationID.Text = decl.DeclarationID.ToString();
txtTemplate.Text = tempInfo.TemplateCode;
ucLegalStates.Org = org;
ucLegalStates.Decl = decl;
ucCertificate.Org = org;
ucCertificate.Decl = decl;
ucParticipant.Org = org;
ucParticipant.Decl = decl;
ucComments.Org = org;
ucComments.Decl = decl;
//接受登录人员
Dal.Models.UserInfo userInfo = (Dal.Models.UserInfo)Session["UserInfo"];
txtUser.Text = userInfo.UserType;
//接受场景
if (!string.IsNullOrEmpty(tempInfo.Situation.ToString()))
{
txtSituation.Text = tempInfo.Situation.ToString();
}
if (tempInfo.Situation.ToString() == "Declara")
{
string strActivityType = Session["ActivityType"].ToString();
// 获取指定活动类型的当前激活活动
Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn);
if (actActivated == null)
{
conn.Close();
Response.Redirect("../Mutual/UserEntry.aspx");
return;
}
int iActivity = actActivated.ActivityID.Value;
string strSpecialty = decl.DeclarationCode.Substring(4, 6);
Dal.Models.Specialty dSpecialty = BLL.Specialty.GetSpecialtyByCode(strSpecialty, iActivity, conn);
conn.Close();
nav02.InnerText = dSpecialty.SpecialtyName;
}
}
}
/// <summary>
/// 创建、删除时需要的传入参数检查以及缺省值设定
/// </summary>
/// <param name="specialty"></param>
/// <returns></returns>
public static void PreCheck(Dal.Models.Specialty specialty, OleDbConnection conn, OleDbTransaction trans = null)
{
// 必须项检查
if (specialty.ActivityID == null ||
string.IsNullOrEmpty(specialty.SpecialtyName))
{
throw new Exception("参数错误!");
}
//需要查询奖项有没有
if (specialty.ParentID != null)
{
int iPrize = Prize.Count(specialty.ParentID.Value, conn, trans);
if (iPrize > 0)
{
throw new Exception("已有奖项的专业不允许修改本专业和创建子专业!");
}
}
// 重名检查
Dal.Models.Specialty specialtyOriginal = GetSpecialtyByName(specialty.SpecialtyName, specialty.ActivityID.Value, conn, trans);
if (specialtyOriginal != null)
{
if (specialtyOriginal.SpecialtyID != specialty.SpecialtyID)
{
throw new Exception("本次活动已有同名专业!");
}
}
if (string.IsNullOrEmpty(specialty.SpecialtyCode))
{
// 获取专业编码
specialty.SpecialtyCode = GetSpecialtyCode(specialty.ActivityID.Value, specialty.ParentID, conn, trans);
}
if (specialty.CreateTime == null || specialty.LastUpdateTime == null)
{
specialty.CreateTime = DateTime.Now;
specialty.LastUpdateTime = specialty.CreateTime;
}
// 默认继承时间节点
if (specialty.IsInheritSchedule == null)
{
specialty.IsInheritSchedule = true;
}
// 默认继承模板
if (specialty.IsInheritTemplet == null)
{
if (specialty.ParentID != null)
{
specialty.IsInheritTemplet = true;
specialty.TemplateCode = GetTempletCode(specialty.ParentID.Value, conn, trans);
}
else
{
specialty.IsInheritTemplet = false;
}
}
else
{
if (specialty.ParentID == null)
{
specialty.IsInheritTemplet = false;
}
else
{
if (specialty.IsInheritTemplet.Value)
{
specialty.TemplateCode = GetTempletCode(specialty.ParentID.Value, conn, trans);
}
}
}
if (string.IsNullOrEmpty(specialty.TemplateCode))
{
throw new Exception("请选择模板!");
}
// 默认不共享获奖名额
if (specialty.IsShareQuota == null)
{
specialty.IsShareQuota = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ActivityType"] == null || Session["UserInfo"] == null)
{
Response.Redirect("../Common/Login.aspx");
return;
}
if (!IsPostBack)
{
//根据当前模板状态显示部件
//Dal.Models.TemplateInfo tempInfo = (Dal.Models.TemplateInfo)Session["TemplateInfo"];
Dal.Models.TemplateInfo tempInfo = null;
try
{
tempInfo = ((Declaration)Context.Handler).TempInfo;
}
catch
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
if (tempInfo == null)
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
//显示模板的当前编辑部分 Template_18_WaterSystem
//divfather.FindControl(tempInfo.Anchor).Visible = true;
Dal.Models.Template_18_WaterSystem tempTraditionalBuilding =
BLL.Declaration.GetDeclarationData <Dal.Models.Template_18_WaterSystem>(tempInfo.DeclarationID.Value, conn);
Dal.Models.Declaration decl = BLL.Declaration.GetDeclaration(tempInfo.DeclarationID.Value, conn);
SetDropDownList(DeclarationCategory, BLL.SysConstant.GetConstantList("33", conn));
//为控件赋值
BLL.Common.SetData <Dal.Models.Template_18_WaterSystem>(tempTraditionalBuilding, divfather);
// 设置参与人员
ucParticipant.ParticipantList = BLL.Declaration.GetParticipant(tempInfo.DeclarationID.Value, conn);
Dal.Models.Organization org = BLL.Organization.GetOrganization(decl.OrganizationID.Value, conn);
DeclarationName.Text = decl.DeclarationName;
UseDeclarationName.Text = decl.DeclarationName;
ConstructionDeclarationName.Text = decl.DeclarationName;
DeclarationUnit.Text = org.OrganizationName;
PostalAddress.Text = org.OrganizationAddress;
Linkman.Text = org.Linkman;
TelephoneNumber.Text = org.TelephoneNumber;
FaxNumber.Text = org.FaxNumber;
MobileNumber.Text = org.MobileNumber;
Postcode.Text = org.Postcode;
EmailAddress.Text = org.EmailAddress;;//org.EmailAddress
txtDeclarationID.Text = decl.DeclarationID.ToString();
txtTemplate.Text = tempInfo.TemplateCode;
ucLegalStates.Org = org;
ucLegalStates.Decl = decl;
ucCertificate.Org = org;
ucCertificate.Decl = decl;
ucParticipant.Org = org;
ucParticipant.Decl = decl;
ucComments.Org = org;
ucComments.Decl = decl;
//接受登录人员
Dal.Models.UserInfo userInfo = (Dal.Models.UserInfo)Session["UserInfo"];
txtUser.Text = userInfo.UserType;
//接受场景
if (!string.IsNullOrEmpty(tempInfo.Situation.ToString()))
{
txtSituation.Text = tempInfo.Situation.ToString();
}
if (tempInfo.Situation.ToString() == "Declara")
{
string strActivityType = Session["ActivityType"].ToString();
// 获取指定活动类型的当前激活活动
Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn);
if (actActivated == null)
{
conn.Close();
Response.Redirect("../Common/Login.aspx");
return;
}
int iActivity = actActivated.ActivityID.Value;
string strSpecialty = decl.DeclarationCode.Substring(4, 6);
Dal.Models.Specialty dSpecialty = BLL.Specialty.GetSpecialtyByCode(strSpecialty, iActivity, conn);
conn.Close();
nav02.InnerText = dSpecialty.SpecialtyName;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ActivityType"] == null || Session["UserInfo"] == null)
{
Response.Redirect("../Mutual/UserEntry.aspx");
return;
}
if (!IsPostBack)
{
//根据当前模板状态显示部件
// Dal.Models.TemplateInfo tempInfo = (Dal.Models.TemplateInfo)Session["TemplateInfo"];
Dal.Models.TemplateInfo tempInfo = null;
try
{
tempInfo = ((Declaration)Context.Handler).TempInfo;
}
catch
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
if (tempInfo == null)
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
//显示模板的当前编辑部分
//divfather.FindControl(tempInfo.Anchor).Visible = true;
Dal.Models.Template_17_Standard tempStandard =
BLL.Declaration.GetDeclarationData <Dal.Models.Template_17_Standard>(tempInfo.DeclarationID.Value, conn);
Dal.Models.Declaration decl = BLL.Declaration.GetDeclaration(tempInfo.DeclarationID.Value, conn);
ListItem item = new ListItem();
item.Text = "行业";
item.Value = "2401";
ListItem item2 = new ListItem();
item2.Text = "地方";
item2.Value = "2402";
ListItem item3 = new ListItem();
item3.Text = "国家";
item3.Value = "2403";
ListItem item4 = new ListItem();
item4.Text = "其他";
item4.Value = "2404";
ProjectSource.Items.Add(item);
ProjectSource.Items.Add(item2);
ProjectSource.Items.Add(item3);
ProjectSource.Items.Add(item4);
//为控件赋值
BLL.Common.SetData <Dal.Models.Template_17_Standard>(tempStandard, divfather);
if (FileCatalog.Text == "")
{
FileCatalog.Text = BLL.SysConstant.GetTemplateConstant(tempInfo.TemplateCode, "FileCatalogDefaultText", conn);
}
// 设置参与人员
ucParticipant.ParticipantList = BLL.Declaration.GetParticipant(tempInfo.DeclarationID.Value, conn);
Dal.Models.Organization org = BLL.Organization.GetOrganization(decl.OrganizationID.Value, conn);
StandardName.Text = decl.DeclarationName;
ChiefEditorUnit.Text = org.OrganizationName;
PostalAddress.Text = org.OrganizationAddress;
Linkman.Text = org.Linkman;
TelephoneNumber.Text = org.TelephoneNumber;
FaxNumber.Text = org.FaxNumber;
MobileNumber.Text = org.MobileNumber;
Postcode.Text = org.Postcode;
EmailAddress.Text = org.EmailAddress;;//org.EmailAddress
txtDeclarationID.Text = decl.DeclarationID.ToString();
txtTemplate.Text = tempInfo.TemplateCode;
ucLegalStates.Org = org;
ucLegalStates.Decl = decl;
ucCertificate.Org = org;
ucCertificate.Decl = decl;
ucParticipant.Org = org;
ucParticipant.Decl = decl;
ucComments.Org = org;
ucComments.Decl = decl;
//接受登录人员
Dal.Models.UserInfo userInfo = (Dal.Models.UserInfo)Session["UserInfo"];
txtUser.Text = userInfo.UserType;
//接受场景
if (!string.IsNullOrEmpty(tempInfo.Situation.ToString()))
{
txtSituation.Text = tempInfo.Situation.ToString();
}
if (tempInfo.Situation.ToString() == "Declara")
{
string strActivityType = Session["ActivityType"].ToString();
// 获取指定活动类型的当前激活活动
Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn);
if (actActivated == null)
{
conn.Close();
Response.Redirect("../Mutual/UserEntry.aspx");
return;
}
int iActivity = actActivated.ActivityID.Value;
string strSpecialty = decl.DeclarationCode.Substring(4, 6);
Dal.Models.Specialty dSpecialty = BLL.Specialty.GetSpecialtyByCode(strSpecialty, iActivity, conn);
conn.Close();
nav02.InnerText = dSpecialty.SpecialtyName;
}
//string sourceText = ProjectSource.SelectedItem.Text;
//ProjectSource.Text = sourceText;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
if (user == null)
{
Response.Redirect("~/View/Mutual/UserEntry.aspx");
}
if (!IsPostBack)
{
btnNext.Attributes.Add("OnClick", "return UserAddVerify()");
// 设定专业
Dal.Models.Specialty spec = null;
Dal.Models.Prize prize = null;
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
string strActivityType = Request.Cookies["ActivityType"].Value;
Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn);
if (actActivated == null)
{
hdMsg.Value = "当前活动已关闭，请联系活动管理人员！";
return;
}
// 设置推荐协会
if (ConfigurationManager.AppSettings["ActivityType"] != "0102")
{
RecommendationAssociation.Visible = false;
}
else
{
List <Dal.Models.UserInfo> lstAssociation = BLL.User.GetlstAssociationUser(conn);
ChooseAssociation.DataSource = lstAssociation;
ChooseAssociation.DataTextField = "UserName";
ChooseAssociation.DataValueField = "UserID";
ChooseAssociation.DataBind();
}
int iDeclarationID = 0;
int.TryParse(Request["DeclarationID"], out iDeclarationID);
hdDeclarationID.Value = iDeclarationID.ToString();
Dal.Models.Declaration decl = BLL.Declaration.GetDeclaration(iDeclarationID, conn);
if (decl == null)
{
// 获取菜单传递过来的参数
spec = BLL.Specialty.GetSpecialty(actActivated.ActivityID.Value, Request["SepcCode"], conn);
if (spec == null)
{
List <Dal.Models.Specialty> lst = BLL.Specialty.GetSpecialtyList(actActivated.ActivityID.Value, true, conn);
spec = lst[0];
}
// 设定封页台头
litTitle.Text = BLL.SysConstant.GetConstant(spec.TemplateCode, conn).ConstantDiscription;
// 设定奖项列表
List <Dal.Models.Specialty> lstSpecialty = BLL.Specialty.GetDirectlyChildList(spec.SpecialtyID.Value, conn);
List <Dal.Models.Prize> lstPrize = null;
if (lstSpecialty.Count == 0)
{
lblSpecil.Visible = false;
ddlSpecialty.Visible = false;
ddlChildSpecialty.Visible = false;
// 设定奖项列表
lstPrize = BLL.Prize.GetPrizeList(spec.SpecialtyID.Value, conn);
}
else
{
ddlSpecialty.Visible = true;
List <Dal.Models.Specialty> lstChildSpecialty = null;
lstSpecialty = lstSpecialty.Where(s =>
BLL.Prize.Count(s.SpecialtyID.Value, conn) > 0 ||
BLL.Specialty.Count(actActivated.ActivityID.Value, s.SpecialtyID, conn) > 0
).ToList();
ddlSpecialty.DataSource = lstSpecialty;
ddlSpecialty.DataTextField = "SpecialtyName";
ddlSpecialty.DataValueField = "SpecialtyID";
ddlSpecialty.DataBind();
ddlSpecialty.SelectedIndex = 0;
if (lstSpecialty.Count > 0)
{
lstChildSpecialty = BLL.Specialty.GetDirectlyChildList(lstSpecialty[0].SpecialtyID.Value, conn);
if (lstChildSpecialty.Count == 0)
{
ddlChildSpecialty.Visible = false;
// 设定奖项列表
lstPrize = BLL.Prize.GetPrizeList(lstSpecialty[0].SpecialtyID.Value, conn);
}
else
{
ddlChildSpecialty.Visible = true;
ddlChildSpecialty.DataSource = lstChildSpecialty;
ddlChildSpecialty.DataTextField = "SpecialtyName";
ddlChildSpecialty.DataValueField = "SpecialtyID";
ddlChildSpecialty.DataBind();
ddlSpecialty.SelectedIndex = 0;
// 设定奖项列表
lstPrize = BLL.Prize.GetPrizeList(lstChildSpecialty[0].SpecialtyID.Value, conn);
}
}
}
if (lstPrize != null && lstPrize.Count > 0)
{
// 绑定奖项列表
rdlPrize.DataSource = lstPrize;
rdlPrize.DataTextField = "PrizeName";
rdlPrize.DataValueField = "PrizeID";
rdlPrize.DataBind();
rdlPrize.SelectedIndex = 0;
// 根据奖项获取模版
string strTempCode = lstPrize.Where(p => p.PrizeID.Value == Convert.ToInt32(rdlPrize.SelectedValue)).ToList()[0].TemplateCode;
Dal.Models.Organization org = BLL.User.GetOrganization(user.UserID.Value, conn);
// 绑定导入数据
List <Dal.Models.Declaration> lstDeclaration = BLL.Declaration.GetDeclarationList(user, actActivated.ActivityID.Value, conn);
lstDeclaration = lstDeclaration.Where(d => d.PrizeID == lstPrize[0].PrizeID).ToList();
if (lstDeclaration.Count() > 0)
{
ImportDeclarationData.DataSource = lstDeclaration;
ImportDeclarationData.DataTextField = "DeclarationName";
ImportDeclarationData.DataValueField = "DeclarationID";
ImportDeclarationData.DataBind();
ImportDeclarationData.Items.Insert(0, new ListItem("<-- 不导入 -->", "0"));
ImportDeclarationData.SelectedIndex = 0;
}
else
{
ImportData.Visible = false;
}
if (org != null)
{
// 设定单位信息
txtOrganizationName.Text = org.OrganizationName;
}
txtDeclarateDate.Text = DateTime.Today.ToString("yyyy-MM-dd");
}
else
{
hdMsg.Value = "该专业下暂无奖项，无法申报!";
return;
}
}
else
{
// 隐藏控件
ddlSpecialty.Visible = false;
ddlChildSpecialty.Visible = false;
lblSpecil.Visible = false;
prize = BLL.Prize.GetPrize(decl.PrizeID.Value, conn);
spec = BLL.Specialty.GetSpecialty(prize.SpecialtyID.Value, conn);
ViewState["DeclarationID"] = decl.DeclarationID.Value;
// 设定封页台头
litTitle.Text = BLL.SysConstant.GetConstant(prize.TemplateCode, conn).ConstantDiscription;
// 设定封页台头
txtProjectName.Text = decl.DeclarationName;
txtDeclarateDate.Text = decl.DeclareDate.Value.ToString("yyyy-MM-dd");
Dal.Models.Organization org = BLL.User.GetOrganization(decl.UserID.Value, conn);
if (org != null)
{
// 设定单位信息
txtOrganizationName.Text = org.OrganizationName;
}
// 设定奖项列表
List <Dal.Models.Prize> lstPrize = BLL.Prize.GetPrizeList(spec.SpecialtyID.Value, conn);
foreach (Dal.Models.Prize item in lstPrize)
{
rdlPrize.Items.Add(new System.Web.UI.WebControls.ListItem(
item.PrizeName, item.PrizeID.Value.ToString())
{
Enabled = item.TemplateCode == prize.TemplateCode
});
}
rdlPrize.SelectedValue = prize.PrizeID.Value.ToString();
if (decl.RecommendFrom == null || decl.RecommendFrom == "0" || decl.RecommendFrom == "")
{
ChooseAssociation.SelectedValue = "0";
litChooseAssociation.Text = "未有推荐协会";
}
else
{
ChooseAssociation.SelectedValue = decl.RecommendFrom.ToString();
litChooseAssociation.Text = BLL.User.GetUserInfo(Convert.ToInt32(decl.RecommendFrom), conn).UserName;
}
// 隐藏导入数据控件
ImportData.Visible = false;
// 生成二维码
//string imgUrl = BLL.Declaration.CreatQRcode(decl.DeclarationCode, conn);
//// 显示二维码
//HtmlTableRow tr = new HtmlTableRow();
//HtmlTableCell td1 = new HtmlTableCell("td");
//HtmlTableCell td2 = new HtmlTableCell("td");
//td1.InnerHtml = "<label style='margin-top: 20px;'>二维码：</label>";
//td1.Style.Add("width", "30%");
//td2.InnerHtml = "<img src='../../Content/Temp/" + decl.DeclarationCode + "/QRcode" + decl.DeclarationCode + ".jpg' style='width:150px;height:150px;' />";
//td2.ColSpan = 2;
//tr.Cells.Add(td1);
//tr.Cells.Add(td2);
//tbInformation.Rows.Add(tr);
}
//接受场景
if (!string.IsNullOrEmpty(Request["Situation"]))
{
txtSituation.Text = Request["Situation"].Replace("'", "");
litProjectName.Text = decl.DeclarationName;
litDeclarateDate.Text = decl.DeclareDate.Value.ToString("yyyy-MM-dd");
litrdlPrize.Text = prize.PrizeName;
}
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
OleDbTransaction trans = conn.BeginTransaction();
DeclarationName.Text = Decl.DeclarationName;
DeclarationUnit.Text = Org.OrganizationName;
litDeclarationUnit.Text = Org.OrganizationName;
SurveylitDeclarationUnit.Text = Org.OrganizationName;
txtMaiDeclarationUnit.Text = Org.OrganizationName;
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
txtUserType.Text = user.UserType;
Dal.Models.Prize prize = BLL.Prize.GetPrize(Convert.ToInt32(Decl.PrizeID), conn, trans);
uPrize.InnerText = prize.PrizeName;
Dal.Models.Specialty spec = BLL.Specialty.GetSpecialty(Convert.ToInt32(prize.SpecialtyID), conn, trans);
IsAllowUpdate.Value = spec.IsAllowUpdate.ToString();
List <Dal.Models.TemplateConstant> sys = BLL.SysConstant.GetSysConstantListOfConstantDiscription(prize.TemplateCode, conn, trans);
List <Dal.Models.Declaration_Data> decl = BLL.Declaration.GetDeclarationDivisionList(Convert.ToInt32(Decl.DeclarationID), sys[1].KeyValue, sys[0].KeyValue, conn, trans);
TemplateCode.Value = prize.TemplateCode;
txtdeclID.Text = Decl.DeclarationID.ToString();
if (prize.TemplateCode == "0216" || prize.TemplateCode == "0217" || prize.TemplateCode == "0218")
{
if (!string.IsNullOrEmpty(decl[0].Data))
{
txtCooperationUnit2.Text = decl[0].Data;
}
if (!string.IsNullOrEmpty(decl[2].Data))
{
txtUndertakeWork2.Text = decl[2].Data;
}
if (!string.IsNullOrEmpty(decl[3].Data))
{
txtCooperationUnit3.Text = decl[3].Data;
}
if (!string.IsNullOrEmpty(decl[5].Data))
{
txtUndertakeWork3.Text = decl[5].Data;
}
if (!string.IsNullOrEmpty(decl[6].Data))
{
txtCooperationUnit4.Text = decl[6].Data;
}
if (!string.IsNullOrEmpty(decl[8].Data))
{
txtUndertakeWork4.Text = decl[8].Data;
}
if (!string.IsNullOrEmpty(decl[9].Data))
{
txtCooperationUnit5.Text = decl[9].Data;
}
if (!string.IsNullOrEmpty(decl[11].Data))
{
txtUndertakeWork5.Text = decl[11].Data;
}
}
else
{
if (!string.IsNullOrEmpty(decl[0].Data))
{
txtDeclarationUnit2.Text = decl[0].Data;
SurveylitDeclarationUnit2.Text = decl[0].Data;
if (!string.IsNullOrEmpty(decl[2].Data))
{
Division2.Value = decl[2].Data;
SetSurveyCollaborativePhase("SurveyCollaborativePhase2_", decl[2].Data.Split(','));
}
}
if (!string.IsNullOrEmpty(decl[3].Data))
{
txtDeclarationUnit3.Text = decl[3].Data;
SurveylitDeclarationUnit3.Text = decl[3].Data;
if (!string.IsNullOrEmpty(decl[5].Data))
{
Division3.Value = decl[5].Data;
SetSurveyCollaborativePhase("SurveyCollaborativePhase3_", decl[5].Data.Split(','));
}
}
if (!string.IsNullOrEmpty(decl[6].Data))
{
txtDeclarationUnit4.Text = decl[6].Data;
SurveylitDeclarationUnit4.Text = decl[6].Data;
if (!string.IsNullOrEmpty(decl[8].Data))
{
Division4.Value = decl[8].Data;
SetSurveyCollaborativePhase("SurveyCollaborativePhase4_", decl[8].Data.Split(','));
}
}
if (!string.IsNullOrEmpty(decl[9].Data))
{
txtDeclarationUnit5.Text = decl[9].Data;
SurveylitDeclarationUnit5.Text = decl[9].Data;
if (!string.IsNullOrEmpty(decl[11].Data))
{
Division5.Value = decl[11].Data;
SetSurveyCollaborativePhase("SurveyCollaborativePhase5_", decl[11].Data.Split(','));
}
}
}
trans.Commit();
conn.Close();
}
catch
{ }
}
public void InitPage(OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
int iSpecialtyID = 0;
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
Response.Redirect("~/View/Mutual/HomePage.aspx");
return;
}
if (!IsPostBack)
{
//修改
if (Request["sid"] != null || ViewState["SpecialtyID"] != null)
{
if (!Int32.TryParse(Request["sid"] ?? "0", out iSpecialtyID))
{
Response.Redirect("SpecialtyList.aspx");
}
else
{
hfSpecialtyLevel.Value = Request["specialtyLevel"];
ViewState["SpecialtyID"] = iSpecialtyID;
hfSpecialID.Value = Request["sid"];
hfParentID.Value = Request["pid"];
Dal.Models.Specialty spec = null;
try
{
spec = BLL.Specialty.GetSpecialty(iSpecialtyID, conn);
}
catch (Exception ex)
{
spec = null;
hdMsg.Value = ex.Message;
}
if (spec == null)
{
hdMsg.Value = "参数错误!";
Response.Redirect("SpecialtyList.aspx");
}
else
{
//修改时
txtSpecialtyName.Text = spec.SpecialtyName;
txtSpecialtyID.Text = (spec.SpecialtyID).ToString();
// txtSpecialtyCode.Text = spec.SpecialtyCode;
txtIconPicker.Value = spec.SpecialtyIcon;//ddlIsInheritTemplet.SelectedValue = "false";
txtOrdinal.Text = (spec.Ordinal ?? 0).ToString();
Dal.Models.Specialty parentSpecialty = BLL.Specialty.GetSpecialty((spec.ParentID ?? 0), conn);
if (parentSpecialty != null)
{
ListItem item = new ListItem(parentSpecialty.SpecialtyName, parentSpecialty.SpecialtyID.ToString());
ddlParent.Items.Add(item);
ddlParent.Items.Insert(0, new ListItem("--请选择--", "0"));
ddlParent.SelectedValue = (parentSpecialty.SpecialtyID ?? 0).ToString();
hfLevel.Value = parentSpecialty.SpecialtyLevel;
}
else
{
hfLevel.Value = "";//一级专业没有父级
}
ddlParent.Enabled = false;
ddlIsInheritSchedule.SelectedValue = (spec.IsInheritSchedule ?? true).ToString();
ddlIsAllowUpdate.SelectedValue = (spec.IsAllowUpdate ?? false).ToString();
ddlIsAllowSubmit.SelectedValue = spec.IsAllowSubmit.ToString();
ddlIsSendReceivePost.SelectedValue = spec.IsSendReceivePost.ToString() == "True" ? "1" : "0";
ddlIsSendUpdatePost.SelectedValue = spec.IsSendUpdatePost.ToString() == "True"?"1":"0";
ddlIsSendDeletePost.SelectedValue = spec.IsSendDeletePost.ToString() == "True" ? "1" : "0";
ucSchedule.UcSchedule = BLL.Schedule.GetSpecialtySchedule(iSpecialtyID, conn);
if (ucSchedule.UcSchedule == null)
{
ucSchedule.UcSchedule = new Dal.Models.Schedule();
}
ucSchedule.UcSchedule.SpecialtyID = iSpecialtyID;
ucSchedule.UcSchedule.ActivityID = null;
//ddlTemplate.SelectedValue = spec.TemplateCode;
//ddlTemplate.Enabled = !(spec.IsInheritTemplet ?? true);
//ddlIsInheritTemplet.SelectedValue = (spec.IsInheritTemplet ?? spec.ParentID != null).ToString();
//ddlTemplate.Enabled = false;
//txtSpecialtyCode.Enabled = false;
lkbCreate.Visible = false;
ucSchedule.Visible = true;
//lkbSetPrize.Visible = true;
lkbSetAtlas.Visible = true;
lkbSetAppendix.Visible = true;
//string showType = Request.QueryString["show"];
//if (spec.PrizeCount != 0 || spec.ChildCount != 0)
//{
// divPrizeList.Visible = spec.PrizeCount > 0;
// divChild.Visible = spec.ChildCount > 0;
//}
//if (showType == "all")
//{
// divPrizeList.Visible = true;
// divChild.Visible = true;
//}
//else if (showType == "child")
//{
// divPrizeList.Visible = false;
// divChild.Visible = true;
//}
//else
//{
// divPrizeList.Visible = true;
// divChild.Visible = false;
//}
tbxSpecialtyAtlas.Text = spec.SpecialtyName;
tbxSpecialtyAppendix.Text = spec.SpecialtyName;
}
}
}
else //新建
{
// 专业下拉列表
List <Dal.Models.Specialty> lstTemp = BLL.Specialty.GetSpecialtyDropList(activity.ActivityID.Value, user.UserType, user.UserID.Value, true, conn);
List <Dal.Models.Specialty> lstSpec = lstTemp;
List <Dal.Models.Specialty> listtemp = lstTemp;
for (int i = 0; i < lstSpec.Count(); i++)
{
List <Dal.Models.Specialty> lstChildSpec = BLL.Specialty.GetDirectlyChildTowList(lstSpec[i].SpecialtyID, conn);
for (int j = 0; j < lstChildSpec.Count(); j++)
{
lstChildSpec[j].SpecialtyName = " " + lstChildSpec[j].SpecialtyName;
listtemp.Add(lstChildSpec[j]);
}
}
listtemp = listtemp.OrderBy(s => s.TotalOrdinal).ToList();
ListItem option = null;
foreach (Dal.Models.Specialty item in listtemp)
{
option = new ListItem(item.SpecialtyName, item.SpecialtyID.ToString());
ddlParent.Items.Add(option);
}
//ddlParent.Items.Insert(0, new ListItem("--请选择--", "0"));
ListItem itemParent = ddlParent.Items.FindByValue(Request["pid"]);
if (itemParent != null)
{
ddlParent.SelectedValue = Request["pid"];
ddlParent.Enabled = false;
}
else
{
// hdMsg.Value = "已经有奖项的专业不可以添加子专业！";
}
txtOrdinal.Text = (BLL.Specialty.Count(activity.ActivityID.Value, null, conn, null) + 1).ToString();
ddlIsInheritSchedule.SelectedValue = "True";
ddlIsAllowSubmit.SelectedValue = "True";
//ddlIsInheritTemplet.SelectedValue = "false";
if (ddlParent.SelectedValue != "")
{
int parentSpecialtyID = Convert.ToInt32(ddlParent.SelectedValue);
Dal.Models.Specialty spl = BLL.Specialty.GetSpecialty(parentSpecialtyID, conn);
hfLevel.Value = spl.SpecialtyLevel;
}
else
{
hdMsg.Value = "对不起，您没有专业权限或专业下有奖项，不能再新建专业！";
}
if (ddlParent.Items.Count > 0)
{
lkbCreate.Enabled = true;
}
else
{
lkbCreate.Enabled = false;
}
lkbUpdate.Visible = false;
ucSchedule.Visible = false;
//lkbSetPrize.Visible = false;
lkbSetAtlas.Visible = false;
lkbSetAppendix.Visible = false;
//divPrizeList.Visible = false;
//divChild.Visible = false;
txtSpecialtyName.Enabled = true;
}
}
ucSchedule.OnSaveSchedule += SaveSchedule;
}
/// <summary>
/// 更新专业信息(调整序号请调用SetOrdinal)
/// </summary>
/// <param name="specialty"></param>
/// <returns></returns>
public static int UpdateSpecialty(Dal.Models.Specialty specialty, OleDbConnection conn, OleDbTransaction trans = null)
{
// 必须项检查
if (specialty.SpecialtyID == null)
{
throw new Exception("参数错误!");
}
PreCheck(specialty, conn, trans);
Dal.Models.Specialty specialtyOriginal = GetSpecialty(specialty.SpecialtyID.Value, conn, trans);
// 如果原始状态不继承时间表，修改为继承时间表的，需要删除时间表
if (!specialtyOriginal.IsInheritSchedule.Value && specialty.IsInheritSchedule.Value)
{
string strSql = " DELETE FROM Schedule WHERE SpecialtyID = ? ";
Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = specialty.SpecialtyID
});
}
StringBuilder sbSql = new StringBuilder();
sbSql.Append(" UPDATE Specialty SET ");
sbSql.Append(" SpecialtyCode = ? ");
sbSql.Append(" ,SpecialtyName = ? ");
sbSql.Append(" ,SpecialtyIcon = ? ");
sbSql.Append(" ,TemplateCode = ? ");
sbSql.Append(" ,IsShareQuota = ? ");
sbSql.Append(" ,IsInheritSchedule = ? ");
sbSql.Append(" ,IsInheritTemplet = ? ");
sbSql.Append(" ,IsAllowUpdate = ? ");
sbSql.Append(" ,IsAllowSubmit = ? ");
sbSql.Append(" ,ParentID = ? ");
sbSql.Append(" ,LastUpdateTime = ? ");
sbSql.Append(" ,IsSendReceivePost = ? ");
sbSql.Append(" ,IsSendUpdatePost = ? ");
sbSql.Append(" ,IsSendDeletePost = ? ");
sbSql.Append(" WHERE SpecialtyID = ? ");
int iResult = Dal.OleDbHlper.ExecuteNonQuery(sbSql.ToString(), conn, CommandType.Text, trans
, new OleDbParameter("@SpecialtyCode", OleDbType.VarWChar)
{
Value = specialty.SpecialtyCode
}
, new OleDbParameter("@SpecialtyName", OleDbType.VarWChar)
{
Value = specialty.SpecialtyName
}
, new OleDbParameter("@SpecialtyIcon", OleDbType.VarWChar)
{
Value = specialty.SpecialtyIcon
}
, new OleDbParameter("@TemplateCode", OleDbType.VarWChar)
{
Value = specialty.TemplateCode
}
, new OleDbParameter("@IsShareQuota", OleDbType.Boolean)
{
Value = specialty.IsShareQuota
}
, new OleDbParameter("@IsInheritSchedule", OleDbType.Boolean)
{
Value = specialty.IsInheritSchedule
}
, new OleDbParameter("@IsInheritTemplet", OleDbType.Boolean)
{
Value = specialty.IsInheritTemplet
}
, new OleDbParameter("@IsAllowUpdate", OleDbType.Boolean)
{
Value = specialty.IsAllowUpdate
}
, new OleDbParameter("@IsAllowSubmit", OleDbType.Boolean)
{
Value = specialty.IsAllowSubmit
}
, new OleDbParameter("@ParentID", OleDbType.Integer)
{
Value = specialty.ParentID
}
, new OleDbParameter("@LastUpdateTime", OleDbType.DBDate)
{
Value = specialty.LastUpdateTime
}
, new OleDbParameter("@IsSendReceivePost", OleDbType.Boolean)
{
Value = specialty.IsSendReceivePost
}
, new OleDbParameter("@IsSendUpdatePost", OleDbType.Boolean)
{
Value = specialty.IsSendUpdatePost
}
, new OleDbParameter("@IsSendDeletePost", OleDbType.Boolean)
{
Value = specialty.IsSendDeletePost
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = specialty.SpecialtyID
});
SetOrdinal(specialty, conn, trans);
return(iResult);
}
protected void lkbUpdate_Click(object sender, EventArgs e)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
int iSpecialID = Convert.ToInt32(ViewState["SpecialtyID"]);
Dal.Models.Specialty specialty = BLL.Specialty.GetSpecialty(iSpecialID, conn);
if (specialty == null)
{
hdMsg.Value = "专业不存在!";
//Response.Write("<script>alert('专业不存在!')</script>");
Response.Redirect("SpecialtyList.aspx");
}
else
{
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
hdMsg.Value = "当前活动已经结束!";
return;
}
if (ddlParent.SelectedValue != "" && ddlParent.SelectedValue != "0")
{
specialty.ParentID = Convert.ToInt32(ddlParent.SelectedValue);
}
if (!string.IsNullOrEmpty(txtIconPicker.Value))
{
specialty.SpecialtyIcon = txtIconPicker.Value;
}
//specialty.SpecialtyIcon = "glyphicon-home";
specialty.SpecialtyName = txtSpecialtyName.Text;
//specialty.SpecialtyCode = txtSpecialtyCode.Text;
if (hfLevel.Value == "一级")
{
specialty.SpecialtyLevel = "二级";
}
else if (hfLevel.Value == "二级")
{
specialty.SpecialtyLevel = "三级";
}
else
{
specialty.SpecialtyLevel = "一级";
}
int iOrdinal = 0;
if (!string.IsNullOrEmpty(txtOrdinal.Text) && Int32.TryParse(txtOrdinal.Text, out iOrdinal))
{
specialty.Ordinal = iOrdinal;
}
specialty.IsInheritSchedule = ddlIsInheritSchedule.SelectedValue == "True";
specialty.IsInheritTemplet = false;//ddlIsInheritTemplet.SelectedValue == "True";
specialty.IsAllowUpdate = ddlIsAllowUpdate.SelectedValue == "True";
specialty.IsAllowSubmit = ddlIsAllowSubmit.SelectedValue == "True";
specialty.IsSendReceivePost = ddlIsSendReceivePost.SelectedValue == "1";
specialty.IsSendUpdatePost = ddlIsSendUpdatePost.SelectedValue == "1";
specialty.IsSendDeletePost = ddlIsSendDeletePost.SelectedValue == "1";
//specialty.IsSendReceivePost = Convert.ToInt32(ddlIsSendReceivePost.SelectedValue);
//specialty.IsSendUpdatePost = Convert.ToInt32(ddlIsSendUpdatePost.SelectedValue);
//specialty.IsSendDeletePost = Convert.ToInt32(ddlIsSendDeletePost.SelectedValue);
OleDbTransaction trans = conn.BeginTransaction();
try
{
BLL.Specialty.UpdateSpecialty(specialty, conn, trans);
trans.Commit();
hdMsg.Value = "修改成功!";
//Response.Write("<script>alert('修改成功!')</script>");
}
catch (Exception ex)
{
trans.Rollback();
// Response.Write("<script>alert('" + ex.Message + "')</script>");
hdMsg.Value = ex.Message;
}
}
conn.Close();
//Response.Redirect("~/view/ActivityManage/SpecialtyList.aspx?specialtyMSg=" + hdMsg.Value);
}
public static int SetPrize(
Dal.Models.Prize prize, List <int> LstPrizeLimitNum, OleDbConnection conn, OleDbTransaction tran)
{
if (prize == null || string.IsNullOrEmpty(prize.PrizeName) || prize.SpecialtyID == null)
{
throw new Exception("参数错误！");
}
Dal.Models.Specialty specialty = Specialty.GetSpecialty(prize.SpecialtyID.Value, conn, tran);
// 所选专业不存在
if (specialty == null)
{
throw new Exception("所选专业不存在！");
}
if ((specialty.ChildCount ?? 0) > 0)
{
throw new Exception("奖项创建失败,该专业下已存在子专业,无法创建奖项。");
}
// 同一专业中，奖项不允许重名
Dal.Models.Prize prizeOriginal = GetPrize(prize.PrizeName, prize.SpecialtyID.Value, conn, tran);
if (prizeOriginal != null && prize.PrizeID != prizeOriginal.PrizeID)
{
throw new Exception("同一专业中，奖项不允许重名！");
}
//奖项类别为空时，默认类别为综合奖
if (string.IsNullOrEmpty(prize.PrizeTypeCode) ||
!(new string[] { "0301", "0302", "0303", "0304" }).Contains(prize.PrizeTypeCode))
{
prize.PrizeTypeCode = "0301";
}
if (prize.ParticipantLimit == null)
{
prize.ParticipantLimit = Convert.ToInt32(
SysConstant.GetConstant(prize.PrizeTypeCode, conn, tran).CorrelationValue);
}
if (string.IsNullOrEmpty(prize.TemplateCode))
{
prize.TemplateCode = specialty.TemplateCode;
}
StringBuilder sbSql = new StringBuilder();
if (prize.PrizeID == null)
{
sbSql.Append(" INSERT INTO Prize ( ");
sbSql.Append(" PrizeName");
sbSql.Append(" ,SpecialtyID ");
sbSql.Append(" ,PrizeTypeCode ");
sbSql.Append(" ,TemplateCode ");
sbSql.Append(" ,IsMultipleVoting ");
sbSql.Append(" ,VoteType ");
sbSql.Append(" ,ParticipantLimit ");
sbSql.Append(" ,AppendixDiscription ");
sbSql.Append(" ,CreateTime ");
sbSql.Append(" ,LastUpdateTime ");
sbSql.Append(" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, GETDATE(), GETDATE() ) ");
int iResult = Dal.OleDbHlper.ExecuteNonQuery(
sbSql.ToString(), conn, CommandType.Text, tran
, new OleDbParameter("@PrizeName", OleDbType.VarWChar)
{
Value = prize.PrizeName
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = prize.SpecialtyID
}
, new OleDbParameter("@PrizeTypeCode", OleDbType.VarWChar)
{
Value = prize.PrizeTypeCode
}
, new OleDbParameter("@TemplateCode", OleDbType.VarWChar)
{
Value = prize.TemplateCode
}
, new OleDbParameter("@IsMultipleVoting", OleDbType.Boolean)
{
Value = prize.IsMultipleVoting
}
, new OleDbParameter("@VoteType", OleDbType.VarWChar)
{
Value = prize.VoteType
}
, new OleDbParameter("@ParticipantNumber", OleDbType.Integer)
{
Value = prize.ParticipantLimit
}
, new OleDbParameter("@AppendixDiscription", OleDbType.VarWChar)
{
Value = prize.AppendixDiscription
}
);
prize.PrizeID = GetPrize(prize.PrizeName, prize.SpecialtyID.Value, conn, tran).PrizeID;
}
else
{
sbSql.Append(" UPDATE Prize ");
sbSql.Append(" SET PrizeName = ? ");
sbSql.Append(" ,IsMultipleVoting = ? ");
sbSql.Append(" ,VoteType = ? ");
sbSql.Append(" ,ParticipantLimit = ? ");
sbSql.Append(" ,AppendixDiscription = ? ");
sbSql.Append(" ,LastUpdateTime = GETDATE() ");
sbSql.Append(" WHERE PrizeID = ? ");
int iResult = Dal.OleDbHlper.ExecuteNonQuery(
sbSql.ToString(), conn, CommandType.Text, tran
, new OleDbParameter("@PrizeName", OleDbType.VarWChar)
{
Value = prize.PrizeName
}
, new OleDbParameter("@IsMultipleVoting", OleDbType.Boolean)
{
Value = prize.IsMultipleVoting
}
, new OleDbParameter("@VoteType", OleDbType.VarWChar)
{
Value = prize.VoteType
}
, new OleDbParameter("@ParticipantLimit", OleDbType.Integer)
{
Value = prize.ParticipantLimit
}
, new OleDbParameter("@AppendixDiscription", OleDbType.VarWChar)
{
Value = prize.AppendixDiscription
}
, new OleDbParameter("@PrizeID", OleDbType.Integer)
{
Value = prize.PrizeID
}
);
}
//奖项数量
SetPrizeLevel(prize, LstPrizeLimitNum, conn, tran);
SetOrdinal(prize, conn, tran);
return(prize.PrizeID.Value);
}
/// <summary>
/// 删除专业和专业的子专业（递归）(已有申报奖项的专业，不允许删除)
/// </summary>
/// <param name="iSpecialtyID"></param>
/// <param name="conn"></param>
/// <param name="trans"></param>
public static void DeleteSpecialty(int iSpecialtyID, OleDbConnection conn, OleDbTransaction trans = null)
{
StringBuilder sbSql = new StringBuilder();
// 已有申报奖项的专业，不允许删除
Dal.Models.Specialty mSpecialty = GetSpecialty(iSpecialtyID, conn, trans);
if ((mSpecialty.PrizeCount ?? 0) > 0 || (mSpecialty.ChildCount ?? 0) > 0 || Declaration.CountInSpecialty(mSpecialty.SpecialtyID.Value, conn, trans) > 0)
{
throw new Exception("当前专业已有申报奖项，不能删除！");
}
else
{
// 删除专业、子专业奖项
string strSql = " delete FROM Prize WHERE SpecialtyID = ? or SpecialtyID in (select SpecialtyID from dbo.Fn_GetChildSpecialty(?)) ";
Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
});
// 删除专业、子专业附件
strSql = "delete from Appendix where SpecialtyID = ? or SpecialtyID in (select SpecialtyID from dbo.Fn_GetChildSpecialty(?)) ";
Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
});
// 删除专业、子专业图集
strSql = "delete from Atlas where SpecialtyID = ? or SpecialtyID in (select SpecialtyID from dbo.Fn_GetChildSpecialty(?)) ";
Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
});
// 删除专业、子专业
strSql = " delete FROM Specialty WHERE SpecialtyID = ? or SpecialtyID in (select SpecialtyID from dbo.Fn_GetChildSpecialty(?)) ";
Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, trans
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
}
, new OleDbParameter("@SpecialtyID", OleDbType.Integer)
{
Value = iSpecialtyID
});
// 重排序号
ResetOrdinal(mSpecialty.ActivityID.Value, mSpecialty.ParentID, conn, trans);
}
}
/// <summary>
/// 创建专业
/// </summary>
/// <param name="specialty"></param>
/// <returns></returns>
public static int CreateSpecialty(Dal.Models.Specialty specialty, OleDbConnection conn, OleDbTransaction trans = null)
{
PreCheck(specialty, conn, trans);
StringBuilder sbSql = new StringBuilder();
sbSql.Append(" INSERT INTO Specialty ( ");
sbSql.Append(" ActivityID ");
sbSql.Append(" ,SpecialtyCode ");
sbSql.Append(" ,SpecialtyName ");
sbSql.Append(" ,SpecialtyLevel ");
sbSql.Append(" ,SpecialtyIcon ");
sbSql.Append(" ,TemplateCode ");
sbSql.Append(" ,IsShareQuota ");
sbSql.Append(" ,IsInheritSchedule ");
sbSql.Append(" ,IsInheritTemplet ");
sbSql.Append(" ,IsAllowUpdate");
sbSql.Append(" ,IsAllowSubmit");
sbSql.Append(" ,ParentID ");
sbSql.Append(" ,CreateTime ");
sbSql.Append(" ,LastUpdateTime ");
sbSql.Append(" ,IsSendReceivePost");
sbSql.Append(" ,IsSendUpdatePost");
sbSql.Append(" ,IsSendDeletePost");
sbSql.Append(" ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?,?,?,?,?)");
// 创建专业
Dal.OleDbHlper.ExecuteNonQuery(sbSql.ToString(), conn, CommandType.Text, trans
, new OleDbParameter("@ActivityID", OleDbType.Integer)
{
Value = specialty.ActivityID
}
, new OleDbParameter("@SpecialtyCode", OleDbType.VarWChar)
{
Value = specialty.SpecialtyCode
}
, new OleDbParameter("@SpecialtyName", OleDbType.VarWChar)
{
Value = specialty.SpecialtyName
}
, new OleDbParameter("@SpecialtyLevel", OleDbType.VarWChar)
{
Value = specialty.SpecialtyLevel
}
, new OleDbParameter("@SpecialtyIcon", OleDbType.VarWChar)
{
Value = specialty.SpecialtyIcon
}
, new OleDbParameter("@TemplateCode", OleDbType.VarWChar)
{
Value = specialty.TemplateCode
}
, new OleDbParameter("@IsShareQuota", OleDbType.Boolean)
{
Value = specialty.IsShareQuota
}
, new OleDbParameter("@IsInheritSchedule", OleDbType.Boolean)
{
Value = specialty.IsInheritSchedule
}
, new OleDbParameter("@IsInheritTemplet", OleDbType.Boolean)
{
Value = specialty.IsInheritTemplet
}
, new OleDbParameter("@IsAllowUpdate", OleDbType.Boolean)
{
Value = specialty.IsAllowUpdate
}
, new OleDbParameter("@IsAllowSubmit", OleDbType.Boolean)
{
Value = specialty.IsAllowSubmit
}
, new OleDbParameter("@ParentID", OleDbType.Integer)
{
Value = specialty.ParentID
}
, new OleDbParameter("@CreateTime", OleDbType.DBDate)
{
Value = specialty.CreateTime
}
, new OleDbParameter("@LastUpdateTime", OleDbType.DBDate)
{
Value = specialty.LastUpdateTime
}
, new OleDbParameter("@IsSendReceivePost", OleDbType.Boolean)
{
Value = specialty.IsSendReceivePost
}
, new OleDbParameter("@IsSendUpdatePost", OleDbType.Boolean)
{
Value = specialty.IsSendUpdatePost
}
, new OleDbParameter("@IsSendDeletePost", OleDbType.Boolean)
{
Value = specialty.IsSendDeletePost
});
specialty.SpecialtyID = GetSpecialtyByCode(specialty.SpecialtyCode, specialty.ActivityID.Value, conn, trans).SpecialtyID;
// 对专业重新排序，设定专业内部序号
SetOrdinal(specialty, conn, trans);
return(specialty.SpecialtyID.Value);
}
protected void lkbCreate_Click(object sender, EventArgs e)
{
int num = BLL.Specialty.IsExist(txtSpecialtyName.Text);
if (num > 0)
{
hdMsg.Value = "该专业名已存在!";
//Response.Write("<script>alert('该专业名已存在!')</script>");
}
else
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
hdMsg.Value = "当前活动已经结束!";
return;
}
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
Dal.Models.Specialty specialty = new Dal.Models.Specialty();
if (ddlParent.SelectedValue != "0")
{
specialty.ParentID = Convert.ToInt32(ddlParent.SelectedValue);
}
specialty.ActivityID = activity.ActivityID;
if (!string.IsNullOrEmpty(txtIconPicker.Value))
{
specialty.SpecialtyIcon = txtIconPicker.Value;
}
specialty.SpecialtyName = txtSpecialtyName.Text;
//specialty.SpecialtyCode = txtSpecialtyCode.Text;
if (hfLevel.Value == "一级")
{
specialty.SpecialtyLevel = "二级";
}
else if (hfLevel.Value == "二级")
{
specialty.SpecialtyLevel = "三级";
}
else if (hfLevel.Value == "三级")
{
hdMsg.Value = "不能给三级专业再创建子专业！";
return;
}
string templateCode = BLL.Specialty.GetTempletCode(Convert.ToInt32(specialty.ParentID), conn);
specialty.TemplateCode = templateCode;//ddlTemplate.SelectedValue;
int iOrdinal = 0;
if (!string.IsNullOrEmpty(txtOrdinal.Text) && Int32.TryParse(txtOrdinal.Text, out iOrdinal))
{
specialty.Ordinal = iOrdinal;
}
specialty.IsInheritSchedule = ddlIsInheritSchedule.SelectedValue == "True";
specialty.IsInheritTemplet = false; //ddlIsInheritTemplet.SelectedValue == "True";
specialty.IsAllowUpdate = ddlIsAllowUpdate.SelectedValue == "True";
specialty.IsAllowSubmit = ddlIsAllowSubmit.SelectedValue == "True";
specialty.IsSendReceivePost = ddlIsSendReceivePost.SelectedValue == "True";
specialty.IsSendUpdatePost = ddlIsSendUpdatePost.SelectedValue == "True";
specialty.IsSendDeletePost = ddlIsSendDeletePost.SelectedValue == "True";
//specialty.IsSendReceivePost = Convert.ToInt32(ddlIsSendReceivePost.SelectedValue);
//specialty.IsSendUpdatePost = Convert.ToInt32(ddlIsSendUpdatePost.SelectedValue);
//specialty.IsSendDeletePost = Convert.ToInt32(ddlIsSendDeletePost.SelectedValue);
OleDbTransaction trans = conn.BeginTransaction();
try
{
int result = BLL.Specialty.CreateSpecialty(specialty, conn, trans);
trans.Commit();
hdMsg.Value = "添加成功!";
txtSpecialtyID.Text = result.ToString();
//Response.Write("<script>alert('添加成功!')</script>");
}
catch (Exception ex)
{
trans.Rollback();
//Response.Write("<script>alert('" + ex.Message + "')</script>");
hdMsg.Value = ex.Message;
}
conn.Close();
//Response.Redirect("~/view/ActivityManage/SpecialtyList.aspx?specialtyMSg=" + hdMsg.Value);
}
}
