/// <summary>
/// 物理删除
/// </summary>
/// <param name="KeyId">需要删除对象的ID</param>
/// <returns>返回受影响的行数</returns>
public virtual int LogicDelete(string KeyId)
{
int counts = 0;//影响行数标记
ServiceDirectDBEntities objDB;
vUTPCommand vUTPCommandObj;
try
{
objDB = new ServiceDirectDBEntities();
vUTPCommandObj = objDB.vUTPCommand.FirstOrDefault(c => c.RelateID == KeyId);
if (vUTPCommandObj != null)
{
if (vUTPCommandObj.RelateID != null && vUTPCommandObj.RelateID != string.Empty)
{
objDB.DeleteObject(vUTPCommandObj);
counts = objDB.SaveChanges();
}
}
}
catch (EntityException)
{
throw;
}
return(counts);
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="SchedulerObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual Boolean UpdateInTaskView(tblScheduler SchedulerObj)
{
tblScheduler SchedulerObjUpdate;//需要跟新的对象
Boolean flagSuccess = false;
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
SchedulerObjUpdate = ServiceDirectDB.tblScheduler.First(t => t.ScheduleID == SchedulerObj.ScheduleID);
}
catch (EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
//SchedulerObjUpdate.Action = SchedulerObj.Action;
//SchedulerObjUpdate.TraceType = SchedulerObj.TraceType;
//SchedulerObjUpdate.PostAction = SchedulerObj.PostAction;
//SchedulerObjUpdate.ScheduleType = SchedulerObj.ScheduleType;
//SchedulerObjUpdate.StartTime = SchedulerObj.StartTime;
//SchedulerObjUpdate.TaskName = SchedulerObj.TaskName;
//SchedulerObjUpdate.RunOnly = SchedulerObj.RunOnly;
//SchedulerObjUpdate.RunOnlyStart = SchedulerObj.RunOnlyStart;
//SchedulerObjUpdate.RunOnlyEnd = SchedulerObj.RunOnlyEnd;
SchedulerObjUpdate.Trace = SchedulerObj.Trace;
SchedulerObjUpdate.TraceTable = SchedulerObj.TraceTable;
SchedulerObjUpdate.JobID = SchedulerObj.JobID;
//SchedulerObjUpdate.Status = SchedulerObj.Status;
//SchedulerObjUpdate.UTPPwd = SchedulerObj.UTPPwd;
//SchedulerObjUpdate.UTPUser = SchedulerObj.UTPUser;
//SchedulerObjUpdate.Cycle = SchedulerObj.Cycle;
//SchedulerObjUpdate.Calc = SchedulerObj.Calc;
//SchedulerObjUpdate.Company = SchedulerObj.Company;
//SchedulerObjUpdate.Copy = SchedulerObj.Copy;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
flagSuccess = true;
return(flagSuccess);
}
return(flagSuccess);
}
/// <summary>
/// 插入的对象
/// </summary>
/// <param name="SchedulerObj">需要插入的对象</param>
/// <returns>受影响的行数</returns>
public virtual string Insert(tblScheduler SchedulerObj)
{
int counts; //影响行数标记
string strScheduleID; //插入对象的ID
string strErrorMessage = "InsertError";
SchedulerObj.ScheduleID = System.Guid.NewGuid();
//插入数据
try
{
ServiceDirectDBEntitieAdd = new ServiceDirectDBEntities();
ServiceDirectDBEntitieAdd.tblScheduler.AddObject(SchedulerObj);
counts = ServiceDirectDBEntitieAdd.SaveChanges();
}
catch (EntitySqlException)
{
throw;
}
if (counts > 0)
{
strScheduleID = SchedulerObj.ScheduleID.ToString();
return(strScheduleID);
}
return(strErrorMessage);
}
/// <summary>
/// 物理删除
/// </summary>
/// <param name="KeyId">需要删除对象的ID</param>
/// <returns>返回受影响的行数</returns>
public virtual string LogicDelete(string KeyId)
{
int counts = 0;//影响行数标记
string strMessage = "InsertError";
System.Guid KeyIdGuid = new Guid(KeyId); //转换成Guid类型
tblScheduler SchedulerObjDelete; //需要跟新的对象
try
{
ServiceDirectDBEntitiesDelete = new ServiceDirectDBEntities();
SchedulerObjDelete = ServiceDirectDBEntitiesDelete.tblScheduler.First(t => t.ScheduleID == KeyIdGuid);
ServiceDirectDBEntitiesDelete.DeleteObject(SchedulerObjDelete);
counts = ServiceDirectDBEntitiesDelete.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
strMessage = "update success";
return(strMessage);
}
return(strMessage);
}
public void InsertCommand(UTPCommandBuilder builder, string RelateID)
{
ServiceDirectDBEntities objDB;
vUTPCommand vUTPCommandObj;
//影响行数标记
int counts = 0;
//插入数据
try
{
objDB = new ServiceDirectDBEntities();
vUTPCommandObj = new vUTPCommand();
vUTPCommandObj.CommandID = builder.CommandID;
vUTPCommandObj.CommandLine = builder.CommandString;
vUTPCommandObj.RelateID = RelateID;
vUTPCommandObj.Sequence = 1;
objDB.vUTPCommand.AddObject(vUTPCommandObj);
counts = objDB.SaveChanges();
}
catch (EntitySqlException)
{
throw;
}
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="SchedulerObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual string UpdateInTaskDetailForm(tblScheduler SchedulerObj)
{
tblScheduler SchedulerObjUpdate;//需要跟新的对象
string strMessage = "UpdateError";
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
SchedulerObjUpdate = ServiceDirectDB.tblScheduler.First(t => t.ScheduleID == SchedulerObj.ScheduleID);
}
catch (EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
SchedulerObjUpdate.Action = SchedulerObj.Action;
SchedulerObjUpdate.TraceType = SchedulerObj.TraceType;
SchedulerObjUpdate.PostAction = SchedulerObj.PostAction;
SchedulerObjUpdate.ScheduleType = SchedulerObj.ScheduleType;
SchedulerObjUpdate.StartTime = SchedulerObj.StartTime;
SchedulerObjUpdate.TaskName = SchedulerObj.TaskName;
SchedulerObjUpdate.RunOnly = SchedulerObj.RunOnly;
SchedulerObjUpdate.RunOnlyStart = SchedulerObj.RunOnlyStart;
SchedulerObjUpdate.RunOnlyEnd = SchedulerObj.RunOnlyEnd;
SchedulerObjUpdate.BackupID = SchedulerObj.BackupID;
SchedulerObjUpdate.Trace = SchedulerObj.Trace;
SchedulerObjUpdate.TraceTable = SchedulerObj.TraceTable;
//SchedulerObjUpdate.Status = SchedulerObj.Status;
//SchedulerObjUpdate.UTPPwd = SchedulerObj.UTPPwd;
//SchedulerObjUpdate.UTPUser = SchedulerObj.UTPUser;
//SchedulerObjUpdate.Cycle = SchedulerObj.Cycle;
//SchedulerObjUpdate.Calc = SchedulerObj.Calc;
//SchedulerObjUpdate.Company = SchedulerObj.Company;
//SchedulerObjUpdate.Copy = SchedulerObj.Copy;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
strMessage = "Update success";
return(strMessage);
}
return(strMessage);
}
public ObjectQuery<tblGauge> GetGauges2()
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
ObjectQuery<tblGauge> query = objDB.tblGauge.Where("it.IsDeleted=false");
return query;
}
public ObjectQuery<vGauge> GetGauges()
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
ObjectQuery<vGauge> objGauge = objDB.vGauge.Where("it.IsDeleted=false");
return objGauge;
}
public ObjectQuery <tblGauge> GetGauges2()
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
ObjectQuery <tblGauge> query = objDB.tblGauge.Where("it.IsDeleted=false");
return(query);
}
public ObjectQuery <vGauge> GetGauges()
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
ObjectQuery <vGauge> objGauge = objDB.vGauge.Where("it.IsDeleted=false");
return(objGauge);
}
public ObjectQuery<tblManufacturer> FindAll()
{
ObjectQuery<tblManufacturer> query;
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
query = objDB.tblManufacturer.Where("it.IsDeleted=false");
return query;
}
public ObjectQuery <tblManufacturer> FindAll()
{
ObjectQuery <tblManufacturer> query;
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
query = objDB.tblManufacturer.Where("it.IsDeleted=false");
return(query);
}
/// <summary>
/// 根据Company对象的ID查询数据
/// </summary>
/// <param name="KeyId">Company的ID</param>
/// <returns>返回对象</returns>
public virtual vUTPCycle FindFirstCycleByCompanyId(string KeyId, string orderby)
{
vUTPCycle CycleObj;
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
CycleObj = ServiceDirectDB.vUTPCycle.OrderBy(orderby).First(t => t.CompanyID == KeyId);
}
catch (EntityException)
{
throw;
}
return(CycleObj);
}
/// <summary>
/// 根据ScheduleId查询UserName信息
/// </summary>
/// <param name="ScheduleId"></param>
/// <returns></returns>
public vUTPScheduleMessager FindUserNameByScheduleId(string ScheduleId)
{
vUTPScheduleMessager ScheduleLogObj = null;
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
ScheduleLogObj = ServiceDirectDB.vUTPScheduleMessager.FirstOrDefault(t => t.SID == ScheduleId);
}
catch (EntitySqlException)
{
throw;
}
return(ScheduleLogObj);
}
protected void RadButton5_Click1(object sender, EventArgs e)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
tblGauge objGauge = objDB.tblGauge.First <tblGauge>(g => g.GaugeCode == txtGaugeCode.Text);
if (objGauge != null)
{
cboSize.SelectedValue = objGauge.SizeID.ToString();
cboModel.SelectedValue = objGauge.ModelID.ToString();
cboManufacturer.SelectedValue = objGauge.MfrID.ToString();
dtpLastCalibrationDate.SelectedDate = objGauge.LastCalibrationDate;
hfGaugeID.Value = objGauge.GaugeID.ToString();
}
}
/// <summary>
/// 根据条件以及排序规则，获取对象集
/// </summary>
/// <param name="SearchStr">查询条件</param>
/// <param name="orderby">排序规则</param>
/// <returns>符合条件的对象集</returns>
public ObjectQuery <vBackupAndEmailSetting> GetBackupAndEmailSetting(string SearchStr, string orderby)
{
string StrWhere = " it.BackupID is not null " + SearchStr;
ObjectQuery <vBackupAndEmailSetting> query = null;
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
query = ServiceDirectDB.vBackupAndEmailSetting.Top("1").Where(StrWhere).OrderBy(orderby);
}
catch (EntitySqlException)
{
throw;
}
return(query);
}
/// <summary>
/// 根据条件以及排序规则，获取对象集
/// </summary>
/// <param name="SearchStr">查询条件</param>
/// <param name="orderby">排序规则</param>
/// <returns>符合条件的对象集</returns>
public ObjectQuery <tblScheduler> GetSchedulers(string SearchStr, string orderby)
{
string StrWhere = " it.ScheduleID is not null " + SearchStr;
ObjectQuery <tblScheduler> query = null;
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
query = ServiceDirectDB.tblScheduler.Where(StrWhere).OrderBy(orderby);
}
catch (EntitySqlException)
{
throw;
}
return(query);
}
/// <summary>
/// 根据条件以及排序规则，获取对象集
/// </summary>
/// <param name="SearchStr">查询条件</param>
/// <param name="orderby">排序规则</param>
/// <returns>符合条件的对象集</returns>
public ObjectQuery <vOnlySysJobs> GetVOnlyJobs(string SearchStr, string orderby)
{
string StrWhere = " it.job_id is not null " + SearchStr;
ObjectQuery <vOnlySysJobs> query = null;
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
query = ServiceDirectDB.vOnlySysJobs.Where(StrWhere).OrderBy(orderby);
}
catch (EntitySqlException)
{
throw;
}
return(query);
}
/// <summary>
/// 根据条件以及排序规则，获取对象集
/// </summary>
/// <param name="SearchStr">查询条件</param>
/// <param name="orderby">排序规则</param>
/// <returns>符合条件的对象集</returns>
public ObjectQuery <vUTPCycle> GetUTPCycles(string SearchStr, string orderby)
{
string StrWhere = " it.CycleID is not null " + SearchStr;
ObjectQuery <vUTPCycle> query = null;
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
query = ServiceDirectDB.vUTPCycle.Where(StrWhere).OrderBy(orderby);
}
catch (EntitySqlException)
{
throw;
}
return(query);
}
/// <summary>
/// 调用存储过程，创建发送的Email
/// </summary>
/// <param name="EmailID">EmailID</param>
/// <returns></returns>
public int CreateEmail(string EmailID)
{
int counts = 0;
ServiceDirectDBEntities objDB;
try
{
objDB = new ServiceDirectDBEntities();
counts = objDB.PrJobEmail(EmailID);
return(counts);
}
catch (Exception)
{
return(counts);
}
}
public bool Delete(tblManufacturer OldManufacturer)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
objDB.tblManufacturer.DeleteObject(OldManufacturer);
try
{
objDB.SaveChanges();
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 根据对象的ID查询数据
/// </summary>
/// <param name="KeyId">对象ID</param>
/// <returns>返回对象</returns>
public virtual vSchedulerTasks FindvSchedulerTasksById(string jobID)
{
ServiceDirectDBEntities objDB;
vSchedulerTasks vSchedulerTasksObj;
System.Guid KeyIdGuid = new Guid(jobID);
try
{
objDB = new ServiceDirectDBEntities();
vSchedulerTasksObj = objDB.vSchedulerTasks.FirstOrDefault(s => s.JobID == KeyIdGuid);
}
catch (EntityException)
{
return(null);
}
return(vSchedulerTasksObj);
}
/// <summary>
/// 根据对象的ID查询数据
/// </summary>
/// <param name="KeyId">对象ID</param>
/// <returns>返回对象</returns>
public virtual vSchedulerEmailBackup FindvSchedulerEmailBackupById(string KeyId)
{
ServiceDirectDBEntities objDB;
vSchedulerEmailBackup vSchedulerEmailBackupObj;
System.Guid KeyIdGuid = new Guid(KeyId);
try
{
objDB = new ServiceDirectDBEntities();
vSchedulerEmailBackupObj = objDB.vSchedulerEmailBackup.FirstOrDefault(s => s.ScheduleID == KeyIdGuid);
}
catch (EntityException)
{
return(null);
}
return(vSchedulerEmailBackupObj);
}
/// <summary>
/// 查询所有job的结果信息
/// </summary>
/// <param name="SearchStr">查询条件</param>
/// <param name="orderby">倒序排列</param>
/// <returns></returns>
public virtual ObjectQuery <vUTPScheduleMessager> FindJobResult(string SearchStr, string orderby)
{
ObjectQuery <vUTPScheduleMessager> ScheduleLogObjs;
string StrWhere = " it.PID is not null " + SearchStr;
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
ScheduleLogObjs = ServiceDirectDB.vUTPScheduleMessager.Where(StrWhere).OrderBy(orderby);
}
catch (EntitySqlException)
{
throw;
}
return(ScheduleLogObjs);
}
/// <summary>
/// 根据对象的ID查询数据
/// </summary>
/// <param name="KeyId">对象的ID</param>
/// <returns>返回对象</returns>
public virtual tblEmail FindEmailById(string KeyId)
{
tblEmail EmailObj;
System.Guid KeyIdGuid = new Guid(KeyId);
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
EmailObj = ServiceDirectDB.tblEmail.First(t => t.EmailID == KeyIdGuid);
}
catch (EntityException)
{
throw;
}
return(EmailObj);
}
public bool Delete(tblManufacturer OldManufacturer)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
objDB.tblManufacturer.DeleteObject(OldManufacturer);
try
{
objDB.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 根据jobID查询job对象
/// </summary>
/// <param name="jobId">jobId</param>
/// <returns>job对象</returns>
public vOnlySysJobs FindVOnlyJobByJobId(string jobId)
{
vOnlySysJobs VOnlyJobObj = null;
System.Guid KeyIdGuid = new Guid(jobId);
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
VOnlyJobObj = ServiceDirectDB.vOnlySysJobs.FirstOrDefault(t => t.job_id == KeyIdGuid);
}
catch (EntitySqlException)
{
throw;
}
return(VOnlyJobObj);
}
public bool Insert(tblManufacturer NewManufacturer)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
try
{
objDB.tblManufacturer.AddObject(NewManufacturer);
objDB.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 根据对象的ID查询数据
/// </summary>
/// <param name="KeyId">对象的ID</param>
/// <returns>返回对象</returns>
public virtual tblBackup FindBackupById(string KeyId)
{
tblBackup BackupObj;
System.Guid KeyIdGuid = new Guid(KeyId);
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
BackupObj = ServiceDirectDB.tblBackup.FirstOrDefault(t => t.BackupID == KeyIdGuid);
}
catch (EntityException)
{
throw;
}
return(BackupObj);
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="EmailObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual string Update(tblEmail EmailObj)
{
tblEmail EmailObjUpdate;//需要跟新的对象
string strMessage = "InsertError";
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
EmailObjUpdate = ServiceDirectDB.tblEmail.First(t => t.EmailID == EmailObj.EmailID);
}catch (EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
EmailObjUpdate.EmailFrom = EmailObj.EmailFrom;
//EmailObjUpdate.EmailTo = EmailObj.EmailTo;
EmailObjUpdate.EmailPort = EmailObj.EmailPort;
EmailObjUpdate.EmailSSL = EmailObj.EmailSSL;
EmailObjUpdate.SMTPHost = EmailObj.SMTPHost;
EmailObjUpdate.SMTPUsername = EmailObj.SMTPUsername;
EmailObjUpdate.SMTPPassword = EmailObj.SMTPPassword;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
strMessage = "update success";
return(strMessage);
}
return(strMessage);
}
public bool Insert(tblManufacturer NewManufacturer)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
try
{
objDB.tblManufacturer.AddObject(NewManufacturer);
objDB.SaveChanges();
return true;
}
catch
{
return false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
ObjectQuery SizeList = objDB.tblSize.Where("it.IsDeleted=false and it.SizeType='GAUGE'");
ObjectQuery ModelList = objDB.tblModel.Where("it.IsDeleted=false and it.ModelType='GAUGE'");
ObjectQuery MfrList = objDB.tblManufacturer.Where("it.IsDeleted=false and it.MfrType='GAUGE'");
foreach (tblSize objSize in SizeList)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Value = objSize.SizeID.ToString();
item.Text = objSize.Size;
cboSize.Items.Add(item);
}
foreach (tblModel objModel in ModelList)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Value = objModel.ModelID.ToString();
item.Text = objModel.Model;
cboModel.Items.Add(item);
}
foreach (tblManufacturer objManufacturer in MfrList)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Value = objManufacturer.MfrID.ToString();
item.Text = objManufacturer.MfrName;
cboManufacturer.Items.Add(item);
}
dtpLastCalibrationDate.SelectedDate = DateTime.Now.Date;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
ObjectQuery SizeList = objDB.tblSize.Where("it.IsDeleted=false and it.SizeType='GAUGE'");
ObjectQuery ModelList = objDB.tblModel.Where("it.IsDeleted=false and it.ModelType='GAUGE'");
ObjectQuery MfrList = objDB.tblManufacturer.Where("it.IsDeleted=false and it.MfrType='GAUGE'");
foreach (tblSize objSize in SizeList)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Value = objSize.SizeID.ToString();
item.Text = objSize.Size;
cboSize.Items.Add(item);
}
foreach (tblModel objModel in ModelList)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Value = objModel.ModelID.ToString();
item.Text = objModel.Model;
cboModel.Items.Add(item);
}
foreach (tblManufacturer objManufacturer in MfrList)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Value = objManufacturer.MfrID.ToString();
item.Text = objManufacturer.MfrName;
cboManufacturer.Items.Add(item);
}
dtpLastCalibrationDate.SelectedDate = DateTime.Now.Date;
}
}
protected void RadButton3_Click(object sender, EventArgs e)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
tblGauge objGauge;
if (hfGaugeID.Value != string.Empty)
{
objGauge = objDB.tblGauge.First<tblGauge>(g => g.GaugeID == Guid.Parse(hfGaugeID.Value));
}
else
{
objGauge = objDB.tblGauge.CreateObject();
}
if (objGauge.GaugeID==Guid.Empty)
{
objGauge.GaugeID = Guid.NewGuid();
objGauge.GaugeCode = txtGaugeCode.Text;
objGauge.SizeID =Guid.Parse(cboSize.SelectedValue);
objGauge.ModelID = Guid.Parse(cboModel.SelectedValue);
objGauge.MfrID = Guid.Parse(cboManufacturer.SelectedValue);
objGauge.LastCalibrationDate = dtpLastCalibrationDate.SelectedDate;
objGauge.LastModifiedDate = DateTime.Now;
objGauge.CreatedDate = DateTime.Now;
objDB.tblGauge.AddObject(objGauge);
}
else
{
objGauge.GaugeCode = txtGaugeCode.Text;
objGauge.SizeID = Guid.Parse(cboSize.SelectedValue);
objGauge.ModelID = Guid.Parse(cboModel.SelectedValue);
objGauge.MfrID = Guid.Parse(cboManufacturer.SelectedValue);
objGauge.LastCalibrationDate = dtpLastCalibrationDate.SelectedDate;
objGauge.LastModifiedDate = DateTime.Now;
}
objDB.SaveChanges();
}
public bool Update(tblManufacturer NewManufacturer)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
tblManufacturer OldManufacturer = objDB.tblManufacturer.First(c => c.MfrID == NewManufacturer.MfrID);
try
{
OldManufacturer.MfrName = NewManufacturer.MfrName;
OldManufacturer.MfrType = NewManufacturer.MfrType;
objDB.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Update(tblManufacturer NewManufacturer)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
tblManufacturer OldManufacturer= objDB.tblManufacturer.First(c=>c.MfrID==NewManufacturer.MfrID);
try
{
OldManufacturer.MfrName = NewManufacturer.MfrName;
OldManufacturer.MfrType = NewManufacturer.MfrType;
objDB.SaveChanges();
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 物理删除
/// </summary>
/// <param name="KeyId">需要删除对象的ID</param>
/// <returns>返回受影响的行数</returns>
public virtual int LogicDelete(string KeyId)
{
int counts = 0; //影响行数标记
System.Guid KeyIdGuid = new Guid(KeyId); //转换成Guid类型
tblBackup BackupObjDelete; //需要跟新的对象
try
{
ServiceDirectDBEntitiesDelete = new ServiceDirectDBEntities();
BackupObjDelete = ServiceDirectDBEntitiesDelete.tblBackup.First(t => t.BackupID == KeyIdGuid);
ServiceDirectDBEntitiesDelete.DeleteObject(BackupObjDelete);
counts = ServiceDirectDBEntitiesDelete.SaveChanges();
}
catch (EntityException)
{
throw;
}
return(counts);
}
protected void RadButton3_Click(object sender, EventArgs e)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
tblGauge objGauge;
if (hfGaugeID.Value != string.Empty)
{
objGauge = objDB.tblGauge.First <tblGauge>(g => g.GaugeID == Guid.Parse(hfGaugeID.Value));
}
else
{
objGauge = objDB.tblGauge.CreateObject();
}
if (objGauge.GaugeID == Guid.Empty)
{
objGauge.GaugeID = Guid.NewGuid();
objGauge.GaugeCode = txtGaugeCode.Text;
objGauge.SizeID = Guid.Parse(cboSize.SelectedValue);
objGauge.ModelID = Guid.Parse(cboModel.SelectedValue);
objGauge.MfrID = Guid.Parse(cboManufacturer.SelectedValue);
objGauge.LastCalibrationDate = dtpLastCalibrationDate.SelectedDate;
objGauge.LastModifiedDate = DateTime.Now;
objGauge.CreatedDate = DateTime.Now;
objDB.tblGauge.AddObject(objGauge);
}
else
{
objGauge.GaugeCode = txtGaugeCode.Text;
objGauge.SizeID = Guid.Parse(cboSize.SelectedValue);
objGauge.ModelID = Guid.Parse(cboModel.SelectedValue);
objGauge.MfrID = Guid.Parse(cboManufacturer.SelectedValue);
objGauge.LastCalibrationDate = dtpLastCalibrationDate.SelectedDate;
objGauge.LastModifiedDate = DateTime.Now;
}
objDB.SaveChanges();
}
protected void RadButton5_Click1(object sender, EventArgs e)
{
ServiceDirectDBEntities objDB = new ServiceDirectDBEntities();
tblGauge objGauge = objDB.tblGauge.First<tblGauge>(g => g.GaugeCode == txtGaugeCode.Text);
if (objGauge != null)
{
cboSize.SelectedValue = objGauge.SizeID.ToString();
cboModel.SelectedValue = objGauge.ModelID.ToString();
cboManufacturer.SelectedValue = objGauge.MfrID.ToString();
dtpLastCalibrationDate.SelectedDate = objGauge.LastCalibrationDate;
hfGaugeID.Value = objGauge.GaugeID.ToString();
}
}
