private void LockDB_gridView_RowDeleted(object sender, DevExpress.Data.RowDeletedEventArgs e)
{
LockDBCompany delete = e.Row.CastTo <LockDBCompany>();
if (delete.Status == ModifyMode.Insert)
{
return;
}
delete.Status = ModifyMode.Delete;
this.LockDBCompanyDelete.Add(delete);
}
public bool DeleteLockDB(LockDBCompany data)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@ClockDBID", data.ClockDBID),
new SqlParameter("@CompanyID", data.CompanyID),
new SqlParameter("@CreateUser", UserInfo.UserID),
new SqlParameter("@IsDelete", data.IsDelete)
};
this.Context.ExecuteDataFromProcedure("LockDBCompanyDelete", sqlParameters);
return(true);
}
private void LockDB_gridView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
bool isNewRow = this.LockDB_gridView.IsNewItemRow(e.RowHandle);
if (isNewRow)
{
return;
}
LockDBCompany row = e.Row as LockDBCompany;
if (row.Status == ModifyMode.Insert)
{
return;
}
row.Status = ModifyMode.Update;
}
public bool UpdateLockDB(LockDBCompany data)
{
try
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@ClockDBID", data.ClockDBID),
new SqlParameter("@CompanyID", data.CompanyID),
new SqlParameter("@ClockDBDate", data.ClockDBDate),
new SqlParameter("@ClockDBNote", data.ClockDBNote),
new SqlParameter("@ClockStatus", data.ClockStatus),
new SqlParameter("@CreateUser", UserInfo.UserID)
};
this.Context.ExecuteDataFromProcedure("LockDBCompanyUpdate", sqlParameters);
return(true);
}
catch (Exception ex)
{
Console.Write(ex.ToString());
return(false);
}
}
public bool DeleteLockDB(LockDBCompany lockDB)
{
return(this.LockDBCompanyDAO.DeleteLockDB(lockDB));
}
public bool UpdateLockDB(LockDBCompany lockDB)
{
return(this.LockDBCompanyDAO.UpdateLockDB(lockDB));
}
public bool InsertLockDB(LockDBCompany lockDB)
{
return(this.LockDBCompanyDAO.InsertLockDB(lockDB));
}
