public ResultMessage Create(string GUID, string ExamPaper, string Code, string QuestionType, string QuestionContent, decimal FullScore, string Comment)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = false;
request.Params = new List<RequestParameter>()
{
new RequestParameter() { Name = "@GUID", Value = GUID, Type = "string", } ,
new RequestParameter() { Name = "@ExamPaper", Value = ExamPaper, Type = "string", } ,
new RequestParameter() { Name = "@Code", Value = Code, Type = "string", } ,
new RequestParameter() { Name = "@QuestionType", Value = QuestionType, Type = "string", } ,
new RequestParameter() { Name = "@QuestionContent", Value = QuestionContent, Type = "string", } ,
new RequestParameter() { Name = "@FullScore", Value = FullScore.ToString(), Type = "decimal", } ,
new RequestParameter() { Name = "@Comment", Value = Comment, Type = "string", } ,
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "Create");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "提交成功！" };
}
else
{
return new ResultMessage() { State = false, Message = "对不起，提交失败！" };
}
}
public ResultMessage IsExistsExamAnswer(string ExamPaper, string UserCode)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = true;
request.Params = new List<RequestParameter>()
{
new RequestParameter() { Name = "@ExamPaper", Value = ExamPaper, Type = "string", } ,
new RequestParameter() { Name = "@UserCode", Value = UserCode, Type = "string", } ,
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "IsExistsExamAnswer");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "您已经参加过该项测试，不能重复考试。如有需要，请联系培训招集人。" };
}
else
{
return new ResultMessage() { State = false, Message = "没有参加测试！" };
}
}
public ResultMessage Create(string ExamPaper, string Byname, decimal TotalFullScore, string LimitTime, string OwnerType)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = false;
request.Params = new List<RequestParameter>()
{
new RequestParameter() { Name = "@ExamPaper", Value = ExamPaper, Type = "string", } ,
new RequestParameter() { Name = "@Byname", Value = Byname, Type = "string", } ,
new RequestParameter() { Name = "@TotalFullScore", Value = TotalFullScore.ToString(), Type = "decimal", } ,
new RequestParameter() { Name = "@LimitTime", Value = LimitTime, Type = "string", } ,
new RequestParameter() { Name = "@OwnerType", Value = OwnerType, Type = "string", } ,
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "Create");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "提交成功！" };
}
else
{
return new ResultMessage() { State = false, Message = "对不起，提交失败！" };
}
}
public ResultMessage Create(string GUID, string Answer_GUID, string ItemOrder, string Value, string ExpandValue)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = false;
request.Params = new List<RequestParameter>()
{
new RequestParameter() { Name = "@GUID", Value = GUID, Type = "string", } ,
new RequestParameter() { Name = "@Answer_GUID", Value = Answer_GUID, Type = "string", } ,
new RequestParameter() { Name = "@ItemOrder", Value = ItemOrder, Type = "string", } ,
new RequestParameter() { Name = "@Value", Value = Value, Type = "string", } ,
new RequestParameter() { Name = "@ExpandValue", Value = ExpandValue, Type = "string", } ,
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "Create");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "提交成功！" };
}
else
{
return new ResultMessage() { State = false, Message = "对不起，提交失败！" };
}
}
public ResultMessage Create(string GUID, string ExamPaper, string UserCode, string ClientIP, string LeftTime, string RightTime, decimal TotalScore)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = false;
request.Params = new List<RequestParameter>()
{
new RequestParameter() { Name = "@GUID", Value = GUID, Type = "string", } ,
new RequestParameter() { Name = "@ExamPaper", Value = ExamPaper, Type = "string", } ,
new RequestParameter() { Name = "@UserCode", Value = UserCode, Type = "string", } ,
new RequestParameter() { Name = "@ClientIP", Value = ClientIP, Type = "string", } ,
new RequestParameter() { Name = "@LeftTime", Value = LeftTime, Type = "string", } ,
new RequestParameter() { Name = "@RightTime", Value = RightTime, Type = "string", } ,
new RequestParameter() { Name = "@TotalScore", Value = TotalScore.ToString(), Type = "string", } ,
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "Create");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "提交成功！" };
}
else
{
return new ResultMessage() { State = false, Message = "对不起，提交失败！" };
}
}
public ResultMessage Pass(User user)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = true;
request.Params = new List<RequestParameter>()
{
new RequestParameter() { Name = "@UserCode", Value = user.UserCode, Type = "string", } ,
new RequestParameter() { Name = "@Email", Value = user.Email, Type = "string", } ,
new RequestParameter() { Name = "@PWD", Value = user.PWD, Type = "string", } ,
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "IsExistsUser");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "登录成功！" };
}
else
{
return new ResultMessage() { State = false, Message = "不存在该用户！" };
}
}
public bool IsExistsRegister(string ProjGuid, string CstName, string MobileTel)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = true;
request.Params = new List<RequestParameter>()
{
new RequestParameter(){ Name = "@ProjGuid", Value = ProjGuid },
new RequestParameter(){ Name = "@CstName", Value = CstName },
new RequestParameter(){ Name = "@MobileTel", Value = MobileTel },
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "IsExistsRegister");
return Convert.ToInt32(response.ResultValue) > 0;
}
public bool CreateRegister(string ProjGuid, string ProjName, string BUGuid, string CstGuid, string CstName, string Gender,
string MobileTel, string TjrName, string TjrMoblieTel, string TjrCarid)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = false;
request.Params = new List<RequestParameter>()
{
new RequestParameter(){ Name = "@ProjGuid", Value = ProjGuid },
new RequestParameter(){ Name = "@ProjName", Value = ProjName },
new RequestParameter(){ Name = "@BUGuid", Value = BUGuid },
new RequestParameter(){ Name = "@CstGuid", Value = CstGuid },
new RequestParameter(){ Name = "@CstName", Value = CstName },
new RequestParameter(){ Name = "@Gender", Value = Gender },
new RequestParameter(){ Name = "@MobileTel", Value = MobileTel },
new RequestParameter(){ Name = "@TjrName", Value = TjrName },
new RequestParameter(){ Name = "@TjrMoblieTel", Value = TjrMoblieTel },
new RequestParameter(){ Name = "@TjrCarid", Value = TjrCarid },
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "CreateRegister");
return Convert.ToInt32(response.ResultValue) > 0;
}
public ResultMessage IsExistsRegister(string ProjGuid, string CstName, string MobileTel)
{
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = true;
request.Params = new List<RequestParameter>()
{
new RequestParameter(){ Name = "@ProjGuid", Value = ProjGuid },
new RequestParameter(){ Name = "@CstName", Value = CstName },
new RequestParameter(){ Name = "@MobileTel", Value = MobileTel },
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "IsExistsRegister");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "该客户已被推荐，不能再次推荐！" };
}
else
{
return new ResultMessage() { State = false, Message = "该客户没有被推荐！" };
}
}
public ResultMessage CreateRegister(string ProjGuid, string ProjName, string BUGuid, string CstName, string Gender,
string MobileTel, string TjrName, string TjrMoblieTel, string TjrCarid, int Isyz)
{
var r = IsExistsRegister(ProjGuid, CstName, MobileTel);
if (r.State) { return r; }
CommandRequest request = new CommandRequest();
request.TrueScalar_FalseIntByResult = false;
request.Params = new List<RequestParameter>()
{
new RequestParameter(){ Name = "@ProjGuid", Value = ProjGuid },
new RequestParameter(){ Name = "@ProjName", Value = ProjName },
new RequestParameter(){ Name = "@BUGuid", Value = BUGuid },
new RequestParameter(){ Name = "@CstGuid", Value = System.Guid.NewGuid().ToString() },
new RequestParameter(){ Name = "@CstName", Value = CstName },
new RequestParameter(){ Name = "@Gender", Value = Gender },
new RequestParameter(){ Name = "@MobileTel", Value = MobileTel },
new RequestParameter(){ Name = "@TjrName", Value = TjrName },
new RequestParameter(){ Name = "@TjrMoblieTel", Value = TjrMoblieTel },
new RequestParameter(){ Name = "@TjrCarid", Value = TjrCarid },
new RequestParameter(){ Name = "@Isyz", Value = Isyz.ToString(), Type = "bit" },
};
CommandResponse response = new Command().Execute(request, ReposityEntityFactory.Items[Flag], "CreateRegister");
if (Convert.ToInt32(response.ResultValue) > 0)
{
return new ResultMessage() { State = true, Message = "提交成功，请等待客户推荐审核结果！" };
}
else
{
return new ResultMessage() { State = false, Message = "对不起，客户推荐失败！" };
}
}
