public JsonItemCollection GetFactorys(IDbConnection cn) { JsonItemCollection factorys = new JsonItemCollection(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cn as SqlConnection; cmd.CommandText = "SELECT * FROM iSYSFactory"; using (YZReader reader = new YZReader(cmd.ExecuteReader())) { while (reader.Read()) { JsonItem factory = new JsonItem(); factorys.Add(factory); factory.Attributes["ID"] = reader.ReadInt32("ID"); factory.Attributes["Name"] = reader.ReadString("Name"); factory.Attributes["MapX"] = reader.ReadInt32("MapX"); factory.Attributes["MapY"] = reader.ReadInt32("MapY"); } } } return(factorys); }
/// <summary> /// 返回sql数据库列表 /// </summary> /// <param name="provider"></param> /// <param name="cn"></param> /// <param name="dataSource"></param> /// <param name="user"></param> /// <param name="pwd"></param> /// <returns></returns> public static JArray GetSqlServerDBList(string dataSource, string user, string pwd) { try { string conStr = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3}", dataSource, "master", user, pwd); using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(conStr)) { con.Open(); using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = con; cmd.CommandText = @"select name from master..sysdatabases"; using (YZReader reader = new YZReader(cmd.ExecuteReader())) { JArray array = new JArray(); while (reader.Read()) { JObject obj = new JObject(); obj["text"] = reader.ReadString("name"); obj["value"] = reader.ReadString("name"); array.Add(obj); } return(array); } } } } catch (Exception ex) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "sysdatabases", ex.Message); } }
public static Library GetLibrary(IYZDbProvider provider, IDbConnection cn, int libid) { Library lib = null; try { using (YZReader reader = new YZReader(provider.GetLibrary(cn, libid))) { if (reader.Read()) { lib = new Library(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppLibrary", e.Message); } if (lib == null) { throw new BPMException(String.Format(Resources.YZStrings.Aspx_Library_Ext_LibraryNotExist, libid)); } return(lib); }
public static Cash GetCash(IYZDbProvider provider, IDbConnection cn, int itemid) { Cash cash = null; try { using (YZReader reader = new YZReader(provider.GetNotesCash(cn, itemid))) { if (reader.Read()) { cash = new Cash(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppNotesCash", e.Message); } if (cash == null) { throw new BPMException(String.Format(Resources.YZStrings.Aspx_RecordNotExist, itemid)); } return(cash); }
public static Barcode GetBarcode(IYZDbProvider provider, IDbConnection cn, int itemid) { Barcode barcode = null; try { using (YZReader reader = new YZReader(provider.GetNotesBarcode(cn, itemid))) { if (reader.Read()) { barcode = new Barcode(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppNotesBarcode", e.Message); } if (barcode == null) { throw new BPMException(String.Format(Resources.YZStrings.Aspx_RecordNotExist, itemid)); } return(barcode); }
public static Speak GetSpeak(IYZDbProvider provider, IDbConnection cn, int itemid) { Speak speak = null; try { using (YZReader reader = new YZReader(provider.GetNotesSpeak(cn, itemid))) { if (reader.Read()) { speak = new Speak(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppNotesSpeak", e.Message); } if (speak == null) { throw new BPMException(String.Format(Resources.YZStrings.Aspx_RecordNotExist, itemid)); } return(speak); }
public static LibraryCollection GetLibraries(IYZDbProvider provider, IDbConnection cn, string libType, string filter, string sort) { try { LibraryCollection alllibs = new LibraryCollection(); using (YZReader reader = new YZReader(provider.GetLibraries(cn, libType, filter, sort))) { while (reader.Read()) { Library lib = new Library(reader); if (!String.IsNullOrEmpty(lib.Name)) { alllibs.Add(lib); } } } return(alllibs); } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppLibrary", e.Message); } }
private static SourceInfo ReaderToEntity(YZReader reader) { reader.Read(); SourceInfo source = new SourceInfo(); source.sourceId = reader.ReadInt32("sourceId"); source.sourceName = reader.ReadString("sourceName"); source.sourceType = reader.ReadEnum <SourceTypeEnum>("connectType", SourceTypeEnum.NoType); source.sourceStr = reader.ReadString("sourceStr"); source.caption = reader.ReadString("caption"); source.createTime = reader.ReadDateTime("createTime"); source.updateTime = reader.ReadDateTime("updateTime"); source.isvalid = reader.ReadBool("isvalid", false); ConnectInfo connect = new ConnectInfo(); connect.connectId = reader.ReadInt32("connectId"); connect.connectName = reader.ReadString("connectName"); connect.connectType = reader.ReadEnum <SourceTypeEnum>("connectType", SourceTypeEnum.NoType); connect.caption = reader.ReadString("caption"); connect.connectStr = reader.ReadString("connectStr"); connect.createTime = reader.ReadDateTime("createTime"); connect.updateTime = reader.ReadDateTime("updateTime"); connect.isvalid = reader.ReadBool("isvalid", false); source.connectInfo = connect; return(source); }
public static GroupCollection GetGroupsAndMemberCount(IYZDbProvider provider, IDbConnection cn, string uid, string filter, string sort) { try { GroupCollection groups = new GroupCollection(); using (YZReader reader = new YZReader(provider.GetGroupsAndMemberCount(cn, uid, filter, sort))) { while (reader.Read()) { Group group = new Group(reader); group.MemberCount = reader.ReadInt32("MemberCount"); if (!String.IsNullOrEmpty(group.Name)) { groups.Add(group); } } } return(groups); } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppGroup", e.Message); } }
protected static object RenderLeaveType(string fieldXClass, object value) { using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider) { using (IDbConnection cn = provider.OpenConnection()) { using (IDbCommand cmd = cn.CreateCommand()) { IDbDataParameter pmTypeCode = provider.CreateParameter("TypeCode", value, true); cmd.CommandText = String.Format("select * from YZMDLeavingType WHERE TypeCode={0}", pmTypeCode.ParameterName); cmd.Parameters.Add(pmTypeCode); using (YZReader reader = new YZReader(cmd.ExecuteReader())) { if (reader.Read()) { return(reader.ReadString("Name")); } else { return(value); } } } } } }
public virtual IDataReader GetTopicNewMessageCount(IDbConnection cn, YZResourceType resType, string resId, string uid) { using (OracleCommand cmd = new OracleCommand()) { cmd.Connection = cn as OracleConnection; cmd.BindByName = true; cmd.CommandText = "select NVL(max(readId),0) from YZAppCommunicationRead WHERE resType=:resType and resId=:resId and \"UID\"=:pm_uid"; cmd.Parameters.Add(":resType", OracleDbType.NVarchar2).Value = resType.ToString(); cmd.Parameters.Add(":resId", OracleDbType.NVarchar2).Value = resId; cmd.Parameters.Add(":pm_uid", OracleDbType.NVarchar2).Value = uid; int readId = 0; using (YZReader rd = new YZReader(cmd.ExecuteReader())) { if (rd.Read()) { readId = rd.ReadInt32(0); } } cmd.Parameters.Clear(); cmd.CommandText = "select count(*) from YZAppCommunication WHERE resType=:resType and resId=:resId and id>:readId"; cmd.Parameters.Add(":resType", OracleDbType.NVarchar2).Value = resType.ToString(); cmd.Parameters.Add(":resId", OracleDbType.NVarchar2).Value = resId; cmd.Parameters.Add(":readId", OracleDbType.Int32).Value = readId; return(cmd.ExecuteReader()); } }
public static P2PGroup GetGroup(IYZDbProvider provider, IDbConnection cn, int groupid) { P2PGroup group = null; try { using (YZReader reader = new YZReader(provider.GetP2PGroup(cn, groupid))) { if (reader.Read()) { group = new P2PGroup(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppP2PGroup", e.Message); } if (group == null) { throw new BPMException(String.Format(Resources.YZStrings.Aspx_Group_Ext_GroupNotExist, groupid)); } return(group); }
public JArray GetFactorys(IDbConnection cn) { JArray factorys = new JArray(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cn as SqlConnection; cmd.CommandText = "SELECT * FROM iSYSFactory"; using (YZReader reader = new YZReader(cmd.ExecuteReader())) { while (reader.Read()) { JObject factory = new JObject(); factorys.Add(factory); factory["ID"] = reader.ReadInt32("ID"); factory["Name"] = reader.ReadString("Name"); factory["MapX"] = reader.ReadInt32("MapX"); factory["MapY"] = reader.ReadInt32("MapY"); } } } return(factorys); }
public YZMessageCollection(YZReader reader) { while (reader.Read()) { YZMessage message = new YZMessage(reader); this.Add(message); } }
public FavoriteCollection(YZReader reader) { while (reader.Read()) { Favorite favorite = new Favorite(reader); this.Add(favorite); } }
public static bool HasVoted(IYZDbProvider provider, IDbConnection cn, int messageid, string uid) { try { using (YZReader reader = new YZReader(provider.HasVoted(cn, messageid, uid))) { reader.Read(); return(reader.ReadInt32(0) == 0 ? false:true); } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppCommunicationVote", e.Message); } }
public static int GetVotePraisedCount(IYZDbProvider provider, IDbConnection cn, int messageid) { try { using (YZReader reader = new YZReader(provider.GetVotePraisedCount(cn, messageid))) { reader.Read(); return(reader.ReadInt32(0)); } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBInsertDataErr, "YZAppCommunicationVote", e.Message); } }
public static int GetNewMessageCount(IYZDbProvider provider, IDbConnection cn, YZResourceType resType, string resId, string uid) { try { using (YZReader reader = new YZReader(provider.GetTopicNewMessageCount(cn, resType, resId, uid))) { reader.Read(); return(reader.ReadInt32(0)); } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBInsertDataErr, "YZAppCommunication", e.Message); } }
public static bool HasFavorited(IYZDbProvider provider, IDbConnection cn, string uid, YZResourceType resType, string resId) { try { using (YZReader reader = new YZReader(provider.HasFavorited(cn, uid, resType, resId))) { reader.Read(); return(reader.ReadInt32(0) == 0 ? false : true); } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZSysFavorites", e.Message); } }
public static int GetNewMessageCount(IDbConnection cn, string uid, YZResourceType resType, string resId) { IYZDBProvider dbProvider = YZDBProviderManager.CurrentProvider; IDbCommand cmd = dbProvider.GetResourceCommunicationNewMessageCountCommand(uid, resType, resId); cmd.Connection = cn; using (YZReader reader = new YZReader(cmd.ExecuteReader())) { if (reader.Read()) { return(reader.ReadInt32(0)); } else { return(0); } } }
public static BPMObjectNameCollection GetNotifyUsersTaskSocial(IYZDbProvider provider, IDbConnection cn, int taskid) { try { BPMObjectNameCollection uids = new BPMObjectNameCollection(); using (YZReader reader = new YZReader(provider.GetNotifyUsersTaskSocial(cn, taskid))) { while (reader.Read()) { uids.Add(reader.ReadString(0)); } return(uids); } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "BPMInstProcSteps", e.Message); } }
public static BPMObjectNameCollection GetUidsFromRegisterId(IYZDbProvider provider, IDbConnection cn, string registerId) { try { BPMObjectNameCollection uids = new BPMObjectNameCollection(); using (YZReader reader = new YZReader(provider.GetUidsFromPushNotificationRegisterId(cn, registerId))) { while (reader.Read()) { uids.Add(reader.ReadString(0)); } return(uids); } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "BPMSysUserCommonInfo", e.Message); } }
private static ConnectInfoCollection ReaderToEntityList(YZReader reader) { ConnectInfoCollection rv = new ConnectInfoCollection(); while (reader.Read()) { ConnectInfo connect = new ConnectInfo(); connect.connectId = reader.ReadInt32("connectId"); connect.connectName = reader.ReadString("connectName"); connect.connectType = reader.ReadEnum <SourceTypeEnum>("connectType", SourceTypeEnum.NoType); connect.caption = reader.ReadString("caption"); connect.connectStr = reader.ReadString("connectStr"); connect.createTime = reader.ReadDateTime("createTime"); connect.updateTime = reader.ReadDateTime("updateTime"); connect.isvalid = reader.ReadBool("isvalid", false); rv.Add(connect); } return(rv); }
public static FileCollection GetFiles(IYZDbProvider provider, IDbConnection cn, int parentFolderID, string filter, string sort, int top) { try { FileCollection files = new FileCollection(); using (YZReader reader = new YZReader(provider.GetFiles(cn, parentFolderID, filter, sort, top))) { while (reader.Read()) { File file = new File(reader); files.Add(file); } } return(files); } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppFolderFiles", e.Message); } }
public static SpriteLinkCollection GetFileUsedByLinks(IYZDbProvider provider, IDbConnection cn, string fileid, string property) { try { SpriteLinkCollection links = new SpriteLinkCollection(); using (YZReader reader = new YZReader(provider.GetFileUsedByLinks(cn, fileid, property))) { while (reader.Read()) { SpriteLink link = new SpriteLink(reader); links.Add(link); } } return(links); } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "BPASpriteLink", e.Message); } }
public static UserPositionCollection GetUserPositions(IYZDbProvider provider, IDbConnection cn, string uid) { try { UserPositionCollection poses = new UserPositionCollection(); using (YZReader reader = new YZReader(provider.GetUserPositions(cn, uid))) { while (reader.Read()) { UserPosition pos = new UserPosition(reader); poses.Add(pos); } } return(poses); } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "BPAUserPosition", e.Message); } }
public static MonthlyReportCollection GetReports(IYZDbProvider provider, IDbConnection cn, string account, int year) { try { MonthlyReportCollection rv = new MonthlyReportCollection(); using (YZReader reader = new YZReader(provider.GetMonthlyReports(cn, account, year))) { while (reader.Read()) { rv.Add(new MonthlyReport(reader)); } } return(rv); } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "iMonthlyReport", e.Message); } }
public static P2PGroup TryGetGroup(IYZDbProvider provider, IDbConnection cn, string account1, string account2) { P2PGroup group = null; try { using (YZReader reader = new YZReader(provider.GetP2PGroup(cn, account1, account2))) { if (reader.Read()) { group = new P2PGroup(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZAppP2PGroup", e.Message); } return(group); }
public static SMS TryGetSMS(IYZDbProvider provider, IDbConnection cn, string itemguid) { SMS sms = null; try { using (YZReader reader = new YZReader(provider.GetValidationSMS(cn, itemguid))) { if (reader.Read()) { sms = new SMS(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZSysSMSValidation", e.Message); } return(sms); }
public static Device TryGetDevice(IYZDbProvider provider, IDbConnection cn, string account, string uuid) { Device device = null; try { using (YZReader reader = new YZReader(provider.GetDevice(cn, account, uuid))) { if (reader.Read()) { device = new Device(reader); } } } catch (Exception e) { throw new BPMException(BPMExceptionType.DBLoadDataErr, "YZSysMobileDevice", e.Message); } return(device); }