//同意签订!! 2015-12-26
protected void btnConfirm_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
{
string id = Functions.ParseStr(ViewState["id"]);
HRContractBLL hrcb = new HRContractBLL(conn);
hrcb.ConfirmHRContract(id);
//copy video from userdata/tempvideos to contract
//hrid.mp4 --> .pdf.mp4
//hrid.wmv --> .pdf.wmv
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow hrc = hrcd.GetAHRContract(id);
string docpath = Functions.CleanDBString(hrc["docpath"]);//pdf fullfilename
string contractdatapath = Functions.GetAppConfigString("ContractFileRootPath", "");
string userdatapath = Functions.GetAppConfigString("UserDataPath", "");
string srcfile = userdatapath + "\\tempvideos\\"+id+".wmv";
string destfile = contractdatapath + "\\"+docpath+".wmv";
File.Copy(srcfile, destfile, true);
File.Delete(srcfile);
GetSuccessMsg("签约成功!\\n合同内容已不可修改!", "list.aspx");
}
}
//拒绝
protected void btnReject_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
{
string id = Functions.ParseStr(ViewState["id"]);
HRContractDAL hrcd = new HRContractDAL(conn);
hrcd.ProcAndLog(id, "", (int)HRContractProcType.PersonReject, (int)HRContractStatus.PersonRejected);
BindData(conn);
}
}
//保存修改
protected void btnSave_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
{
string id = Functions.ParseStr(ViewState["id"]);
HRContractDAL hrcd = new HRContractDAL(conn);
hrcd.ProcAndLog(id, corpadminid, (int)HRContractProcType.AdminEdit, (int)HRContractStatus.Edit);
int status = Functions.ParseInt(ViewState["status"], -1);
if (status == (int)HRContractStatus.Edit)
{
string jsonpath = Functions.ParseStr(ViewState["jsonpath"]);
string contractbase = Functions.GetAppConfigString("ContractFileRootPath", "");
string jsonfile = contractbase + "\\" + jsonpath;
TempletInfoEditor.SaveToJSONFile(jsonfile);
this.EditArea.Visible = false;
this.btnEdit.Visible = true;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
string person_corp_id = PersonSelecter.SelectedCorpPersonID;
string person_id = PersonSelecter.SelectedPersonID;
if (person_corp_id.Equals("") || person_id.Equals("")) {
GetErrMsg("请先选择人员!");
return;
}
string templet_id = TempletSelecter.SelectedTempletID;
if (templet_id.Equals(""))
{
GetErrMsg("请先选择模板!");
return;
}
using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
{
//保存为json文件，
string jsonfile = this.TempletInfoEditor.SaveToJSONFile();
//记录db
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow hrc = hrcd.GetABlankHRContract();
hrc["corp_person_id"] = this.PersonSelecter.SelectedCorpPersonID;
hrc["person_id"] = this.PersonSelecter.SelectedPersonID;
hrc["corp_id"] = this.corpid;
hrc["templet_id"] = this.TempletSelecter.SelectedTempletID;
hrc["docpath"] = "";
hrc["jsonpath"] = jsonfile;
hrc["creatorid"] = this.adminid;
hrc["status"] = HRContractStatus.Starting;
//reclog
string newid = hrcd.Create(hrc);
hrcd.ProcAndLog(newid, adminid, (int)HRContractProcType.AdminEdit, (int)HRContractStatus.Starting);
//redirect
Response.Redirect("list.aspx");
}
}
private void BindData(SqlConnection conn)
{
try
{
string id = Functions.ParseStr(ViewState["id"]);
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow hrc = hrcd.GetAHRContract(id);
if (null == hrc) return;
int status = Functions.CleanDBInt(hrc["status"]);
ViewState["status"] = status;
string jsonpath = Functions.CleanDBString(hrc["jsonpath"]);
ViewState["jsonpath"] = jsonpath;
ContractLog.ContractID = id;
ContractLog.XmlGridFile = "../person/lists.xml";
ContractLog.XmlGridName = "contractlog";
ContractLog.BindGrid();
PDFImageViewer.PDFID = id;
PDFImageViewer.PDFType = "hrc";
PDFImageViewer.PageNo = 1;
PDFImageViewer.From = "p";
}
catch (Exception e) {
Response.Write(e.ToString());
GetErrMsg(e.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string _corpid = "";
string _personid = "";
string from = Functions.ParseStr(Request["from"], "c");//来源:c:corp;p:person
if (from.Equals("c"))
{
CorpAdminBLL.CheckSession(Session, Request, Response);
_corpid = Functions.ParseStr(Session["corp.id"]);
}
else
{
PersonBLL.CheckSession(Session, Request, Response);
_personid = Functions.ParseStr(Session["person.id"]);
}
//request
string hrcontractid = Functions.ParseStr(Request["id"]);
using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
{
HRContractBLL hrcb = new HRContractBLL(conn);
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow hrc = hrcd.GetAHRContract(hrcontractid);
string personid = Functions.CleanDBGuid(hrc["person_id"]);
string corpid = Functions.CleanDBGuid(hrc["corp_id"]);
if (!_corpid.Equals(corpid) && !_personid.Equals(personid))
{
//非本人或者本企业无权利查看该合同
Response.Write("您没有该合同的访问权.");
CloseOrBack("您没有该合同的访问权.");
return;
}
string contractbase = Functions.GetAppConfigString("ContractFileRootPath", "");
#region v1 （v2版本换为HRContractBLL中的GetContractFilePathByID，会增加一次数据库访问，但会让程序漂亮）
//int status = Functions.CleanDBInt(hrc["status"]);
//最终的合同直接读取docpath
string docpath = Functions.CleanDBString(hrc["docpath"]);
string docfile = contractbase + "\\" + docpath+".wmv";
if (File.Exists(docfile))
{
Response.ContentType = "application/octet-stream";
CommonBLL.GetStreamFromFile(docfile, Response);
}
else
{
Response.Write("视频不存在.");
CloseOrBack("视频不存在.");
}
#endregion
}
}
private void BindData(SqlConnection conn)
{
string id = Functions.ParseStr(ViewState["id"]);
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow hrc = hrcd.GetAHRContract(id);
if (null == hrc) return;
int status = Functions.CleanDBInt(hrc["status"]);
ViewState["status"] = status;
string jsonpath = Functions.CleanDBString(hrc["jsonpath"]);
ViewState["jsonpath"] = jsonpath;
PersonInfo.Conn = conn;
PersonInfo.PersonID = Functions.CleanDBGuid(hrc["person_id"]);
ContractLog.ContractID = id;
ContractLog.XmlGridFile = "../corp/lists.xml";
ContractLog.XmlGridName = "contractlog";
ContractLog.BindGrid();
//PDFImageViewer.Conn = conn;
PDFImageViewer.PDFID = id;
PDFImageViewer.PDFType = "hrc";
PDFImageViewer.PageNo = 1;
//PDFImageViewer.BindData();
}
//撤回
protected void btnWithdraw_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
{
string id = Functions.ParseStr(ViewState["id"]);
HRContractDAL hrcd = new HRContractDAL(conn);
hrcd.ProcAndLog(id, corpadminid, (int)HRContractProcType.AdminWithdraw, (int)HRContractStatus.Edit);
BindData(conn);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string _corpid = "";
string _personid = "";
string from = Functions.ParseStr(Request["from"], "c");//来源:c:corp;p:person
string type = Functions.ParseStr(Request["type"], "pdf").ToLower();//pdf/img
if (from.Equals("c"))
{
CorpAdminBLL.CheckSession(Session, Request, Response);
_corpid = Functions.ParseStr(Session["corp.id"]);
}else
{
PersonBLL.CheckSession(Session, Request, Response);
_personid = Functions.ParseStr(Session["person.id"]);
}
//request
string hrcontractid = Functions.ParseStr(Request["id"]);
using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
{
HRContractBLL hrcb = new HRContractBLL(conn);
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow hrc = hrcd.GetAHRContract(hrcontractid);
string personid = Functions.CleanDBGuid(hrc["person_id"]);
string corpid = Functions.CleanDBGuid(hrc["corp_id"]);
if (!_corpid.Equals(corpid) && !_personid.Equals(personid)) {
//非本人或者本企业无权利查看该合同
Response.Write("您没有该合同的访问权.");
CloseOrBack("您没有该合同的访问权.");
return;
}
string contractbase = Functions.GetAppConfigString("ContractFileRootPath", "");
#region v1 （v2版本换为HRContractBLL中的GetContractFilePathByID，会增加一次数据库访问，但会让程序漂亮）
int status = Functions.CleanDBInt(hrc["status"]);
if (status == (int)HRContractStatus.PersonAccepted)
{
//最终的合同直接读取docpath
string docpath = Functions.CleanDBString(hrc["docpath"]);
string docfile = contractbase + "\\" + docpath;
if (!File.Exists(docfile))
{
Response.Write("未发现合同文件.");
CloseOrBack("未发现合同文件.");
return;
}
Response.ContentType = "application/pdf";
CommonBLL.GetStreamFromFile(docfile, Response);
}
else
{
//其他状态的合同根据jsonfile临时生成,之后清除掉
string jsonpath = Functions.CleanDBString(hrc["jsonpath"]);
string jsonfile = contractbase + "\\" + jsonpath;
string outputfile = contractbase + "\\temp\\" + hrcontractid + ".pdf";
if (!File.Exists(jsonfile))
{
Response.Write("未发现数据文件[J].");
CloseOrBack("未发现数据文件[J].");
return;
}
hrcb.CreatePDFInstance(jsonfile, outputfile);
if (!File.Exists(outputfile))
{
Response.Write("未发现合同文件.");
CloseOrBack("未发现合同文件.");
return;
}
Response.ContentType = "application/pdf";
CommonBLL.GetStreamFromFile(outputfile, Response);
File.Delete(outputfile);
}
#endregion
}
}
//确认合同生成；
//生成pdf，记录hrcontract状态，记录日志；
//2015-9-3 记录人员状态为 已签约
public void ConfirmHRContract(string hrcid)
{
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow hrc = hrcd.GetAHRContract(hrcid);
if (null == hrc) return;
string corp_person_id = Functions.CleanDBGuid(hrc["corp_person_id"]);
//生成pdf实例;only jsondata
string jsonpath = Functions.CleanDBString(hrc["jsonpath"]);
string contractbase = Functions.GetAppConfigString("ContractFileRootPath", "");
string jsonfile = contractbase + "\\" + jsonpath;
//在json中插入signtime信息
PDFInstanceData pdfJsonData0 = PDFInstanceData.LoadFromJSONFile(jsonfile);
//PDFInstanceFieldItem fi_signtime = new PDFInstanceFieldItem();
//fi_signtime.FieldKey = "signtime";
//fi_signtime.FeildValue = DateTime.Now.ToShortDateString();
//pdfJsonData0.Items.Add(fi_signtime);
pdfJsonData0.AddItem("signtime", DateTime.Now.ToShortDateString());
pdfJsonData0.SaveToJSONFile(jsonfile);
string datepath = DateTime.Now.ToString("yyyy/MM/dd").Replace('/', '\\').Replace('-','\\') ;
string dir = contractbase + "\\" + datepath;
if (!Directory.Exists(dir)) Directory.CreateDirectory(dir);
string filename = Guid.NewGuid().ToString() + ".pdf";
string newFile = dir + "\\" + filename; //contracts下YYYY/MM/DD/GUID.json命名
//create pdf instance file
this.CreatePDFInstance(jsonfile, newFile);
#region CreatePDFInstance old srcode
////------------------------------------
//PDFInstanceData data = PDFInstanceData.LoadFromJSONFile(jsonfile);
//string corpid = data.CorpID;
//string personid = data.PersonID;
//string templetid = data.TempletID;
//string templetdocpath = data.TempletDocPath;
//string templetbase = Functions.GetAppConfigString("TempletFileRootPath", "");
//string pdfTemplate = templetbase + "\\" + corpid + "\\" + templetdocpath;
//PdfReader pdfReader = new PdfReader(pdfTemplate);
//PdfStamper pdfStamper = null;
//try
//{
// pdfStamper = new PdfStamper(pdfReader, new FileStream(newFile, FileMode.Create));
// //设置字体解决中文问题
// BaseFont font = BaseFont.CreateFont(fontpath+ ",1",/*@"C:\windows\fonts\simsun.ttc,1", */
// BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
// pdfStamper.AcroFields.AddSubstitutionFont(font);
// AcroFields pdfFormFields = pdfStamper.AcroFields;
// // set form pdfFormFields
// // The first worksheet and W-4 form
// for (int x = 0; x < data.Items.Count; x++)
// {
// string fieldName = data.Items[x].FieldKey;
// string fieldValue = data.Items[x].FeildValue;
// pdfFormFields.SetField(fieldName, fieldValue);
// }
// // close the pdf
// pdfStamper.Close();
//}
//catch (Exception e)
//{
// e.ToString();
// pdfStamper.Close();
//}
////--------------------------------------
#endregion
//写hrcontract
//extract infos from json
PDFInstanceData pdfJsonData = PDFInstanceData.LoadFromJSONFile(jsonfile);
foreach (PDFTempletFieldItem fi in this._fieldsInfo.FeildsNeedExtract)
{
string fieldKey = fi.FieldKey;
string fieldValue = pdfJsonData.GetItem(fieldKey).FeildValue;
try
{
hrc[fieldKey] = fieldValue;
}
catch { }
}
//set db docpath
string docpath = datepath + "\\" + filename;
hrc["docpath"] = docpath;
hrcd.Update(hrc);
//写企业人员状态corp_person
//因为此过程由person发起,所以没有admin_id
CorpPersonDAL cpd = new CorpPersonDAL(conn);
cpd.ProcAndLog(corp_person_id, "", (int)CorpPersonProcType.ContractAssgin, (int)CorpPersonStatus.ContractAssigned);
//reclog
hrcd.ProcAndLog(hrcid, "", (int)HRContractProcType.PersonAccept, (int)HRContractStatus.PersonAccepted);
}
//通过id获取Instance实例文件路径,若还没有实例则返回空字符
//return:1:存在的实例文件；0：通过json生成的临时文件(json里含有templetid)。
//若返回0，则需要调用方注意，用完之后删掉！！！否则造成空间浪费
//out参数filename,在调用完之后需检查一下该文件是否存在(可能因为未知原因造成文件不存在,比如在多处开发时,测试数据不一致
public int GetContractFilePathByID(string hrcontractid,out string filename )
{
int res = 0;
string contractbase = Functions.GetAppConfigString("ContractFileRootPath", "");
HRContractDAL hrcd = new HRContractDAL(conn);
DataRow r = hrcd.GetAHRContract(hrcontractid);
string docpath = Functions.CleanDBString(r["docpath"]);
if(docpath.Equals(""))
{
res = 0;
string jsonpath = Functions.CleanDBString(r["jsonpath"]);
string jsonfile = contractbase + "\\" + jsonpath;
filename = contractbase + "\\temp\\" + hrcontractid + ".pdf";
CreatePDFInstance(jsonfile, filename);
}
else
{
res = 1;
filename = contractbase + "\\" + docpath;
}
return res;
}