/// <summary>
/// 根据影响因子(QIF)返回级别(JiBie)和级别分系数(LevelFactor) －By Jianguo Fung
/// </summary>
public ZQUSR.Model.sr_Lunwen GetJiBieByQIF(decimal QIF)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JiBie,LevelFactor from sr_Lunwen ");
strSql.Append(" where @QIF>Factor1-0.0001 and @QIF<Factor2 ");
SqlParameter[] parameters =
{
new SqlParameter("@QIF", SqlDbType.Decimal, 8)
};
parameters[0].Value = QIF;
ZQUSR.Model.sr_Lunwen model = new ZQUSR.Model.sr_Lunwen();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.JiBie = ds.Tables[0].Rows[0]["JiBie"].ToString();
if (ds.Tables[0].Rows[0]["LevelFactor"].ToString() != "")
{
model.LevelFactor = decimal.Parse(ds.Tables[0].Rows[0]["LevelFactor"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 根据收录转载情况(Sitution)返回级别(JiBie)和级别分系数(LevelFactor) －By Jianguo Fung
/// </summary>
public ZQUSR.Model.sr_Lunwen GetJiBieBySitution(string Situation)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JiBie,LevelFactor from sr_Lunwen ");
strSql.Append(" where Situation=@Situation");
SqlParameter[] parameters =
{
new SqlParameter("@Situation", SqlDbType.NVarChar, 100)
};
parameters[0].Value = Situation;
ZQUSR.Model.sr_Lunwen model = new ZQUSR.Model.sr_Lunwen();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.JiBie = ds.Tables[0].Rows[0]["JiBie"].ToString();
if (ds.Tables[0].Rows[0]["LevelFactor"].ToString() != "")
{
model.LevelFactor = decimal.Parse(ds.Tables[0].Rows[0]["LevelFactor"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZQUSR.Model.sr_Lunwen GetModel(int PK_LID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PK_LID,Type,Situation,Factor1,Factor2,JiBie,LevelFactor,Extra1,Extra2 from sr_Lunwen ");
strSql.Append(" where PK_LID=@PK_LID ");
SqlParameter[] parameters =
{
new SqlParameter("@PK_LID", SqlDbType.Int, 4)
};
parameters[0].Value = PK_LID;
ZQUSR.Model.sr_Lunwen model = new ZQUSR.Model.sr_Lunwen();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["PK_LID"].ToString() != "")
{
model.PK_LID = int.Parse(ds.Tables[0].Rows[0]["PK_LID"].ToString());
}
model.Type = ds.Tables[0].Rows[0]["Type"].ToString();
model.Situation = ds.Tables[0].Rows[0]["Situation"].ToString();
if (ds.Tables[0].Rows[0]["Factor1"].ToString() != "")
{
model.Factor1 = decimal.Parse(ds.Tables[0].Rows[0]["Factor1"].ToString());
//model.Factor1 = ds.Tables[0].Rows[0]["Factor1"].ToString(); //---by caiyuying
}
if (ds.Tables[0].Rows[0]["Factor2"].ToString() != "")
{
model.Factor2 = decimal.Parse(ds.Tables[0].Rows[0]["Factor2"].ToString());
//model.Factor2 = ds.Tables[0].Rows[0]["Factor2"].ToString(); //---by caiyuying
}
model.JiBie = ds.Tables[0].Rows[0]["JiBie"].ToString();
if (ds.Tables[0].Rows[0]["LevelFactor"].ToString() != "")
{
model.LevelFactor = decimal.Parse(ds.Tables[0].Rows[0]["LevelFactor"].ToString());
//model.LevelFactor = ds.Tables[0].Rows[0]["LevelFactor"].ToString(); //---by caiyuying
}
model.Extra1 = ds.Tables[0].Rows[0]["Extra1"].ToString();
model.Extra2 = ds.Tables[0].Rows[0]["Extra2"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 是否存在该记录（Type/Situation）－By Jianguo Fung
/// </summary>
public bool Exists(ZQUSR.Model.sr_Lunwen model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from sr_Lunwen");
strSql.Append(" where Type=@Type and ");
strSql.Append(" Situation=@Situation ");
SqlParameter[] parameters =
{
new SqlParameter("@Type", SqlDbType.Char, 10),
new SqlParameter("@Situation", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.Type;
parameters[1].Value = model.Situation;
return(DbHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 更新级别和级别分系数 －By Jianguo Fung
/// </summary>
/// <param name="model"></param>
public void UpdateJiBie(ZQUSR.Model.sr_Lunwen model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sr_Lunwen set ");
strSql.Append("JiBie=@JiBie,");
strSql.Append("LevelFactor=@LevelFactor ");
strSql.Append(" where PK_LID=@PK_LID ");
SqlParameter[] parameters =
{
new SqlParameter("@PK_LID", SqlDbType.Int, 4),
new SqlParameter("@JiBie", SqlDbType.Char, 1),
new SqlParameter("@LevelFactor", SqlDbType.Float, 8)
};
parameters[0].Value = model.PK_LID;
parameters[1].Value = model.JiBie;
parameters[2].Value = model.LevelFactor;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ZQUSR.Model.sr_Lunwen model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sr_Lunwen(");
strSql.Append("Type,Situation,Factor1,Factor2,JiBie,LevelFactor,Extra1,Extra2)");
strSql.Append(" values (");
strSql.Append("@Type,@Situation,@Factor1,@Factor2,@JiBie,@LevelFactor,@Extra1,@Extra2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Type", SqlDbType.NVarChar, 10),
new SqlParameter("@Situation", SqlDbType.NVarChar, 100),
new SqlParameter("@Factor1", SqlDbType.Float, 8),
new SqlParameter("@Factor2", SqlDbType.Float, 8),
new SqlParameter("@JiBie", SqlDbType.Char, 1),
new SqlParameter("@LevelFactor", SqlDbType.Float, 8),
new SqlParameter("@Extra1", SqlDbType.NVarChar, 10),
new SqlParameter("@Extra2", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.Type;
parameters[1].Value = model.Situation;
parameters[2].Value = model.Factor1;
parameters[3].Value = model.Factor2;
parameters[4].Value = model.JiBie;
parameters[5].Value = model.LevelFactor;
parameters[6].Value = model.Extra1;
parameters[7].Value = model.Extra2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据 modify by caiyuying 2011-01-20
/// </summary>
public void Update(ZQUSR.Model.sr_Lunwen model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sr_Lunwen set ");
//strSql.Append("Type=@Type,");
strSql.Append("Situation=@Situation,");
strSql.Append("Factor1=@Factor1,");
strSql.Append("Factor2=@Factor2,");
strSql.Append("JiBie=@JiBie,");
strSql.Append("LevelFactor=@LevelFactor,");
strSql.Append("Extra1=@Extra1,");
strSql.Append("Extra2=@Extra2");
strSql.Append(" where PK_LID=@PK_LID ");
SqlParameter[] parameters =
{
new SqlParameter("@PK_LID", SqlDbType.Int, 4),
//new SqlParameter("@Type", SqlDbType.NVarChar,10),
new SqlParameter("@Situation", SqlDbType.NVarChar, 100),
new SqlParameter("@Factor1", SqlDbType.Float, 8),
new SqlParameter("@Factor2", SqlDbType.Float, 8),
new SqlParameter("@JiBie", SqlDbType.Char, 1),
new SqlParameter("@LevelFactor", SqlDbType.Float, 8),
new SqlParameter("@Extra1", SqlDbType.NVarChar, 10),
new SqlParameter("@Extra2", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.PK_LID;
//parameters[1].Value = model.Type;
parameters[1].Value = model.Situation;
parameters[2].Value = model.Factor1;
parameters[3].Value = model.Factor2;
parameters[4].Value = model.JiBie;
parameters[5].Value = model.LevelFactor;
parameters[6].Value = model.Extra1;
parameters[7].Value = model.Extra2;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
//protected void txtNumber1_TextChanged(object sender, EventArgs e)
//{
// string strName = PeriBll.GetQikanNameByISSN(txtNumber1.Text);
// txtUnit.Text = strName;
//}
//protected void txtNumber2_TextChanged(object sender, EventArgs e)
//{
// string strName = PeriBll.GetQikanNameByISSN(txtNumber2.Text);
// txtStateUnit.Text = strName;
//}
#endregion
#region 保存
private void Save(string strAuditState)
{
if (Session["UserID"] != null)
{
string cmd = Request.QueryString["cmd"].ToString();
try
{
if (ddlType.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择论文类型！");
ddlType.Focus();
}
else if (txtTitle.Text == "")
{
MessageBox.Show(this, "论文题目不能为空！");
txtTitle.Focus();
}
//else if (txtNumber1.Text == "")
//{
// MessageBox.Show(this, "发表刊物期刊号不能为空！");
// txtNumber1.Focus();
//}
else if (txtUnit.Text == "")
{
MessageBox.Show(this, "发表刊物名称不能为空！");
txtUnit.Focus();
}
else if (txtTime.Text == "")
{
MessageBox.Show(this, "发表日期不能为空！");
txtTime.Focus();
}
else if (!PageValidateBll.IsDateTime(txtTime.Text))
{
MessageBox.Show(this, "发表日期格式不正确！");
txtTime.Focus();
}
else if (ddlState.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择收录/转载情况！");
ddlState.Focus();
}
//else if (txtNumber2.Text == "")
//{
// MessageBox.Show(this, "收录/转载期刊号不能为空！");
// txtNumber2.Focus();
//}
//else if (txtStateUnit.Text == "")
//{
// MessageBox.Show(this, "收录/转载期刊名称不能为空！");
// txtStateUnit.Focus();
//}
else if (ddlSchoolSign.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择学校署名排名！");
ddlSchoolSign.Focus();
}
else if (ddlRank.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择完成成果排名！");
ddlRank.Focus();
}
else
{
string strLZID = txtLZID.Text; //论文编号
string strUserID = Session["UserID"].ToString(); //用户编号
string strBigSort = "科研成果"; //大类别
string strSmallSort = "学术论文"; //小类别
string strType = ddlType.SelectedItem.Text; //论文类型
string strTitle = txtTitle.Text; //论文题目
DateTime dtAddTime = DateTime.Now; //提交时间
//string strNumber1 = txtNumber1.Text; //发表刊物期刊号
string strUnit = txtUnit.Text; //发表刊物名称
DateTime dtPublishTime = Convert.ToDateTime(txtTime.Text); //发表日期
string strState = ddlState.SelectedItem.Text; //收录/转载情况：
int intRank = Convert.ToInt32(ddlRank.SelectedValue); //完成成果排名
string strSchoolSign = ddlSchoolSign.SelectedItem.Text; //学校署名排名
string strRemark = txtRemark.Text; //备注
LZJModel.PK_LZID = strLZID; //论文编号
LZJModel.FK_UserID = strUserID; //用户编号
LZJModel.BigSort = strBigSort; //大类别
LZJModel.SmallSort = strSmallSort; //小类别
LZJModel.Type = strType; //论文类型
LZJModel.Title = strTitle; //论文题目
//LZJModel.Number1 = strNumber1; //发表刊物期刊号
LZJModel.Unit = strUnit; //发表刊物名称
LZJModel.PublishTime = dtPublishTime; //发表日期
LZJModel.Rank = intRank; //完成成果排名
LZJModel.SchoolSign = strSchoolSign; //学校署名排名
LZJModel.Remark = strRemark; //备注
LZJModel.AddTime = dtAddTime; //提交时间
LZJModel.AuditState = strAuditState; //审核状态
//计算级别分
string strJiBie = ""; //级别
decimal decLevelFactor = 0; //级别分系数
decimal decJiBieScore = 0; //级别分
///三种情况的级别和级别分系数
string jibie1 = "", jibie2 = "", jibie3 = "";
decimal levelFactor1 = 0, levelFactor2 = 0, levelFactor3 = 0;
PeriModel = PeriBll.GetLunwenJiBieByQikanName(strUnit);
if (PeriModel != null)
{
//情况一：根据发表刊物得到级别和级别分系数
jibie1 = PeriModel.JiBie;
levelFactor1 = Convert.ToDecimal(PeriModel.LevelFactor);
//情况二：
//若为SCI收录或SSCI收录：先根据发表刊物得到影响因子，再得到级别和级别分系数
if (strState == "被SCI收录" || strState == "被SSCI收录")
{
decimal decQIF = Convert.ToDecimal(PeriModel.QIF);
if (Convert.ToBoolean(decQIF))
{
LunwenModel = LunwenBll.GetJiBieByQIF(decQIF);
if (LunwenModel != null)
{
jibie2 = LunwenModel.JiBie;
levelFactor2 = Convert.ToDecimal(LunwenModel.LevelFactor);
}
}
}
}
//情况三：根据收录/转载情况得到级别和级别分系数
LunwenModel = LunwenBll.GetJiBieBySitution(strState);
if (LunwenModel != null)
{
jibie3 = LunwenModel.JiBie;
levelFactor3 = Convert.ToDecimal(LunwenModel.LevelFactor);
}
//比较大小
if (Convert.ToBoolean(jibie1.CompareTo(jibie2)) && Convert.ToBoolean(jibie1.CompareTo(jibie3)))
{
strJiBie = jibie1;
decLevelFactor = levelFactor1;
}
else if (Convert.ToBoolean(jibie2.CompareTo(jibie1)) && Convert.ToBoolean(jibie2.CompareTo(jibie3)))
{
strJiBie = jibie2;
decLevelFactor = levelFactor2;
}
else
{
strJiBie = jibie3;
decLevelFactor = levelFactor3;
}
LZJModel.JiBie = strJiBie;
LZJModel.LevelFactor = decLevelFactor;
int intScore = LevelScoresBll.GetScoreByJiBie(strJiBie); //根据级别得到对应的级别分数
decJiBieScore = intScore * decLevelFactor; //级别分
//计算成果个人得分
int intPopulation = 1; //完成人数
string strAllAuthor = ""; //参与作者
decimal decPerScore = 0; //个人得分
//根据完成成果排名判断是否为多人合作，若是则按多人合作个人所占比例规则计算得分
//若否则成果总得分即为个人得分
if (!(intRank == -1 || intRank == 0))
{
if (txtPopulation.Text == "")
{
MessageBox.Show(this, "完成人数不能为空！");
txtPopulation.Focus();
}
else if (!PageValidateBll.IsNumber(txtPopulation.Text))
{
MessageBox.Show(this, "完成人数只能填写数字！");
txtPopulation.Focus();
}
else if (txtAllAuthor.Text == "")
{
MessageBox.Show(this, "参与作者不能为空！");
txtAllAuthor.Focus();
}
else
{
intPopulation = Convert.ToInt32(txtPopulation.Text);
strAllAuthor = txtAllAuthor.Text;
//根据完成人数和完成成果排名返回对应的得分比例
Cal2Model = Cal2Bll.GetScoreScale(intPopulation, intRank);
if (Cal2Model != null)
{
string strScale = Cal2Model.ScoreScale;
string[] str = strScale.Split('/');
int int1 = int.Parse(str[0]);
int int2 = int.Parse(str[1]);
decPerScore = decJiBieScore * int1 / int2;
LZJModel.Population = intPopulation; //完成人数
LZJModel.AllAuthor = strAllAuthor; //参与作者
LZJModel.PerScore = decPerScore; //个人得分
if (cmd == "add") //新增
{
if (!LZJBll.Exists(strLZID))
{
LZJBll.Add(LZJModel);
}
else
{
MessageBox.Show(this, "已经存在该记录产！");
}
}
if (cmd == "modify") //修改
{
LZJBll.Update(LZJModel);
}
Response.Redirect("Thesis_List.aspx");
}
}
}
else
{
decPerScore = decJiBieScore;
LZJModel.Population = intPopulation; //完成人数
LZJModel.AllAuthor = strAllAuthor; //参与作者
LZJModel.PerScore = decPerScore; //个人得分
if (cmd == "add") //新增
{
if (!LZJBll.Exists(strLZID))
{
LZJBll.Add(LZJModel);
}
else
{
MessageBox.Show(this, "已经存在该记录产！");
}
}
if (cmd == "modify") //修改
{
LZJBll.Update(LZJModel);
}
Response.Redirect("Thesis_List.aspx");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
else
{
Response.Write("<script language=javascript>alert('您已经与服务器断开连接，请重新登录！');window.location.href='~/../../login.aspx';</script>");
}
}
private void Save(string strAuditState)
{
if (Session["UserID"] != null)
{
string cmd = Request.QueryString["cmd"].ToString();
try
{
if (ddlType.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择论文类型！");
ddlType.Focus();
}
else if (txtTitle.Text == "")
{
MessageBox.Show(this, "论文题目不能为空！");
txtTitle.Focus();
}
//else if (txtNumber1.Text == "")
//{
// MessageBox.Show(this, "发表刊物期刊号不能为空！");
// txtNumber1.Focus();
//}
else if (txtUnit.Text == "")
{
MessageBox.Show(this, "发表刊物名称不能为空！");
txtUnit.Focus();
}
else if (txtTime.Text == "")
{
MessageBox.Show(this, "发表日期不能为空！");
txtTime.Focus();
}
else if (!PageValidateBll.IsDateTime(txtTime.Text))
{
MessageBox.Show(this, "发表日期格式不正确！");
txtTime.Focus();
}
else if (ddlState.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择收录/转载情况！");
ddlState.Focus();
}
//else if (txtNumber2.Text == "")
//{
// MessageBox.Show(this, "收录/转载期刊号不能为空！");
// txtNumber2.Focus();
//}
//else if (txtStateUnit.Text == "")
//{
// MessageBox.Show(this, "收录/转载期刊名称不能为空！");
// txtStateUnit.Focus();
//}
else if (ddlSchoolSign.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择学校署名排名！");
ddlSchoolSign.Focus();
}
else if (ddlRank.SelectedValue == "-1")
{
MessageBox.Show(this, "请选择完成成果排名！");
ddlRank.Focus();
}
else
{
string strLZID = txtLZID.Text; //论文编号
string strUserID = Session["UserID"].ToString(); //用户编号
string strBigSort = "科研成果"; //大类别
string strSmallSort = "学术论文"; //小类别
string strType = ddlType.SelectedItem.Text; //论文类型
string strTitle = txtTitle.Text; //论文题目
DateTime dtAddTime = DateTime.Now; //提交时间
//string strNumber1 = txtNumber1.Text; //发表刊物期刊号
string strUnit = txtUnit.Text; //发表刊物名称
DateTime dtPublishTime = Convert.ToDateTime(txtTime.Text); //发表日期
string strState = ddlState.SelectedItem.Text; //收录/转载情况：
int intRank = Convert.ToInt32(ddlRank.SelectedValue); //完成成果排名
string strSchoolSign = ddlSchoolSign.SelectedItem.Text; //学校署名排名
string strRemark = txtRemark.Text; //备注
LZJModel.PK_LZID = strLZID; //论文编号
LZJModel.FK_UserID = strUserID; //用户编号
LZJModel.BigSort = strBigSort; //大类别
LZJModel.SmallSort = strSmallSort; //小类别
LZJModel.Type = strType; //论文类型
LZJModel.Title = strTitle; //论文题目
//LZJModel.Number1 = strNumber1; //发表刊物期刊号
LZJModel.Unit = strUnit; //发表刊物名称
LZJModel.PublishTime = dtPublishTime; //发表日期
LZJModel.Rank = intRank; //完成成果排名
LZJModel.SchoolSign = strSchoolSign; //学校署名排名
LZJModel.Remark = strRemark; //备注
LZJModel.AddTime = dtAddTime; //提交时间
LZJModel.AuditState = strAuditState; //审核状态
//计算级别分
string strJiBie = ""; //级别
decimal decLevelFactor = 0; //级别分系数
decimal decJiBieScore = 0; //级别分
///三种情况的级别和级别分系数
string jibie1="",jibie2="",jibie3="";
decimal levelFactor1=0, levelFactor2=0, levelFactor3=0;
PeriModel = PeriBll.GetLunwenJiBieByQikanName(strUnit);
if (PeriModel != null)
{
//情况一：根据发表刊物得到级别和级别分系数
jibie1 = PeriModel.JiBie;
levelFactor1 = Convert.ToDecimal(PeriModel.LevelFactor);
//情况二：
//若为SCI收录或SSCI收录：先根据发表刊物得到影响因子，再得到级别和级别分系数
if (strState == "被SCI收录" || strState == "被SSCI收录")
{
decimal decQIF = Convert.ToDecimal(PeriModel.QIF);
if (Convert.ToBoolean(decQIF))
{
LunwenModel = LunwenBll.GetJiBieByQIF(decQIF);
if (LunwenModel != null)
{
jibie2 = LunwenModel.JiBie;
levelFactor2 = Convert.ToDecimal(LunwenModel.LevelFactor);
}
}
}
}
//情况三：根据收录/转载情况得到级别和级别分系数
LunwenModel = LunwenBll.GetJiBieBySitution(strState);
if (LunwenModel != null)
{
jibie3 = LunwenModel.JiBie;
levelFactor3 = Convert.ToDecimal(LunwenModel.LevelFactor);
}
//比较大小
if (Convert.ToBoolean(jibie1.CompareTo(jibie2)) && Convert.ToBoolean(jibie1.CompareTo(jibie3)))
{
strJiBie = jibie1;
decLevelFactor = levelFactor1;
}
else if (Convert.ToBoolean(jibie2.CompareTo(jibie1)) && Convert.ToBoolean(jibie2.CompareTo(jibie3)))
{
strJiBie = jibie2;
decLevelFactor = levelFactor2;
}
else
{
strJiBie = jibie3;
decLevelFactor = levelFactor3;
}
LZJModel.JiBie = strJiBie;
LZJModel.LevelFactor = decLevelFactor;
int intScore = LevelScoresBll.GetScoreByJiBie(strJiBie); //根据级别得到对应的级别分数
decJiBieScore = intScore * decLevelFactor; //级别分
//计算成果个人得分
int intPopulation = 1; //完成人数
string strAllAuthor = ""; //参与作者
decimal decPerScore = 0; //个人得分
//根据完成成果排名判断是否为多人合作，若是则按多人合作个人所占比例规则计算得分
//若否则成果总得分即为个人得分
if (!(intRank == -1 || intRank == 0))
{
if (txtPopulation.Text == "")
{
MessageBox.Show(this, "完成人数不能为空！");
txtPopulation.Focus();
}
else if (!PageValidateBll.IsNumber(txtPopulation.Text))
{
MessageBox.Show(this, "完成人数只能填写数字！");
txtPopulation.Focus();
}
else if (txtAllAuthor.Text == "")
{
MessageBox.Show(this, "参与作者不能为空！");
txtAllAuthor.Focus();
}
else
{
intPopulation = Convert.ToInt32(txtPopulation.Text);
strAllAuthor = txtAllAuthor.Text;
//根据完成人数和完成成果排名返回对应的得分比例
Cal2Model = Cal2Bll.GetScoreScale(intPopulation, intRank);
if (Cal2Model != null)
{
string strScale = Cal2Model.ScoreScale;
string[] str = strScale.Split('/');
int int1 = int.Parse(str[0]);
int int2 = int.Parse(str[1]);
decPerScore = decJiBieScore * int1 / int2;
LZJModel.Population = intPopulation; //完成人数
LZJModel.AllAuthor = strAllAuthor; //参与作者
LZJModel.PerScore = decPerScore; //个人得分
if (cmd == "add") //新增
{
if (!LZJBll.Exists(strLZID))
{
LZJBll.Add(LZJModel);
}
else
{
MessageBox.Show(this, "已经存在该记录产！");
}
}
if (cmd == "modify") //修改
{
LZJBll.Update(LZJModel);
}
Response.Redirect("Thesis_List.aspx");
}
}
}
else
{
decPerScore = decJiBieScore;
LZJModel.Population = intPopulation; //完成人数
LZJModel.AllAuthor = strAllAuthor; //参与作者
LZJModel.PerScore = decPerScore; //个人得分
if (cmd == "add") //新增
{
if (!LZJBll.Exists(strLZID))
{
LZJBll.Add(LZJModel);
}
else
{
MessageBox.Show(this, "已经存在该记录产！");
}
}
if (cmd == "modify") //修改
{
LZJBll.Update(LZJModel);
}
Response.Redirect("Thesis_List.aspx");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
else
{
Response.Write("<script language=javascript>alert('您已经与服务器断开连接，请重新登录！');window.location.href='~/../../login.aspx';</script>");
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public ZQUSR.Model.sr_Lunwen GetModel(int PK_LID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 PK_LID,Type,Situation,Factor1,Factor2,JiBie,LevelFactor,Extra1,Extra2 from sr_Lunwen ");
strSql.Append(" where PK_LID=@PK_LID ");
SqlParameter[] parameters = {
new SqlParameter("@PK_LID", SqlDbType.Int,4)};
parameters[0].Value = PK_LID;
ZQUSR.Model.sr_Lunwen model=new ZQUSR.Model.sr_Lunwen();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["PK_LID"].ToString()!="")
{
model.PK_LID=int.Parse(ds.Tables[0].Rows[0]["PK_LID"].ToString());
}
model.Type=ds.Tables[0].Rows[0]["Type"].ToString();
model.Situation=ds.Tables[0].Rows[0]["Situation"].ToString();
if(ds.Tables[0].Rows[0]["Factor1"].ToString()!="")
{
model.Factor1=decimal.Parse(ds.Tables[0].Rows[0]["Factor1"].ToString());
//model.Factor1 = ds.Tables[0].Rows[0]["Factor1"].ToString(); //---by caiyuying
}
if(ds.Tables[0].Rows[0]["Factor2"].ToString()!="")
{
model.Factor2=decimal.Parse(ds.Tables[0].Rows[0]["Factor2"].ToString());
//model.Factor2 = ds.Tables[0].Rows[0]["Factor2"].ToString(); //---by caiyuying
}
model.JiBie=ds.Tables[0].Rows[0]["JiBie"].ToString();
if(ds.Tables[0].Rows[0]["LevelFactor"].ToString()!="")
{
model.LevelFactor=decimal.Parse(ds.Tables[0].Rows[0]["LevelFactor"].ToString());
//model.LevelFactor = ds.Tables[0].Rows[0]["LevelFactor"].ToString(); //---by caiyuying
}
model.Extra1=ds.Tables[0].Rows[0]["Extra1"].ToString();
model.Extra2=ds.Tables[0].Rows[0]["Extra2"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// ������¼ת�����(Sitution)���ؼ���(JiBie)�ͼ����ϵ��(LevelFactor) ��By Jianguo Fung
/// </summary>
public ZQUSR.Model.sr_Lunwen GetJiBieBySitution(string Situation)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JiBie,LevelFactor from sr_Lunwen ");
strSql.Append(" where Situation=@Situation");
SqlParameter[] parameters = {
new SqlParameter("@Situation", SqlDbType.NVarChar,100)};
parameters[0].Value = Situation;
ZQUSR.Model.sr_Lunwen model = new ZQUSR.Model.sr_Lunwen();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.JiBie = ds.Tables[0].Rows[0]["JiBie"].ToString();
if (ds.Tables[0].Rows[0]["LevelFactor"].ToString() != "")
{
model.LevelFactor = decimal.Parse(ds.Tables[0].Rows[0]["LevelFactor"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// ����Ӱ������(QIF)���ؼ���(JiBie)�ͼ����ϵ��(LevelFactor) ��By Jianguo Fung
/// </summary>
public ZQUSR.Model.sr_Lunwen GetJiBieByQIF(decimal QIF)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JiBie,LevelFactor from sr_Lunwen ");
strSql.Append(" where @QIF>Factor1-0.0001 and @QIF<Factor2 ");
SqlParameter[] parameters = {
new SqlParameter("@QIF", SqlDbType.Decimal,8)};
parameters[0].Value = QIF;
ZQUSR.Model.sr_Lunwen model = new ZQUSR.Model.sr_Lunwen();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.JiBie = ds.Tables[0].Rows[0]["JiBie"].ToString();
if (ds.Tables[0].Rows[0]["LevelFactor"].ToString() != "")
{
model.LevelFactor = decimal.Parse(ds.Tables[0].Rows[0]["LevelFactor"].ToString());
}
return model;
}
else
{
return null;
}
}
