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); }
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 DataTable GetProcessUsage(HttpContext context) { YZRequest request = new YZRequest(context); string type = request.GetString("Type", "year"); int year = request.GetInt32("year", DateTime.Today.Year); int month = request.GetInt32("month", -1); if (String.Compare(type, "year", true) == 0) { month = -1; } using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider) { using (IDbConnection cn = provider.OpenConnection()) { using (YZReader reader = new YZReader(provider.GetProcessUsage(cn, year, month))) { DataTable table = reader.LoadTable(); PageResult.RegularColumnsName(table, new string[] { "ProcessName", "Counts", "Total", "Per" }); return(table); } } } }
public virtual object GetExpenseTypes(HttpContext context) { YZRequest request = new YZRequest(context); using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider) { using (IDbConnection cn = provider.OpenConnection()) { using (IDbCommand cmd = cn.CreateCommand()) { cmd.CommandText = "SELECT * FROM YZMDExpenseType"; using (YZReader reader = new YZReader(cmd.ExecuteReader())) { DataTable table = reader.LoadTable(); PageResult.RegularColumnsName(table, new string[] { "Code", "Text", "NameSpace", "Image" }); return(table); } } } } }
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 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 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); }
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 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); } }
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); } }
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 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 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 ServiceContacts(YZReader reader) { this.Product = reader.ReadString("Product"); this.ServiceCenter = reader.ReadString("ServiceCenter"); this.Description = reader.ReadString("Description"); this.Tel = reader.ReadString("Tel"); this.OrderIndex = reader.ReadInt32("OrderIndex"); }
public Speak(YZReader reader) { this.ItemID = reader.ReadInt32("ItemID"); this.Account = reader.ReadString("Account"); this.FileID = reader.ReadString("FileID"); this.Duration = reader.ReadInt32("Duration"); this.Comments = reader.ReadString("Comments"); this.CreateAt = reader.ReadDateTime("CreateAt"); }
public Favorite(YZReader reader) { this.uid = reader.ReadString("uid"); this.resType = (YZResourceType)reader.ReadEnum("resType", typeof(YZResourceType), YZResourceType.Process); this.resId = reader.ReadString("resId"); this.date = reader.ReadDateTime("date"); this.comments = reader.ReadString("comments"); this.orderIndex = reader.ReadInt32("orderIndex"); }
public YZMessage(YZReader reader) { this.id = reader.ReadInt32("id"); this.uid = reader.ReadString("uid"); this.date = reader.ReadDateTime("date"); this.resType = (YZResourceType)reader.ReadEnum("resType", typeof(YZResourceType), YZResourceType.Task); this.resId = reader.ReadString("resId"); this.message = reader.ReadString("message"); }
public YZMessageVote(IDataReader reader) { YZReader dbr = new YZReader(reader); this.id = dbr.ReadInt32("id"); this.messageid = dbr.ReadInt32("messageid"); this.uid = dbr.ReadString("uid"); this.date = dbr.ReadDateTime("date"); }
public SpriteLink(YZReader reader) { this.FileID = reader.ReadString("FileID"); this.SpriteID = reader.ReadString("SpriteID"); this.LinkType = reader.ReadEnum <ReferenceType>("LinkType", ReferenceType.SpriteToSprite); this.LinkedFileID = reader.ReadString("LinkedFileID"); this.LinkedSpriteID = reader.ReadString("LinkedSpriteID"); this.LinkedByProperty = reader.ReadString("LinkedByProperty"); }
public SMS(YZReader reader) { this.ItemGUID = reader.ReadString("ItemGUID"); this.IDDCode = reader.ReadString("IDDCode"); this.PhoneNumber = reader.ReadString("PhoneNumber"); this.ValidationCode = reader.ReadString("ValidationCode"); this.ExpireDate = reader.ReadDateTime("ExpireDate"); this.CreateDate = reader.ReadDateTime("CreateDate"); this.CreateBy = reader.ReadString("CreateBy"); }
public Barcode(YZReader reader) { this.ItemID = reader.ReadInt32("ItemID"); this.Account = reader.ReadString("Account"); this.BarcodeValue = reader.ReadString("Barcode"); this.Format = reader.ReadString("Format"); this.ProductName = reader.ReadString("ProductName"); this.Comments = reader.ReadString("Comments"); this.CreateAt = reader.ReadDateTime("CreateAt"); }
public Device(YZReader reader) { this.Account = reader.ReadString("Account"); this.UUID = reader.ReadString("UUID"); this.Name = reader.ReadString("Name"); this.Model = reader.ReadString("Model"); this.Description = reader.ReadString("Description"); this.Disabled = reader.ReadBool("Disabled", false); this.RegisterAt = reader.ReadDateTime("RegisterAt"); this.LastLogin = reader.ReadDateTime("LastLogin"); }
public P2PGroup(YZReader reader) { this.GroupID = reader.ReadInt32("GroupID"); this.Account1 = reader.ReadString("Account1"); this.Account2 = reader.ReadString("Account2"); this.UserName1 = reader.ReadString("UserName1"); this.UserName2 = reader.ReadString("UserName2"); this.FolderID = reader.ReadInt32("FolderID"); this.CreateBy = reader.ReadString("CreateBy"); this.CreateAt = reader.ReadDateTime("CreateAt"); }
public Cash(YZReader reader) { this.ItemID = reader.ReadInt32("ItemID"); this.Account = reader.ReadString("Account"); this.Type = reader.ReadString("Type"); this.Date = reader.ReadDateTime("Date"); this.Amount = reader.ReadDecimal("Amount"); this.Invoice = reader.ReadString("Invoice"); this.Comments = reader.ReadString("Comments"); this.CreateAt = reader.ReadDateTime("CreateAt"); }
public static YZMessageCollection GetNewMessages(IDbConnection cn, YZResourceType resType, string resId, int maxReadedMessageId) { IYZDBProvider dbProvider = YZDBProviderManager.CurrentProvider; IDbCommand cmd = dbProvider.GetResourceCommunicationNewMessagesCommand(resType, resId, maxReadedMessageId); cmd.Connection = cn; using (YZReader reader = new YZReader(cmd.ExecuteReader())) { YZMessageCollection messages = new YZMessageCollection(reader); return(messages); } }
public YZMessage(IDataReader reader) { YZReader dbr = new YZReader(reader); this.id = dbr.ReadInt32("id"); this.replyto = dbr.ReadInt32("replyto"); this.uid = dbr.ReadString("uid"); this.date = dbr.ReadDateTime("date"); this.resType = (YZResourceType)dbr.ReadEnum("resType", typeof(YZResourceType), YZResourceType.Task); this.resId = dbr.ReadString("resId"); this.message = dbr.ReadString("message"); this.duration = dbr.ReadInt32("duration"); }