public static DataTable GetHandoverLogByHandoverLogId(int handoverLogId) { string connectionString = ConnectionStringFactory.GetNXJCConnectionString(); DataSet ds = new DataSet(); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = connection.CreateCommand(); command.CommandText = @"SELECT WorkingTeamShiftLog.*, StaffInfo.Name AS ChargeManName, ProductLine.Name AS ProductLineName, WorkingTeam.Name AS WorkingTeamName FROM WorkingTeam INNER JOIN StaffInfo INNER JOIN WorkingTeamShiftLog ON StaffInfo.ID = WorkingTeamShiftLog.ChargeManID INNER JOIN ProductLine ON WorkingTeamShiftLog.ProductLineID = ProductLine.ID ON WorkingTeam.ID = WorkingTeamShiftLog.WorkingTeamID WHERE (WorkingTeamShiftLog.ID = @workingTeamShiftLogID)"; command.Parameters.Add(new SqlParameter("workingTeamShiftLogID", handoverLogId)); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(ds); } return ds.Tables[0]; }
public static void LerUsuarios_Desconectado() { DataSet ds = new DataSet(); using (var con = ObterConexao()) { var cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM Usuario"; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); } foreach (DataTable table in ds.Tables) { foreach (DataColumn column in table.Columns) { foreach (DataRow row in table.Rows) { Console.WriteLine("{0}: {1}", column.ColumnName, row[column.ColumnName]); } } } Console.Read(); }
//Activate This Construntor to log All To Standard output //public TestClass():base(true){} //Activate this constructor to log Failures to a log file //public TestClass(System.IO.TextWriter tw):base(tw, false){} //Activate this constructor to log All to a log file //public TestClass(System.IO.TextWriter tw):base(tw, true){} //BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES public void run() { Exception exp = null; DataSet ds = new DataSet(); DataTable dtParent = GHTUtils.DataProvider.CreateParentDataTable(); DataTable dtChild = GHTUtils.DataProvider.CreateChildDataTable(); ds.Tables.Add(dtParent); ds.Tables.Add(dtChild); ForeignKeyConstraint fc = null; fc = new ForeignKeyConstraint(dtParent.Columns[0],dtChild.Columns[0]); try { BeginCase("default "); Compare(fc.ConstraintName ,string.Empty ); } catch(Exception ex) {exp = ex;} finally {EndCase(exp); exp = null;} fc.ConstraintName = "myConstraint"; try { BeginCase("set/get "); Compare(fc.ConstraintName ,"myConstraint" ); } catch(Exception ex) {exp = ex;} finally {EndCase(exp); exp = null;} }
private void button1_Click(object sender, EventArgs e) { bool check; Control.Control control= new Control.Control(); Entity.Entity entity = new Entity.Entity(); entity.setUsername(this.textBox1.Text); entity.setPassword(this.textBox2.Text); check = control.checkUsers(entity.getUsername(), entity.getPassword()); dt = control.getCustomer(entity.getUsername()); if (check) { check1 = true; mainForm main = new mainForm(); main.ShowDialog(); this.textBox1.Text = ""; this.textBox2.Text = ""; } else { this.textBox1.Text = ""; this.textBox2.Text = ""; MessageBox.Show("密码错误或用户名不存在"); } }
public void resetData() { DataSet dstmp = new DataSet(); //创建虚拟数据表 DataTable table = new DataTable("TAB_NM"); //获取列集合,添加列 DataColumnCollection columns = table.Columns; columns.Add("教工号", typeof(String)); columns.Add("姓名", typeof(String)); columns.Add("基本工资", typeof(float)); columns.Add("津贴", typeof(float)); columns.Add("公积金", typeof(float)); columns.Add("生活费", typeof(float)); columns.Add("所得税", typeof(float)); List<Teacher> list = new TeacherDB().selectAll(); //Teacher mTeacher = new Teacher(); foreach (Teacher mTeacher in list) { //添加一行记录 DataRow row = table.NewRow(); row["教工号"] = mTeacher.Id; row["姓名"] = mTeacher.Name; row["基本工资"] = mTeacher.BaseSalary; row["津贴"] = mTeacher.Allowance; row["公积金"] = mTeacher.Fund; row["生活费"] = mTeacher.Sanitary; row["所得税"] = mTeacher.IncomeTax; table.Rows.Add(row); } dstmp.Tables.Add(table); //把信息表放入DataSet中 dataGridView1.DataSource = dstmp.Tables["TAB_NM"]; }
public void BindData() { DataSet searchList = new DataSet(); StringBuilder builder = new StringBuilder(); if (this.txtKeyword.Text.Trim() != "") { builder.Append(" NickName like '%" + this.txtKeyword.Text + "%' "); } if (!string.IsNullOrEmpty(this.txtBeginTime.Text.Trim())) { if (builder.Length > 0) { builder.Append(" and "); } builder.Append(" convert(date,User_dateCreate)>='" + this.txtBeginTime.Text.Trim() + "' "); } if (Globals.SafeInt(this.dropType.SelectedValue, -1) > -1) { if (builder.Length > 0) { builder.Append(" and "); } builder.Append(" Activity=" + this.dropType.SelectedValue + " "); } if (!string.IsNullOrEmpty(this.txtEndTime.Text.Trim())) { if (builder.Length > 0) { builder.Append(" and "); } builder.Append(" convert(date,User_dateCreate)<='" + this.txtEndTime.Text.Trim() + "' "); } searchList = this.user.GetSearchList("UU", builder.ToString()); this.gridView.DataSetSource = searchList; }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { SqlConnection con = new SqlConnection(constring); con.Open(); int curRow = int.Parse(e.RowIndex.ToString()); string currentrow; currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString(); SqlDataAdapter adp1 = new SqlDataAdapter("Select * from ResManagerToAdmin where ResID='" + currentrow + "'", con); DataSet ds1 = new DataSet(); adp1.Fill(ds1); SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + p2 + "' where ResID='" + currentrow + "'", con); cmd.ExecuteNonQuery(); SqlCommand cmd1 = new SqlCommand("Update ResManagerToAdmin set RFinalView='" + p2 + "' where ResID='" + currentrow + "'", con); cmd1.ExecuteNonQuery(); status = ds1.Tables[0].Rows[0]["RStatus"].ToString(); if (status == "Success") { ViewAdminResponses var = new ViewAdminResponses(); var.ShowDialog(); } else { RecordNotFound rnf = new RecordNotFound(); rnf.ShowDialog(); } }
public static List<string> QueryAccessFomList(int userID, string conn) { try { List<string> list = new List<string>(); DataSet ds = new DataSet(); ds.Tables.Add(); ds.Tables[0].Columns.Add("mode"); ds.Tables[0].Columns.Add("id"); ds.Tables[0].Rows.Add("2", userID); DataTable dt = DbUserRes.QueryFormAuth(ds, conn); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string formName = dt.Rows[i]["NAME"].ToString(); if (!list.Contains(formName)) { list.Add(formName); } } } return list; } catch (Exception ex) { throw ex; } }
/// <summary> /// 处理数据 /// </summary> /// <param name="ds"></param> public void HandleData(DataSet ds) { int count = ds.Tables[0].Rows.Count; int current = AspNetPager.PageSize * (AspNetPager.CurrentPageIndex - 1) + 1; dsPosts.Tables.Add("table"); dsPosts.Tables[0].Columns.AddRange(new DataColumn[] { new DataColumn("ID"), new DataColumn("PostTitle"), new DataColumn("PosterID"), new DataColumn("PostContent"), new DataColumn("PostRecordTime"), new DataColumn("PostReplyCount"), new DataColumn("PosterType"), new DataColumn("PostPlateID"), new DataColumn("ViewTimes") }); DataRow row; for (int i = current - 1; (i < current + AspNetPager.PageSize - 1) && (i < count); i++) { row = ds.Tables[0].Rows[i]; dsPosts.Tables[0].Rows.Add(row["ID"], row["PostTitle"], row["PosterID"], row["PostContent"], row["PostRecordTime"], row["PostReplyCount"], row["PosterType"], row["PostPlateID"], row["ViewTimes"]); } }
public SquadForm(DbConnect postgreConnect, DataSet globalDS, int squadID = -1) { InitializeComponent(); cbColumn = new DataGridViewCheckBoxColumn(); cbColumn.HeaderText = "Является сотрудником отряда"; cbColumn.DataPropertyName = "is_in_squad"; cbColumn.FillWeight = 40; cbColumn.ReadOnly = false; dataSet1 = globalDS; postgreConnection = postgreConnect; squadSelectBS.DataSource = dataSet1.Tables["squad"]; listBox1.DataSource = dataSet1.Tables["squad"]; listBox1.DisplayMember = "name"; listBox1.ValueMember = "id"; initEnd = true; if (listBox1.SelectedValue != null) ChangeSelectedSquad(int.Parse(listBox1.SelectedValue.ToString())); else DeactivateAllButtons(); SetButtonPermissions(); if (squadID != -1) listBox1.SelectedValue = squadID; bindingNavigator2.BindingSource = selectionsDataBS; bindingNavigator1.BindingSource = employeesAddBS; dataGridView1.DataSource = selectionsDataBS; }
public IList<Models.Auto> GetAllAutos() { DataSet ds = new DataSet(); myCommand = new SqlDataAdapter("Select * from Auto", myConnection); ds = new DataSet(); myCommand.Fill(ds); IList<Models.Auto> AutoList = new List<Models.Auto>(); foreach (DataRow item in ds.Tables[0].Rows) { AutoList.Add(new Auto { AutoNumber = item["AutoNumber"].ToString(), AutoName = item["AutoName"].ToString() }); } ds.Dispose(); ds = null; return AutoList; }
private void ArrayBinding_Load(object sender, System.EventArgs e) { // Access database System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm mainForm = (System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm)this.ParentForm; // The XML document string fileNameString = mainForm.applicationPath + "\\data\\data.xml"; string fileNameSchema = mainForm.applicationPath + "\\data\\data.xsd"; // Initializes a new instance of the DataSet class DataSet custDS = new DataSet(); // Reads an XML schema into the DataSet. custDS.ReadXmlSchema( fileNameSchema ); // Reads XML schema and data into the DataSet. custDS.ReadXml( fileNameString ); // Initializes a new instance of the DataView class DataView firstView = new DataView(custDS.Tables[0]); Chart1.Series.Clear(); // Since the DataView implements and IEnumerable, pass the reader directly into // the DataBindTable method with the name of the column used for the X value. Chart1.DataBindTable(firstView, "Name"); // Set series appearance Chart1.Series[0].ChartType = SeriesChartType.Bar; Chart1.Series[0].Font = new Font("Trebuchet MS", 8); Chart1.Series[0].Color = System.Drawing.Color.FromArgb(220, 224,64,10); Chart1.Series[0].BorderWidth = 0; }
public void LoadData() { ds = BWorkstation.Retrieves(); dgrWorkstation.AutoGenerateColumns = false; dgrWorkstation.DataSource = ds.Tables[0].DefaultView; GenSTT(); }
public static string runDocno(string tablename, string fieldname, string doctype) { SqlConnection con = new SqlConnection(SysApp.DatabaseConfig.ServerConStr); string sql = " select "; sql += " case when max(substring(" + fieldname + ",4,6)) <> convert(varchar,getdate(),12) then "; sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-0001' "; sql += " when max(substring(" + fieldname + ",4,6)) = convert(varchar,getdate(),12) then "; sql += " case "; sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <10 then '" + doctype + "' + convert(varchar,getdate(),12) + '-000' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) "; sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <100 then '" + doctype + "' + convert(varchar,getdate(),12) + '-00' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) "; sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <1000 then '" + doctype + "' + convert(varchar,getdate(),12) + '-0' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) "; sql += " else "; sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) "; sql += " end "; sql += " else "; sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-0001' "; sql += " end "; sql += " as " + fieldname; sql += " from " + tablename; sql += " where " + fieldname + " like '" + doctype + "%' "; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "runDocno"); string docno = ds.Tables["runDocno"].Rows[0][fieldname].ToString(); da = null; return docno; }
private void cartelera_Load(object sender, EventArgs e) { //frmCiudad ciudad = new frmCiudad(); String numeroSucursal = lblsucursal.Text; string query = string.Format("select TRHORA.idSucursal,MAPELI.iidpelicula, MAPELI.bimagen FROM TRHORARIO TRHORA, MAPELICULA MAPELI WHERE TRHORA.iidpelicula=MAPELI.iidpelicula and TRHORA.idSucursal = '"+ numeroSucursal +"'"); MySqlCommand comando = new MySqlCommand(query, classCrearConexion.Conexion()); MySqlDataAdapter da = new MySqlDataAdapter(comando); DataSet ds = new DataSet("MAPELICULA"); da.Fill(ds, "MAPELICULA"); byte[] datos = new byte[0]; DataRow dr = ds.Tables["MAPELICULA"].Rows[0]; datos = (byte[])dr["bimagen"]; System.IO.MemoryStream ms = new System.IO.MemoryStream(datos); pb1.Image = System.Drawing.Bitmap.FromStream(ms); /*pb1.Image = Properties.Resources.El_Destino_de_Júpite; pb1.Refresh(); pb2.Image = Properties.Resources.FF2; pb2.Refresh(); pb3.Image = Properties.Resources.In_to_the_Woods_En_el_Bosqu; pb3.Refresh(); pb4.Image = Properties.Resources.Ombis_Alien_Invasion__2015_; pb4.Refresh(); pb5.Image = Properties.Resources.peliculas_2015_15_e1422754101215; pb5.Refresh(); pb6.Image = Properties.Resources.peliculas_2015_rapido_furioso_4; pb6.Refresh(); pb7.Image = Properties.Resources.images; pb7.Refresh();*/ }
public bool InsertUpdateDelete(DataSet ds) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand commandInsert = db.GetStoredProcCommand("usp_TaxTypeInsert"); db.AddInParameter(commandInsert, "@CompanyId", DbType.Int32, "CompanyId", DataRowVersion.Current); db.AddInParameter(commandInsert, "@TaxTypeName", DbType.String, "TaxTypeName", DataRowVersion.Current); db.AddInParameter(commandInsert, "@Note", DbType.String, "Note", DataRowVersion.Current); db.AddInParameter(commandInsert, "@TaxPercentage", DbType.Decimal, "TaxPercentage", DataRowVersion.Current); db.AddInParameter(commandInsert, "@CreatedUser", DbType.Int32, "CreatedUser", DataRowVersion.Current); db.AddInParameter(commandInsert, "@StatusId", DbType.Int32, "StatusId", DataRowVersion.Current); DbCommand commandUpdate = db.GetStoredProcCommand("usp_TaxTypeUpdate"); db.AddInParameter(commandUpdate, "@TaxTypeId", DbType.Int32, "TaxTypeId", DataRowVersion.Current); db.AddInParameter(commandUpdate, "@TaxTypeName", DbType.String, "TaxTypeName", DataRowVersion.Current); db.AddInParameter(commandUpdate, "@Note", DbType.String, "Note", DataRowVersion.Current); db.AddInParameter(commandUpdate, "@TaxPercentage", DbType.Decimal, "TaxPercentage", DataRowVersion.Current); db.AddInParameter(commandUpdate, "@UpdatedUser", DbType.Int32, "UpdatedUser", DataRowVersion.Current); db.AddInParameter(commandUpdate, "@StatusId", DbType.Int32, "StatusId", DataRowVersion.Current); DbCommand commandDelete = db.GetStoredProcCommand("usp_TaxTypeDelete"); db.AddInParameter(commandDelete, "@TaxTypeId", DbType.Int32, "TaxTypeId", DataRowVersion.Current); db.UpdateDataSet(ds, ds.Tables[0].TableName, commandInsert, commandUpdate, commandDelete, UpdateBehavior.Transactional); return true; }
public DataSet GetAll(string empresaid, tb_co_tabla01_mediopago BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCoTabla01Mediopago_SEARCH", cnx)) { DataSet ds = new DataSet(); { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@codigoid", SqlDbType.Char, 3).Value = BE.codigoid; cmd.Parameters.Add("@descripcion", SqlDbType.VarChar, 100).Value = BE.descripcion; cmd.Parameters.Add("@sigla", SqlDbType.Char, 3).Value = BE.sigla; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); ds.ReadXml(@"D:\Books.xml"); bookgrd.DataSource = ds.Tables[0]; bookgrd.DataBind(); IEnumerable<DataRow> tbl1row = ds.Tables[0].AsEnumerable(); ds1.ReadXml(@"D:\Books2.xml"); IEnumerable<DataRow> tbl2row = ds1.Tables[0].AsEnumerable(); GridView1.DataSource = ds1.Tables[0]; GridView1.DataBind(); var items = tbl2row.AsEnumerable().Select(r => r.Field<string>("id")) .Except(tbl1row.AsEnumerable().Select(r => r.Field<string>("id"))); DataTable TableC = (from row in tbl2row.AsEnumerable() join id in items on row.Field<string>("id") equals id select row).CopyToDataTable(); GridView2.DataSource = TableC; GridView2.DataBind(); }
protected void load_price() { string price_name = null; string article = null; price_name = Request.QueryString["price_name"]; article = Request.QueryString["article"]; if (article != null) { if (price_name != null) { SqlConnection con = new SqlConnection(str); string sql = "SELECT id, article, ROUND([price]*(SELECT course FROM Course_USD WHERE id = 1),2) AS [price] FROM " + price_name + " WHERE article=" + article + ";"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, price_name); DataRow dr; dr = ds.Tables[price_name].Rows[0]; //Заполняем стоимость товара: lblprice.Text = dr["price"].ToString(); } else {Response.Redirect("Error.aspx");} } else {Response.Redirect("Error.aspx"); } }
public DataSet FilterData(ArsonFilterModel filterData) { var connectionString = ConfigurationManager.ConnectionStrings["UCR_DataEntities"]; DataSet dsResult = new DataSet(); using (SqlConnection conn = new SqlConnection(connectionString.ConnectionString)) { try { SqlCommand command = new SqlCommand(); command.Connection = conn; command.CommandText = GenerateArsonORQuery(filterData); command.CommandType = System.Data.CommandType.Text; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; conn.Open(); adapter.Fill(dsResult); conn.Close(); adapter.Dispose(); command.Dispose(); } catch (Exception ex) { StorageClient.LogError(ex); } } return dsResult; }
/// <summary> /// 根据faterid 获取组织机构树 /// </summary> /// <returns></returns> public DataSet GetORGTreeByID(Dbconn conn, String strType) { DataSet ds = new DataSet(); String strSQL = ""; //获取条件值 string strXML = m_request.Tables[0].Rows[0]["XML"].ToString(); DataSet dsXML = Common.Common.GetDSByExcelXML(strXML); string strPage = dsXML.Tables["LIST"].Rows[0]["Page"].ToString(); string strNum = dsXML.Tables["LIST"].Rows[0]["Num"].ToString(); string strCons = dsXML.Tables["LIST"].Rows[0]["Cons"].ToString(); string strOrderBy = dsXML.Tables["LIST"].Rows[0]["OrderBy"].ToString(); string[] strParam = new string[] { }; strSQL = @" SELECT [OZ1_OrgCode], [OZ1_OrgName], [OZ1_FatherId] , [OZ1_OrgType], [OZ1_ID], [OZ1_CONO], [OZ1_DIVI], [OZ1_FatherId] As [OZ1_FatherIdT] , [OZ1_CostCenterCode], [OZ1_DepartmentManager] , [OZ1_MDeptCode], [OZ1_ShopCode], [OZ1_OrgEnable] , [OZ1_CostCenterEnable], [OZ1_BusdepartmentEnable] , [OZ1_ShopEnable], [OZ1_State], [OZ1_ModelType], [OZ1_BMMoney] , [OZ1_Brand], [OZ1_Com], [OZ1_CostCenterCode1], [OZ1_BMPer] , OZ1_Com1, OZ1_ComCode1, OZ1_ISBranch, OZ1_CostCenterCode2 FROM [F01_CERT].[OZ1_Organization] WHERE 1=1 AND OZ1_OrgType <> '业务线' " + strCons + strOrderBy; ds = conn.GetDataSet(strSQL); return ds; }
private void button1_Click_1(object sender, EventArgs e) { SqlConnection con1 = new SqlConnection(constring); con1.Open(); SqlDataAdapter adp = new SqlDataAdapter("Select whoislogin from Registration", con1); DataSet ds = new DataSet(); adp.Fill(ds); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { SqlCommand cmd = new SqlCommand("Update Registration set whoislogin='******'", con1); cmd.ExecuteNonQuery(); } SqlDataAdapter adp2 = new SqlDataAdapter("Select * from ResManagerToAdmin", con1); DataSet ds2 = new DataSet(); adp2.Fill(ds2); for (int j = 0; j < ds2.Tables[0].Rows.Count; j++) { //adminview = ds.Tables[0].Rows[j]["RView"].ToString(); SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + adminviewempty + "'", con1); cmd.ExecuteNonQuery(); } con1.Close(); this.Close(); }
public static DataSet ExecuteDataSet(CommandType cmdType, string strProcedureName, SqlParameter[] objParameters) { DataSet dset = new DataSet(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db1ConnectionString"].ToString()); con.Open(); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = cmdType; cmd.CommandText = strProcedureName; AttachParameters(cmd, objParameters); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dset); return dset; } catch (Exception ex) { return dset; } finally { con.Close(); } }
public UserAction GetUserDetails(string UserName) { try { oDatabaseHandler = new DatabaseHandler(); DataSet oDataSet = new DataSet(); oDataSet = oDatabaseHandler.FillData("select U.UserId,U.RoleId,R.[Role] RoleName,R.[Create],R.Edit,R.[View],R.Assign,R.Finish from Users as U " + " inner join Roles R on R.RoleId=U.RoleId" + " where U.UserName='******'"); if (oDataSet != null && oDataSet.Tables != null && oDataSet.Tables.Count > 0 && oDataSet.Tables[0].Rows != null && oDataSet.Tables[0].Rows.Count > 0) { UserAction oUserDetails = new UserAction(); //oUserDetails.Cus = int.Parse(oDataSet.Tables[0].Rows[0]["UserId"].ToString()); oUserDetails.UserName = UserName;// oDataSet.Tables[0].Rows[0]["UserId"].ToString(); oUserDetails.RoleID = int.Parse(oDataSet.Tables[0].Rows[0]["RoleId"].ToString()); oUserDetails.RoleName = oDataSet.Tables[0].Rows[0]["RoleName"].ToString(); oUserDetails.Create = bool.Parse(oDataSet.Tables[0].Rows[0]["Create"].ToString()); oUserDetails.Edit = bool.Parse(oDataSet.Tables[0].Rows[0]["Edit"].ToString()); oUserDetails.View = bool.Parse(oDataSet.Tables[0].Rows[0]["View"].ToString()); oUserDetails.Assign = bool.Parse(oDataSet.Tables[0].Rows[0]["Assign"].ToString()); oUserDetails.Finish = bool.Parse(oDataSet.Tables[0].Rows[0]["Finish"].ToString()); return oUserDetails; } return null; } catch (Exception ex) { } return null; }
private void BindData() { SqlDataSource1.DataBind(); //string sqlquery = "SELECT * FROM [ISBEPI_DEV].[dbo].[HomeVisitorSiteVisitSurvey] WHERE Schd_ID = 16"; DataTable dt = new DataTable(); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView view = (DataView)SqlDataSource1.Select(args); dt = view.ToTable(); DataSet ds = new DataSet(); ds.Tables.Add(dt); DataSet new_ds = FlipDataSet(ds); // Flip the DataSet DataView my_DataView = new_ds.Tables[0].DefaultView; this.DataGrid1.DataSource = my_DataView; this.DataGrid1.DataBind(); DataTable dt2 = new DataTable(); DataSourceSelectArguments args2 = new DataSourceSelectArguments(); DataView view2 = (DataView)SqlDataSource2.Select(args2); dt2 = view2.ToTable(); DataSet ds2 = new DataSet(); ds2.Tables.Add(dt2); DataSet new_ds2 = FlipDataSet(ds2); // Flip the DataSet DataView my_DataView2 = new_ds2.Tables[0].DefaultView; this.DataGrid2.DataSource = my_DataView2; this.DataGrid2.DataBind(); }
public void process(ServiceRequest request, ServiceResponse response) { List<Category> list = new List<Category>(); string sqlStr = "select * from category"; MySqlConnection conn = ConnectionManager.getInstance().getConnection(); conn.Open(); MySqlDataAdapter mda = new MySqlDataAdapter(sqlStr, conn); DataSet ds = new DataSet(); mda.Fill(ds,"table1"); conn.Close(); int count = ds.Tables["table1"].Rows.Count; for (int i = 0; i < count; i++) { Category c = new Category(); c.categoryId = (int)ds.Tables["table1"].Rows[i][0]; c.categoryName = (string)ds.Tables["table1"].Rows[i][1]; list.Add(c); } GetCategoryResponse serviceResponse = new GetCategoryResponse(); serviceResponse.categories = list; response.responseObj = serviceResponse; response.returnCode = 0; }
public void challanout() { DataTable dt = new DataTable("challandt"); dt = (DataTable)Session["challanout_dt"]; DataSet ds = new DataSet(); Viewer.Report.ChallanOutrpt crystalReport = new Report.ChallanOutrpt(); string st = HttpContext.Current.Server.MapPath("~/ChallanOutCrpt1.rpt"); // Label1.Text = st; // Response.Write(string.Format("<script language='javascript' type='text/javascript'>alert( "+st+") </script>")); crystalReport.Load(st); if (ds.Tables.Contains("challandt") == true) { ds.Tables.Remove("challandt"); } ds.Tables.Add(dt); ds.WriteXmlSchema(HttpContext.Current.Server.MapPath("~/App_Data/Challanout.xml")); crystalReport.SetDataSource(dt); CrystalReportViewer1.ReportSource = crystalReport; crystalReport.ExportToHttpResponse (CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "CHALLANOUTSHEET"); }
public DataSet GetAll(string empresaid, tb_tipimpto BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbTipimpto_SEARCH", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid; cmd.Parameters.Add("@status", SqlDbType.Bit).Value = BE.status; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet FlipDataSet(DataSet my_DataSet) { DataSet ds = new DataSet(); DataTable table = new DataTable(); foreach (DataTable dt in my_DataSet.Tables) { for (int i = 0; i <= dt.Rows.Count; i++) { table.Columns.Add(Convert.ToString(i)); } for (int k = 0; k < dt.Columns.Count; k++) { r = table.NewRow(); r[0] = dt.Columns[k].ToString(); for (int j = 1; j <= dt.Rows.Count; j++) r[j] = dt.Rows[j - 1][k]; table.Rows.Add(r); } ds.Tables.Add(table); } return ds; }
/// <summary> /// Executes the query. /// </summary> /// <param name="dataSet">The data set to return containing the data.</param> /// <param name="tables">The datatable schema to add.</param> /// <param name="queryText">The query text to execute.</param> /// <param name="commandType">The command type.</param> /// <param name="connectionString">The connection string to use.</param> /// <param name="values">The collection of sql parameters to include.</param> /// <returns>The sql command containing any return values.</returns> public DbCommand ExecuteQuery(ref System.Data.DataSet dataSet, DataTable[] tables, string queryText, CommandType commandType, string connectionString, params DbParameter[] values) { // Initial connection objects. DbCommand dbCommand = null; OracleClient.OracleConnection orlConnection = null; IDataReader dataReader = null; try { // Create a new connection. using (orlConnection = new OracleClient.OracleConnection(connectionString)) { // Open the connection. orlConnection.Open(); // Create the command and assign any parameters. dbCommand = new OracleClient.OracleCommand(DataTypeConversion.GetSqlConversionDataTypeNoContainer( ConnectionContext.ConnectionDataType.OracleDataType, queryText), orlConnection); dbCommand.CommandType = commandType; if (values != null) { foreach (OracleClient.OracleParameter sqlParameter in values) { dbCommand.Parameters.Add(sqlParameter); } } // Load the data into the table. using (dataReader = dbCommand.ExecuteReader()) { dataSet = new System.Data.DataSet(); dataSet.Tables.AddRange(tables); dataSet.EnforceConstraints = false; dataSet.Load(dataReader, LoadOption.OverwriteChanges, tables); dataReader.Close(); } // Close the database connection. orlConnection.Close(); } // Return the sql command, including // any parameters that have been // marked as output direction. return(dbCommand); } catch (Exception ex) { // Throw a general exception. throw new Exception(ex.Message, ex.InnerException); } finally { if (dataReader != null) { dataReader.Close(); } if (orlConnection != null) { orlConnection.Close(); } } }
protected void remplirTableauBien(string idAcq) { //String requeteBien = "SELECT * FROM Biens INNER JOIN optionsBiens ON Biens.ref = optionsBiens.refOptions WHERE Biens.[ref]='" + idAcq + "'"; String requeteBien = "SELECT * FROM Biens INNER JOIN optionsBiens ON Biens.ref = optionsBiens.refOptions WHERE Biens.[ref]='" + Request.QueryString["ref"] + "'"; System.Data.DataSet dst = null; Connexion c = null; c = new Connexion(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); c.Open(); dst = c.exeRequette(requeteBien); c.Close(); c = null; System.Data.DataRowCollection dsr = dst.Tables[0].Rows; Bien bien = new Bien(); foreach (System.Data.DataRow ligne2 in dsr) { bien.REFERENCE = ligne2["ref"].ToString(); bien.ETAT = ligne2["etat"].ToString(); bien.TYPE_BIEN = ligne2["type de bien"].ToString(); bien.S_HABITABLE = (int)ligne2["surface habitable"]; bien.S_SEJOUR = (int)ligne2["surface séjour"]; bien.S_TERRAIN = (int)ligne2["surface terrain"]; bien.NBRE_PIECE = (int)ligne2["nombre de pieces"]; bien.NBRE_CHAMBRE = (int)ligne2["nombre de chambres"]; bien.CODE_POSTAL_BIEN = ligne2["code postal du bien"].ToString(); bien.VILLE_BIEN = ligne2["ville du bien"].ToString().ToUpper(); bien.NEGOCIATEUR = ligne2["negociateur"].ToString(); bien.LOYER_CC = (int)ligne2["loyer_cc"]; bien.PRIX_VENTE = (int)ligne2["prix de vente"]; bien.PAYS = ligne2["PaysBien"].ToString().ToUpper(); bien.ADRESSE_BIEN = ligne2["adresse du bien"].ToString(); bien.ADRESSE_VENDEUR = ligne2["adresse vendeur"].ToString(); //bien.CODE_POSTAL_VENDEUR = int.Parse(ligne2["code postal vendeur"].ToString()); bien.CODE_POSTAL_VENDEUR = ligne2["code postal vendeur"].ToString(); bien.VILLE_VENDEUR = ligne2["ville vendeur"].ToString(); bien.PAYS_VENDEUR = ligne2["pays vendeur"].ToString(); bien.PRENOM_VENDEUR = ligne2["prenom vendeur"].ToString(); bien.NOM_VENDEUR = ligne2["nom vendeur"].ToString(); } int nbphotos = CheckNombrePhotos(bien.REFERENCE); switch (nbphotos) { case 0: LabelImage.Text = "<img style='width:125px;' src='../img_site/images_par_defaut/" + bien.TYPE_BIEN + ".jpg' alt='photo'>" + "<div class='tooltip'><span>" + "<img style='width:250px' src='../img_site/images_par_defaut/" + bien.TYPE_BIEN + ".jpg' alt='photo'></span></div>"; break; case 1: LabelImage.Text = "<img style='width:125px;' src='../images/" + bien.REFERENCE + "A.jpg' alt='photo'>" + "<div class='tooltip'><span>" + nbphotos + " Photo <br/>" + "<img style='width:250px' src='../images/" + bien.REFERENCE + "A.jpg' alt='photo'></span></div>"; break; default: LabelImage.Text = "<img style='width:125px;' src='../images/" + bien.REFERENCE + "A.jpg' alt='photo'>" + "<div class='tooltip'><span>" + nbphotos + " Photos <br/>" + "<img style='width:250px;' src='../images/" + bien.REFERENCE + "A.jpg' alt='photo'> " + "<img style='margin-left:5px;width:250px;' src='../images/" + bien.REFERENCE + "B.jpg' alt='photo'></span></div>"; break; } Label0.Text = ": " + bien.REFERENCE; Label12.Text = "<a href=\"./fichedetail1.aspx?ref=" + bien.REFERENCE + "\" target='_blank'>Voir Fiche</a>"; switch (bien.TYPE_BIEN) { case "A": Label2.Text = ": Appartement"; break; case "M": Label2.Text = ": Maison"; break; case "I": Label2.Text = ": Immeuble"; break; case "L": Label2.Text = ": Local"; break; case "T": Label2.Text = ": Terrain"; break; } string codeiso = Code_iso("bieniso", bien); Label3.Text = ": " + bien.S_HABITABLE.ToString(); Label3bis.Text = ": " + bien.S_SEJOUR.ToString(); Label4.Text = ": " + bien.S_TERRAIN.ToString(); Label5.Text = ": " + bien.NBRE_PIECE.ToString(); Label6.Text = bien.CODE_POSTAL_BIEN + ", " + bien.VILLE_BIEN; Label7.Text = ": " + "<img height='20px' src='../img_site/drapeau/" + codeiso + ".png'/>" + "<div class='tooltip'><span>" + "<img height='50px' src='../img_site/drapeau/" + codeiso + ".png'/></span></div>" + " " + "<a href='https://www.google.fr/maps/place/" + bien.ADRESSE_BIEN + " " + bien.VILLE_BIEN + "' target='_blank'><img style='cursor:pointer' src='../img_site/flat_round/monde.png' height='20px'/></a>" + " " + bien.ADRESSE_BIEN; if (bien.LOYER_CC == 0) { Label9.Text = ": " + bien.PRIX_VENTE.ToString(); } else { Label9.Text = ": " + bien.LOYER_CC.ToString(); } string temp = Label9.Text; string prix = ""; int k = 0; while ((k + 1) * 3 < temp.Length) { prix = temp.Substring((temp.Length - (k + 1) * 3), 3) + " " + prix; k++; } prix = temp.Substring(0, temp.Length - k * 3) + " " + prix; Label9.Text = prix; codeiso = Code_iso("vendeur", bien, null); if (codeiso != "" && bien.ADRESSE_VENDEUR != "" && bien.VILLE_VENDEUR != "") { adressevendeur.Text = "<img height='20px' src='../img_site/drapeau/" + codeiso + ".png'/>" + "<div class='tooltip'><span>" + "<img height='50px' src='../img_site/drapeau/" + codeiso + ".png'/></span></div>" + " " + "<a href='https://www.google.fr/maps/place/" + bien.ADRESSE_VENDEUR + " " + bien.VILLE_VENDEUR + "' target='_blank'><img style='cursor:pointer' src='../img_site/flat_round/monde.png' height='20px'/></a>" + " " + bien.ADRESSE_VENDEUR + "<br/> " + bien.CODE_POSTAL_VENDEUR + ", " + bien.VILLE_VENDEUR; } else if (codeiso == "" || bien.VILLE_VENDEUR == "" || bien.ADRESSE_VENDEUR == "") { if (bien.ADRESSE_VENDEUR == "" || bien.VILLE_VENDEUR == "") { if (codeiso == "") { adressevendeur.Text = bien.ADRESSE_VENDEUR + "<br/> " + bien.CODE_POSTAL_VENDEUR + bien.VILLE_VENDEUR; } else { adressevendeur.Text = "<img height='20px' src='../img_site/drapeau/" + codeiso + ".png'/>" + "<div class='tooltip'><span>" + "<img height='50px' src='../img_site/drapeau/" + codeiso + ".png'/></span></div>" + " " + " " + bien.ADRESSE_VENDEUR + "<br/> " + bien.CODE_POSTAL_VENDEUR + bien.VILLE_VENDEUR; } } else { adressevendeur.Text = "<a href='https://www.google.fr/maps/place/" + bien.ADRESSE_VENDEUR + " " + bien.VILLE_VENDEUR + "' target='_blank'><img style='cursor:pointer' src='../img_site/flat_round/monde.png' height='20px'/></a>" + " " + bien.ADRESSE_VENDEUR + "<br/> " + bien.CODE_POSTAL_VENDEUR + bien.VILLE_VENDEUR; } } nomvendeur.Text = bien.NOM_VENDEUR + " " + bien.PRENOM_VENDEUR; }
/// <summary> /// 高级查询 /// </summary> /// <param name="ServerID">0珠海GPS1深圳GPS2珠海Customer</param> /// <param name="iPageIndex">页索引</param> /// <param name="iPageSize">每页显示记录数</param> /// <param name="strFields">要显示的字段列表</param> /// <param name="strFrom">要查询的表名</param> /// <param name="strWhere">查询条件</param> /// <param name="strOrderBy">排序字段</param> /// <param name="iRecordCount">总记录数</param> /// <param name="iPageCount">总页数</param> /// <param name="ds">DataSet控件ID</param> public bool DataSelect1(int iPageIndex, int iPageSize, string strFields, string strFrom, string strWhere, string strOrderBy, out int iRecordCount, out int iPageCount, out System.Data.DataSet ds, out string strError) { iRecordCount = 0; iPageCount = 0; ds = new DataSet(); strError = string.Empty; bool result = false; SqlConnection myConn = new SqlConnection(m_strConnection); SqlCommand myComm = new SqlCommand("prDefiPager1", myConn); myComm.CommandType = CommandType.StoredProcedure; SqlParameter PageIndex = new SqlParameter("@PageIndex", SqlDbType.Int, 20);//页索引 PageIndex.Value = iPageIndex; myComm.Parameters.Add(PageIndex); SqlParameter PageSize = new SqlParameter("@PageSize", SqlDbType.Int, 20);//每页显示记录数 PageSize.Value = iPageSize; myComm.Parameters.Add(PageSize); SqlParameter Fields = new SqlParameter("@Fields", SqlDbType.VarChar, 500);//要显示的字段列表 Fields.Value = strFields; myComm.Parameters.Add(Fields); SqlParameter From = new SqlParameter("@From", SqlDbType.VarChar, 700);//要查询的表名 From.Value = strFrom; myComm.Parameters.Add(From); SqlParameter Where = new SqlParameter("@Where", SqlDbType.VarChar, 500);//查询条件 Where.Value = strWhere; myComm.Parameters.Add(Where); SqlParameter OrderBy = new SqlParameter("@OrderBy", SqlDbType.VarChar, 100);//排序字段 OrderBy.Value = strOrderBy; myComm.Parameters.Add(OrderBy); SqlParameter RecordCount = new SqlParameter("@RecordCount", SqlDbType.Int);//总记录数 RecordCount.Direction = ParameterDirection.Output; myComm.Parameters.Add(RecordCount); SqlParameter PageCount = new SqlParameter("@PageCount", SqlDbType.Int);//总页数 PageCount.Direction = ParameterDirection.Output; myComm.Parameters.Add(PageCount); try { myConn.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = myComm; sda.Fill(ds); iRecordCount = (int)RecordCount.Value; iPageCount = (int)PageCount.Value; result = true; } catch (Exception ex) { strError = ex.Message; } return(result); }
public static TestOutput CorrectColour(ForeGroundStrucuture[] foregorungRGB_CPU, BackGroundStrucuture[] BackgroundXYZ_CPU) { //rgb = System.Drawing.Color.FromArgb(69, 77, 217); //X = 0.0630982813175294; //Y = 0.616476271122916; //Z = 0.667048468232457; const int image_size = 960 * 540; //cuda intializer CudafyModule km = CudafyModule.TryDeserialize(); if (km == null || !km.TryVerifyChecksums()) { // km = CudafyTranslator.Cudafy((typeof(ForeGroundStrucuture)), (typeof(BackGroundStrucuture)), typeof(Color)); km = CudafyTranslator.Cudafy((typeof(ProfileStrucuture)), (typeof(ForeGroundStrucuture)), (typeof(BackGroundStrucuture)), (typeof(SampleStructure)), typeof(snake)); km.TrySerialize(); } CudafyTranslator.GenerateDebug = true; // cuda or emulator GPGPU gpu = CudafyHost.GetDevice(CudafyModes.Target, CudafyModes.DeviceId); //GPGPU gpu = CudafyHost.GetDevice(eGPUType.Emulator); Console.WriteLine("Running quick correction using {0}", gpu.GetDeviceProperties(false).Name); gpu.LoadModule(km); ForeGroundStrucuture[] distance_CPU = new ForeGroundStrucuture[image_size]; // allocate memory on the GPU for the bitmap (same size as ptr) #region DataTable profile = new DataTable(); try { // add the csv bin file using (GenericParserAdapter parser = new GenericParserAdapter(@"C:\lev\STColorCorrection\Data\PROFILE\p3700.csv")) { System.Data.DataSet dsResult = parser.GetDataSet(); profile = dsResult.Tables[0]; } } catch (Exception ex) { Console.WriteLine(ex); } #endregion // allocate temp memory, initialize it, copy to constant memory on the GPU // L 0-21 A 0-41 B 0-45 ProfileStrucuture[, ,] profiles_CPU = new ProfileStrucuture[21, 41, 45]; SampleStructure[,] samples_CPU = new SampleStructure[image_size, 6]; //profile inicialization #region for (int indexL = 0; indexL < 21; indexL++) { for (int indexA = 0; indexA < 41; indexA++) { for (int indexB = 0; indexB < 45; indexB++) { profiles_CPU[indexL, indexA, indexB].L = indexL; profiles_CPU[indexL, indexA, indexB].A = indexA; profiles_CPU[indexL, indexA, indexB].B = indexB; profiles_CPU[indexL, indexA, indexB].Given_R = 0; profiles_CPU[indexL, indexA, indexB].Given_G = 0; profiles_CPU[indexL, indexA, indexB].Given_B = 0; profiles_CPU[indexL, indexA, indexB].ML = 0; profiles_CPU[indexL, indexA, indexB].MA = 0; profiles_CPU[indexL, indexA, indexB].MB = 0; profiles_CPU[indexL, indexA, indexB].MX = 0; profiles_CPU[indexL, indexA, indexB].MY = 0; profiles_CPU[indexL, indexA, indexB].MZ = 0; profiles_CPU[indexL, indexA, indexB].distance = -1.0; profiles_CPU[indexL, indexA, indexB].weight = -1.0; profiles_CPU[indexL, indexA, indexB].isempty = TRUE; profiles_CPU[indexL, indexA, indexB].isMoreAccurateThanOrigin = FALSE; } } } int lvalue, avalue, bvalue; try { for (int i = 1; i < profile.Rows.Count; i++) { lvalue = Convert.ToInt32(profile.Rows[i][0].ToString()); avalue = Convert.ToInt32(profile.Rows[i][1].ToString()); bvalue = Convert.ToInt32(profile.Rows[i][2].ToString()); lvalue = (int)(lvalue * 0.2); avalue = (int)(avalue * 0.2) + 20; bvalue = (int)(bvalue * 0.2) + 22; profiles_CPU[lvalue, avalue, bvalue].L = lvalue; profiles_CPU[lvalue, avalue, bvalue].A = avalue; profiles_CPU[lvalue, avalue, bvalue].B = bvalue; profiles_CPU[lvalue, avalue, bvalue].Given_R = (byte)Convert.ToByte(profile.Rows[i][9].ToString()); profiles_CPU[lvalue, avalue, bvalue].Given_G = (byte)Convert.ToByte(profile.Rows[i][10].ToString()); profiles_CPU[lvalue, avalue, bvalue].Given_B = (byte)Convert.ToByte(profile.Rows[i][11].ToString()); profiles_CPU[lvalue, avalue, bvalue].ML = (double)Convert.ToDouble(profile.Rows[i][3].ToString()); profiles_CPU[lvalue, avalue, bvalue].MA = (double)Convert.ToDouble(profile.Rows[i][4].ToString()); profiles_CPU[lvalue, avalue, bvalue].MB = (double)Convert.ToDouble(profile.Rows[i][5].ToString()); profiles_CPU[lvalue, avalue, bvalue].MX = (double)Convert.ToDouble(profile.Rows[i][6].ToString()); profiles_CPU[lvalue, avalue, bvalue].MY = (double)Convert.ToDouble(profile.Rows[i][7].ToString()); profiles_CPU[lvalue, avalue, bvalue].MZ = (double)Convert.ToDouble(profile.Rows[i][8].ToString()); profiles_CPU[lvalue, avalue, bvalue].isempty = FALSE; } } catch (Exception ex) { Console.WriteLine(ex); } #endregion //grab the colors ProfileStrucuture[, ,] profile_GPU = gpu.CopyToDevice(profiles_CPU); SampleStructure[,] samples_GPU = gpu.CopyToDevice(samples_CPU); //begin execution // capture the start time gpu.StartTimer(); ForeGroundStrucuture[] foregorungRGB_GPU = gpu.CopyToDevice(foregorungRGB_CPU); BackGroundStrucuture[] BackgroundXYZ_GPU = gpu.CopyToDevice(BackgroundXYZ_CPU); //out put ForeGroundStrucuture[] distance_GPU = gpu.Allocate(distance_CPU); // generate a bitmap from our sphere data //Image size: 1024 x 768 dim3 grids = new dim3(24, 675); dim3 threads = new dim3(8, 4); //dim3 grids = new dim3(1, 1); //dim3 threads = new dim3(1, 1); //quick_correct //gpu.Launch(grids, threads, ((Action<GThread, ProfileStrucuture[, ,], ForeGroundStrucuture[], BackGroundStrucuture[], ProfileStrucuture[], SampleStructure[,]>)QuickCorr), profile_GPU, foregorungRGB_GPU, BackgroundXYZ_GPU, distance_GPU, samples_GPU); //quick correct - testing gpu.Launch(grids, threads, ((Action <GThread, ProfileStrucuture[, , ], ForeGroundStrucuture[], BackGroundStrucuture[], ForeGroundStrucuture[], SampleStructure[, ]>)Snake), profile_GPU, foregorungRGB_GPU, BackgroundXYZ_GPU, distance_GPU, samples_GPU); // copy our bitmap back from the GPU for display gpu.CopyFromDevice(distance_GPU, distance_CPU); // get stop time, and display the timing results double elapsedTime = gpu.StopTimer(); TestOutput to_return = new TestOutput(); to_return.output_image = distance_CPU; to_return.timeTaken = elapsedTime; Console.WriteLine("Time to generate: {0} ms", elapsedTime); gpu.Free(foregorungRGB_GPU); gpu.Free(BackgroundXYZ_GPU); gpu.Free(distance_GPU); gpu.FreeAll(); return(to_return); }
protected override System.Data.DataSet CreateDataSource() { System.Data.DataSet dataSet = new System.Data.DataSet(); DataTable empInfoTable = new DataTable("EmpInfo"); DataTable payrollTable = new DataTable("Payment"); dataSet.Tables.Add(empInfoTable); dataSet.Tables.Add(payrollTable); payrollTable.Columns.Add("EmpPayrollID", typeof(string)); int firstDetailColumnPos = payrollTable.Columns.Count; empInfoTable.Columns.Add("Employee No.", typeof(string)); empInfoTable.Columns.Add("EmpPayrollID", typeof(int)); empInfoTable.Columns.Add("Employee Name", typeof(string)); empInfoTable.Columns.Add("Alias", typeof(string)); empInfoTable.Columns.Add("Company", typeof(string)); DBFilter hierarchyLevelFilter = new DBFilter(); Hashtable hierarchyLevelHashTable = new Hashtable(); hierarchyLevelFilter.add("HLevelSeqNo", true); ArrayList hierarchyLevelList = EHierarchyLevel.db.select(dbConn, hierarchyLevelFilter); //***** Start 2013/11/22, Ricky So, Special handle display by staff level (not in hierarchy setting) if (intHierarchyLevelID == STAFF_LEVEL_ID) { hierarchyLevelGroupingFieldName = "Employee Name"; } //***** End 2013/11/22, Ricky So, Special handle display by staff level (not in hierarchy setting) foreach (EHierarchyLevel hlevel in hierarchyLevelList) { if (hlevel.HLevelID.Equals(intHierarchyLevelID)) { hierarchyLevelGroupingFieldName = hlevel.HLevelDesc; } empInfoTable.Columns.Add(hlevel.HLevelDesc, typeof(string)); hierarchyLevelHashTable.Add(hlevel.HLevelID, hlevel); } empInfoTable.Columns.Add("Payroll Group", typeof(string)); empInfoTable.Columns.Add("Date Join", typeof(DateTime)); empInfoTable.Columns.Add("Date Left", typeof(DateTime)); empInfoTable.Columns.Add("Net Payable", typeof(double)); empInfoTable.Columns.Add("MCEE", typeof(double)); empInfoTable.Columns.Add("MCER", typeof(double)); empInfoTable.Columns.Add("VCEE", typeof(double)); empInfoTable.Columns.Add("VCER", typeof(double)); empInfoTable.Columns.Add("PFundEE", typeof(double)); empInfoTable.Columns.Add("PFundER", typeof(double)); DBFilter payPeriodFilter = new DBFilter(); if (!PeriodFrom.Ticks.Equals(0)) { payPeriodFilter.add(new Match("PayPeriodTo", ">=", PeriodFrom)); } if (!PeriodTo.Ticks.Equals(0)) { payPeriodFilter.add(new Match("PayPeriodTo", "<=", PeriodTo)); } ArrayList payPeriodList = EPayrollPeriod.db.select(dbConn, payPeriodFilter); if (payPeriodList.Count > 0) { // reset period PeriodFrom = new DateTime(); PeriodTo = new DateTime(); } DBFilter m_userCompanyFilter = new DBFilter(); m_userCompanyFilter.add(new Match("UserID", currentUser.UserID)); DBFilter m_userRankFilter = new DBFilter(); m_userRankFilter.add(new Match("UserID", currentUser.UserID)); Hashtable m_userCompanyList = new Hashtable(); foreach (EUserCompany m_userCompany in EUserCompany.db.select(dbConn, m_userCompanyFilter)) { m_userCompanyList.Add(m_userCompany.CompanyID, m_userCompany.CompanyID); } Hashtable m_userRankList = new Hashtable(); foreach (EUserRank m_userRank in EUserRank.db.select(dbConn, m_userRankFilter)) { m_userRankList.Add(m_userRank.RankID, m_userRank.RankID); } int[] m_EmpIDList = new int[empList.Count]; int i = 0; foreach (EEmpPersonalInfo m_info in empList) { m_EmpIDList[i] = m_info.EmpID; i++; } foreach (EPayrollPeriod payPeriod in payPeriodList) { if (PeriodFrom > payPeriod.PayPeriodFr || PeriodFrom.Ticks.Equals(0)) { PeriodFrom = payPeriod.PayPeriodFr; } if (PeriodTo < payPeriod.PayPeriodTo || PeriodTo.Ticks.Equals(0)) { PeriodTo = payPeriod.PayPeriodTo; } DBFilter empPayrollFilter = new DBFilter(); empPayrollFilter.add(new Match("PayPeriodID", payPeriod.PayPeriodID)); empPayrollFilter.add(new IN("EmpID", m_EmpIDList)); ArrayList empPayrollList = EEmpPayroll.db.select(dbConn, empPayrollFilter); foreach (EEmpPayroll empPayroll in empPayrollList) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = empPayroll.EmpID; EEmpPersonalInfo.db.select(dbConn, empInfo); DataRow row = empInfoTable.NewRow(); DataRow paymentRow = payrollTable.NewRow(); row["Employee No."] = empInfo.EmpNo; row["EmpPayrollID"] = empPayroll.EmpPayrollID; paymentRow["EmpPayrollID"] = empPayroll.EmpPayrollID; row["Employee Name"] = empInfo.EmpEngFullName; row["Alias"] = empInfo.EmpAlias; row["Date Join"] = empInfo.EmpDateOfJoin; DBFilter empTerminationFilter = new DBFilter(); empTerminationFilter.add(new Match("EmpID", empInfo.EmpID)); ArrayList empTerminationList = EEmpTermination.db.select(dbConn, empTerminationFilter); if (empTerminationList.Count > 0) { row["Date Left"] = ((EEmpTermination)empTerminationList[0]).EmpTermLastDate; } DBFilter empPosFilter = new DBFilter(); EEmpPositionInfo empPos = AppUtils.GetLastPositionInfo(dbConn, payPeriod.PayPeriodTo, empInfo.EmpID); if (empPos != null) { if (!m_userCompanyList.Contains(empPos.CompanyID) || !m_userRankList.Contains(empPos.RankID)) { continue; } ECompany company = new ECompany(); company.CompanyID = empPos.CompanyID; if (ECompany.db.select(dbConn, company)) { row["Company"] = company.CompanyName; } EPayrollGroup payrollGroup = new EPayrollGroup(); payrollGroup.PayGroupID = empPos.PayGroupID; if (EPayrollGroup.db.select(dbConn, payrollGroup)) { row["Payroll Group"] = payrollGroup.PayGroupDesc; } DBFilter empHierarchyFilter = new DBFilter(); empHierarchyFilter.add(new Match("EmpPosID", empPos.EmpPosID)); ArrayList empHierarchyList = EEmpHierarchy.db.select(dbConn, empHierarchyFilter); foreach (EEmpHierarchy empHierarchy in empHierarchyList) { EHierarchyLevel hierarchyLevel = (EHierarchyLevel)hierarchyLevelHashTable[empHierarchy.HLevelID]; if (hierarchyLevel != null) { EHierarchyElement hierarchyElement = new EHierarchyElement(); hierarchyElement.HElementID = empHierarchy.HElementID; if (EHierarchyElement.db.select(dbConn, hierarchyElement)) { row[hierarchyLevel.HLevelDesc] = hierarchyElement.HElementDesc; } } } } double netAmount = 0, releventIncome = 0, nonRelevantIncome = 0, MCEE = 0, MCER = 0, VCEE = 0, VCER = 0, PFUNDEE = 0, PFUNDER = 0; DBFilter paymentRecordFilter = new DBFilter(); paymentRecordFilter.add(new Match("EmpPayrollID", empPayroll.EmpPayrollID)); paymentRecordFilter.add(new Match("PayRecStatus", "A")); ArrayList paymentRecords = EPaymentRecord.db.select(dbConn, paymentRecordFilter); foreach (EPaymentRecord paymentRecord in paymentRecords) { EPaymentCode payCode = new EPaymentCode(); payCode.PaymentCodeID = paymentRecord.PaymentCodeID; EPaymentCode.db.select(dbConn, payCode); string fieldName = payCode.PaymentCodeDesc; if (payrollTable.Columns[fieldName] == null) { payrollTable.Columns.Add(new DataColumn(fieldName, typeof(double))); } if (paymentRow[fieldName] == null || paymentRow[fieldName] == DBNull.Value) { paymentRow[fieldName] = 0; } paymentRow[fieldName] = (double)paymentRow[fieldName] + paymentRecord.PayRecActAmount; netAmount += paymentRecord.PayRecActAmount; if (payCode.PaymentCodeIsMPF) { releventIncome += paymentRecord.PayRecActAmount; } else { nonRelevantIncome += paymentRecord.PayRecActAmount; } } row["Net Payable"] = HROne.CommonLib.GenericRoundingFunctions.RoundingTo(netAmount, ExchangeCurrency.DefaultCurrencyDecimalPlaces(), ExchangeCurrency.DefaultCurrencyDecimalPlaces()); //row["Relevant Income"] = HROne.CommonLib.GenericRoundingFunctions.RoundingTo(releventIncome, ExchangeCurrency.DefaultCurrencyDecimalPlaces(), ExchangeCurrency.DefaultCurrencyDecimalPlaces()); //row["Non-Relevant Income"] = HROne.CommonLib.GenericRoundingFunctions.RoundingTo(nonRelevantIncome, ExchangeCurrency.DefaultCurrencyDecimalPlaces(), ExchangeCurrency.DefaultCurrencyDecimalPlaces()); DBFilter mpfRecordFilter = new DBFilter(); mpfRecordFilter.add(new Match("EmpPayrollID", empPayroll.EmpPayrollID)); ArrayList mpfRecords = EMPFRecord.db.select(dbConn, mpfRecordFilter); foreach (EMPFRecord mpfRecord in mpfRecords) { VCER += mpfRecord.MPFRecActVCER; MCER += mpfRecord.MPFRecActMCER; VCEE += mpfRecord.MPFRecActVCEE; MCEE += mpfRecord.MPFRecActMCEE; } row["MCEE"] = MCEE; row["VCEE"] = VCEE; row["MCER"] = MCER; row["VCER"] = VCER; ArrayList orsoRecords = EORSORecord.db.select(dbConn, mpfRecordFilter); foreach (EORSORecord orsoRecord in orsoRecords) { PFUNDER += orsoRecord.ORSORecActER; PFUNDEE += orsoRecord.ORSORecActEE; } row["PFundEE"] = PFUNDEE; row["PFundER"] = PFUNDER; empInfoTable.Rows.Add(row); payrollTable.Rows.Add(paymentRow); } } DBFilter paymentCodeFilter = new DBFilter(); paymentCodeFilter.add("PaymentCodeDisplaySeqNo", false); paymentCodeFilter.add("PaymentCode", false); ArrayList paymentCodeList = EPaymentCode.db.select(dbConn, paymentCodeFilter); foreach (EPaymentCode paymentCode in paymentCodeList) { if (payrollTable.Columns.Contains(paymentCode.PaymentCodeDesc)) { payrollTable.Columns[paymentCode.PaymentCodeDesc].SetOrdinal(firstDetailColumnPos); } } return(dataSet); }
protected ushort GenerateColumnHeader(NPOI.HSSF.UserModel.HSSFSheet workSheet, System.Data.DataSet dataSet, string CompanyHeader, string HierarchyHeader, ushort RowPos, NPOI.HSSF.UserModel.HSSFCellStyle GroupHeaderStyle, NPOI.HSSF.UserModel.HSSFCellStyle ColumnHeaderStyle) { DataTable paymentTable = dataSet.Tables["payment"]; //org.in2bits.MyXls.XF xf = xlsDoc.NewXF(); //xf.Font.Bold = true; //xf.BottomLineStyle = (ushort)1; RowPos += 2; //workSheet.Cells.Add((int)RowPos, 1, "Company"); //workSheet.Cells.Add((int)RowPos, 2, CompanyHeader); //workSheet.Rows[RowPos].GetCell(1).Font.Bold = true; //workSheet.Rows[RowPos].GetCell(2).Font.Bold = true; NPOI.HSSF.UserModel.HSSFRow row = (NPOI.HSSF.UserModel.HSSFRow)workSheet.CreateRow((int)RowPos); NPOI.HSSF.UserModel.HSSFCell cell = (NPOI.HSSF.UserModel.HSSFCell)row.CreateCell(0); cell.SetCellValue("Company"); cell.CellStyle = GroupHeaderStyle; cell = (NPOI.HSSF.UserModel.HSSFCell)row.CreateCell(1); cell.SetCellValue(CompanyHeader); cell.CellStyle = GroupHeaderStyle; RowPos += 2; //workSheet.Cells.Add((int)RowPos, 1, HierarchyHeader, xf); row = (NPOI.HSSF.UserModel.HSSFRow)workSheet.CreateRow((int)RowPos); ushort colPos = 0; // ***** Start 2013/11/22, Ricky So, grouping for Staff where Employee No is necessary if (intHierarchyLevelID == STAFF_LEVEL_ID) { cell = (NPOI.HSSF.UserModel.HSSFCell)row.CreateCell(colPos); cell.SetCellValue("Employee No."); cell.CellStyle = ColumnHeaderStyle; colPos++; } // ***** End 2013/11/22, Ricky So, grouping for Staff where Employee No is necessary cell = (NPOI.HSSF.UserModel.HSSFCell)row.CreateCell(colPos); cell.SetCellValue(HierarchyHeader); cell.CellStyle = ColumnHeaderStyle; foreach (DataColumn column in paymentTable.Columns) { if (column.ColumnName.Equals("EmpPayrollID")) { continue; } colPos++; //workSheet.Cells.Add(RowPos, colPos, column.ColumnName, xf); cell = (NPOI.HSSF.UserModel.HSSFCell)row.CreateCell(colPos); cell.SetCellValue(column.ColumnName); cell.CellStyle = ColumnHeaderStyle; } colPos++; //workSheet.Cells.Add(RowPos, colPos, "Net Pay", xf); cell = (NPOI.HSSF.UserModel.HSSFCell)row.CreateCell(colPos); cell.SetCellValue("Net Pay"); cell.CellStyle = ColumnHeaderStyle; colPos++; //workSheet.Cells.Add(RowPos, colPos, "Employer Contribution", xf); cell = (NPOI.HSSF.UserModel.HSSFCell)row.CreateCell(colPos); cell.SetCellValue("Employer Contribution"); cell.CellStyle = ColumnHeaderStyle; //workSheet.Cells.Merge((int)RowPos - 2, (int)RowPos - 2, 2, colPos); workSheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress((int)RowPos - 2, (int)RowPos - 2, 1, colPos)); return(RowPos); }
void cargar() { Int32 id = Convert.ToInt32(Request.QueryString["IDVP"]); PedidoDAO db = new PedidoDAO(); System.Data.DataSet ds = db.BuscarPedido(id); DataTable dtcabecera = ds.Tables[0]; AsignaZonaDAO db1 = new AsignaZonaDAO(); string idusu = Session["IDUsuario"].ToString(); txtnumeropuesto.Text = Convert.ToString(dtcabecera.Rows[0]["NumeroPuesto"]); txtfecha.Text = Convert.ToDateTime(dtcabecera.Rows[0]["fechaCheque"]).ToString("yyyy-MM-dd"); ddlmercados.SelectedValue = Convert.ToString(dtcabecera.Rows[0]["IdMercado"]); lbligv.Text = Convert.ToString(dtcabecera.Rows[0]["IGV"]); lbltotal.Text = Convert.ToString(dtcabecera.Rows[0]["Total_Venta"]); lblnombre.Text = Convert.ToString(dtcabecera.Rows[0]["NombrePropietario"]); ddlmoneda.SelectedValue = Convert.ToString(dtcabecera.Rows[0]["Id_Moneda"]); ddlformapago.SelectedValue = Convert.ToString(dtcabecera.Rows[0]["Id_FormaPago"]); string idzona = Convert.ToString(dtcabecera.Rows[0]["IdZona"]); lblzona.Text = Convert.ToString(dtcabecera.Rows[0]["DescripLarga"]); cargarmercado(idzona); DataTable detalles = (DataTable)Session["detalles"]; if (detalles.Rows.Count > 0) { detalles.Rows.Clear(); } DataTable dtdetalles = ds.Tables[1]; foreach (DataRow Rg in dtdetalles.Rows) { string idpro = Convert.ToString(Rg["Id_prod"]); string Descripcion = Convert.ToString(Rg["descripcion"]); decimal precio = Convert.ToDecimal(Rg["PrecioUnit"]); int dcantidad = Convert.ToInt32(Rg["Paquetes"]); decimal peso = Convert.ToDecimal(Rg["CantidadKilos"]); decimal igv = Convert.ToDecimal(Rg["IGV"]); int unidad = Convert.ToInt32(Rg["Unidad"]); int idmedida = Convert.ToInt32(Rg["Id_UMedida"]); decimal cantidadkilos = Math.Round(dcantidad * peso, 2); if (idpro == "486" || idpro == "488" || idpro == "487") { decimal total = dcantidad * precio * peso; Util.Helper.Agregar_Detalles(detalles, idpro, Descripcion, precio, dcantidad, peso, igv, total, cantidadkilos, unidad, idmedida); Session["detalles"] = detalles; } else { if (precio <= 14.00m) { decimal total = dcantidad * precio * peso; Util.Helper.Agregar_Detalles(detalles, idpro, Descripcion, precio, dcantidad, peso, igv, total, cantidadkilos, unidad, idmedida); Session["detalles"] = detalles; } else { decimal total = dcantidad * precio; Util.Helper.Agregar_Detalles(detalles, idpro, Descripcion, precio, dcantidad, peso, igv, total, cantidadkilos, unidad, idmedida); Session["detalles"] = detalles; } } } cargarDetalles(); //lbltotal.Text = Util.Helper.TotalizarGrilla(grvDetalles,5).ToString(); }
public string GenerarPlanoXML(int idDocumento, string strNombreDocumento, int idCompania, string strCompania, string strUsuario, string strClave, System.Data.DataSet dsFuenteDatos, ref string Path, ref string strResultado) { object[] results = this.Invoke("GenerarPlanoXML", new object[] { idDocumento, strNombreDocumento, idCompania, strCompania, strUsuario, strClave, dsFuenteDatos, Path, strResultado }); Path = ((string)(results[1])); strResultado = ((string)(results[2])); return((string)(results[0])); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.gridControl1 = new DefaultEditor.UserGridControl(); this.DataTable1 = new System.Data.DataTable(); this.DataColumn1 = new System.Data.DataColumn(); this.DataColumn2 = new System.Data.DataColumn(); this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView(); this.colLastAccessTime = new DevExpress.XtraGrid.Columns.GridColumn(); this.colEncrypted = new DevExpress.XtraGrid.Columns.GridColumn(); this.DataSet1 = new System.Data.DataSet(); ((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.DataTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.DataSet1)).BeginInit(); this.SuspendLayout(); // // gridControl1 // this.gridControl1.DataSource = this.DataTable1; this.gridControl1.Dock = System.Windows.Forms.DockStyle.Fill; // // gridControl1.EmbeddedNavigator // this.gridControl1.EmbeddedNavigator.Name = ""; this.gridControl1.Location = new System.Drawing.Point(0, 0); this.gridControl1.MainView = this.gridView1; this.gridControl1.Name = "gridControl1"; this.gridControl1.Size = new System.Drawing.Size(416, 270); this.gridControl1.TabIndex = 0; this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { this.gridView1 }); // // DataTable1 // this.DataTable1.Columns.AddRange(new System.Data.DataColumn[] { this.DataColumn1, this.DataColumn2 }); this.DataTable1.TableName = "Table1"; // // DataColumn1 // this.DataColumn1.ColumnName = "LastAccessTime"; this.DataColumn1.DataType = typeof(System.DateTime); // // DataColumn2 // this.DataColumn2.ColumnName = "Encrypted"; this.DataColumn2.DataType = typeof(bool); // // gridView1 // this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { this.colLastAccessTime, this.colEncrypted }); this.gridView1.GridControl = this.gridControl1; this.gridView1.Name = "gridView1"; // // colLastAccessTime // this.colLastAccessTime.Caption = "LastAccessTime"; this.colLastAccessTime.FieldName = "LastAccessTime"; this.colLastAccessTime.Name = "colLastAccessTime"; this.colLastAccessTime.Visible = true; this.colLastAccessTime.VisibleIndex = 0; // // colEncrypted // this.colEncrypted.Caption = "Encrypted"; this.colEncrypted.FieldName = "Encrypted"; this.colEncrypted.Name = "colEncrypted"; this.colEncrypted.Visible = true; this.colEncrypted.VisibleIndex = 1; // // DataSet1 // this.DataSet1.DataSetName = "NewDataSet"; this.DataSet1.Locale = new System.Globalization.CultureInfo("en-US"); this.DataSet1.Tables.AddRange(new System.Data.DataTable[] { this.DataTable1 }); // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(416, 270); this.Controls.Add(this.gridControl1); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.DataTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.DataSet1)).EndInit(); this.ResumeLayout(false); }
private void LoadReport() { rptVwrTodaysSales.Visible = true; rptVwrTodaysSales.LocalReport.ReportPath = string.Format(Server.MapPath(@"rdl\TodaysSalesReport.rdl")); SqlCommand cmd = new SqlCommand(); DateTime dtFromDate = Convert.ToDateTime(txtFromDate.Text.ToString()); DateTime dtToDate = Convert.ToDateTime(txtToDate.Text.ToString()); cmd.Parameters.Add(new SqlParameter("@FromDay", dtFromDate.Day)); cmd.Parameters.Add(new SqlParameter("@FromMonth", dtFromDate.Month)); cmd.Parameters.Add(new SqlParameter("@FromYear", dtFromDate.Year)); cmd.Parameters.Add(new SqlParameter("@ToDay", dtToDate.Day)); cmd.Parameters.Add(new SqlParameter("@ToMonth", dtToDate.Month)); cmd.Parameters.Add(new SqlParameter("@ToYear", dtToDate.Year)); string thisConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection thisConnection = new SqlConnection(thisConnectionString); cmd.Connection = thisConnection; cmd.CommandText = "usp_getTodaysSales"; cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); System.Data.DataSet thisDataSet = new System.Data.DataSet(); /* Put the stored procedure result into a dataset */ da.Fill(thisDataSet); /* Associate thisDataSet (now loaded with the stored * procedure result) with the ReportViewer datasource */ ReportDataSource datasource = new ReportDataSource("dtsetTodaysSales", thisDataSet.Tables[0]); rptVwrTodaysSales.LocalReport.DataSources.Clear(); rptVwrTodaysSales.LocalReport.DataSources.Add(datasource); //if (thisDataSet.Tables[0].Rows.Count == 0) //{ //} using (StreamReader rdlcSR = new StreamReader(Server.MapPath(@"rdl\TodaysSalesReport.rdl"))) { rptVwrTodaysSales.LocalReport.LoadReportDefinition(rdlcSR); List <ReportParameter> lst = new List <ReportParameter>(); ReportParameter rptParam1 = new ReportParameter("FromDay", dtFromDate.Day.ToString()); ReportParameter rptParam2 = new ReportParameter("FromMonth", dtFromDate.Month.ToString()); ReportParameter rptParam3 = new ReportParameter("FromYear", dtFromDate.Year.ToString()); ReportParameter rptParam4 = new ReportParameter("ToDay", dtToDate.Day.ToString()); ReportParameter rptParam5 = new ReportParameter("ToMonth", dtToDate.Month.ToString()); ReportParameter rptParam6 = new ReportParameter("ToYear", dtToDate.Year.ToString()); lst.Add(rptParam1); lst.Add(rptParam2); lst.Add(rptParam3); lst.Add(rptParam4); lst.Add(rptParam5); lst.Add(rptParam6); rptVwrTodaysSales.LocalReport.SetParameters(lst); rptVwrTodaysSales.LocalReport.Refresh(); } }
private void btnExcel_Click(object sender, EventArgs e) { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "General".ToUpper()) { string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "','General'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "tblLeaveDetails"; gridExcel.DataSource = null; gridExcel.DataSource = dsList.Tables["tblLeaveDetails"]; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "ML".ToUpper()) { string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'ML'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "tblLeaveDetails"; gridExcel.DataSource = null; gridExcel.DataSource = dsList.Tables["tblLeaveDetails"]; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "FirstML".ToUpper()) { string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'FirstML'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "tblLeaveDetails"; gridExcel.DataSource = null; gridExcel.DataSource = dsList.Tables["tblLeaveDetails"]; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "LastML".ToUpper()) { string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'LastML'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "tblLeaveDetails"; gridExcel.DataSource = null; gridExcel.DataSource = dsList.Tables["tblLeaveDetails"]; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "Details".ToUpper()) { string sqlquary = "Exec rptLeaveBalance " + Common.Classes.clsMain.intComId + ", '" + cboFinyear.Value.ToString() + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'Details'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "tblLeaveDetails"; gridExcel.DataSource = null; gridExcel.DataSource = dsList.Tables["tblLeaveDetails"]; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "Summary".ToUpper()) { string sqlquary = "Exec rptLeaveBalance " + Common.Classes.clsMain.intComId + ", " + cboFinyear.Value.ToString() + ",'" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "','Summary'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "tblLeaveDetails"; gridExcel.DataSource = null; gridExcel.DataSource = dsList.Tables["tblLeaveDetails"]; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "MonthDetails".ToUpper()) { string sqlquary = "Exec rptLeaveBalanceDetails " + Common.Classes.clsMain.intComId + ", " + cboFinyear.Value.ToString() + ",'" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'MonthDetails'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "tblLeaveDetails"; gridExcel.DataSource = null; gridExcel.DataSource = dsList.Tables["tblLeaveDetails"]; } DialogResult dlgRes = MessageBox.Show("Do You Want to Save the Data Sheet"); if (dlgRes != DialogResult.OK) { return; } SaveFileDialog dlgSurveyExcel = new SaveFileDialog(); dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls"; dlgSurveyExcel.FileName = gridCriteria.ActiveRow.Cells["Criteria"].Text.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_"); dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog(); if (dlgResSaveFile == DialogResult.Cancel) { return; } Cursor.Current = Cursors.WaitCursor; Application.DoEvents(); UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter(); GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData; GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn); GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName); MessageBox.Show("Download complete."); }
private void btnPreview_Click(object sender, EventArgs e) { dsDetails = new DataSet(); ArrayList arQuery = new ArrayList(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); try { string ReportPath = "", SQLQuery = "", DataSourceName = "DataSet1", FormCaption = ""; DataSourceName = "DataSet1"; FormCaption = "Report :: Leave Information..."; if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "General".ToUpper()) { ReportPath = Common.Classes.clsMain.AppPath + @"\Attendence\Reports\rptLeaveList.rdlc"; SQLQuery = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','=ALL=','General'"; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "ML".ToUpper()) { ReportPath = Common.Classes.clsMain.AppPath + @"\Attendence\Reports\rptLeaveList.rdlc"; SQLQuery = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'ML'"; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "FirstML".ToUpper()) { ReportPath = Common.Classes.clsMain.AppPath + @"\Attendence\Reports\rptLeaveList.rdlc"; SQLQuery = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'FirstML'"; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "LastML".ToUpper()) { ReportPath = Common.Classes.clsMain.AppPath + @"\Attendence\Reports\rptLeaveList.rdlc"; SQLQuery = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'LastML'"; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "Details".ToUpper()) { ReportPath = Common.Classes.clsMain.AppPath + @"\Attendence\Reports\rptLeaveDetails.rdlc"; SQLQuery = "Exec rptLeaveBalance " + Common.Classes.clsMain.intComId + ", '" + cboFinyear.Value.ToString() + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'Details'"; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "Summary".ToUpper()) { ReportPath = Common.Classes.clsMain.AppPath + @"\Attendence\Reports\rptLeaveSum.rdlc"; SQLQuery = "Exec rptLeaveBalance " + Common.Classes.clsMain.intComId + ", " + cboFinyear.Value.ToString() + ",'" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "','Summary'"; } else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "MonthDetails".ToUpper()) { ReportPath = Common.Classes.clsMain.AppPath + @"\Attendence\Reports\rptLeaveMonthDetails.rdlc"; SQLQuery = "Exec rptLeaveBalanceDetails " + Common.Classes.clsMain.intComId + ", " + cboFinyear.Value.ToString() + ",'" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'MonthDetails'"; } clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery); if (dsDetails.Tables[0].Rows.Count == 0) { MessageBox.Show("Data Not Found"); return; } clsReport.strReportPathMain = ReportPath; clsReport.dsReport = dsDetails; clsReport.strDSNMain = DataSourceName; Common.Classes.clsMain.strExtension = optFormat.Value.ToString(); Common.Classes.clsMain.strFormat = optFormat.Text.ToString(); FM.prcShowReport(FormCaption); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void GetBy(HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TKeys keys, ref System.Data.DataSet dataSet) { try { _dataObject.SelectByPrimaryKey(keys, ref dataSet); } catch (System.Exception ex) { throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this); } }
/// <summary> /// Executes the query. /// </summary> /// <param name="dataTable">The data table to return containing the data.</param> /// <param name="queryText">The query text to execute.</param> /// <param name="commandType">The command type.</param> /// <param name="connectionString">The connection string to use.</param> /// <param name="getSchemaTable">Get the table schema from the database and then load the data. Used when /// returning data from the database for a particilar table.</param> /// <param name="values">The collection of sql parameters to include.</param> /// <returns>The sql command containing any return values.</returns> public DbCommand ExecuteQuery(ref DataTable dataTable, string queryText, CommandType commandType, string connectionString, bool getSchemaTable, params DbParameter[] values) { // Initial connection objects. DbCommand dbCommand = null; OracleClient.OracleConnection orlConnection = null; IDataReader dataReader = null; try { // Create a new connection. using (orlConnection = new OracleClient.OracleConnection(connectionString)) { // Open the connection. orlConnection.Open(); // Create the command and assign any parameters. dbCommand = new OracleClient.OracleCommand(DataTypeConversion.GetSqlConversionDataTypeNoContainer( ConnectionContext.ConnectionDataType.OracleDataType, queryText), orlConnection); dbCommand.CommandType = commandType; if (values != null) { foreach (OracleClient.OracleParameter sqlParameter in values) { dbCommand.Parameters.Add(sqlParameter); } } // Load the data into the table. using (dataReader = dbCommand.ExecuteReader()) { // Get the schema from the data because the // table has not predefined schema if (getSchemaTable) { // Load the table after the schema is // returned. dataTable = dataReader.GetSchemaTable(); dataTable = new DataTable(); System.Data.DataSet localDataSet = new System.Data.DataSet(); localDataSet.EnforceConstraints = false; localDataSet.Tables.Add(dataTable); dataTable.Load(dataReader); } else { // Load the data into a table schema. // Load the data into a table schema. System.Data.DataSet localDataSet = new System.Data.DataSet(); localDataSet.EnforceConstraints = false; localDataSet.Tables.Add(dataTable); dataTable.Load(dataReader); } dataReader.Close(); } // Close the database connection. orlConnection.Close(); } // Return the sql command, including // any parameters that have been // marked as output direction. return(dbCommand); } catch (Exception ex) { // Throw a general exception. throw new Exception(ex.Message, ex.InnerException); } finally { if (dataReader != null) { dataReader.Close(); } if (orlConnection != null) { orlConnection.Close(); } } }
/// <summary> /// Executes the query. /// </summary> /// <typeparam name="TypeDataTable">The data type to examine.</typeparam> /// <param name="dataTable">The data table to return containing the data.</param> /// <param name="queryText">The query text to execute.</param> /// <param name="commandType">The command type.</param> /// <param name="connectionString">The connection string to use.</param> /// <param name="values">The collection of sql parameters to include.</param> /// <returns>The sql command containing any return values.</returns> public DbCommand ExecuteClientQuery <TypeDataTable>(ref TypeDataTable dataTable, string queryText, CommandType commandType, string connectionString, params DbParameter[] values) where TypeDataTable : DataTable, new() { // Initial connection objects. OracleClient.OracleCommand sqlCommand = null; OracleClient.OracleConnection connection = null; IDataReader dataReader = null; dataTable = new TypeDataTable(); try { // Create a new connection. using (connection = new OracleClient.OracleConnection(connectionString)) { // Open the connection. connection.Open(); // Create the command and assign any parameters. sqlCommand = new OracleClient.OracleCommand(queryText, connection); sqlCommand.CommandType = commandType; if (values != null) { foreach (OracleClient.OracleParameter sqlParameter in values) { sqlCommand.Parameters.Add(sqlParameter); } } // Load the data into the table. using (dataReader = sqlCommand.ExecuteReader()) { System.Data.DataSet localDataSet = new System.Data.DataSet(); localDataSet.EnforceConstraints = false; localDataSet.Tables.Add(dataTable); dataTable.Load(dataReader); dataReader.Close(); } // Close the database connection. connection.Close(); } // Return the sql command, including // any parameters that have been // marked as output direction. return(sqlCommand); } catch (Exception ex) { // Throw a general exception. throw new Exception(ex.Message, ex.InnerException); } finally { if (dataReader != null) { dataReader.Close(); } if (connection != null) { connection.Close(); } } }
void btnPreview_Click(object sender, EventArgs e) { string criteria = string.Empty; if (string.IsNullOrEmpty(radioGroup1.EditValue.ToString())) { Common.setMessageBox("Search Criteria Option not Selected....!", Program.ApplicationName, 2); return; } else { try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); if (boolIsUpdate) { //exception report if ((Int32)this.radioGroup1.EditValue == 0) { criteria = string.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber , DepositSlipNumber , PaymentDate , [PayerID] , UPPER(PayerName) AS PayerName ,AgencyName , Description , Amount ,BankName + ',' + BranchName AS Bank , Collection.tblCollectionReport.EReceipts ,Collection.tblCollectionReport.StationCode ,( SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName FROM Collection.tblCollectionReport WHERE Collection.tblCollectionReport.EReceiptsDate >='{0}' And Collection.tblCollectionReport.EReceiptsDate <= '{1}' AND RevenueCode IN ( SELECT RevenueCode FROM Receipt.tblRevenueReceiptException ) ORDER BY Collection.tblCollectionReport.AgencyName , Collection.tblCollectionReport.Description , Collection.tblCollectionReport.EReceipts", string.Format("{0:MM/dd/yyyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 1) { criteria = string.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber , DepositSlipNumber , PaymentDate , [PayerID] , UPPER(PayerName) AS PayerName ,AgencyName , Description , Amount ,BankName + ',' + BranchName AS Bank , Collection.tblCollectionReport.EReceipts ,Collection.tblCollectionReport.StationCode ,( SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName FROM Collection.tblCollectionReport WHERE Collection.tblCollectionReport.PaymentRefNumber Like '%{0}%' AND RevenueCode IN ( SELECT RevenueCode FROM Receipt.tblRevenueReceiptException ) ORDER BY Collection.tblCollectionReport.AgencyName , Collection.tblCollectionReport.Description , Collection.tblCollectionReport.EReceipts", txtpayRef.Text.Trim()); } } else { //pyment report //groupBox1.Text = "Payment Report"; if ((Int32)this.radioGroup1.EditValue == 0) { criteria = string.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber , DepositSlipNumber , PaymentDate , [PayerID] ,UPPER(PayerName) AS PayerName , AgencyName , Description , Amount , BankName + ',' + BranchName AS Bank , Collection.tblCollectionReport.EReceipts , ControlNumber , ControlNumberBy , ControlNumberDate , PrintedBY , Collection.tblCollectionReport.StationCode , ( SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Receipt.tblCollectionReceipt.PaymentRefNumber = Collection.tblCollectionReport.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceiptsDate >='{0}' And Collection.tblCollectionReport.EReceiptsDate <= '{1}' ORDER BY Collection.tblCollectionReport.AgencyName , Collection.tblCollectionReport.Description , Collection.tblCollectionReport.EReceipts", string.Format("{0:MM/dd/yyyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 1) { criteria = string.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber , DepositSlipNumber , PaymentDate , [PayerID] ,UPPER(PayerName) AS PayerName , AgencyName , Description , Amount , BankName + ',' + BranchName AS Bank , Collection.tblCollectionReport.EReceipts , ControlNumber , ControlNumberBy , ControlNumberDate , PrintedBY , Collection.tblCollectionReport.StationCode , ( SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Receipt.tblCollectionReceipt.PaymentRefNumber = Collection.tblCollectionReport.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber Like '%{0}%' ORDER BY Collection.tblCollectionReport.AgencyName , Collection.tblCollectionReport.Description , Collection.tblCollectionReport.EReceipts", txtpayRef.Text.Trim()); } } using (var ds = new System.Data.DataSet()) { ds.Clear(); using (SqlDataAdapter ada = new SqlDataAdapter(criteria, Logic.ConnectionString)) { ada.Fill(ds, "table"); } if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { if (boolIsUpdate) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { ////using object class var listexpection = (from DataRow row in ds.Tables[0].Rows select new DataSet.Reports { PaymentRefNumber = row["PaymentRefNumber"] as string, DepositSlipNumber = row["DepositSlipNumber"] as string, PaymentDate = Convert.ToDateTime(row["PaymentDate"]), PayerID = row["PayerID"] as string, PayerName = row["PayerName"] as string, AgencyName = row["AgencyName"] as string, Description = row["Description"] as string, Amount = Convert.ToDecimal(row["Amount"]), Bank = row["Bank"] as string, EReceipts = row["EReceipts"] as string, StationCode = row["StationCode"] as string, StationName = row["StationName"] as string } ).ToList(); XtraRepExecptionReport report = new XtraRepExecptionReport(); var bindsoucre = (BindingSource)report.DataSource; bindsoucre.Clear(); bindsoucre.DataSource = listexpection; report.xrLabel12.Text = string.Format("{0} State Government", Program.StateName.ToUpper()); report.xrLabel13.Text = string.Format("List of Revenue Receipts Exception between {0} and {1}", string.Format("{0:dd/MM/yyyy}", dtpDate.Value), string.Format("{0:dd/MM/yyyy}", dtpenddate.Value)); report.ShowPreviewDialog(); } else { Common.setMessageBox("No Record Found", Program.ApplicationName, 1); return; } } else { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { var list = (from DataRow rows in ds.Tables[0].Rows select new DataSet.Reports2 { PaymentRefNumber = rows["PaymentRefNumber"] as string , DepositSlipNumber = rows["DepositSlipNumber"] as string, PaymentDate = Convert.ToDateTime(rows["PaymentDate"]), PayerID = rows["PayerID"] as string, PayerName = rows["PayerName"] as string, AgencyName = rows["AgencyName"] as string, Description = rows["Description"] as string , Amount = Convert.ToDecimal(rows["Amount"]), Bank = rows["Bank"] as string, EReceipts = rows["EReceipts"] as string, StationCode = rows["StationCode"] as string, StationName = rows["StationName"] as string, ControlNumber = rows["ControlNumber"] as string, //ControlNumberDate = Convert.ToDateTime(rows["ControlNumberDate"]), PrintedBY = rows["PrintedBY"] as string } ).ToList(); XtraRepPayments report = new XtraRepPayments(); var bindsoucre = (BindingSource)report.DataSource; bindsoucre.Clear(); bindsoucre.DataSource = list; report.xrLabel12.Text = string.Format("{0} State Government", Program.StateName.ToUpper()); report.xrLabel13.Text = string.Format("List of Payment Collections Reports between {0} and {1}", string.Format("{0:dd/MM/yyyy}", dtpDate.Value), string.Format("{0:dd/MM/yyyy}", dtpenddate.Value)); report.ShowPreviewDialog(); } else { Common.setMessageBox("No Record Found", Program.ApplicationName, 1); return; } } } else { Common.setMessageBox("No Record Found", Program.ApplicationName, 1); return; } } } finally { SplashScreenManager.CloseForm(false); } } }
protected override void GenerateWorkbookDetail(NPOI.HSSF.UserModel.HSSFWorkbook workBook, System.Data.DataSet dataSet) { NPOI.HSSF.UserModel.HSSFSheet workSheet = (NPOI.HSSF.UserModel.HSSFSheet)workBook.CreateSheet("Payroll Detail"); ushort rowPos = 0; DataTable empInfoTable = dataSet.Tables["EmpInfo"]; DataTable paymentTable = dataSet.Tables["payment"]; DataTable costCenterDetailTable = dataSet.Tables["CostCenterDetail"]; NPOI.HSSF.UserModel.HSSFFont boldFont = (NPOI.HSSF.UserModel.HSSFFont)workBook.CreateFont(); boldFont.Boldweight = 700; NPOI.HSSF.UserModel.HSSFCellStyle reportHeaderStyle = (NPOI.HSSF.UserModel.HSSFCellStyle)workBook.CreateCellStyle(); reportHeaderStyle.SetFont(boldFont); reportHeaderStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.CENTER; NPOI.HSSF.UserModel.HSSFCellStyle groupHeaderStyle = (NPOI.HSSF.UserModel.HSSFCellStyle)workBook.CreateCellStyle(); groupHeaderStyle.SetFont(boldFont); NPOI.HSSF.UserModel.HSSFCellStyle columnHeaderStyle = (NPOI.HSSF.UserModel.HSSFCellStyle)workBook.CreateCellStyle(); columnHeaderStyle.SetFont(boldFont); columnHeaderStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.THIN; NPOI.HSSF.UserModel.HSSFCellStyle detailStyle = (NPOI.HSSF.UserModel.HSSFCellStyle)workBook.CreateCellStyle(); detailStyle.DataFormat = workBook.CreateDataFormat().GetFormat("#,##0.00;(#,##0.00)"); NPOI.HSSF.UserModel.HSSFCellStyle subTotalStyle = (NPOI.HSSF.UserModel.HSSFCellStyle)workBook.CreateCellStyle(); subTotalStyle.DataFormat = workBook.CreateDataFormat().GetFormat("#,##0.00;(#,##0.00)"); subTotalStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.THIN; //rowPos = GenerateHeader(xlsDoc, workSheet, PeriodFrom, PeriodTo, rowPos); rowPos = GenerateHeader(workSheet, PeriodFrom, PeriodTo, rowPos, reportHeaderStyle, groupHeaderStyle); DataRow[] rows = dataSet.Tables["EmpInfo"].Select("", "Company, " + empInfoTable.Columns[hierarchyLevelGroupingFieldName].ColumnName + ", Employee Name, Alias"); string currentCompany = string.Empty; string currentHierarchyGroup = string.Empty; string currentEmployeeNo = string.Empty; ushort groupRowCount = 0; Hashtable groupedTotalCostCenterHash = new Hashtable(); ArrayList subTotalRowList = new ArrayList(); Hashtable paymentHashTable = new Hashtable(); Hashtable companyTotalHashTable = new Hashtable(); double netPayment = 0; double companyNetPayment = 0; double employerContribution = 0; double companyEmployerContribution = 0; ArrayList companyTotalRowNumList = new ArrayList(); foreach (DataRow row in rows) { string tmpCompany = row["Company"].ToString(); string tmpHierarchy = row[hierarchyLevelGroupingFieldName].ToString(); string tmpEmployeeNo = row["Employee No."].ToString(); if (!currentCompany.Equals(tmpCompany, StringComparison.CurrentCultureIgnoreCase) || rows[0] == row) { if (rows[0] != row) { groupRowCount++; rowPos = GenerateHierarchyTotal(workSheet, paymentTable, currentHierarchyGroup, currentEmployeeNo, paymentHashTable, netPayment, employerContribution, rowPos, detailStyle); paymentHashTable = new Hashtable(); rowPos = GenerateCompanyTotal(workSheet, paymentTable, groupRowCount, companyEmployerContribution, rowPos, subTotalStyle); companyTotalRowNumList.Add(rowPos); companyTotalHashTable = new Hashtable(); } groupRowCount = 0; netPayment = 0; employerContribution = 0; currentHierarchyGroup = tmpHierarchy; currentEmployeeNo = tmpEmployeeNo; companyNetPayment = 0; companyEmployerContribution = 0; currentCompany = tmpCompany; rowPos = GenerateColumnHeader(workSheet, dataSet, currentCompany, hierarchyLevelGroupingFieldName, rowPos, groupHeaderStyle, columnHeaderStyle); } else if (!currentHierarchyGroup.Equals(tmpHierarchy, StringComparison.CurrentCultureIgnoreCase)) { groupRowCount++; rowPos = GenerateHierarchyTotal(workSheet, paymentTable, currentHierarchyGroup, currentEmployeeNo, paymentHashTable, netPayment, employerContribution, rowPos, detailStyle); paymentHashTable = new Hashtable(); netPayment = 0; employerContribution = 0; currentHierarchyGroup = tmpHierarchy; currentEmployeeNo = tmpEmployeeNo; } DataRow[] paymentRows = paymentTable.Select("[EmpPayrollID]='" + row["EmpPayrollID"].ToString() + "'"); foreach (DataRow paymentRow in paymentRows) { foreach (DataColumn column in paymentTable.Columns) { if (column.ColumnName.Equals("EmpPayrollID")) { continue; } double amount = 0; double companyTotalAmount = 0; if (paymentHashTable.ContainsKey(column.ColumnName)) { amount = (double)paymentHashTable[column.ColumnName]; } else { paymentHashTable.Add(column.ColumnName, amount); } if (companyTotalHashTable.ContainsKey(column.ColumnName)) { companyTotalAmount = (double)companyTotalHashTable[column.ColumnName]; } else { companyTotalHashTable.Add(column.ColumnName, companyTotalAmount); } if (!string.IsNullOrEmpty(paymentRow[column.ColumnName].ToString())) { amount += (double)paymentRow[column.ColumnName]; companyTotalAmount += (double)paymentRow[column.ColumnName]; netPayment += (double)paymentRow[column.ColumnName]; companyNetPayment += (double)paymentRow[column.ColumnName]; paymentHashTable[column.ColumnName] = amount; companyTotalHashTable[column.ColumnName] = companyTotalAmount; } } } if (!row.IsNull("MCER")) { double contribution = (double)row["MCER"]; employerContribution += contribution; companyEmployerContribution += contribution; } if (!row.IsNull("VCER")) { double contribution = (double)row["VCER"]; employerContribution += contribution; companyEmployerContribution += contribution; } if (!row.IsNull("PFundER")) { double contribution = (double)row["PFundER"]; employerContribution += contribution; companyEmployerContribution += contribution; } } if (paymentHashTable.Count > 0) { groupRowCount++; rowPos = GenerateHierarchyTotal(workSheet, paymentTable, currentHierarchyGroup, currentEmployeeNo, paymentHashTable, netPayment, employerContribution, rowPos, detailStyle); paymentHashTable = new Hashtable(); netPayment = 0; employerContribution = 0; } if (groupRowCount > 0) { rowPos = GenerateCompanyTotal(workSheet, paymentTable, groupRowCount, companyEmployerContribution, rowPos, subTotalStyle); companyTotalRowNumList.Add(rowPos); } if (companyTotalRowNumList.Count > 0) { rowPos = GenerateTotal(workSheet, paymentTable, companyTotalRowNumList, rowPos, subTotalStyle); } //workSheet.Cells.Merge(1, 1, 1, paymentTable.Columns.Count + 2); //workSheet.Rows[1].GetCell(1).Font.Bold = true; //workSheet.Rows[1].GetCell(1).Font.Height = 300; //workSheet.Rows[1].GetCell(1).HorizontalAlignment = org.in2bits.MyXls.HorizontalAlignments.Centered; workSheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, paymentTable.Columns.Count + 1)); // checking the number of column to resize for better user view int resizeColumn = paymentTable.Columns.Count + 1; if (intHierarchyLevelID == STAFF_LEVEL_ID) { resizeColumn++; } for (int i = 0; i <= resizeColumn; i++) { //org.in2bits.MyXls.ColumnInfo columnInfo = new org.in2bits.MyXls.ColumnInfo(xlsDoc, workSheet); //workSheet.AddColumnInfo(columnInfo); //columnInfo.ColumnIndexStart = 0; //columnInfo.ColumnIndexEnd = (ushort)(paymentTable.Columns.Count + 2); //columnInfo.Width = 15 * 254; //columnInfo.Collapsed = true; workSheet.SetColumnWidth(i, 15 * 254); } }
protected override void DoRecuperaRegistroDialog(System.Data.DataSet dataSet, object[] pk) { string sql = @"SELECT * FROM DRAtividade(NOLOCK) WHERE CODIGOPRJ =@1 AND CodAtividade =@2 AND CodEtapa =@3"; DBCon.Fill(dataSet.Tables["DRAtividade"], sql, pk); }
void douser() { DataSet dt = new DataSet(); Guid userGuid = System.Guid.NewGuid(); string strpass = "******"; string hashedPassword = Security.HashSHA1(strpass.ToString() + userGuid.ToString()); SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet response = new System.Data.DataSet(); using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString)) { if (connect.State != ConnectionState.Closed) { connect.Close(); } connect.Open(); _command = new SqlCommand("doInsertnewuser", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@merchantcode", SqlDbType.VarChar)).Value = (string)ViewState["MMerchantCode"];//ddlState.SelectedValue; _command.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar)).Value = txtlast.Value.Trim(); _command.Parameters.Add(new SqlParameter("@firstname", SqlDbType.VarChar)).Value = txtfirst.Value.Trim(); _command.Parameters.Add(new SqlParameter("@email", SqlDbType.VarChar)).Value = txtemail.Value.Trim(); _command.Parameters.Add(new SqlParameter("@PasswordHas", SqlDbType.VarChar)).Value = hashedPassword; _command.Parameters.Add(new SqlParameter("@UserGuid", SqlDbType.UniqueIdentifier)).Value = userGuid; _command.CommandTimeout = 0; response.Clear(); _adp = new SqlDataAdapter(_command); _adp.Fill(response); connect.Close(); if (response.Tables[0].Rows[0]["returnCode"].ToString() == "00") { //send email SendLoginMail(txtemail.Value.ToString()); //display error message string strmess = "Kindly check provide mail for confirmation"; Response.Write("<script language='javascript'>alert('" + Server.HtmlEncode(response.Tables[0].Rows[0]["returnMessage"].ToString()) + "')</script>"); Response.Write("<script language='javascript'>alert('" + Server.HtmlEncode(strmess.ToString()) + "')</script>"); lblerror.Text = response.Tables[0].Rows[0]["returnMessage"].ToString(); lblerror.Visible = true; } else { //display error message Response.Write("<script language='javascript'>alert('" + Server.HtmlEncode(response.Tables[0].Rows[0]["returnMessage"].ToString()) + "')</script>"); lblerror.Text = response.Tables[0].Rows[0]["returnMessage"].ToString(); lblerror.Visible = true; } } }
protected override void DoCriaDataSet(out System.Data.DataSet dataSet) { dataSet = new DSCadastro(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["AppLocation"] == null || Session.Count == 0 || Session["AppUserID"].ToString() == "") { IQCareMsgBox.Show("SessionExpired", this); Response.Redirect("~/frmlogin.aspx", true); } //(Master.FindControl("levelOneNavigationUserControl1").FindControl("lblRoot") as Label).Text = "Clinical Forms >> "; //(Master.FindControl("levelOneNavigationUserControl1").FindControl("lblheader") as Label).Text = "Patient History"; //(Master.FindControl("levelTwoNavigationUserControl1").FindControl("lblformname") as Label).Text = "Existing Forms"; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("lblpntStatus") as Label).Text = (Session["PatientStatus"] != null) ? Convert.ToString(Session["PatientStatus"]) : Convert.ToString(Request.QueryString["sts"]); #region "Refresh Patient Records" IPatientHome PManager; PManager = (IPatientHome)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientHome, BusinessProcess.Clinical"); System.Data.DataSet thePDS = PManager.GetPatientDetails(Convert.ToInt32(Session["PatientId"]), Convert.ToInt32(Session["SystemId"]), Convert.ToInt32(Session["TechnicalAreaId"])); //System.Data.DataSet thePDS = PManager.GetPatientDetails(Convert.ToInt32(Request.QueryString["PatientId"]), Convert.ToInt32(Session["SystemId"])); Session["PatientInformation"] = thePDS.Tables[0]; #endregion IPatientHome PatientManager; PatientManager = (IPatientHome)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientHome, BusinessProcess.Clinical"); try { if (!IsPostBack) { IFacilitySetup FacilityMaster = (IFacilitySetup)ObjectFactory.CreateInstance("BusinessProcess.Administration.BFacility, BusinessProcess.Administration"); //theFacilityDS = FacilityMaster.GetFacilityList(Convert.ToInt32(Session["SystemId"]), 1001); //theFacilityDS = FacilityMaster.GetSystemBasedLabels(Convert.ToInt32(Session["SystemId"]), 1001, 0); //ViewState["FacilityDS"] = theFacilityDS; //SetPageLabels(); //******************************************************// if (Session["PatientId"] == null || Convert.ToString(Session["PatientId"]) == "0") { Session["PatientId"] = Request.QueryString["PatientId"]; //remove it after session of patient set on find add when patient selected from grid. } PId = Convert.ToString(Session["PatientId"]); PtnSts = Convert.ToString(Session["PatientStatus"]); //Request.QueryString["sts"].ToString(); if (Session["PatientId"] != null && Convert.ToInt32(Session["PatientId"]) != 0) { PId = Session["PatientId"].ToString(); } if (Session["PatientStatus"] != null) { PtnSts = Session["PatientStatus"].ToString(); } DataSet theDS = PatientManager.GetPatientHistory(Convert.ToInt32(PId)); ViewState["theCFDT"] = theDS.Tables[3].Copy(); Session["FormStatus"] = "Pending"; FormIQCare(theDS); if (Session["TechnicalAreaName"].ToString() == "ART Clinic") { ucCCCMenu1.Visible = true; } else { ucCCCMenu1.Visible = false; } } } catch (Exception err) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = err.Message.ToString(); IQCareMsgBox.Show("#C1", theBuilder, this); return; } finally { PatientManager = null; } }
protected override void DoSalvaRegistro(System.Data.DataSet dataSet) { }
/// <remarks/> public void ImportarDatosTablasDSAsync(int idDocumento, string strNombreDocumento, int idCompania, string strCompania, string strUsuario, string strClave, System.Data.DataSet dsFuenteDatos, string tsProceso, string Path, object userState) { if ((this.ImportarDatosTablasDSOperationCompleted == null)) { this.ImportarDatosTablasDSOperationCompleted = new System.Threading.SendOrPostCallback(this.OnImportarDatosTablasDSOperationCompleted); } this.InvokeAsync("ImportarDatosTablasDS", new object[] { idDocumento, strNombreDocumento, idCompania, strCompania, strUsuario, strClave, dsFuenteDatos, tsProceso, Path }, this.ImportarDatosTablasDSOperationCompleted, userState); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["ref"] == null) { Response.Redirect("./moncomptetableaudebord_bis.aspx"); } Membre member = (Membre)Session["Membre"]; if (member != null && (member.STATUT != "nego" || member.STATUT != "ultranego")) { } else { Response.Redirect("./moncomptetableaudebord_bis.aspx"); } isAdmin = (member.STATUT == "ultranego"); Connexion c = new Connexion(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); c.Open(); try { bien = c.exeRequetteOpen("SELECT * FROM Biens WHERE ref='" + Request.QueryString["ref"] + "'").Tables[0].Rows[0]; } catch { Response.Redirect("./moncomptetableaudebord_bis.aspx"); c.Close(); } if (!IsPostBack) { int idNego = (int)bien["idclient"]; int honoraire = (int)bien["honoraires"]; int prix = (int)bien["prix de vente"]; ((Label)Page.Master.FindControl("titrebandeau")).Text = "Proposer vente"; //refBien.Text = Request.QueryString["ref"]; TextBoxHonoraires.Text = honoraire.ToString(); TextBoxPrix.Text = prix.ToString(); TextBoxSequestre.Text = ((int)(int.Parse(TextBoxPrix.Text) * 5 / 100)).ToString(); string codeiso = Code_iso("negomandat"); DataRow negoMandat = c.exeRequetteOpen("SELECT Clients.* FROM Clients,Biens WHERE Biens.idclient = Clients.idclient AND Biens.ref = '" + Request.QueryString["ref"] + "'").Tables[0].Rows[0]; nego.Text = negoMandat["prenom_client"].ToString() + " " + negoMandat["nom_client"].ToString().ToUpper(); negoadresse.Text = "<img height='20px' src='../img_site/drapeau/" + codeiso + ".png'/>" + "<div class='tooltip'><span>" + "<img height='50px' src='../img_site/drapeau/" + codeiso + ".png'/></span></div>" + " " + "<a href='https://www.google.fr/maps/place/" + negoMandat["adresse_client"] + " " + negoMandat["ville_client"].ToString() + "' target='_blank'><img style='cursor:pointer' src='../img_site/flat_round/monde.png' height='20px'/></a>" + " " + negoMandat["adresse_client"].ToString() + "<br/>" + " " + negoMandat["postal_client"].ToString() + ", " + negoMandat["ville_client"].ToString(); negoTel.Text = negoMandat["tel_client"].ToString(); negoMail.Text = "<a href='mailto:" + negoMandat["id_client"] + "'>" + negoMandat["id_client"] + "</a>"; string temp = DropDownListAcq.SelectedValue; string temp2 = DropDownListNotaire.SelectedValue; string req; string req2; if (member.STATUT == "ultranego") { req = "SELECT id_acq,nom,prenom,tel,mail,code_postal,ville,idclient,adresse,pays FROM Acquereurs WHERE actif='actif' ORDER BY Nom ASC"; req2 = "SELECT id_notaire,nom,prenom,adresse,code_postal,ville,mail,telephone,pays,fax FROM Notaires ORDER BY Nom ASC"; } else { req = "SELECT id_acq,nom,prenom,tel,mail,code_postal,ville,idclient,adresse,pays FROM Acquereurs WHERE actif='actif' AND idclient = " + member.IDCLIENT + " ORDER BY Nom ASC"; req2 = "SELECT Notaires.id_notaire,nom,prenom,adresse,code_postal,ville,mail,telephone,pays,fax FROM Notaires INNER JOIN lien_clients_notaires ON lien_clients_notaires.id_notaire=Notaires.id_notaire WHERE lien_clients_notaires.id_client = " + member.IDCLIENT + " ORDER BY Nom ASC"; } DataRowCollection listeAcquereur = c.exeRequetteOpen(req).Tables[0].Rows; foreach (DataRow acq in listeAcquereur) { string nomnegoacq = null, prenomnegoacq = null; string idacq = acq["id_acq"].ToString(); req = "SELECT Clients.nom_client, Clients.prenom_client FROM Acquereurs INNER JOIN Clients ON Acquereurs.idclient = Clients.idclient WHERE ((Acquereurs.id_acq)=" + idacq + ")"; OdbcConnection connect = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OdbcCommand requet = new OdbcCommand(req, connect); connect.Open(); OdbcDataReader read = requet.ExecuteReader(); while (read.Read()) { nomnegoacq = read["nom_client"].ToString().ToUpper(); prenomnegoacq = read["prenom_client"].ToString(); } connect.Close(); ListItem x = new ListItem(acq["nom"].ToString().ToUpper() + " " + acq["prenom"].ToString() + " (" + acq["ville"].ToString() + " - " + acq["code_postal"].ToString() + ") | négo associé: " + nomnegoacq + " " + prenomnegoacq); x.Attributes["tel"] = acq["tel"].ToString(); x.Attributes["mail"] = acq["mail"].ToString(); x.Attributes["idclient"] = acq["idclient"].ToString(); x.Attributes["nom"] = acq["nom"].ToString().ToUpper(); x.Attributes["prenom"] = acq["prenom"].ToString(); x.Attributes["adresse"] = acq["adresse"].ToString(); x.Attributes["ville"] = acq["ville"].ToString(); x.Attributes["code_postal"] = acq["code_postal"].ToString(); x.Attributes["pays"] = acq["pays"].ToString().ToUpper(); x.Value = acq["id_acq"].ToString(); req = "SELECT Pays.codeiso FROM Pays WHERE ((Pays.Titre_Pays)='" + acq["pays"].ToString() + "')"; OdbcConnection connection = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OdbcCommand requette = new OdbcCommand(req, connection); connection.Open(); OdbcDataReader reader = requette.ExecuteReader(); reader.Read(); x.Attributes["codeiso"] = reader["codeiso"].ToString(); connection.Close(); DropDownListAcq.Items.Add(x); } if (Request.QueryString["acq"] != null) { DropDownListAcq.SelectedValue = Request.QueryString["acq"]; nomacquereur.Text = DropDownListAcq.SelectedItem.Attributes["nom"] + " " + DropDownListAcq.SelectedItem.Attributes["prenom"]; } InformationNegoAcquereur(); DataRowCollection listeNotaire = c.exeRequetteOpen(req2).Tables[0].Rows; foreach (DataRow not in listeNotaire) { ListItem y = new ListItem(not["nom"].ToString().ToUpper() + ", " + not["prenom"].ToString() + " (" + not["ville"].ToString() + " - " + not["code_postal"].ToString() + ")", not["id_notaire"].ToString()); y.Attributes["nom"] = not["nom"].ToString().ToUpper(); y.Attributes["prenom"] = not["prenom"].ToString(); y.Attributes["adresse"] = not["adresse"].ToString(); y.Attributes["code_postal"] = not["code_postal"].ToString(); y.Attributes["ville"] = not["ville"].ToString(); y.Attributes["mail"] = not["mail"].ToString(); y.Attributes["telephone"] = not["telephone"].ToString(); y.Attributes["pays"] = not["pays"].ToString().ToUpper(); y.Attributes["fax"] = not["fax"].ToString(); y.Attributes["id_notaire"] = not["id_notaire"].ToString(); if (not["pays"].ToString() != "") { req = "SELECT Pays.codeiso FROM Pays WHERE ((Pays.Titre_Pays)='" + not["pays"].ToString() + "')"; // OdbcConnection connection = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OdbcCommand requette = new OdbcCommand(req, connection); connection.Open(); OdbcDataReader reader = requette.ExecuteReader(); reader.Read(); y.Attributes["codeiso"] = reader["codeiso"].ToString(); connection.Close(); } DropDownListNotaire.Items.Add(y); } DropDownListNotaire.SelectedValue = temp2; if (Request.QueryString["id"] != null) //Consultation d'une fiche vente { System.Data.DataSet ds2 = c.exeRequetteOpen("Select * from Environnement"); String racine_site = (String)ds2.Tables[0].Rows[0]["Chemin_racine_site"]; string filePathActe = racine_site + "Ventes\\" + Request.QueryString["id"] + "_acte.pdf"; string filePathPromesse = racine_site + "Ventes\\" + Request.QueryString["id"] + "_promesse.pdf"; if (System.IO.File.Exists(filePathPromesse)) { oldPromesse.Text = "<span id='newPromesse'><a href='../Ventes/" + Request.QueryString["id"] + "_promesse.pdf' target='_blank'>Voir Fichier</a></span>"; filePromesse.Attributes["style"] += ";width: 140px;color:white;"; } if (System.IO.File.Exists(filePathActe)) { oldActe.Text = "<span id='newActe'><a href='../Ventes/" + Request.QueryString["id"] + "_acte.pdf' target='_blank'>Voir Fichier</a></span>"; fileActe.Attributes["style"] += ";width: 140px;color:white;"; } string val = ""; if (Request.QueryString["id"] != null) { val = Request.QueryString["id"]; } else if (Request.QueryString["acq"] != null) { val = Request.QueryString["acq"]; } DataRow vente = c.exeRequetteOpen("SELECT * FROM Ventes WHERE ID =" + val).Tables[0].Rows[0]; bool venteValidee = (bool)vente["valider_signature"]; DropDownListAcq.SelectedValue = vente["id_acquereur"].ToString(); ratioNegoMandat.Text = ((double)vente["taux_mandat"] * 100).ToString(); ratioNegoVente.Text = ((double)vente["taux_vente"] * 100).ToString(); TextBoxPrix.Text = vente["prix_vente"].ToString(); TextBoxSequestre.Text = vente["sequestre"].ToString(); TextBoxHonoraires.Text = vente["commission"].ToString(); // il faudrait plutot recuperer les infos du notaire dans la table notaire .. notaireNom.Text = vente["nom_notaire"].ToString(); notairePrenom.Text = vente["prenom_notaire"].ToString(); notaireAdresse.Text = vente["adresse_notaire"].ToString(); notaireCPetville.Text = vente["cp_notaire"].ToString() + ", " + vente["ville_notaire"].ToString(); notaireTel.Text = vente["tel_notaire"].ToString(); notaireMail.Text = vente["mail_notaire"].ToString(); TextBoxDateCompromis.Text = vente["date_compromis"].ToString().Split(' ')[0]; TextBoxDateSignature.Text = vente["date_signature"].ToString().Split(' ')[0]; int idNegoMandataire = (int)vente["id_nego"]; int idNegoVente = (int)c.exeRequetteOpen("SELECT idclient FROM Acquereurs WHERE id_acq = " + vente["id_acquereur"].ToString()).Tables[0].Rows[0]["idclient"]; saveVente.Visible = false; if ((!venteValidee && member.IDCLIENT == idNegoMandataire) || (!venteValidee && member.IDCLIENT == idNegoVente) || member.STATUT == "ultranego") { updateVente.Visible = true; } else { edit = false; if (venteValidee) { msg.Text = "Vente validée, aucune modification possible.<br/>"; } } } c.Close(); remplirTableauBien(Request.QueryString["ref"]); } }
void btnSelect_Click(object sender, EventArgs e) { try { switch (Program.intCode) { case 13: //Akwa Ibom state if ((Int32)this.radioGroup1.EditValue == 1) { //and ([EReceiptsDate] BETWEEN '{1} 00:00:00' AND '{1} 23:59:59') criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceipts LIKE '%{0}%'", txtSearch.Text.Trim()); } else if ((Int32)this.radioGroup1.EditValue == 2) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber LIKE '%{0}%'", txtSearch.Text.Trim()); } else if ((Int32)this.radioGroup1.EditValue == 3) { //this.label1.Text = "Payer Name"; criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Receipt.tblCollectionReceipt.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport left JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PayerName Like '%{0}%'", txtSearch.Text.Trim()); } else if ((Int32)this.radioGroup1.EditValue == 4) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE DepositSlipNumber Like '%{0}%'", txtSearch.Text.Trim()); } break; case 20: //detla state if ((Int32)this.radioGroup1.EditValue == 1) { //and ([EReceiptsDate] BETWEEN '{1} 00:00:00' AND '{1} 23:59:59') criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,Collection.tblCollectionReport.ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceipts LIKE '%{0}%' and Collection.tblCollectionReport.PaymentDate >= '{1}' And Collection.tblCollectionReport.PaymentDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 2) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,Collection.tblCollectionReport.ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber LIKE '%{0}%' And Collection.tblCollectionReport.PaymentDate >= '{1}' And Collection.tblCollectionReport.PaymentDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 3) { //this.label1.Text = "Payer Name"; criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Receipt.tblCollectionReceipt.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,Collection.tblCollectionReport.ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport left JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PayerName Like '%{0}%' and Collection.tblCollectionReport.PaymentDate >= '{1}' And Collection.tblCollectionReport.PaymentDate <= '{2}' ", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 4) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,Collection.tblCollectionReport.ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentDate >= '{0}' And Collection.tblCollectionReport.PaymentDate <= '{1}' AND DepositSlipNumber Like '%{2}%'", string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value), txtSearch.Text.Trim()); } break; case 37: //ogun state if ((Int32)this.radioGroup1.EditValue == 1) { //and ([EReceiptsDate] BETWEEN '{1} 00:00:00' AND '{1} 23:59:59') criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceipts LIKE '%{0}%' and Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 2) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber LIKE '%{0}%' And Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 3) { //this.label1.Text = "Payer Name"; criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Receipt.tblCollectionReceipt.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport left JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PayerName Like '%{0}%' and Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}' ", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 4) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceiptsDate >= '{0}' And Collection.tblCollectionReport.EReceiptsDate <= '{1}' AND DepositSlipNumber Like '%{2}%'", string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value), txtSearch.Text.Trim()); } break; case 40: //oyo state if ((Int32)this.radioGroup1.EditValue == 1) { //and ([EReceiptsDate] BETWEEN '{1} 00:00:00' AND '{1} 23:59:59') criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceipts LIKE '%{0}%' and Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 2) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber LIKE '%{0}%' And Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 3) { //this.label1.Text = "Payer Name"; criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Receipt.tblCollectionReceipt.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport left JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PayerName Like '%{0}%' and Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}' ", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 4) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceiptsDate >= '{0}' And Collection.tblCollectionReport.EReceiptsDate <= '{1}' AND DepositSlipNumber Like '%{2}%'", string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value), txtSearch.Text.Trim()); } break; case 32: //kogi state if ((Int32)this.radioGroup1.EditValue == 1) { //and ([EReceiptsDate] BETWEEN '{1} 00:00:00' AND '{1} 23:59:59') criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceipts LIKE '%{0}%' and Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 2) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber LIKE '%{0}%' And Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}'", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 3) { //this.label1.Text = "Payer Name"; criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Receipt.tblCollectionReceipt.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport left JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PayerName Like '%{0}%' and Collection.tblCollectionReport.EReceiptsDate >= '{1}' And Collection.tblCollectionReport.EReceiptsDate <= '{2}' ", txtSearch.Text.Trim(), string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value)); } else if ((Int32)this.radioGroup1.EditValue == 4) { criteria = String.Format("SELECT Collection.tblCollectionReport.PaymentRefNumber,PayerName,Amount,CONVERT(VARCHAR, CONVERT(DATE, PaymentDate), 103) AS PaymentDate,AgencyName,Description,Collection.tblCollectionReport.EReceipts,CONVERT(VARCHAR, CONVERT(DATE, Receipt.tblCollectionReceipt.EReceiptsDate), 103) AS [Receipts Date],PrintedBY,CONVERT(VARCHAR, CONVERT(DATE, IsPrintedDate), 103) AS DatePrinted,ControlNumber ,Collection.tblCollectionReport.StationCode, ( SELECT StationName FROM Receipt.tblStation WHERE Collection.tblCollectionReport.StationCode = Receipt.tblStation.StationCode ) AS StationName FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.EReceiptsDate >= '{0}' And Collection.tblCollectionReport.EReceiptsDate <= '{1}' AND DepositSlipNumber Like '%{2}%'", string.Format("{0:MM/dd/yyy 00:00:00}", dtpDate.Value), string.Format("{0:MM/dd/yyy 23:59:59}", dtpenddate.Value), txtSearch.Text.Trim()); } break; default: break; } if (radioGroup1.EditValue == null) { Common.setEmptyField("Search Criteria, can't be empty", "Search Receipt"); return; } else { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); using (var ds = new System.Data.DataSet()) { using (SqlDataAdapter ada = new SqlDataAdapter(criteria, Logic.ConnectionString)) { ada.SelectCommand.CommandTimeout = 0; ada.Fill(ds, "table"); } dt = ds.Tables[0]; } if (dt != null && dt.Rows.Count > 0) { //gridControl4.DataSource = dt; gridControl1.DataSource = dt; gridView2.BestFitColumns(); layoutView1.Columns["Amount"].DisplayFormat.FormatType = FormatType.Numeric; layoutView1.Columns["Amount"].DisplayFormat.FormatString = "n2"; //layoutView1. //layoutView1.Columns["Amount"].DisplayFormat.Forma layoutView1.Columns["PaymentDate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; layoutView1.Columns["PaymentDate"].DisplayFormat.FormatString = "dd/MM/yyyy"; layoutView1.Columns["DatePrinted"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; layoutView1.Columns["DatePrinted"].DisplayFormat.FormatString = "dd/MM/yyyy"; //layoutView1.bes //gridView2.Columns["Amount"].DisplayFormat.FormatType = FormatType.Numeric; //gridView2.Columns["Amount"].DisplayFormat.FormatString = "n2"; //gridView4.Columns["ID"].Visible = false; } else { Common.setMessageBox("No Record Found", Program.ApplicationName, 1); return; } } } finally { SplashScreenManager.CloseForm(false); } }
public void GetAllBy(HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T.LadeCancelAssignment_TField fieldName, Object value, ref System.Data.DataSet dataSet) { try { _dataObject.SelectByField(fieldName.ToString(), value, ref dataSet); } catch (System.Exception ex) { throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this); } }
/// <remarks/> public void GenerarPlanoXMLAsync(int idDocumento, string strNombreDocumento, int idCompania, string strCompania, string strUsuario, string strClave, System.Data.DataSet dsFuenteDatos, string Path, string strResultado) { this.GenerarPlanoXMLAsync(idDocumento, strNombreDocumento, idCompania, strCompania, strUsuario, strClave, dsFuenteDatos, Path, strResultado, null); }
/// <remarks/> public void GenerarPlanoXMLAsync(int idDocumento, string strNombreDocumento, int idCompania, string strCompania, string strUsuario, string strClave, System.Data.DataSet dsFuenteDatos, string Path, string strResultado, object userState) { if ((this.GenerarPlanoXMLOperationCompleted == null)) { this.GenerarPlanoXMLOperationCompleted = new System.Threading.SendOrPostCallback(this.OnGenerarPlanoXMLOperationCompleted); } this.InvokeAsync("GenerarPlanoXML", new object[] { idDocumento, strNombreDocumento, idCompania, strCompania, strUsuario, strClave, dsFuenteDatos, Path, strResultado }, this.GenerarPlanoXMLOperationCompleted, userState); }
public string ImportarDatosTablasDS(int idDocumento, string strNombreDocumento, int idCompania, string strCompania, string strUsuario, string strClave, System.Data.DataSet dsFuenteDatos, string tsProceso, ref string Path) { object[] results = this.Invoke("ImportarDatosTablasDS", new object[] { idDocumento, strNombreDocumento, idCompania, strCompania, strUsuario, strClave, dsFuenteDatos, tsProceso, Path }); Path = ((string)(results[1])); return((string)(results[0])); }
/// <remarks/> public void ImportarDatosTablasDSAsync(int idDocumento, string strNombreDocumento, int idCompania, string strCompania, string strUsuario, string strClave, System.Data.DataSet dsFuenteDatos, string tsProceso, string Path) { this.ImportarDatosTablasDSAsync(idDocumento, strNombreDocumento, idCompania, strCompania, strUsuario, strClave, dsFuenteDatos, tsProceso, Path, null); }
public static int SaveRecord(string sql) { const int rv = 0; try { string connectionString = ConfigurationManager.ConnectionStrings["LA3Access"].ConnectionString; using (var conn = new OleDbConnection(connectionString)) { conn.Open(); var cmGetID = new OleDbCommand("SELECT @@IDENTITY", conn); var comm = new OleDbCommand(sql, conn) { CommandType = CommandType.Text }; comm.ExecuteNonQuery(); var ds = new DataSet(); var adapt = new OleDbDataAdapter(cmGetID); adapt.Fill(ds); adapt.Dispose(); cmGetID.Dispose(); return int.Parse(ds.Tables[0].Rows[0][0].ToString()); } } catch (Exception) { } return rv; }