项目目录:
首先建立数据库
建立实体类:
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:
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层:
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配置:
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配置:
<?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>
建立窗口并配置窗口文件
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>
在这里可能要给密码(需要的情况下)
打开此文件
对以上进行加密解密:(找到AESTool,右键点击调试进行加密解密)
把此段话粘贴至加密解密的右边区域进行解密:
进行解密:把解密区域的pwd=root替换城你自己的数据库密码,然后进行加密,加密后把加密区域的此段话又重新粘贴到原来复制的地方替换掉。然后进行运行项目。
运行后登陆:
登陆后显示结果图和增删改查操作: