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");
}
