public void DisconnectAll()
{
A01.Stop();
A01.Disconnect();
A02.Stop();
A02.Disconnect();
}
public void ConnectAll()
{
if (A01.Connect("192.168.10.121:502", 1000))
{
A01.Start(1000);
}
if (A02.Connect("192.168.10.111:502", 1000))
{
A02.Start(1000);
}
}
/// <summary>
/// 修改该人员的考勤记录为1的
/// </summary>
/// <param name="PersonID"></param>
/// <returns></returns>
private bool UpdateA02LastRow(string PersonID)
{
A02 a = new A02();
a.IsLastRow = 0;
var data = GetByPersonID(PersonID);
if (data != null && data.Where(o => o.IsLastRow == 1).Count() > 0)
{
return(base.Modify(a, o => o.PersonID == PersonID && o.IsLastRow == 1, "IsLastRow") > 0);
}
else
{
return(true);
}
}
/// <summary>
/// 打卡上报
/// </summary>
/// <param name="PersonID"></param>
/// <param name="checkDate"></param>
/// <param name="checkTip"></param>
public void UpCheck(string PersonID, string checkDate, string checkTip, string RowID)
{
View_A02 item = new View_A02BLL().Select(o => o.RowID == RowID).FirstOrDefault();
string UnitID = item.UnitID;
B01 Unit = new B01BLL().Select(o => o.UnitID == UnitID).FirstOrDefault();
string realUnitID = string.IsNullOrEmpty(Unit.upLoadId) ? Unit.UnitID : Unit.UnitID;
string param = "<?xml version=\"1.0\" encoding=\"GBK\"?><p>";
param += "<d k=\"vds\">";
param += " <r ";
param += " kqid=\"" + RowID + "\"";
param += " ryid=\"" + item.PersonID + "\"";
param += " xxly=\"" + xxly + "\"";
param += " xmbh=\"" + realUnitID + "\"";
param += " sfzh=\"" + item.A0177 + "\"";
param += " xm=\"" + item.A0101 + "\"";
param += " kqsj=\"" + HCQ2_Common.DateHelper.GetCSTDate(checkDate) + "\"";
param += " sbbs=\"" + (item.A0203 == "1" ? 1 : 2) + "\"";
param += " kqtz=\"9\"";
param += " kqsbbm=\"\"";
param += " />";
param += "</d>";
param += "</p>";
WebUpData.uddi client2 = new WebUpData.uddi();
ServicePointManager.ServerCertificateValidationCallback = ValidateServerCertificate;
client2.Url = "https://222.85.128.67:8088/dwlesbserver/services/uddi?wsdl";
X509Certificate xs = new X509Certificate("E:\\RSA2008root.cer");
client2.ClientCertificates.Add(xs);
//基本信息上报字符串
string serviceName = "HSMWService";
string methodName = "UploadProAttendInfo";
string mess = client2.invokeService(serviceName, methodName, param);
if (mess.Contains("调用服务成功"))
{
//修改记录状态
A02 att = new A02();
att.if_upattend = "1";
string updateRowID = item.RowID;
base.Modify(att, o => o.RowID == updateRowID, "if_upattend");
}
}
private void hideEverything()
{
A00.Hide();
A01.Hide();
A02.Hide();
A10.Hide();
A11.Hide();
A12.Hide();
A20.Hide();
A21.Hide();
A22.Hide();
lbl_actualPlayer.Hide();
lbl_draw.Hide();
lbl_X.Hide();
lbl_Y.Hide();
bttn_changeName.Hide();
bttn_newGame.Hide();
bttn_reset.Hide();
bttn_close.Hide();
}
/// <summary>
/// 添加、编辑考勤时间
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool OperAttendance(object obj)
{
FormCollection param = (FormCollection)obj;
A01BLL aBll = new A01BLL();
A02 a = new A02();
a.A0201 = Convert.ToDateTime(param["A0201"]);
bool returnBool = false;
if (!string.IsNullOrEmpty(param["AttendanceIsEdit"]))
{
string RowID = param["AttendanceIsEdit"];
returnBool = base.Modify(a, o => o.RowID == RowID, "A0201") > 0;
}
else
{
string RowID = param["AttendanceRowID"];
a.PersonID = aBll.GetByRowID(RowID).PersonID;
if (UpdateA02LastRow(a.PersonID))
{
a.RowID = HCQ2_Common.RowIDHelp.GetNewRowID();
a.IsLastRow = 1; var data = GetA02Info();
if (data.Count() > 0)
{
a.DispOrder = data.Count() + 1;
}
else
{
a.DispOrder = 1;
}
returnBool = base.Add(a) > 0;
}
else
{
returnBool = false;
}
}
return(returnBool);
}
/// <summary>
/// 上报异常考勤
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool UpLoadExcptionAttend(object obj)
{
List <string> strXmlList = new List <string>();
FormCollection param = (FormCollection)obj;
JArray comJson = JArray.Parse(param["rows"]);
List <View_A02> viewList = new List <View_A02>();
StringBuilder sbSql = new StringBuilder();
//收集上报的项目的ID
string strRowID = "";
foreach (JObject item in comJson)
{
View_A02 at = new View_A02();
at.RowID = item["RowID"].ToString();
viewList.Add(at);
if (string.IsNullOrEmpty(strRowID))
{
strRowID = "'" + item["RowID"].ToString() + "'";
}
else
{
strRowID += ",'" + item["RowID"].ToString() + "'";
}
}
//需要上报的数据
List <View_A02> attList = DBSession.IView_A02DAL.GetAttendsByRowID(strRowID);
string xmlParam = "<?xml version=\"1.0\" encoding=\"GBK\"?><p>";
xmlParam += "<d k=\"vds\">";
xmlParam += UploadAttends(attList);
xmlParam += "</d>";
xmlParam += "</p>";
string serviceName = "HSMWService";
string methodName = "UploadProAttendInfo";
//正式地址
WebUpData.uddi client2 = new WebUpData.uddi();
ServicePointManager.ServerCertificateValidationCallback = ValidateServerCertificate;
client2.Url = "https://222.85.128.67:8088/dwlesbserver/services/uddi?wsdl";
X509Certificate xs = new X509Certificate("E:\\RSA2008root.cer");
client2.ClientCertificates.Add(xs);
string mess = client2.invokeService(serviceName, methodName, xmlParam);
if (mess.Contains("服务调用成功"))
{
foreach (var item in viewList)
{
string upRowID = item.RowID;
A02 view = new A02();
view.if_upattend = "1";
new A02BLL().Modify(view, o => o.RowID == upRowID, "if_upattend");
}
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// API接口考勤签到
/// </summary>
/// <param name="model"></param>
/// <param name="RowID"></param>
/// <returns></returns>
public bool ApiCheckPerson(HCQ2_Model.WebApiModel.ParamModel.CheckWorkModel model, ref string RowID)
{
A02 personCheck = new A02();
//本次打卡记录
personCheck.PersonID = model.personid;
personCheck.A0201 = System.Convert.ToDateTime(model.signtime);
RowID = HCQ2_Common.RowIDHelp.GetNewRowID();
personCheck.RowID = RowID;
personCheck.IsLastRow = 1;
personCheck.if_upattend = "0";
var dispOrder = base.Select(o => o.PersonID == model.personid);
personCheck.DispOrder = dispOrder.Count > 0 ? dispOrder.Max(o => o.DispOrder) + 1 : 1;
personCheck.A0202 = model.type;
//判断是上班还是下班
DateTime dt = System.Convert.ToDateTime(model.signtime);
StringBuilder sbSql = new StringBuilder();
sbSql.AppendFormat(" select * from A02 where YEAR(A0201)={0} and MONTH(A0201)={1} ", dt.Year, dt.Month);
sbSql.AppendFormat(" and DAY(A0201)={0} and PersonID='{1}' ", dt.Day, model.personid);
DataTable dtCheck = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString());
if (dtCheck.Rows.Count > 0)
{
//有打卡记录
var dataCheck = dtCheck.AsEnumerable().Where(o => o.Field <string>("A0204") == "1");
if (dataCheck.Count() > 0)
{
//今天有下班记录
string checkRowID = dataCheck.FirstOrDefault().Field <string>("RowID");
//修改下班记录为空
A02 cA02 = new A02();
cA02.A0204 = "";
Modify(cA02, o => o.RowID == checkRowID, "A0204");
//添加新的下班记录
personCheck.A0204 = "1";
}
else
{
personCheck.A0204 = "1";
}
}
else
{
personCheck.A0203 = "1";
}
var data = base.Select(o => o.PersonID == model.personid);
if (data.Count() == 0)
{
return(base.Add(personCheck) > 0);
}
else
{
A02 updateLastRow = new A02();
updateLastRow.IsLastRow = 0;
//有lastRow为1的要修改为0
if (data.Where(o => o.IsLastRow == 1).Count() > 0)
{
base.Modify(updateLastRow, o => o.PersonID == model.personid && o.IsLastRow == 1, "IsLastRow");
}
return(base.Add(personCheck) > 0);
}
}
