public void InsertNT77(string strHardwareID, string strCardNo, string OperName)
{
NT77 nt77 = new NT77();
nt77.HardwareID = strHardwareID;
nt77 = EntityMapping.Get(nt77) as NT77;
if (nt77 == null)
{
nt77 = new NT77();
nt77.HardwareID = strHardwareID;
nt77.CardNo = strCardNo;
nt77.CreateDate = DateTime.Now;
nt77.OperName = OperName;
nt77.bIsUse = true;
EntityMapping.Create(nt77);
}
}
public void UpdateNT77(List <NT77> lnt)
{
try
{
conn = ConnectionPool.BorrowConnection();
trans = conn.BeginTransaction();
foreach (NT77 nt in lnt)
{
NT77 oldnt = EntityMapping.Get(nt, trans) as NT77;
oldnt.bIsUse = nt.bIsUse;
oldnt.OperName = nt.OperName;
EntityMapping.Update(oldnt, trans);
}
trans.Commit();
}
catch (BusinessException bex) //业务异常
{
//LogAdapter.WriteBusinessException(bex);
trans.Rollback();
throw new BusinessException(bex.Type, bex.Message);
}
catch (SqlException sex) //数据库异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteDatabaseException(sex);
throw new BusinessException("数据库异常", sex.Message);
}
catch (Exception ex) //其他异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteFeaturesException(ex);
throw new BusinessException("其它异常", ex.Message);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
private void ultraButton2_Click(object sender, EventArgs e)
{
List <NT77> lnt = new List <NT77>();
//ultraGrid1.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.ExitEditMode);
//ultraGrid1.UpdateData();
foreach (UltraGridRow gr in this.ultraGrid1.Rows)
{
NT77 nt = new NT77();
nt.HardwareID = gr.Cells["HardwareID"].Value.ToString();
nt.CardNo = gr.Cells["CardNo"].Value.ToString();
nt.CreateDate = Convert.ToDateTime(gr.Cells["CreateDate"].Value);
nt.bIsUse = Convert.ToBoolean(gr.Cells["bIsUse"].Value);
nt.OperName = gr.Cells["OperName"].Value.ToString();
lnt.Add(nt);
}
ynhrMemberManage.BusinessFacade.MemberBusiness.SecurityManage sm = new SecurityManage();
sm.UpdateNT77(lnt);
MessageBox.Show("ekey使用信息更新成功", "ekey管理");
}
