public DependentHandle(TPrimary primary, TSecondary secondary)
{
IntPtr intPtr;
InternalMethods.nInitialize(primary, secondary, out intPtr);
this.handle = intPtr;
}
public void Dispose()
{
if (handle != IntPtr.Zero)
{
IntPtr intPtr = handle;
handle = IntPtr.Zero;
InternalMethods.nFree(intPtr);
}
}
public static Responses.SQLDatabase.ListServers.ResponseWithoutGeneric ListServersWithoutGeneric(
System.Security.Cryptography.X509Certificates.X509Certificate2 certificate,
Guid subscriptionId)
{
Uri uri = new Uri(
GetManagementURI() + "/" +
subscriptionId.ToString() + "/" +
"services" + "/" +
"sqlservers/servers");
return(InternalMethods.PerformSimpleGet <Responses.SQLDatabase.ListServers.ResponseWithoutGeneric>(uri, certificate, AZURE_VERSION));
}
public static Responses.SQLDatabase.ListDatabases.Response GetDataMaskingPolicy(
System.Security.Cryptography.X509Certificates.X509Certificate2 certificate,
Guid subscriptionId,
string serverName)
{
Uri uri = new Uri(
GetManagementURI() + "/" +
subscriptionId.ToString() + "/" +
"services" + "/" +
"sqlservers/servers/" +
serverName + "/" +
"databases?contentview=generic");
return(InternalMethods.PerformSimpleGet <Responses.SQLDatabase.ListDatabases.Response>(uri, certificate, AZURE_VERSION));
}
public bool TryGetPrimary(out TPrimary primary)
{
if (!IsAllocated)
{
primary = default(TPrimary);
return(false);
}
object obj;
InternalMethods.nGetPrimary(handle, out obj);
if (obj == null)
{
primary = default(TPrimary);
return(false);
}
primary = (TPrimary)obj;
return(true);
}
//换一种数据结构存储
private Dictionary <UnitFunctionGroupType, List <IEntityData> > GetNewDataStructure(List <IEntityData> lstAllData)
{
Dictionary <UnitFunctionGroupType, List <IEntityData> > groupData = null;
if (groupData == null)
{
groupData = new Dictionary <UnitFunctionGroupType, List <IEntityData> >();
}
else
{
groupData.Clear();
}
foreach (int enumIndex in Enum.GetValues(typeof(UnitFunctionGroupType)))
{
UnitFunctionGroupType unitContentGroupType = (UnitFunctionGroupType)enumIndex;
List <IEntityData> lstData = null;
foreach (IEntityData item in lstAllData)
{
if (lstData == null)
{
lstData = new List <IEntityData>();
}
FunctionData data = item as FunctionData;
if (data != null && unitContentGroupType == InternalMethods.GetUnitFunctionGroupType(data.FunctionType))
{
lstData.Add(item);
}
}
if (lstData == null || lstData.Count <= 0)
{
continue;
}
groupData.Add(unitContentGroupType, lstData);
}
return(groupData);
}
public bool TryGetPrimaryAndSecondary(out TPrimary primary, out TSecondary secondary)
{
if (!IsAllocated)
{
primary = default(TPrimary);
secondary = default(TSecondary);
return(false);
}
object p;
object s;
InternalMethods.nGetPrimaryAndSecondary(handle, out p, out s);
if (p == null)
{
primary = default(TPrimary);
secondary = default(TSecondary);
return(false);
}
primary = (TPrimary)p;
secondary = (TSecondary)s;
return(true);
}
public static void Do()
{
string accountName = "enosg";
string sharedKey = "oooo+ps!";
bool useHTTPS = true;
string contName = "testsas";
SharedAccessSignatureACL queueACL = new SharedAccessSignatureACL();
queueACL.SignedIdentifier = new List <SignedIdentifier>();
queueACL.SignedIdentifier.Add(new SignedIdentifier()
{
Id = "sisisisisisisvvv",
AccessPolicy = new AccessPolicy()
{
Start = DateTime.Now.AddYears(-1),
Expiry = DateTime.Now.AddYears(1),
Permission = "rwd"
}
});
queueACL.SignedIdentifier.Add(new SignedIdentifier()
{
Id = "secondsigid",
AccessPolicy = new AccessPolicy()
{
Start = DateTime.Now.AddYears(-10),
Expiry = DateTime.Now.AddYears(10),
Permission = "rwdl"
}
});
System.Xml.Serialization.XmlSerializer ser = new System.Xml.Serialization.XmlSerializer(queueACL.GetType());
// use this two lines to get rid of those useless namespaces :).
System.Xml.Serialization.XmlSerializerNamespaces namespaces = new System.Xml.Serialization.XmlSerializerNamespaces();
namespaces.Add(string.Empty, string.Empty);
using (System.IO.FileStream fs = new System.IO.FileStream("C:\\temp\\QueueACL.xml", System.IO.FileMode.Create, System.IO.FileAccess.Write, System.IO.FileShare.Read))
{
ser.Serialize(fs, queueACL, namespaces);
}
using (System.IO.FileStream fs = new System.IO.FileStream("C:\\temp\\QueueACL.xml", System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.Read))
{
queueACL = (SharedAccessSignatureACL)ser.Deserialize(fs);
}
var result = InternalMethods.SetContainerACL(accountName, sharedKey, useHTTPS, contName, null, queueACL, ITPCfSQL.Azure.Enumerations.ContainerPublicReadAccess.Blob);
//return;
AzureBlobService abs = new AzureBlobService(accountName, sharedKey, useHTTPS);
List <Container> lConts = abs.ListContainers();
if (lConts.FirstOrDefault(item => item.Name == contName) == null)
{
abs.CreateContainer("testsas", ITPCfSQL.Azure.Enumerations.ContainerPublicReadAccess.Blob);
lConts = abs.ListContainers();
}
Container cTest = lConts.First(item => item.Name == contName);
ContainerPublicReadAccess containerPublicAccess;
var output = InternalMethods.GetContainerACL(accountName, sharedKey, useHTTPS, contName, out containerPublicAccess);
}
void bgwSave_DoWork(object sender, DoWorkEventArgs e)
{
DataTable dtData = e.Argument as DataTable;
DBAccessEx dbAccess = localService.GetNewDBAccessEx();
dbAccess.BeginTransaction();
//首先删除表中数据，删除数据分主表和字表，主表为preline,字表为premonthdata
PreLineService m_PreLineService = new PreLineService(dbAccess);
m_PreLineService.Delete(decParams.ProID, decParams.Pjnd, decParams.Dydm, StudyType.DYFX);
PreMonthDataService m_PreMonthDataService = new PreMonthDataService(dbAccess);
m_PreMonthDataService.Delete(decParams.ProID, decParams.Pjnd, decParams.Dydm);
//插入线数据
string prelineID_YCY = Guid.NewGuid().ToString(); //月产油
string prelineID_YCQ = Guid.NewGuid().ToString(); //月产气
DataTable dt_preline = m_PreLineService.GetEmptyDataTable();
//插入月产油数据
DataRow dr_line_ycy = dt_preline.NewRow();
dr_line_ycy["prelineID"] = prelineID_YCY;
dr_line_ycy["proID"] = decParams.ProID;
dr_line_ycy["pjnd"] = decParams.Pjnd;
dr_line_ycy["dydm"] = decParams.Dydm;
dr_line_ycy["studyType"] = "DYFX";
dr_line_ycy["seriesName"] = "ycy";
dt_preline.Rows.Add(dr_line_ycy);
//插入月产气数据
DataRow dr_line_ycq = dt_preline.NewRow();
dr_line_ycq["prelineID"] = prelineID_YCQ;
dr_line_ycq["proID"] = decParams.ProID;
dr_line_ycq["pjnd"] = decParams.Pjnd;
dr_line_ycq["dydm"] = decParams.Dydm;
dr_line_ycq["studyType"] = "DYFX";
dr_line_ycq["seriesName"] = "ycq";
dt_preline.Rows.Add(dr_line_ycq);
m_PreLineService.Insert(dt_preline);
//插入预测数据
DataTable dt_data = m_PreMonthDataService.GetEmptyDataTable();
foreach (DataRow dr in dtData.Rows)
{
//添加月产油
DataRow dr_data_ycy = dt_data.NewRow();
dr_data_ycy["prelineID"] = prelineID_YCY;
dr_data_ycy["NY"] = dr["NY"];
double ycy = dr["YCY"].ToDouble();
if (tsbUnitSwich.Text == "切换为英式单位")
{
DYDAB01Service M_DYDAB01Service = new DYDAB01Service();
double YYMD = M_DYDAB01Service.GetYYMD(decParams.ProID, decParams.Dydm);
ycy = InternalMethods.GetWTonByMBBL(ycy, YYMD);
}
dr_data_ycy["YCValue"] = dr["YCY"];
dt_data.Rows.Add(dr_data_ycy);
//添加月产气
DataRow dr_data_ycq = dt_data.NewRow();
dr_data_ycq["prelineID"] = prelineID_YCQ;
dr_data_ycq["NY"] = dr["NY"];
double YCQ = dr["YCQ"].ToDouble();
if (tsbUnitSwich.Text == "切换为英式单位")
{
DYDAB01Service M_DYDAB01Service = new DYDAB01Service();
YCQ = InternalMethods.GetM3ByMCF(YCQ);
}
dr_data_ycq["YCValue"] = YCQ;
dt_data.Rows.Add(dr_data_ycq);
}
e.Result = m_PreMonthDataService.Insert(dt_data);
dbAccess.Commit();
}
