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