/// <summary>
/// 1.13.6 删除学员
/// </summary>
public InterfaceOutPut DeleteStudent(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 1;
try
{
InDeleteStudent InParams = JsonConvert.DeserializeObject <InDeleteStudent>(Data);
DBTeacherXYRel db = new DBTeacherXYRel();
db.DeleteStudent(InParams.TeacherGUID, InParams.StudentGUID);
//添加操作日志
XyOperateLog OperateLog = new XyOperateLog();
OperateLog.RelationOP = 3;//删除学员
OperateLog.strTeacherGUID = InParams.TeacherGUID;
OperateLog.strDutyUserGUID = InParams.DutyUserGUID;
OperateLog.strStudentGUID = InParams.StudentGUID;
db.AddLog(OperateLog);
output.result = 0;
output.resultStr = "删除成功";
}
catch (Exception ex)
{
output.resultStr = ex.Message;
throw ex;
}
return(output);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void OperateLogDataRowToModel(XyOperateLog model, DataRow dr)
{
model.RelationOP = ObjectConvertClass.static_ext_int(dr["nRelationOP"]);
model.strTeacherGUID = ObjectConvertClass.static_ext_string(dr["strTeacherGUID"]);
model.strTeacherNumber = ObjectConvertClass.static_ext_string(dr["strTeacherNumber"]);
model.strTeacherName = ObjectConvertClass.static_ext_string(dr["strTeacherName"]);
model.strStudentGUID = ObjectConvertClass.static_ext_string(dr["strStudentGUID"]);
model.strStudentNumber = ObjectConvertClass.static_ext_string(dr["strStudentNumber"]);
model.strStudentName = ObjectConvertClass.static_ext_string(dr["strStudentName"]);
model.strDutyUserGUID = ObjectConvertClass.static_ext_string(dr["strDutyUserGUID"]);
model.strDutyUserNumber = ObjectConvertClass.static_ext_string(dr["strDutyNumber"]);
model.strDutyUserName = ObjectConvertClass.static_ext_string(dr["strDutyName"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
}
/// <summary>
/// 添加操作日志
/// </summary>
public int AddLog(XyOperateLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Base_XYRelation_Log");
strSql.Append("(nRelationOP,strTeacherGUID,strStudentGUID,strDutyUserGUID)");
strSql.Append("values(@nRelationOP,@strTeacherGUID,@strStudentGUID,@strDutyUserGUID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@nRelationOP", model.RelationOP),
new SqlParameter("@strTeacherGUID", model.strTeacherGUID),
new SqlParameter("@strStudentGUID", model.strStudentGUID),
new SqlParameter("@strDutyUserGUID", model.strDutyUserGUID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)));
}
/// <summary>
/// 获取操作日志数据List
/// </summary>
public XyOperateLogArray GetXyOperateLogList(DateTime dtBegin, DateTime dtEnd)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from VIEW_Base_XYRelation_Log ");
strSql.Append(" where dtCreateTime >= @dtBegin and dtCreateTime <= @dtEnd order by dtCreateTime DESC");
SqlParameter[] sqlParams =
{
new SqlParameter("dtBegin", dtBegin),
new SqlParameter("dtEnd", dtEnd)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
XyOperateLogArray list = new XyOperateLogArray();
foreach (DataRow dr in dt.Rows)
{
XyOperateLog _Base_XYRelation_Log = new XyOperateLog();
OperateLogDataRowToModel(_Base_XYRelation_Log, dr);
list.Add(_Base_XYRelation_Log);
}
return(list);
}
/// <summary>
/// 1.13.3 添加师傅
/// </summary>
public InterfaceOutPut AddTeacher(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 1;
try
{
InAddTeacher InParams = JsonConvert.DeserializeObject <InAddTeacher>(Data);
DBTeacherXYRel db = new DBTeacherXYRel();
if (!db.ExistTeacher(InParams.TeacherGUID))
{
db.AddTeacher(InParams.TeacherGUID);
//添加操作日志
XyOperateLog OperateLog = new XyOperateLog();
OperateLog.RelationOP = 0;//添加师傅
OperateLog.strTeacherGUID = InParams.TeacherGUID;
OperateLog.strDutyUserGUID = InParams.DutyUserGUID;
db.AddLog(OperateLog);
output.result = 0;
output.resultStr = "添加成功";
}
else
{
output.resultStr = "数据已存在";
}
}
catch (Exception ex)
{
output.resultStr = "添加失败：" + ex.Message;
throw ex;
}
return(output);
}
