public void getCampsSupervisors()
{
clSys mu = new clSys();
string Comm1 = "select top 10 item_id id, f2 name, f3 age, f4 ageUnit, f5 address from persons";
System.Data.Common.DbDataReader R1 = mu.ExecuteReader(Comm1);
string json = "";
if (R1.HasRows)
{
string dataStr = "";
while (R1.Read())
{
dataStr += dataStr == "" ? "{\"id\":\"" + R1["id"] + "\",\"name\":\"" + R1["name"] + "\" "
+ "\"}"
:
","
+ "{\"id\":\"" + R1["id"] + "\",\"name\":\"" + R1["name"] + "\" "
+ "\"}";
}
json = "{\"success\":\"1\", \"error\":\"0\", \"title\" :[" + dataStr + "]}";
}
else
{
json = "{\"success\":\"1\", \"error\":\"0\", \"title\" :[{\"id\":\"noData\",\"name\":\"No data\"}]}";
}
R1.Close();
HttpContext.Current.Response.Write(json);
}
public string ShowMatInText(string strCondition)
{
string[] strArr = strCondition.Split(':');
System.Collections.ArrayList mass = new System.Collections.ArrayList();
System.Collections.ArrayList key1 = new System.Collections.ArrayList();
System.Collections.ArrayList key2 = new System.Collections.ArrayList();
System.Collections.ArrayList key3 = new System.Collections.ArrayList();
using (SqlText sql = new SqlText(String.Format("select m.MassPartsIDFlag, m.ExpansionKey1, m.ExpansionKey2, m.ExpansionKey3 from MaterialNumber as m join Customer as c on m.ShiptoParty = c.Code where c.PlantCode = '{1}' and shiptoParty like '{0}%' and m.customerItemNumber = '{2}'", strArr[0], strArr[1], strArr[2])))
{
System.Data.Common.DbDataReader readerSender = sql.ExecuteReader();
while (readerSender.Read())
{
mass.Add(readerSender["MassPartsIDFlag"].ToString());
key1.Add(readerSender["ExpansionKey1"].ToString());
key2.Add(readerSender["ExpansionKey2"].ToString());
key3.Add(readerSender["ExpansionKey3"].ToString());
}
readerSender.Close();
readerSender.Dispose();
}
MN[] l = new MN[mass.Count];
for (int i = 0; i <= mass.Count - 1; i++)
{
l[i] = new MN();
l[i].MassPartsIDFlag = mass[i].ToString();
l[i].ExpansionKey1 = key1[i].ToString();
l[i].ExpansionKey2 = key2[i].ToString();
l[i].ExpansionKey3 = key3[i].ToString();
}
return(new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(l));
}
private string getCurrentOrder()
{
clSys mu = new clSys();
string Comm1 = "select top 1 item_id campID, f2 campName, f3 personID, f4 moveOrder from camps where f5 is null"
+ " order by convert(int, f4) \n";
System.Data.Common.DbDataReader R1 = mu.ExecuteReader(Comm1);
string json = "";
string dataStr = "";
if (R1.HasRows)
{
while (R1.Read())
{
//dataStr += R1["campName"] + ", " + R1["personID"] + ", " + R1["moveOrder"] + " \n";
dataStr = "{\"move\":\"1\", \"campID\":\"" + R1["campID"] + "\",\"campName\":\"" + R1["campName"] + "\", \"moveOrder\":\"" + R1["moveOrder"] + "\" } ";
}
}
else
{
//return -1 means the cycle completed
dataStr = "{\"move\":\"-1\"}";
}
R1.Close();
return(dataStr);
}
public static DataTable ConvertDataReaderToDataTable(DbDataReader reader)
{
try
{
DataTable table = new DataTable();
int fieldCount = reader.FieldCount;
for (int fieldIndex = 0; fieldIndex < fieldCount; ++fieldIndex)
{
table.Columns.Add(reader.GetName(fieldIndex), reader.GetFieldType(fieldIndex));
}
table.BeginLoadData();
object[] rowValues = new object[fieldCount];
while (reader.Read())
{
reader.GetValues(rowValues);
table.LoadDataRow(rowValues, true);
}
reader.Close();
table.EndLoadData();
return table;
}
catch (Exception ex)
{
throw new Exception("DataReader转换为DataTable时出错!", ex);
}
}
public void getMovementOrderOrg()
{
clSys mu = new clSys();
string Comm1 = "select f2 movementTime from moveTime";
System.Data.Common.DbDataReader R1 = mu.ExecuteReader(Comm1);
string moveTime = mu.ExecuteScalar(Comm1);
string[] moveDateAr = moveTime.Split(' ');
string[] dateValue = moveDateAr[0].Split('/');
int hours = int.Parse(moveDateAr[1].Split(':')[0]);
int mins = int.Parse(moveDateAr[1].Split(':')[1]);
string dataStr = "";
DateTime moveTimeDate = new DateTime(int.Parse(dateValue[2]), int.Parse(dateValue[1]), int.Parse(dateValue[0]),
hours, mins, 0);
if (DateTime.Now > moveTimeDate)
{
dataStr = getCurrentOrder();
}
else
{
dataStr = "{\"move\":\"0\"}";
}
R1.Close();
HttpContext.Current.Response.Write(dataStr);
}
private void frm_load()
{
try
{
System.Data.Common.DbDataReader dbRS = null;
string strSql = "SELECT * FROM CODE_DTL WHERE CODE_TYPE = 'PRIVILEGE' ORDER BY CODE_NO ";
if (!clsDB.FunOpenDB())
{
throw new Exception("資料庫開啟失敗!");
}
if (clsDB.FunRsSql(strSql, ref dbRS))
{
while (dbRS.Read())
{
cboProgStytle.Items.Add(dbRS["CODE_NO"].ToString() + ":" + dbRS["CODE_NAME"].ToString());
}
dbRS.Close(); // DbDataReader Close
}
clsDB.FunClsDB();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private MFPAJ100Entity GetMFPAJ100FromIDataReader(DbDataReader dr)
{
MFPAJ100Entity dt = new MFPAJ100Entity();
if (dr.FieldCount > 0)
{
if (dr["MessageID"].ToString() != "" || dr["MessageID"] != null) dt.MessageID = Int32.Parse(dr["MessageID"].ToString());
dt.MessageType = dr["MessageType"].ToString();
dt.MessageDetail = dr["MessageDetail"].ToString();
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
if (dr["CreatorSID"].ToString() != "" || dr["CreatorSID"] != null) dt.CreatorSID = Int32.Parse(dr["CreatorSID"].ToString());
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
dr.Close();
return dt;
}
dr.Close();
return null;
}
public bool Fun_RsSQL(string sSQL, ref System.Data.Common.DbDataReader retRS, bool bDBClose = false)
{
try
{
sSQL = sSQL.Replace("''", "' '");
if (this.DBConn == null)
{
if (this.Fun_OpenDataBase() == false)
{
return(false);
}
}
else
{
if (this.DBConn.State != System.Data.ConnectionState.Open)
{
if (this.Fun_OpenDataBase() == false)
{
return(false);
}
}
}
if (DBConn.State != System.Data.ConnectionState.Open)
{
return(false);
}
DBCommand.Connection = DBConn;
DBCommand.CommandText = sSQL;
retRS = DBCommand.ExecuteReader();
if (retRS.HasRows == false)
{
retRS.Close();
if (bDBClose == true)
{
Fun_CloseDB();
}
return(false);
}
else
{
if (bDBClose == true)
{
Fun_CloseDB();
}
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public T[] List <T>(string Sql, System.Data.Common.DbTransaction transaction = null)
{
DbBase.LastSQL = Sql;
System.Data.Common.DbCommand cmd = null;
System.Data.Common.DbDataReader dataReader = null;
T[] result = null;
try
{
if (transaction == null && DbConnection.State != ConnectionState.Open)
{
DbConnection.Open();
}
cmd = DbBase.DbConnection.CreateCommand();
cmd.CommandText = Sql;
if (transaction != null)
{
cmd.Transaction = transaction;
}
dataReader = cmd.ExecuteReader();
List <string> columns = GetDataReaderColumns(dataReader);
result = List <T>(dataReader, columns);
}
finally
{
if (dataReader != null)
{
dataReader.Close();
dataReader.Dispose();
dataReader = null;
}
if (cmd != null)
{
cmd.Dispose();
cmd = null;
}
if (transaction == null)
{
DbConnection.Close();
}
}
if (result == null)
{
return(new T[] { });
}
return(result);
}
static int Close(IntPtr L)
{
try
{
ToLua.CheckArgsCount(L, 1);
System.Data.Common.DbDataReader obj = (System.Data.Common.DbDataReader)ToLua.CheckObject(L, 1, typeof(System.Data.Common.DbDataReader));
obj.Close();
return(0);
}
catch (Exception e)
{
return(LuaDLL.toluaL_exception(L, e));
}
}
public void GetProviderSpecificValues_Reader_Closed ()
{
cmd.CommandText = "SELECT * FROM employee";
rdr = cmd.ExecuteReader ();
rdr.Close ();
try {
rdr.GetProviderSpecificValues (null);
Assert.Fail ("#1");
} catch (InvalidOperationException ex) {
// Invalid attempt to call MetaData
// when reader is closed
Assert.AreEqual (typeof (InvalidOperationException), ex.GetType (), "#2");
Assert.IsNull (ex.InnerException, "#3");
Assert.IsNotNull (ex.Message, "#4");
}
}
/// <summary>
/// Readers to G object.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
public static GObject ReaderToGObject(DbDataReader reader)
{
GObject result = null;
if (!reader.HasRows)
{
}
try
{
reader.Close();
reader = null;
}
catch (Exception)
{
reader = null;
}
return result;
}
public string cbPlantCode(string strCondition)
{
System.Collections.ArrayList receiverList = new System.Collections.ArrayList();
using (SqlText sql = new SqlText(String.Format("select distinct(PlantCode) from Customer where Code like '{0}%' and PlantCode is not null", strCondition)))
{
System.Data.Common.DbDataReader readerSender = sql.ExecuteReader();
while (readerSender.Read())
{
receiverList.Add(readerSender["PlantCode"].ToString());
}
readerSender.Close();
readerSender.Dispose();
}
MN[] l = new MN[receiverList.Count];
for (int i = 0; i <= receiverList.Count - 1; i++)
{
l[i] = new MN();
l[i].strItem = receiverList[i].ToString();
}
return(new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(l));
}
public static List<object> GetColumnFromDataReader(DbDataReader dr, string columnName)
{
List<object> column = new List<object>();
try
{
while (dr.Read())
{
column.Add(dr[columnName]);
}
}
finally
{
if (dr != null && !dr.IsClosed)
{
dr.Close(); // Data Reader is done (read only, forward only)
dr.Dispose();
}
}
return column;
}
public string cbMatCode(string strCondition)
{
string[] strArr = strCondition.Split(':');
System.Collections.ArrayList receiverList = new System.Collections.ArrayList();
using (SqlText sql = new SqlText(String.Format("select m.customerItemNumber from MaterialNumber as m join Customer as c on m.ShiptoParty = c.Code where c.PlantCode = '{1}' and shiptoParty like '{0}%'", strArr[0], strArr[1])))
{
System.Data.Common.DbDataReader readerSender = sql.ExecuteReader();
while (readerSender.Read())
{
receiverList.Add(readerSender["customerItemNumber"].ToString());
}
readerSender.Close();
readerSender.Dispose();
}
MN[] l = new MN[receiverList.Count];
for (int i = 0; i <= receiverList.Count - 1; i++)
{
l[i] = new MN();
l[i].strItem = receiverList[i].ToString();
}
return(new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(l));
}
public static List<Category> GetCategorys(DbDataReader dataReader)
{
List<Category> categorys = new List<Category>();
while (dataReader.Read())
{
Category category = new Category();
category.CategoryId = Convert.ToInt32(dataReader[CategoryField.CategoryId]);
category.CategoryGuid = (Guid)dataReader[CategoryField.CategoryGuid];
category.CategoryName = Convert.ToString(dataReader[CategoryField.CategoryName]);
category.ParentGuid = (Guid)dataReader[CategoryField.ParentGuid];
category.ParentCategoryName = dataReader[CategoryField.ParentCategoryName].ToString();
category.Rank = Convert.ToInt32(dataReader[CategoryField.Rank]);
category.ArticleType = (byte)dataReader[CategoryField.ArticleType];
if (dataReader[CategoryField.ThumbnailWidth] != DBNull.Value)
category.ThumbnailWidth = (int)dataReader[CategoryField.ThumbnailWidth];
if (dataReader[CategoryField.ThumbnailHeight] != DBNull.Value)
category.ThumbnailHeight = (int)dataReader[CategoryField.ThumbnailHeight];
category.RecordCount = (int)dataReader[CategoryField.RecordCount];
categorys.Add(category);
}
dataReader.Close();
return categorys;
}
public String ViewTableTxt(String TableName)
{
ESData.GetInst.Open_Conn();
String txt = "TabeName:" + TableName + "\n";
System.Data.Common.DbDataReader dr = ESData.GetInst.Reader(String.Format("select * from {0};", TableName));
for (int i = 0; i < dr.FieldCount; i++)
{
txt += dr.GetName(i) + "\t ";
}
txt += "\n"; //if (dr.HasRows)
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
try{ txt += dr[i].ToString() + "\t "; }
catch { MessageBox.Show(dr[0].ToString()); }
}
txt += "\n";
}
dr.Close();
dr.Dispose();
return(txt);
}
protected void Register(object sender, EventArgs e)
{
if (!string.Equals(uxPasswordRepeat.Text, uxPassword.Text))
{
plus.Util.Helper.error("رمز عبور و تکرار رمز عبور یکی نیست. لطفاْ دقت نمایید.", "");
return;
}
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
System.Collections.IDictionary param = new Dictionary <string, object>();
System.Data.Common.DbDataReader reader = plus.Data.DAL.Read("Default",
"SELECT Substring(PARAMETER_NAME,2, 100) PARAMETER_NAME, DATA_TYPE, PARAMETER_MODE FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_SCHEMA = 'perm' AND SPECIFIC_NAME = 'spRegisterUser' ORDER BY ORDINAL_POSITION");
while (reader.Read())
{
string name = reader["PARAMETER_NAME"].ToString();
if (sb.Length > 1)
{
sb.Append(", ");
}
sb.Append("@" + name);
object value = plus.Data.Common.FindAndGetValue(dvAsanWazifa_prf_Profile, "ux" + name);
param.Add(name, value);
}
reader.Close();
plus.Security.Principal.UserRecord record = plus.Security.Authentication.RegisterUser(param);
if (string.IsNullOrEmpty(record.errorMessage))
{
Server.Transfer("~/Security/User/activation");
//plus.Util.Helper.success("User successfully created. Please check your email for activation link.", "");
//return;
}
}
private Workflow_NodeLinkEntity GetWorkflow_NodeLinkFromIDataReader(DbDataReader dr)
{
Workflow_NodeLinkEntity dt = new Workflow_NodeLinkEntity();
if (dr.FieldCount > 0)
{
if (dr["LinkID"].ToString() != "" || dr["LinkID"] != null) dt.LinkID = Int32.Parse(dr["LinkID"].ToString());
dt.LinkName = dr["LinkName"].ToString();
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["StartNodeID"].ToString() != "" || dr["StartNodeID"] != null) dt.StartNodeID = Int32.Parse(dr["StartNodeID"].ToString());
if (dr["TargetNodeID"].ToString() != "" || dr["TargetNodeID"] != null) dt.TargetNodeID = Int32.Parse(dr["TargetNodeID"].ToString());
if (dr["IsRejected"].ToString() != "" || dr["IsRejected"] != null) dt.IsRejected = Int32.Parse(dr["IsRejected"].ToString());
dt.Creator = dr["Creator"].ToString();
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
dt.lastModifier = dr["lastModifier"].ToString();
dt.lastModifyDate = Convert.ToDateTime(dr["lastModifyDate"]);
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_TriggerWFFieldMappingMainEntity GetWorkflow_TriggerWFFieldMappingMainFromIDataReader(DbDataReader dr)
{
Workflow_TriggerWFFieldMappingMainEntity dt = new Workflow_TriggerWFFieldMappingMainEntity();
if (dr.FieldCount > 0)
{
if (dr["MappingID"].ToString() != "" || dr["MappingID"] != null) dt.MappingID = Int32.Parse(dr["MappingID"].ToString());
if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString());
if (dr["TargetGroupID"].ToString() != "" || dr["TargetGroupID"] != null) dt.TargetGroupID = Int32.Parse(dr["TargetGroupID"].ToString());
if (dr["OPCycleType"].ToString() != "" || dr["OPCycleType"] != null) dt.MappingID = Convert.ToByte(dr["OPCycleType"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_RequestBaseEntity GetWorkflow_RequestBaseFromIDataReader(DbDataReader dr)
{
Workflow_RequestBaseEntity dt = new Workflow_RequestBaseEntity();
if (dr.FieldCount > 0)
{
if (dr["RequestID"].ToString() != "" || dr["RequestID"] != null) dt.RequestID = Int32.Parse(dr["RequestID"].ToString());
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["LastNodeID"].ToString() != "" || dr["LastNodeID"] != null) dt.LastNodeID = Int32.Parse(dr["LastNodeID"].ToString());
dt.LastRuleID = dr["LastRuleID"].ToString();
dt.LastRuleType = dr["LastRuleType"].ToString();
if (dr["LastNodeType"].ToString() != "" || dr["LastNodeType"] != null) dt.LastNodeType = Int32.Parse(dr["LastNodeType"].ToString());
if (dr["LastDeptLevel"].ToString() != "" || dr["LastDeptLevel"] != null) dt.LastDeptLevel = Int32.Parse(dr["LastDeptLevel"].ToString());
dt.LastOperatorID = dr["LastOperatorID"].ToString();
if (dr["CurrentNodeID"].ToString() != "" || dr["CurrentNodeID"] != null) dt.CurrentNodeID = Int32.Parse(dr["CurrentNodeID"].ToString());
dt.CurrentRuleID = dr["CurrentRuleID"].ToString();
dt.CurrentRuleType = dr["CurrentRuleType"].ToString();
if (dr["CurrentNodeType"].ToString() != "" || dr["CurrentNodeType"] != null) dt.CurrentNodeType = Int32.Parse(dr["CurrentNodeType"].ToString());
if (dr["CurrentDeptLevel"].ToString() != "" || dr["CurrentDeptLevel"] != null) dt.CurrentDeptLevel = Int32.Parse(dr["CurrentDeptLevel"].ToString());
dt.CurrentOperatorID = dr["CurrentOperatorID"].ToString();
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["Creator"].ToString() != "" || dr["Creator"] != null) dt.Creator = Int32.Parse(dr["Creator"].ToString());
dt.RequestStatus = dr["RequestStatus"].ToString();
dt.RequestName = dr["RequestName"].ToString();
if (dr["IsCancel"].ToString() != "" || dr["IsCancel"] != null) dt.IsCancel = Int32.Parse(dr["IsCancel"].ToString());
dt.AllParticipator = dr["AllParticipator"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_ReportTypeEntity GetWorkflow_ReportTypeFromIDataReader(DbDataReader dr)
{
Workflow_ReportTypeEntity dt = new Workflow_ReportTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["ReportTypeID"].ToString() != "" || dr["ReportTypeID"] != null) dt.ReportTypeID = Int32.Parse(dr["ReportTypeID"].ToString());
dt.ReportTypeName = dr["ReportTypeName"].ToString();
dt.ReportTypeDesc = dr["ReportTypeDesc"].ToString();
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_ReportMainEntity GetWorkflow_ReportMainFromIDataReader(DbDataReader dr)
{
Workflow_ReportMainEntity dt = new Workflow_ReportMainEntity();
if (dr.FieldCount > 0)
{
if (dr["ReportID"].ToString() != "" || dr["ReportID"] != null) dt.ReportID = Int32.Parse(dr["ReportID"].ToString());
if (dr["ReportTypeID"].ToString() != "" || dr["ReportTypeID"] != null) dt.ReportTypeID = Int32.Parse(dr["ReportTypeID"].ToString());
dt.ReportName = dr["ReportName"].ToString();
if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
dt.WorkflowID = dr["WorkflowID"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_NodeTriggerWorkflowEntity GetWorkflow_NodeTriggerWorkflowFromIDataReader(DbDataReader dr)
{
Workflow_NodeTriggerWorkflowEntity dt = new Workflow_NodeTriggerWorkflowEntity();
if (dr.FieldCount > 0)
{
if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString());
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["NodeID"].ToString() != "" || dr["NodeID"] != null) dt.NodeID = Int32.Parse(dr["NodeID"].ToString());
if (dr["OPTime"].ToString() != "" || dr["OPTime"] != null) dt.OPTime = Int32.Parse(dr["OPTime"].ToString());
dt.OPCondition = dr["OPCondition"].ToString();
if (dr["TriggerWFID"].ToString() != "" || dr["TriggerWFID"] != null) dt.TriggerWFID = Int32.Parse(dr["TriggerWFID"].ToString());
if (dr["TriggerWFCreator"].ToString() != "" || dr["TriggerWFCreator"] != null) dt.TriggerWFCreator = Int32.Parse(dr["TriggerWFCreator"].ToString());
if (dr["WFCreateNode"].ToString() != "" || dr["WFCreateNode"] != null) dt.WFCreateNode = Int32.Parse(dr["WFCreateNode"].ToString());
if (dr["WFCreateFieldID"].ToString() != "" || dr["WFCreateFieldID"] != null) dt.WFCreateFieldID = Int32.Parse(dr["WFCreateFieldID"].ToString());
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["CreateSID"].ToString() != "" || dr["CreateSID"] != null) dt.CreateSID = Int32.Parse(dr["CreateSID"].ToString());
if (dr["IsCancel"].ToString() != "" || dr["IsCancel"] != null) dt.IsCancel = Int32.Parse(dr["IsCancel"].ToString());
if (dr["CancelDate"].ToString() != "" || dr["CancelDate"] != null) dt.CancelDate = Convert.ToDateTime(dr["CancelDate"]);
if (dr["CancelSID"].ToString() != "" || dr["CancelSID"] != null) dt.CancelSID = Int32.Parse(dr["CancelSID"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_BasicValidTypeEntity GetWorkflow_BasicValidTypeFromIDataReader(DbDataReader dr)
{
Workflow_BasicValidTypeEntity dt = new Workflow_BasicValidTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["ValidTypeID"].ToString() != "" || dr["ValidTypeID"] != null) dt.ValidTypeID = Int32.Parse(dr["ValidTypeID"].ToString());
dt.ValidTypeDesc = dr["ValidTypeDesc"].ToString();
dt.ValidErrorMsg = dr["ValidErrorMsg"].ToString();
dt.ValidRule = (dr["ValidRule"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_BrowseTypeEntity GetWorkflow_BrowseTypeFromIDataReader(DbDataReader dr)
{
Workflow_BrowseTypeEntity dt = new Workflow_BrowseTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["BrowseTypeID"].ToString() != "" || dr["BrowseTypeID"] != null) dt.BrowseTypeID = Int32.Parse(dr["BrowseTypeID"].ToString());
dt.BrowseTypeName = dr["BrowseTypeName"].ToString();
dt.BrowseTypeDesc = dr["BrowseTypeDesc"].ToString();
dt.BrowsePage = dr["BrowsePage"].ToString();
dt.Useflag = dr["Useflag"].ToString();
dt.BrowseValueSql = dr["BrowseValueSql"].ToString();
dt.BrowseSqlParam = dr["BrowseSqlParam"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_DataSetEntity GetWorkflow_DataSetFromIDataReader(DbDataReader dr)
{
Workflow_DataSetEntity dt = new Workflow_DataSetEntity();
if (dr.FieldCount > 0)
{
if (dr["DataSetID"].ToString() != "" || dr["DataSetID"] != null) dt.DataSetID = Int32.Parse(dr["DataSetID"].ToString());
if (dr["DataSetType"].ToString() != "" || dr["DataSetType"] != null) dt.DataSetType = Int32.Parse(dr["DataSetType"].ToString());
dt.DataSetName = dr["DataSetName"].ToString();
if (dr["DataSourceID"].ToString() != "" || dr["DataSourceID"] != null) dt.DataSourceID = Int32.Parse(dr["DataSourceID"].ToString());
dt.TableList = dr["TableList"].ToString();
dt.FieldList = dr["FieldList"].ToString();
dt.QueryCondition = dr["QueryCondition"].ToString();
dt.OrderBy = dr["OrderBy"].ToString();
dt.QuerySql = dr["QuerySql"].ToString();
dt.ReturnColumns = dr["ReturnColumns"].ToString();
dt.ReturnColumnsName = dr["ReturnColumnsName"].ToString();
dt.DataSetPKColumns = dr["DataSetPKColumns"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
protected void FillTreeNavigation(int major, TreeNode tNode, ContextMenuStrip nodeContextMenuStrip)
{
//change the type of data base
if (tNode != null)
{
TreeNodeData dataNode = (TreeNodeData)tNode.Tag;
currentConnectionStringName = dataNode.ConnectionStringName;
}
if (!string.IsNullOrEmpty(currentConnectionStringName))
{
currentProviderName = ConfigurationManager.ConnectionStrings[currentConnectionStringName].ProviderName;
currentConnectionString = ConfigurationManager.ConnectionStrings[currentConnectionStringName].ConnectionString;
switch (currentProviderName)
{
case "System.Data.SqlClient":
{
dbConnection = sqlConnection;
dbCommand = sqlCommand;
dbConnectionDaughter = sqlConnectionDaughter;
dbCommandDaughter = sqlCommandDaughter;
break;
}
case "FirebirdSql.Data.FirebirdClient":
{
dbConnection = fbConnection;
dbCommand = fbCommand;
dbConnectionDaughter = fbConnectionDaughter;
dbCommandDaughter = fbCommandDaughter;
break;
}
default:
{
throw new Exception("Bad name of current connection string");
}
}
}
else
{
throw new Exception("Bad name of current connection string");
}
//logic
dbConnection.Open();
dbConnectionDaughter.Open();
TreeNodeData treeNodeData;
TreeNode currentNode;
int i = 0, n = 0;
dbCommand.CommandText = "Select Id, Name From TUObjects Where Major = " + major + " Order by ClassId, Name";
dbDataReader = dbCommand.ExecuteReader();
while (dbDataReader.Read())
{
treeNodeData = new TreeNodeData(dbDataReader.GetInt32(0), false, currentConnectionStringName);
currentNode = new TreeNode(dbDataReader.GetString(1));
currentNode.Tag = treeNodeData;
if(nodeContextMenuStrip != null)
currentNode.ContextMenuStrip = nodeContextMenuStrip;
if (tNode != null)
tNode.Nodes.Add(currentNode);
else
treeNavigation.Nodes.Add(currentNode);
dbCommandDaughter.CommandText = "Select Count(Id) From TUObjects Where Major = " + dbDataReader.GetInt32(0);
n = (int)dbCommandDaughter.ExecuteScalar();
if (n > 0)
{
if (tNode != null)
tNode.Nodes[i].Nodes.Add("Virtual Node");
else
treeNavigation.Nodes[i].Nodes.Add("Virtual Node");
}
i++;
}
dbDataReader.Close();
dbConnection.Close();
dbConnectionDaughter.Close();
}
private Workflow_AgentSettingEntity GetWorkflow_AgentSettingFromIDataReader(DbDataReader dr)
{
Workflow_AgentSettingEntity dt = new Workflow_AgentSettingEntity();
if (dr.FieldCount > 0)
{
if (dr["AgentID"].ToString() != "" || dr["AgentID"] != null) dt.AgentID = Int32.Parse(dr["AgentID"].ToString());
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["BeAgentPersonID"].ToString() != "" || dr["BeAgentPersonID"] != null) dt.BeAgentPersonID = Int32.Parse(dr["BeAgentPersonID"].ToString());
if (dr["AgentPersonID"].ToString() != "" || dr["AgentPersonID"] != null) dt.AgentPersonID = Int32.Parse(dr["AgentPersonID"].ToString());
if (dr["AgentStartDate"].ToString() != "" || dr["AgentStartDate"].ToString() != null) dt.AgentStartDate = Convert.ToDateTime(dr["AgentStartDate"].ToString());
if (dr["AgentEndDate"].ToString() != "" || dr["AgentEndDate"].ToString() != null) dt.AgentEndDate = Convert.ToDateTime(dr["AgentEndDate"].ToString());
if (dr["CreateDate"].ToString() != "" || dr["CreateDate"].ToString() != null) dt.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString());
if (dr["Creator"].ToString() != "" || dr["Creator"] != null) dt.Creator = Int32.Parse(dr["Creator"].ToString());
dt.IsCancel = dr["IsCancel"].ToString();
dt.AllowCycle = dr["AllowCycle"].ToString();
dt.AllowCreate = dr["AllowCreate"].ToString();
if (dr["CancelOperator"].ToString() != "" || dr["CancelOperator"] != null) dt.CancelOperator = Int32.Parse(dr["CancelOperator"].ToString());
if (dr["CancelDate"].ToString() != "" || dr["CancelDate"].ToString() != null) dt.CancelDate = Convert.ToDateTime(dr["CancelDate"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_FieldDictEntity GetWorkflow_FieldDictFromIDataReader(DbDataReader dr)
{
Workflow_FieldDictEntity dt = new Workflow_FieldDictEntity();
if (dr.FieldCount > 0)
{
if (dr["FieldID"].ToString() != "" || dr["FieldID"] != null) dt.FieldID = Int32.Parse(dr["FieldID"].ToString());
dt.FieldName = dr["FieldName"].ToString();
dt.FieldDesc = dr["FieldDesc"].ToString();
if (dr["DataTypeID"].ToString() != "" || dr["DataTypeID"] != null) dt.DataTypeID = Int32.Parse(dr["DataTypeID"].ToString());
dt.FieldDBType = dr["FieldDBType"].ToString();
if (dr["HTMLTypeID"].ToString() != "" || dr["HTMLTypeID"] != null) dt.HTMLTypeID = Int32.Parse(dr["HTMLTypeID"].ToString());
if (dr["FieldTypeID"].ToString() != "" || dr["FieldTypeID"] != null) dt.FieldTypeID = Int32.Parse(dr["FieldTypeID"].ToString());
dt.ValidateType = dr["ValidateType"].ToString();
if (dr["TextLength"].ToString() != "" || dr["TextLength"] != null) dt.TextLength = Int32.Parse(dr["TextLength"].ToString());
dt.Dateformat = dr["Dateformat"].ToString();
if (dr["TextHeight"].ToString() != "" || dr["TextHeight"] != null) dt.TextHeight = Int32.Parse(dr["TextHeight"].ToString());
dt.IsHTML = dr["IsHTML"].ToString();
if (dr["BrowseType"].ToString() != "" || dr["BrowseType"] != null) dt.BrowseType = Int32.Parse(dr["BrowseType"].ToString());
dt.IsDynamic = dr["IsDynamic"].ToString();
dt.DataSetID = Convert.ToInt32(dr["DataSetID"]);
dt.ValueColumn = dr["ValueColumn"].ToString();
dt.TextColumn = dr["TextColumn"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_DataSourceEntity GetWorkflow_DataSourceFromIDataReader(DbDataReader dr)
{
Workflow_DataSourceEntity dt = new Workflow_DataSourceEntity();
if (dr.FieldCount > 0)
{
if (dr["DataSourceID"].ToString() != "" || dr["DataSourceID"] != null) dt.DataSourceID = Int32.Parse(dr["DataSourceID"].ToString());
dt.DataSourceName = dr["DataSourceName"].ToString();
dt.DataSourceDBType = dr["DataSourceDBType"].ToString();
dt.ConnectString = dr["ConnectString"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["excel"] != null)
{
ExportExcel();
return;
}
string url = Request.QueryString["url"];
//Response.Write(url);
string html = System.IO.File.ReadAllText(Server.MapPath("~" + url));
string recordid = Request.QueryString["recordid"];
string path = Request.QueryString["altPath"] ?? Request.QueryString["path"]; // <conn>.<schema>.<object>
string type = Request.QueryString["type"] ?? "application";
string[] pathArray = path.Contains('_') ? path.Split('_') : path.Split('.');
System.Data.Common.DbDataReader reader = null;
String TypeString = Request.QueryString["Type"];
if (TypeString.Equals("timesheet"))
{
System.Collections.IDictionary param = new Dictionary <string, object>();
var UserID = Request.QueryString["userID"];
var OrgUnit = Request.QueryString["orgID"];
var start = Request.QueryString["start"];
var end = Request.QueryString["end"];
var rank = Request.QueryString["rank"];
param.Add("ID", null);
param.Add("OrganizationUnitID", null);
param.Add("StartDate", null);
param.Add("EndDate", null);
param.Add("Rank", null);
if (UserID.Length != 0)
{
param["ID"] = UserID;
}
if (OrgUnit.Length != 0)
{
param["OrganizationUnitID"] = OrgUnit;
}
if (start.Length != 0)
{
param["StartDate"] = start;
}
if (end.Length != 0)
{
param["EndDate"] = end;
}
if (rank.Length != 0)
{
param["Rank"] = rank;
}
param.Add("CreatedBy", 1);
param.Add("Offset", 0);
param.Add("Limit", 0);
int typeID = 0;
string p = Request.QueryString["Path"].Split('.')[0];
try
{
typeID = Convert.ToInt32(Request.QueryString["typeID"]);
}
catch (Exception) { }
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[p].ToString());
conn.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "att.spGetMonthlyTimeSheet";
foreach (var ent in param.Keys)
{
command.Parameters.Add(new SqlParameter(ent.ToString(), param[ent]));
}
command.CommandTimeout = 200;
reader = command.ExecuteReader();
};
//reader = plus.Data.DAL.Read("AMS", "att.spGetMonthlyTimeSheet",param);
Dictionary <int, String> maps = new Dictionary <int, string>();
maps.Add(2, "PR");
maps.Add(3, "AB");
maps.Add(4, "HD");
maps.Add(5, "ALH");
maps.Add(6, "AL");
StringBuilder sb = new StringBuilder();
sb.Append("<thead>");
sb.Append("<tr>");
sb.Append("<th>کود</th><th>نام مکمل</th><th>نام پدر</th><th>وظیفه</th><th>بست</th><th>اداره</th>");
for (int i = 0; i < reader.FieldCount; i++)
{
if (i > 6)
{
sb.Append("<th>" + reader.GetName(i).Split('_')[2] + "</th>");
}
}
sb.Append("</tr></thead>");
sb.Append("<tbody>");
while (reader.Read())
{
sb.Append("<tr>");
for (int i = 1; i < reader.FieldCount; i++)
{
if (i < 7 || (typeID == 0 || typeID == 1))
{
sb.Append("<td>" + reader[i].ToString() + "</td>");
}
else
{
string s = reader[i].ToString();
if (maps[typeID].Equals(s))
{
sb.Append("<td>" + reader[i].ToString() + "</td>");
}
else
{
sb.Append("<td> </td>");
}
}
}
sb.Append("</tr>");
}
sb.Append("<tbody>");
html = html.Replace("$body", sb.ToString());
Response.Write(html);
conn.Close();
return;
}
else if (TypeString.Equals("attreport"))
{
int typeID = 0;
try
{
typeID = Convert.ToInt32(Request.QueryString["typeID"]);
}
catch (Exception) { }
System.Collections.IDictionary param = new Dictionary <string, object>();
var UserID = Request.QueryString["userID"];
var OrgUnit = Request.QueryString["orgID"];
var start = Request.QueryString["start"];
var end = Request.QueryString["end"];
var rank = Request.QueryString["rank"];
param.Add("UserID", null);
param.Add("OrganizationUnit", null);
param.Add("StartDate", null);
param.Add("EndDate", null);
param.Add("RankID", null);
param.Add("AttID", null);
param.Add("HRCode", null);
param.Add("CreatedBy", null);
param.Add("Type", null);
if (UserID.Length != 0)
{
param["UserID"] = UserID;
}
if (OrgUnit.Length != 0)
{
param["OrganizationUnit"] = OrgUnit;
}
if (start.Length != 0)
{
param["StartDate"] = start;
}
if (end.Length != 0)
{
param["EndDate"] = end;
}
if (rank.Length != 0)
{
param["RankID"] = rank;
}
if (typeID != 0)
{
param["Type"] = typeID;
}
reader = plus.Data.DAL.Read("AMS", "att.spGenerateTimeSheet", param);
StringBuilder sb = new StringBuilder();
sb.Append("<thead>");
sb.Append("<tr>");
sb.Append("<th> کود کادری </th><th> نام مکمل </th><th> نام پدر </th><th> وظیفه </th><th> بست </th><th> ریاست </th><th> شیفت </th><th> تاریخ </th><th> وقت دخول </th><th> وقت خروج </th><th> حاضری </th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
while (reader.Read())
{
sb.Append("<tr>");
for (int i = 1; i < reader.FieldCount; i++)
{
if (!reader.GetName(i).Equals("AttType"))
{
sb.Append("<td>" + reader[i].ToString() + "</td>");
}
}
sb.Append("</tr>");
}
sb.Append("</tbody>");
html = html.Replace("$body", sb.ToString());
Response.Write(html);
return;
}
if (type.Equals("idcard"))
{
//string keyCol = Request.QueryString["PID"] ?? "ID";
System.Data.DataSet ds = plus.Data.DAL.GetDataSet("hcm", "select FullName, FatherName, HRCode, Position, IssueDate, PhotoPath from rec.vCardPrint where ID=" + recordid);
string imgPath = ds.Tables[0].Rows[0]["PhotoPath"].ToString();
string xName = ds.Tables[0].Rows[0]["FullName"].ToString();
string xNameEng = (ds.Tables[0].Rows[0]["FullName"].ToString()) + "s";
string xSO = ds.Tables[0].Rows[0]["Fathername"].ToString();
string xDuty = ds.Tables[0].Rows[0]["Position"].ToString();
string xCode = ds.Tables[0].Rows[0]["HRCode"].ToString();
string xIssueDate = ds.Tables[0].Rows[0]["IssueDate"].ToString();
//Labels
string lblName = "اسم:";
string lblSO = "ولد/بنت:";
string lblDuty = "وظیفه:";
string lblID = "شماره شناخت:";
string lblIssueDate = "تاریخ صدور:";
string lblNameEng = "Name:";
string lblSOEng = "S/O:";
string lblDutyEng = "Duty:";
string lblIDEng = "ID Number:";
string lblIssueDateEng = "IssueDate:";
//Get the Data
string Name = xName; //"نادر";
string SO = xSO; //"روشن";
string Duty = xDuty; //"انجنیر نرم افزار";
string ID = xCode; //"SC000122";
string IssueDate = xIssueDate; //"1396-12-2";
string NameEng = xNameEng; //"Nadir";
string SOEng = xSO; //"Roshan";
string DutyEng = xDuty; //"Software Engineer";
string IDEng = xCode; //"SC000122";
string IssueDateEng = xIssueDate; //"2017-12-2";
//imgPath = imgPath.Contains('\\') ? imgPath.Replace('\\', '/') : imgPath.Replace('\\','/');
string photo = Server.MapPath("~/hcm/userPhoto" + imgPath);
//Set X and Y axis for Labels and Data
PointF lblNameLoc = new PointF(535f, 130f);
PointF lblSOLoc = new PointF(535f, 190f);
PointF lblDutyLoc = new PointF(535f, 250f);
PointF lblIDLoc = new PointF(535f, 310f);
PointF lblIssueDateLoc = new PointF(535f, 365f);
PointF lblNameEngLoc = new PointF(265f, 130f);
PointF lblSOEngLoc = new PointF(265f, 190f);
PointF lblDutyEngLoc = new PointF(265f, 250f);
PointF lblIDEngLoc = new PointF(265f, 310f);
PointF lblIssueDateEngLoc = new PointF(265f, 365f);
PointF nameLoc = new PointF(360f, 130f);
PointF SOLoc = new PointF(360f, 190f);
PointF DutyLoc = new PointF(360f, 250f);
PointF IDLoc = new PointF(360f, 310f);
PointF IssueDateLoc = new PointF(360f, 365f);
PointF photoLoc = new PointF(600f, 140f);
PointF nameEngLoc = new PointF(450f, 130f);
PointF SOEngLoc = new PointF(450f, 190f);
PointF DutyEngLoc = new PointF(450f, 250f);
PointF IDEngLoc = new PointF(450f, 310f);
PointF IssueDateEngLoc = new PointF(450f, 365f);
PointF photoEngLoc = new PointF(20f, 140f);
//Dari Text Direction
StringFormat rtl = new StringFormat(StringFormatFlags.DirectionRightToLeft);
//Cards path
string imageDariFilePath = Server.MapPath("~/page/templ/idcard/dari/Administration.jpg"); //@"~/hcm/page/idcard/dari/Administration.jpg"; //template path dari
string imageEngFilePath = Server.MapPath("~/page/templ/idcard/dari/Administration.jpg"); //@"~/hcm/page/idcard/eng/Administration.jpg"; //template path eng
string imageDariOutput = Server.MapPath("~/page/templ/idcard/Generated/" + Name + ".jpg"); //@"~/hcm/page/idcard/Generated/" + Name + ".jpg"; //Path after generated dari
string imageEngOutput = Server.MapPath("~/page/templ/idcard/Generated/" + NameEng + ".jpg"); //@"~/hcm/page/idcard/Generated/" + NameEng + ".jpg"; //Path after generated eng
//Resize Image
System.Drawing.Image imgResized = ScaleImage(System.Drawing.Image.FromFile(photo), 70, 80);
//Convert Image to bitmap
Bitmap daribitmap = (Bitmap)System.Drawing.Image.FromFile(imageDariFilePath);
Bitmap engbitmap = (Bitmap)System.Drawing.Image.FromFile(imageEngFilePath);
Bitmap bitmapPhoto = (Bitmap)imgResized;
//Write the labels and data on image using graphics class
using (Graphics gdari = Graphics.FromImage(daribitmap))
using (Graphics geng = Graphics.FromImage(engbitmap))
{
using (Font arialFont = new Font("Times New Roman", 8))
{
//Dari Card-----------------------------------------------------------------
//Draw labels
gdari.DrawString(lblName, arialFont, Brushes.Black, lblNameLoc, rtl);
gdari.DrawString(lblSO, arialFont, Brushes.Black, lblSOLoc, rtl);
gdari.DrawString(lblDuty, arialFont, Brushes.Black, lblDutyLoc, rtl);
gdari.DrawString(lblID, arialFont, Brushes.Black, lblIDLoc, rtl);
gdari.DrawString(lblIssueDate, arialFont, Brushes.Black, lblIssueDateLoc, rtl);
//Draw data
//gdari.CompositingMode = CompositingMode.SourceOver;
//bitmapPhoto.MakeTransparent();
gdari.DrawImage(bitmapPhoto, photoLoc);
gdari.DrawString(Name, arialFont, Brushes.Black, nameLoc, rtl);
gdari.DrawString(SO, arialFont, Brushes.Black, SOLoc, rtl);
gdari.DrawString(Duty, arialFont, Brushes.Black, DutyLoc, rtl);
gdari.DrawString(ID, arialFont, Brushes.Black, IDLoc, rtl);
gdari.DrawString(IssueDate, arialFont, Brushes.Black, IssueDateLoc, rtl);
// English Card--------------------------------------------------------------
//Draw labels
geng.DrawString(lblNameEng, arialFont, Brushes.Black, lblNameEngLoc);
geng.DrawString(lblSOEng, arialFont, Brushes.Black, lblSOEngLoc);
geng.DrawString(lblDutyEng, arialFont, Brushes.Black, lblDutyEngLoc);
geng.DrawString(lblIDEng, arialFont, Brushes.Black, lblIDEngLoc);
geng.DrawString(lblIssueDateEng, arialFont, Brushes.Black, lblIssueDateEngLoc);
//Draw data
//geng.CompositingMode = CompositingMode.SourceOver;
//bitmapPhoto.MakeTransparent();
geng.DrawImage(bitmapPhoto, photoEngLoc);
geng.DrawString(NameEng, arialFont, Brushes.Black, nameEngLoc);
geng.DrawString(SOEng, arialFont, Brushes.Black, SOEngLoc);
geng.DrawString(DutyEng, arialFont, Brushes.Black, DutyEngLoc);
geng.DrawString(IDEng, arialFont, Brushes.Black, IDEngLoc);
geng.DrawString(IssueDateEng, arialFont, Brushes.Black, IssueDateEngLoc);
}
}
// Save the generated card
using (MemoryStream memorydari = new MemoryStream())
using (MemoryStream memoryeng = new MemoryStream())
{
using (FileStream fsdari = new FileStream(imageDariOutput, FileMode.Create, FileAccess.ReadWrite))
using (FileStream fseng = new FileStream(imageEngOutput, FileMode.Create, FileAccess.ReadWrite))
{
daribitmap.Save(memorydari, ImageFormat.Jpeg);
engbitmap.Save(memoryeng, ImageFormat.Jpeg);
byte[] bytesdari = memorydari.ToArray();
byte[] byteseng = memoryeng.ToArray();
fsdari.Write(bytesdari, 0, bytesdari.Length);
fseng.Write(byteseng, 0, byteseng.Length);
}
}
//html = html.Replace("{imgPath}", Convert.ToString(imageDariOutput));
}
else
{
if (type.Equals("DailyUserReport"))
{
string reportdate = Request.QueryString["reportdate"];
string reporttype = Request.QueryString["reporttype"];
string shamsidate = Request.QueryString["shamsidate"];
string issent = Request.QueryString["issent"];
string rolename = Request.QueryString["rolename"];
reader = plus.Data.DAL.Read(pathArray[0],
string.Format("SELECT * FROM {0}.{1} WHERE RoleID=@RoleID AND ReportDate = @ReportDate and ReportType=@ReportType and Issent=@Issent order by Total DESC", pathArray[1], pathArray[2])
, "RoleID", recordid, "ReportDate", reportdate, "ReportType", reporttype, "Issent", issent);
String tbody = " <page size='A4' class='Print'>";
tbody += "<table class='table' style='width:90%;'>";
String thead = "";
thead += "<thead>";
thead += "<tr>";
thead += "<th colspan='10' style='border:none; font-size:16px;'>گزارش روزانه کارمندان بخش $RoleName بابت تاریخ $rptdate </th>";
thead += "</tr>";
thead += "<tr>";
thead += "<th> شماره</th>";
thead += "<th> اسم کارمند</th>";
thead += "<th> دیپارتمنت</th>";
thead += "<th> تاریخ</th>";
thead += "<th> نوع گزارش</th>";
thead += "<th>حالت اسناد</th>";
thead += "<th>تعداد</th>";
thead += "</tr>";
thead += "</thead>";
thead = thead.Replace("$RoleName", rolename);
thead = thead.Replace("$rptdate", shamsidate);
tbody += thead;
tbody += "<tbody>";
int counter = 1;
while (reader.Read())
{
string trow = "<tr>";
trow += "<td>$NO</td>";
trow += "<td>$FullName</td>";
trow += "<td>$RoleName</td>";
trow += "<td>$ReportDate_Shamsi</td>";
trow += "<td>$RptTypeName</td>";
trow += "<td>$SENTName</td>";
trow += "<td>$Total</td>";
trow += "</tr>";
trow = trow.Replace("$NO", counter.ToString());
for (int i = 0; i < reader.FieldCount; i++)
{
string colName = reader.GetName(i);
trow = trow.Replace("$" + colName, Convert.ToString(reader[colName]));
}
tbody += trow;
counter++;
}
tbody += "</tbody></table> <br/>";
tbody += "<div style='margin-right:20px; margin-left:20px;'>";
System.Data.Common.DbDataReader summaryReader = plus.Data.DAL.Read(pathArray[0],
string.Format("exec [rpt].[spGetGrandTotalDailyUsersReport] {0}, '{1}', {2}, {3}", recordid, reportdate, reporttype, issent));
String sthead = "";
String summary = "<table class='table' style='width:90%;'>";
String stbody = "<tbody>";
sthead += "<thead>";
sthead += "<tr>";
sthead += "<th colspan='10' style='border:none; font-size:16px;'>مجموع عمومی:</th>";
sthead += "</tr>";
sthead += "</thead>";
summary += sthead;
while (summaryReader.Read())
{
stbody += "<tr>";
stbody += "<th>@GrandTotal</th>";
stbody += "</tr>";
for (int i = 0; i < summaryReader.FieldCount; i++)
{
string colName = summaryReader.GetName(i);
stbody = stbody.Replace("@" + colName, Convert.ToString(summaryReader[colName]));
}
}
summary += stbody;
summary += "</table>";
tbody += summary;
tbody += "</div>";
tbody += "</page>";
html = html.Replace("$body", tbody);
}
else if (!type.Equals("closedlist"))
{
string keyCol = Request.QueryString["keyCol"] ?? "ID";
reader = plus.Data.DAL.Read(pathArray[0],
string.Format("SELECT * FROM {0}.{1} WHERE {2} = @RecordID", pathArray[1], pathArray[2], keyCol)
, "RecordID", recordid);
if (type.Equals("application"))
{
while (reader.Read())
{
// loop through columns
for (int i = 0; i < reader.FieldCount; i++)
{
string colName = reader.GetName(i); // firstName
if (!colName.Equals("BirthDate"))
{
html = html.Replace("{" + colName + "}", Convert.ToString(reader[colName]));
}
else
{
html = html.Replace("{" + colName + "}", Convert.ToDateTime(reader[colName]).ToString("dd MMM yyyy"));
}
}
}
}
else if (type.Equals("progresslist"))
{
string subpath = "preport_rpt_vUserReport";
string[] subPathArray = subpath.Split('_');
string subKeyCol = "ID";
System.Data.Common.DbDataReader subReader = plus.Data.DAL.Read(subPathArray[0],
string.Format("SELECT * FROM {0}.{1} WHERE {2} = @RecordID", subPathArray[1], subPathArray[2], subKeyCol)
, "RecordID", recordid);
String tbody = " <page size='A4' class='Print'>";
tbody += "<table class='table' style='font-size:10px !important;'>";
String thead = "";
thead += "<thead>";
thead += "<tr>";
thead += "<th colspan='10' style='border:none; font-size:14px;'>گزارش نمبر $CODE از فعالیت و کارکرد مورخ $SHAMSI محترم $Employee کارمند بخش $RoleName</th>";
thead += "</tr>";
thead += "<tr>";
thead += "<th> شماره</th>";
thead += "<th> کود متقاضی</th>";
thead += "<th> نام متقاضی</th>";
thead += "<th>نام پدر</th>";
thead += "<th>نام پدرکلان</th>";
thead += "<th>محل تولد</th>";
thead += "<th> تاریخ تولد</th>";
thead += "<th> تاریخ اجرأت کارمند</th>";
thead += "<th> زمان اجرأت کارمند</th>";
thead += "<th> مرحله ارسالی</th>";
thead += "</tr>";
thead += "</thead>";
while (subReader.Read())
{
for (int i = 0; i < subReader.FieldCount; i++)
{
string subColName = subReader.GetName(i);
thead = thead.Replace("$" + subColName, Convert.ToString(subReader[subColName]));
}
}
tbody += thead;
tbody += "<tbody>";
int counter = 1;
while (reader.Read())
{
string trow = "<tr>";
trow += "<td>$NO</td>";
trow += "<td>$Code</td>";
trow += "<td>$FullName</td>";
trow += "<td>$FatherNameLocal</td>";
trow += "<td>$GrandFatherNameLocal</td>";
trow += "<td>$BirthLocation</td>";
trow += "<td>$BirthDate</td>";
trow += "<td>$ProcessedDate</td>";
trow += "<td>$ProcessedTime</td>";
trow += "<td>$ProcessName</td>";
trow += "</tr>";
trow = trow.Replace("$NO", counter.ToString());
for (int i = 0; i < reader.FieldCount; i++)
{
string colName = reader.GetName(i);
trow = trow.Replace("$" + colName, Convert.ToString(reader[colName]));
}
tbody += trow;
counter++;
}
tbody += "</tbody></table> <br/>";
tbody += "<div style='margin-right:10px; margin-left:10px;'>";
String sthead = "";
String summary = "<table class='table' style='font-size:16px; width:90%;'>";
String stbody = "<tbody>";
sthead += "<tr>";
sthead += "<th>امضأ و نام مکمل کارمند</th>";
sthead += "<th>امضأ و نام مکمل آمر بخش</th>";
sthead += "<th>امضأ و نام مکمل تسلیم شونده</th>";
sthead += "</tr>";
sthead += "</thead>";
summary += sthead;
stbody += "<tr style='height:100px;'>";
stbody += "<th></th>";
stbody += "<th></th>";
stbody += "<th></th>";
stbody += "</tr>";
summary += stbody;
summary += "</table>";
tbody += summary;
tbody += "</div>";
tbody += "</page>";
html = html.Replace("$body", tbody);
}
else if (type.Equals("postprogresslist"))
{
string subpath = "preport_rpt_vUserReport";
string[] subPathArray = subpath.Split('_');
string subKeyCol = "ID";
System.Data.Common.DbDataReader subReader = plus.Data.DAL.Read(subPathArray[0],
string.Format("SELECT * FROM {0}.{1} WHERE {2} = @RecordID", subPathArray[1], subPathArray[2], subKeyCol)
, "RecordID", recordid);
String tbody = " <page size='A4' class='Print'>";
tbody += "<table class='table' style='font-size:10px !important;'>";
String thead = "";
thead += "<thead>";
thead += "<tr>";
thead += "<th colspan='10' style='border:none; font-size:14px;'>گزارش نمبر $CODE از فعالیت و کارکرد مورخ $SHAMSI محترم $Employee کارمند بخش $RoleName</th>";
thead += "</tr>";
thead += "<tr>";
thead += "<th> شماره</th>";
thead += "<th> نمبر پاسپورت</th>";
thead += "<th> نام متقاضی</th>";
thead += "<th>نام پدر</th>";
thead += "<th>نام پدرکلان</th>";
thead += "<th>محل تولد</th>";
thead += "</tr>";
thead += "</thead>";
while (subReader.Read())
{
for (int i = 0; i < subReader.FieldCount; i++)
{
string subColName = subReader.GetName(i);
thead = thead.Replace("$" + subColName, Convert.ToString(subReader[subColName]));
}
}
tbody += thead;
tbody += "<tbody>";
int counter = 1;
while (reader.Read())
{
string trow = "<tr>";
trow += "<td>$NO</td>";
trow += "<td>$PassportNumber</td>";
trow += "<td>$FullName</td>";
trow += "<td>$FatherNameLocal</td>";
trow += "<td>$GrandFatherNameLocal</td>";
trow += "<td>$BirthLocation</td>";
trow += "</tr>";
trow = trow.Replace("$NO", counter.ToString());
for (int i = 0; i < reader.FieldCount; i++)
{
string colName = reader.GetName(i);
trow = trow.Replace("$" + colName, Convert.ToString(reader[colName]));
}
tbody += trow;
counter++;
}
tbody += "</tbody></table> <br/>";
tbody += "<div style='margin-right:10px; margin-left:10px;'>";
String sthead = "";
String summary = "<table class='table' style='font-size:16px; width:90%;'>";
String stbody = "<tbody>";
sthead += "<tr>";
sthead += "<th>امضأ و نام مکمل کارمند</th>";
sthead += "<th>امضأ و نام مکمل آمر بخش</th>";
sthead += "<th>امضأ و نام مکمل تسلیم شونده</th>";
sthead += "</tr>";
sthead += "</thead>";
summary += sthead;
stbody += "<tr style='height:100px;'>";
stbody += "<th></th>";
stbody += "<th></th>";
stbody += "<th></th>";
stbody += "</tr>";
summary += stbody;
summary += "</table>";
tbody += summary;
tbody += "</div>";
tbody += "</page>";
html = html.Replace("$body", tbody);
}
else if (type.Equals("printedlist"))
{
string subpath = "RegistryServices_stc_vStockOut";
string[] subPathArray = subpath.Split('_');
string subKeyCol = "ID";
System.Data.Common.DbDataReader subReader = plus.Data.DAL.Read(subPathArray[0],
string.Format("SELECT * FROM {0}.{1} WHERE {2} = @RecordID", subPathArray[1], subPathArray[2], subKeyCol)
, "RecordID", recordid);
String tbody = " <page size='A4' class='Print'>";
tbody += "<table class='table'>";
String thead = "";
thead += "<thead>";
thead += "<tr>";
thead += "<th colspan='10' style='border:none; font-size:16px;'> گزارش پاسپورت های چاپ شده از نمبر ($StartSerial) الی نمبر ($EndSerial) <br/> که به تاریخ $Date در جمع $FullName ثبت گردیده</th>";
thead += "</tr>";
thead += "<tr>";
thead += "<th> شماره</th>";
thead += "<th> نمبر پاسپورت</th>";
thead += "<th> نام متقاضی</th>";
thead += "<th> پاسپورت</th>";
thead += "<th>درخواست</th>";
thead += "<th> جریمه</th>";
thead += "<th> مدت</th>";
thead += "<th> پرداخت</th>";
thead += "<th>قیمت</th>";
thead += "<th> تاریخ صدور</th>";
thead += "<th> حالت</th>";
thead += "</tr>";
thead += "</thead>";
while (subReader.Read())
{
for (int i = 0; i < subReader.FieldCount; i++)
{
string subColName = subReader.GetName(i);
thead = thead.Replace("$" + subColName, Convert.ToString(subReader[subColName]));
}
}
tbody += thead;
tbody += "<tbody>";
int counter = 1;
while (reader.Read())
{
string trow = "<tr>";
trow += "<td>$NO</td>";
trow += "<td>$PassportNumber</td>";
trow += "<td>$FullName</td>";
trow += "<td>$PassportType</td>";
trow += "<td>$ApplicationType</td>";
trow += "<td>$FineName</td>";
trow += "<td>$DurationName</td>";
trow += "<td>$PaymentType</td>";
trow += "<td>$PaymentPrice</td>";
trow += "<td>$IssueDate_Shamsi</td>";
trow += "<td>$StatusName</td>";
trow += "</tr>";
trow = trow.Replace("$NO", counter.ToString());
for (int i = 0; i < reader.FieldCount; i++)
{
string colName = reader.GetName(i);
trow = trow.Replace("$" + colName, Convert.ToString(reader[colName]));
}
tbody += trow;
counter++;
}
tbody += "</tbody></table> <br/>";
tbody += "<div style='margin-right:20px; margin-left:20px;'>";
System.Data.Common.DbDataReader summaryReader = plus.Data.DAL.Read(subPathArray[0],
string.Format("exec [rpt].[spGetPassportCountReportByStockOutId] {0}, {1}, {2}", 1, recordid, "Status")
, "RecordID", recordid);
String sthead = "";
String summary = "<table class='table' style='width:90%;'>";
String stbody = "<tbody>";
sthead += "<thead>";
sthead += "<tr>";
sthead += "<th colspan='10' style='border:none; font-size:16px;'>خلص گزارش پاسپورت های چاپ شده نظر به مقدار پرداخت</th>";
sthead += "</tr>";
sthead += "<tr>";
sthead += "<th>نوعیت پرداخت</th>";
sthead += "<th> مقدار پرداخت</th>";
sthead += "<th> باطل شده</th>";
sthead += "<th>تائید شده</th>";
sthead += "<th>مجموع چاپ شده</th>";
sthead += "</tr>";
sthead += "</thead>";
summary += sthead;
while (summaryReader.Read())
{
stbody += "<tr>";
stbody += "<th>@PaymentType</th>";
stbody += "<th>@PaymentPrice</th>";
stbody += "<th>@SPOILED</th>";
stbody += "<th>@PRINTED</th>";
stbody += "<th>@TOTAL</th>";
stbody += "</tr>";
for (int i = 0; i < summaryReader.FieldCount; i++)
{
string colName = summaryReader.GetName(i);
stbody = stbody.Replace("@" + colName, Convert.ToString(summaryReader[colName]));
}
}
summary += stbody;
summary += "</table>";
tbody += summary;
tbody += "</div>";
tbody += "</page>";
html = html.Replace("$body", tbody);
}
}
else if (type.Equals("closedlist"))
{
string start = Request.QueryString["start"];
string end = Request.QueryString["end"];
string starts = Request.QueryString["starts"];
string ends = Request.QueryString["ends"];
string postofficename = Request.QueryString["postofficename"];
reader = plus.Data.DAL.Read(pathArray[0],
string.Format("SELECT * FROM {0}.{1} WHERE ClosedDate BETWEEN '{2}' AND '{3}' AND PostOfficeID = @PostOffice", pathArray[1], pathArray[2], start, end)
, "PostOffice", recordid);
String tbody = " <page size='A4' class='Print'>";
tbody += "<table class='table'>";
String thead = "";
thead += "<thead>";
thead += "<tr>";
thead += "<th colspan='10' style='border:none; font-size:16px;'>گزارش درخواست های مربوط پسته خانه $PostOffice که از تاریخ $starts الی تاریخ $ends تکمیل و نهائی گردیده اند</th>";
thead += "</tr>";
thead += "<tr>";
thead += "<th> شماره</th>";
thead += "<th> نمبر پاسپورت</th>";
thead += "<th> نام متقاضی</th>";
thead += "<th> نام پدر</th>";
thead += "<th> نام پدر کلان</th>";
thead += "<th>محل تولد</th>";
thead += "<th>پوسته خانه</th>";
thead += "<th>نمبر تلفون</th>";
thead += "<th>ملاحضات</th>";
thead += "</tr>";
thead += "</thead>";
thead = thead.Replace("$PostOffice", postofficename);
thead = thead.Replace("$starts", starts);
thead = thead.Replace("$ends", ends);
tbody += thead;
tbody += "<tbody>";
int counter = 1;
while (reader.Read())
{
string trow = "<tr>";
trow += "<td>$NO</td>";
trow += "<td>$PassportNumber</td>";
trow += "<td>$FullName</td>";
trow += "<td>$FatherNameLocal</td>";
trow += "<td>$GrandFatherNameLocal</td>";
trow += "<td>$LocationName</td>";
trow += "<td>$PostOffice</td>";
trow += "<td>$Mobile</td>";
trow += "<td style='width:150px;'></td>";
trow += "</tr>";
trow = trow.Replace("$NO", counter.ToString());
for (int i = 0; i < reader.FieldCount; i++)
{
string colName = reader.GetName(i);
trow = trow.Replace("$" + colName, Convert.ToString(reader[colName]));
}
tbody += trow;
counter++;
}
tbody += "</tbody>";
tbody += "</page>";
html = html.Replace("$body", tbody);
}
reader.Close();
Response.Write(html);
}
}
private Workflow_NodeOperatorDetailEntity GetWorkflow_NodeOperatorDetailFromIDataReader(DbDataReader dr)
{
Workflow_NodeOperatorDetailEntity dt = new Workflow_NodeOperatorDetailEntity();
if (dr.FieldCount > 0)
{
if (dr["RuleID"].ToString() != "" || dr["RuleID"] != null) dt.RuleID = Int32.Parse(dr["RuleID"].ToString());
if (dr["NodeID"].ToString() != "" || dr["NodeID"] != null) dt.NodeID = Int32.Parse(dr["NodeID"].ToString());
if (dr["RuleType"].ToString() != "" || dr["RuleType"] != null) dt.RuleType = Int32.Parse(dr["RuleType"].ToString());
dt.RuleCondition = dr["RuleCondition"].ToString();
dt.ObjectValue = dr["ObjectValue"].ToString();
dt.RuleName = dr["RuleName"].ToString();
if (dr["RuleSeq"].ToString() != "" || dr["RuleSeq"] != null) dt.RuleSeq = Int32.Parse(dr["RuleSeq"].ToString());
if (dr["SecurityStart"].ToString() != "" || dr["SecurityStart"] != null) dt.SecurityStart = Int32.Parse(dr["SecurityStart"].ToString());
if (dr["SecurityEnd"].ToString() != "" || dr["SecurityEnd"] != null) dt.SecurityEnd = Int32.Parse(dr["SecurityEnd"].ToString());
if (dr["LevelStart"].ToString() != "" || dr["LevelStart"] != null) dt.LevelStart = Int32.Parse(dr["LevelStart"].ToString());
if (dr["LevelEnd"].ToString() != "" || dr["LevelEnd"] != null) dt.LevelEnd = Int32.Parse(dr["LevelEnd"].ToString());
if (dr["SignType"].ToString() != "" || dr["SignType"] != null) dt.SignType = Int32.Parse(dr["SignType"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
/// <summary>
/// ��ȡ���ݼ��ϡ�
/// </summary>
/// <param name="dataReader"></param>
/// <returns></returns>
public static List<Article> GetArticles(DbDataReader dataReader)
{
// ������
List<Article> articles = new List<Article>();
while (dataReader.Read())
{
Article article = new Article();
article.ArticleId = Convert.ToInt32(dataReader["ArticleId"]);
article.ArticleGuid = (Guid)dataReader["ArticleGuid"];
// ��ȡ Category ����
article.Category.CategoryId = Convert.ToInt32(dataReader["CategoryId"]);
article.Category.CategoryGuid = (Guid)dataReader["CategoryGuid"];
article.Category.CategoryName = Convert.ToString(dataReader["CategoryName"]);
article.Category.ParentGuid = (Guid)dataReader["ParentGuid"];
article.Category.Rank = Convert.ToInt32(dataReader["Rank"]);
article.Category.RecordCount = (int)dataReader[CategoryField.RecordCount];
if (dataReader["MetaKeywords"] != DBNull.Value)
article.MetaKeywords = Convert.ToString(dataReader["MetaKeywords"]);
if (dataReader["MetaDesc"] != DBNull.Value)
article.MetaDesc = Convert.ToString(dataReader["MetaDesc"]);
article.Title = Convert.ToString(dataReader["Title"]);
if (dataReader["TitleColor"] != DBNull.Value)
article.TitleColor = Convert.ToString(dataReader["TitleColor"]);
if (dataReader["SubTitle"] != DBNull.Value)
article.SubTitle = Convert.ToString(dataReader["SubTitle"]);
if (dataReader["Summary"] != DBNull.Value)
article.Summary = Convert.ToString(dataReader["Summary"]);
if (dataReader["ContentHtml"] != DBNull.Value)
article.ContentHtml = Convert.ToString(dataReader["ContentHtml"]);
if (dataReader["Editor"] != DBNull.Value)
article.Editor = (Guid)dataReader["Editor"];
if (dataReader["Author"] != DBNull.Value)
article.Author = Convert.ToString(dataReader["Author"]);
if (dataReader["Original"] != DBNull.Value)
article.Original = Convert.ToString(dataReader["Original"]);
article.Rank = Convert.ToInt32(dataReader["Rank"]);
article.Hits = Convert.ToInt32(dataReader["Hits"]);
article.Comments = Convert.ToInt32(dataReader["Comments"]);
article.Votes = Convert.ToInt32(dataReader["Votes"]);
article.DateCreated = Convert.ToDateTime(dataReader["DateCreated"]);
articles.Add(article);
}
dataReader.Close();
return articles;
}
private Workflow_NodeTriggerConditionEntity GetWorkflow_NodeTriggerConditionFromIDataReader(DbDataReader dr)
{
Workflow_NodeTriggerConditionEntity dt = new Workflow_NodeTriggerConditionEntity();
if (dr.FieldCount > 0)
{
if (dr["ConditionID"].ToString() != "" || dr["ConditionID"] != null) dt.ConditionID = Int32.Parse(dr["ConditionID"].ToString());
dt.BatchSeq = Convert.ToByte(dr["BatchSeq"]);
dt.BranchBatchSeq = Convert.ToByte(dr["BranchBatchSeq"]);
if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString());
if (dr["FieldID"].ToString() != "" || dr["FieldID"] != null) dt.FieldID = Int32.Parse(dr["FieldID"].ToString());
dt.SymbolCode = dr["SymbolCode"].ToString();
dt.CompareToValue = dr["CompareToValue"].ToString();
dt.AndOr = dr["AndOr"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_FlowNodeEntity GetWorkflow_FlowNodeFromIDataReader(DbDataReader dr)
{
Workflow_FlowNodeEntity dt = new Workflow_FlowNodeEntity();
if (dr.FieldCount > 0)
{
if (dr["NodeID"].ToString() != "" || dr["NodeID"] != null) dt.NodeID = Int32.Parse(dr["NodeID"].ToString());
dt.NodeName = dr["NodeName"].ToString();
dt.NodeDesc = dr["NodeDesc"].ToString();
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["NodeTypeID"].ToString() != "" || dr["NodeTypeID"] != null) dt.NodeTypeID = Int32.Parse(dr["NodeTypeID"].ToString());
if (dr["IsOverTime"].ToString() != "" || dr["IsOverTime"] != null) dt.IsOverTime = Int32.Parse(dr["IsOverTime"].ToString());
dt.OverTimeLen = dr["OverTimeLen"].ToString();
if (dr["SignType"].ToString() != "" || dr["SignType"] != null) dt.SignType = Int32.Parse(dr["SignType"].ToString());
dt.WithdrawTypeID = dr["WithdrawTypeID"].ToString();
if (dr["ArchiveFlag"].ToString() != "" || dr["ArchiveFlag"] != null) dt.ArchiveFlag = Int32.Parse(dr["ArchiveFlag"].ToString());
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_BaseEntity GetWorkflow_BaseFromIDataReader(DbDataReader dr)
{
Workflow_BaseEntity dt = new Workflow_BaseEntity();
if (dr.FieldCount > 0)
{
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
dt.WorkflowName = dr["WorkflowName"].ToString();
dt.WorkflowDesc = dr["WorkflowDesc"].ToString();
if (dr["FlowTypeID"].ToString() != "" || dr["FlowTypeID"] != null) dt.FlowTypeID = Int32.Parse(dr["FlowTypeID"].ToString());
if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
if (dr["IsValid"].ToString() != "" || dr["IsValid"] != null) dt.IsValid = Int32.Parse(dr["IsValid"].ToString());
if (dr["IsMailNotice"].ToString() != "" || dr["IsMailNotice"] != null) dt.IsMailNotice = Int32.Parse(dr["IsMailNotice"].ToString());
if (dr["IsMsgNotice"].ToString() != "" || dr["IsMsgNotice"] != null) dt.IsMsgNotice = Int32.Parse(dr["IsMsgNotice"].ToString());
if (dr["IsTransfer"].ToString() != "" || dr["IsTransfer"] != null) dt.IsTransfer = Int32.Parse(dr["IsTransfer"].ToString());
if (dr["AttachDocPath"].ToString() != "" || dr["AttachDocPath"] != null) dt.AttachDocPath = Int32.Parse(dr["AttachDocPath"].ToString());
if (dr["HelpDocPath"].ToString() != "" || dr["HelpDocPath"] != null) dt.HelpDocPath = Int32.Parse(dr["HelpDocPath"].ToString());
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
private PSACNEntity GetPSACNFromIDataReader(DbDataReader dr)
{
PSACNEntity dt = new PSACNEntity();
if (dr.FieldCount > 0)
{
dt.PSACNCO = dr["PSACNCO"].ToString();
dt.PSACNNCN = dr["PSACNNCN"].ToString();
dt.PSACNNEN = dr["PSACNNEN"].ToString();
dt.PSACNNTW = dr["PSACNNTW"].ToString();
dt.PSACNPRE = dr["PSACNPRE"].ToString();
dt.PSACNDAT = dr["PSACNDAT"].ToString();
if (dr["PSACNLEN"].ToString() != "" || dr["PSACNLEN"] != null) dt.PSACNLEN = Int32.Parse(dr["PSACNLEN"].ToString());
if (dr["PSACNCUR"].ToString() != "" || dr["PSACNCUR"] != null) dt.PSACNCUR = Int32.Parse(dr["PSACNCUR"].ToString());
dt.PSACNPDA = dr["PSACNPDA"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
private Workflow_FormFieldGroupEntity GetWorkflow_FormFieldGroupFromIDataReader(DbDataReader dr)
{
Workflow_FormFieldGroupEntity dt = new Workflow_FormFieldGroupEntity();
if (dr.FieldCount > 0)
{
if (dr["GroupID"].ToString() != "" || dr["GroupID"] != null) dt.GroupID = Int32.Parse(dr["GroupID"].ToString());
dt.GroupName = dr["GroupName"].ToString();
dt.GroupDesc = dr["GroupDesc"].ToString();
if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
internal static List<OfferDetails> GetOfferDetailObject(DbDataReader reader)
{
OfferDetails hooOffer = null;
List<OfferDetails> allOffers = new List<OfferDetails>();
while (reader.Read())
{
hooOffer = new OfferDetails();
hooOffer.OfferId = reader.IsDBNull(reader.GetOrdinal("OfferId")) ? 0 : Convert.ToInt32(reader["OfferId"], CultureInfo.InvariantCulture);
hooOffer.OfferTitle = reader.IsDBNull(reader.GetOrdinal("OfferTitle")) ? string.Empty : Convert.ToString(reader["OfferTitle"], CultureInfo.InvariantCulture);
hooOffer.OfferDescription = reader.IsDBNull(reader.GetOrdinal("OfferDescription")) ? string.Empty : Convert.ToString(reader["OfferDescription"], CultureInfo.InvariantCulture);
hooOffer.ImageUrl = reader.IsDBNull(reader.GetOrdinal("OfferImageUrl")) ? string.Empty : Convert.ToString(reader["OfferImageUrl"], CultureInfo.InvariantCulture);
hooOffer.StartDate = reader.IsDBNull(reader.GetOrdinal("StartDate")) ? DateTime.Now : Convert.ToDateTime(reader["StartDate"], CultureInfo.InvariantCulture);
hooOffer.ExpireDate = reader.IsDBNull(reader.GetOrdinal("ExpireDate")) ? DateTime.Now : Convert.ToDateTime(reader["ExpireDate"], CultureInfo.InvariantCulture);
hooOffer.comments = reader.IsDBNull(reader.GetOrdinal("Comments")) ? string.Empty : Convert.ToString(reader["Comments"], CultureInfo.InvariantCulture);
hooOffer.Latitude = reader.IsDBNull(reader.GetOrdinal("Latitude")) ? 0 : Convert.ToDouble(reader["Latitude"], CultureInfo.InvariantCulture);
hooOffer.Longitude = reader.IsDBNull(reader.GetOrdinal("Longitude")) ? 0 : Convert.ToDouble(reader["Longitude"], CultureInfo.InvariantCulture);
hooOffer.City = reader.IsDBNull(reader.GetOrdinal("City")) ? string.Empty : Convert.ToString(reader["City"], CultureInfo.InvariantCulture);
hooOffer.OfferCategory = reader.IsDBNull(reader.GetOrdinal("OfferCategory")) ? string.Empty : Convert.ToString(reader["OfferCategory"], CultureInfo.InvariantCulture);
hooOffer.PromoCode = reader.IsDBNull(reader.GetOrdinal("PromoCode")) ? string.Empty : Convert.ToString(reader["PromoCode"], CultureInfo.InvariantCulture);
hooOffer.Ratings = reader.IsDBNull(reader.GetOrdinal("SumOfRating")) ? 0 : Convert.ToInt32(reader["SumOfRating"], CultureInfo.InvariantCulture);
hooOffer.Vendor = new Supplier();
hooOffer.Vendor.SupplierId = reader.IsDBNull(reader.GetOrdinal("SupplierId")) ? 0 : Convert.ToInt32(reader["SupplierId"], CultureInfo.InvariantCulture);
hooOffer.Vendor.SupplierName = reader.IsDBNull(reader.GetOrdinal("SupName")) ? string.Empty : Convert.ToString(reader["SupName"], CultureInfo.InvariantCulture);
hooOffer.Vendor.ContactNumber = reader.IsDBNull(reader.GetOrdinal("SupContactNumber")) ? string.Empty : Convert.ToString(reader["SupContactNumber"], CultureInfo.InvariantCulture);
hooOffer.Vendor.Email = reader.IsDBNull(reader.GetOrdinal("SupEmailId")) ? string.Empty : Convert.ToString(reader["SupEmailId"], CultureInfo.InvariantCulture);
hooOffer.Vendor.ImageUrl = ConfigurationManager.AppSettings["ImageFolder"].ToString();
hooOffer.Vendor.ImageUrl += reader.IsDBNull(reader.GetOrdinal("SupImageURL")) ? string.Empty : Convert.ToString(reader["SupImageURL"], CultureInfo.InvariantCulture);
hooOffer.Vendor.SupplierAddress = reader.IsDBNull(reader.GetOrdinal("SupAddress")) ? string.Empty : Convert.ToString(reader["SupAddress"], CultureInfo.InvariantCulture);
allOffers.Add(hooOffer);
}
reader.Close();
return allOffers;
}
private Workflow_FormTypeEntity GetWorkflow_FormTypeFromIDataReader(DbDataReader dr)
{
Workflow_FormTypeEntity dt = new Workflow_FormTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["FormTypeID"].ToString() != "" || dr["FormTypeID"] != null) dt.FormTypeID = Int32.Parse(dr["FormTypeID"].ToString());
dt.FormTypeName = dr["FormTypeName"].ToString();
dt.FormTypeDesc = dr["FormTypeDesc"].ToString();
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dt.Useflag = dr["Useflag"].ToString();
dt.Creator = dr["Creator"].ToString();
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
dt.lastModifier = dr["lastModifier"].ToString();
dt.lastModifyDate = Convert.ToDateTime(dr["lastModifyDate"]);
dr.Close();
return dt;
}
dr.Close();
return null;
}
/// <summary>
/// Closes the current connection and disposes of the reader passed in
/// </summary>
/// <param name="reader">The reader object to dispose of (if there is one, else pass 'null')</param>
public void CleanUp(DbDataReader reader)
{
if (_connection != null && _connection.State == ConnectionState.Open && _transaction == null)
_connection.Close();
if (reader != null)
{
if (!reader.IsClosed)
reader.Close();
reader.Dispose();
}
}
private Workflow_HTMLTypeEntity GetWorkflow_HTMLTypeFromIDataReader(DbDataReader dr)
{
Workflow_HTMLTypeEntity dt = new Workflow_HTMLTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["HTMLTypeID"].ToString() != "" || dr["HTMLTypeID"] != null) dt.HTMLTypeID = Int32.Parse(dr["HTMLTypeID"].ToString());
dt.HTMLTypeName = dr["HTMLTypeName"].ToString();
dt.HTMLTypeDesc = dr["HTMLTypeDesc"].ToString();
dt.Useflag = dr["Useflag"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
