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("新增失败！");
}
}
}
