/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnQuery_Click(object sender, EventArgs e)
{
queryHistoryFlag.Value = "";
DbConnectionMappingContext.ClearAllMappings();
ExecQuery();
}
private void UpdateInfo(string materialId, string url, string connectionName, string rootPath)
{
materialId.CheckStringIsNullOrEmpty("materialId");
url.CheckStringIsNullOrEmpty("url");
connectionName.CheckStringIsNullOrEmpty("connectionName");
var material = MaterialHelper.LoadMaterial(materialId, connectionName);
var extraData = material.ExtraDataDictionary;
if (extraData.ContainsKey(SyncMaterialFileToDocCenterOperation.ShowFileUrlKey))
{
extraData[SyncMaterialFileToDocCenterOperation.ShowFileUrlKey] = url;
}
else
{
extraData.Add(SyncMaterialFileToDocCenterOperation.ShowFileUrlKey, url);
}
var deltaMaterialList = new DeltaMaterialList();
deltaMaterialList.RootPathName = rootPath;
deltaMaterialList.Updated.Add(material);
DbConnectionMappingContext.DoMappingAction(
MaterialAdapter.Instance.GetConnectionName(),
connectionName,
() =>
{
MaterialAdapter.Instance.SaveDeltaMaterials(deltaMaterialList, false);
});
}
public virtual void DoModifyFileOperations(string rootPath, MaterialFileOeprationInfo fileOperation, MaterialContent content)
{
var task = new InvokeServiceTask()
{
TaskID = UuidHelper.NewUuidString(),
TaskTitle = string.Format(this.taskTitleTemplate, fileOperation.Material.OriginalName, fileOperation.Material.ID),
};
var parameters = new WfServiceOperationParameterCollection
{
new WfServiceOperationParameter("rootPath", rootPath),
new WfServiceOperationParameter("fileOperation", fileOperation.Operation.ToString()),
new WfServiceOperationParameter("materialConnectionName",
DbConnectionMappingContext.GetMappedConnectionName(MaterialAdapter.Instance.GetConnectionName())),
new WfServiceOperationParameter("contentConnectionName",
DbConnectionMappingContext.GetMappedConnectionName(MaterialContentAdapter.Instance.ConnectionName)),
new WfServiceOperationParameter("materialId", fileOperation.Material.ID),
new WfServiceOperationParameter("url", fileOperation.Material.ShowFileUrl)
};
task.SvcOperationDefs.Add(new WfServiceOperationDefinition(
new WfServiceAddressDefinition(WfServiceRequestMethod.Post, null, ResourceUriSettings.GetConfig().Paths[this.resourceUri].Uri.ToString()),
"DoFileToDocService", parameters, "ReturnValue")
);
DbConnectionMappingContext.DoMappingAction(
DbConnectionMappingContext.GetMappedConnectionName(InvokeServiceTaskAdapter.Instance.ConnectionName),
InvokeServiceTaskAdapter.Instance.ConnectionName,
() =>
{
InvokeServiceTaskAdapter.Instance.Update(task);
});
}
public void MaterialCloneAndPersistTest()
{
Material source = PrepareSourceMaterial();
Material dest = source.Clone();
MaterialList list = new MaterialList();
list.Add(dest);
DbConnectionMappingContext.DoMappingAction(
MaterialAdapter.Instance.GetConnectionName(), "SubjectDB",
() =>
{
TransactionScopeFactory.DoAction(() =>
{
MaterialAdapter.Instance.InsertWithContent(list);
MaterialList loadedList = MaterialAdapter.Instance.LoadMaterialByMaterialID(dest.ID);
Assert.IsTrue(loadedList.Count > 0);
loadedList[0].EnsureMaterialContent();
ValidateMaterial(source, loadedList[0]);
});
});
}
private static void InitConnectionMappings(Dictionary <string, string> connectionMappings)
{
foreach (KeyValuePair <string, string> kp in connectionMappings)
{
DbConnectionMappingContext.CreateMapping(kp.Key, kp.Value);
}
}
private void InitConnectionMappings()
{
foreach (KeyValuePair <string, string> kp in this.RequestMessage.ConnectionMappings)
{
DbConnectionMappingContext.CreateMapping(kp.Key, kp.Value);
}
}
public void SimpleConnectionMapping()
{
DbConnectionMappingContext.DoMappingAction("HB2008", "HB2008Test", () =>
{
Assert.AreEqual("HB2008Test", DbConnectionMappingContext.GetMappedConnectionName("HB2008"));
});
}
public void SimpleConnectionMappingTest()
{
DbConnectionMappingContext.DoMappingAction("HB2008", "HB2009", () =>
{
Assert.AreEqual("HB2009", DbConnectionMappingContextCache.Instance["HB2008"].DestinationConnectionName);
});
Assert.IsFalse(DbConnectionMappingContextCache.Instance.ContainsKey("HB2008"));
}
public static void DoDbAction(Action method)
{
DbConnectionMappingContext.DoMappingAction(MCS.Library.SOA.DataObjects.Security.Adapters.SCConnectionDefine.DBConnectionName, GetMappedName(AUCommon.DBConnectionName), () =>
{
method();
});
return;
}
protected void btnQueryHistory_Click(object sender, EventArgs e)
{
DbConnectionMappingContext.ClearAllMappings();
ArchiveSettings.GetConfig().ConnectionMappings.CreateConnectionMappingContexts();
queryHistoryFlag.Value = "QueryHistory";
ExecQuery();
}
public static R DoDbProcess <R>(Func <R> method)
{
R result = default(R);
DbConnectionMappingContext.DoMappingAction(PC.Adapters.SCConnectionDefine.DBConnectionName, GetMappedName(AUCommon.DBConnectionName), () =>
{
result = method();
});
return(result);
}
public void CascadeConnectionMapping()
{
DbConnectionMappingContext.DoMappingAction("HB2008", "HB2008Test", () =>
{
DbConnectionMappingContext.DoMappingAction("PermissionCenter", "HB2008", () =>
{
Assert.AreEqual("HB2008Test", DbConnectionMappingContext.GetMappedConnectionName("PermissionCenter"));
});
Assert.AreEqual("HB2008Test", DbConnectionMappingContext.GetMappedConnectionName("HB2008"));
});
}
public ArchiveConnectionMappingContextCollection CreateConnectionMappingContexts()
{
ArchiveConnectionMappingContextCollection result = new ArchiveConnectionMappingContextCollection();
foreach (ArchiveConnectionMappingElement elem in this)
{
DbConnectionMappingContext context = DbConnectionMappingContext.CreateMapping(elem.SourceConnection, elem.DestinationConnection);
result.Add(context);
}
return(result);
}
public void RestoreNestedConnectionMapping()
{
DbConnectionMappingContext.DoMappingAction("HB2008", "HB2008Test", () =>
{
Assert.AreEqual("HB2008Test", DbConnectionMappingContext.GetMappedConnectionName("HB2008"));
DbConnectionMappingContext.DoMappingAction("HB2008", "HB2008Archive", () =>
{
Assert.AreEqual("HB2008Archive", DbConnectionMappingContext.GetMappedConnectionName("HB2008"));
});
Assert.AreEqual("HB2008Test", DbConnectionMappingContext.GetMappedConnectionName("HB2008"));
});
}
public static MaterialContent LoadMaterialContent(string materialId, string connectionName)
{
materialId.CheckStringIsNullOrEmpty("materialId");
connectionName.CheckStringIsNullOrEmpty("connectionName");
MaterialContent result = null;
DbConnectionMappingContext.DoMappingAction(
MaterialContentAdapter.Instance.ConnectionName,
connectionName,
() =>
{
result = MaterialContentAdapter.Instance.Load(p => p.AppendItem("CONTENT_ID", materialId)).FirstOrDefault();
});
return(result);
}
public static Material LoadMaterial(string materialId, string connectionName)
{
materialId.CheckStringIsNullOrEmpty("materialId");
connectionName.CheckStringIsNullOrEmpty("connectionName");
Material result = null;
DbConnectionMappingContext.DoMappingAction(
MaterialContentAdapter.Instance.ConnectionName,
connectionName,
() =>
{
result = MaterialAdapter.Instance.LoadMaterialByMaterialID(materialId).FirstOrDefault();
});
return(result);
}
public void Archive(ArchiveBasicInfo info)
{
LoadOriginalData(info);
using (DbConnectionMappingContext context =
DbConnectionMappingContext.CreateMapping(ConnectionDefine.DBConnectionName, "Archive"))
{
using (TransactionScope scope = TransactionScopeFactory.Create())
{
SaveArchiveData(info);
scope.Complete();
}
}
if (ArchiveSettings.GetConfig().DeleteOriginalData)
{
InnerDelete(info);
}
}
private object BuildWhere()
{
DbConnectionMappingContext.ClearAllMappings();
FormQueryCondition queryCondition = new FormQueryCondition()
{
Subject = this.Request.QueryString["sfSubject"],
CreateTimeBegin = GetRequestData <DateTime>("sfStart", DateTime.MinValue),
CreateTimeEnd = GetRequestData <DateTime>("sfEnd", DateTime.MinValue),
DraftDepartmentName = this.Request.QueryString["sfDept"] ?? string.Empty,
CurrentUsersName = this.Request.QueryString["sfApplicant"] ?? string.Empty,
ApplicationName = this.Request.QueryString[sfAppName.ClientID],
ProgramName_SinoOcean = this.Request.QueryString[sfProgramName.ClientID]
};
WhereSqlClauseBuilder builder = ConditionMapping.GetWhereSqlClauseBuilder(queryCondition,
new AdjustConditionValueDelegate(AdjustQueryConditionValue));
//申请部门
if (string.IsNullOrEmpty(queryCondition.DraftDepartmentName) == false)
{
builder.AppendItem("CONTAINS(DRAFT_DEPARTMENT_NAME," + GetFullTextParameter(queryCondition.DraftDepartmentName) + ")", "", "", true);
}
var allConditions = new ConnectiveSqlClauseCollection(builder);
//if (MostSupervisor == false || NormalSupervisior == false)
//{
// //检查是否具有分类授权
// WfApplicationAuthCollection authInfo = WfApplicationAuthAdapter.Instance.GetUserApplicationAuthInfo(DeluxeIdentity.Current.User);
// var builder2 = authInfo.GetApplicationAndProgramBuilder("APPLICATION_NAME", "PROGRAM_NAME");
// allConditions.Add(builder2);
//}
string whereCondition = allConditions.ToSqlString(TSqlBuilder.Instance);
return(whereCondition);
}
