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