protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
int StuNumber = new CourseManege().QueryStuNum(CourseId);
StuNum.Text = StuNumber.ToString();
List <Model.Class> clalist = new CourseManege().queryClassByCourseId(CourseId);
string ClassId;
foreach (Model.Class Class in clalist)
{
ClassId = Class.ClassId;
ddlclass.Items.Add(ClassId);
}
List <Students> stulist = new StudentManage().queryStudentByCourseId(CourseId);
Repeater1.DataSource = stulist;
Repeater1.DataBind();
int ScoreNum = new ScoreManage().queryCouseScoreNum(CourseId);
//当前该课程只要有记录记录则无法在添加学生成绩，此处可扩展，
if (ScoreNum > 0)
{
Button2.Enabled = false;
Literal1.Text = "该课程已完成成绩录入";
}
}
}
/// <summary>
/// 改变数字
/// </summary>
/// <param name="changeObj">Change object.</param>
/// <param name="targetBgCellObj">Target background cell object.</param>
public void ChangeNumber(GameObject changeObj, GameObject targetBgCellObj)
{
NumberEntity entity = changeObj.GetComponent <NumberCell>().NumberEntity;
if (entity.CurrentNumberValue + 1 > GlobalConfig.MaxNubmberValue)
{
GlobalConfig.MaxNubmberValue = entity.CurrentNumberValue + 1;
}
//分数设置
ScoreManage.SetScore(entity.CurrentNumberValue + 1);
var numberObj = CommonToolkit.LoadNumberResource(entity.CurrentNumberValue);
GameObject newGameObject = NumberConstructor.CreateNumber(
numberObj,
targetBgCellObj,
targetBgCellObj.GetComponent <BackgroundCell>().BackgroundCellEntity.Index,
entity.CurrentNumberValue + 1);
targetBgCellObj.GetComponent <BackgroundCell>().DisposeNumber();
CommonToolkit.SetNumberObjectToBackgroundCell(targetBgCellObj, newGameObject);
GameObject scoreNumberObj = CommonToolkit.GetScoreNumberObject(targetBgCellObj, entity.CurrentNumberValue + 1);
scoreNumberObj.GetComponent <Animation>().Play("AnimationScoreRun");
}
private void Start()
{
GameObject player = GameObject.FindGameObjectWithTag("Player");
soundPlayed = player.GetComponent <PlayRanSound>();
trackingScore = player.GetComponent <ScoreManage>();
}
// Update is called once per frame
void Update()
{
if (first == false)
{
if (this.CompareTag("filled"))
{
transform.DOShakeScale(0.2f, new Vector3(1, 1, 0));
skin.material = new Material(offskin);
/// LightOn();
BoardsInst.BornCall = true;
if (this.name == ("chosen"))
{
for (int i = 0; i <= 10; i++)
{
ScoreManage.ScoreUp();
}
}
else
{
ScoreManage.ScoreUp();
}
first = true;
}
}
}
//通过姓名模糊查询
protected void btn_searchstu_Click(object sender, EventArgs e)
{
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
string StuName = txt_name.Text.Trim().ToString();
List <ScoreExt> sclist = new ScoreManage().queryScorebyCIdSNa(CourseId, StuName);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
protected void btn_searchstu_Click(object sender, EventArgs e)
{
string name = txt_name.Text.Trim();
int StuId = Convert.ToInt32(((Model.Login)Session["CurrentUser"]).UserName);
string Season = ddlseason.SelectedItem.Text.Trim();
List <Model.Score> sclist = new ScoreManage().queryScoreByName(StuId, name, Season);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
public void Index()
{
var context = HttpContext;
_dealerId = context.Request["DealerId"];
_dealerName = context.Request["DealerName"];
ScoreManage sm = ScoreManage.LoadGradeObject("loadfullscorestruct", "C_Grade", new StructNames(false), LoadDealerInfo, System.Configuration.ConfigurationManager.AppSettings["BPMEngine"]);
context.Response.Write(JsonConvert.SerializeObject(sm.GetGrade()));
}
private void Awake()
{
if (singleton == null)
{
singleton = this;
}
else if (singleton != this)
{
Destroy(gameObject);
}
m_CurScore = 0;
}
//通过学号查学生
protected void btn_searchStuId_Click(object sender, EventArgs e)
{
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
int StuId = Convert.ToInt32(txt_StuId.Text.Trim());
if (StuId == 0)
{
return;
}
List <ScoreExt> sclist = new ScoreManage().queryScorebyCIdSId(CourseId, StuId);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
private string GetGrade()
{
ScoreManage sm = ScoreManage.LoadGradeObject("loadfullscorestruct", "C_Grade", new StructNames(false), LoadDealerInfo, System.Configuration.ConfigurationManager.AppSettings["BPMEngine"]);
List <Dealer> result = sm.GetGrade(true);
if (result == null || result.Count <= 0 || result[0].ResultList.Count <= 0)
{
return("");
}
else
{
return(result[0].ResultList[0].ResultGrade);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ClassId = Request.Params["ClassId"].ToString();
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
List <ScoreExt> sclist = new ScoreManage().queryScorebyFDY(CourseId, ClassId);
foreach (ScoreExt sc in sclist)
{
sc.KqNum = new KqManage().queryStuKqNum(sc.StuId, sc.CourseId);
sc.HwNum = new HomeworkManage().queryStuHwNum(sc.StuId, sc.CourseId);
}
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//绑定下拉框
int StuId = Convert.ToInt32(((Model.Login)Session["CurrentUser"]).UserName);
List <CourseMana> Seasonlist = new CourseManege().querySeason(StuId);
foreach (CourseMana Season in Seasonlist)
{
ddlseason.Items.Add(Season.Season);
}
//显示数据
List <Model.Score> sclist = new ScoreManage().queryScore(StuId);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int stuId = Convert.ToInt32(Request.Params["StuId"]);
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
List <ScoreExt> sclist = new ScoreManage().queryScorebyCIdSId(CourseId, stuId);
CourseMana course = new ScoreManage().queryRatio(CourseId);
MatchRatio.Text = course.MatchRatio.ToString();
ClassRatio.Text = course.ClassRatio.ToString();
StuName.Text = sclist[0].StuName.ToString();
StuId.Text = sclist[0].StuId.ToString();
CourseName.Text = sclist[0].CourseName.ToString();
old_ClassScore.Text = sclist[0].ClassScore.ToString();
old_MatchScore.Text = sclist[0].MatchScore.ToString();
old_FinalScore.Text = sclist[0].FinalScore.ToString();
}
}
protected void ddlclass_SelectedIndexChanged(object sender, EventArgs e)
{
string ClassId = ddlclass.SelectedItem.Text.Trim();
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
if (ClassId == "请选择")
{
List <ScoreExt> sclist = new ScoreManage().queryScorebyCourseId(CourseId);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
else
{
List <ScoreExt> sclist = new ScoreManage().queryScorebyClassId(CourseId, ClassId);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
}
// Use this for initialization
void Start()
{
GameObject gameControllerObject = GameObject.FindWithTag("HandControl");
if (gameControllerObject != null)
{
handController = gameControllerObject.GetComponent <HandController>();
}
scorr = gameObject.GetComponent <ScoreManage>();
if (ScoreManage3.score3 <= 20000)
{
Obj.GetComponent <Renderer>().material.mainTexture = textur1;
}
else
{
Obj.GetComponent <Renderer>().material.mainTexture = textur2;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/x-excel";
//将HTTP头添加到输出流，设置默认导出的文件名
int StuId = Convert.ToInt32(context.Request.QueryString["StuId"]);
string StuName = context.Request.QueryString["StuName"].ToString();
string filename = HttpUtility.UrlEncode(StuId + StuName + "成绩表.xls");
context.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
//创建Excel工作簿和工作表
HSSFWorkbook workbook = new HSSFWorkbook();
ISheet newsheet = workbook.CreateSheet("学生成绩表");
//创建工作表的标题
IRow rowHeader = newsheet.CreateRow(0);
rowHeader.CreateCell(0, CellType.Numeric).SetCellValue("课程名");
rowHeader.CreateCell(1, CellType.String).SetCellValue("课程性质");
rowHeader.CreateCell(2, CellType.String).SetCellValue("学分");
rowHeader.CreateCell(3, CellType.Numeric).SetCellValue("学院");
rowHeader.CreateCell(4, CellType.Numeric).SetCellValue("教师");
rowHeader.CreateCell(5, CellType.Numeric).SetCellValue("学期");
rowHeader.CreateCell(6, CellType.Numeric).SetCellValue("平时成绩");
rowHeader.CreateCell(7, CellType.Numeric).SetCellValue("期末成绩");
rowHeader.CreateCell(8, CellType.Numeric).SetCellValue("总成绩");
//查询数据
List <Model.Score> sclist = new ScoreManage().queryScore(StuId);
for (int i = 0; i < sclist.Count; i++)
{
IRow newRow = newsheet.CreateRow(i + 1);
newRow.CreateCell(0, CellType.Numeric).SetCellValue(sclist[i].CourseName);
newRow.CreateCell(1, CellType.Numeric).SetCellValue(sclist[i].courseproperty);
newRow.CreateCell(2, CellType.Numeric).SetCellValue(sclist[i].Xuefen);
newRow.CreateCell(3, CellType.Numeric).SetCellValue(sclist[i].CollegeName);
newRow.CreateCell(4, CellType.Numeric).SetCellValue(sclist[i].TeaName);
newRow.CreateCell(5, CellType.Numeric).SetCellValue(sclist[i].Season);
newRow.CreateCell(6, CellType.Numeric).SetCellValue(sclist[i].ClassScore);
newRow.CreateCell(7, CellType.Numeric).SetCellValue(sclist[i].MatchScore);
newRow.CreateCell(8, CellType.Numeric).SetCellValue(sclist[i].FinalScore);
}
//将输出流写入Excel工作簿
workbook.Write(context.Response.OutputStream);
}
protected void ddlseason_SelectedIndexChanged(object sender, EventArgs e)
{
string Season = ddlseason.SelectedItem.Text.Trim();
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
int StuId = Convert.ToInt32(((Model.Login)Session["CurrentUser"]).UserName);
if (Season == "请选择")
{
List <Model.Score> sclist = new ScoreManage().queryScore(StuId);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
}
else
{
List <Model.Score> scList = new ScoreManage().queryScoreBySea(StuId, Season);
Repeater1.DataSource = scList;
Repeater1.DataBind();
}
}
protected void btn_change_Click(object sender, EventArgs e)
{
Model.Score sc = new Model.Score()
{
StuId = Convert.ToInt32(Request.Params["StuId"]),
CourseId = Convert.ToInt32(Request.Params["CourseId"]),
ClassScore = float.Parse(new_ClassScore.Text.ToString().Trim()),
MatchScore = float.Parse(new_MatchScore.Text.ToString().Trim()),
FinalScore = float.Parse(new_FinalScore.Text.ToString().Trim()),
};
int res = new ScoreManage().ChangeScore(sc);
if (res > 0)
{
Response.Write("<script>alert('修改成功！');history.go(-2)</script>");
}
else
{
Response.Write("<script>alert('修改失败！');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
List <ScoreExt> sclist = new ScoreManage().queryScorebyCourseId(CourseId);
Repeater1.DataSource = sclist;
Repeater1.DataBind();
//绑定下拉框
List <Model.Class> clalist = new CourseManege().queryClassByCourseId(CourseId);
string ClassId;
foreach (Model.Class Class in clalist)
{
ClassId = Class.ClassId;
ddlclass.Items.Add(ClassId);
}
//显示计分比例
CourseMana course = new ScoreManage().queryRatio(CourseId);
MatchRatio.Text = course.MatchRatio.ToString();
ClassRatio.Text = course.ClassRatio.ToString();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
float matchratio = float.Parse(TextBox2.Text.Trim());
float classratio = float.Parse(TextBox1.Text.Trim());
for (int i = 0; i < Repeater1.Items.Count; i++)
{
Model.Score sc = new Model.Score()
{
StuId = Convert.ToInt32(((Literal)Repeater1.Items[i].FindControl("StuId")).Text.Trim()),
CourseId = Convert.ToInt32(Request.Params["CourseId"]),
MatchScore = float.Parse(((TextBox)(Repeater1.Items[i].Controls[0].FindControl("matchScore"))).Text),
ClassScore = float.Parse(((TextBox)(Repeater1.Items[i].FindControl("classScore"))).Text),
FinalScore = float.Parse(((TextBox)(Repeater1.Items[i].FindControl("matchScore"))).Text) * matchratio + float.Parse(((TextBox)(Repeater1.Items[i].FindControl("classScore"))).Text) * classratio
};
int result = new ScoreManage().addStuScore(sc);
if (result == 0)
{
Response.Write("<script>window.alert('成功添加了" + i + "名同学的成绩，第" + i + 1 + "位同学成绩添加失败！');</script>");
break;
}
}
Response.Write("<script>window.alert('成功添加了" + Repeater1.Items.Count + "名同学的成绩');</script>");
}
// Start is called before the first frame update
void Start()
{
coinpicksound = GameObject.Find("CoinPickSound").GetComponent <AudioSource>();
scoreManager = FindObjectOfType <ScoreManage>();
}
//private string[] _names = new string[10];
void Awake()
{
_scoreManage = Camera.main.GetComponent <ScoreManage>();
_player = Camera.main.GetComponent <Player>();
}
private void 成绩管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
ScoreManage scoreManage = new ScoreManage();
scoreManage.ShowDialog();
}
/// <summary>
/// 读取数据和计算评分
/// </summary>
/// <returns>评分json</returns>
static string LoadDataAndGetGrade()
{
Log.WriteLog(true, "开始读取数据结构", 0.0, null);
ScoreManage sm = ScoreManage.LoadGradeObject("loadfullscorestruct", "C_Grade", new StructNames(), LoadDealerInfo, Config.Settings["Engine"]);
//ScoreManage.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable("TRUNCATE TABLE C_JXSMC ");
//Log.WriteLog(true, sm.GetGradeLog, 0);
sm.ReCordLog = Program.recordLog;
Log.WriteLog(true, "开始计算评分", 0.0, null);
List <Dealer> dealers = sm.GetGrade(true);
if (Program.recordLog)
{
Log.WriteLog(true, sm.GetGradeLog, 0.0, null);
}
JArray jarray = new JArray();
JArray ret = new JArray();
List <string> sqlList = new List <string>();
foreach (Dealer item in dealers)
{
JObject token = new JObject();
token.Add("menu_name", "customer_success");
token.Add("third_system_no", item.DealerId);
token.Add("account", item.DealerAccount);
token.Add("dealerType", item.DealerType);
token.Add("dealerKind", item.DealerKind);
token.Add("dealerName", item.DealerName);
token.Add("hasScore", item.ResultList.Count > 0 ? "1" : "0");
token.Add("SystemScore", item.ResultList.Count > 0 ? item.ResultList[0].TotalScore.ToString() : "");
token.Add("grade", item.ResultList.Count > 0 ? item.ResultList[0].ResultGrade : "");
ret.Add(token);
Score rw = item.ResultList.Count > 0 ? item.ResultList[0].Scores.FirstOrDefault(x => x.ScoreName == "入网评分") : null;
Score yw = item.ResultList.Count > 0 ? item.ResultList[0].Scores.FirstOrDefault(x => x.ScoreName == "业务评分") : null;
sqlList.Add(DealerGrade.Replace("[VALUES]",
"'" + item.DealerId + "','" + item.DealerName + "','" + item.DealerType + "','" +
(rw != null ? rw.RealScore.ToString() : "") + "','" +
(yw != null ? yw.RealScore.ToString() : "") + "','" +
(item.ResultList.Count > 0 ? item.ResultList[0].TotalScore.ToString() : "") + "','" +
(item.ResultList.Count > 0 ? item.ResultList[0].ResultGrade : "") + "','" +
item.DealerKind + "','" + DateTime.Now.Year + "','" + DateTime.Now.Month + "','" +
DateTime.Now.Day + "','" + item.DealerId + "','" + (item.ResultList.Count > 0 ? "1" : "0") + "'"));
}
try
{
foreach (string sql in sqlList)
{
int i = ScoreManage.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteNonQuery(sql);
}
}
catch (Exception e)
{
}
string sendData = ret.ToString();
if (!Directory.Exists(".\\WaitPush"))
{
Directory.CreateDirectory(".\\WaitPush");
}
StreamWriter sw = new StreamWriter(".\\WaitPush\\" + DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss_fff") + ".txt");
sw.Write(sendData);
sw.Close();
return("源数据：\r\n" + JsonConvert.SerializeObject(dealers) + "\r\n处理后数据：\r\n" + sendData + "\r\n");
}
public void Index()
{
var context = HttpContext;
context.Response.ContentType = "text/plain";
string score = "";
string action = context.Request["action"] ?? "";
_dealerName = context.Request["dealer"] ?? "";
_dealerId = context.Request["crmDealerId"] ?? "";
string type = context.Request["type"] ?? "";
string dealerType = context.Request["dealerType"] ?? "";
if (string.IsNullOrEmpty(_dealerName) || string.IsNullOrEmpty(type))
{
try
{
string sql = "SELECT DISTRIBUTOR,TYPE,DISTRIBUTORTYPE FROM I_ALLOWIN WHERE CRMDEALERID='" + _dealerId + "'";
DataTable dt = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql);
type = dt.Rows[0]["TYPE"] + string.Empty;
dealerType = dt.Rows[0]["DISTRIBUTORTYPE"] + string.Empty;
_dealerName = dt.Rows[0]["DISTRIBUTOR"] + string.Empty;
}
catch (Exception ex) { }
}
ScoreManage sm = ScoreManage.LoadGradeObject("loadfullscorestruct", "C_Grade", new StructNames(false), LoadDealerInfo, System.Configuration.ConfigurationManager.AppSettings["BPMEngine"]);
List <Dealer> scoreList = sm.GetGrade();
foreach (var dealer in scoreList)
{
foreach (var list in dealer.ResultList)
{
if (type == list.DealerType && dealerType == list.DealerIntranet)
{
if (action == "Prewaring" || action == "Relegation" || action == "RiskPoint2")
{
score = list.TotalScore.ToString();
}
else
{
foreach (var item in list.Scores)
{
if (item.ScoreName == "入网评分" && (action == "AllowIn" || action == "RiskPoint1" || action == "UpdateEnterNet"))
{
score = item.RealScore.ToString();
}
}
}
}
}
}
if (action == "RiskPoint1" && !string.IsNullOrEmpty(_dealerName))
{
string sql =
"SELECT TOTAL,ICOUNT,CASE WHEN TOTAL IS NULL OR TOTAL = 0 THEN 0 ELSE ROUND(ICOUNT*100/TOTAL,2) END RATE FROM (" +
"SELECT DISTINCT IA.DISTRIBUTOR AS Dealer,IA.SystemScore,IA.TYPE,IA.DISTRIBUTORTYPE,IA.PROVINCE,IA.CITY,IA.CrmDealerId," +
"(SELECT COUNT(1) FROM in_cms.mv_dy_application_date_info@to_dy_cms cms WHERE cms.经销商名称 = IA.DISTRIBUTOR) TOTAL," +
"(SELECT COUNT(1) FROM in_cms.mv_dy_application_date_info@to_dy_cms cms WHERE cms.经销商名称 = IA.DISTRIBUTOR AND TO_DATE(cms.合同到期日,'yyyy-mm-dd')< SYSDATE) ICOUNT " +
"FROM I_ALLOWIN IA WHERE IA.DISTRIBUTOR = '" + _dealerName + "')";
DataTable table = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql);
score += "|" + table.Rows[0]["RATE"] + "%";
}
//string ms = JsonConvert.SerializeObject(sm.GetGrade());
context.Response.Write(score);
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
ScoreManage scoreManage = new ScoreManage();
scoreManage.ShowDialog();
}
