/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int UpdateUserInfo(UserInfo user)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "UPDATE USERINFO SET LOGINID=:p1,PASSWORD=:p2,ROLEID=:p3,ISLOGIN=:p4,STATE=:p5 " +
" WHERE USERID =:p6)";
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", user.LOGINID);
oraCMD.Parameters.Add(":p2", user.PASSWORD);
oraCMD.Parameters.Add(":p3", user.ROLEID);
oraCMD.Parameters.Add(":p4", user.ISLOGIN);
oraCMD.Parameters.Add(":p5", user.STATE);
oraCMD.Parameters.Add(":p6", user.USERID);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
public static Area getArea(string areacode)
{
Area area = new Area();
OracleConnection oraVectorConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraVectorConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT AREACODE,AREANAME FROM AREA WHERE AREACODE = '" + areacode + "'";
oraCMD = new OracleCommand(sql, oraVectorConn);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
area = new Area(Convert.ToString(oraDataReader["AREACODE"]), Convert.ToString(oraDataReader["AREANAME"]));
}
oraVectorConn.Close();
oraCMD.Dispose();
return(area);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public static int ImportUserInfo(UserInfo userInfo)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "INSERT INTO USERINFO(USERID,LOGINID,PASSWORD,ROLEID,ISLOGIN,STATE) " +
" VALUES(sys_guid(),:p1, :p2, :p3,:p4,:p5)";
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", userInfo.LOGINID);
oraCMD.Parameters.Add(":p2", userInfo.PASSWORD);
oraCMD.Parameters.Add(":p3", userInfo.ROLEID);
oraCMD.Parameters.Add(":p4", userInfo.ISLOGIN);
oraCMD.Parameters.Add(":p5", userInfo.STATE);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
public static List <Area> getProvinceList(string nationCode)
{
List <Area> area = new List <Area>();
OracleConnection oraVectorConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraVectorConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT SUBSTR(AREACODE,4,2)AS AREACODE,AREANAME FROM AREA WHERE AREACODE <> '"
+ nationCode + "000000' and AREACODE LIKE '" + nationCode + "%' GROUP BY SUBSTR(AREACODE,4,2),AREANAME";
oraCMD = new OracleCommand(sql, oraVectorConn);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
area.Add(new Area(Convert.ToString(oraDataReader["AREACODE"]), Convert.ToString(oraDataReader["AREANAME"])));
}
oraVectorConn.Close();
oraCMD.Dispose();
return(area);
}
public static int ImportFileIndex(string layerID, string xmlfile)
{
if (String.IsNullOrEmpty(layerID) || String.IsNullOrEmpty(xmlfile))
{
return(0);
}
OracleConnection oraRasterConn;
OracleCommand oraCMD;
oraRasterConn = DBCon.OraConOpen();;
StringBuilder sql;
sql = new StringBuilder("UPDATE FILE_LAYERS SET XMLFILE=:p1 WHERE LAYERID=:p2");
oraCMD = new OracleCommand(sql.ToString(), oraRasterConn);
oraCMD.Parameters.Add(":p1", layerID);
oraCMD.Parameters.Add(":p2", OraBlob.WriteBolb(xmlfile));
int result = oraCMD.ExecuteNonQuery();
oraRasterConn.Close();
oraCMD.Dispose();
return(result);
}
public static int UpdateRole(Role role)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "UPDATE ROLE SET ROLENAME=:p1,QUERYGRADER=:p2,GETGRADER=:p3 " +
" WHERE ROLEID=:p4";
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", role.ROLENAME);
oraCMD.Parameters.Add(":p2", role.QUERYGRADER);
oraCMD.Parameters.Add(":p3", role.GETGRADER);
oraCMD.Parameters.Add(":p4", role.ROLEID);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
public static int ImportHandleLog(HandleLog HL)
{
OracleConnection oraFileConn;
OracleCommand oraCMD;
oraFileConn = DBCon.OraConOpen();;
StringBuilder sql;
sql = new StringBuilder("INSERT INTO HANDLELOG(LOGID,USERID, TYPE,BEGINDATE,ENDDATE,DESCRIPTION, LAYERSIZE,RESULT,TARGETDB, TARGETITEM,BATCHID)");
sql.Append(" VALUES(sys_guid(),:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10)");
oraCMD = new OracleCommand(sql.ToString(), oraFileConn);
oraCMD.Parameters.Add(":p1", HL.USERID);
oraCMD.Parameters.Add(":p2", HL.TYPE.ToString());
oraCMD.Parameters.Add(":p3", HL.BEGINDATE);
oraCMD.Parameters.Add(":p4", HL.ENDDATE);
oraCMD.Parameters.Add(":p5", HL.DESCRIPTION);
oraCMD.Parameters.Add(":p6", HL.LAYERSIZE);
oraCMD.Parameters.Add(":p7", HL.RESULT);
oraCMD.Parameters.Add(":p8", HL.TARGETDB);
oraCMD.Parameters.Add(":p9", HL.TARGETITEM);
oraCMD.Parameters.Add(":p10", HL.BATCHID);
int result = oraCMD.ExecuteNonQuery();
oraFileConn.Close();
oraCMD.Dispose();
return(result);
}
public static List <string> getDataSource()
{
List <string> datasource = new List <string>();
OracleConnection oraVectorConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraVectorConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT NAME FROM DATASOURCE";
oraCMD = new OracleCommand(sql, oraVectorConn);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
while (oraDataReader.Read())
{
//int fieldCount = oraDataReader.FieldCount;
datasource.Add(Convert.ToString(oraDataReader["NAME"]));
}
oraVectorConn.Close();
oraCMD.Dispose();
return(datasource);
}
public static VectorLayer GetVectorIndexById(string LayerID)
{
VectorLayer VL = new VectorLayer();
OracleConnection oraVectorConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraVectorConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT * FROM VECTOR_LAYERS WHERE LAYERID = :p1";
oraCMD = new OracleCommand(sql, oraVectorConn);
oraCMD.Parameters.Add(":p1", LayerID);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
string fieldName = oraDataReader.GetName(i).ToString();
if (fieldName.Equals("XMLFILE"))
{
try
{
byte[] data = (byte[])oraDataReader["XMLFILE"];
UTF8Encoding enc = new UTF8Encoding(true, true);//如果blob数据原本为utf8编码
VL.XMLFILE = System.Text.Encoding.UTF8.GetString(data);
}
catch
{
VL.XMLFILE = "";
}
}
else
{
VL = InitVectorData(VL, oraDataReader[fieldName], fieldName);
}
}
}
oraVectorConn.Close();
oraCMD.Dispose();
return(VL);
}
public static int ImportFileIndex(FileLayer FL, string xmlfile)
{
OracleConnection oraFileConn;
OracleCommand oraCMD;
oraFileConn = DBCon.OraConOpen();;
StringBuilder sql;
sql = new StringBuilder("INSERT INTO FILE_LAYERS(LAYERID,LAYERNAME,DBNAME,URI,MAPNUM,SCALE,PROJECTION,AUTHOR," +
"CREATETIME,DATATYPE,DESCRIPTION,OPENAS,ISFOLDER,LAYERSIZE,ISEXIST,QUERYGRADER,GETGRADER,REGION,DATAGETDATE,DATAFORMAT,DATASOURCES");
if (String.IsNullOrEmpty(xmlfile))
{
sql.Append(",XMLFILE");
}
sql.Append(" ) VALUES(sys_guid(),:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14,:p15,:p16, :p17, :p18,:p19,:p20");
if (String.IsNullOrEmpty(xmlfile))
{
sql.Append(",:p21");
}
sql.Append(")");
oraCMD = new OracleCommand(sql.ToString(), oraFileConn);
oraCMD.Parameters.Add(":p1", FL.LAYERNAME);
oraCMD.Parameters.Add(":p2", FL.DBNAME);
oraCMD.Parameters.Add(":p3", FL.URI);
oraCMD.Parameters.Add(":p4", FL.MAPNUM);
oraCMD.Parameters.Add(":p5", FL.SCALE);
oraCMD.Parameters.Add(":p6", FL.PROJECTION);
oraCMD.Parameters.Add(":p7", FL.AUTHOR);
oraCMD.Parameters.Add(":p8", FL.CREATETIME);
oraCMD.Parameters.Add(":p9", FL.DATATYPE);
oraCMD.Parameters.Add(":p10", FL.DESCRIPTION);
oraCMD.Parameters.Add(":p11", FL.OPENAS);
oraCMD.Parameters.Add(":p12", Convert.ToInt64(FL.ISFOLDER));
oraCMD.Parameters.Add(":p13", FL.LAYERSIZE);
oraCMD.Parameters.Add(":p14", Convert.ToInt64(FL.ISEXIST));
oraCMD.Parameters.Add(":p15", FL.QUERYGRADER);
oraCMD.Parameters.Add(":p16", FL.GETGRADER);
oraCMD.Parameters.Add(":p17", FL.REGION);
oraCMD.Parameters.Add(":p18", FL.DATAGETDATE);
oraCMD.Parameters.Add(":p19", FL.DATAFORMAT);
oraCMD.Parameters.Add(":p20", FL.DATASOURCES);
if (String.IsNullOrEmpty(xmlfile))
{
oraCMD.Parameters.Add(":p21", OraBlob.WriteBolb(xmlfile));
}
int result = oraCMD.ExecuteNonQuery();
oraFileConn.Close();
oraCMD.Dispose();
return(result);
}
public static List <HandleLog> GetHandleLogByTargetAndType(string targetDB, string targetItem, string type)
{
List <HandleLog> HLs = new List <HandleLog>();
OracleConnection oraFileConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraFileConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT * FROM HANDLELOG WHERE TARGETDB = :p1 AND TARGETITEM=:p2 ";
if (!String.IsNullOrEmpty(type))
{
sql += " AND TYPE=:p3";;
}
oraCMD = new OracleCommand(sql, oraFileConn);
oraCMD.Parameters.Add(":p1", targetDB);
oraCMD.Parameters.Add(":p2", targetItem);
if (!String.IsNullOrEmpty(type))
{
oraCMD.Parameters.Add(":p3", type);
}
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
HandleLog HL;
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
HL = new HandleLog();
for (int i = 0; i < fieldCount; i++)
{
string fieldName = oraDataReader.GetName(i).ToString();
HL = InitHandleLogData(HL, oraDataReader[fieldName], fieldName);
}
HLs.Add(HL);
}
oraFileConn.Close();
oraCMD.Dispose();
return(HLs);
}
public void ReadBolb()
{
OracleConnection connn = DBCon.OraConOpen();
OracleCommand cmddd = connn.CreateCommand();
cmddd.CommandText = "select * from TEST where PID='21C67F3362EB421ABAE4844C8303C8FA'";
OracleDataReader rs = cmddd.ExecuteReader();
while (rs.Read())//读取数据，如果odr.Read()返回为false的话，就说明到记录集的尾部了
{
byte[] data = (byte[])rs["TE"];
UTF8Encoding enc = new UTF8Encoding(true, true);//如果blob数据原本为utf8编码
string s = System.Text.Encoding.UTF8.GetString(data);
MessageBox.Show(s);
}
rs.Close();
}
public static TreeNode GetTreeNode(string DB, string DBName)
{
OracleConnection oraConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraConn = DBCon.OraConOpen();;
string sql;
sql = string.Format("SELECT * FROM {0} WHERE DBNAME = :p1", DB);
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", DBName);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
TreeNode nowNode = new TreeNode(DBName);
nowNode.Tag = DB;
string errMSG = "";
while (oraDataReader.Read())
{
TreeNode childNode = new TreeNode();
try { childNode.Tag = oraDataReader["LAYERID"]; }
catch { errMSG += "LAYERID;"; }
try { childNode.Text = Convert.ToString(oraDataReader["LAYERNAME"]); }
catch { errMSG += "LAYERNAME;"; }
nowNode.Nodes.Add(childNode);
}
oraConn.Close();
oraCMD.Dispose();
return(nowNode);
}
/// <summary>
/// 用户登录信息
/// </summary>
/// <param name="loginId"></param>
/// <param name="pwd"></param>
/// <returns>用户信息</returns>
public static UserInfo GetUserInfoByLoginInfo(string loginId, string pwd)
{
UserInfo userinfo = new UserInfo();
OracleConnection oraRasterConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraRasterConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT * FROM USERINFO WHERE LOGINID = :p1 AND PASSWORD = :p2 AND ISLOGIN=0 AND STATE = 0";
oraCMD = new OracleCommand(sql, oraRasterConn);
oraCMD.Parameters.Add(":p1", loginId);
oraCMD.Parameters.Add(":p2", pwd);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
string fieldName = oraDataReader.GetName(i).ToString();
userinfo = InitUserInfoData(userinfo, oraDataReader[fieldName], fieldName);
}
}
oraRasterConn.Close();
oraCMD.Dispose();
return(userinfo);
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int DeleteUserInfo(UserInfo user)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "DELETE FROM USERINFO WHERE USERID=:p1";
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", user.USERID);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
/// <summary>
/// 修改用户状态
/// </summary>
/// <param name="userId"></param>
/// <param name="state"></param>
/// <returns></returns>
public static int ChangeUserInfoState(string userId, int state)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "UPDATE USERINFO SET STATE=:p1 WHERE USERID =:p2)";
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", state);
oraCMD.Parameters.Add(":p2", userId);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
public static Role GetRoleById(string roleId)
{
Role role = new Role();
OracleConnection oraRasterConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraRasterConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT * FROM ROLE WHERE ROLEID = :p1";
oraCMD = new OracleCommand(sql, oraRasterConn);
oraCMD.Parameters.Add(":p1", roleId);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
string fieldName = oraDataReader.GetName(i).ToString();
role = InitRoleData(role, oraDataReader[fieldName], fieldName);
}
}
oraRasterConn.Close();
oraCMD.Dispose();
return(role);
}
public static HandleLog GetHandleLogById(string LogID)
{
HandleLog HL = new HandleLog();
OracleConnection oraFileConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraFileConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT * FROM HANDLELOG WHERE LOGID = :p1";
oraCMD = new OracleCommand(sql, oraFileConn);
oraCMD.Parameters.Add(":p1", LogID);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
string fieldName = oraDataReader.GetName(i).ToString();
HL = InitHandleLogData(HL, oraDataReader[fieldName], fieldName);
}
}
oraFileConn.Close();
oraCMD.Dispose();
return(HL);
}
/// <summary>
/// 用户授权
/// </summary>
/// <param name="userId"></param>
/// <param name="roleId"></param>
/// <returns></returns>
public static int AuthorizationUserInfo(string userId, string roleId)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "UPDATE USERINFO SET ROLEID=:p1 WHERE USERID =:p2)";
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", roleId);
oraCMD.Parameters.Add(":p2", userId);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
public static int DeleteRole(Role role)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "DELETE FROM ROLE WHERE ROLEID=:p1";
oraCMD = new OracleCommand(sql, oraConn);
// oraCMD.Parameters.Add();
oraCMD.Parameters.Add(":p1", role.ROLEID);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
public static int ImportRole(Role role)
{
OracleConnection oraConn;
OracleCommand oraCMD;
oraConn = DBCon.OraConOpen();;
string sql;
sql = "INSERT INTO ROLE(ROLEID,ROLENAME,QUERYGRADER,GETGRADER) " +
" VALUES(sys_guid(),:p1, :p2, :p3)";
oraCMD = new OracleCommand(sql, oraConn);
oraCMD.Parameters.Add(":p1", role.ROLENAME);
oraCMD.Parameters.Add(":p2", role.QUERYGRADER);
oraCMD.Parameters.Add(":p3", role.GETGRADER);
int result = oraCMD.ExecuteNonQuery();
oraConn.Close();
oraCMD.Dispose();
return(result);
}
public static int ImportRasterIndex(RasterLayer RL, string xmlfile)
{
OracleConnection oraRasterConn;
OracleCommand oraCMD;
oraRasterConn = DBCon.OraConOpen();
//string sql;
StringBuilder sql;
sql = new StringBuilder("INSERT INTO RASTER_LAYERS(LAYERID,LAYERNAME,DBNAME,URI,MAPNUM,SCALE,PROJECTION,AUTHOR," +
"CREATETIME,DATATYPE,DESCRIPTION,BANDCOUNT,MINX,MAXX,MINY,MAXY,HEIGHT,WIDTH,RESOLUTION," +
"NODATAVALUE,ISVISIBLE,LAYERSIZE,ISEXIST,QUERYGRADER,GETGRADER,REGION,DATAGETDATE,DATAFORMAT,DATASOURCES");
if (!String.IsNullOrEmpty(xmlfile))
{
sql.Append(",XMLFILE ");
}
sql.Append(") VALUES(sys_guid(),:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13," +
" :p14, :p15, :p16, :p17, :p18, :p19, :p20,:p21,:p22,:p23,:p24,:p25,:p26,:p27,:p28");
if (!String.IsNullOrEmpty(xmlfile))
{
sql.Append(",:p29");
}
sql.Append(")");
oraCMD = new OracleCommand(sql.ToString(), oraRasterConn);
oraCMD.Parameters.Add(":p1", RL.LAYERNAME);
oraCMD.Parameters.Add(":p2", RL.DBNAME);
oraCMD.Parameters.Add(":p3", RL.URI);
oraCMD.Parameters.Add(":p4", RL.MAPNUM);
oraCMD.Parameters.Add(":p5", RL.SCALE);
oraCMD.Parameters.Add(":p6", RL.PROJECTION);
oraCMD.Parameters.Add(":p7", RL.AUTHOR);
oraCMD.Parameters.Add(":p8", RL.CREATETIME);
oraCMD.Parameters.Add(":p9", RL.DATATYPE);
oraCMD.Parameters.Add(":p10", RL.DESCRIPTION);
oraCMD.Parameters.Add(":p11", RL.BANDCOUNT);
oraCMD.Parameters.Add(":p12", RL.MINX);
oraCMD.Parameters.Add(":p13", RL.MAXX);
oraCMD.Parameters.Add(":p14", RL.MINY);
oraCMD.Parameters.Add(":p15", RL.MAXY);
oraCMD.Parameters.Add(":p16", RL.HEIGHT);
oraCMD.Parameters.Add(":p17", RL.WIDTH);
oraCMD.Parameters.Add(":p18", RL.RESOLUTION);
oraCMD.Parameters.Add(":p19", RL.NODATAVALUE);
oraCMD.Parameters.Add(":p20", Convert.ToInt64(RL.ISVISIBLE));
oraCMD.Parameters.Add(":p21", RL.LAYERSIZE);
oraCMD.Parameters.Add(":p22", Convert.ToInt64(RL.ISEXIST));
oraCMD.Parameters.Add(":p23", RL.QUERYGRADER);
oraCMD.Parameters.Add(":p24", RL.GETGRADER);
oraCMD.Parameters.Add(":p25", RL.REGION);
oraCMD.Parameters.Add(":p26", RL.DATAGETDATE);
oraCMD.Parameters.Add(":p27", RL.DATAFORMAT);
oraCMD.Parameters.Add(":p28", RL.DATASOURCES);
if (!String.IsNullOrEmpty(xmlfile))
{
oraCMD.Parameters.Add(":p29", OraBlob.WriteBolb(xmlfile));
}
int result = oraCMD.ExecuteNonQuery();
oraRasterConn.Close();
oraCMD.Dispose();
return(result);
}
public static List <FileLayer> GetFileLayerBySearchConditions(string dbName, SearchConditions sc)
{
if (String.IsNullOrEmpty(dbName) || sc == null)
{
return(null);
}
List <FileLayer> FLs = new List <FileLayer>();
OracleConnection oraRasterConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraRasterConn = DBCon.OraConOpen();;
StringBuilder sql;
sql = new StringBuilder("SELECT * FROM FILE_LAYERS WHERE 1=1 AND DBNAME='" + dbName + "' ");
if (sc.area.Count > 0)
{
sql.Append("AND ( ");
foreach (string s in sc.area)
{
sql.Append(" AND REGION LIKE '" + s + "' OR ");
}
sql.Append("1<>1 )");
}
if (sc.datasource.Count > 0)
{
sql.Append("AND ( ");
foreach (string s in sc.datasource)
{
sql.Append(" AND DATASOURCES='" + s + "' OR ");
}
sql.Append("1<>1 )");
}
if (sc.scale.Count > 0 && sc.scale.Count == 2)
{
sql.Append(" AND SCALE BETWEEN " + sc.scale[0] + " AND " + sc.scale[1]);
}
if (!String.IsNullOrEmpty(sc.keywords))
{
sql.Append(" AND (LAYERNAME LIKE '" + sc.keywords + "%' OR DESCRIPTION LIKE '%" + sc.keywords + "%')");
}
oraCMD = new OracleCommand(sql.ToString(), oraRasterConn);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(null); }
if (!oraDataReader.HasRows)
{
return(null);
}
FileLayer FL;
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
FL = new FileLayer();
for (int i = 0; i < fieldCount; i++)
{
string fieldName = oraDataReader.GetName(i).ToString();
if (fieldName.Equals("XMLFILE"))
{
try
{
byte[] data = (byte[])oraDataReader["XMLFILE"];
UTF8Encoding enc = new UTF8Encoding(true, true);//如果blob数据原本为utf8编码
FL.XMLFILE = System.Text.Encoding.UTF8.GetString(data);
}
catch
{
FL.XMLFILE = "";
}
}
else
{
FL = InitFileData(FL, oraDataReader[fieldName], fieldName);
}
}
FLs.Add(FL);
}
oraRasterConn.Close();
oraCMD.Dispose();
return(FLs);
}
/// <summary>
/// 用户登陆状况
/// return 0 :登陆成功，1：登录失败，2：用户停用，3:用户已登录，4：未授权用户
/// </summary>
/// <param name="loginId">uuuu</param>
/// <param name="pwd"></param>
/// <returns></returns>
public static int UserInfoLogin(string loginId, string pwd, out UserInfo userinfo)
{
userinfo = new UserInfo();
int result = -1;
OracleConnection oraRasterConn;
OracleCommand oraCMD;
OracleDataReader oraDataReader;
oraRasterConn = DBCon.OraConOpen();;
string sql;
sql = "SELECT * FROM USERINFO WHERE LOGINID = :p1 AND PASSWORD = :p2 ";
oraCMD = new OracleCommand(sql, oraRasterConn);
oraCMD.Parameters.Add(":p1", loginId);
oraCMD.Parameters.Add(":p2", pwd);
try { oraDataReader = oraCMD.ExecuteReader(); }
catch { return(result); }
if (!oraDataReader.HasRows)
{
result = 1;
return(result);
}
while (oraDataReader.Read())
{
int fieldCount = oraDataReader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
string fieldName = oraDataReader.GetName(i).ToString();
userinfo = InitUserInfoData(userinfo, oraDataReader[fieldName], fieldName);
}
}
oraRasterConn.Close();
oraCMD.Dispose();
if (userinfo == null)
{
result = 1;
}
else if (userinfo.STATE == 1)
{
result = 2;
}
else if (userinfo.ISLOGIN == 1)
{
result = 3;
}
else if (userinfo.ROLEID == null)
{
result = 4;
}
else
{
result = 1;
}
return(result);
}
