/// <summary>
/// 创建实体
/// </summary>
/// <param name="saveType"></param>
/// <returns></returns>
public virtual CertificateEntity CreateEntity(SaveType saveType)
{
var entity = new CertificateEntity
{
IsShow = IsShow.HasValue? IsShow.Value:true,
Sequence = Sequence == null ? 1 : Sequence.Value,
FileName = string.IsNullOrWhiteSpace(FileName) ? "" : FileName,
SaveType = saveType
};
if (!string.IsNullOrEmpty(FileName))
{
entity.FileByte = Ioc.Resolve <IFileApplicationService>().Grab(FileName.Substring(FileName.IndexOf("/Files")));
entity.FileName = string.Format("Files/Images/SiteCertificate/copy{0}", Path.GetExtension(FileName));
}
if (saveType == SaveType.Modify)
{
entity.Id = Id.Convert <long>();
if (IsShow != null)
{
entity.SetProperty(it => it.IsShow);
}
if (FileName != null)
{
entity.SetProperty(it => it.FileName);
}
if (Sequence != null)
{
entity.SetProperty(it => it.Sequence);
}
}
return(entity);
}
public void SubmitForm(CertificateEntity certificateEntity, string keyValue, string projectType)
{
List <CertificateEntity> models = GetList();
List <CertificateEntity> modelsT = models.Where(m => m.IdCard == certificateEntity.IdCard && m.Id != keyValue).ToList();
if (modelsT != null && modelsT.Count > 0)
{
List <CertificateEntity> modelsT2 = modelsT.Where(m => m.Number == certificateEntity.Number && m.Id != keyValue).ToList();
if (modelsT2 != null && modelsT2.Count > 0)
{
throw new Exception("相同身份证号下证件编号已存在，请重新输入！");
}
}
//ItemsDetailEntity itemsDetailEntity = itemsDetailEntities.Where(m => m.ItemCode == projectType).FirstOrDefault();
//if (itemsDetailEntity != null && !string.IsNullOrEmpty(itemsDetailEntity.Id))
//{
// certificateEntity.ProjectName = itemsDetailEntity.ItemName;
//}
if (!string.IsNullOrEmpty(keyValue))
{
certificateEntity.Modify(keyValue);
service.Update(certificateEntity);
}
else
{
certificateEntity.Create();
service.Insert(certificateEntity);
}
}
/// <summary>
/// 提交
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Url"></param>
/// <param name="entity"></param>
/// <param name="certificate"></param>
/// <returns></returns>
internal static XElement Post <T>(string Url, T entity, CertificateEntity certificate = null) where T : Base
{
entity.sign = PaySign.AddSign(entity, JsApiConfig.Key);
string formdata = Serializer.SerializerXml.Serializer(entity);
return(Post(Url, formdata, certificate));
}
protected void Page_Load(object sender, EventArgs e)
{
//SelectTemplate_Button.Attributes.Add("onclick", "javascript:alert('gege');");
this.Button1.Attributes.Add("onclick", "javascript: SaveToWeb();");
//if (!Page.IsPostBack)
//{
ToolMethods.InitDropDownDocTemplate(Doc_DropDown); //初始化证书模板DropDown
DeviceDetectID = Convert.ToInt32(Request.QueryString["DeviceDetectID"].ToString());
forfile = DateTime.Now.ToFileTime() + "" + DeviceDetectID + ".doc";
verid = ToolMethods.GetDictionaryIDByCode("CERTIFICATE_VERIFICATION"); //检定证书内部编号ID，
certificate = ToolMethods.ObtainCertificateByDetectID(DeviceDetectID);
cate = BusinessFacadeShanliTech_HLD_Business.DeviceDisp(certificate.StandardDeviceID).DeviceCategoryID;
InitDataArrayByCate();
InitDataStandard();
InitDataBasic();
//}
if (!Page.IsPostBack)
{
Random g = new Random();
string rad = g.Next(10000).ToString();
number = "" + System.DateTime.Now.Year.ToString() + "" + System.DateTime.Now.Month.ToString() + "" + System.DateTime.Now.Day.ToString() + "" + System.DateTime.Now.Hour.ToString() + "" + System.DateTime.Now.Minute.ToString() + "" + System.DateTime.Now.Second.ToString() + "" + System.DateTime.Now.Millisecond.ToString() + "" + rad + "";
//Number.Text = number;
}
}
public ActionResult Search(string name, string IdNumber, string CertificateNumber)
{
CertificateApp certificateApp = new CertificateApp();
List <CertificateEntity> certificateEntitys = new List <CertificateEntity>();
List <CertificateShowEntity> certificateShowEntitys = new List <CertificateShowEntity>();
if (!string.IsNullOrEmpty(name) && !string.IsNullOrEmpty(IdNumber))
{
certificateEntitys = certificateApp.GetForms(name, IdNumber);
}
if (!string.IsNullOrEmpty(CertificateNumber))
{
certificateEntitys = new List <CertificateEntity>();
CertificateEntity certificateEntitT = certificateApp.GetFormByNumber(CertificateNumber);
if (certificateEntitT != null && !string.IsNullOrEmpty(certificateEntitT.Id))
{
certificateEntitys.Add(certificateEntitT);
}
}
if (certificateEntitys != null && certificateEntitys.Count > 0)
{
foreach (CertificateEntity item in certificateEntitys)
{
CertificateShowEntity certificateShowEntity = new CertificateShowEntity();
certificateShowEntity.SortCode = item.SortCode;
certificateShowEntity.FullName = item.FullName;
certificateShowEntity.IdCard = item.IdCard;
certificateShowEntity.ProjectType = item.ProjectType;
certificateShowEntity.ProjectName = item.ProjectName;
certificateShowEntity.Number = item.Number;
if (item.Gender == 0)
{
certificateShowEntity.Gender = "男";
}
if (item.Gender == 1)
{
certificateShowEntity.Gender = "女";
}
if (item.CertificationTime != null)
{
certificateShowEntity.CertificationTime = item.CertificationTime;
}
certificateShowEntitys.Add(certificateShowEntity);
}
}
if (certificateShowEntitys != null && certificateShowEntitys.Count > 0)
{
return(View(certificateShowEntitys));
}
else
{
return(View("NoFind"));
}
}
/// <summary>
/// Creates a new certificate.
/// </summary>
/// <param name="csrBytes">The certificate signing request data.</param>
/// <returns>The certificate issued.</returns>
public async Task <AcmeCertificate> NewCertificate(byte[] csrBytes)
{
var payload = new CertificateEntity
{
Csr = JwsConvert.ToBase64String(csrBytes),
Resource = ResourceTypes.NewCertificate
};
var uri = await this.handler.GetResourceUri(ResourceTypes.NewCertificate);
var result = await this.handler.Post(uri, payload, key);
ThrowIfError(result);
byte[] pem;
using (var buffer = new MemoryStream())
{
pem = buffer.ToArray();
}
var cert = new AcmeCertificate
{
Raw = result.Raw,
Links = result.Links,
Location = result.Location,
ContentType = result.ContentType
};
var currentCert = cert;
while (true)
{
var upLink = currentCert.Links?.Where(l => l.Rel == "up").FirstOrDefault();
if (upLink == null)
{
break;
}
else
{
var issuerResult = await this.handler.Get <AcmeCertificate>(upLink.Uri);
currentCert.Issuer = new AcmeCertificate
{
Raw = issuerResult.Raw,
Links = issuerResult.Links,
Location = issuerResult.Location,
ContentType = issuerResult.ContentType
};
currentCert = currentCert.Issuer;
}
}
return(cert);
}
/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public bool SaveForm(string keyValue, CertificateEntity entity)
{
try
{
return(service.SaveForm(keyValue, entity));
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 提交
/// </summary>
/// <param name="Url"></param>
/// <param name="formdata"></param>
/// <param name="entity"></param>
/// <returns></returns>
internal static XElement Post(string Url, string formdata, CertificateEntity entity = null)
{
HttpWebResponse response = null;
var formDataBytes = formdata == null ? new byte[0] : Encoding.UTF8.GetBytes(formdata);
byte[] result = HttpHelper.SendRequestData(Url, formDataBytes, ref response, entity);
string reslutxml = System.Text.Encoding.UTF8.GetString(result);
XDocument resultDod = XDocument.Parse(reslutxml);
return(resultDod.Element("xml"));
}
public CertificateEntity GetForm(string keyValue)
{
CertificateEntity certificateEntity = service.FindEntity(keyValue);
//ItemsDetailEntity itemsDetailEntity = itemsDetailEntities.Where(m => m.ItemCode == certificateEntity.ProjectType).FirstOrDefault();
//if (itemsDetailEntity != null && !string.IsNullOrEmpty(itemsDetailEntity.Id))
//{
// certificateEntity.ProjectName = itemsDetailEntity.ItemName;
//}
return(certificateEntity);
}
/// <summary>
/// 提交
/// </summary>
/// <param name="Url"></param>
/// <param name="element"></param>
/// <returns></returns>
internal static XElement Post(string Url, XElement element, string WxUrl, CertificateEntity entity = null)
{
string posturl = string.Format("{0}{1}", WxUrl, Url);
var data = element.ToString();
var formDataBytes = data == null ? new byte[0] : Encoding.UTF8.GetBytes(data);
HttpWebResponse response = null;
byte[] result = HttpHelper.SendRequestData(posturl, formDataBytes, ref response, entity);
string reslutxml = System.Text.Encoding.UTF8.GetString(result);
XDocument resultDod = XDocument.Parse(reslutxml);
return(resultDod.Element("xml"));
}
/// <summary>
/// Find certificate with given parameters.
/// </summary>
/// <param name="entity">Certificate entity.</param>
/// <param name="type">Certificate type.</param>
/// <param name="systemtitle">System title.</param>
/// <returns></returns>
public GXDLMSCertificateInfo Find(CertificateEntity entity, CertificateType type, byte[] systemtitle)
{
string subject = GXAsn1Converter.SystemTitleToSubject(systemtitle);
foreach (GXDLMSCertificateInfo it in this)
{
if ((it.Entity == CertificateEntity.Server && entity == CertificateEntity.Server) ||
(it.Entity == CertificateEntity.Client && entity == CertificateEntity.Client) &&
it.Subject == subject)
{
return(it);
}
}
return(null);
}
public void AddForm(CertificateEntity certificateEntity)
{
List <CertificateEntity> models = GetList();
List <CertificateEntity> modelsT = models.Where(m => m.IdCard == certificateEntity.IdCard).ToList();
if (modelsT != null && modelsT.Count > 0)
{
List <CertificateEntity> modelsT2 = modelsT.Where(m => m.Number == certificateEntity.Number).ToList();
if (modelsT2 != null && modelsT2.Count > 0)
{
return;
}
}
certificateEntity.Create();
service.Insert(certificateEntity);
}
/// <summary>
///获取单条证书信息
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public object GetCertInfo([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string id = dy.data.id;
string path = itemBll.GetItemValue("imgUrl");
FileInfoBLL fileInfoBLL = new FileInfoBLL();
CertificateEntity cert = certificatebll.GetEntity(id);
return(new
{
code = 0,
info = "获取数据成功",
data = new
{
cert.Id,
cert.CertNum,
cert.CertName,
cert.CertType,
cert.WorkType,
cert.WorkItem,
SendDate = cert.SendDate.Value.ToString("yyyy-MM-dd"),
StartDate = cert.StartDate == null ? "" : cert.StartDate.Value.ToString("yyyy-MM-dd"),
cert.UserId,
cert.Grade,
cert.ZGName,
cert.Craft,
cert.Industry,
cert.UserType,
cert.Years,
cert.SendOrgan,
EndDate = cert.EndDate == null ? "" : cert.EndDate.Value.ToString("yyyy-MM-dd"),
ApplyDate = cert.ApplyDate == null ? "" : cert.ApplyDate.Value.ToString("yyyy-MM-dd"),
files = fileInfoBLL.GetFileList(id).Select(f => new { id = f.FileId, url = path + f.FilePath.Replace("~", "") })
}
});
}
catch (Exception ex)
{
return(new { code = 1, info = ex.Message });
}
}
public CertificateEntity GetFormByIdCard(string idCard)
{
CertificateEntity certificateEntity = service.IQueryable(m => m.DeleteMark != true &&
m.IdCard == idCard).OrderBy(t => t.CreatorTime).FirstOrDefault();
if (certificateEntity == null)
{
certificateEntity = new CertificateEntity();
}
//else
//{
// ItemsDetailEntity itemsDetailEntity = itemsDetailEntities.Where(m => m.ItemCode == certificateEntity.ProjectType).FirstOrDefault();
// if (itemsDetailEntity != null && !string.IsNullOrEmpty(itemsDetailEntity.Id))
// {
// certificateEntity.ProjectName = itemsDetailEntity.ItemName;
// }
//}
return(certificateEntity);
}
public DataTable CerticateSave(string pWorkingTag, CertificateEntity entity, string pLoginId)
{
DataTable dtData = new DataTable();
string spName = "PKHR_HRCertificate.sp_Certificate_Save";
OracleParameter[] param = new OracleParameter[9];
param[0] = new OracleParameter("pWorkingTag", pWorkingTag);
param[1] = new OracleParameter("pEmpId", entity.PSysempid);
param[2] = new OracleParameter("pCER_KIND", entity.PCerKind);
param[3] = new OracleParameter("pCER_ITEM", entity.PCerItem);
param[4] = new OracleParameter("pCER_LEVEL", obj: entity.PCerLevel ?? "");
param[5] = new OracleParameter("pCER_DATE", entity.PCerDate ?? "");
param[6] = new OracleParameter("pREMARK", entity.PRemark ?? "");
param[7] = new OracleParameter("pLogin", pLoginId);
param[8] = new OracleParameter("T_TABLE", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
dtData = DBHelper.getDataTable_SP(spName, param);
return(dtData);
}
public void AddForms(List <CertificateImportEntity> mdoels)
{
if (mdoels != null && mdoels.Count > 0)
{
foreach (CertificateImportEntity item in mdoels)
{
if (item.IsQualified == true)
{
CertificateEntity certificateEntity = new CertificateEntity();
certificateEntity.SortCode = item.SortCode;
certificateEntity.FullName = item.FullName;
certificateEntity.Gender = item.Gender;
certificateEntity.IdCard = item.IdCard;
certificateEntity.ProjectType = item.ProjectType;
certificateEntity.ProjectName = item.ProjectName;
certificateEntity.Number = item.Number;
certificateEntity.CertificationTime = item.CertificationTime;
AddForm(certificateEntity);
}
}
}
}
/// <summary>
/// Removes X.509 v3 certificate from the server using entity.
/// </summary>
/// <param name="client">DLMS client that is used to generate action.</param>
/// <param name="entity">Certificate entity type.</param>
/// <param name="type">Certificate type.</param>
/// <param name="systemTitle">System title.</param>
/// <returns>Generated action.</returns>
public byte[][] RemoveCertificateByEntity(GXDLMSClient client, CertificateEntity entity, CertificateType type, byte[] systemTitle)
{
GXByteBuffer bb = new GXByteBuffer();
bb.SetUInt8(DataType.Structure);
bb.SetUInt8(2);
//Add enum
bb.SetUInt8(DataType.Enum);
bb.SetUInt8(0);
//Add certificate_identification_by_entity
bb.SetUInt8(DataType.Structure);
bb.SetUInt8(3);
//Add certificate_entity
bb.SetUInt8(DataType.Enum);
bb.SetUInt8(entity);
//Add certificate_type
bb.SetUInt8(DataType.Enum);
bb.SetUInt8(type);
//system_title
GXCommon.SetData(client.Settings, bb, DataType.OctetString, systemTitle);
return(client.Method(this, 8, bb.Array(), DataType.Structure));
}
public virtual ActionResult Remove(string[] id)
{
var result = new Dictionary <string, object>();
var rev = false;
if (id != null)
{
var infos = new List <CertificateEntity>();
foreach (var i in id)
{
var info = new CertificateEntity
{
Id = i.Convert <long>(),
SaveType = SaveType.Remove
};
infos.Add(info);
}
rev = this.SaveEntities(infos);
}
result.Add("Status", rev);
return(this.Jsonp(result));
}
/// <summary>
/// Find certificate using entity information.
/// </summary>
/// <param name="settings"> DLMS Settings.</param>
/// <param name="entity">Certificate entity type.</param>
/// <param name="type">Certificate type.</param>
/// <param name="systemtitle">System title.</param>
/// <returns></returns>
private static GXx509Certificate FindCertificateByEntity(GXDLMSSettings settings, CertificateEntity entity, CertificateType type, byte[] systemtitle)
{
String subject = SystemTitleToSubject(systemtitle);
KeyUsage k = CertificateTypeToKeyUsage(type);
foreach (GXx509Certificate it in settings.Cipher.Certificates)
{
if ((it.KeyUsage & k) != 0 && it.Subject == subject)
{
return(it);
}
}
return(null);
}
/// <summary>
/// 新增类型
/// </summary>
/// <param name="entity"></param>
public bool addCertificate(CertificateEntity entity)
{
return(bll.addCertificate(entity));
}
public ActionResult SubmitForm(CertificateEntity certificateEntity, string keyValue, string projectType)
{
certificateApp.SubmitForm(certificateEntity, keyValue, projectType);
return(Success("操作成功。"));
}
/// <summary>
/// Removes X.509 v3 certificate from the server using entity.
/// </summary>
/// <param name="client">DLMS client that is used to generate action.</param>
/// <param name="entity">Certificate entity type.</param>
/// <param name="type">Certificate type.</param>
/// <param name="systemTitle">System title.</param>
/// <returns>Generated action.</returns>
public byte[][] RemoveCertificateByEntity(GXDLMSClient client, CertificateEntity entity, CertificateType type, byte[] systemTitle)
{
GXByteBuffer bb = new GXByteBuffer();
bb.SetUInt8(DataType.Structure);
bb.SetUInt8(2);
//Add enum
bb.SetUInt8(DataType.Enum);
bb.SetUInt8(0);
//Add certificate_identification_by_entity
bb.SetUInt8(DataType.Structure);
bb.SetUInt8(3);
//Add certificate_entity
bb.SetUInt8(DataType.Enum);
bb.SetUInt8(entity);
//Add certificate_type
bb.SetUInt8(DataType.Enum);
bb.SetUInt8(type);
//system_title
GXCommon.SetData(client.Settings, bb, DataType.OctetString, systemTitle);
return client.Method(this, 8, bb.Array(), DataType.OctetString);
}
/// <summary>
/// 新增或修改人员证书
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public object SaveUserCert()
{
try
{
string res = HttpContext.Current.Request["json"];
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string id = "";
//var keys = HttpContext.Current.Request.Form.AllKeys;
//Hashtable ht = new Hashtable();
//foreach(string key in keys)
//{
// ht.Add(key, HttpContext.Current.Request.Form[key]);
//}
var content = Newtonsoft.Json.JsonConvert.SerializeObject(dy.data);
CertificateEntity cert = Newtonsoft.Json.JsonConvert.DeserializeObject <CertificateEntity>(content);
if (string.IsNullOrWhiteSpace(cert.Id))
{
id = Guid.NewGuid().ToString();
}
else
{
id = cert.Id;
}
string path = itemBll.GetItemValue("imgPath");
string remark = "";
if (!string.IsNullOrWhiteSpace(cert.Remark))
{
remark = cert.Remark;
cert.Remark = "";
}
bool result = certificatebll.SaveForm(id, cert);
FileInfoBLL fileInfoBLL = new FileInfoBLL();
if (result)
{
HttpFileCollection files = HttpContext.Current.Request.Files;
for (int i = 0; i < files.AllKeys.Length; i++)
{
HttpPostedFile file = files[i];
//获取文件完整文件名(包含绝对路径)
//文件存放路径格式：/Resource/ResourceFile/{userId}{data}/{guid}.{后缀名}
string fileGuid = Guid.NewGuid().ToString();
long filesize = file.ContentLength;
string FileEextension = Path.GetExtension(file.FileName);
string uploadDate = DateTime.Now.ToString("yyyyMMdd");
string virtualPath = string.Format("~/Resource/cert/{0}/{1}{2}", uploadDate, fileGuid, FileEextension);
string virtualPath1 = string.Format("\\Resource\\cert\\{0}\\{1}{2}", uploadDate, fileGuid, FileEextension);
string fullFileName = path + virtualPath1;
//创建文件夹
string path1 = Path.GetDirectoryName(fullFileName);
Directory.CreateDirectory(path1);
FileInfoEntity fileInfoEntity = new FileInfoEntity();
if (!System.IO.File.Exists(fullFileName))
{
//保存文件
file.SaveAs(fullFileName);
}
//文件信息写入数据库
fileInfoEntity.FileId = fileGuid;
fileInfoEntity.RecId = id; //关联ID
fileInfoEntity.FolderId = "cert";
fileInfoEntity.FileName = file.FileName;
fileInfoEntity.FilePath = virtualPath;
fileInfoEntity.FileSize = filesize.ToString();
fileInfoEntity.FileExtensions = FileEextension;
fileInfoEntity.FileType = FileEextension.Replace(".", "");
fileInfoBLL.SaveForm("", fileInfoEntity);
}
if (!string.IsNullOrWhiteSpace(remark))
{
deptBll.ExecuteSql(string.Format("delete from base_fileinfo where recid='{0}' and fileid in('{1}')", id, remark.Replace(",", "','")));
}
return(new { code = 0, info = "操作成功", data = cert });
}
else
{
return(new { code = 1, info = "操作失败" });
}
}
catch (Exception ex)
{
return(new { code = 1, info = ex.Message });
}
}
/// <summary>
/// 新增修改类别
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult SaveForm(CertificateEntity entity)
{
bll.addCertificate(entity);
return(Success("操作成功。"));
}
