alluserdb.cs

自动生成的代码,特别简单,方便,而且易用

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;
/// <summary>
/// AllUserDB 的摘要说明
/// </summary>
public class AllUserDB
{
    public static bool Insert(AllUser entity)
    {
        //请根据您的配置需要，更改Connection的名称
        Database db = DatabaseFactory.CreateDatabase("Connection");
        string sqlCommand = "AllUser_Insert";
        DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper(sqlCommand);

        dbCommandWrapper.AddInParameter("@Phone", DbType.String, entity.Phone);
        dbCommandWrapper.AddInParameter("@ServiceID", DbType.String, entity.ServiceID);
        dbCommandWrapper.AddInParameter("@CreateTime", DbType.String, entity.CreateTime);
        dbCommandWrapper.AddInParameter("@EndTime", DbType.String, entity.EndTime);
        dbCommandWrapper.AddInParameter("@SPNumber", DbType.String, entity.SPNumber);
        dbCommandWrapper.AddInParameter("@Province", DbType.String, entity.Province);
        dbCommandWrapper.AddInParameter("@City", DbType.String, entity.City);
        dbCommandWrapper.AddInParameter("@Flag", DbType.Int32, entity.Flag);
        dbCommandWrapper.AddInParameter("@Attrib1", DbType.String, entity.Attrib1);
        dbCommandWrapper.AddInParameter("@Attrib2", DbType.String, entity.Attrib2);
        dbCommandWrapper.AddInParameter("@Attrib3", DbType.String, entity.Attrib3);

        try
        {
            db.ExecuteNonQuery(dbCommandWrapper);
            return true;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
            //return false;
        }

    }

}