/// <summary>
///
/// </summary>
/// <param name="name">SqlLoadKey</param>
/// <param name="dict"></param>
/// <param name="tran"></param>
/// <param name="connect"></param>
public static void ExecuteProcedure(ProcedureItem pitem, DbTransaction tran = null, string connect = "")
{
var commd = Command(pitem.ProcedureName, tran, connect);
commd.CommandType = CommandType.StoredProcedure;
string paramstr = "(";
foreach (var item in pitem.ParametersKeys)
{
var p = pitem.Parameters[item];
var param = commd.CreateParameter();
param.ParameterName = p.ParameterName;
param.Direction = p.Direction;
param.Value = p.Value;
param.DbType = p.DataType;
commd.Parameters.Add(param);
paramstr += p.Value + ",";
}
//Debug.Write(paramstr.TrimEnd(',') + ")");
commd.ExecuteNonQuery();
if (tran == null)
{
commd.Connection.Close();
}
foreach (DbParameter item in commd.Parameters)
{
if (item.Direction != ParameterDirection.Input)
{
pitem[item.ParameterName] = item.Value;
}
}
}
public static ProcedureItem GetInstance()
{
if (singleInstance == null)
{
singleInstance = new ProcedureItem();
}
return(singleInstance);
}
public ActionResult Details(int id)
{
ProcedureDetailViewModel viewModel = new ProcedureDetailViewModel();
ProcedureItem procedureItem = GetSqlItem <ProcedureItem>(ProcedureItem.ItemSql, new { Id = id });
if (procedureItem.Id != 0)
{
viewModel.Procedure = procedureItem;
viewModel.Tree = GenerateProcedureTree(id);
}
return(View(viewModel));
}
public bool Run(ProcedureItem procedure, bool noevent = false) {
Clear();
if (procedure == null) return true;
_procedure = procedure;
try {
_result = procedure.Module.Run(procedure.Name, procedure.Params);
return true;
} catch(Exception ex) {
var quitEx = Regex.Match(ex.Message, @"^Quit=(\d+)$", RegexOptions.IgnoreCase);
if (quitEx.Success)
return quitEx.Groups[1].Value == "0" ? true : false;
if (_error == null) throw;
if (OnError != null && !noevent)
OnError(_error);
}
return false;
}
public override void OnHandleClick(object sender, ClickedEventArgs e)
{
Item item = null;
if (IsInItem)
{
switch (CurrentObject.tag)//根据对象的标签，来实例化对应的对象
{
case "SwitchScene":
item = SwitchSceneItem.GetInstance();
break;
case "Procedure":
item = ProcedureItem.GetInstance();
break;
}
if (item != null)
{
item.Dispose(CurrentObject.name);
}
}
}
public ScriptResult(Script script, ProcedureItem procedure) {
Script = script;
Procedure = procedure;
}
public ScriptError(Script script, ProcedureItem procedure, string err_message)
: base(script, procedure) {
StackTrace = new List<TraceLine>();
Message = err_message.CleanEnd();
Information = string.Empty;
}
public void Delete(ProcedureItem model)
{
_drugRepository.Delete(model);
}
public void Update(ProcedureItem model)
{
_drugRepository.Update(model);
}
public void Insert(ProcedureItem model)
{
_drugRepository.Insert(model);
}
private void Clear() {
_error = null;
_err_line = 0;
_procedure = null;
_result = null;
}
public ScriptSuccees(Script script, ProcedureItem procedure = null)
: base(script, procedure) {
}
