C# 增删改查

最新推荐文章于 2023-07-22 15:35:32 发布
最新推荐文章于 2023-07-22 15:35:32 发布
阅读量489 收藏
点赞数
文章标签： c# 数据库 python
原文链接：https://my.oschina.net/u/3740271/blog/1936238
版权

2019独角兽企业重金招聘Python工程师标准>>> hot3.png

项目目录：

5fc198f3783a556d1a93683a89734b8eaaf.jpg

首先建立数据库

b50b6e339c90a240bca26f49401bb621c82.jpg

建立实体类：

48ceb05e9c3d4bfdba85be62b005e84847f.jpg

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using LTN.CS.Core;

namespace LTN.CS.SCMEntities.TS
{
    public class TS_JwsCarOwner_Info : BaseEntity
    {
        public int IntId { get; set; }
        public string CarOwnerNo { get; set; }
        public string CarOwnerName { get; set; }
        public string CarOwnerCarNo { get; set; }
        public string CarOwerPhoneNo { get; set; }
        public string DriverName { get; set; }
        public string DriverPhoneNo { get; set; }
        public int YearOld { get; set; }
        public string RegisterFrom { get; set; }
        public string CarCodeInfo { get; set; }
    }
}

xml层配置：
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="TS_Student" xmlns="http://ibatis.apache.org/mapping"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
  <alias>
    <typeAlias alias="TS_JwsCarOwner_Info" type="LTN.CS.SCMEntities.TS.TS_JwsCarOwner_Info,LTN.CS.SCMEntities" />
  </alias>
  <resultMaps>
    <resultMap id="SelectTS_JwsCarOwner_InfoAllResult" class="TS_JwsCarOwner_Info">
      <result property="IntId" column="I_IntId" />
      <result property="CarOwnerNo" column="C_CarOwnerNo" />
      <result property="CarOwnerName" column="C_CarOwnerName" />
      <result property="CarOwnerCarNo" column="C_CarOwnerCarNo" />
      <result property="CarOwerPhoneNo" column="C_CarOwerPhoneNo" />
      <result property="DriverName" column="C_DriverName" />
      <result property="DriverPhoneNo" column="C_DriverPhoneNo" />
      <result property="YearOld" column="I_YearOld" />
      <result property="RegisterFrom" column="C_RegisterFrom" />
      <result property="CarCodeInfo" column="C_CarCodeInfo" />
    </resultMap>
  </resultMaps>
  
  <!--statement配置-->
  <statements>
    <insert id="insertTS_JwsCarOwner_Info"  parameterClass="TS_JwsCarOwner_Info">
      <selectKey property="IntId" type="post" resultClass="int">
        ${selectKey}
      </selectKey>
      INSERT INTO [ACI_SYS].[dbo].[JwsCarOwner_Info]
      (C_CarOwnerNo
      ,C_CarOwnerName
      ,C_CarOwnerCarNo
      ,C_CarOwerPhoneNo
      ,C_DriverName
      ,C_DriverPhoneNo
      ,I_YearOld
      ,C_RegisterFrom
      ,C_CarCodeInfo)
      VALUES
      (#CarOwnerNo#
      ,#CarOwnerName#
      ,#CarOwnerCarNo#
      ,#CarOwerPhoneNo#
      ,#DriverName#
      ,#DriverPhoneNo#
      ,#YearOld#
      ,#RegisterFrom#
      ,#CarCodeInfo#)
    </insert>
    
    <update  id="updateTS_JwsCarOwner_Info" parameterClass="TS_JwsCarOwner_Info" >
      update [ACI_SYS].[dbo].[JwsCarOwner_Info]  set
      C_CarOwnerNo=#CarOwnerNo#,
      C_CarOwnerName=#CarOwnerName#,
      C_CarOwnerCarNo=#CarOwnerCarNo#,
      C_CarOwerPhoneNo=#CarOwerPhoneNo#,
      C_DriverName=#DriverName#,
      C_DriverPhoneNo=#DriverPhoneNo#,
      I_YearOld=#YearOld#,
      C_RegisterFrom=#RegisterFrom#,
      C_CarCodeInfo=#CarCodeInfo#
      where I_IntId=#IntId#
    </update>
    
    <delete  id="deleteTS_JwsCarOwner_Info" parameterClass="TS_JwsCarOwner_Info">
      delete from  [ACI_SYS].[dbo].[JwsCarOwner_Info] where I_IntId=#IntId#
    </delete>

    <select id="selectAllTS_JwsCarOwner_Info"  resultMap="SelectTS_JwsCarOwner_InfoAllResult">
      SELECT TOP 1000 [I_IntId]
      ,[C_CarOwnerNo]
      ,[C_CarOwnerName]
      ,[C_CarOwnerCarNo]
      ,[C_CarOwerPhoneNo]
      ,[C_DriverName]
      ,[C_DriverPhoneNo]
      ,[I_YearOld]
      ,[C_RegisterFrom]
      ,[C_CarCodeInfo]
      FROM [ACI_SYS].[dbo].[JwsCarOwner_Info]
    </select>

    <select id="selectMaxTS_JwsCarOwner_Info"  resultMap="SelectTS_JwsCarOwner_InfoAllResult">
      SELECT top 1 [I_IntId]
      ,[C_CarOwnerNo]
      ,[C_CarOwnerName]
      ,[C_CarOwnerCarNo]
      ,[C_CarOwerPhoneNo]
      ,[C_DriverName]
      ,[C_DriverPhoneNo]
      ,[I_YearOld]
      ,[C_RegisterFrom]
      ,[C_CarCodeInfo]
      FROM [ACI_SYS].[dbo].[JwsCarOwner_Info]
      order by [I_IntId] desc
    </select>
  </statements>
</sqlMap>

建立Dao层和实现层DaoImpl：

833cc9eea74a1f7bf7976939a28030f3f0b.jpg

Dao层：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using LTN.CS.Core.Dao;
using LTN.CS.SCMEntities.TS;

namespace LTN.CS.SCMDao.TS.Interface
{
    public interface ITS_JwsCarOwner_InfoDao : IBaseDao<TS_JwsCarOwner_Info>
    {
        /// <summary>
        /// 查询所有数据
        /// </summary>
        /// <returns></returns>
        IList<TS_JwsCarOwner_Info> ExecuteQueryAllList();

        /// <summary>
        /// 查询最大数据
        /// </summary>
        /// <returns></returns>
        IList<TS_JwsCarOwner_Info> ExecuteQueryMaxList();
    }
}
实现层Dao：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using LTN.CS.Core.Dao;
using LTN.CS.SCMEntities.TS;
using LTN.CS.SCMDao.TS.Interface;

namespace LTN.CS.SCMDao.TS.Implement
{
    public class TS_JwsCarOwner_InfoDaoImpl : BaseDaoImp<TS_JwsCarOwner_Info>, ITS_JwsCarOwner_InfoDao
    {
        public IList<TS_JwsCarOwner_Info> ExecuteQueryAllList()
        {
            return basedao.ExecuteQueryForList<TS_JwsCarOwner_Info>("selectAllTS_JwsCarOwner_Info", null);
        }

        public IList<TS_JwsCarOwner_Info> ExecuteQueryMaxList()
        {
            return basedao.ExecuteQueryForList<TS_JwsCarOwner_Info>("selectMaxTS_JwsCarOwner_Info", null);
        }

        //增删改basedao
        public override object ExecuteInsert(object parameterObject)
        {
            return basedao.ExecuteInsert("insertTS_JwsCarOwner_Info", parameterObject);
        }
        public override object ExecuteUpdate(object parameterObject)
        {
            return basedao.ExecuteUpdate("updateTS_JwsCarOwner_Info", parameterObject);
        }
        public override object ExecuteDelete(object parameterObject)
        {
            return basedao.ExecuteDelete("deleteTS_JwsCarOwner_Info", parameterObject);
        }
    }
}

建立service层：

8f7ec14bfc18ee8b10a65ecc87134b813a3.jpg

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using LTN.CS.SCMEntities.TS;

namespace LTN.CS.SCMService.TS.Interface
{
    public interface ITS_JwsCarOwner_InfoService
    {
         /// <summary>
        /// 查询最大
         /// </summary>
         /// <returns></returns>
        IList<TS_JwsCarOwner_Info> ExecuteDB_QueryMax();

        /// <summary>
        /// 查询所有实体
        /// </summary>
        /// <returns></returns>
        IList<TS_JwsCarOwner_Info> ExecuteDB_QueryAll();

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="leader"></param>
        /// <returns></returns>
        object ExecuteDB_InserSite(TS_JwsCarOwner_Info site);

        /// <summary>
        /// 修改实体
        /// </summary>
        /// <returns></returns>
        object ExecuteDB_UpdateSite(TS_JwsCarOwner_Info site);

        /// <summary>
        /// 删除实体
        /// </summary>
        /// <returns></returns>
        object ExecuteDB_DeleteSite(TS_JwsCarOwner_Info site);


    }
}
实现层：


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using LTN.CS.SCMService.TS.Interface;
using Common.Logging;
using LTN.CS.SCMDao.TS.Interface;
using LTN.CS.Core.Attributes;
using LTN.CS.SCMEntities.TS;
using LTN.CS.Core.Common;

namespace LTN.CS.SCMService.TS.Implement
{
    public class TS_JwsCarOwner_InfoServiceImpl : ITS_JwsCarOwner_InfoService
    {
        /// <summary>
        /// 日志
        /// </summary>
        private readonly ILog log = LogManager.GetLogger("infoAppender");

        public ITS_JwsCarOwner_InfoDao mainDao { set; get; }

        [Services(IsOutTransaction = true)]
        public IList<TS_JwsCarOwner_Info> ExecuteDB_QueryAll()
        {
            IList<TS_JwsCarOwner_Info> rs;
            try
            {
                rs = mainDao.ExecuteQueryAllList();
            }
            catch (Exception ex)
            {
                log.Error(ex.Message);
                rs = null;
            }
            return rs;
        }

        public IList<TS_JwsCarOwner_Info> ExecuteDB_QueryMax()
        {
            IList<TS_JwsCarOwner_Info> rs;
            try
            {
                rs = mainDao.ExecuteQueryMaxList();
            }
            catch (Exception ex)
            {
                log.Error(ex.Message);
                rs = null;
            }
            return rs;
        }

        public object ExecuteDB_InserSite(TS_JwsCarOwner_Info site)
        {
            object rs;
            try
            {
                rs = mainDao.ExecuteInsert(site);
            }
            catch (Exception ex)
            {
                rs = new CustomDBError(ex.Message);
            }
            return rs;
        }

        public object ExecuteDB_UpdateSite(TS_JwsCarOwner_Info site)
        {
            object rs;
            try
            {
                rs = mainDao.ExecuteUpdate(site);
            }
            catch (Exception ex)
            {
                rs = new CustomDBError(ex.Message);
            }
            return rs;
        }

        public object ExecuteDB_DeleteSite(TS_JwsCarOwner_Info site)
        {
            object rs;
            try
            {
                rs = mainDao.ExecuteDelete(site);
            }
            catch (Exception ex)
            {
                rs = new CustomDBError(ex.Message);
            }
            return rs;
        }
    }
}

Dao和service的xml配置：

9204e5ec19ce050de6728b954d7c4ef1fe6.jpg

Dao的xml：
<?xml version="1.0" encoding="utf-8" ?>
<objects xmlns="http://www.springframework.net"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://www.springframework.net http://www.springframework.net/schema/objects/spring-objects-1.3.xsd
          http://www.springframework.net http://www.springframework.net/schema/aop/spring-aop-1.1.xsd
          " default-lazy-init="true">
  <object id="TS_Global_LeaderDao" type="LTN.CS.SCMDao.TS.Implement.TS_Global_LeaderDaoImpl,LTN.CS.SCMDao"  singleton="false" >
    <property  name="basedaoFactory"  ref="BaseSqlMapDaoFactoryForDBOne"></property>
  </object>

  <object id="TS_StudentDao" type="LTN.CS.SCMDao.TS.Implement.TS_StudentDaoImpl,LTN.CS.SCMDao"  singleton="false" >
    <property  name="basedaoFactory"  ref="BaseSqlMapDaoFactoryForDBOne"></property>
  </object>
  
  <object id="TS_JwsCarOwner_InfoDao" type="LTN.CS.SCMDao.TS.Implement.TS_JwsCarOwner_InfoDaoImpl,LTN.CS.SCMDao"  singleton="false" >
    <property  name="basedaoFactory"  ref="BaseSqlMapDaoFactoryForDBOne"></property>
  </object>
</objects>

service的xml：
<?xml version="1.0" encoding="utf-8" ?>
<objects xmlns="http://www.springframework.net"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://www.springframework.net http://www.springframework.net/schema/objects/spring-objects-1.3.xsd
          http://www.springframework.net http://www.springframework.net/schema/aop/spring-aop-1.1.xsd
          "  xmlns:wcf="http://www.springframework.net/wcf"   default-lazy-init="true">
  <object id="TS_Global_LeaderService" type="LTN.CS.SCMService.TS.Implement.TS_Global_LeaderServiceImpl,LTN.CS.SCMService"  singleton="false" >
    <property  name="mainDao"  ref="TS_Global_LeaderDao"></property>
  </object>

  <object id="TS_StudentService" type="LTN.CS.SCMService.TS.Implement.TS_StudentServiceImpl,LTN.CS.SCMService"  singleton="false" >
    <property  name="mainDao"  ref="TS_StudentDao"></property>
  </object>
  
  <object id="TS_JwsCarOwner_InfoService" type="LTN.CS.SCMService.TS.Implement.TS_JwsCarOwner_InfoServiceImpl,LTN.CS.SCMService"  singleton="false" >
    <property  name="mainDao"  ref="TS_JwsCarOwner_InfoDao"></property>
  </object>
</objects>

sql配置：

7440f1e097ba6d0e470f52bd3c25f4e5383.jpg

<?xml version="1.0" encoding="utf-8"?>
<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >

  <!-- 常量属性，通过单独文件properties.config加载-->
  <properties  >
    <property key="selectKey" value="select @@IDENTITY as value"/>
    <property key="useStatementNamespaces" value="false" />
  </properties>
    <settings>
	    <setting useStatementNamespaces="false"/>
	    <setting cacheModelsEnabled="true"/>
	    <setting validateSqlMap="false"/>
    </settings>

    <!-- 数据驱动提供类配置文件的路径和文件名 -->
    <providers resource="providers.config"/>

    <!-- 指定项目内映射的文件的位置-->
    <sqlMaps>
      <sqlMap embedded="Maps.Person.xml,LTN.CS.BaseEntities"  />
      <sqlMap embedded="Maps.BM_GROUP.xml,LTN.CS.BaseEntities"  />
      <sqlMap embedded="Maps.BM_GROUP_USER.xml,LTN.CS.BaseEntities"  />
      <sqlMap embedded="Maps.BM_USER.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.BM_SERVICE.xml,LTN.CS.BaseEntities"/>
      <sqlMap embedded="Maps.BM_SERVICE_USER.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.BM_SERVICE_GROUP.xml,LTN.CS.BaseEntities"  />
      <sqlMap embedded="Maps.BM_MAIN_ASSEMBLY.xml,LTN.CS.BaseEntities"/>
      <sqlMap embedded="Maps.BM_MAIN_PAGE.xml,LTN.CS.BaseEntities"  />
      <sqlMap embedded="Maps.BM_MAIN_GROUP.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.BM_MAIN_GROUP_SERVICE.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.BM_DICTIONARY_MAIN.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.BM_DICTIONARY_DETAIL.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.BM_DELIVERY.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.BM_DELIVERY_HISTORY.xml,LTN.CS.BaseEntities" />
      <sqlMap embedded="Maps.TS_Global_Leader.xml,LTN.CS.SCMEntities" />
      
      <sqlMap embedded="Maps.TS_Student.xml,LTN.CS.SCMEntities" />
      <sqlMap embedded="Maps.TS_JwsCarOwner_Info.xml,LTN.CS.SCMEntities" />
    </sqlMaps>
</sqlMapConfig>

建立窗口并配置窗口文件

619b44143a4cf5b98eda175e59551c870b4.jpg

3eb20e58a56735fd89706a276485d28017d.jpg

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using LTN.CS.Base;
using LTN.CS.SCMService.TS.Interface;
using LTN.CS.SCMEntities.TS;
using LTN.CS.Core.Common;
using LTN.CS.Core.Helper;
using System.Threading;
using DevExpress.XtraEditors.DXErrorProvider;

namespace LTN.CS.SCMForm.TS
{
    public partial class TS_JwsCarOwner_Info_Form : CoreForm
    {
        #region 实例变量
        public ITS_JwsCarOwner_InfoService MainService { get; set; }

        private TS_JwsCarOwner_Info selectMainEntity { get; set; }

        //事件订阅
        private EventHandler eventMainNow;

        private int selectMainId { get; set; }

        private int selectMainRowNum { get; set; }
        #endregion

        #region 构造函数
        public TS_JwsCarOwner_Info_Form()
        {
            InitializeComponent();
        }
        #endregion

        #region 自定义方法
        /// <summary>
        /// 设置主档编辑区赋值
        /// </summary>
        /// <param name="entity"></param>
        private void SetMainEditer(TS_JwsCarOwner_Info entity)
        {
            txt_CarOwnerNo.Text = entity.CarOwnerNo;
            txt_CarOwnerName.Text = entity.CarOwnerName;
            txt_CarOwnerCarNo.Text = entity.CarOwnerCarNo;
            txt_CarOwerPhoneNo.Text = entity.CarOwerPhoneNo;
            txt_DriverName.Text = entity.DriverName;
            txt_DriverPhoneNo.Text = entity.DriverPhoneNo;
            txt_YearOld.Text = entity.YearOld.ToString();
            txt_CarCodeInfo.Text = entity.CarCodeInfo;
            cb_RegisterFrom.Text = entity.RegisterFrom;
        }

        /// <summary>
        /// 清空主档编辑区界面
        /// </summary>
        private void ClearMainEditer()
        {
            txt_CarOwnerNo.Text = "";
            txt_CarOwnerName.Text = "";
            txt_CarOwnerCarNo.Text = "";
            txt_CarOwerPhoneNo.Text = "";
            txt_DriverName.Text = "";
            txt_DriverPhoneNo.Text = "";
            txt_YearOld.Text = "";
            txt_CarCodeInfo.Text = "";
            cb_RegisterFrom.Text = "";
        }

        /// <summary>
        /// 主档按钮状态
        /// </summary>
        private void SetMainButtonEnabled(bool enabled)
        {
            if (enabled)
            {
                btn_Add.Enabled = true;
                btn_update.Enabled = true;
                btn_Confirm.Enabled = false;
                btn_Cancel.Enabled = false;
                btn_delete.Enabled = true;
                btn_refresh.Enabled = true;
                btn_refreshmax.Enabled = true;
            }
            else
            {
                btn_Add.Enabled = false;
                btn_update.Enabled = false;
                btn_Confirm.Enabled = true;
                btn_Cancel.Enabled = true;
                btn_delete.Enabled = false;
                btn_refresh.Enabled = false;
                btn_refreshmax.Enabled = false;
            }
        }

        /// <summary>
        /// 设定编辑区状态
        /// </summary>
        private void SetMainEditerEnabled(bool flag)
        {
            txt_CarOwnerNo.Enabled = flag;
            txt_CarOwnerName.Enabled = flag;
            txt_CarOwnerCarNo.Enabled = flag;
            txt_CarOwerPhoneNo.Enabled = flag;
            txt_DriverName.Enabled = flag;
            txt_DriverPhoneNo.Enabled = flag;
            txt_YearOld.Enabled = flag;
            txt_CarCodeInfo.Enabled = flag;
            cb_RegisterFrom.Enabled = flag;
            if (flag)
            {
                txt_CarOwnerNo.Focus();
            }
        }


        /// <summary>
        /// 自定义新增
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void CustomMainInsert(object sender, EventArgs e)
        {
            try
            {
                ResetSelectMainEntity();
                if (!dxErrorProvider1.HasErrors)
                {
                    var rs = MainService.ExecuteDB_InserSite(selectMainEntity);
                    if (rs is CustomDBError)
                    {
                        MessageDxUtil.ShowError("操作失败：" + ((CustomDBError)rs).ErrorMsg);
                    }
                    else
                    {
                        selectMainId = Convert.ToInt32(rs);
                        SetMainGridData(false);
                        btn_Confirm.Click -= eventMainNow;
                        eventMainNow = null;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageDxUtil.ShowError(ex.Message);
            }
        }

        /// <summary>
        /// 自定义修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void CustomMainUpdate(object sender, EventArgs e)
        {
            try
            {
                ResetSelectMainEntity();
                if (!dxErrorProvider1.HasErrors)
                {
                    var rs = MainService.ExecuteDB_UpdateSite(selectMainEntity);
                    if (rs is CustomDBError)
                    {
                        MessageDxUtil.ShowError("操作失败：" + ((CustomDBError)rs).ErrorMsg);
                    }
                    else
                    {
                        SetMainGridData(false);
                        btn_Confirm.Click -= eventMainNow;
                        eventMainNow = null;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageDxUtil.ShowError(ex.Message);
            }
        }

        /// <summary>
        /// 自定义删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void CustomMainDelete()
        {
            try
            {
                var rs = MainService.ExecuteDB_DeleteSite(selectMainEntity);
                if (rs is CustomDBError)
                {
                    MessageDxUtil.ShowError("操作失败：" + ((CustomDBError)rs).ErrorMsg);
                }
                else
                {
                    SetMainGridData(false);
                }
            }
            catch (Exception ex)
            {
                MessageDxUtil.ShowError(ex.Message);
            }
        }

        /// <summary>
        /// 设定主档Grid数据
        /// </summary>
        /// <param name="isFirst"></param>
        private void SetMainGridData(bool isFirst)
        {
            WaitCallback wc = (o) =>
            {
                Action ac = () =>
                {
                    int selectLeftIdOld = selectMainId;

                    var rss = MainService.ExecuteDB_QueryAll();
                    gcl_main.DataSource = rss;
                    gvw_main.BestFitColumns();
                    if (!isFirst)
                    {
                        selectMainId = selectLeftIdOld;
                        SetMainFocusRow();
                        gvw_main_FocusedRowChanged(null, null);
                    }
                    SetMainEditer(selectMainEntity);
                    SetMainEditerEnabled(false);
                    SetMainButtonEnabled(true);
                };
                Invoke(ac);
            };
            ThreadPool.QueueUserWorkItem(wc);
        }

        /// <summary>
        /// 主档焦点行转换
        /// </summary>
        private void SetMainFocusRow()
        {

            int rowcount = gvw_main.RowCount;
            bool isFocused = false;
            if (selectMainId != 0)
            {
                for (int i = 0; i < rowcount; i++)
                {
                    TS_JwsCarOwner_Info group = gvw_main.GetRow(i) as TS_JwsCarOwner_Info;
                    if (group.IntId == selectMainId)
                    {
                        gvw_main.FocusedRowHandle = i;
                        selectMainRowNum = i;
                        isFocused = true;
                        break;
                    }
                }
            }
            if (selectMainId == 0 || !isFocused)
            {
                if (rowcount - 1 < selectMainId)
                {
                    gvw_main.FocusedRowHandle = rowcount - 1;
                    selectMainId = rowcount - 1;
                }
                else if (selectMainId == 0)
                {
                    gvw_main.FocusedRowHandle = 0;
                    selectMainId = 0;
                }
                else
                {
                    gvw_main.FocusedRowHandle = selectMainId;
                }
            }
        }

        /// <summary>
        /// 给实体类赋值
        /// </summary>
        private void ResetSelectMainEntity()
        {
            dxErrorProvider1.ClearErrors();
            if (eventMainNow.Method.Name == "CustomMainInsert")
            {
                selectMainEntity = new TS_JwsCarOwner_Info();
            }
            if (txt_YearOld.EditValue == null || txt_YearOld.Text == "")
            {
                dxErrorProvider1.SetError(txt_YearOld, "车辆年限不能为空！", ErrorType.Information);
            }
            if (txt_CarOwnerNo.EditValue == null || txt_CarOwnerNo.Text == "")
            {
                dxErrorProvider1.SetError(txt_CarOwnerNo, "身份证号不能为空！", ErrorType.Information);
            }
            if (txt_CarOwnerCarNo.EditValue == null || txt_CarOwnerCarNo.Text == "")
            {
                dxErrorProvider1.SetError(txt_CarOwnerCarNo, "车牌号不能为空！", ErrorType.Information);
            }
            if (txt_CarOwnerName.EditValue == null || txt_CarOwnerName.Text == "")
            {
                dxErrorProvider1.SetError(txt_CarOwnerName, "车主姓名不能为空！", ErrorType.Information);
            }
            selectMainEntity.CarOwnerNo = txt_CarOwnerNo.Text;
            selectMainEntity.CarOwnerName = txt_CarOwnerName.Text;
            selectMainEntity.CarOwnerCarNo = txt_CarOwnerCarNo.Text;
            selectMainEntity.CarOwerPhoneNo = txt_CarOwerPhoneNo.Text;
            selectMainEntity.DriverName = txt_DriverName.Text;
            selectMainEntity.DriverPhoneNo = txt_DriverPhoneNo.Text;
            if (txt_YearOld.EditValue == null || txt_YearOld.Text == "")
            {
                selectMainEntity.YearOld = 0;
            }
            else
            {
                selectMainEntity.YearOld = Convert.ToInt32(txt_YearOld.Text);
            }
            selectMainEntity.RegisterFrom = cb_RegisterFrom.Text;
            selectMainEntity.CarCodeInfo = txt_CarCodeInfo.Text;
        }


        #endregion

        #region 控件方法
        /// <summary>
        /// 加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void TS_JwsCarOwner_Info_Form_Load(object sender, EventArgs e)
        {
            //实例化
            selectMainEntity = new TS_JwsCarOwner_Info();
            SetMainGridData(true);        
        }

        /// <summary>
        /// 焦点改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gvw_main_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
        {
            if (eventMainNow == null)
            {
                if (gvw_main != null && gvw_main.GetFocusedRow() != null)
                {
                    selectMainEntity = gvw_main.GetFocusedRow() as TS_JwsCarOwner_Info;
                    selectMainId = selectMainEntity.IntId;
                    SetMainEditer(selectMainEntity);
                }
            }
        }

        /// <summary>
        /// 刷新按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_refresh_Click(object sender, EventArgs e)
        {
            try
            {
                gcl_main.DataSource = MainService.ExecuteDB_QueryAll();
                selectMainEntity = gvw_main.GetFocusedRow() as TS_JwsCarOwner_Info;
                selectMainId = selectMainEntity.IntId;
                SetMainEditer(selectMainEntity);
            }
            catch (Exception ex)
            {
                MessageDxUtil.ShowError(ex.Message);
            }
        }

        /// <summary>
        /// 删除按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_delete_Click(object sender, EventArgs e)
        {
            var rs = MessageDxUtil.ShowYesNoAndTips("确定删除吗?");
            if (rs == DialogResult.Yes)
            {
                CustomMainDelete();
            }
        }

        /// <summary>
        /// 新增按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Add_Click(object sender, EventArgs e)
        {
            eventMainNow = CustomMainInsert;
            btn_Confirm.Click += eventMainNow;
            ClearMainEditer();
            SetMainEditerEnabled(true);
            SetMainButtonEnabled(false);
        }

        /// <summary>
        /// 修改按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_update_Click(object sender, EventArgs e)
        {
            SetMainEditerEnabled(true);
            SetMainButtonEnabled(false);
            eventMainNow = CustomMainUpdate;
            btn_Confirm.Click += eventMainNow;
        }

        /// <summary>
        /// 取消按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Cancel_Click(object sender, EventArgs e)
        {
            btn_Confirm.Click -= eventMainNow;
            eventMainNow = null;
            dxErrorProvider1.ClearErrors();
            SetMainEditerEnabled(false);
            gvw_main_FocusedRowChanged(null, null);
            SetMainButtonEnabled(true);
        }

        /// <summary>
        /// 查询ID最大按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_refreshmax_Click(object sender, EventArgs e)
        {
            try
            {
                gcl_main.DataSource = MainService.ExecuteDB_QueryMax();
                selectMainEntity = gvw_main.GetFocusedRow() as TS_JwsCarOwner_Info;
                selectMainId = selectMainEntity.IntId;
                SetMainEditer(selectMainEntity);
            }
            catch (Exception ex)
            {
                MessageDxUtil.ShowError(ex.Message);
            }
        }

        /// <summary>
        /// 绘制行号
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gvw_main_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)
        {
            if (e.Info.IsRowIndicator)
            {
                e.Info.DisplayText = Convert.ToString(e.RowHandle + 1);
            }
        }

        #endregion

        private void gToolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }

    }
}
xml配置：
<?xml version="1.0" encoding="utf-8" ?>
<objects xmlns="http://www.springframework.net"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://www.springframework.net http://www.springframework.net/schema/objects/spring-objects-1.3.xsd
          http://www.springframework.net http://www.springframework.net/schema/aop/spring-aop-1.1.xsd
          " default-lazy-init="true">


	<object id="TS_002" type="LTN.CS.SCMForm.TS.TS_Global_Leader_Form,LTN.CS.SCMForm"  singleton="false"  >
    <property  name="leaderService"  ref="TS_Global_LeaderService"></property>
  </object>
  
  <!--id必须要唯一，type=类的全名称，所在的程序集-->
  
  <object id="TS_00001" type="LTN.CS.SCMForm.TS.TS_Test01_Form,LTN.CS.SCMForm"  singleton="false"  >
    <property  name="MainService"  ref="TS_StudentService"></property>
  </object>

  <object id="TS_00002" type="LTN.CS.SCMForm.TS.TS_Day03_Form,LTN.CS.SCMForm"  singleton="false"  >
    <property  name="MainService"  ref="TS_StudentService"></property>
  </object>

  <object id="TS_00003" type="LTN.CS.SCMForm.TS.TS_Yj_Form,LTN.CS.SCMForm"  singleton="false"  >
    <property  name="MainService"  ref="TS_StudentService"></property>
  </object>

  <object id="TS_00004" type="LTN.CS.SCMForm.TS.TS_JwsCarOwner_Info_Form,LTN.CS.SCMForm"  singleton="false"  >
    <property  name="MainService"  ref="TS_JwsCarOwner_InfoService"></property>
  </object>
</objects>

在这里可能要给密码（需要的情况下）

d9a5238ae6aac7d04122a7287fa160b5ee6.jpg

打开此文件

1a9325f466c4192bb3af5a3584af4dabe73.jpg

对以上进行加密解密：（找到AESTool，右键点击调试进行加密解密）

d1ce9f6adfc21535ba7d43978c46ce0dcfc.jpg

8cfaf4625388f2d2adff40c6c80cd899f9c.jpg

7c8cac99d855c833a21513f5428adec38cf.jpg

把此段话粘贴至加密解密的右边区域进行解密：

bc45405ad629ffa583bad5d055777816859.jpg

进行解密：把解密区域的pwd=root替换城你自己的数据库密码，然后进行加密，加密后把加密区域的此段话又重新粘贴到原来复制的地方替换掉。然后进行运行项目。

运行后登陆：

6231958dd1ef22df6ecbe8f625803df3747.jpg

登陆后显示结果图和增删改查操作：

 

转载于:https://my.oschina.net/u/3740271/blog/1936238

weixin_33794672
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
c#增删改查
05-05
在vs软件用c#编写的，能够实现增删改查功能的小示例程序，包括与数据库的连接和页面跳转等功能的实现
Devexpress 11.2 控件使用之 - DxValidationProvider
Hamsic的专栏
08-10 3405
//引用DXErrorProvider命名空间 using DevExpress.XtraEditors.DXErrorProvider; //设置控件的验证规则 //继承ValidationRule类 public class StringEmptyValidation : ValidationRule { public override bool Validate(Control c
Devexpress之dxErrorProvider
afeyfre41671的博客
01-12 291
DXErrorProvider：错误提示控件，用法类似于VS的winform控件中的ErrorProvider。 下面为一个使用实例,验证文本框输入是否为数字: ①.添加System.Text.RegularExpressions引用。 ②.在设计视图上拖一个textEdit控件textEdit1。 ③.验证输入是否为数字，不是显示错误提示。 public bool IsN...
扩展方法实现DevExpress控件校验
weixin_30635053的博客
03-23 182
DevExpress控件中，如果要控件的值进行校验，需要用到DXValidationProvider控件和DXErrorProvider控件，按照正常思路，无论使用哪个控件要实现校验效果时都需要对每个要校验的控件进行校验规则绑定，在这，写一个扩展方法实现一劳永逸的效果。 扩展代码如下： using System; using System.Collections.Generic; ...
C#中的txt文件的增删改查SetValue(key,value)与GetValue(key)
adsd1233123的博客
09-16 1233
目录1.读写txt文档2.实现对txt文档的增删改查3.源代码下载链接 1.读写txt文档 private void Form1_Load(object sender, EventArgs e) { TxtFile.txtName = txb_FileName.Text; TxtFile.SetValue("语文", 89); TxtFile.SetValue("数学", 90.5);
C# 使用自定义类+字典+JSON填充数据，脱离真实数据库，实现简单的增删改查和本地存储与读取数据
阿修罗汉果茶的博客
01-11 2172
本文章适合的情况：①适合数据表少的项目。②适合将数据存储在本地的项目。③适合不想依赖复杂的数据库环境，同时想拥有存储和增删改查数据的功能的项目。④不优雅，不聪明，但是很简单粗暴，可以快速实现.
C#winform实现增删改查
05-26
C#winform实现增删改查
C# SQLite3增删改查Demo
07-14
适合刚入门的小白，对sqlite运行过程有个完整的理解。 Demo中包含的辅助类，非常好用，可以直接copy到自己的项目中，按照Demo中的操作方法直接操作Sqlite
C#增删改查操作Access数据库
11-21
添加：添加四个TextBox控件，在这四个控件中分别输入要添加的ID,学号,姓名,年龄,性别信息，单击Insert按钮将数据添加到Access数据库中并通过datagridview显示添加后的数据库。此外，设置了学号为主键，在添加数据到...
C#增删改查（附数据库要求）
08-12
本人看了很多C#增删改查程序，都不便于用户学习。大家都清楚，也就是代码问题操作嘛，我把增删改查完全简单一体化，便于大家直接复制代码。十分简单
C#三层代码生成器（生成模型层，数据访问层，业务逻辑层）
11-09
可用于生成模型层，数据访问层，业务逻辑层.代码
C#系列之Dictionary
2303_76354097的博客
07-22 172
可以将Dictionary理解为拥有泛型的Hashtable,它也是基于键的哈希代码组织起来的键/值对。键/值对类型从Hashtable的object变为了可以自己制定的泛型。值是可以一致的，但是键不可以。
[DevExpress]DXErrorProvider与DxValidationProvider的使用
德仔
02-19 5262
1. DXErrorProvider：错误提示控件，用法类似于VS的winform控件中的ErrorProvider。下面为一个使用实例,验证文本框输入是否为数字:①.添加System.Text.RegularExpressions引用。②.在设计视图上拖一个textEdit控件textEdit1。③.验证输入是否为数字，不是显示错误提示。?12345678910111213public bool
DevExpress控件使用总结(不断更新中)
计算机视觉算法开发与落地
03-12 1154
数据绑定 class RowDataRecord { public RowDataRecord(int n_id, string xmlpath) { n_id_ = n_id; xmlpath_ = xmlpath; } //!编号 pub...
C#增删查改
weixin_44540247的博客
08-08 2588
C#代码都是做后台数据处理的。它将浏览器与数据库互通形成一个动态数据的平台。而C#对于数据处理方式最多的就是查询、新增、修改、删除。以这四个方面为主做数据的处理。根据实际不同的使用，对这四个方法的使用难度也不一样。 一、 查询 查询方法使用是最多的，在其它三个方法中也会使用。只要是要对数据做处理首先需要查询到数据。 查询的方式有很多种： 1.单表查询 这是一个简单的单表查询，创建一个List表类型的变量接收通过linq语句查询出的数据。linq的查询通过关键字（from 自定义表名 in 数据来源 sel
DevExpress使用小计
chuchaoCocol的博客
07-26 1280
版本：15.1 1、皮肤 添加一个RibbonGalleryBarItem。命名为：rgbiSkins 代码引用：using DevExpress.XtraBars.Helpers; PageLoad事件里添加上一句话就可以：   SkinHelper.InitSkinGallery(rgbiSkins,true); 但是效果和Demo的效果不一样。  在项目的Program文
【转】DXErrorProvider与DxValidationProvider的使用
weixin_34117211的博客
11-12 415
2019独角兽企业重金招聘Python工程师标准>>> ...
C# 数据库标准操作 增删改 接口类写法
weixin_46684628的博客
06-03 395
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data.SqlClient; using System.Data; using System.Configuration;namespace DBUlititly { /// /// 操作SQL Server数据库通...
c# 增删改查excel
最新发布
09-10
“c”字母代表了很多概念和含义。它可以是一个名词、动词或形容词。 首先，“c”字母是英语字母表中的第三个字母，它代表着一个具体的声音，即清辅音音素/k/。在汉语拼音中，它是声母“c”的表示。...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值