/// <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); }