public static resolver Parse(DataRow element)
{
resolver result = new resolver();
result.resolverId = element["ID"].ToString();
result.typeName = element["TYPE_NAME"].ToString();
result.resolverCode = element["RESOLVER_CODE"].ToString();
result.attachName = element["ATTACH_NAME"].ToString();
// result.url = element["url"].ToString();
result.scriptType = element["SCRIPT_TYPE"].ToString();
return(result);
}
public static Task <int> FromAsync(starter s, resolver r, byte[] buffer,
int ofs, int count, AsyncCallback cb, object state)
{
TaskCompletionSource <int> tcs = new TaskCompletionSource <int>();
s(buffer, ofs, count, (ar) => {
try {
int res = r(ar);
tcs.TrySetResult(res);
}
catch (Exception e) {
tcs.TrySetException(e);
}
}, null);
return(tcs.Task);
}
public static resolver Parse(XElement element)
{
if (element.Elements().Count() == 0)
{
return(null);
}
resolver result = new resolver();
result.resolverId = element.Element("resolverId").Value;
result.typeName = element.Element("typeName").Value;
result.resolverCode = element.Element("resolverCode").Value;
result.attachName = element.Element("attachName").Value;
result.url = element.Element("url").Value;
result.scriptType = element.Element("scriptType").Value;
return(result);
}
private static List <resolver> getResolvers(string id)
{
List <resolver> result = new List <resolver>();
string sql = string.Format(@"with a as
(select t.fid as resolver_id, t.mids_script_code resolver_code,t.script_type script_type,t.mids_script_name type_name
from pt6.pm_task_info pt left join import.mds_imp_data_script t
on instr(pt.resolver_task_id,t.fid)>0 where pt.id = '{0}')
select a.resolver_id id,a.resolver_id,a.resolver_code,a.type_name,a.script_type,sa.attach_name from a
left join pt6.sys_attachment sa on sa.parent_register_id = a.resolver_id" , id);
DataSet ds = OracleHelper.Query(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
resolver item = resolver.Parse(dr);
result.Add(item);
}
return(result);
}
