public string AddEPCategory(string categoryname, string categorydesp, string cosid, string devid, string sk)
{
string[,] p = new string[2, 4];
p[0, 0] = "categoryname";
p[1, 0] = categoryname;
p[0, 1] = "categorydesp";
p[1, 1] = categorydesp;
p[0, 2] = "cosid";
p[1, 2] = cosid;
p[0, 3] = "devid";
p[1, 3] = devid;
devid = SEC.SECURITY_ContentDecrypt(devid);
if (!SEC.SECURITY_RequestDecrypt(p, sk, devid))
{
return(SEC.SECURITY_ContentEncrypt("-4"));
}
categoryname = SEC.SECURITY_ContentDecrypt(categoryname);
categorydesp = SEC.SECURITY_ContentDecrypt(categorydesp);
cosid = SEC.SECURITY_ContentDecrypt(cosid);
COS_WEBSERVICE_EPTYPE c = new COS_WEBSERVICE_EPTYPE();
return(SEC.SECURITY_ContentEncrypt(c.EPTYPE_Add(categoryname, categorydesp, cosid).ToString()));
}
public string GetEPCategory(string para, string devid, string sk)
{
string[,] p = new string[2, 2];
p[0, 0] = "para";
p[1, 0] = para;
p[0, 1] = "devid";
p[1, 1] = devid;
devid = SEC.SECURITY_ContentDecrypt(devid);
if (!SEC.SECURITY_RequestDecrypt(p, sk, devid))
{
return(SEC.SECURITY_ContentEncrypt("-4"));
}
para = SEC.SECURITY_ContentDecrypt(para);
if (para != "0")
{
string query = "select * from endpoint_type_fact where HCCU_ID='" + devid + "' and EP_TYPE_ID='" + para + "'";
DataTable dt = DataHelperForDevService.Query_SqlDataAdapter(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
if (dt.Rows.Count == 0)
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
string ret = "";
for (int x = 0; x < dt.Rows.Count; x++)
{
ret += dt.Rows[x]["EP_TYPE_ID"].ToString() + "," + dt.Rows[x]["EP_TYPE_NAME"].ToString() + "," + dt.Rows[x]["EP_TYPE_DESCRIPTION"].ToString() + "|";
}
return(ret);
}
else
{
COS_WEBSERVICE_EPTYPE c = new COS_WEBSERVICE_EPTYPE();
ArrayList al = c.EPTYPE_GetList(devid);
string ret = "";
if (al.Count == 0)
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
for (int x = 0; x < al.Count; x++)
{
if (al[x].ToString().Trim() == "-1" || al[x].ToString().Trim() == "-2")
{
return(SEC.SECURITY_ContentEncrypt("-3"));
}
ret += al[x].ToString() + "|";
}
return(ret);
}
}
public string EPTYPE_GetList(string HCCU_ID, string SK)
{
string[,] p = new string[2, 1];
p[0, 0] = "HCCU_ID";
p[1, 0] = HCCU_ID;
if (!COS_SECURITY_TOOL.SECURITY_RequestDecrypt(p, SK))
{
return(COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-4"));
}
HCCU_ID = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(HCCU_ID);
COS_WEBSERVICE_EPTYPE cos_w_ep = new COS_WEBSERVICE_EPTYPE();
ArrayList a = new ArrayList();
a = cos_w_ep.EPTYPE_GetList(HCCU_ID);
if (a.Count == 0)
{
return(COS_SECURITY_TOOL.SECURITY_ContentEncrypt("0"));
}
else
{
if (a[0].ToString().Trim() == "-1")
{
return(COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-1"));
}
else if (a[0].ToString().Trim() == "-2")
{
return(COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-2"));
}
else
{
string ret = "";
for (int j = 0; j < a.Count; j++)
{
ret += a[j].ToString().Trim() + "|";
}
ret = ret.Substring(0, ret.Length - 1);
return(COS_SECURITY_TOOL.SECURITY_ContentEncrypt(ret));
}
}
}
public string EPTYPE_Add(string EP_Type_name, string EP_Type_Description, string HCCU_ID, string SK)
{
string[,] p = new string[2, 3];
p[0, 0] = "EP_Type_name";
p[1, 0] = EP_Type_name;
p[0, 1] = "EP_Type_Description";
p[1, 1] = EP_Type_Description;
p[0, 2] = "HCCU_ID";
p[1, 2] = HCCU_ID;
if (!COS_SECURITY_TOOL.SECURITY_RequestDecrypt(p, SK)) return COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-4");
EP_Type_name = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(EP_Type_name);
EP_Type_Description = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(EP_Type_Description);
HCCU_ID = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(HCCU_ID);
COS_WEBSERVICE_EPTYPE cos_w_ep = new COS_WEBSERVICE_EPTYPE();
return COS_SECURITY_TOOL.SECURITY_ContentEncrypt(cos_w_ep.EPTYPE_Add(EP_Type_name, EP_Type_Description, HCCU_ID).ToString());
}
public string EPTYPE_Add(string EP_Type_name, string EP_Type_Description, string HCCU_ID, string SK)
{
string[,] p = new string[2, 3];
p[0, 0] = "EP_Type_name";
p[1, 0] = EP_Type_name;
p[0, 1] = "EP_Type_Description";
p[1, 1] = EP_Type_Description;
p[0, 2] = "HCCU_ID";
p[1, 2] = HCCU_ID;
if (!COS_SECURITY_TOOL.SECURITY_RequestDecrypt(p, SK))
{
return(COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-4"));
}
EP_Type_name = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(EP_Type_name);
EP_Type_Description = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(EP_Type_Description);
HCCU_ID = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(HCCU_ID);
COS_WEBSERVICE_EPTYPE cos_w_ep = new COS_WEBSERVICE_EPTYPE();
return(COS_SECURITY_TOOL.SECURITY_ContentEncrypt(cos_w_ep.EPTYPE_Add(EP_Type_name, EP_Type_Description, HCCU_ID).ToString()));
}
public string EPTYPE_GetList(string HCCU_ID,string SK)
{
string[,] p = new string[2, 1];
p[0, 0] = "HCCU_ID";
p[1, 0] = HCCU_ID;
if (!COS_SECURITY_TOOL.SECURITY_RequestDecrypt(p, SK)) return COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-4");
HCCU_ID = COS_SECURITY_TOOL.SECURITY_ContentDecrypt(HCCU_ID);
COS_WEBSERVICE_EPTYPE cos_w_ep = new COS_WEBSERVICE_EPTYPE();
ArrayList a = new ArrayList();
a = cos_w_ep.EPTYPE_GetList(HCCU_ID);
if (a.Count == 0)
{
return COS_SECURITY_TOOL.SECURITY_ContentEncrypt("0");
}
else {
if (a[0].ToString().Trim() == "-1") {
return COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-1");
}
else if (a[0].ToString().Trim() == "-2")
{
return COS_SECURITY_TOOL.SECURITY_ContentEncrypt("-2");
}
else {
string ret = "";
for (int j = 0; j < a.Count; j++) {
ret += a[j].ToString().Trim() + "|";
}
ret = ret.Substring(0, ret.Length - 1);
return COS_SECURITY_TOOL.SECURITY_ContentEncrypt(ret);
}
}
}
public string GetEPCategory(string para, string devid, string sk)
{
string[,] p = new string[2, 2];
p[0, 0] = "para";
p[1, 0] = para;
p[0, 1] = "devid";
p[1, 1] = devid;
devid = SEC.SECURITY_ContentDecrypt(devid);
if (!SEC.SECURITY_RequestDecrypt(p, sk, devid)) return SEC.SECURITY_ContentEncrypt("-4");
para = SEC.SECURITY_ContentDecrypt(para);
if (para != "0")
{
string query = "select * from endpoint_type_fact where HCCU_ID='" + devid + "' and EP_TYPE_ID='" + para + "'";
DataTable dt = DataHelperForDevService.Query_SqlDataAdapter(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
if (dt.Rows.Count == 0) return SEC.SECURITY_ContentEncrypt("0");
string ret = "";
for (int x = 0; x < dt.Rows.Count; x++)
{
ret += dt.Rows[x]["EP_TYPE_ID"].ToString() + "," + dt.Rows[x]["EP_TYPE_NAME"].ToString() + "," + dt.Rows[x]["EP_TYPE_DESCRIPTION"].ToString() + "|";
}
return ret;
}
else
{
COS_WEBSERVICE_EPTYPE c = new COS_WEBSERVICE_EPTYPE();
ArrayList al = c.EPTYPE_GetList(devid);
string ret = "";
if (al.Count == 0) return SEC.SECURITY_ContentEncrypt("0");
for (int x = 0; x < al.Count; x++)
{
if (al[x].ToString().Trim() == "-1" || al[x].ToString().Trim() == "-2") return SEC.SECURITY_ContentEncrypt("-3");
ret += al[x].ToString() + "|";
}
return ret;
}
}
public string AddEPCategory(string categoryname, string categorydesp, string devid, string sk)
{
string[,] p = new string[2, 3];
p[0, 0] = "categoryname";
p[1, 0] = categoryname;
p[0, 1] = "categorydesp";
p[1, 1] = categorydesp;
p[0, 2] = "devid";
p[1, 2] = devid;
devid = SEC.SECURITY_ContentDecrypt(devid);
if (!SEC.SECURITY_RequestDecrypt(p, sk, devid)) return SEC.SECURITY_ContentEncrypt("-4");
categoryname = SEC.SECURITY_ContentDecrypt(categoryname);
categorydesp = SEC.SECURITY_ContentDecrypt(categorydesp);
COS_WEBSERVICE_EPTYPE c = new COS_WEBSERVICE_EPTYPE();
return c.EPTYPE_Add(categoryname, categorydesp, devid).ToString();
}
