protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() == "") { ComTool.Alert("请输入设备编号"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入管理员姓名!"); } else if (TextBox3.Text.Trim() == "") { ComTool.Alert("请输入维修日期!"); } else { Equiprecord obj = new Equiprecord(); obj.equipid = Convert.ToInt64(TextBox1.Text); obj.adminname = TextBox2.Text; obj.recorddate = DateTime.Parse(TextBox3.Text); if (Equiprecord.insertRecord(obj) == 1) { ComTool.Alert("新增成功!"); ComTool.Redirect("recordview.aspx"); } else { ComTool.Alert("新增失败!"); } } }
void Duplicate() { prefab = transform.GetChild(0); var cs = transform.GetChildsL1(); for (int c = 1; c < cs.Count; c++) { cs[c].SetParent(null, false); ComTool.DestroyAuto(cs[c].gameObject); } var os = offset + (prefab as RectTransform).rect.size; int i = 0; foreach (var txt in txts) { if (i == 0) { i++; prefab.GetComponentInChildren <Text>().text = txt; continue; } var t = Instantiate(prefab, transform, true); t.GetComponentInChildren <Text>().text = txt; var rt = (t as RectTransform); rt.anchoredPosition += os * i++ *factor; } }
protected void Button1_Click(object sender, EventArgs e) { if (tbxManagerName.Text.Trim() == "") { ComTool.Alert("请输入用户名!"); } else if (tbxManagerPWD.Text.Trim() == "") { ComTool.Alert("请输入密码!"); } else if (tbxManagerTel.Text.Trim() == "") { ComTool.Alert("请输入联系方式!"); } else { Manager obj = new Manager(); obj.managername = tbxManagerName.Text; obj.managerpwd = tbxManagerPWD.Text; obj.telephone = tbxManagerTel.Text; if (Manager.selectDataTable(obj).Rows.Count == 0 && Manager.insertRecord(obj) == 1) { ComTool.Alert("注册成功!"); ComTool.Redirect("DefaultM.aspx"); } else { ComTool.Alert("用户名已存在!"); } } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string j = GridView1.DataKeys[e.RowIndex].Value.ToString(); string sqlstr = "delete from magazine where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; string sqlstr1 = "delete from article where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; string sqlstr2 = "delete from upImage where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; string sqlstr3 = "select* from upImage where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; DataTable dt = DBOper.execQueryBySQLText(sqlstr3); for (int k = 0; k < dt.Rows.Count; k++) { string path1 = dt.Rows[k]["savepath"].ToString(); File.Delete(path1); } int i = DBOper.execNonQueryBySQLText(sqlstr2); i = DBOper.execNonQueryBySQLText(sqlstr1); if (DBOper.execNonQueryBySQLText(sqlstr) == 1) { BindData(searchCon()); } else { ComTool.Alert("删除失败"); } string dePath = "./image/" + j + "/"; string path = Server.MapPath(dePath); Directory.Delete(path); }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() == "") { ComTool.Alert("请输入设备编号!"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入设备状态!"); } else { huiyi obj = new huiyi(); obj.huiyiname = TextBox1.Text; obj.yuyue = TextBox2.Text; if (huiyi.updateRecord(obj) == 1) { ComTool.Alert("更新成功!"); ComTool.Redirect("huiyiListListM.aspx"); } else { ComTool.Alert("更新失败!"); } } }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() == "") { ComTool.Alert("请输入设备编号!"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入设备状态!"); } else { Equip obj = new Equip(); obj.equipcode = TextBox1.Text; obj.status = TextBox2.Text; if (Equip.updateRecord(obj) == 1) { ComTool.Alert("更新成功!"); ComTool.Redirect("EquipListM.aspx"); } else { ComTool.Alert("更新失败!"); } } }
protected void Button1_Click(object sender, EventArgs e) { if (tbxUserName.Text.Trim() == "") { ComTool.Alert("请输入用户名!"); } else if (tbxUserPWD.Text.Trim() == "") { ComTool.Alert("请输入密码!"); } else { Users obj = new Users(); obj.username = tbxUserName.Text; obj.userpwd = tbxUserPWD.Text; if (Users.selectDataTable(obj).Rows.Count == 0 && Users.insertRecord(obj) == 1) { ComTool.Alert("注册成功!"); ComTool.Redirect("Default.aspx"); } else { ComTool.Alert("用户名已存在!"); } } }
void ClearMeshColliders() { foreach (var mc in GetComponentsInChildren <MeshCollider>(true)) { ComTool.DestroyAuto(mc); } }
protected void B1Click(object sender, EventArgs e) { if (hyname.Text.Trim() == "") { ComTool.Alert("请输入会议室名!"); } else if (shijian.Text.Trim() == "") { ComTool.Alert("请输入预约时间 !"); } else { yuyuehuiyi obj = searchCon(); if (obj.yuyue == "0") { int i = yuyuehuiyi.insertshenqingRecord(obj); if (i != 0) { ComTool.Alert("预约单提交成功!等待管理员审核!"); ComTool.Redirect("huiyiList.aspx"); } else { ComTool.Alert("预约单提交失败!请再次提交!"); } } else { ComTool.Alert("会议室已被他人预约!"); } } }
/// <summary> /// 下载资源包 /// </summary> /// <param name="data"></param> /// <returns></returns> private IEnumerator DownloadAssetBundle(VersionAssetData data) { string loadPath = GetAssetServerPath(data.path, data.md5); WWW www = new WWW(ComTool.FormatTickUrl(loadPath)); yield return(www); if (www.error != null) { Debug.LogError("DownloadAssetBundle Error:" + data.name); SendErrorCode(404); } else { if (CheckDataValid(data, www.bytes)) { WriteAssetOnLocal(data, www.bytes); } else { Debug.LogError("CheckDataValid false:" + data.name); } } www.Dispose(); }
/// <summary> /// 更新版本资源 /// </summary> /// <returns></returns> private IEnumerator OnUpdateVersionRes() { if (m_LocalRVLDic == null) { yield return(StartCoroutine(ParserLocalRVL())); } ///>获取服务器资源版本数据 string path = m_ServerResRootPath + "/" + RVL; WWW serverWWW = new WWW(ComTool.FormatTickUrl(path)); yield return(serverWWW); if (serverWWW.error != null) { SendErrorCode(100); } m_ServerRVLDic = ParserResVersionList(serverWWW.text, ref m_ServerVersion); serverWWW.Dispose(); yield return(StartCoroutine(CompareWithRVL())); ///>是否需要更新资源 if (m_UpdateResList != null && m_UpdateResList.Count > 0) { if (CheckUpdateEvent != null) { CheckUpdateEvent(true); } } else { EndUpdate(); } }
protected void Button1_Click(object sender, EventArgs e) { if (tbxUserName.Text.Trim() == "") { ComTool.Alert("请输入用户名!"); } else if (tbxUserPWD.Text.Trim() == "") { ComTool.Alert("请输入密码!"); } else { Users obj = new Users(); obj.username = tbxUserName.Text; obj.userpwd = tbxUserPWD.Text; if (Users.insertRecord(obj) == 1) { ComTool.Alert("新增成功!"); } else { ComTool.Alert("新增失败!"); } } }
protected void Button1_Click(object sender, EventArgs e) { if (tbxUserName.Text.Trim() == "") { ComTool.Alert("请输入会议室名称!"); } else if (tbxUserPWD.Text.Trim() == "") { ComTool.Alert("请输入会议室位置!"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入会议室状态!"); } else { huiyi obj = new huiyi(); obj.huiyiname = tbxUserName.Text; obj.didian = tbxUserPWD.Text; obj.yuyue = TextBox2.Text; if (huiyi.insertRecord(obj) == 1) { ComTool.Alert("新增成功!"); ComTool.Redirect("huiyiListM.aspx"); } else { ComTool.Alert("新增失败!"); } } }
public void Clear() { foreach (var u in units) { ComTool.DestroyAuto(u.go); } units.Clear(); }
public void TestMethod1() { var datastr = "{'tablename':'xs_zdjbxx','wheret':'ysdm=^666666^'}"; var datastr1 = "Ëwı²¼µ¾±½µwwÈïʴº²ÈÈw|wǸµÂµÄwwÉô½®®wÍ"; var key = "PGY"; var r1 = ComTool.CustomDecryption(datastr, key, false); var r2 = ComTool.CustomDecryption(r1, key, true); Assert.IsTrue(r1 == r2); }
private byte[] result; //字节流 public override void OnBackGroundExcuteEnd() { result = GetBuffer(); if (IsSuccess()) { if (versionEnum != DBVersionEnum.None) { //不是最新的 ComTool.WriteFile(localPath, result); //写入本地 } } }
public void OnEnable() { //if (transform.childCount > 1) return; // 是否已经提前初始化 prefab = transform.GetChild(0); foreach (var child in transform.GetChildsL1()) { if (child != prefab) { child.SetParent(null, false);// UI.Root; ComTool.DestroyAuto(child.gameObject); } } prefab.gameObject.SetActive(true); var os = offset + (prefab as RectTransform).rect.size * factor; btns = new List <GameObject>(); clickable = new List <bool>(); int i = 0; foreach (var btn in buttons) { var t = Instantiate(prefab, transform, true); btns.Add(t.gameObject); clickable.Add(true); (t as RectTransform).anchoredPosition += os * i; t.GetComponentInChildren <Text>().text = btn; var img = t.GetComponent <Image>(); var n = i++; var mw = t.AddComponent <MouseEventWrapper>(); img.color = (i - 1) == idx ? colorDown : colorNormal; mw.onMouseDown = () => { foreach (var b in btns) { b.GetComponent <Image>().color = colorNormal; } idx = n; img.color = colorDown; ItemClick(n); }; mw.onMouseEnter = () => { if (n != idx) { img.color = colorOver; } }; mw.onMouseExit = () => { if (n != idx) { img.color = colorNormal; } }; //mw.onMouseUp = () => { img.color = mw.over ? colorOver : colorNormal; }; mw.CreateBox2D(); } prefab.gameObject.SetActive(false); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string str = "delete from users where userId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; if (DBOper.execNonQueryBySQLText(str) == 1) { BindData(searchCon()); } else { ComTool.Alert("删除失败"); } }
protected void Button1_Click(object sender, EventArgs e) { Users obj = new Users(); obj.username = TextBox1.Text; obj.userpwd = TextBox2.Text; if (Users.ifLogin(obj)) { ComTool.Redirect("UsersList.aspx"); } else { ComTool.Alert("用户名或密码错误!"); } }
public object GetAct() { var type = (ComEnum.ActEnum)Type; object obj = null; Data = ComTool.CustomDecryption(Data.ToString(), ComWebSetting.AppSetingConfig["Key"], true, Data.ToString().Length % (ComWebSetting.KEY.Length % 5)); var SQl = Data.ToString().Replace("~", "\\\"").Replace("^", "\\\'");//~双引号 ^单引号 switch (type) { case ComEnum.ActEnum.Select: //查尽量带t {"Type":"1","Data":"{'tablename':'xs_zdjbxx t','fields':'zl,ysdm','WhereT':'t.zddm=^610821104200GB00039^','Orderby':'t.bsm'}"} obj = JsonConvert.DeserializeObject <ActSelect>(SQl); break; case ComEnum.ActEnum.Insert: //增values不加引号 {"Type":"2","Data":"{'tablename':'xs_zdjbxx','fields':'zl,ysdm','values':'神木县大柳塔镇光明路66666,666666'}"} obj = JsonConvert.DeserializeObject <ActInsert>(SQl); break; case ComEnum.ActEnum.Update: //更新values不加引号 {"Type":"3","Data":"{'tablename':'xs_zdjbxx t','fields':'zl,ysdm','values':'神木县大柳塔镇光明路,6001010001','WhereT':'t.zddm=^610821104200GB00039^'}"} obj = JsonConvert.DeserializeObject <ActUpdate>(SQl); break; case ComEnum.ActEnum.Delete: //删除 {"Type":"4","Data":"{'tablename':'xs_zdjbxx','wheret':'ysdm=^666666^'}"} obj = JsonConvert.DeserializeObject <ActDelete>(SQl); break; case ComEnum.ActEnum.Other: //多条不用begin不行 {"Type":"5","Data":"begin update xs_zdjbxx set zl=zl||'1' where zddm='610821104200GB00030';update xs_zdjbxx set zl=zl||'2' where zddm='610821104200GB00031'; end;"} obj = Data.ToString(); break; case ComEnum.ActEnum.SelectPageProc: obj = JsonConvert.DeserializeObject <PageParam>(SQl); break; case ComEnum.ActEnum.Proc: //注意sql用select *时 一定要带别名 t.* /*{"Type":"6","Data":{"ProcName":"Pager","Param":[{"ParamName":"datasql","DbType":"varchar2","Direction":"in","Value":"select t.* from manage_user t"},{"ParamName":"pagesize","DbType":"int32","Direction":"in","Value":"5"},{"ParamName":"currtpage","DbType":"int32","Direction":"in","Value":"1"},{"ParamName":"pagenum","DbType":"int32","Direction":"out","Value":""},{"ParamName":"numcount","DbType":"int32","Direction":"out","Value":""},{"ParamName":"v_cur","DbType":"cursor","Direction":"out","Value":""}],"IsRetTable":"True"}}*/ obj = JsonConvert.DeserializeObject <ComProcParam>(SQl); break; } return(obj); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string str = "delete from upImage where imageId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; string str1 = "select * from upImage where imageId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; DataTable dt = DBOper.execQueryBySQLText(str1); string path = dt.Rows[0]["savepath"].ToString(); if (DBOper.execNonQueryBySQLText(str) == 1) { BindData(searchCon()); } else { ComTool.Alert("删除失败"); } File.Delete(path); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string sqlstr = "update users set username='******',password='******' where userId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; if (DBOper.execNonQueryBySQLText(sqlstr) == 1) { GridView1.EditIndex = -1; BindData(searchCon()); } else { ComTool.Alert("更新失败"); } }
protected void Button1_Click(object sender, EventArgs e) { myUser obj = new myUser(); obj.username = UserName.Text.Trim(); obj.userkey = Password.Text.Trim(); obj.userphone = Phone.Text.Trim(); if (myUser.selectDataTable(obj).Rows.Count != 0) { ComTool.Alert("注册失败,该用户名已存在!"); } else if (myUser.insertRecord(obj) == 1) { ComTool.Alert("注册成功!"); ComTool.Redirect(" Default.aspx"); } }
protected void gvcourse_RowCommand(object sender, GridViewCommandEventArgs e) { roomBook obj = new roomBook(); int i = roomBook.updateRecord(" update roombook set review='true' where bookid=" + e.CommandArgument.ToString()); int j = roomBook.updateRecord(" update roombook set adminname='管理员' where bookid=" + e.CommandArgument.ToString()); if (i == 1 & j == 1) { ComTool.Alert("审核成功!"); BindData1(); ComTool.Redirect("bookreview.aspx"); } else { ComTool.Alert("审核失败!"); ComTool.Redirect("bookreview.aspx"); } }
protected void btnlook_Click(object sender, EventArgs e) { string sqllookupT = "select TValue from 汇总表"; DataTable DTC = DBOper.execQueryBySQLText(sqllookupT); if (DTC.Rows.Count > 0) { txtteacher.Text = DTC.Rows[0]["TValue"].ToString(); } string sqllookupS = "select SValue from 汇总表"; DataTable DSUC = DBOper.execQueryBySQLText(sqllookupS); if (DSUC.Rows.Count > 0) { txtstudent.Text = DSUC.Rows[0]["SValue"].ToString(); } ComTool.Alert("第" + txtgroup.Text + "组的教师评委评分为:" + txtteacher.Text + "第" + txtgroup.Text + "组的学生评委评分为:" + txtstudent.Text); }
protected void Button1_Click(object sender, EventArgs e) { if (UserName.Text.Trim() == "") { ComTool.Alert("请输入用户名!"); } else if (Password.Text.Trim() == "") { ComTool.Alert("请输入密码!"); } else { if (Int32.Parse(DropDownList1.SelectedItem.Value) == 0) { Admin obj = new Admin(); obj.adminname = UserName.Text; obj.adminkey = Password.Text; if (Admin.ifLogin(obj)) { ComTool.Alert("登陆成功!"); ComTool.Redirect("aroomstate.aspx"); } else { ComTool.Alert("登陆失败!"); } } else if (Int32.Parse(DropDownList1.SelectedItem.Value) == 1) { myUser obj = new myUser(); obj.username = UserName.Text; obj.userkey = Password.Text; if (myUser.ifLogin(obj)) { ComTool.Alert("登陆成功!"); ComTool.Redirect("uroomstate.aspx"); } else { ComTool.Alert("登陆失败!"); } } } }
protected void Button1_Click(object sender, EventArgs e) { Users obj = new Users(); obj.username = TextBox1.Text; obj.userpwd = TextBox2.Text; if (Users.ifLogin(obj)) { ComTool.Redirect("ManagerList.aspx"); } else if (Users.selectDataTable(obj).Rows.Count == 0) { ComTool.Alert("用户名未注册,请先注册!"); } else { ComTool.Alert("密码错误!"); } }
protected void ADSubmit_Click(object sender, EventArgs e) { if (txtADRID.Text.Trim() == "" || txtADRPwd.Text.Trim() == "" || txtADRPwdAgain.Text.Trim() == "") { ComTool.Alert("请输入全部注册信息后点击登录!"); } else if (txtADRPwd.Text.Trim() != txtADRPwdAgain.Text.Trim()) { ComTool.Alert("您两次输入密码不一致,请重新输入!"); } else { string strSQL = "insert into 管理员表(AdminID,AdminPwd) values('" + txtADRID.Text + "','" + txtADRPwd.Text + "')"; if (DBOper.execNonQueryBySQLText(strSQL) == 1)//调用公共类 { ComTool.Redirect("AdminLogin.aspx"); } } }
protected void btnScoreAgain_Click(object sender, EventArgs e) { string STRC = ""; string strSQL = "select TransID from 传值表"; DataTable DDT = DBOper.execQueryBySQLText(strSQL); if (DDT.Rows.Count > 0) { STRC = DDT.Rows[0]["TransID"].ToString(); } if (STRC == txtgroup.Text) { ComTool.Alert("尚未创建新组,请稍后!"); } else { ComTool.Redirect("Score.aspx?A=" + txtCNO.Text); } }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() == "") { ComTool.Alert("请输入文章编号!"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入文章名称!"); } else if (TextBox4.Text.Trim() == "") { ComTool.Alert("请输入作者!"); } else if (TextBox6.Text.Trim() == "") { ComTool.Alert("请输入权限!"); } else if (DropDownList1.SelectedValue.Trim() == "") { ComTool.Alert("请输入期刊编号!"); } else { Article obj = new Article(); obj.articleId = TextBox1.Text; obj.articleName = TextBox2.Text; obj.articleKey = TextBox3.Text; obj.author = TextBox4.Text; obj.adescription = TextBox5.Text; obj.limits = TextBox6.Text; obj.magazineId = DropDownList1.SelectedValue; if (Article.insertRecord(obj) == 1) { ComTool.Alert("新增成功!"); } else { ComTool.Alert("新增失败!"); } } }