Exemplo n.º 1
0
        } // function UpdateARecord

        /// <summary>
        /// 向数据库会议表中插入一条新信息,并返回会议ID
        /// </summary>
        /// <param name="obj">一条新的会议信息</param>
        /// <returns>返回会议的编号</returns>
        /// 作者:王宇昊
        /// 创建时间:2014-09-18
        /// 修改时间:
        public int AddARecordReturnId(object obj)
        {
            try
            {
                ConferenceModel Conference = (ConferenceModel)obj;
                string          strSqlCmd;// 存储数据库命令语句
                strSqlCmd = string.Format(@"insert into Conference values('{0}','{1}','{2}','{3}','{4}',
                                                                          '{5}','{6}','{7}','{8}','{9}',
                                                                          '{10}','{11}','{12}')Select @@Identity",
                                          Conference.ConName, Conference.ConPlace, Conference.ConStartTime.ToString("yyyy-MM-dd HH:mm:ss"),
                                          Conference.ConEndTime.ToString("yyyy-MM-dd HH:mm:ss"), Conference.ConHost, Conference.ConType, Conference.ConStatus,
                                          Conference.ConSubMen, Conference.ConRecordMen, Conference.ConStaffMen, Conference.ConRegister,
                                          Conference.ConIsDone, Conference.ConOthers);
                int CId = SqlHelperDB.ExecuteSqlReturnId(SqlHelperDB.ConnectionString, strSqlCmd);//执行并返回会议ID
                return(CId);
            }
            catch (Exception)
            {
                return(-1);
            }
        } // function AddARecord