public IActionResult ExportPersonContractList()
{
SearchStruct search = new SearchStruct()
{
//ComContractNumber= "CF2019SNEC0006CC",
//ComNameTranslation = "testgaopeng",
//ConferenceId = "a8e5ce7a-3543-460d-891f-118d5c4edfb3",
//ContractTypeId= "ee00dc29-8556-4635-8fe3-80f2428f5b1e",
//CcIsdelete = false
//IsDiscount = false,
//IsFillPC = false,
//IsGive = false,
Year = "2020",
//IsContractTypeWithECode = false,
//CTypeCode = "AS,E"
//ContractStatusCode="S1,W",
//CompanyId= "60cec3ac-08ed-4dd9-bcd7-d35de69d2c43",
//CompanyServicePackId= "7750eb23-2ba8-4762-b3c8-3ec38d68c5ae",
//ComPrice="0",
Owerid = "65dddd36-971f-4f75-ac93-7830e3ce4c3b"
//SessionConferenceId = "c7bdbb1b-888d-414a-a009-4a71a6f78435"
//InviteCodeId = "43d68534-bc4e-435b-9e01-18272307fb3c"
//InviteCodeNumber = "11111"
};
var result = CCServiceClient.ExportPersonContractList(search);
return(Ok(result));
}
private void button2_Click(object sender, EventArgs e)
{
if (ofd.ShowDialog() == DialogResult.OK)
{
currentPath = ofd.FileName;
Text = $"Словарик {currentPath.Split('\\')[currentPath.Split('\\').Length - 1]}";
var allText = File.ReadAllText(ofd.FileName);
words = allText.Split('\\')[1];
structType = allText.Split('\\')[0];
definitions.AddRange(File.ReadAllLines($"{ofd.FileName}.definitions"));
try
{
structure = Deserealize(words); //AVLTree<string>
if (structure != null)
{
fillTreeView(structure.ToString(), Text);
}
button4.Enabled = true;
button5.Enabled = true;
}
catch (Exception)
{
MessageBox.Show("Неверный тип структуры данных");
}
}
}
public IActionResult GetPersonContractListAndApplyConference(int pageindex, int pagesize)
{
SearchStruct search = new SearchStruct()
{
//MemTranslation= "张冰洁",
//MemberPK = "9485c410-a742-477e-8291-3600abf0e8e5",
//CompanyServicePackId = "7410f4cb-d1b0-4e66-a8f4-67ac0914e678,37d9fc6f-870a-4102-9d04-7229330edaa3,37d9fc6f-870a-4102-9d04-7229330edaa3,b4cd9af4-db28-4ee6-b3b3-c4d54cd50dfb,7b7f2ec2-8cbd-4f30-9580-e8470375f456,b5eeeaac-b692-4ce9-ab99-a4a5bcb05daf,a1400684-6169-47e5-8006-91a1d94106b2",
//Year = "2020",
//PcIsdelete = true,
//CompanyId= "99e21994-0b7a-48f8-a2ef-012b0ec6be32",
//MemTranslation="ning165"
//IsGive = false
//ExTypeCode = "esh"
//SessionConferenceId = "c9b3aa72-e6b8-4fd3-83ee-baf72c293a45," +
//"5154ed2f-445a-4cc6-94de-addb8efa1040," +
//"8e7f585a-6a4a-41c8-8637-bfea82535642," +
//"e6793a90-961c-4c9e-870a-70db4aff264f," +
//"18b48377-98f3-4cd3-a9a9-6c4bb91c3ddd," +
//"43a83692-440c-4588-8f00-500bd6acc615"
//SessionConferenceId = "c9b3aa72-e6b8-4fd3-83ee-baf72c293a45"
};
var result = CCServiceClient.GetPersonContractListAndApplyConference(pageindex, pagesize, search);
return(Ok(result));
}
public static InviteCodeList GetInviteCodeList(int pageindex, int pagesize, SearchStruct search)
{
return(_client.GetInviteCodeList(new PaginationRequestSearch
{
Offset = pageindex,
Limit = pagesize,
Search = search
}));
}
private void SearchTimerSink(LifeTimeMonitor sender, object obj)
{
SearchStruct struct2 = (SearchStruct)obj;
if (this.OnSearch != null)
{
this.OnSearch(struct2.ST, struct2.Source, struct2.Local);
}
}
private void SearchTimerSink(LifeTimeMonitor sender, object obj)
{
SearchStruct SS = (SearchStruct)obj;
if (OnSearch != null)
{
OnSearch(SS.ST, SS.Source, SS.Local);
}
}
public IActionResult GetESList(int pageindex, int pagesize)
{
SearchStruct search = new SearchStruct();
//{
// Translation = ""
//};
var result = CCServiceClient.GetExtraServiceList(pageindex, pagesize, search);
return(Ok(result));
}
public IActionResult GetPersonContractActivityMapByMemberPKList()
{
SearchStruct search = new SearchStruct()
{
MemberPK = "a34af51d-185f-40a3-8739-136ead41954a",
Year = "2020"
};
var result = CCServiceClient.GetPersonContractActivityMapByMemberPKList(search);
return(Ok(result));
}
public IActionResult GetComSPList(int pageindex, int pagesize)
{
SearchStruct search = new SearchStruct
{
//Translation = "",
//ConferenceId= "a8e5ce7a-3543-460d-891f-118d5c4edfb3",
Year = "2020"
};
var result = CCServiceClient.GetCompanyServicePackList(pageindex, pagesize, search);
return(Ok(result));
}
public IActionResult GetPersonContractActivityMapByActivityIdList()
{
SearchStruct search = new SearchStruct()
{
ActivityId = "4cadc79b-258f-43a6-b177-a80e2c632f80",
PerContractNumber = "CF2019SNEC0001CW02001",
Year = "2019"
};
var result = CCServiceClient.GetPersonContractActivityMapByActivityIdList(search);
var result2 = CCServiceClient.GetPersonContractActivityMapByPersonContractNumberList(search);
return(Ok(result));
}
public IActionResult GetApplyConferenceBySessionConferenceIdListPagination(int pageindex, int pagesize)
{
SearchStruct search = new SearchStruct()
{
//ComContractNumber= "CF2019SNEC0006CC",
//ComNameTranslation = "乐密",
//ConferenceId = "a8e5ce7a-3543-460d-891f-118d5c4edfb3",
//ContractTypeId= "ee00dc29-8556-4635-8fe3-80f2428f5b1e",
//CcIsdelete = false
//IsDiscount = false
//IsFillPC = true
SessionConferenceId = "e5618b19-c2ce-4f74-b2ca-4998d32591a2,9e5f4bea-9603-47b9-8940-9bce798af6d3,a8ec27e7-447f-49ab-a545-7aed9f5865ff"
};
var result = CCServiceClient.GetApplyConferenceBySessionConferenceIdListPagination(pageindex, pagesize, search);
return(Ok(result));
}
public IActionResult GetConferenceContractList(int pageindex, int pagesize)
{
SearchStruct search = new SearchStruct()
{
//ComContractNumber= "CF2019SNEC0006CC",
//ComNameTranslation = "testgaopeng",
//ConferenceId = "a8e5ce7a-3543-460d-891f-118d5c4edfb3",
//ContractTypeId= "0dc7655a-bc5e-4079-a85e-d0b9b6dcde99",
//CcIsdelete = false
//IsDiscount = false
//Year = "2020"
};
var result = CCServiceClient.GetConferenceContractList(pageindex, pagesize, search);
//var result = CCServiceClient.GetConferenceContractListByIsGive(pageindex, pagesize, search);
return(Ok(result));
}
//查询项目
protected void Button1_Click(object sender, EventArgs e)
{
SearchStruct info1 = new SearchStruct();
info1.xmmc = this.xmmc.Text.Trim();
info1.xmsbh = this.xmsbh.Text.Trim();
info1.num2 = this.num2.Text.Trim();
info1.danwei = this.danwei.Text.Trim();
info1.spstatus = this.spstatus.SelectedValue.Trim();
info1.spresult = this.spresult.SelectedValue.Trim();
info1.status1 = this.status1.SelectedValue.Trim();
info1.status2 = this.status2.SelectedValue.Trim();
info1.zckind = this.zckind.SelectedValue.Trim();
info1.time1 = this.time1.Text.Trim();
info1.time2 = this.time2.Text.Trim();
Session["SearchXiangMu"] = info1;
this.SearchData(info1);
}
public IActionResult GetComContractList(int pageindex, int pagesize)
{
SearchStruct search = new SearchStruct()
{
//ComContractNumber= "CF2019SNEC0006CC",
//ComNameTranslation = "testgaopeng",
//ConferenceId = "a8e5ce7a-3543-460d-891f-118d5c4edfb3",
//ContractTypeId= "ee00dc29-8556-4635-8fe3-80f2428f5b1e",
//CcIsdelete = false
//IsDiscount = false,
//IsFillPC = false,
//IsGive = false,
//Year = "2020"
//IsContractTypeWithECode = false,
//CTypeCode = "AS,E"
//ContractStatusCode="S1,W",
//CompanyId= "60cec3ac-08ed-4dd9-bcd7-d35de69d2c43",
//CompanyServicePackId= "7750eb23-2ba8-4762-b3c8-3ec38d68c5ae",
//ComPrice="0",
//Owerid= "6b43b32c-d12e-4617-b157-912d74daf4d7"
//SessionConferenceId = "c7bdbb1b-888d-414a-a009-4a71a6f78435"
//InviteCodeId = "43d68534-bc4e-435b-9e01-18272307fb3c"
//InviteCodeNumber = "11111"
ComContractNumber = "CF2020SNEC0303CS",
Year = "2020"
};
//var result = CCServiceClient.GetDSPDList(pageindex, pagesize, search);
//var result = CCServiceClient.GetContractStatusDic();
//var result3 = CCServiceClient.GetDSPDFCCList(pageindex, pagesize, search);
//var result = CCServiceClient.GetInviteCodeList(pageindex, pagesize, search);
var result = CCServiceClient.GetCompanyContractList(pageindex, pagesize, search);
//var result = CCServiceClient.GetConferenceContractListByIsGiveWithAllContractStatusCode(pageindex, pagesize, search);
//var result = CCServiceClient.GetInviteCodeByInviteCodeNumber(search);
//var result = CCServiceClient.GetInviteCodeRecordList(pageindex, pagesize, search);
//var result2 = CCServiceClient.GetConferenceContractListByIsGive(pageindex, pagesize, search);
return(Ok(result));
}
public static CompanyServicePackVMStruct GetCompanyServicePackVMByPersonContractNumber(SearchStruct search)
{
return(_client.GetCompanyServicePackVMByPersonContractNumber(search));
}
public static PersonContractList GetPersonContractByMemberPKListWithNoPagination(SearchStruct search)
{
return(_client.GetPersonContractByMemberPKListWithNoPagination(search));
}
public static ApplyConferenceList GetApplyConferenceBySessionConferenceIdAndTagTypeCodeList(int pageindex, int pagesize, SearchStruct search)
{
return(_client.GetApplyConferenceBySessionConferenceIdAndTagTypeCodeList(new PaginationRequestSearch
{
Offset = pageindex,
Limit = pagesize,
Search = search
}));
}
//执行查询
private void SearchData(SearchStruct info1)
{
this.SearchTable.Visible = false;
this.SearchInfo.Visible = true;
U_FASPBU bu1 = new U_FASPBU();
DataSet ds1 = bu1.GetShenPiListBySearchCondition(info1);
////////////////////////////////////////////////////////
DataTable[] ArrData = new DataTable[] { new DataTable(), new DataTable() };
#region Code1
ds1.Tables[0].Columns.Add("sort1"); //增加排序列
ds1.Tables[0].Columns.Add("Money1", typeof(Double));
ds1.Tables[0].Columns.Add("money2", typeof(double));
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
//将查询结果的列写入Dt1和Dt2
ArrayList colName = new ArrayList();
foreach (DataColumn col1 in ds1.Tables[0].Columns)
{
DataColumn newCol1 = new DataColumn(col1.ColumnName, col1.DataType);
DataColumn newCol2 = new DataColumn(col1.ColumnName, col1.DataType);
ArrData[0].Columns.Add(newCol1);
ArrData[1].Columns.Add(newCol2);
colName.Add(col1.ColumnName); //得到列的数组
}
//得到资产包的ID列表；
ArrayList baozclist = this.GetZcbaoIDList();
//将数据写入Dt1和Dt2
//DataRow dr2=null;
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
//设置Sort1的值
String str1 = dr1["xmsbh"].ToString().Trim().Replace('－', '-');
String str2 = null;
if (str1.IndexOf('-') > 0)
{
String temp1 = str1.Split('-')[0].PadLeft(5, '0');
String temp2 = str1.Split('-')[1].PadLeft(5, '0');
str2 = temp1 + "-" + temp2;
}
else
{
str2 = str1.PadLeft(5, '0') + "-" + "00000";
}
str2 = str2 + "-" + dr1["num2"].ToString();
dr1["sort1"] = str2;
//将数据分别移到数据1表和数据2表
int i = 0;
String id = dr1["zcid"].ToString().Trim();
if (baozclist.Contains(id))
{
i = 1;
}
DataRow newdr = ArrData[i].NewRow();
foreach (String m in colName)
{
newdr[m] = dr1[m];
}
ArrData[i].Rows.Add(newdr);
}
}
#endregion
#region code2
for (int i = 0; i < ArrData.Length; i++)
{
//分别计算合计的户数和数据
if (ArrData[i] != null && ArrData[i].Rows.Count > 0)
{
ArrayList arr1 = new ArrayList();
double d1 = 0, d2 = 0, d3 = 0;
foreach (DataRow dr1 in ArrData[i].Rows)
{
String num2 = dr1["num2"].ToString().Trim();
if (String.IsNullOrEmpty(num2) == false)
{
if (arr1.Contains(num2) == false)
{
arr1.Add(num2);
}
}
/////////////////////////////////////////////////////
String temp = dr1["benjin"].ToString().Replace(",", "");
if (String.IsNullOrEmpty(temp))
{
temp = "0";
}
d1 = d1 + double.Parse(temp);
temp = dr1["lixi"].ToString().Replace(",", "");
if (String.IsNullOrEmpty(temp))
{
temp = "0";
}
d2 = d2 + double.Parse(temp);
temp = dr1["zqce"].ToString().Replace(",", "");
if (String.IsNullOrEmpty(temp))
{
temp = "0";
}
d3 = d3 + double.Parse(temp);
}
DataRow dr = ArrData[i].NewRow();
ArrData[i].Rows.Add(dr);
dr["status1"] = DBNull.Value;
dr["spstatus"] = " ";
dr["num2"] = " ";
dr["xmmc"] = "<center><b>合 计(" + arr1.Count + "户) </b></center>";
dr["benjin"] = d1.ToString();
dr["lixi"] = d2.ToString();
dr["zqce"] = d3.ToString();
dr["sort1"] = "ZZZZZ";
}
}
#endregion code2
//绑定数据
DataView view1 = null;
if (ArrData[0].Rows.Count + ArrData[1].Rows.Count > 0)
{
if (ArrData[0] == null || ArrData[0].Rows.Count == 0)
{
view1 = ArrData[1].DefaultView;
view1.Sort = "sort1";
this.GridView1.DataSource = view1;
this.GridView1.DataBind();
}
else
{
view1 = ArrData[0].DefaultView;
view1.Sort = "sort1";
this.GridView1.DataSource = view1;
this.GridView1.DataBind();
view1 = ArrData[1].DefaultView;
view1.Sort = "sort1";
this.GridView2.DataSource = view1;
this.GridView2.DataBind();
}
}
//展开导航项
Common_Master_Zcsp master1 = this.Master as Common_Master_Zcsp;
if (master1 != null)
{
master1.SetShowMax();
}
}
public static PersonContractList ExportPersonContractList(SearchStruct search)
{
return(_client.ExportPersonContractList(search));
}
public static ConferenceContractList GetConferenceContractListByIsGiveWithAllContractStatusCode(int pageindex, int pagesize, SearchStruct search)
{
return(_client.GetConferenceContractListByIsGiveWithAllContractStatusCode(new PaginationRequestSearch
{
Offset = pageindex,
Limit = pagesize,
Search = search
}));
}
public static ContractStatisticsList GetContractStatisticsList(SearchStruct search)
{
return(_client.GetContractStatisticsList(search));
}
private void ProcessPacket(HTTPMessage msg, IPEndPoint src, IPEndPoint local)
{
if (OnSniffPacket != null) OnSniffPacket(src, null, msg);
DText parser = new DText();
parser.ATTRMARK = "::";
bool Alive = false;
String UDN = msg.GetTag("USN");
parser[0] = UDN;
String USN = parser[1];
USN = USN.Substring(USN.IndexOf(":") + 1);
String ST = parser[2];
int MaxAge = 0;
String NTS = msg.GetTag("NTS").ToUpper();
if (NTS == "SSDP:ALIVE")
{
Alive = true;
String ma = msg.GetTag("Cache-Control").Trim();
if (ma != "")
{
parser.ATTRMARK = ",";
parser.MULTMARK = "=";
parser[0] = ma;
for (int i = 1; i <= parser.DCOUNT(); ++i)
{
if (parser[i, 1].Trim().ToUpper() == "MAX-AGE")
{
MaxAge = int.Parse(parser[i, 2].Trim());
break;
}
}
}
}
if (msg.Directive == "NOTIFY" && OnNotify != null)
{
Uri locuri = null;
string location = msg.GetTag("Location");
if (location != null && location.Length > 0) { try { locuri = new Uri(location); } catch (Exception) { } }
OnNotify(src, msg.LocalEndPoint, locuri, Alive, USN, ST, MaxAge, msg);
}
else if (msg.Directive == "M-SEARCH" && OnSearch != null)
{
if (ValidateSearchPacket(msg) == false) return;
int MaxTimer = int.Parse(msg.GetTag("MX"));
SearchStruct SearchData = new SearchStruct();
SearchData.ST = msg.GetTag("ST");
SearchData.Source = src;
SearchData.Local = local;
SearchTimer.Add(SearchData, RandomGenerator.Next(0, MaxTimer));
}
}
public static CompanyServicePackList GetCompanyServicePackList(int pageindex, int pagesize, SearchStruct search)
{
return(_client.GetCompanyServicePackList(new PaginationRequestSearch
{
Offset = pageindex,
Limit = pagesize,
Search = search
}));
}
public static DelegateServicePackDiscountForConferenceContractList GetDSPDFCCList(int pageindex, int pagesize, SearchStruct search)
{
return(_client.GetDSPDFCCList(new PaginationRequestSearch
{
Offset = pageindex,
Limit = pagesize,
Search = search
}));
}
public static ApplyConferenceList GetApplyConferenceByPerContractIdList(SearchStruct search)
{
return(_client.GetApplyConferenceByPerContractIdList(search));
}
public static PersonContractActivityMapList GetPersonContractActivityMapByPersonContractNumberList(SearchStruct search)
{
return(_client.GetPersonContractActivityMapByPersonContractNumberList(search));
}
public static PersonContractList GetPersonContractListAndApplyConference(int pageindex, int pagesize, SearchStruct search)
{
return(_client.GetPersonContractListAndApplyConference(new PaginationRequestSearch
{
Offset = pageindex,
Limit = pagesize,
Search = search
}));
}
private void ProcessPacket(HTTPMessage msg, IPEndPoint src, IPEndPoint local)
{
if (OnSniffPacket != null)
{
OnSniffPacket(src, null, msg);
}
DText parser = new DText();
parser.ATTRMARK = "::";
bool Alive = false;
String UDN = msg.GetTag("USN");
parser[0] = UDN;
String USN = parser[1];
USN = USN.Substring(USN.IndexOf(":") + 1);
String ST = parser[2];
int MaxAge = 0;
String NTS = msg.GetTag("NTS").ToUpper();
if (NTS == "SSDP:ALIVE")
{
Alive = true;
String ma = msg.GetTag("Cache-Control").Trim();
if (ma != "")
{
parser.ATTRMARK = ",";
parser.MULTMARK = "=";
parser[0] = ma;
for (int i = 1; i <= parser.DCOUNT(); ++i)
{
if (parser[i, 1].Trim().ToUpper() == "MAX-AGE")
{
MaxAge = int.Parse(parser[i, 2].Trim());
break;
}
}
}
}
if (msg.Directive == "NOTIFY" && OnNotify != null)
{
Uri locuri = null;
string location = msg.GetTag("Location");
if (location != null && location.Length > 0)
{
try
{
locuri = new Uri(location);
}
catch (Exception ex)
{
OpenSource.Utilities.EventLogger.Log(ex);
}
}
OnNotify(src, msg.LocalEndPoint, locuri, Alive, USN, ST, MaxAge, msg);
}
else if (msg.Directive == "M-SEARCH" && OnSearch != null)
{
if (ValidateSearchPacket(msg) == false)
{
return;
}
int MaxTimer = int.Parse(msg.GetTag("MX"));
SearchStruct SearchData = new SearchStruct();
SearchData.ST = msg.GetTag("ST");
SearchData.Source = src;
SearchData.Local = local;
SearchTimer.Add(SearchData, RandomGenerator.Next(0, MaxTimer));
}
}
public static ModifyReply CopyPackInfoByYear(SearchStruct model)
{
return(_client.CopyPackInfoByYear(model));
}
public static InviteCodeCSPVMStruct GetInviteCodeByInviteCodeNumber(SearchStruct search)
{
return(_client.GetInviteCodeByInviteCodeNumber(search));
}
public static PersonContractList GetPersonContractByMemberPKList(int pageindex, int pagesize, SearchStruct search)
{
return(_client.GetPersonContractByMemberPKList(new PaginationRequestSearch
{
Offset = pageindex,
Limit = pagesize,
Search = search
}));
}
