/// <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);
}
}
