/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string strRowID = hfFormID.Text;
Model.Base_Certificate certificate = new Model.Base_Certificate
{
CertificateCode = this.txtCertificateCode.Text.Trim(),
CertificateName = this.txtCertificateName.Text.Trim(),
Remark = txtRemark.Text.Trim()
};
if (string.IsNullOrEmpty(strRowID))
{
certificate.CertificateId = SQLHelper.GetNewID(typeof(Model.Base_Certificate));
BLL.CertificateService.AddCertificate(certificate);
BLL.LogService.AddSys_Log(this.CurrUser, certificate.CertificateCode, certificate.CertificateId, BLL.Const.CertificateMenuId, BLL.Const.BtnAdd);
}
else
{
certificate.CertificateId = strRowID;
BLL.CertificateService.UpdateCertificate(certificate);
BLL.LogService.AddSys_Log(this.CurrUser, certificate.CertificateCode, certificate.CertificateId, BLL.Const.CertificateMenuId, BLL.Const.BtnModify);
}
this.SimpleForm1.Reset();
// 重新绑定表格，并点击当前编辑或者新增的行
BindGrid();
PageContext.RegisterStartupScript(String.Format("F('{0}').selectRow('{1}');", Grid1.ClientID, certificate.CertificateId));
}
/// <summary>
/// 根据主键删除特岗证书
/// </summary>
/// <param name="certificateId"></param>
public static void DeleteCertificateById(string certificateId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Base_Certificate certificate = db.Base_Certificate.FirstOrDefault(e => e.CertificateId == certificateId);
if (certificate != null)
{
db.Base_Certificate.DeleteOnSubmit(certificate);
db.SubmitChanges();
}
}
/// <summary>
/// 修改特岗证书
/// </summary>
/// <param name="certificate"></param>
public static void UpdateCertificate(Model.Base_Certificate certificate)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Base_Certificate newCertificate = db.Base_Certificate.FirstOrDefault(e => e.CertificateId == certificate.CertificateId);
if (newCertificate != null)
{
newCertificate.CertificateCode = certificate.CertificateCode;
newCertificate.CertificateName = certificate.CertificateName;
newCertificate.Remark = certificate.Remark;
db.SubmitChanges();
}
}
/// <summary>
/// 添加特岗证书
/// </summary>
/// <param name="certificate"></param>
public static void AddCertificate(Model.Base_Certificate certificate)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Base_Certificate newCertificate = new Model.Base_Certificate
{
CertificateId = certificate.CertificateId,
CertificateCode = certificate.CertificateCode,
CertificateName = certificate.CertificateName,
Remark = certificate.Remark
};
db.Base_Certificate.InsertOnSubmit(newCertificate);
db.SubmitChanges();
}
