Ejemplo n.º 1
0
        /// <summary>
        /// 摘要:插入一条记录
        /// </summary>
        /// <param name="T">实体类对象</param>
        /// <returns>自增长主键时返回主键值</returns>
        public override string Insert(object T)
        {
            base.Insert(T);
            StringBuilder sbColumnName       = new StringBuilder();
            StringBuilder sbValues           = new StringBuilder();
            List <string> lisParameter       = new List <string>();
            List <object> lisParameterValues = new List <object>();

            foreach (Record drTemp in base._Records)
            {
                if (drTemp.IsAuto == 0)
                {
                    sbColumnName.Append(_Transfer_B);
                    sbColumnName.Append(drTemp.Name);
                    sbColumnName.Append(_Transfer_E);
                    sbColumnName.Append(",");
                    sbValues.Append(_VariableC + drTemp.Name);
                    sbValues.Append(",");
                    lisParameter.Add(_VariableC + drTemp.Name);
                    lisParameterValues.Add(drTemp.Value);
                }
                else
                {
                    //自增长列的处理,如何返回自增长的值。
                }
            }
            Insert insertSql = new Insert(base._TableName, sbColumnName.Remove(sbColumnName.Length - 1, 1), sbValues.Remove(sbValues.Length - 1, 1));
            int    iResult   = ExecuteSql.ExeParaSqlForNonQuery(insertSql.ConnectInsertString(), lisParameter, lisParameterValues);

            return(string.Empty);
        }