/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Calculate2 model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Calculate2(");
strSql.Append("Population,Rank,ScoreScale)");
strSql.Append(" values (");
strSql.Append("@Population,@Rank,@ScoreScale)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Population", SqlDbType.Int,4),
new SqlParameter("@Rank", SqlDbType.Int,4),
new SqlParameter("@ScoreScale", SqlDbType.NVarChar,5)};
parameters[0].Value = model.Population;
parameters[1].Value = model.Rank;
parameters[2].Value = model.ScoreScale;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_TotalScore model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_TotalScore(");
strSql.Append("FK_UserID,Year,TotalScore,TotalRewards,Extra1,Extra2)");
strSql.Append(" values (");
strSql.Append("@FK_UserID,@Year,@TotalScore,@TotalRewards,@Extra1,@Extra2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@FK_UserID", SqlDbType.NVarChar,10),
new SqlParameter("@Year", SqlDbType.NVarChar,4),
new SqlParameter("@TotalScore", SqlDbType.Float,8),
new SqlParameter("@TotalRewards", SqlDbType.Float,8),
new SqlParameter("@Extra1", SqlDbType.NVarChar,10),
new SqlParameter("@Extra2", SqlDbType.NVarChar,10)};
parameters[0].Value = model.FK_UserID;
parameters[1].Value = model.Year;
parameters[2].Value = model.TotalScore;
parameters[3].Value = model.TotalRewards;
parameters[4].Value = model.Extra1;
parameters[5].Value = model.Extra2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Produce model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Produce(");
strSql.Append("XueKe,Source,JiBie,LevelFactor)");
strSql.Append(" values (");
strSql.Append("@XueKe,@Source,@JiBie,@LevelFactor)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@XueKe", SqlDbType.Char,4),
new SqlParameter("@Source", SqlDbType.NVarChar,70),
new SqlParameter("@JiBie", SqlDbType.Char,1),
new SqlParameter("@LevelFactor", SqlDbType.Float,8)};
parameters[0].Value = model.XueKe;
parameters[1].Value = model.Source;
parameters[2].Value = model.JiBie;
parameters[3].Value = model.LevelFactor;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Calculate1 model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Calculate1(");
strSql.Append("Sort,JiBie,SchoolSign,Scale)");
strSql.Append(" values (");
strSql.Append("@Sort,@JiBie,@SchoolSign,@Scale)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Sort", SqlDbType.NVarChar,10),
new SqlParameter("@JiBie", SqlDbType.Char,1),
new SqlParameter("@SchoolSign", SqlDbType.NVarChar,10),
new SqlParameter("@Scale", SqlDbType.Float,8)};
parameters[0].Value = model.Sort;
parameters[1].Value = model.JiBie;
parameters[2].Value = model.SchoolSign;
parameters[3].Value = model.Scale;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Message model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Message(");
strSql.Append("Title,MessContent,FK_RecieverID,FK_SenderID,SendTime,IsRead)");
strSql.Append(" values (");
strSql.Append("@Title,@MessContent,@FK_RecieverID,@FK_SenderID,@SendTime,@IsRead)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,50),
new SqlParameter("@MessContent", SqlDbType.NVarChar,500),
new SqlParameter("@FK_RecieverID", SqlDbType.NVarChar,10),
new SqlParameter("@FK_SenderID", SqlDbType.NVarChar,10),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@IsRead", SqlDbType.TinyInt,1)};
parameters[0].Value = model.Title;
parameters[1].Value = model.MessContent;
parameters[2].Value = model.FK_RecieverID;
parameters[3].Value = model.FK_SenderID;
parameters[4].Value = model.SendTime;
parameters[5].Value = model.IsRead;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(ZQUSR.Model.sr_Roles model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Roles(");
strSql.Append("PK_RoleID,RoleName,RoleIntro)");
strSql.Append(" values (");
strSql.Append("@PK_RoleID,@RoleName,@RoleIntro)");
SqlParameter[] parameters = {
new SqlParameter("@PK_RoleID", SqlDbType.NVarChar,10),
new SqlParameter("@RoleName", SqlDbType.NVarChar,10),
new SqlParameter("@RoleIntro", SqlDbType.NVarChar,50)};
parameters[0].Value = model.PK_RoleID;
parameters[1].Value = model.RoleName;
parameters[2].Value = model.RoleIntro;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(ZQUSR.Model.sr_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sr_User(");
strSql.Append("PK_UserID,UserName,Password,Sex,Unit,Education,ZhiCheng,Telephone,InOffice,Email,Logins,LastLogin,Status,Extra1,Extra2,Extra3)");
strSql.Append(" values (");
strSql.Append("@PK_UserID,@UserName,@Password,@Sex,@Unit,@Education,@ZhiCheng,@Telephone,@InOffice,@Email,@Logins,@LastLogin,@Status,@Extra1,@Extra2,@Extra3)");
SqlParameter[] parameters = {
new SqlParameter("@PK_UserID", SqlDbType.NVarChar,10),
new SqlParameter("@UserName", SqlDbType.NVarChar,10),
new SqlParameter("@Password", SqlDbType.NVarChar,32),
new SqlParameter("@Sex", SqlDbType.Char,2),
new SqlParameter("@Unit", SqlDbType.NVarChar,20),
new SqlParameter("@Education", SqlDbType.NVarChar,10),
new SqlParameter("@ZhiCheng", SqlDbType.NVarChar,10),
new SqlParameter("@Telephone", SqlDbType.NVarChar,15),
new SqlParameter("@InOffice", SqlDbType.TinyInt,1),
new SqlParameter("@Email", SqlDbType.NVarChar,30),
new SqlParameter("@Logins", SqlDbType.Int,4),
new SqlParameter("@LastLogin", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.TinyInt,1),
new SqlParameter("@Extra1", SqlDbType.NVarChar,10),
new SqlParameter("@Extra2", SqlDbType.NVarChar,10),
new SqlParameter("@Extra3", SqlDbType.NVarChar,10)};
parameters[0].Value = model.PK_UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.Sex;
parameters[4].Value = model.Unit;
parameters[5].Value = model.Education;
parameters[6].Value = model.ZhiCheng;
parameters[7].Value = model.Telephone;
parameters[8].Value = model.InOffice;
parameters[9].Value = model.Email;
parameters[10].Value = model.Logins;
parameters[11].Value = model.LastLogin;
parameters[12].Value = model.Status;
parameters[13].Value = model.Extra1;
parameters[14].Value = model.Extra2;
parameters[15].Value = model.Extra3;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Periodicals model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Periodicals(");
strSql.Append("ISSN,QikanKey,QikanName,QikanEngName,XueKe,QIF,JiBie,LevelFactor,Extra1,Extra2,Extra3)");
strSql.Append(" values (");
strSql.Append("@ISSN,@QikanKey,@QikanName,@QikanEngName,@XueKe,@QIF,@JiBie,@LevelFactor,@Extra1,@Extra2,@Extra3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ISSN", SqlDbType.NVarChar,20),
new SqlParameter("@QikanKey", SqlDbType.NVarChar,10),
new SqlParameter("@QikanName", SqlDbType.NVarChar,100),
new SqlParameter("@QikanEngName", SqlDbType.NVarChar,100),
new SqlParameter("@XueKe", SqlDbType.NVarChar,10),
new SqlParameter("@QIF", 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),
new SqlParameter("@Extra3", SqlDbType.NVarChar,10)};
parameters[0].Value = model.ISSN;
parameters[1].Value = model.QikanKey;
parameters[2].Value = model.QikanName;
parameters[3].Value = model.QikanEngName;
parameters[4].Value = model.XueKe;
parameters[5].Value = model.QIF;
parameters[6].Value = model.JiBie;
parameters[7].Value = model.LevelFactor;
parameters[8].Value = model.Extra1;
parameters[9].Value = model.Extra2;
parameters[10].Value = model.Extra3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Evaluate model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Evaluate(");
strSql.Append("Sort,Type,Source,Grade,AwardGrade,Funds1,Funds2,JiBie,LevelFactor,Extra1,Extra2)");
strSql.Append(" values (");
strSql.Append("@Sort,@Type,@Source,@Grade,@AwardGrade,@Funds1,@Funds2,@JiBie,@LevelFactor,@Extra1,@Extra2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Sort", SqlDbType.NVarChar,10),
new SqlParameter("@Type", SqlDbType.NVarChar,10),
new SqlParameter("@Source", SqlDbType.NVarChar,30),
new SqlParameter("@Grade", SqlDbType.NVarChar,20),
new SqlParameter("@AwardGrade", SqlDbType.NVarChar,5),
new SqlParameter("@Funds1", SqlDbType.Float,8),
new SqlParameter("@Funds2", 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.Sort;
parameters[1].Value = model.Type;
parameters[2].Value = model.Source;
parameters[3].Value = model.Grade;
parameters[4].Value = model.AwardGrade;
parameters[5].Value = model.Funds1;
parameters[6].Value = model.Funds2;
parameters[7].Value = model.JiBie;
parameters[8].Value = model.LevelFactor;
parameters[9].Value = model.Extra1;
parameters[10].Value = model.Extra2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_WordsFunds model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sr_WordsFunds(");
strSql.Append("Sort,Type,Digit1,Digit2,Digit3,Digit4,Digit5,Digit6,Digit7)");
strSql.Append(" values (");
strSql.Append("@Sort,@Type,@Digit1,@Digit2,@Digit3,@Digit4,@Digit5,@Digit6,@Digit7)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Sort", SqlDbType.NVarChar,10),
new SqlParameter("@Type", SqlDbType.NVarChar,10),
new SqlParameter("@Digit1", SqlDbType.Float,8),
new SqlParameter("@Digit2", SqlDbType.Float,8),
new SqlParameter("@Digit3", SqlDbType.Float,8),
new SqlParameter("@Digit4", SqlDbType.Float,8),
new SqlParameter("@Digit5", SqlDbType.Float,8),
new SqlParameter("@Digit6", SqlDbType.Float,8),
new SqlParameter("@Digit7", SqlDbType.Float,8)};
parameters[0].Value = model.Sort;
parameters[1].Value = model.Type;
parameters[2].Value = model.Digit1;
parameters[3].Value = model.Digit2;
parameters[4].Value = model.Digit3;
parameters[5].Value = model.Digit4;
parameters[6].Value = model.Digit5;
parameters[7].Value = model.Digit6;
parameters[8].Value = model.Digit7;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_HelpNotice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_HelpNotice(");
strSql.Append("Title,FK_UserID,AddTime,NotContent,Type,Extra1,Extra2,Extra3)");
strSql.Append(" values (");
strSql.Append("@Title,@FK_UserID,@AddTime,@NotContent,@Type,@Extra1,@Extra2,@Extra3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,50),
new SqlParameter("@FK_UserID", SqlDbType.NVarChar,10),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@NotContent", SqlDbType.NVarChar,500),
new SqlParameter("@Type", SqlDbType.TinyInt,1),
new SqlParameter("@Extra1", SqlDbType.NVarChar,10),
new SqlParameter("@Extra2", SqlDbType.NVarChar,10),
new SqlParameter("@Extra3", SqlDbType.NVarChar,10)};
parameters[0].Value = model.Title;
parameters[1].Value = model.FK_UserID;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.NotContent;
parameters[4].Value = model.Type;
parameters[5].Value = model.Extra1;
parameters[6].Value = model.Extra2;
parameters[7].Value = model.Extra3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Publish model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_Publish(");
strSql.Append("Publisher,UnitName)");
strSql.Append(" values (");
strSql.Append("@Publisher,@UnitName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Publisher", SqlDbType.NVarChar,20),
new SqlParameter("@UnitName", SqlDbType.NVarChar,20)};
parameters[0].Value = model.Publisher;
parameters[1].Value = model.UnitName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <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>
/// 增加一条数据
/// </summary>
public int Add(ZQUSR.Model.sr_ZhiCheng model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sr_ZhiCheng(");
strSql.Append("Grade,ZhiChengName)");
strSql.Append(" values (");
strSql.Append("@Grade,@ZhiChengName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Grade", SqlDbType.NVarChar,10),
new SqlParameter("@ZhiChengName", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Grade;
parameters[1].Value = model.ZhiChengName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_LevelScores model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sr_LevelScores(");
strSql.Append("JiBie,Score)");
strSql.Append(" values (");
strSql.Append("@JiBie,@Score)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@JiBie", SqlDbType.Char,1),
new SqlParameter("@Score", SqlDbType.Int,4)};
parameters[0].Value = model.JiBie;
parameters[1].Value = model.Score;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ZQUSR.Model.sr_ZhiCheng model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sr_ZhiCheng set ");
strSql.Append("Grade=@Grade,");
strSql.Append("ZhiChengName=@ZhiChengName");
strSql.Append(" where PK_ZCID=@PK_ZCID");
SqlParameter[] parameters = {
new SqlParameter("@PK_ZCID", SqlDbType.Int,4),
new SqlParameter("@Grade", SqlDbType.NVarChar,10),
new SqlParameter("@ZhiChengName", SqlDbType.NVarChar,50)};
parameters[0].Value = model.PK_ZCID;
parameters[1].Value = model.Grade;
parameters[2].Value = model.ZhiChengName;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ���¼���ͼ����ϵ�� ��By Jianguo Fung
/// </summary>
/// <param name="model"></param>
public void UpdateJiBie(ZQUSR.Model.sr_Periodicals model)
{
dal.UpdateJiBie(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(ZQUSR.Model.sr_HelpNotice model)
{
dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_HelpNotice model)
{
return dal.Add(model);
}
/// <summary>
/// ���¼���ͼ����ϵ�� ��By Jianguo Fung
/// </summary>
/// <param name="model"></param>
public void UpdateJiBie(ZQUSR.Model.sr_Periodicals model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sr_Periodicals set ");
strSql.Append(" JiBie=@JiBie,");
strSql.Append(" LevelFactor=@LevelFactor ");
strSql.Append(" where PK_PID=@PK_PID ");
SqlParameter[] parameters = {
new SqlParameter("@PK_PID", SqlDbType.Int,4),
new SqlParameter("@JiBie", SqlDbType.Char,1),
new SqlParameter("@LevelFactor", SqlDbType.Float,8)};
parameters[0].Value = model.PK_PID;
parameters[1].Value = model.JiBie;
parameters[2].Value = model.LevelFactor;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// ����Ӱ������ ��By Jianguo Fung
/// </summary>
/// <param name="model"></param>
public void UpdateQIF(ZQUSR.Model.sr_Periodicals model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sr_Periodicals set ");
strSql.Append("QIF=@QIF ");
strSql.Append(" where PK_PID=@PK_PID ");
SqlParameter[] parameters = {
new SqlParameter("@PK_PID", SqlDbType.Int,4),
new SqlParameter("@QIF", SqlDbType.Float,8)};
parameters[0].Value = model.PK_PID;
parameters[1].Value = model.QIF;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// ����һ������ ��By Jianguo Fung
/// </summary>
public void UpdateScale(ZQUSR.Model.sr_Calculate3 model)
{
dal.UpdateScale(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(ZQUSR.Model.sr_Periodicals model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update sr_Periodicals set ");
strSql.Append("ISSN=@ISSN,");
strSql.Append("QikanKey=@QikanKey,");
strSql.Append("QikanName=@QikanName,");
strSql.Append("QikanEngName=@QikanEngName,");
strSql.Append("XueKe=@XueKe,");
strSql.Append("QIF=@QIF,");
strSql.Append("JiBie=@JiBie,");
strSql.Append("LevelFactor=@LevelFactor,");
strSql.Append("Extra1=@Extra1,");
strSql.Append("Extra2=@Extra2,");
strSql.Append("Extra3=@Extra3");
strSql.Append(" where PK_PID=@PK_PID ");
SqlParameter[] parameters = {
new SqlParameter("@PK_PID", SqlDbType.Int,4),
new SqlParameter("@ISSN", SqlDbType.NVarChar,20),
new SqlParameter("@QikanKey", SqlDbType.NVarChar,10),
new SqlParameter("@QikanName", SqlDbType.NVarChar,100),
new SqlParameter("@QikanEngName", SqlDbType.NVarChar,100),
new SqlParameter("@XueKe", SqlDbType.NVarChar,10),
new SqlParameter("@QIF", 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),
new SqlParameter("@Extra3", SqlDbType.NVarChar,10)};
parameters[0].Value = model.PK_PID;
parameters[1].Value = model.ISSN;
parameters[2].Value = model.QikanKey;
parameters[3].Value = model.QikanName;
parameters[4].Value = model.QikanEngName;
parameters[5].Value = model.XueKe;
parameters[6].Value = model.QIF;
parameters[7].Value = model.JiBie;
parameters[8].Value = model.LevelFactor;
parameters[9].Value = model.Extra1;
parameters[10].Value = model.Extra2;
parameters[11].Value = model.Extra3;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Message model)
{
return dal.Add(model);
}
/// <summary>
/// �Ƿ���ڸü�¼��QikanKey/QikanName����By Jianguo Fung
/// </summary>
public bool Exists(ZQUSR.Model.sr_Periodicals model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from sr_Periodicals");
strSql.Append(" where QikanKey=@QikanKey and ");
strSql.Append(" QikanName=@QikanName ");
SqlParameter[] parameters = {
new SqlParameter("@QikanKey", SqlDbType.Char,10),
new SqlParameter("@QikanName", SqlDbType.NVarChar,100)};
parameters[0].Value = model.QikanKey;
parameters[1].Value = model.QikanName;
return DbHelperSQL.Exists(strSql.ToString(), parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(ZQUSR.Model.sr_Message model)
{
dal.Update(model);
}
/// <summary>
/// �Ƿ���ڸü�¼��QikanKey/QikanName����By Jianguo Fung
/// </summary>
public bool Exists(ZQUSR.Model.sr_Periodicals model)
{
return dal.Exists(model);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Periodicals model)
{
return dal.Add(model);
}
/// <summary>
/// ����Ӱ������ ��By Jianguo Fung
/// </summary>
/// <param name="model"></param>
public void UpdateQIF(ZQUSR.Model.sr_Periodicals model)
{
dal.UpdateQIF(model);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ZQUSR.Model.sr_Calculate3 model)
{
return dal.Add(model);
}
