public void ProcessRequest(HttpContext context) { string LanUrl = string.Empty; string ExtranetUrl = Rc.Common.ConfigHelper.GetConfigString("TeachingPlanWebSiteUrl"); string strUserId = string.Empty; try { strUserId = context.Request.QueryString["UserId"].Filter(); List <Model_ConfigSchool> listModelCS = new List <Model_ConfigSchool>(); string strWhere = string.Format("D_Type='{0}' and School_ID in(select SchoolId from VW_UserOnClassGradeSchool where userid='{1}' and SchoolId is not null)" , ConfigSchoolTypeEnum.TeachingplanResourceHost.ToString(), strUserId); listModelCS = new BLL_ConfigSchool().GetModelList(strWhere); if (listModelCS.Count > 0) { Model_ConfigSchool model = listModelCS[0]; //服务器端验证‘学校局域网是否可访问’有问题,暂时停用,直接不验证 //Rc.Cloud.Web.Common.pfunction.VerifyLANIsAccess(strUserId, model.D_Value, ExtranetUrl); Rc.Common.DataCache.SetCache(strUserId, model.D_Value); } } catch (Exception ex) { } context.Response.Write("1"); }
public bool Add(Model_ConfigSchool model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ConfigSchool("); builder.Append("ConfigEnum,School_ID,School_Name,D_Name,D_Value,D_Type,D_Remark,D_Order,D_CreateTime,D_CreateUser,D_UpdateTime,D_UpdateUser,D_PublicValue,SchoolIP,Mobile)"); builder.Append(" values ("); builder.Append("@ConfigEnum,@School_ID,@School_Name,@D_Name,@D_Value,@D_Type,@D_Remark,@D_Order,@D_CreateTime,@D_CreateUser,@D_UpdateTime,@D_UpdateUser,@D_PublicValue,@SchoolIP,@Mobile)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ConfigEnum", SqlDbType.VarChar, 20), new SqlParameter("@School_ID", SqlDbType.VarChar, 50), new SqlParameter("@School_Name", SqlDbType.NVarChar, 250), new SqlParameter("@D_Name", SqlDbType.NVarChar, 100), new SqlParameter("@D_Value", SqlDbType.VarChar, 300), new SqlParameter("@D_Type", SqlDbType.VarChar, 50), new SqlParameter("@D_Remark", SqlDbType.NVarChar, 500), new SqlParameter("@D_Order", SqlDbType.Int, 4), new SqlParameter("@D_CreateTime", SqlDbType.DateTime), new SqlParameter("@D_CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@D_UpdateTime", SqlDbType.DateTime), new SqlParameter("@D_UpdateUser", SqlDbType.Char, 0x24), new SqlParameter("@D_PublicValue", SqlDbType.VarChar, 300), new SqlParameter("@SchoolIP", SqlDbType.VarChar, 300), new SqlParameter("@Mobile", SqlDbType.VarChar, 50) }; cmdParms[0].Value = model.ConfigEnum; cmdParms[1].Value = model.School_ID; cmdParms[2].Value = model.School_Name; cmdParms[3].Value = model.D_Name; cmdParms[4].Value = model.D_Value; cmdParms[5].Value = model.D_Type; cmdParms[6].Value = model.D_Remark; cmdParms[7].Value = model.D_Order; cmdParms[8].Value = model.D_CreateTime; cmdParms[9].Value = model.D_CreateUser; cmdParms[10].Value = model.D_UpdateTime; cmdParms[11].Value = model.D_UpdateUser; cmdParms[12].Value = model.D_PublicValue; cmdParms[13].Value = model.SchoolIP; cmdParms[14].Value = model.Mobile; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
/// <summary> /// 第三方用户登录认证 17-12-18TS /// </summary> public static bool AuthUserLoginByIF(Model_ConfigSchool modelCS, string schoolCode, string userName, string password) { bool flag = false; if (schoolCode == ThirdPartyEnum.yzlyxx.ToString()) { #region 扬州旅游商贸学校 用户认证 string para = string.Format("UserName={0}&Password={1}", userName, password); if (Rc.Common.RemotWeb.PostDataToServer(modelCS.D_PublicValue + "/AuthApi/yzlyxx/auth.aspx", para, Encoding.UTF8, "POST") == "successful") { flag = true; } #endregion } else if (schoolCode == ThirdPartyEnum.ahjzvs.ToString()) { #region 安徽金寨职业学校 object objUser = new BLL_F_User().GetModel(userName, Rc.Common.StrUtility.DESEncryptLogin.EncryptString(password)); if (objUser != null) { flag = true; } #endregion } return(flag); }
public static string GetSchoolUrl(string schoolId) { string temp = string.Empty; try { Model_ConfigSchool modelCS = new Model_ConfigSchool(); BLL_ConfigSchool bllCS = new BLL_ConfigSchool(); modelCS = bllCS.GetModelBySchoolId(schoolId.Filter()); if (modelCS == null) { temp = JsonConvert.SerializeObject(new { err = "学校配置信息不存在" }); } else { if (string.IsNullOrEmpty(modelCS.D_PublicValue)) { temp = JsonConvert.SerializeObject(new { err = "请配置学校外网地址" }); } else { temp = JsonConvert.SerializeObject(new { err = "null", SchoolIP_Local = modelCS.D_Value, SchoolIP = modelCS.D_PublicValue }); } } } catch (Exception ex) { temp = JsonConvert.SerializeObject(new { err = ex.Message.ToString() }); } return(temp); }
public List <Model_ConfigSchool> DataTableToList(DataTable dt) { List <Model_ConfigSchool> list = new List <Model_ConfigSchool>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_ConfigSchool item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
/// <summary> /// 修改时的默认值 /// </summary> protected void loadData() { model = bll.GetModel(ConfigEnum); if (model == null) { return; } else { txtConfigEnum.Attributes.Add("readonly", "true"); txtConfigEnum.Text = model.ConfigEnum; hidtxtSchool.Value = model.School_ID; txtSchool.Value = model.School_Name; txtDName.Text = model.D_Name; txtDValue.Text = model.D_Value; txtSchoolIP.Text = model.SchoolIP; txtDPublicValue.Text = model.D_PublicValue; ddlDType.SelectedValue = model.D_Type; txtRemark.Text = model.D_Remark; } }
public bool Update(Model_ConfigSchool model) { StringBuilder builder = new StringBuilder(); builder.Append("update ConfigSchool set "); builder.Append("School_ID=@School_ID,"); builder.Append("School_Name=@School_Name,"); builder.Append("D_Name=@D_Name,"); builder.Append("D_Value=@D_Value,"); builder.Append("D_Type=@D_Type,"); builder.Append("D_Remark=@D_Remark,"); builder.Append("D_Order=@D_Order,"); builder.Append("D_CreateTime=@D_CreateTime,"); builder.Append("D_CreateUser=@D_CreateUser,"); builder.Append("D_UpdateTime=@D_UpdateTime,"); builder.Append("D_UpdateUser=@D_UpdateUser,"); builder.Append("D_PublicValue=@D_PublicValue,"); builder.Append("SchoolIP=@SchoolIP,"); builder.Append("Mobile=@Mobile"); builder.Append(" where ConfigEnum=@ConfigEnum "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@School_ID", SqlDbType.VarChar, 50), new SqlParameter("@School_Name", SqlDbType.NVarChar, 250), new SqlParameter("@D_Name", SqlDbType.NVarChar, 100), new SqlParameter("@D_Value", SqlDbType.VarChar, 300), new SqlParameter("@D_Type", SqlDbType.VarChar, 50), new SqlParameter("@D_Remark", SqlDbType.NVarChar, 500), new SqlParameter("@D_Order", SqlDbType.Int, 4), new SqlParameter("@D_CreateTime", SqlDbType.DateTime), new SqlParameter("@D_CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@D_UpdateTime", SqlDbType.DateTime), new SqlParameter("@D_UpdateUser", SqlDbType.Char, 0x24), new SqlParameter("@D_PublicValue", SqlDbType.VarChar, 300), new SqlParameter("@SchoolIP", SqlDbType.VarChar, 300), new SqlParameter("@Mobile", SqlDbType.VarChar, 50), new SqlParameter("@ConfigEnum", SqlDbType.VarChar, 20) }; cmdParms[0].Value = model.School_ID; cmdParms[1].Value = model.School_Name; cmdParms[2].Value = model.D_Name; cmdParms[3].Value = model.D_Value; cmdParms[4].Value = model.D_Type; cmdParms[5].Value = model.D_Remark; cmdParms[6].Value = model.D_Order; cmdParms[7].Value = model.D_CreateTime; cmdParms[8].Value = model.D_CreateUser; cmdParms[9].Value = model.D_UpdateTime; cmdParms[10].Value = model.D_UpdateUser; cmdParms[11].Value = model.D_PublicValue; cmdParms[12].Value = model.SchoolIP; cmdParms[13].Value = model.Mobile; cmdParms[14].Value = model.ConfigEnum; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { int intOrder = 0; int.TryParse(txtDSort.Text, out intOrder); if (string.IsNullOrEmpty(ConfigEnum)) { #region 添加 model = new Model_ConfigSchool(); model.ConfigEnum = txtConfigEnum.Text.Trim(); model.School_ID = hidtxtSchool.Value.Trim(); model.School_Name = txtSchool.Value.Trim(); model.D_Name = txtDName.Text.Trim(); model.D_Value = txtDValue.Text.Trim(); model.D_PublicValue = txtDPublicValue.Text.Trim(); model.D_Type = ddlDType.SelectedValue; model.D_Order = intOrder; model.D_Remark = txtRemark.Text.Trim(); model.D_CreateUser = loginUser.SysUser_ID; model.D_CreateTime = DateTime.Now; model.SchoolIP = txtSchoolIP.Text.Trim(); //验证标识是否已存在 if (bll.GetRecordCount("ConfigEnum='" + txtConfigEnum.Text.Trim() + "'") > 0) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('标识已存在', { time: 2000, icon: 2})</script>"); return; } //验证学校是否已配置某一类型的数据 if (bll.GetRecordCount("School_ID='" + hidtxtSchool.Value.Trim() + "' and D_Type='" + ddlDType.SelectedValue + "'") > 0) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('该学校已添加此类型数据', { time: 2000, icon: 2})</script>"); return; } if (bll.Add(model)) { new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS("90207000", "新增学校配置标识成功"); ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index)});</script>"); return; } #endregion } else { #region 修改 model = bll.GetModel(ConfigEnum); model.School_ID = hidtxtSchool.Value.Trim(); model.School_Name = txtSchool.Value.Trim(); model.D_Name = txtDName.Text.Trim(); model.D_Value = txtDValue.Text.Trim(); model.D_PublicValue = txtDPublicValue.Text.Trim(); model.D_Type = ddlDType.SelectedValue; model.D_Order = intOrder; model.D_Remark = txtRemark.Text.Trim(); model.D_UpdateUser = loginUser.SysUser_ID; model.D_UpdateTime = DateTime.Now; model.SchoolIP = txtSchoolIP.Text.Trim(); //验证学校是否已配置某一类型的数据 if (bll.GetRecordCount("ConfigEnum!='" + txtConfigEnum.Text.Trim() + "' and School_ID='" + hidtxtSchool.Value.Trim() + "' and D_Type='" + ddlDType.SelectedValue + "'") > 0) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('该学校已添加此类型数据', { time: 2000, icon: 2})</script>"); return; } if (bll.Update(model)) { new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS("90207000", "修改学校配置标识成功"); ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>"); } #endregion } } catch (Exception) { new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS("90207000", "操作学校配置标识失败"); ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('操作失败!',{ time: 2000,icon:2},function(){parent.loadData();parent.layer.close(index);});</script>"); } }
public Model_ConfigSchool DataRowToModel(DataRow row) { Model_ConfigSchool school = new Model_ConfigSchool(); if (row != null) { if (row["ConfigEnum"] != null) { school.ConfigEnum = row["ConfigEnum"].ToString(); } if (row["School_ID"] != null) { school.School_ID = row["School_ID"].ToString(); } if (row["School_Name"] != null) { school.School_Name = row["School_Name"].ToString(); } if (row["D_Name"] != null) { school.D_Name = row["D_Name"].ToString(); } if (row["D_Value"] != null) { school.D_Value = row["D_Value"].ToString(); } if (row["D_Type"] != null) { school.D_Type = row["D_Type"].ToString(); } if (row["D_Remark"] != null) { school.D_Remark = row["D_Remark"].ToString(); } if ((row["D_Order"] != null) && (row["D_Order"].ToString() != "")) { school.D_Order = new int?(int.Parse(row["D_Order"].ToString())); } if ((row["D_CreateTime"] != null) && (row["D_CreateTime"].ToString() != "")) { school.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString())); } if (row["D_CreateUser"] != null) { school.D_CreateUser = row["D_CreateUser"].ToString(); } if ((row["D_UpdateTime"] != null) && (row["D_UpdateTime"].ToString() != "")) { school.D_UpdateTime = new DateTime?(DateTime.Parse(row["D_UpdateTime"].ToString())); } if (row["D_UpdateUser"] != null) { school.D_UpdateUser = row["D_UpdateUser"].ToString(); } if (row["D_PublicValue"] != null) { school.D_PublicValue = row["D_PublicValue"].ToString(); } if (row["SchoolIP"] != null) { school.SchoolIP = row["SchoolIP"].ToString(); } if (row["Mobile"] != null) { school.Mobile = row["Mobile"].ToString(); } } return(school); }
public bool Update(Model_ConfigSchool model) { return(this.dal.Update(model)); }
public bool Add(Model_ConfigSchool model) { return(this.dal.Add(model)); }
/// <summary> /// 文件同步 /// </summary> protected void btnDataAnalysis_Click(object sender, EventArgs e) { try { string strDate = txtBeginTime.Text.Trim(); string strSchool = hidtxtSchool.Value.Trim(); string strSchoolExtranet = string.Empty; if (string.IsNullOrEmpty(strDate)) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.closeAll();layer.msg('请选择日期',{icon: 2, time: 2000 });", true); return; } if (string.IsNullOrEmpty(strSchool)) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.closeAll();layer.msg('请选择学校',{icon: 2, time: 2000 });", true); return; } Model_ConfigSchool modelCS = new Model_ConfigSchool(); BLL_ConfigSchool bllCS = new BLL_ConfigSchool(); modelCS = bllCS.GetModelBySchoolId(hidtxtSchool.Value); if (modelCS == null) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.closeAll();layer.msg('学校配置信息不存在',{icon: 2, time: 2000 });", true); return; } else { if (string.IsNullOrEmpty(modelCS.D_PublicValue)) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.closeAll();layer.msg('请配置学校外网IP',{icon: 2, time: 2000 });", true); return; } else { strSchoolExtranet = modelCS.D_PublicValue; } } try { Model_FileSyncRecord modelSync = new Model_FileSyncRecord(); modelSync.FileSyncRecord_Id = Guid.NewGuid().ToString(); modelSync.SyncTime = DateTime.Now; Stopwatch timer = new System.Diagnostics.Stopwatch(); timer.Start(); #region 步 Rc.Model.Resources.Model_SystemLogFileSync model = new Rc.Model.Resources.Model_SystemLogFileSync(); Rc.BLL.Resources.BLL_SystemLogFileSync bll = new Rc.BLL.Resources.BLL_SystemLogFileSync(); model.SystemLogFileSyncID = Guid.NewGuid().ToString(); //model.FileSize = ls; // model.SyncUrl = strFilePath; model.MsgType = "Start"; model.ErrorMark = DateTime.Now.ToString(); model.CreateTime = DateTime.Now; bll.Add(model); //for (int i = 0; i < 30; i++) //{ //string strDate = DateTime.Now.ToString("yyyy-MM-dd"); // Date = DateTime.Now.ToString("yyyy-MM-dd"); //Rc.Model.Resources.Model_SystemLogFileSync model = new Rc.Model.Resources.Model_SystemLogFileSync(); // Rc.BLL.Resources.BLL_SystemLogFileSync bll = new Rc.BLL.Resources.BLL_SystemLogFileSync(); model.SystemLogFileSyncID = Guid.NewGuid().ToString(); //model.FileSize = ls; // model.SyncUrl = strFilePath; model.MsgType = "Start"; model.ErrorMark = strDate; model.CreateTime = DateTime.Now; bll.Add(model); strLog = new StringBuilder(); //同步文件 if (ddlType.SelectedValue == "1")//教案 { ResSynchroTeachingPlan(strSchoolExtranet, strDate, strSchool); ResSynchroTeachingPlanView(strSchoolExtranet, strDate, strSchool); } else if (ddlType.SelectedValue == "2")//习题集 { ResSynchroTest(strSchoolExtranet, strDate, strSchool); } else { ResSynchroTeachingPlan(strSchoolExtranet, strDate, strSchool); ResSynchroTeachingPlanView(strSchoolExtranet, strDate, strSchool); ResSynchroTest(strSchoolExtranet, strDate, strSchool); } model.SystemLogFileSyncID = Guid.NewGuid().ToString(); //model.FileSize = ls; // model.SyncUrl = strFilePath; model.MsgType = "End"; // model.ErrorMark = ex.Message; model.CreateTime = DateTime.Now; bll.Add(model); //} #endregion timer.Stop(); string lenght = timer.Elapsed.ToString(); modelSync.SyncUserId = loginUser.SysUser_ID; modelSync.SyncUserName = loginUser.SysUser_Name == "" ? loginUser.SysUser_LoginName : loginUser.SysUser_Name; modelSync.SyncLong = lenght; modelSync.SyncType = FileSyncType.SyncSchool.ToString(); if (new BLL_FileSyncRecord().Add(modelSync)) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.closeAll();layer.msg('文件同步成功',{icon: 1, time: 1000 },function(){loadData();});", true); return; } else { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.closeAll();layer.msg('文件同步失败',{icon: 2, time: 2000 });", true); return; } } catch (Exception ex) { Rc.Model.Resources.Model_SystemLogFileSync model = new Rc.Model.Resources.Model_SystemLogFileSync(); Rc.BLL.Resources.BLL_SystemLogFileSync bll = new Rc.BLL.Resources.BLL_SystemLogFileSync(); model.SystemLogFileSyncID = Guid.NewGuid().ToString(); //model.FileSize = ls; // model.SyncUrl = strFilePath; model.MsgType = "Error"; model.ErrorMark = ex.Message; model.CreateTime = DateTime.Now; bll.Add(model); throw; } } catch (Exception ex) { new BLL_clsAuth().AddLogErrorFromBS("文件同步失败:", string.Format("类:{0},方法{1},错误信息:{2}", ex.TargetSite.DeclaringType.ToString() , ex.TargetSite.Name.ToString(), ex.Message)); ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.closeAll();layer.msg('文件同步失败,出现异常',{icon: 2, time: 2000 });", true); } }