/// <summary>
/// 执行
/// </summary>
/// <returns>返回执行结果</returns>
public string DoMethod_ExeSQL()
{
MethodFunc func = new MethodFunc(this.MyPK);
string doc = func.MethodDoc_SQL;
GEEntity en = new GEEntity(func.FrmID, this.WorkID);
doc = BP.WF.Glo.DealExp(doc, en, null); //替换里面的内容.
try
{
DBAccess.RunSQLs(doc);
if (func.MsgSuccess.Equals(""))
{
func.MsgSuccess = "执行成功.";
}
return(func.MsgSuccess);
}
catch (Exception ex)
{
if (func.MsgErr.Equals(""))
{
func.MsgErr = "执行失败(DoMethod_ExeSQL).";
}
return("err@" + func.MsgErr + " @ " + ex.Message);
}
}
public string MethodDocDemoJS_Init()
{
var func = new MethodFunc(this.MyPK);
return(func.MethodDoc_JavaScript_Demo);
}
public string MethodDocDemoSQL_Init()
{
var func = new MethodFunc(this.MyPK);
return(func.MethodDoc_SQL_Demo);
}
/// <summary>
/// 执行SQL
/// </summary>
/// <returns></returns>
public string DoMethodPara_ExeSQL()
{
MethodFunc func = new MethodFunc(this.MyPK);
string doc = func.MethodDoc_SQL;
GEEntity en = new GEEntity(func.FrmID, this.WorkID);
doc = BP.WF.Glo.DealExp(doc, en, null); //替换里面的内容.
#region 替换参数变量.
MapAttrs attrs = new MapAttrs();
attrs.Retrieve(MapAttrAttr.FK_MapData, this.MyPK);
foreach (MapAttr item in attrs)
{
if (item.UIContralType == UIContralType.TB)
{
doc = doc.Replace("@" + item.KeyOfEn, this.GetRequestVal("TB_" + item.KeyOfEn));
continue;
}
if (item.UIContralType == UIContralType.DDL)
{
doc = doc.Replace("@" + item.KeyOfEn, this.GetRequestVal("DDL_" + item.KeyOfEn));
continue;
}
if (item.UIContralType == UIContralType.CheckBok)
{
doc = doc.Replace("@" + item.KeyOfEn, this.GetRequestVal("CB_" + item.KeyOfEn));
continue;
}
if (item.UIContralType == UIContralType.RadioBtn)
{
doc = doc.Replace("@" + item.KeyOfEn, this.GetRequestVal("RB_" + item.KeyOfEn));
continue;
}
}
#endregion 替换参数变量.
#region 开始执行SQLs.
try
{
DBAccess.RunSQLs(doc);
if (func.MsgSuccess.Equals(""))
{
func.MsgSuccess = "执行成功.";
}
return(func.MsgSuccess);
}
catch (Exception ex)
{
if (func.MsgErr.Equals(""))
{
func.MsgErr = "执行失败.";
}
return("err@" + func.MsgErr + " @ " + ex.Message);
}
#endregion 开始执行SQLs.
return("err@" + func.MethodDocTypeOfFunc + ",执行的类型没有解析.");
}
