/// <summary> /// 编辑数据 /// </summary> /// <returns></returns> private string editData() { string lb = getUTF8ToString("lb"); if (lb == "readWords" || lb == "hisWords")//文件,历史词汇 { return("false"); } string oid = getUTF8ToString("oid"); string text = getUTF8ToString("text"); try { DefVal dv = new DefVal(); dv.RetrieveByAttr(DefValAttr.OID, oid); dv.CurValue = text; dv.Update(); return("true"); } catch (Exception) { return("false"); } }
/// <summary> /// 根据oid删除 /// </summary> /// <returns></returns> private string deleteData() { string oids = getUTF8ToString("oids"); if (string.IsNullOrEmpty(oids)) { return("false"); } string lb = getUTF8ToString("lb"); if (lb == "readWords" || lb == "hisWords") { return("false"); } try { string[] oidsArray = oids.Split(','); foreach (string oid in oidsArray) { if (string.IsNullOrEmpty(oid)) { continue; } DefVal dv = new DefVal(); dv.RetrieveByAttr(DefValAttr.OID, oid); dv.Delete(); } return("true"); } catch (Exception) { return("false"); } }
//获取数据 private string getData() { DefVal dv = new DefVal(); dv.CheckPhysicsTable(); string enName = getUTF8ToString("FK_MapData"); string AttrKey = getUTF8ToString("AttrKey"); string lb = getUTF8ToString("lb"); if (lb == "readWords")//读取txt文件 { return(readTxt()); } try { DataTable dt = new DataTable(); string sql = ""; string addQue = "";//公用sql查询条件 addQue = " and FK_MapData='" + enName + "' and AttrKey='" + AttrKey + "'"; if (lb == "myWords")//我的词汇 { sql = "select * from sys_defval where LB='1' and FK_Emp='" + WebUser.No + "'" + addQue; } if (lb == "hisWords")//历史词汇 { sql = "select * from sys_defval where LB='2' and FK_Emp='" + WebUser.No + "'" + addQue; } if (lb == "sysWords")//系统词汇 { switch (DBAccess.AppCenterDBType) { case DBType.Oracle: sql = "select * from sys_defval where LB='3' and FK_Emp is null" + addQue; break; case DBType.MSSQL: sql = "select * from sys_defval where LB='3' and FK_Emp=''" + addQue; break; } } string pageNumber = getUTF8ToString("pageNumber"); int iPageNumber = string.IsNullOrEmpty(pageNumber) ? 1 : Convert.ToInt32(pageNumber); //每页多少行 string pageSize = getUTF8ToString("pageSize"); int iPageSize = string.IsNullOrEmpty(pageSize) ? 9999 : Convert.ToInt32(pageSize); switch (DBAccess.AppCenterDBType) { case DBType.Oracle: case DBType.MSSQL: return(DBPaging("(" + sql + ")sqlStr", iPageNumber, iPageSize, "OID", "OID")); case DBType.MySQL: return(DBPaging("(" + sql + " order by OID DESC )sqlStr", iPageNumber, iPageSize, "OID", "")); default: throw new Exception("暂不支持您的数据库类型."); } } catch (Exception) { return(""); } }
/// <summary> /// 添加数据 /// </summary> /// <returns></returns> private string addData() { string lb = getUTF8ToString("lb"); if (lb == "readWords" || lb == "hisWords")//文件,历史词汇 { return("false"); } string text = getUTF8ToString("text"); text = DataTableConvertJson.GetFilteredStrForJSON(text); if (string.IsNullOrEmpty(text)) { return("false"); } string enName = getUTF8ToString("FK_MapData"); string AttrKey = getUTF8ToString("AttrKey"); string lbStr = ""; string fk_emp = ""; if (lb == "myWords")//我的词汇 { lbStr = "1"; fk_emp = WebUser.No; } if (lb == "sysWords")//系统词汇 { lbStr = "3"; fk_emp = ""; } string addQue = " and FK_MapData='" + enName + "' and AttrKey='" + AttrKey + "' and CurValue='" + text + "'"; string sql = "select * from sys_defval where LB='" + lbStr + "' and FK_Emp='" + fk_emp + "'" + addQue; if (DBAccess.RunSQLReturnCOUNT(sql) != 0) { return("false"); } try { DefVal dv = new DefVal(); dv.FK_MapData = enName; dv.AttrKey = AttrKey; dv.LB = lbStr; dv.FK_Emp = fk_emp; dv.CurValue = text; dv.Insert(); } catch { DefVal dv = new DefVal(); dv.RunSQL("drop table Sys_DefVal"); dv.CheckPhysicsTable(); } return("true"); }
/// <summary> /// 保存历史数据 /// </summary> /// <returns></returns> private string saveHistoryData() { string lb = getUTF8ToString("lb"); if (lb == "readWords" || lb == "hisWords") { return("false"); } string enName = getUTF8ToString("FK_MapData"); string AttrKey = getUTF8ToString("AttrKey"); string str = getUTF8ToString("str"); string sql = "select * from sys_defval where LB='2' and FK_Emp='" + WebUser.No + "' and FK_MapData='" + enName + "' and AttrKey='" + AttrKey + "' and CurValue='" + str + "'"; if (DBAccess.RunSQLReturnCOUNT(sql) != 0)//禁止添加重复数据 { return("false"); } sql = "select * from sys_defval where LB='2' and FK_Emp='" + WebUser.No + "' and FK_MapData='" + enName + "' and AttrKey='" + AttrKey + "'"; DataTable dt = DBAccess.RunSQLReturnTable(sql); DefVal dv = new DefVal(); if (dt.Rows.Count == 50)//动态更新数据,限制50条 { try { int minOid = int.Parse(dt.Rows[0]["OID"].ToString()); foreach (DataRow dr in dt.Rows) { int drOid = int.Parse(dr["OID"].ToString()); if (minOid > drOid) { minOid = drOid; } } dv = new DefVal(); dv.RetrieveByAttr(DefValAttr.OID, minOid); dv.Delete(); } catch (Exception) { if (dt.Rows.Count != 0) { return("false"); } } } dv = new DefVal(); dv.FK_MapData = enName; dv.AttrKey = AttrKey; dv.LB = "2"; dv.FK_Emp = WebUser.No; dv.CurValue = str; dv.Insert(); return("true"); }
private void BPToolBar2_ButtonClick(object sender, System.EventArgs e) { try { ToolbarBtn btn = (ToolbarBtn)sender; DefVal en = new DefVal(); QueryObject qo = new QueryObject(en); // BP.En.Entity enDA = DA.ClassFactory.GetEn(this.EnsName); switch (btn.ID) { case NamesOfBtn.Cancel: this.WinClose(); break; case "Btn_SaveToMyDefaultValues": if (AttrKeyValue.Trim().Length == 0) { throw new Exception("@默认值不能为空。"); } en.FK_Emp = WebUser.No; en.EnsName = this.EnsName; en.AttrKey = this.AttrKey; en.Val = this.AttrKeyValue; qo.AddWhere(DefValAttr.FK_Emp, en.FK_Emp); qo.addAnd(); qo.AddWhere(DefValAttr.AttrKey, en.AttrKey); qo.addAnd(); qo.AddWhere(DefValAttr.EnsName, en.EnsName); qo.addAnd(); qo.AddWhere(DefValAttr.Val, en.Val); if (qo.DoQuery() == 0) { en.Insert(); } this.SetDGData(); this.ResponseWriteBlueMsg_SaveOK(); break; case "Btn_SaveToAppDefaultValues": if (AttrKeyValue.Trim().Length == 0) { throw new Exception("@默认值不能为空。"); } en.FK_Emp = "0"; en.EnsName = this.EnsName; en.AttrKey = this.AttrKey; en.Val = this.AttrKeyValue; qo.AddWhere(DefValAttr.FK_Emp, en.FK_Emp); qo.addAnd(); qo.AddWhere(DefValAttr.AttrKey, en.AttrKey); qo.addAnd(); qo.AddWhere(DefValAttr.EnsName, en.EnsName); qo.addAnd(); qo.AddWhere(DefValAttr.Val, en.Val); if (qo.DoQuery() == 0) { en.Insert(); } this.SetDGData(); this.ResponseWriteBlueMsg_SaveOK(); break; case NamesOfBtn.Confirm: this.Confirm(); break; default: throw new Exception("没有处理的控件" + btn.ID); } } catch (Exception ex) { this.ResponseWriteRedMsg(ex); } }
private void BPToolBar1_ButtonClick(object sender, System.EventArgs e) { try { string id = ""; try { ToolbarBtn btn = (ToolbarBtn)sender; id = btn.ID; } catch { if (this.CurrentSelectedCheckButton.Index == 2) { this.BPToolBar1.GetBtnByKey(NamesOfBtn.Delete).Enabled = false; } else { this.BPToolBar1.GetBtnByKey(NamesOfBtn.Delete).Enabled = true; } this.SetDGData(); return; } switch (id) { case NamesOfBtn.Update: if (AttrKeyValue == null || AttrKeyValue == "") { throw new Exception("@默认值不能为空."); } //DBAccess.RunSQL("update Sys_UIDefaultValue set DefaultVal='"+this.AttrKeyValue+"' WHERE EnsName='"+this.EnsName+"' AND AttrKey='"+this.AttrKey+"' AND DefaultVal='"+this.DG1.CurrendSelectedNo+"'" ); this.ResponseWriteBlueMsg_UpdataOK(); this.SetDGData(); break; case NamesOfBtn.Confirm: this.Confirm(); break; case NamesOfBtn.Close: this.WinClose(); break; case NamesOfBtn.Delete: if (this.CurrentSelectedCheckButton.Index == 0) { foreach (ListItem li in this.CBL1.Items) { if (li.Selected == false) { continue; } BP.Sys.DefVal dv = new DefVal(); dv.Delete(DefValAttr.Val, li.Text, DefValAttr.EnsName, this.EnsName, DefValAttr.FK_Emp, this.FK_Emp); } } else { foreach (ListItem li in this.CBL1.Items) { if (li.Selected == false) { continue; } BP.Sys.DefVal dv = new DefVal(); dv.Delete(DefValAttr.Val, li.Text, DefValAttr.EnsName, this.EnsName, DefValAttr.FK_Emp, "0"); // DBAccess.RunSQL("DELETE FROM Sys_UIDefaultValue WHERE DefaultVal='" + li.Text + "' AND ENSCLASSNAME='" + this.EnsName + "' AND AttrKey='" + this.AttrKey + "' AND No='0'"); } } this.ResponseWriteBlueMsg_DeleteOK(); this.SetDGData(); break; case NamesOfBtn.New: //this.DG1.SelectedIndex =-1; this.TB_Key.Text = ""; break; case NamesOfBtn.Help: this.Helper(); break; default: this.SetDGData(); break; } } catch (Exception ex) { this.Response.Write(ex.Message); //this.ResponseWriteRedMsg(ex); } }