C# SqlDataProvider类代码示例

    public int InsertFeedbackCustomer()
    {
        SqlDataProvider db = new SqlDataProvider();

           // return db.Insert_UserToEmail_mst(this);
            return db.Insert_FeedbackCustomer_mst(this);
    }

    protected void btnsave_Click(object sender, EventArgs e)
    {
        DataTable dtMealTemplate = new DataTable();
        SqlDataProvider db = new SqlDataProvider();
        dtMealTemplate.Columns.Add("Userid", Type.GetType("System.Int32"));
        dtMealTemplate.Columns.Add("Emailid", Type.GetType("System.String"));
        foreach (GridViewRow gvr in grdvwSite.Rows)
        {
            ///DataRow drMT = new DataRow();

            DataRow drMT = dtMealTemplate.NewRow();
            drMT["Userid"] = gvr.Cells[1].Text;
            drMT["Emailid"] = gvr.Cells[4].Text;

            dtMealTemplate.Rows.Add(drMT);
            CheckBox myCheckBox = (CheckBox)gvr.FindControl("CheckAll");
            if (myCheckBox.Checked == true)
            {
                UserEmail obj1 = new UserEmail();

                objuseremail.Userid = Convert.ToInt16(drMT["Userid"]);
                objuseremail.Emailid = drMT["Emailid"].ToString();
                objsentuseremail.SentFeedbackmailToUser(objuseremail.Userid, objuseremail.Emailid);
                objuseremail.InsertFeedbackCustomer();

            }
        }
    }

        public ConnectionTreeModel LoadConnections(bool import)
        {
            IDeserializer deserializer;
            if (UseDatabase)
            {
                var connector = new SqlDatabaseConnector();
                var dataProvider = new SqlDataProvider(connector);
                var dataTable = dataProvider.Load();
                deserializer = new DataTableDeserializer(dataTable);
            }
            else
            {
                var dataProvider = new FileDataProvider(ConnectionFileName);
                var xmlString = dataProvider.Load();
                deserializer = new XmlConnectionsDeserializer(xmlString, PromptForPassword);
            }

            var connectionTreeModel = deserializer.Deserialize();

            if (connectionTreeModel != null)
                frmMain.Default.ConnectionsFileName = ConnectionFileName;
            else
                connectionTreeModel = new ConnectionTreeModel();

            if (import) return connectionTreeModel;
            PuttySessionsManager.Instance.AddSessions();
            connectionTreeModel.RootNodes.AddRange(PuttySessionsManager.Instance.RootPuttySessionsNodes);

            return connectionTreeModel;
        }

 static DataProvider()
 {
     DataProvider dataProvider;
     if (FrameWork.Common.GetDBType == "MsSql")
         dataProvider = new SqlDataProvider();
     else if (FrameWork.Common.GetDBType == "Access")
         dataProvider = new AccessDataProvider();
     else
         throw new ApplicationException("数据库配置不对！");
     _defaultInstance = dataProvider;
 }

        public static IDataProvider GetRepository()
        {
            var ctl = ComponentFactory.GetComponent<IDataProvider>();

            if (ctl == null)
            {
                ctl = new SqlDataProvider();
                ComponentFactory.RegisterComponentInstance<IDataProvider>(ctl);
            }
            return ctl;
        }

 public int Get_By_Id(int CustId, int siteid)
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Get_CustId_mst_Get_By_SiteId(CustId, siteid);
 }

 public int Delete(int CustId, int siteid)
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Delete_CustomerToSiteMapping_mst_By_id(CustId, siteid);
 }

 public int Delete(int slaid)
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Delete_SLA_mst_By_id(slaid);
 }

 public int Insert()
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Insert_SLA_mst(this);
 }

 public SLA_mst Get_By_id(int Slaid)
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.SLA_mst_Get_By_Slaid(Slaid);
 }

 public int Insert()
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Insert_IncidentResolution(this);
 }

 public int Get_By_DepartmentName(string departmentname, int siteid)
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Get_deptid_mst_Get_By_DepartmentName(departmentname, siteid);
 }

 public BLLCollection<Department_mst> Get_All_By_SiteId(int siteid)
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Get_Department_mst_All_By_SieId(siteid);
 }

 public BLLCollection<Department_mst> Get_All()
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Get_Department_mst_All();
 }

 public int Delete(int deptid)
 {
     SqlDataProvider db = new SqlDataProvider();
     return db.Delete_Department_mst_By_id( deptid);
 }