public string UserAuthentication(string login_mail, string login_password, string devid, string sk)
{
string[,] p = new string[2, 3];
p[0, 0] = "login_mail";
p[1, 0] = login_mail;
p[0, 1] = "login_password";
p[1, 1] = login_password;
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"));
}
login_mail = SEC.SECURITY_ContentDecrypt(login_mail);
string query = "select HCCU_ID from HCCU_FACT WHERE HCCU_UID='" + login_mail + "' AND SUBSTRING(HCCU_PSW,4,LEN(HCCU_PSW)-7)=SUBSTRING('" + login_password + "',4,LEN('" + login_password + "')-7)";
try
{
string ret0 = DataHelperForDevService.Query_ExecuteScalar(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
return(SEC.SECURITY_ContentEncrypt(ret0)); // return -2 if the input para equals null.
}
catch {
return(SEC.SECURITY_ContentEncrypt("0"));
}
}
public string GetHCCUNetworkInfo(string devid, string sk)
{
string[,] p = new string[2, 1];
p[0, 0] = "devid";
p[1, 0] = devid;
devid = SEC.SECURITY_ContentDecrypt(devid);
if (!SEC.SECURITY_RequestDecrypt(p, sk, devid))
{
return(SEC.SECURITY_ContentEncrypt("-4"));
}
string query = "select * from hccu_mac_fact where hccu_id='" + devid + "'";
DataTable dt = DataHelperForDevService.Query_SqlDataAdapter(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
if (dt.Rows.Count == 0)
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
else
{
string returns = "";
for (int x = 0; x < dt.Rows.Count; x++)
{
returns += dt.Rows[0]["IP"].ToString() + "," + dt.Rows[0]["PORT"].ToString() + "|";
}
return(SEC.SECURITY_ContentEncrypt(returns));
}
}
public string UserAuthenticationWithLocalIPVarify(string login_id, string login_password, string devid, string sk)
{
string[,] p = new string[2, 3];
p[0, 0] = "login_id";
p[1, 0] = login_id;
p[0, 1] = "login_password";
p[1, 1] = login_password;
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"));
}
login_id = SEC.SECURITY_ContentDecrypt(login_id);
string query = "select HCCU_ID from HCCU_FACT WHERE HCCU_UID='" + login_id + "' AND HCCU_PSW = '" + login_password + "'";
try
{
string ret0 = DataHelperForDevService.Query_ExecuteScalar(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
string query2 = "select ip from v_hccu where hccu_id='" + ret0 + "'";
string ret1 = DataHelperForDevService.Query_ExecuteScalar(DataHelperForDevService.DataBaseFact.CENTRAL, query2, null);
return(SEC.SECURITY_ContentEncrypt(ret0 + "|" + ret1));
}
catch
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
}
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 GetCurrentExecOrder(string para, string cosid, string devid, string sk)
{
string[,] p = new string[2, 3];
p[0, 0] = "para";
p[1, 0] = para;
p[0, 1] = "cosid";
p[1, 1] = cosid;
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"));
}
para = SEC.SECURITY_ContentDecrypt(para);
cosid = SEC.SECURITY_ContentDecrypt(cosid);
string query0 = "select count(*) from endpoint_fact where hccu_id='" + cosid + "'";
string ret0 = DataHelperForDevService.Query_ExecuteScalar(DataHelperForDevService.DataBaseFact.CENTRAL, query0, null);
if (ret0 == "0")
{
return(SEC.SECURITY_ContentEncrypt("-3"));
}
string query = "select * from exec_order where ep_id = '" + para + "'";
DataTable dt = DataHelperForDevService.Query_SqlDataAdapter(DataHelperForDevService.DataBaseFact.PROPERTY, query, null);
if (dt.Rows.Count == 0)
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
else
{
string ret = "";
for (int x = 0; x < dt.Rows.Count; x++)
{
ret += dt.Rows[x]["PROP"].ToString().Trim() + "," + dt.Rows[x]["VALUE"].ToString().Trim() + "," + dt.Rows[x]["ORDER_DATE"].ToString().Trim() + "," + dt.Rows[x]["IFSENT"].ToString().Trim()
+ "," + dt.Rows[x]["EXPIRE"].ToString().Trim() + "|";
}
return(SEC.SECURITY_ContentEncrypt(ret));
}
}
public string DeleteEndPoint(string para, string cosid, string devid, string sk)
{
string[,] p = new string[2, 3];
p[0, 0] = "para";
p[1, 0] = para;
p[0, 1] = "cosid";
p[1, 1] = cosid;
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"));
}
para = SEC.SECURITY_ContentDecrypt(para);
cosid = SEC.SECURITY_ContentDecrypt(cosid);
string query = "select count(*) from ENDPOINT_FACT WHERE EP_ID='" + para + "' AND HCCU_ID = '" + cosid + "'";
string ret0 = DataHelperForDevService.Query_ExecuteScalar(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
if (ret0 == "0")
{
return(SEC.SECURITY_ContentEncrypt("-2"));
}
string[,] pa = new string[2, 1];
pa[0, 0] = "EP_ID";
pa[1, 0] = para;
string[,] op = new string[2, 1];
op[0, 0] = "RET";
op[1, 0] = DataHelperForDevService.OUTPUT_PARA_INT16;
List <SqlParameter> ret = DataHelperForDevService.QueryWithSP_OUTPUT(DataHelperForDevService.DataBaseFact.CENTRAL, "EP_DELETE_SP", pa, op);
if (((SqlParameter)ret[0]).Value.ToString().Trim() != "1")
{
return(SEC.SECURITY_ContentEncrypt("-3"));
}
return(SEC.SECURITY_ContentEncrypt("1"));
}
public string DeleteEPCategory(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);
string[,] pa = new string[2, 1];
pa[0, 0] = "EP_TYPEID";
pa[1, 0] = para;
string[,] op = new string[2, 1];
op[0, 0] = "RET";
op[1, 0] = DataHelperForDevService.OUTPUT_PARA_INT16;
List <SqlParameter> ret = DataHelperForDevService.QueryWithSP_OUTPUT(DataHelperForDevService.DataBaseFact.CENTRAL, "EPTYPE_DELETE_SP", pa, op);
string retvalue = ((SqlParameter)ret[0]).Value.ToString().Trim();
if (retvalue == "1")
{
return(SEC.SECURITY_ContentEncrypt("1"));
}
else
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
}
public string invoke(string epid, string method, string para, string devid, string sk)
{
string[,] p = new string[2, 4];
p[0, 0] = "epid";
p[1, 0] = epid;
p[0, 1] = "method";
p[1, 1] = method;
p[0, 2] = "para";
p[1, 2] = para;
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"));
}
epid = SEC.SECURITY_ContentDecrypt(epid);
method = SEC.SECURITY_ContentDecrypt(method);
para = SEC.SECURITY_ContentDecrypt(para);
string query = "SELECT * FROM EP_PRODUCT_METHODS_FACT"
+ " WHERE EP_PRODUCT_ID"
+ " IN"
+ " (SELECT EP_PRODUCTID FROM ENDPOINT_FACT WHERE EP_ID = '" + epid + "') AND METHODNAME='" + method + "'";
DataTable dt = DataHelperForDevService.Query_SqlDataAdapter(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
if (dt.Rows.Count == 0)
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
string methodname = dt.Rows[0]["MethodName"].ToString();
string returnType = dt.Rows[0]["returntype"].ToString();
string paracollection = dt.Rows[0]["paracollection"].ToString();
string id = dt.Rows[0]["id"].ToString();
string sp_para = "";
string procedurename = "invokMethod_" + id;
#region 确定双方参数数量
int paracollection_number = 0;
int para_number = 0;
try
{
if (paracollection.Trim() == "")
{
paracollection_number = 0;
}
if (paracollection.IndexOf(',') == -1)
{
paracollection_number = 1;
}
else
{
string[] s = paracollection.Split(',');
paracollection_number = s.Length;
}
if (para.Trim() == "")
{
para_number = 0;
}
if (para.IndexOf(',') == -1)
{
para_number = 1;
}
else
{
string[] s = para.Split(',');
para_number = s.Length;
}
}
catch { }
#endregion
if (paracollection_number + 1 != para_number)
{
return(SEC.SECURITY_ContentEncrypt("-1"));
}
if (paracollection_number == 0)
{
sp_para += " @SESSIONINEPID = N'" + para + "' ";
}
else if (paracollection_number == 1)
{
sp_para += paracollection + "=N'" + para.Split(',')[0].ToString().Trim() + "', @SESSIONINEPID = N'" + para.Split(',')[1].ToString().Trim() + "' ";
}
else
{
string[] x = paracollection.Split(',');
string[] y = para.Split(',');
for (int j = 0; j < x.Length; j++)
{
sp_para += x[j].ToString().Trim() + "=" + y[j].ToString().Trim() + ", ";
}
sp_para += " @SESSIONINEPID = N'" + y[x.Length].ToString().Trim() + "' ";
}
if (returnType == "1")
{
sp_para += " ,@INVOKERETURN = @INVOKERETURN OUTPUT; SELECT @INVOKERETURN AS 'RET','1' AS 'STA'";
}
else
{
sp_para += "; SELECT '0' AS 'RET', '1' AS 'STA'";
}
string execquery = "DECLARE @INVOKERETURN NVARCHAR(500); EXEC " + procedurename + " " + sp_para;
try
{
DataTable dts = DataHelperForDevService.Query_SqlDataAdapter(DataHelperForDevService.DataBaseFact.PROPERTY, execquery, null);
if (dts == null)
{
return(SEC.SECURITY_ContentEncrypt("-3"));
}
if (dts.Rows.Count == 0)
{
return(SEC.SECURITY_ContentEncrypt("-3"));
}
else
{
return(SEC.SECURITY_ContentEncrypt(dts.Rows[0]["RET"].ToString() + "," + dts.Rows[0]["STA"].ToString()));
}
}
catch
{
return(SEC.SECURITY_ContentEncrypt("-3"));
}
}
public string GetEndPoint(string para, string getendpointlistmode, string devid, string sk)
{
string[,] p = new string[2, 3];
p[0, 0] = "para";
p[1, 0] = para;
p[0, 1] = "getendpointlistmode";
p[1, 1] = getendpointlistmode;
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"));
}
para = SEC.SECURITY_ContentDecrypt(para);
getendpointlistmode = SEC.SECURITY_ContentDecrypt(getendpointlistmode);
if (para.IndexOf('^') != -1 && para.IndexOf('#') != -1)
{
para = Decode_hc(para);
}
string query = "";
string ret = "";
if (getendpointlistmode == getendpointlistmodeenum.devid.ToString())
{
query = "select * from endpoint_Fact where hccu_id='" + para + "'";
}
else if (getendpointlistmode == getendpointlistmodeenum.epid.ToString())
{
query = "select * from endpoint_Fact where ep_id='" + para + "'";
}
else if (getendpointlistmode == getendpointlistmodeenum.epmodeid.ToString())
{
query = "select * from endpoint_Fact where ep_productid='" + para + "'";
}
else if (getendpointlistmode == getendpointlistmodeenum.epmodename.ToString())
{
query = "select * from endpoint_Fact where ep_productid"
+ " in"
+ " (select ep_product_id from endpoint_product_fact where ep_product_name='" + para + "' and dev_id='" + devid + "')";
}
else if (getendpointlistmode == getendpointlistmodeenum.epname.ToString())
{
query = "select * from endpoint_Fact where ep_userdefined_alias='" + para + "' and hccu_id='" + devid + "'";
}
DataTable dt = DataHelperForDevService.Query_SqlDataAdapter(DataHelperForDevService.DataBaseFact.CENTRAL, query, null);
if (dt.Rows.Count == 0)
{
return(SEC.SECURITY_ContentEncrypt("0"));
}
for (int s = 0; s < dt.Rows.Count; s++)
{
ret += dt.Rows[0]["EP_ID"].ToString().Trim() + "," + dt.Rows[0]["EP_TYPEID"].ToString().Trim() + "," + Encode(dt.Rows[0]["EP_USERDEFINED_ALIAS"].ToString().Trim()) + ","
+ dt.Rows[0]["EP_PRODUCTID"].ToString().Trim() + "," + dt.Rows[0]["HCCU_ID"].ToString().Trim() + "," + dt.Rows[0]["EP_MAC_ID"].ToString().Trim() + "|";
}
return(SEC.SECURITY_ContentEncrypt(ret));
}
