/// <summary>
/// 更新历史出勤数据
/// </summary>
/// <param name="haModel">历史出勤对象</param>
/// <param name="strErrMsg">带出的结果</param>
/// <returns>返回的参数 -1为操作失败 1为操作成功</returns>
public int UpdateEmployeeAttendanceHistory(HistoryAttendanceModel haModel, out string strErrMsg)
{
SqlParameter[] sqlpara = new SqlParameter[]
{
new SqlParameter("@ID", SqlDbType.BigInt),
new SqlParameter("@BlockID", SqlDbType.Int, 4),
new SqlParameter("@EmployeeName", SqlDbType.VarChar, 10),
new SqlParameter("@DeptID", SqlDbType.Int, 4),
new SqlParameter("@ClassID", SqlDbType.Int, 4),
new SqlParameter("@ClassShortName", SqlDbType.VarChar, 20),
new SqlParameter("@BeginWorkTime", SqlDbType.VarChar, 20),
new SqlParameter("@EndWorkTime", SqlDbType.VarChar, 20),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@TimerIntervalID", SqlDbType.Int, 4),
new SqlParameter("@DataAttendance", SqlDbType.VarChar, 20)
};
sqlpara[0].Value = haModel.ID_HistoryAttendance;
sqlpara[1].Value = haModel.BlockID;
sqlpara[2].Value = haModel.EmployeeName;
sqlpara[3].Value = haModel.DeptID;
sqlpara[4].Value = haModel.ClassID;
sqlpara[5].Value = haModel.ClassShortName;
sqlpara[6].Value = haModel.BeginWorkTime;
sqlpara[7].Value = haModel.EndWorkTime;
sqlpara[8].Value = haModel.OperatorID;
sqlpara[9].Value = haModel.Remark;
sqlpara[10].Value = haModel.TimerIntervalID;
sqlpara[11].Value = haModel.DataAttendance;
return(DB.RunProcedureByInt("Shine_Shen_HistoryAttendanceUpdate", sqlpara, out strErrMsg));
}
/// <summary>
/// 修改实时岗位异常报警信息措施信息
/// </summary>
/// <param name="id">异常报警信息id</param>
/// <param name="measure">措施内容</param>
/// <returns>返回影响的行数</returns>
public int UpdateRealTimePostAlarmInfoMeasure(int id, string measure)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@measure", SqlDbType.VarChar, 100)
};
para[0].Value = id;
para[1].Value = measure;
return(help.RunProcedureByInt("UpdateRealTimePostMeasure", para, out outStr));
}
/// <summary>
/// 增加PathEmpRelation信息
/// </summary>
/// <param name="pathEmpRelation">线路员工关系类对象</param>
/// <returns>此次操作影响的行数</returns>
public int InsertPathEmpRelation(PathEmpRelationModel pathEmpRelation, out string strMessage)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@PathNo", SqlDbType.VarChar, 50),
new SqlParameter("@EmpID", SqlDbType.Int),
};
para[0].Value = pathEmpRelation.PathNo;
para[1].Value = pathEmpRelation.EmpID;
int result = help.RunProcedureByInt("insert_Path_Emp_Relation", para, out strMessage);
return(result);
}
/// <summary>
/// 添加行走异常配置信息
/// </summary>
/// <returns>返回执行结果行数</returns>
public int InsertWalkConfigInfo(WalkConfigModel model)
{
SqlParameter[] para = new SqlParameter[]
{
//new SqlParameter("@WalkConfigId", SqlDbType.Int, 1000) ,
new SqlParameter("@EmpID", SqlDbType.Int, 1000),
new SqlParameter("@FirstStationAddress", SqlDbType.Int),
new SqlParameter("@FirstStationHeadAddress", SqlDbType.Int),
new SqlParameter("@FirstStationHeadAntennaA", SqlDbType.Bit),
new SqlParameter("@FirstStationHeadAntennaB", SqlDbType.Bit),
new SqlParameter("@MiddleStationAddress", SqlDbType.Int, 1000),
new SqlParameter("@MiddleStationHeadAddress", SqlDbType.Int, 1000),
new SqlParameter("@MiddleStationHeadAntennaA", SqlDbType.Bit),
new SqlParameter("@MiddleStationHeadAntennaB", SqlDbType.Bit),
new SqlParameter("@LastStationAddress", SqlDbType.Int),
new SqlParameter("@LastStationHeadAddress", SqlDbType.Int),
new SqlParameter("@LastStationHeadAntennaA", SqlDbType.Bit),
new SqlParameter("@LastStationHeadAntennaB", SqlDbType.Bit),
new SqlParameter("@TimeValue", SqlDbType.Int)
};
//para[0].Value = model.WalkConfigId;
para[0].Value = model.EmpId;
para[1].Value = model.FirstStationHead.StationAddress;
para[2].Value = model.FirstStationHead.StationHeadAddress;
para[3].Value = model.FirstStationHead.StationHeadAntennaA;
para[4].Value = model.FirstStationHead.StationHeadAntennaB;
para[5].Value = model.MiddleStationHead.StationAddress;
para[6].Value = model.MiddleStationHead.StationHeadAddress;
para[7].Value = model.MiddleStationHead.StationHeadAntennaA;
para[8].Value = model.MiddleStationHead.StationHeadAntennaB;
para[9].Value = model.LastStationHead.StationAddress;
para[10].Value = model.LastStationHead.StationHeadAddress;
para[11].Value = model.LastStationHead.StationHeadAntennaA;
para[12].Value = model.LastStationHead.StationHeadAntennaB;
para[13].Value = model.TimeValue;
return(help.RunProcedureByInt("InsertWalkConfigInfo", para, out outStr));
}
/// <summary>
/// 增加PathInfo信息
/// </summary>
/// <param name="pathInfo">线路信息类对象</param>
/// <returns>此次操作影响的行数</returns>
public int InsertPathInfo(PathInfoModel pathInfo, out string strMessage)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@PathNo", SqlDbType.VarChar, 50),
new SqlParameter("@PathName", SqlDbType.VarChar, 100),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
};
para[0].Value = pathInfo.PathNo;
para[1].Value = pathInfo.PathName;
para[2].Value = pathInfo.Remark;
int result = help.RunProcedureByInt("insert_Path_Info", para, out strMessage);
return(result);
}
public int InsertUnitPriceInfo(int intDeptID, float fUnitPrice, string strRemark, out string strErr)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@DeptID", SqlDbType.Int, 4),
new SqlParameter("@UnitPrice", SqlDbType.Float, 8),
new SqlParameter("@Remark", SqlDbType.VarChar, 200)
};
parameter[0].Value = intDeptID;
parameter[1].Value = fUnitPrice;
parameter[2].Value = strRemark;
return(DB.RunProcedureByInt("Shine_Shen_UnitPrice_Add", parameter, out strErr));
}
/// <summary>
/// 管理员登录
/// </summary>
/// <param name="strAccount"></param>
/// <param name="strPassword"></param>
/// <param name="intIP"></param>
/// <param name="strRemark"></param>
/// <param name="strErr"></param>
/// <returns></returns>
public int Login(string strAccount, string strPassword, int intIP, string strRemark, out string strErr)
{
SqlParameter[] arrParm =
{
new SqlParameter("@d_name", SqlDbType.VarChar, 20),
new SqlParameter("@d_pwd", SqlDbType.VarChar, 20),
new SqlParameter("@p_TmpLoginIP", SqlDbType.BigInt),
new SqlParameter("@p_Remark", SqlDbType.VarChar, 200)
};
arrParm[0].Value = strAccount;
arrParm[1].Value = strPassword;
arrParm[2].Value = intIP;
arrParm[3].Value = strRemark;
return(DB.RunProcedureByInt("PROC_userLogin", arrParm, out strErr));
}
public int InsertRealTimePathCheck(RealTimePathCheckModel model)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@EmpID", SqlDbType.Int),
new SqlParameter("@Interval", SqlDbType.Int),
new SqlParameter("@CheckTime", SqlDbType.DateTime)
};
para[0].Value = model.EmpNO;
para[1].Value = model.Interval;
para[2].Value = model.CheckTime;
int result = help.RunProcedureByInt("insert_RealTimePathCheck", para, out outStr);
return(result);
}
public int insertAdmin(string Account, string password, string passwordback, bool isEnable, bool isUserEndDate, DateTime UseEndDate, int userGroupID, int CreateID, int CreateIP, string Remark, out string err)
{
SqlParameter[] arrParm =
{
new SqlParameter("@Account", SqlDbType.VarChar, 20),
new SqlParameter("@password", SqlDbType.VarChar, 16),
new SqlParameter("@Passwordback", SqlDbType.VarChar, 16),
new SqlParameter("@isEnable", SqlDbType.Bit, 1),
new SqlParameter("@IsUseEndDate", SqlDbType.Bit, 1),
new SqlParameter("@UseEndDate", SqlDbType.DateTime, 8),
new SqlParameter("@userGroupID", SqlDbType.Int, 4),
new SqlParameter("@CreateID", SqlDbType.Int, 4),
new SqlParameter("@CreateIP", SqlDbType.BigInt, 8),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@ID", SqlDbType.Int)
};
arrParm[0].Value = Account;
arrParm[1].Value = password;
arrParm[2].Value = passwordback;
arrParm[3].Value = isEnable;
arrParm[4].Value = isUserEndDate;
arrParm[5].Value = UseEndDate;
arrParm[6].Value = userGroupID;
arrParm[7].Value = CreateID;
arrParm[8].Value = CreateIP;
arrParm[9].Value = Remark;
arrParm[10].Value = Account.GetHashCode();
return(DB.RunProcedureByInt("inserUser", arrParm, out err));
}
/// <summary>
/// 增加一条记录
/// </summary>
public void Add(string UGName, bool IsEnable, bool IsUseEndDate, DateTime UseEndDate, string Remark, out string ErrMsgString)
{
SqlParameter[] parameters =
{
new SqlParameter("@UGName", SqlDbType.VarChar, 20),
new SqlParameter("@IsEnable", SqlDbType.Bit, 1),
new SqlParameter("@IsUseEndDate", SqlDbType.Bit, 1),
new SqlParameter("@UseEndDate", SqlDbType.DateTime, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
};
parameters[0].Value = UGName;
parameters[1].Value = IsEnable;
parameters[2].Value = IsUseEndDate;
parameters[3].Value = UseEndDate;
parameters[4].Value = Remark;
DB.RunProcedureByInt("Shine_UserGroups_Add1", parameters, out ErrMsgString);
}
public int DeleteRealTimeAlarmPathByEmpID(int empID)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@EmpID", SqlDbType.Int)
};
para[0].Value = empID;
int result = help.RunProcedureByInt("delete_RealTimePathAlert", para, out outStr);
return(result);
}
/// <summary>
/// 增加PathDetail信息
/// </summary>
/// <param name="pathDetail">线路具体信息类对象</param>
/// <returns>此次操作影响的行数</returns>
public int InsertPathDetail(PathDetailModel pathDetail)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@PathNo", SqlDbType.VarChar),
new SqlParameter("@StationAddress", SqlDbType.Int),
new SqlParameter("@StationHeadAddress", SqlDbType.Int)
};
para[0].Value = pathDetail.PathNo;
para[1].Value = pathDetail.StationAddress;
para[2].Value = pathDetail.StationHeadAddress;
try
{
int result = help.RunProcedureByInt("insert_Path_Detail", para, out outStr);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 增加HisPathAlert
/// </summary>
/// <param name="hisPathAlert">历史线路报警类对象</param>
/// <returns>此次操作影响的行数</returns>
public int InsertHisPathAlert(HisPathAlertModel hisPathAlert)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@PathId", SqlDbType.Int),
new SqlParameter("@StationHeadId", SqlDbType.Int),
new SqlParameter("@EmpId", SqlDbType.Int),
new SqlParameter("@AlertBeginTime", SqlDbType.DateTime),
new SqlParameter("@AlertEndTime", SqlDbType.DateTime),
new SqlParameter("@AlertTimeValue", SqlDbType.Int)
};
para[0].Value = hisPathAlert.PathId;
para[1].Value = hisPathAlert.StationHeadId;
para[2].Value = hisPathAlert.EmpId;
para[3].Value = hisPathAlert.AlertBeginTime;
para[4].Value = hisPathAlert.AlertEndTime;
para[5].Value = hisPathAlert.AlertTimeValue;
int result = help.RunProcedureByInt("insert_His_PathAlert", para, out outStr);
return(result);
}
/// <summary>
/// 返回执行的行数
/// </summary>
/// <param name="Id">要删除的记录Id</param>
/// <returns>返回的行数</returns>
public int DeletePathAlertInfo(int Id)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@id", SqlDbType.Int)
};
para[0].Value = Id;
string outStr = String.Empty;
int result = help.RunProcedureByInt("delete_His_PathAlert", para, out outStr);
return(result);
}
public void DeleteByPointId(string strPointId, out string strErrMsg)
{
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@strPointId", SqlDbType.VarChar, 20) };
parameters[0].Value = strPointId;
DB.RunProcedureByInt("Shine_Points_DeleteByPointId", parameters, out strErrMsg);
}
