/// <summary>
/// 数据源
/// </summary>
/// <param name="attrs">数据字符串，规则如下:
/// <para>1.每个字段间用 ^ 来分隔</para>
/// <para>2.字段的信息间用 ~ 来分隔</para>
/// <para>3.字段的信息分别为：英文名称，中文名称，数据类型，最大长度，逻辑类型，序号</para>
/// </param>
/// <param name="tableName">数据表名称</param>
public void InitMapAttr(string tableName, string attrs)
{
Pub1.AddEasyUiPanelInfo("发送信息", attrs);
return;
//删除有可能存在的临时数据.
string tempStr = tableName + "Tmp";
MapAttr ma = new MapAttr();
ma.Delete(MapAttrAttr.FK_MapData, tempStr);
string[] strs = attrs.Split('^');
foreach (string str in strs)
{
if (string.IsNullOrEmpty(str))
{
continue;
}
string[] mystrs = str.Split('~');
ma = new MapAttr();
ma.KeyOfEn = mystrs[0];
ma.Name = mystrs[1];
ma.FK_MapData = tempStr;
ma.MyDataType = int.Parse(mystrs[2]);
ma.MaxLen = int.Parse(mystrs[3]);
ma.LGType = (BP.En.FieldTypeS) int.Parse(mystrs[4]);
ma.Idx = int.Parse(mystrs[5]);
ma.MyPK = tempStr + "_" + ma.KeyOfEn;
ma.Insert();
}
}
public string SaveFKField(string fk_mapData, string fieldKey, string fieldName, string enName, double x, double y)
{
try
{
MapAttr attr = new MapAttr();
attr.MyPK = fk_mapData + "_" + fieldKey;
if (attr.IsExits == true)
{
return("字段{" + fieldKey + "}已经存在.");
}
attr.FK_MapData = fk_mapData;
attr.KeyOfEn = fieldKey;
attr.Name = fieldName;
attr.MyDataType = DataType.AppString;
attr.X = float.Parse(x.ToString());
attr.Y = float.Parse(y.ToString());
attr.UIBindKey = enName;
attr.UIContralType = UIContralType.DDL;
attr.LGType = FieldTypeS.FK;
attr.Insert();
return("OK");
}
catch (Exception ex)
{
return("@错误信息:" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//this.Response.Write(this.Request.RawUrl);
this.Title = "编辑枚举类型"; // "编辑枚举类型";
MapAttr attr = null;
if (this.RefNo == null)
{
attr = new MapAttr();
string enumKey = this.Request.QueryString["EnumKey"];
if (enumKey != null)
{
SysEnumMain se = new SysEnumMain(enumKey);
attr.KeyOfEn = enumKey;
attr.UIBindKey = enumKey;
attr.Name = se.Name;
attr.Name = se.Name;
}
}
else
{
attr = new MapAttr(this.RefNo);
}
BindEnum(attr);
}
/// <summary>
/// 生成列的计算
/// </summary>
/// <param name="pk"></param>
/// <param name="attrs"></param>
/// <param name="attr"></param>
/// <returns></returns>
public string GenerAutoFull(string pk, MapAttrs attrs, MapAttr attr)
{
try
{
string left = "\n document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + attr.KeyOfEn + "_" + pk).ClientID + ".value = ";
string right = attr.AutoFullDoc;
foreach (MapAttr mattr in attrs)
{
string tbID = "TB_" + mattr.KeyOfEn + "_" + pk;
TextBox tb = this.Pub1.GetTextBoxByID(tbID);
if (tb == null)
{
continue;
}
right = right.Replace("@" + mattr.Name, " parseFloat( document.forms[0]." + this.Pub1.GetTextBoxByID(tbID).ClientID + ".value.replace( ',' , '' ) ) ");
right = right.Replace("@" + mattr.KeyOfEn, " parseFloat( document.forms[0]." + this.Pub1.GetTextBoxByID(tbID).ClientID + ".value.replace( ',' , '' ) ) ");
}
string s = left + right;
s += "\t\n document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + attr.KeyOfEn + "_" + pk).ClientID + ".value= VirtyMoney(document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + attr.KeyOfEn + "_" + pk).ClientID + ".value ) ;";
return(s += " C" + attr.KeyOfEn + "();");
}
catch (Exception ex)
{
this.Alert(ex.Message);
return("");
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region 处理活动.
switch (this.Request.QueryString["ActionType"])
{
case "Left":
MapAttr attr = new MapAttr(this.FK_MapAttr);
attr.DoUp();
break;
case "Right":
MapAttr attrR = new MapAttr(this.FK_MapAttr);
attrR.DoDown();
break;
default:
break;
}
#endregion 处理活动.
MapAttrs attrs = new MapAttrs(this.RptNo);
this.Pub2.AddTable("align=left");
this.Pub2.AddCaptionLeft("列表字段显示顺序- 移动箭头改变顺序");
this.Pub2.AddTR();
this.Pub2.AddTDTitle("序");
int idx = -1;
string tKey = DateTime.Now.ToString("HHmmddss");
foreach (MapAttr attr in attrs)
{
idx++;
this.Pub2.Add("<TD class=Title>");
if (idx != 0)
{
this.Pub2.Add("<a href=\"javascript:DoLeft('" + FK_Flow + "','" + this.RptNo + "','" + attr.MyPK + "','" + tKey + "')\" ><img src='/WF/Img/Arr/Arrowhead_Previous_S.gif' ></a>");
}
this.Pub2.Add(attr.Name);
this.Pub2.Add("<a href=\"javascript:DoRight('" + FK_Flow + "','" + this.RptNo + "','" + attr.MyPK + "','" + tKey + "')\" ><img src='/WF/Img/Arr/Arrowhead_Next_S.gif' ></a>");
this.Pub2.Add("</TD>");
}
this.Pub2.AddTREnd();
for (int i = 0; i < 12; i++)
{
this.Pub2.AddTR();
this.Pub2.AddTDIdx(i);
foreach (MapAttr attr in attrs)
{
this.Pub2.AddTD();
}
this.Pub2.AddTREnd();
}
this.Pub2.AddTableEnd();
}
public void Add()
{
MapAttr attr = new MapAttr();
attr.MyDataType = this.FType;
attr.FK_MapData = this.MyPK;
attr.UIIsEnable = true;
switch (this.FType)
{
case DataType.AppString:
this.EditString(attr);
break;
case DataType.AppInt:
case DataType.AppDateTime:
case DataType.AppDate:
case DataType.AppFloat:
case DataType.AppDouble:
case DataType.AppMoney:
this.EditInt(attr);
break;
case DataType.AppBoolean:
this.EditBool(attr);
break;
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
MapAttr mattrNew = new MapAttr(this.RefNo);
MapExt me = new MapExt();
me.MyPK = this.RefNo + "_AutoFull";
me.RetrieveFromDBSources();
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = mattrNew.KeyOfEn;
me.ExtType = MapExtXmlList.AutoFull;
if (me.Tag == "0")
{
this.RB_0.Checked = true;
this.TB_Exp.Text = "";
}
else
{
this.RB_0.Checked = false;
}
if (me.Tag == "1")
{
this.RB_1.Checked = true;
}
else
{
this.RB_1.Checked = false;
}
this.TB_Exp.Text = me.Doc;
}
}
public string GenerSum(MapAttr mattr, GEDtls dtls)
{
return("");
//string left = "\n document.forms[0]." + this.ucsys1.GetTBByID("TB_" + mattr.Key).ClientID + ".value = ";
//string right = "";
//int i = 0;
//foreach (GEDtl dtl in dtls)
//{
// string tbID = "TB_" + mattr.Key + "_" + dtl.PKVal;
// TB tb = this.ucsys1.GetTBByID(tbID);
// if (i == 0)
// right += " parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
// else
// right += " +parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
// i++;
//}
//string s = left + right + " ;";
//switch (mattr.MyDataType)
//{
// case BP.DA.DataType.AppMoney:
// case BP.DA.DataType.AppRate:
// return s += "\t\n document.forms[0]." + this.ucsys1.GetTBByID("TB_" + mattr.Key).ClientID + ".value= VirtyMoney(document.forms[0]." + this.ucsys1.GetTBByID("TB_" + mattr.Key).ClientID + ".value ) ;";
// default:
// return s;
//}
}
public static new GameObject CreateGameObject(MapAttr attrs)
{
GameObject ob = new GameObject();
//ob.AddComponent(typeof(Account));
return(ob);
}
public string StandAloneFrm_InitField()
{
//字段属性.
MapAttr attr = new MapAttr();
attr.MyPK = this.FrmID + "_" + this.KeyOfEn;
attr.Retrieve();
return(AttrCond(attr));
}
public string CondByFrm_InitField()
{
//字段属性.
MapAttr attr = new MapAttr();
attr.MyPK = "ND" + int.Parse(this.FK_Flow) + "Rpt_" + this.KeyOfEn;
attr.Retrieve();
return(AttrCond(attr));
}
/// <summary>
/// 删除，把影子字段也要删除.
/// </summary>
protected override void afterDelete()
{
MapAttr attr = new MapAttr();
attr.MyPK = attr.FK_MapData + "_" + this.KeyOfEn + "T";
attr.Delete();
base.afterDelete();
}
protected void Page_Load(object sender, EventArgs e)
{
this.BindTop();
if (this.RefNo == null)
{
/*请选择要设置的字段*/
MapAttrs mattrs = new MapAttrs();
mattrs.Retrieve(MapAttrAttr.FK_MapData, this.FK_MapData);
//this.Pub1.AddFieldSet("请选择要设置的字段");
this.Pub1.AddEasyUiPanelInfoBegin("选择要设置的字段");
this.Pub1.AddUL("class='navlist'");
foreach (MapAttr en in mattrs)
{
if (en.UIVisible == false && en.UIIsEnable == false)
{
continue;
}
//this.Pub1.AddLi("?FK_MapData=" + this.FK_MapData + "&RefNo=" + en.MyPK + "&ExtType=AutoFull", en.KeyOfEn + " - " + en.Name);
this.Pub1.Add("<li style=\"font-weight:bold\"><div><a href=\"?FK_MapData=" + this.FK_MapData +
"&RefNo=" + en.MyPK + "&ExtType=AutoFull\"><span class=\"nav\">" + en.KeyOfEn + " - " +
en.Name + "</span></a></div></li>");
;
}
this.Pub1.AddULEnd();
//this.Pub1.AddFieldSetEnd();
this.Pub1.AddEasyUiPanelInfoEnd();
return;
}
MapAttr mattr = new MapAttr(this.RefNo);
Attr attr = mattr.HisAttr;
this.Title = "为[" + mattr.KeyOfEn + "][" + mattr.Name + "]设置自动完成"; // this.ToE("GuideNewField");
switch (attr.MyDataType)
{
case BP.DA.DataType.AppRate:
case BP.DA.DataType.AppMoney:
case BP.DA.DataType.AppInt:
case BP.DA.DataType.AppFloat:
BindNumType(mattr);
break;
case BP.DA.DataType.AppString:
BindStringType(mattr);
break;
default:
BindStringType(mattr);
break;
}
}
void ddlType_SelectedIndexChanged(object sender, EventArgs e)
{
MapAttr attr = new MapAttr(this.RefNo);
attr.MyDataTypeS = this.Pub1.GetDDLByID("DDL_DTType").SelectedItemStringVal;
attr.Update();
this.Response.Redirect("EditF.aspx?DoType=" + this.DoType + "&MyPK=" + this.MyPK + "&RefNo=" + this.RefNo + "&FType=" + attr.MyDataType + "&GroupField=" + this.GroupField, true);
// this.Response.Redirect(this.Request.RawUrl, true);
}
public static new GameObject CreateGameObject(MapAttr attrs)
{
var worldController = GameObject.Find("GoWorldController");
var world = worldController.GetComponent <GoWorldController>();
var p = GameObject.Instantiate(world.Player);
var entityStatus = world.GetEntityStatus();
p.GetComponent <Player>().Init(entityStatus);
return(p);
}
public string GenerLab(MapAttr attr, int idx, int i, int count)
{
string divAttr = " onmouseover=FieldOnMouseOver('" + attr.MyPK + "') onmouseout=FieldOnMouseOut('" + attr.MyPK + "') ";
string lab = attr.Name;
if (attr.MyDataType == DataType.AppBoolean && attr.UIIsLine)
{
lab = "编辑";
}
bool isLeft = true;
if (i == 1)
{
isLeft = false;
}
if (attr.HisEditType == EditType.Edit || attr.HisEditType == EditType.UnDel)
{
switch (attr.LGType)
{
case FieldTypeS.Normal:
lab = "<a href=\"javascript:Edit('" + this.FK_MapData + "','" + attr.MyPK + "','" + attr.MyDataType + "');\">" + lab + "</a>";
break;
case FieldTypeS.FK:
lab = "<a href=\"javascript:EditTable('" + this.FK_MapData + "','" + attr.MyPK + "','" + attr.MyDataType + "');\">" + lab + "</a>";
break;
case FieldTypeS.Enum:
lab = "<a href=\"javascript:EditEnum('" + this.FK_MapData + "','" + attr.MyPK + "','" + attr.MyDataType + "');\">" + lab + "</a>";
break;
default:
break;
}
}
else
{
lab = attr.Name;
}
if (idx == 0)
{
/*第一个。*/
return("<div " + divAttr + " >" + lab + "<a href=\"javascript:Down('" + this.FK_MapData + "','" + attr.MyPK + "','1');\" ><img src='./WF/Img/Btn/Right.gif' class='Arrow' alt='向右动顺序' border=0/></a></div>");
}
if (idx == count - 1)
{
/*到数第一个。*/
return("<div " + divAttr + " ><a href=\"javascript:Up('" + this.FK_MapData + "','" + attr.MyPK + "','1');\" ><img src='./WF/Img/Btn/Left.gif' alt='向左移动顺序' class='Arrow' border=0/></a>" + lab + "</div>");
}
return("<div " + divAttr + " ><a href=\"javascript:Up('" + this.FK_MapData + "','" + attr.MyPK + "','1');\" ><img src='./WF/Img/Btn/Left.gif' alt='向下移动顺序' class='Arrow' border=0/></a>" + lab + "<a href=\"javascript:Down('" + this.FK_MapData + "','" + attr.MyPK + "','1');\" ><img src='./WF/Img/Btn/Right.gif' alt='向右移动顺序' class='Arrow' border=0/></a></div>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.MyPK == null)
{
throw new Exception("Mypk==null");
}
this.Title = "编辑字段";
switch (this.DoType)
{
case "Add":
this.Add();
break;
case "Edit":
MapAttr attr = new MapAttr();
attr.MyPK = this.RefNo;
attr.RetrieveFromDBSources();
attr.MyDataType = this.FType;
if (attr.UIContralType == UIContralType.DDL)
{
this.Response.Redirect("EditSQL.aspx?MyPK=" + this.MyPK + "&RefNo=" + this.RefNo, true);
return;
}
switch (attr.MyDataType)
{
case BP.DA.DataType.AppString:
this.EditString(attr);
break;
case BP.DA.DataType.AppDateTime:
case BP.DA.DataType.AppDate:
case BP.DA.DataType.AppInt:
case BP.DA.DataType.AppFloat:
case BP.DA.DataType.AppMoney:
case BP.DA.DataType.AppDouble:
this.EditInt(attr);
break;
case BP.DA.DataType.AppBoolean:
this.EditBool(attr);
break;
default:
throw new Exception("为考虑的类型" + this.FType);
}
break;
default:
break;
}
}
/// <summary>
/// 删除，把影子字段也要删除.
/// </summary>
protected override void afterDelete()
{
MapAttr attr = new MapAttr();
attr.MyPK = attr.FK_MapData + "_" + this.KeyOfEn + "T";
attr.Delete();
//调用frmEditAction, 完成其他的操作.
BP.Sys.CCFormAPI.AfterFrmEditAction(this.FK_MapData);
base.afterDelete();
}
public string GenerSum(MapAttr mattr, GEDtls dtls)
{
if (dtls.Count <= 1)
{
return("");
}
string ClientID = "";
try
{
ClientID = this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID;
}
catch
{
return("");
}
string left = "\n document.forms[0]." + ClientID + ".value = ";
string right = "";
int i = 0;
foreach (GEDtl dtl in dtls)
{
string tbID = "TB_" + mattr.KeyOfEn + "_" + dtl.OID;
TextBox tb = this.Pub1.GetTextBoxByID(tbID);
if (tb == null)
{
continue;
}
if (i == 0)
{
right += " parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
}
else
{
right += " +parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
}
i++;
}
string s = left + right + " ;";
switch (mattr.MyDataType)
{
case BP.DA.DataType.AppMoney:
case BP.DA.DataType.AppRate:
return(s += "\t\n document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID + ".value= VirtyMoney(document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID + ".value ) ;");
default:
return(s);
}
}
protected override void afterInsertUpdateAction()
{
MapAttr mapAttr = new MapAttr();
mapAttr.MyPK = this.MyPK;
mapAttr.RetrieveFromDBSources();
mapAttr.Update();
//调用frmEditAction, 完成其他的操作.
BP.Sys.CCFormAPI.AfterFrmEditAction(this.FK_MapData);
base.afterInsertUpdateAction();
}
protected void Page_Load(object sender, EventArgs e)
{
switch (this.DoType)
{
case "Up":
MapAttr ma = new MapAttr(this.FK_MapData + "_" + this.KeyOfEn);
ma.DoUpTabIdx();
break;
case "Down":
MapAttr ma1 = new MapAttr(this.FK_MapData + "_" + this.KeyOfEn);
ma1.DoDownTabIdx();
break;
default:
break;
}
string sql = "SELECT KeyOfEn,Name,IDX FROM Sys_MapAttr WHERE FK_MapData='" + this.FK_MapData + "' AND UIVisible=1 ORDER BY Idx ";
this.Title = "设置tab键顺序";
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
this.Pub1.AddTable("width='100%'");
this.Pub1.AddCaption("正确的调整好Tab键的顺序,可以方便用户数据录入.");
this.Pub1.AddTR();
this.Pub1.AddTDTitle("IDX");
this.Pub1.AddTDTitle("字段");
this.Pub1.AddTDTitle("描述");
this.Pub1.AddTDTitle("顺序号");
this.Pub1.AddTDTitle("移动");
this.Pub1.AddTDTitle("移动");
this.Pub1.AddTREnd();
bool is1 = false;
int idx = 0;
foreach (DataRow dr in dt.Rows)
{
idx++;
is1 = this.Pub1.AddTR(is1);
this.Pub1.AddTDIdx(idx);
this.Pub1.AddTD(dr["KeyOfEn"].ToString());
this.Pub1.AddTD(dr["Name"].ToString());
this.Pub1.AddTD(dr["Idx"].ToString());
this.Pub1.AddTD("<a href='TabIdx.aspx?DoType=Up&FK_MapData=" + this.FK_MapData + "&KeyOfEn=" + dr["KeyOfEn"].ToString() + "' ><img src='../Img/Btn/Up.gif' border=0></a>");
this.Pub1.AddTD("<a href='TabIdx.aspx?DoType=Down&FK_MapData=" + this.FK_MapData + "&KeyOfEn=" + dr["KeyOfEn"].ToString() + "' ><img src='../Img/Btn/Down.gif' border=0></a>");
this.Pub1.AddTREnd();
}
this.Pub1.AddTableEnd();
}
public void Edit()
{
MapAttr attr = new MapAttr(this.RefNo);
switch (attr.MyDataType)
{
case BP.DA.DataType.AppString:
// this.Response.Redirect("EditF.aspx?RefOID="+this
break;
default:
break;
}
}
void btn_Click(object sender, EventArgs e)
{
MapDatas mds = this.GetMDs;
MapAttr mattrOld = new MapAttr(this.FK_MapData, this.KeyOfEn);
MapAttr mattr = new MapAttr(this.FK_MapData, this.KeyOfEn);
foreach (MapData md in mds)
{
CheckBox cb = this.Pub1.GetCBByID("CB_" + md.No);
if (cb == null)
{
continue;
}
if (cb.Checked == false)
{
continue;
}
if (this.DoType == "Copy")
{
/*执行批量Copy*/
mattr.FK_MapData = md.No;
mattr.Insert();
mattr.Idx = mattrOld.Idx;
}
if (this.DoType == "Update")
{
/*执行批量Update*/
MapAttr mattrUpdate = new MapAttr(md.No, this.KeyOfEn);
int gID = mattrUpdate.GroupID;
mattrUpdate.Copy(mattrOld);
mattrUpdate.FK_MapData = md.No;
mattrUpdate.GroupID = gID;
mattrUpdate.Update();
}
if (this.DoType == "Delete")
{
/*执行批量 Delete */
MapAttr mattrDelete = new MapAttr(md.No, this.KeyOfEn);
mattrDelete.Delete();
}
}
// 转向.
this.Response.Redirect(this.Request.RawUrl, true);
}
/// <summary>
/// 执行
/// </summary>
/// <returns>返回执行结果</returns>
public override object Do()
{
string rpt = BP.PubClass.DBRpt(BP.DBLevel.High);
// 手动升级. 2011-07-08 补充节点字段分组.
string sql = "DELETE FROM Sys_EnCfg WHERE No='BP.WF.Ext.NodeSheet'";
BP.DA.DBAccess.RunSQL(sql);
sql = "INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Ext.NodeSheet','NodeID=基本配置@WarningDays=考核属性@SendLab=功能按钮标签与状态')";
BP.DA.DBAccess.RunSQL(sql);
// 修复因bug丢失的字段.
MapDatas mds = new MapDatas();
mds.RetrieveAll();
foreach (MapData md in mds)
{
string nodeid = md.No.Replace("ND", "");
try
{
BP.WF.Node nd = new Node(int.Parse(nodeid));
nd.RepareMap();
continue;
}
catch (Exception ex)
{
}
MapAttr attr = new MapAttr();
if (attr.IsExit(MapAttrAttr.KeyOfEn, "OID", MapAttrAttr.FK_MapData, md.No) == false)
{
attr.FK_MapData = md.No;
attr.KeyOfEn = "OID";
attr.Name = "OID";
attr.MyDataType = BP.DA.DataType.AppInt;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.DefVal = "0";
attr.HisEditType = BP.En.EditType.Readonly;
attr.Insert();
}
}
return("执行成功...");
}
/// <summary>
/// 返回信息。
/// </summary>
/// <returns></returns>
public string RadioBtns_Init()
{
DataSet ds = new DataSet();
//放入表单字段.
MapAttrs attrs = new MapAttrs(this.FK_MapData);
ds.Tables.Add(attrs.ToDataTableField("Sys_MapAttr"));
//属性.
MapAttr attr = new MapAttr();
attr.MyPK = this.FK_MapData + "_" + this.KeyOfEn;
attr.Retrieve();
//把分组加入里面.
GroupFields gfs = new GroupFields(this.FK_MapData);
ds.Tables.Add(gfs.ToDataTableField("Sys_GroupFields"));
//字段值.
FrmRBs rbs = new FrmRBs();
rbs.Retrieve(FrmRBAttr.FK_MapData, this.FK_MapData, FrmRBAttr.KeyOfEn, this.KeyOfEn);
if (rbs.Count == 0)
{
/*初始枚举值变化.
*/
SysEnums ses = new SysEnums(attr.UIBindKey);
foreach (SysEnum se in ses)
{
FrmRB rb = new FrmRB();
rb.FK_MapData = this.FK_MapData;
rb.KeyOfEn = this.KeyOfEn;
rb.IntKey = se.IntKey;
rb.Lab = se.Lab;
rb.EnumKey = attr.UIBindKey;
rb.Insert(); //插入数据.
}
rbs.Retrieve(FrmRBAttr.FK_MapData, this.FK_MapData, FrmRBAttr.KeyOfEn, this.KeyOfEn);
}
//加入单选按钮.
ds.Tables.Add(rbs.ToDataTableField("Sys_FrmRB"));
return(BP.Tools.Json.ToJson(ds));
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.MyPK == null)
{
throw new Exception("Mypk==null");
}
this.Title = "编辑字段";
switch (this.DoType)
{
case "Add":
this.Add();
break;
case "Edit":
MapAttr attr = new MapAttr();
attr.MyPK = this.RefNo;
attr.RetrieveFromDBSources();
attr.MyDataType = this.FType;
switch (attr.MyDataType)
{
case BP.DA.DataType.AppString:
this.EditString(attr);
break;
case BP.DA.DataType.AppDateTime:
case BP.DA.DataType.AppDate:
case BP.DA.DataType.AppInt:
case BP.DA.DataType.AppFloat:
case BP.DA.DataType.AppMoney:
this.EditInt(attr);
break;
case BP.DA.DataType.AppBoolean:
this.EditBool(attr);
break;
default:
throw new Exception("为考虑的类型" + this.FType);
}
break;
default:
break;
}
}
public string GenerSum(MapAttr mattr, MapDtl dtl)
{
if (dtl.IsShowSum == false)
{
return("");
}
if (mattr.MyDataType == DataType.AppBoolean)
{
return("");
}
string left = "\n document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID + ".value = ";
string right = "";
for (int i = 1; i <= dtl.RowsOfList; i++)
{
string tbID = "TB_" + mattr.KeyOfEn + "_" + i;
TextBox tb = this.Pub1.GetTextBoxByID(tbID);
if (tb == null)
{
continue;
}
if (i == 0)
{
right += " parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
}
else
{
right += " +parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
}
}
string s = left + right + " ;";
switch (mattr.MyDataType)
{
case BP.DA.DataType.AppMoney:
case BP.DA.DataType.AppRate:
return(s += "\t\n document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID + ".value= VirtyMoney(document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID + ".value ) ;");
default:
return(s);
}
}
/// <summary>
/// 保存列的顺序名称.
/// </summary>
/// <returns></returns>
public string S3ColsLabel_Save()
{
string orders = this.GetRequestVal("Orders");
//格式为 @KeyOfEn,Lable,idx 比如： @DianHua,电话,1@Addr,地址,2
string rptNo = this.GetRequestVal("RptNo");
string[] strs = orders.Split('@');
foreach (string item in strs)
{
if (DataType.IsNullOrEmpty(item) == true)
{
continue;
}
string[] vals = item.Split(',');
string mypk = rptNo + "_" + vals[0];
MapAttr attr = new MapAttr();
attr.MyPK = mypk;
attr.Retrieve();
attr.Name = vals[1];
attr.Idx = int.Parse(vals[2]);
attr.Update(); //执行更新.
}
MapAttr myattr = new MapAttr();
myattr.MyPK = rptNo + "_OID";
myattr.RetrieveFromDBSources();
myattr.Idx = 200;
myattr.Name = "工作ID";
myattr.Update();
myattr = new MapAttr();
myattr.MyPK = rptNo + "_Title";
myattr.RetrieveFromDBSources();
myattr.Idx = -100;
myattr.Name = "标题";
myattr.Update();
return("保存成功..");
}
/// <summary>
/// 执行
/// </summary>
/// <returns>返回执行结果</returns>
public override object Do()
{
string keys = "~!@#$%^&*()+{}|:<>?`=[];,./～！＠＃￥％……＆×（）——＋｛｝｜：“《》？｀－＝［］；＇，．／";
char[] cc = keys.ToCharArray();
foreach (char c in cc)
{
DBAccess.RunSQL("update sys_mapattr set keyofen=REPLACE(keyofen,'" + c + "' , '')");
}
BP.Sys.MapAttrs attrs = new Sys.MapAttrs();
attrs.RetrieveAll();
int idx = 0;
string msg = "";
foreach (BP.Sys.MapAttr item in attrs)
{
string f = item.KeyOfEn.Clone().ToString();
try
{
int i = int.Parse(item.KeyOfEn.Substring(0, 1));
item.KeyOfEn = "F" + item.KeyOfEn;
try
{
MapAttr itemCopy = new MapAttr();
itemCopy.Copy(item);
itemCopy.Insert();
item.DirectDelete();
}
catch (Exception ex)
{
msg += "@" + ex.Message;
}
}
catch
{
continue;
}
DBAccess.RunSQL("UPDATE sys_mapAttr set KeyOfEn='" + item.KeyOfEn + "', mypk=FK_MapData+'_'+keyofen where keyofen='" + item.KeyOfEn + "'");
msg += "@第(" + idx + ")个错误修复成功，原（" + f + "）修复成(" + item.KeyOfEn + ").";
idx++;
}
BP.DA.DBAccess.RunSQL("UPDATE Sys_MapAttr SET MyPK=FK_MapData+'_'+KeyOfEn WHERE MyPK!=FK_MapData+'_'+KeyOfEn");
return("修复信息如下:" + msg);
}
public void EditInt(MapAttr mapAttr)
{
this.EditBeforeAdd(mapAttr);
TB tb = new TB();
this.Pub1.AddTR();
this.Pub1.AddTDIdx(idx++);
this.Pub1.AddTD("文本框宽度");
tb = new TB();
tb.ID = "TB_UIWidth";
tb.CssClass = "TBNum";
tb.Text = mapAttr.UIWidth.ToString();
this.Pub1.AddTD(tb);
this.Pub1.AddTDB("对从表有效");
this.Pub1.AddTREnd();
this.EditBeforeEnd(mapAttr);
}
