public DeletePlaylist(Form1 form, DataSet1 dataset, AxWindowsMediaPlayer mp)
{
InitializeComponent();
this.otherForm = form;
this.dataset = dataset;
manager = new PlayListManager(dataset);
this.mp = mp;
}
private void Frm_ThongKe_Load(object sender, EventArgs e)
{
//1 reset report
this.rpv_BaoCao.Reset();
//2 format report
rpv_BaoCao.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.Normal);
rpv_BaoCao.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
rpv_BaoCao.ZoomPercent = 100;
//config
DataSet1 dataset = new DataSet1();
dataset.BeginInit();
this.rpv_BaoCao.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", dataset.Tables["DtHoaDon"]));
this.rpv_BaoCao.LocalReport.ReportPath = "../../rptReportHoaDon.rdlc";
this.rpv_BaoCao.Location = new System.Drawing.Point(0, 0);
dataset.EndInit();
DataSet1TableAdapters.DtHoaDonTableAdapter DTHoaDon = new DataSet1TableAdapters.DtHoaDonTableAdapter();
DTHoaDon.Connection.ConnectionString = HDon_PTA.sChuoiKetNoi();
DTHoaDon.ClearBeforeFill = true;
if (sDk != "")
DTHoaDon.FillBy(dataset.DtHoaDon, sDk);
else
DTHoaDon.Fill(dataset.DtHoaDon);
this.rpv_BaoCao.RefreshReport();
}
public static DataSet1 LoadData(DataSet1 dataSet1)
{
if (dataSet1.Tables.Contains("MainProjects") && dataSet1.Tables.Contains("PartProjects"))
{
DataTable dtMain;
DataTable dtPart;
dtMain = dataSet1.Tables["MainProjects"];
dtPart = dataSet1.Tables["PartProjects"];
dtMain.Rows.Add(1, "TestProject");
var startDate = new DateTime(2016, 01, 18);
var nextDate1 = NextAvailDate(startDate, 6, true);
var endDate1 = EndDate(nextDate1, true);
var nextDate2 = EndDate(endDate1.AddDays(1), false);
var endDate2 = NextAvailDate(nextDate2.AddDays(-1), 5, false);
var nextDate3 = EndDate(endDate2.AddDays(1), true);
var endDate3 = NextAvailDate(nextDate3.AddDays(-1),1, true);
dtPart.Rows.Add(1, 1, "Delmål1", startDate, 6, true, endDate1);
dtPart.Rows.Add(2, 1, "Delmål2", nextDate2, 5, false, endDate2);
dtPart.Rows.Add(3, 1, "Delmål3", nextDate3, 1, true, endDate3);
}
return dataSet1;
}
//--------------------------------------------
private DataTable getData()
{
IDictionary<string, List<string>> LoadedImgFiles =
(IDictionary<string, List<string>>)Session["LoadedIamges"];
DataSet1 ds = new DataSet1();
DataTable dt = ds.Tables[0];
for (int i = 0; i < LoadedImgFiles.Count; i ++)
{
DataRow dr = dt.NewRow();
var pair = LoadedImgFiles.ElementAt(i);
//tr.Cells.Add(AddImage(pair.Key.ToString(), pair.Value.ToString()));
//if (i < LoadedImgFiles.Count - 1)
//{
// pair = LoadedImgFiles.ElementAt(i + 1);
// tr.Cells.Add(AddImage(pair.Key.ToString(), pair.Value.ToString()));
//}
dr["FilePath"] = "http://" + System.Web.HttpContext.Current.Request.Url.Authority + "/uploads/" + pair.Key.ToString();
dr["Description"] = dr["FilePath"];
dt.Rows.Add(dr);
}
return dt;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && !GridWeb1.IsPostBack)
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Specifies the datasource for the sheet.
sheet.DataSource = dataSet11;
sheet.DataMember = "Products";
// Creates in-sheet column headers.
sheet.EnableCreateBindColumnHeader = true;
// Data cells begin at row 1;
sheet.BindStartRow = 1;
// Creates the data field column automatically.
sheet.CreateAutoGenratedColumns();
// Modifies a column's number type.
sheet.BindColumns["UnitPrice"].NumberType = NumberType.Currency3;
// The "product name" field is required.
Aspose.Cells.GridWeb.Validation v = new Aspose.Cells.GridWeb.Validation();
v.IsRequired = true;
sheet.BindColumns["ProductName"].Validation = v;
// Modifies column headers' background color.
for (int i = 0; i < sheet.BindColumns.Count; i++)
{
sheet.BindColumns[i].ColumnHeaderStyle.BackColor = Color.SkyBlue;
}
// Create demo database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Loads data from database.
db.oleDbDataAdapter1.Fill(dataSet11);
}
finally
{
// Close connection
db.oleDbConnection1.Close();
}
// Binding.
sheet.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1 dsOrder = new DataSet1();
DataTable dtOrder = dsOrder.Tables[0];
dtOrder.Rows.Add("lideng", "125", "M", "1");
dtOrder.Rows.Add("lideng1", "13", "M", "1");
dtOrder.Rows.Add("lideng2", "14", "M", "2");
dtOrder.Rows.Add("lideng3", "15", "M", "2");
DataSetLine dsOrderLine = new DataSetLine();
DataTable dtOrderLine = dsOrderLine.Tables[0];
dtOrderLine.Rows.Add("11", "Desc", "33", "GST1", "1");
dtOrderLine.Rows.Add("11", "Desc", "33", "GST1", "1");
dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2");
dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2");
ReportDataSource rds = new ReportDataSource("DataSet1", dtOrder);
ReportDataSource reportDataSource = new ReportDataSource("DataSet2", dtOrderLine);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.DataSources.Add(reportDataSource);
ReportViewer1.LocalReport.Refresh();
}
public ListViewItem ToItem(DataSet1.PlaylistRow row)
{
ListViewGroup in_group = null;
string group_name = (row.artist ?? "") + " - " + (row.album ?? "");
foreach (ListViewGroup group in listViewTracks.Groups)
{
if (group.Name == group_name)
{
in_group = group;
break;
}
}
if (in_group == null)
{
in_group = new ListViewGroup(group_name, group_name);
listViewTracks.Groups.Add(in_group);
}
int iconIndex = _icon_mgr.GetIconIndex(new FileInfo(row.path), true);
ListViewItem item = new ListViewItem(row.title, iconIndex);
TimeSpan Length = TimeSpan.FromSeconds(row.length);
string lenStr = string.Format("{0:d}.{1:d2}:{2:d2}:{3:d2}", Length.Days, Length.Hours, Length.Minutes, Length.Seconds).TrimStart('0', ':', '.');
item.SubItems.Add(new ListViewItem.ListViewSubItem(item, lenStr));
item.Group = in_group;
item.Tag = row;
return item;
}
/// <summary>
/// 增加
/// </summary>
public void add()
{
System.Text.StringBuilder list = new System.Text.StringBuilder();
DataSet ds = new DataSet1();
ds.ReadXml(Server.MapPath("work.xml"));
DataRow row = ds.Tables[0].NewRow();
row["cname"] = Request.QueryString["cname"];
row["cmoney"] = Request.QueryString["cmoney"];
row["mark"] = Request.QueryString["mark"];
ds.Tables[0].Rows.Add(row);
ds.WriteXml(Server.MapPath("work.xml"));
DataSet dss = new DataSet1();
dss.ReadXml(Server.MapPath("work.xml"));
int ircount = dss.Tables[0].Rows.Count;
int maxid = 0;
for (int i = 0; i < ircount; i++)
{
if (Convert.ToInt32(dss.Tables[0].Rows[i][0]) > maxid)
{
maxid = Convert.ToInt32(dss.Tables[0].Rows[i][0]);
}
}
list.Append("<tr id='d" + maxid + "'>");
list.Append("<td><a href='javascript:del(" + maxid.ToString() + ")'>删除</a></td>");
list.Append("<td>"+Request.QueryString["cname"]+"</td>");
list.Append("<td>" + Request.QueryString["cmoney"] + "</td>");
list.Append("<td>" + Request.QueryString["mark"] + "</td></tr>");
Response.Write(list.ToString());
Response.End();
}
public Edit(DataSet1.recordDataRow row)
{
InitializeComponent();
idLoaded = row.id;
RecordRow = dataSet1.recordData.NewrecordDataRow();
this.relationBox.Text=row.relation;
this.titleText.Text=row.title;
this.fnameText.Text=row.first_name;
this.midnameText.Text=row.mid_name;
this.lnameText.Text=row.last_name;
this.nickText.Text=row.nickname;
if(row.sex == "Male"){male.Checked=true;}
else { female.Checked = true; };
if (row.birthdate != null)
{
this.dateTimePicker1.Checked = true;
this.dateTimePicker1.Value = System.DateTime.Parse(row.birthdate);
}
this.noteText.Text=row.note;
this.pictureBox1.ImageLocation=row.photo;
this.pictureBox1.Image= new Bitmap(row.photo);
this.pictureBox1.SizeMode=PictureBoxSizeMode.StretchImage;
this.pcityText.Text=row.pcity;
this.paddressText.Text=row.paddress;
this.pzipText.Text=row.pzip;
if (((row.scity.Length>0) || (row.sddress.Length>0))
|| ((row.szip.Length > 0) || (row.sstate.Length > 0)))
{
this.checkGroupBox2.Checked = true;
this.groupBox2.Enabled = true;
this.pstateText.Text = row.pstate;
this.scityText.Text = row.scity;
this.saddText.Text = row.sddress;
this.szipText.Text = row.szip;
this.sstateText.Text = row.sstate;
}
this.num1.Text=row.num1;
this.num2.Text=row.num2;
this.num3.Text=row.num3;
this.num4.Text=row.num4;
this.num5.Text=row.num5;
this.num6.Text=row.num6;
this.num1Text.Text=row.nnum1;
this.num2Text.Text=row.nnum2;
this.num3Text.Text=row.nnum3;
this.num4Text.Text=row.nnum4;
this.num5Text.Text=row.nnum5;
this.num6Text.Text=row.nnum6;
this.emailText.Text=row.email;
this.webText.Text=row.web;
this.wpositionText.Text=row.wposition;
this.wcopmanyText.Text=row.wcompany;
this.waddressText.Text=row.waddress;
this.wcityText.Text=row.wcity;
this.wzipText.Text=row.wzip;
this.wtelText.Text=row.wtelephone;
this.wemailText.Text=row.wemail;
this.wwebText.Text = row.wweb;
}
private bool IsWinnerExpected(int winnerId, DataSet1.playerRow playerA, DataSet1.playerRow playerB)
{
if (playerA.currentPoints >= playerB.currentPoints && winnerId == playerA.Id ||
playerB.currentPoints >= playerA.currentPoints && winnerId == playerB.Id)
return true;
else
return false;
}
// Konstruktor
public TZBForm()
{
InitializeComponent();
ds = new DataSet1();
dataGridView1.DataSource = ds.Tables["DataTable1"];
num = ComboBox1.SelectedIndex;
}
public void showValues()
{
DataSet1 set = new DataSet1();
adapter.Fill(set.DataTable2);
DataRow [] arrRow = set.DataTable2.Select("fname = 'arif'");
DataRow row = arrRow[0];
Console.WriteLine(row[1]);
}
private void LoadDataSource()
{
//SortBy is required.
if (string.IsNullOrEmpty(dgv1.SortBy)) dgv1.SortBy = DEFAULT_SORT;
DataSet1 ds = new DataSet1();
var dt = Class1.GetData(TABLE_NAME, dgv1.PageSize, dgv1.PageNumber, SEARCH_FIELD, dgv1.SearchEntry, dgv1.SortBy);
dgv1.DataSource = dt;
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("insert into feedback (us,feedback)values(@user,@feedback)", cn);
da.SelectCommand.Parameters.AddWithValue("@user", Session["email_id"].ToString());
da.SelectCommand.Parameters.AddWithValue("@feedback", TextBox1.Text);
DataSet1 ds = new DataSet1();
da.Fill(ds);
// cn.Close();
}
public frmMain() {
InitializeComponent();
a1 = new ArrayList();
a2 = new ArrayList();
a3 = new ArrayList();
d = new ArrayList();
config = new ArrayList();
ds = new DataSet1();
browserListe = new ArrayList();
bs = new BindingSource();
datasetVersion = "1.0.0";
}
private void XtraReport1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
DataSet1TableAdapters.CategoriesTableAdapter da = new DataSet1TableAdapters.CategoriesTableAdapter();
DataSet1 ds = new DataSet1();
da.Fill(ds.Categories);
DataSource = ds.Categories;
xrLabel2.Text = "[CategoryName]";
xrLabel3.Text = "[Description]";
xrPictureBox1.DataBindings.Add("Image", null, "Picture");
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con =new SqlConnection();
con.ConnectionString = "Data Source=LALITHA-PC;Initial Catalog=LSR;Integrated Security=True";
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select customerID,salutation,fname,lname,state_address,email from Customer",con);
DataSet1 dt = new DataSet1();
da.Fill(dt, "Customer");
CrystalReportSource1.ReportDocument.SetDataSource(dt.Tables[0]);
}
public void GetAll()
{
DataSet1 dataSet = BL.getPositions();
List <DataRow> list = dataSet.position_in_mat_delivery_note.Select().OfType <DataRow>().ToList();
list.Sort((x, y) => ((int)x["id_"]).CompareTo((int)y["id_"])); //сортируем по ид
Assert.That(1, Is.EqualTo(1));
Assert.That(list.Count, Is.EqualTo(5));
Assert.That((int)(list[0]["id_"]), Is.EqualTo(1));
Assert.That((double)(list[0]["amount"]), Is.EqualTo(10));
Assert.That((int)(list[0]["invoice_id"]), Is.EqualTo(1));
}
private void botoneraImpCancel1_Click_IMP(object sender, EventArgs e)
{
try
{
//*********************IMAGEN PROGRESS BAR**********************
picProgresBar.Visible = true;
botoneraImpCancel1.Visible = false;
//*******************************************************
if (dgvGrilla.DataSource != null)
{
VISTA.DataSet1 dsDatos = new DataSet1();
//CREO EL DATATABLE EN MEMORIA
DataTable tabla = new DataTable();
//FILTRO LOS QUE ESTAN TILDADOS PARA IMPRIMIR
var colIMPRIMIR = (from entity in ListProductoImprimir
where entity.IMPRIMIR == true
select entity).ToList();
foreach (var producto in colIMPRIMIR)
{
DataRow NuevaFila = dsDatos.Tables["ProductosFaltantes"].NewRow();
NuevaFila["Descipcion"] = producto.PRO_DESCRIPCION;
NuevaFila["CodBarra"] = producto.PRO_BARRAS;
NuevaFila["Categoria"] = producto.CATEGORIA_PRODUCTO.CAT_DESCRIPCION;
NuevaFila["Costo"] = "$ " + producto.PRO_COSTO;
NuevaFila["CantidadEnStock"] = producto.PRO_STOCKACTUAL;
NuevaFila["CantidadMinima"] = producto.PRO_STOCKMINIMO;
dsDatos.Tables["ProductosFaltantes"].Rows.Add(NuevaFila);
}
string TipoInfo = "PRODUCTOSFALTANTES";
frmINFORMES form = new frmINFORMES(dsDatos.Tables["ProductosFaltantes"], TipoInfo);
form.Show();
}
//*********************IMAGEN PROGRESS BAR**********************
picProgresBar.Visible = false;
botoneraImpCancel1.Visible = true;
//*******************************************************
}
catch (Exception ex)
{
ProcesarExcepcion(ex);
}
}
private void BindWithInSheetHeaders()
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Connects to database and fetches data.
db.oleDbDataAdapter1.Fill(dataSet11);
// Create webworksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
// Enables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = true;
// Data cells begin from row 2.
sheet.BindStartRow = 2;
// Creates some title cells.
sheet.Cells["A1"].PutValue("The Product Table");
sheet.Cells["A1"].GetStyle().Font.Size = new FontUnit("20pt");
sheet.Cells["A1"].GetStyle().HorizontalAlign = HorizontalAlign.Center;
sheet.Cells["A1"].GetStyle().VerticalAlign = VerticalAlign.Middle;
sheet.Cells["A1"].GetStyle().BackColor = Color.SkyBlue;
sheet.Cells["A1"].GetStyle().ForeColor = Color.Blue;
sheet.Cells.Merge(0, 0, 2, 11);
// Freezes the header rows.
sheet.FreezePanes(3, 0, 3, 0);
// Bind the sheet to the dataset.
sheet.DataBind();
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
}
private void IPDPatientTreatmentSheet_Load(object sender, EventArgs e)
{
if (IPDPatientTreatmentSheetGuid != Guid.Empty)
{
DataSet1 ds = new DataSet1();
Hospital.Reports.IPDPatientTreatmentSheetDetails objIPDPatientTreatmentSheetDetailsRpt = new Reports.IPDPatientTreatmentSheetDetails();
TextObject txtPatientName = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtPatientName"] as TextObject;
TextObject txtIPDNo = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtIPDNo"] as TextObject;
TextObject txtInchargeDoctor = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtInchargeDoctor"] as TextObject;
TextObject txtDiagnosis = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtDiagnosis"] as TextObject;
//
TextObject txtTreatmentDate = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtTreatmentDate"] as TextObject;
TextObject txtDietAdvice = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtDietAdvice"] as TextObject;
TextObject txtSOSDrug = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtSOSDrug"] as TextObject;
TextObject txtSpecialAdvice = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtSpecialAdvice"] as TextObject;
//
if (PatientGuid != Guid.Empty)
{
objPatient = new Patient(PatientGuid);
if (objPatient != null)
{
txtIPDNo.Text = objPatient.PatientIndoorNo.ToString();
txtPatientName.Text = objPatient.DisplayName;
txtInchargeDoctor.Text = objPatient.PatientDoctorIncharge;
txtDiagnosis.Text = objPatient.PatientFinalDiagnosis;
}
}
objTreatmentSheet = new IPDPatientTreatmentSheet(IPDPatientTreatmentSheetGuid);
if (objTreatmentSheet != null)
{
txtDietAdvice.Text = objTreatmentSheet.DiatAdvice;
txtSOSDrug.Text = objTreatmentSheet.SOSDrug;
txtSpecialAdvice.Text = objTreatmentSheet.SpecialAdvice;
txtTreatmentDate.Text = Common.DateToString(objTreatmentSheet.SheetDate);
}
var obj = Report.GetIPDPatientTreatmentSheetDetailsReport(IPDPatientTreatmentSheetGuid);
ds.Tables["IPDPatientTreatmentSheetDetails"].Merge(obj);
var objVital = Report.GetIPDPatientVitalsByDate(PatientGuid, objTreatmentSheet.SheetDate);
ds.Tables["PatientVitalDetails"].Merge(objVital);
ReportDocument reportdocument = new ReportDocument();
objIPDPatientTreatmentSheetDetailsRpt.SetDataSource(ds);
IPDPatientTreatmentSheet.ReportSource = objIPDPatientTreatmentSheetDetailsRpt;
}
}
private void BindWithInSheetHeaders()
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Connects to database and fetches data.
db.oleDbDataAdapter1.Fill(dataSet11);
// Create webworksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
// Enables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = true;
// Data cells begin from row 2.
sheet.BindStartRow = 2;
// Creates some title cells.
sheet.Cells["A1"].PutValue("The Product Table");
sheet.Cells["A1"].GetStyle().Font.Size = new FontUnit("20pt");
sheet.Cells["A1"].GetStyle().HorizontalAlign = HorizontalAlign.Center;
sheet.Cells["A1"].GetStyle().VerticalAlign = VerticalAlign.Middle;
sheet.Cells["A1"].GetStyle().BackColor = Color.SkyBlue;
sheet.Cells["A1"].GetStyle().ForeColor = Color.Blue;
sheet.Cells.Merge(0, 0, 2, 11);
// Freezes the header rows.
sheet.FreezePanes(3, 0, 3, 0);
// Bind the sheet to the dataset.
sheet.DataBind();
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
}
public static DataSet1 get_repot(string no_invoice)
{
DataSet1 ds = new DataSet1();
try
{
using (var db = new Models.jotunContext())
{
db.Database.Connection.Open();
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = string.Format("select * from invoice where no_invoice = '{0}'", no_invoice);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["invoice"].Merge(dt);
}
cmd.CommandText = string.Format("select * from detail_invoice where no_invoice = '{0}'", no_invoice);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["detail_invoice"].Merge(dt);
}
string[] tables = new string[] { "barang", "customer", "surat_jalan", "po" };
foreach (var table in tables)
{
cmd.CommandText = string.Format("select * from {0}", table);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables[table].Merge(dt);
}
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(ds);
}
public static DataSet1 get_report(string kolom, string param)
{
DataSet1 result = new DataSet1();
kolom = kolom.ToLower();
string sql = "select * from karyawan where ";
if (kolom.Contains("kode"))
{
sql += string.Format("kd_karyawan like '%{0}%'", param);
}
else if (kolom.Contains("nama"))
{
sql += string.Format("nama like '%{0}%'", param);
}
else if (kolom.Contains("alamat"))
{
sql += string.Format("alamat like '%{0}%'", param);
}
else if (kolom.Contains("email"))
{
sql += string.Format("email like '%{0}%'", param);
}
else if (kolom.Contains("akses"))
{
sql += string.Format("hak_akses like '%{0}%'", param);
}
try
{
using (var db = new Models.sim_penjualanContext())
{
db.Database.Connection.Open();
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
result.Tables["karyawan"].Merge(dt);
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
public void RelatorioAcompanhamento()
{
DRFormAguarde.ExecuteFormWait("Gerando Relatório", "Acompanhamento ");
using (DataSet1 ds = ServerDR.GetAcompanhamentoPeriodo(DRProjetoContext.DRProjeto.CodProjeto, dtini, dtfim, checkBox1.Checked))
{
if (ds.DRACOMPANHAMENTO.Rows.Count == 0)
{
DRFormAguarde.FormAguarde.FinalizaAguarde();
MessageBox.Show("Não foi encontrado nenhuma informação!");
return;
}
DataRow rowEmp = ServerDR.GetInfoEmpresa();
string caminho;
DRRelatorisClass.LoadLogoRel(rowEmp, out caminho);
string titulo = GetTitulo();
decimal totPrevisto;
decimal totDespesaAnterior;
decimal totDespesaAtual;
ServerDR.GetTotalizadores(DRProjetoContext.DRProjeto.CodProjeto, dtini, dtfim,
out totPrevisto, out totDespesaAnterior, out totDespesaAtual);
decimal totDespesa = totDespesaAnterior + totDespesaAtual;
DRFormAguarde.FormAguarde.FinalizaAguarde();
using (DRViewRel rel = new DRViewRel())
{
Microsoft.Reporting.WinForms.ReportParameter[] parametros =
{
new Microsoft.Reporting.WinForms.ReportParameter("P_OBRA", "Obra: " + DRProjetoContext.DRProjeto.NomeProjeto),
new Microsoft.Reporting.WinForms.ReportParameter("ImageLogo", caminho),
new Microsoft.Reporting.WinForms.ReportParameter("Endereco", DRRelatorisClass.GetEndereco(rowEmp)),
new Microsoft.Reporting.WinForms.ReportParameter("NomeEmpresa", rowEmp["NOME"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TITULO", titulo),
new Microsoft.Reporting.WinForms.ReportParameter("TotalDespesa", totDespesa.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TotalPrevisto", totPrevisto.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TotDespesaAtual", totDespesaAtual.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TotDespesaAnterior", totDespesaAnterior.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("Observacao", txtObs.Text)
};
rel.ExecuteRel(ds.DRACOMPANHAMENTO, "DataSet1_DRACOMPANHAMENTO", "DRRelAcompanhamento.rdlc", parametros);
}
DRRelatorisClass.DeleteImageLogo();
}
}
private void DischargeSummeryReportForm_Load(object sender, EventArgs e)
{
DataSet1 ds = new DataSet1();
var obj = Report.GetDischargeSummeryReport(PatientGuid);
var objtre = Report.GetDischargeTreatmentRpt(PatientGuid);
ds.Tables["DischargeSummery"].Merge(obj);
ds.Tables["DischargeTreatment"].Merge(objtre);
objrpt = new Reports.DischargeSummeryReport();
ReportDocument reportdocument = new ReportDocument();
objrpt.SetDataSource(ds);
DischargeSummeryReportForm.ReportSource = objrpt;
}
public void GetAll()
{
DataSet1 dataSet = BL.getUnits();
List <DataRow> list = dataSet.unit_of_measurement.Select().OfType <DataRow>().ToList();
list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); //сортируем по ид
Assert.That(list.Count, Is.EqualTo(15));
Assert.That((int)(list[0]["id"]), Is.EqualTo(4));
Assert.That((string)(list[0]["unit_name"]), Is.EqualTo("Миллиметр"));
Assert.That((string)(list[0]["code"]), Is.EqualTo("003"));
Assert.That((string)(list[0]["national_symbol"]), Is.EqualTo("мм"));
}
private void button2_Click(object sender, EventArgs e)
{
string cell = dataGridView1.CurrentRow.Cells[5].Value.ToString();
DialogResult result = MessageBox.Show("Вы действительно хотите удалить эту запись?",
"Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
DataSet1 newDataSet1 = new DataSet1();
DataSet1TableAdapters.workerTableAdapter workerTA = new DataSet1TableAdapters.workerTableAdapter();
workerTA.DeleteQuery(Convert.ToInt32(cell));
WorkerViewForm_Activated(sender, e);
}
}
private void View_Load(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=DESKTOP-U9D8BHS\YASIR;Initial Catalog=INFOEMP;Integrated Security=True ";
string sql = "SELECT Table_1.Employee_ID, Table_1.Full_Name, Table_1.Job, Table_1.Job_Degree, Table_1.First_job_Date, Table_1.Department, Table_2.Birth_Date, Table_2.Birth_Place, Table_1.Working_Years, Table_1.Place_Of_working, Table_2.Card_Number, Table_2.Gavernatore, Table_2.Relajon, Table_2.Street FROM Table_1 INNER JOIN Table_2 ON Table_1.Employee_ID = Table_2.Information_ID";
DataSet1 ds = new DataSet1();
SqlDataAdapter dad = new SqlDataAdapter(sql, con);
dad.Fill(ds.Tables["OrderTable"]);
CryOrder ord = new CryOrder();
ord.SetDataSource(ds.Tables["OrderTable"]);
crystalReportViewer1.ReportSource = ord;
crystalReportViewer1.Refresh();
}
public frmMain()
{
InitializeComponent();
a1 = new ArrayList();
a2 = new ArrayList();
a3 = new ArrayList();
d = new ArrayList();
config = new ArrayList();
ds = new DataSet1();
browserListe = new ArrayList();
bs = new BindingSource();
datasetVersion = "1.0.0";
}
public void GetAll()
{
DataSet1 dataSet = BL.getInvoices();
List <DataRow> list = dataSet.invoice.Select().OfType <DataRow>().ToList();
list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); //сортируем по ид
Assert.That(1, Is.EqualTo(1));
Assert.That(list.Count, Is.EqualTo(2));
Assert.That((int)(list[0]["id"]), Is.EqualTo(1));
Assert.That((string)(list[0]["invoice_number"]), Is.EqualTo("000001"));
Assert.That((int)(list[0]["organization_id"]), Is.EqualTo(2));
}
private void View_Load(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=DESKTOP-U9D8BHS\YASIR;Initial Catalog=INFOEMP;Integrated Security=True ";
string sql = "SELECT Table_1.Employee_ID,Table_1.Full_Name,Table_1.Job,Table_1.Job_Degree,Table_1.Sex,Table_1.First_job_Date, Table_1.Department, Table_1.Working_Years, Table_1.Place_Of_working, Table_2.Birth_Date, Table_2.Birth_Place, Table_2.Name_of_presonal_card_Office, Table_2.Number_Of_File_Card,Table_2.Number_Of_Page_Card,Table_2.Card_Number,Table_2.Sertificate_Number,Table_2.Sertificate_Issuse_Date,Table_2.Marride_State,Table_2.Total_Children,Table_2.Food_Card_Number,Table_2.Gavernatore,Table_2.Relajon,Table_2.Street,Table_2.House,Table_2.Mobile_Number FROM Table_1 INNER JOIN Table_2 ON Table_1.Employee_ID = Table_2.Information_ID WHERE Table_1.Employee_ID = " + x;
DataSet1 ds = new DataSet1();
SqlDataAdapter dad = new SqlDataAdapter(sql, con);
dad.Fill(ds.Tables["OrdarTable"]);
Order ord = new Order();
ord.SetDataSource(ds.Tables["OrdarTable"]);
crystalReportViewer1.ReportSource = ord;
crystalReportViewer1.Refresh();
}
protected void fillexamtypes()
{
strsql = "select strexamtype from tblexamschedule where intschool=" + Session["SchoolID"] + " group by strexamtype";
DataAccess da = new DataAccess();
DataSet ds = new DataSet();
ds = da.ExceuteSql(strsql);
ddlexamtype.DataSource = ds;
ddlexamtype.DataTextField = "strexamtype";
ddlexamtype.DataValueField = "strexamtype";
ddlexamtype.DataBind();
ddlexamtype.Items.Insert(0, "-Select-");
ddlexamtype.Items.Insert(1, "All");
}
//string CCon = ConfigurationManager.AppSettings["ConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.DisplayGroupTree = false;
RD = new ReportDocument();
ReportID = Request.QueryString["ReportID"];
if (ReportID == "PartItemLedger")
{
string StrToDateFrom = "", StrDateTo = "";
RD = new ReportDocument();
dsrpt = new DataSet1();
// PartItemLedger.sp_ItemStockLedger_select.Load(ds.CreateDataReader());
DataSet ds = new DataSet();
//DataSet ds1 = new DataSet();
StrToDateFrom = Request.QueryString["FromDate"];
StrDateTo = Request.QueryString["ToDate"];
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@ToPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@OpeningDate", SqlDbType.VarChar, 10), //0
new SqlParameter("@ToDate", SqlDbType.VarChar, 10), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = Request.QueryString["FromCode"].ToString();
param[2].Value = Request.QueryString["ToCode"].ToString();
param[3].Value = Convert.ToDateTime(StrToDateFrom).ToString("yyyy-MM-dd");
param[4].Value = Convert.ToDateTime(StrDateTo).ToString("yyyy-MM-dd");
ObjSysFunc.ExecuteSP_NonQuery("sp_PartItemLedger", param);
ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.Text, "sp_tempItemStockLedger_Select '" + Session["DealerCode"].ToString() + "'");
//dsrpt.sp_tempItemStockLedger_Select.Load(ds.CreateDataReader());
RD.Load(base.Server.MapPath("rptItemStockLedger.rpt"));
//RD.Load(base.Server.MapPath("rptLedger.rpt"));
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["FromDate"].ToString()).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["ToDate"].ToString()).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "ITEM STOCK LEDGER REPORT" + "\"";
RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
// RD.SetDataSource(dsrpt.sp_tempItemStockLedger_Select.DataSet);
}
CrystalReportViewer1.ReportSource = RD;
}
public PassportMKD()
{
InitializeComponent();
ds = new DataSet1();
elHouseAdapter = new ElHouseTableAdapter();
elHouseParamAdapter = new ElHouseParamsTableAdapter();
// elHouseFlatsAdapter = new ElHouseFlatsTableAdapter();
// elHouseNoflatsAdapter = new ElHouseNoflatsTableAdapter();
porchAdapter = new PorchTableAdapter();
pomeschAdapter = new PomeschenieTableAdapter();
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string email = tbemail.Text;
string pwd = tbpwd.Text;
DataSet1 ds = new DataSet1();
DataSet1TableAdapters.UsersTableTableAdapter taUser =
new DataSet1TableAdapters.UsersTableTableAdapter();
taUser.Fill(ds.UsersTable);
DataRow[] dr = ds.UsersTable.Select("Email='" + email + "'");
Users user = new Users();
if (dr.Count() == 0)
{
Label1.Visible = true;
Label1.Text = "User Doesnt exists!! Sign Up first";
}
else if ((string)(dr[0]["Password"]) != pwd)
{
Label1.Visible = true;
Label1.Text = "Invalid Password !!!!";
}
else if ((string)(dr[0]["UserType"]) == "Employer")
{
user.FirstName = (string)dr[0]["FirstName"];
user.LastName = (string)dr[0]["LastName"];
user.Password = (string)dr[0]["Password"];
user.userid = (int)dr[0]["userid"];
user.UserType = (string)dr[0]["UserType"];
// if ((string)dr[0]["Skillset"] != null)
//{
// user.SkillSet = (string)dr[0]["Skillset"];
// }
Session["user"] = user;
Session["userid"] = user.userid;
Response.Redirect("~/OrganizationSide/OrgShowAllProj.aspx");
}
else if ((string)(dr[0]["UserType"]) == "Student")
{
user.FirstName = (string)dr[0]["FirstName"];
user.LastName = (string)dr[0]["LastName"];
user.Password = (string)dr[0]["Password"];
user.userid = (int)dr[0]["userid"];
user.UserType = (string)dr[0]["UserType"];
Session["student"] = user;
Session["message"] = null;
Response.Redirect("~/Index.aspx");
}
}
private void dailyAttendanceReportToolStripMenuItem_Click(object sender, EventArgs e)
{
RayedoxVariables.currentReport = "Absentee Monthly Report";
// Absentee Monthly Report
frmReportOrderBy frm = new frmReportOrderBy("D");
frm.ShowDialog();
if (frm.orderby != "")
{
SqlConnection conn = new SqlConnection(RayedoxVariables.connectionstring);
SqlCommand cmd;
SqlDataAdapter da;
DataSet1 ds = new DataSet1();
string stingadd1 = "select * from view_attendance where 1=1" + frm.orderby;
conn.Open();
cmd = new SqlCommand(stingadd1, conn);
da = new SqlDataAdapter(cmd);
da.Fill(ds.tblAttendance);
cmd.Dispose();
da.Dispose();
rptDailyAttendance rpt = new rptDailyAttendance();
rpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.RefreshReport();
cmd.Dispose();
da.Dispose();
conn.Close();
try
{
try
{
rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "D:\\Rayedoxreport.txt" + ".txt");
}
catch
{
rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "E:\\Rayedoxreport.txt" + ".txt");
}
}
catch
{
rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "F:\\Rayedoxreport.txt" + ".txt");
}
}
}
public void printPreview()
{
string doaFrom, doaTo;
// Init selected dates from calendar
DateTime?selectedDateFrom = usc_stockout.sortDOAfrom.SelectedDate;
DateTime?selectedDateTo = usc_stockout.sortDOAto.SelectedDate;
try
{
if (selectedDateFrom.HasValue || selectedDateTo.HasValue)
{
// Making a format and getting the value of datepicker to string
doaFrom = selectedDateFrom.Value.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture);
doaTo = selectedDateTo.Value.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture);
ReportDataSource rptDataSource;
this.ReportViewerStockInHistory.LocalReport.DataSources.Clear();
ReportViewerStockInHistory.LocalReport.ReportEmbeddedResource = "NavigationDrawerPopUpMenu2.Reportstockinhistory.rdlc";
DataSet1 ds = new DataSet1();
conn.Open(); // Open Connection
if (reportToPrint == "Select")
{
query = "SELECT * FROM stock_in WHERE stockinStatus = 'Stock In' ORDER BY stockinItem ASC";
}
else if (reportToPrint == "Sort")
{
query = "SELECT * FROM stock_in WHERE stockinDate BETWEEN '" + doaFrom + "' AND '" + doaTo + "' ORDER BY stockinItem ASC "; // Sort base on the query
}
MySqlDataAdapter da = conn.DataAdapter(query);
da.Fill(ds.Tables["dtStockin"]);
conn.Close(); // Close Conn
rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtStockin"]);
this.ReportViewerStockInHistory.LocalReport.DataSources.Add(rptDataSource);
ReportViewerStockInHistory.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
ReportViewerStockInHistory.ZoomMode = ZoomMode.Percent;
ReportViewerStockInHistory.ZoomPercent = 100;
}
}
catch (Exception x)
{
conn.Close();
MessageBox.Show(x.Message + ", Try again later", "Stock In Report Failed", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
ObjectId id = ObjectId.Parse(dvBill.SelectedRows[0].Cells[2].Value.ToString());
FilterDefinition <BsonDocument> filter = Builders <BsonDocument> .Filter.Eq("bills._id", id);
BsonDocument r = collection.Find(filter).First();
int selectedIndex = dvBill.SelectedRows[0].Index;
DataSet1 ds = new DataSet1();
DataRow row;
var items = r["bills"][selectedIndex]["items"].AsBsonArray;
row = ds.dtReceipt.NewRow();
row["patient_name"] = string.Format("{0} {1} {2}", r["firstname"].ToString(),
r["middlename"].ToString(), r["lastname"].ToString());
try
{
row["address"] = r["address"];
}catch (System.Collections.Generic.KeyNotFoundException ex)
{
Console.WriteLine(ex.ToString());
}
ds.dtReceipt.Rows.Add(row);
foreach (var item in items)
{
row = ds.dtReceipt.NewRow();
row["item"] = item["name"];
row["amount"] = item["amount"];
ds.dtReceipt.Rows.Add(row);
}
row = ds.dtReceipt.NewRow();
row["total"] = r["bills"][selectedIndex]["total"];
try
{
row["amount_paid"] = r["bills"][selectedIndex]["paid"];
row["change"] = r["bills"][selectedIndex]["change"];
}catch (System.Collections.Generic.KeyNotFoundException ex)
{
Console.WriteLine(ex.ToString());
MessageBox.Show("Unpaid");
return;
}
ds.dtReceipt.Rows.Add(row);
new Print.FrmPrintForm(ds, new Print.PrintReceipt()).ShowDialog();
}
public void LoadReport(string pcash, string pchange)
{
ReportDataSource rptDataSource;
try
{
this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\Reports\Report1.rdlc";
this.reportViewer1.LocalReport.DataSources.Clear();
DataSet1 ds = new DataSet1();
MySqlDataAdapter da = new MySqlDataAdapter();
con.Open();
da.SelectCommand = new MySqlCommand("SELECT c.id, c.transno,c.pcode,c.price,c.qty,c.disc, c.total,c.sdate,c.status, p.pdesc FROM `tblcart` as c INNER JOIN tblproduct as p ON p.pcode = c.pcode where transno like '" + f.lbltransno.Text + "'", con);
da.Fill(ds.Tables["dtSold"]);
con.Close();
ReportParameter pVatable = new ReportParameter("pVatable", f.lblVatable.Text);
ReportParameter pVat = new ReportParameter("pVat", f.lblVat.Text);
ReportParameter pDiscount = new ReportParameter("pDiscount", f.lblDiscount.Text);
ReportParameter pTotal = new ReportParameter("pTotal", f.lblTotal.Text);
ReportParameter pCash = new ReportParameter("pCash", pcash);
ReportParameter pChange = new ReportParameter("pChange", pchange);
ReportParameter pStore = new ReportParameter("pStore", store);
ReportParameter pAddress = new ReportParameter("pAddress", address);
ReportParameter pTransaction = new ReportParameter("pTransaction", "Invoice #: " + f.lbltransno.Text);
ReportParameter pCashier = new ReportParameter("pCashier", f.lblUsername.Text);
reportViewer1.LocalReport.SetParameters(pVatable);
reportViewer1.LocalReport.SetParameters(pVat);
reportViewer1.LocalReport.SetParameters(pDiscount);
reportViewer1.LocalReport.SetParameters(pTotal);
reportViewer1.LocalReport.SetParameters(pChange);
reportViewer1.LocalReport.SetParameters(pCash);
reportViewer1.LocalReport.SetParameters(pStore);
reportViewer1.LocalReport.SetParameters(pAddress);
reportViewer1.LocalReport.SetParameters(pTransaction);
reportViewer1.LocalReport.SetParameters(pCashier);
rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtSold"]);
reportViewer1.LocalReport.DataSources.Add(rptDataSource);
reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
reportViewer1.ZoomMode = ZoomMode.Percent;
reportViewer1.ZoomPercent = 100;
}
catch (Exception ex)
{
con.Close();
MessageBox.Show(ex.Message);
}
}
public XtraReport CreateDataGroupingReport()
{
// Create a report, and bind it to a data source.
XtraReport report = new XtraReport();
DataSet1 ds = new DataSet1();
new DataSet1TableAdapters.OrdersTableAdapter().Fill(ds.Orders);
report.DataSource = ds;
report.DataMember = "Orders";
// Create a detail band and add it to the report.
DetailBand detailBand = new DetailBand();
detailBand.Height = 20;
report.Bands.Add(detailBand);
// Create a group header band and add it to the report.
GroupHeaderBand ghBand = new GroupHeaderBand();
ghBand.Height = 20;
report.Bands.Add(ghBand);
// Create a calculated field, and add it to the report's collection
CalculatedField calcField = new CalculatedField(report.DataSource, report.DataMember);
report.CalculatedFields.Add(calcField);
// Define its name, field type and expression.
// Note that numerous built-in date-time functions are supported.
calcField.Name = "dayOfWeek";
calcField.FieldType = FieldType.None;
calcField.Expression = "GetDayOfWeek([OrderDate])";
// Define the calculated field as
// a grouping criteria for the group header band.
GroupField groupField = new GroupField();
groupField.FieldName = "dayOfWeek";
ghBand.GroupFields.Add(groupField);
// Create two data-bound labels, and add them to
// the corresponding bands.
XRLabel ghLabel = new XRLabel();
ghLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:dddd}");
ghLabel.BackColor = Color.Red;
ghBand.Controls.Add(ghLabel);
XRLabel detailLabel = new XRLabel();
detailLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:MM/dd/yyyy}");
detailLabel.ProcessDuplicates = ValueSuppressType.Suppress;
detailBand.Controls.Add(detailLabel);
return report;
}
private void button4_Click(object sender, EventArgs e)
{
// 環境設定年月の確認
string msg = "処理対象年月は " + global.cnfYear.ToString() + "年 " + global.cnfMonth.ToString() + "月です。よろしいですか？";
if (MessageBox.Show(msg, "勤怠データ作成", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No)
{
return;
}
bool hol = true;
Hide();
if (getHoldData() > 0)
{
// 保留データ選択
OCR.frmFaxSelect frmH = new OCR.frmFaxSelect();
frmH.ShowDialog();
hol = frmH.myBool; // 中止のとき：false
frmH.Dispose();
}
if (hol)
{
/* 出勤簿フォームを開く前に処理可能な出勤簿データがあるか確認してなければ終了する
* // 2017/10/24
* // CSVファイル数をカウント */
int n = System.IO.Directory.GetFiles(Properties.Settings.Default.dataPath, "*.csv").Count();
DataSet1 dts = new DataSet1();
DataSet1TableAdapters.勤務票ヘッダTableAdapter hAdp = new DataSet1TableAdapters.勤務票ヘッダTableAdapter();
hAdp.Fill(dts.勤務票ヘッダ);
// 勤務票件数カウント
if (n == 0 && dts.勤務票ヘッダ.Count == 0)
{
MessageBox.Show("出勤簿がありません", "出勤簿登録", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Show(); // メニュー画面再表示
return; // 戻る
}
// 勤怠データ作成
OCR.frmCorrect frm = new OCR.frmCorrect(string.Empty);
frm.ShowDialog();
}
Show();
}
/// <summary>
/// Create experiment based on Dataset
/// </summary>
/// <param name="dataset"></param>
public Experiment(DataSet1 dataset)
{
//copy data
m_strData = new string[dataset.Data.Length][];
for (int i = 0; i < dataset.Data.Length; i++)
{
m_strData[i] = new string[dataset.Data[i].Length];
for (int j = 0; j < dataset.Data[i].Length; j++)
{
m_strData[i][j] = dataset.Data[i][j];
}
}
//
Init(dataset.MetaData.ToList(), dataset.TestRows, dataset.IsPrecentige);
}
private void LoadData(FlexCelReport fr)
{
DataSet1 Data = new DataSet1();
DataSet1TableAdapters.ProductTableAdapter ProductAdapter = new DataSet1TableAdapters.ProductTableAdapter();
ProductAdapter.Fill(Data.Product);
DataSet1TableAdapters.ProductPhotoTableAdapter ProductPhotoAdapter = new DataSet1TableAdapters.ProductPhotoTableAdapter();
ProductPhotoAdapter.Fill(Data.ProductPhoto);
DataSet1TableAdapters.ProductProductPhotoTableAdapter ProductProductPhotoAdapter = new DataSet1TableAdapters.ProductProductPhotoTableAdapter();
ProductProductPhotoAdapter.Fill(Data.ProductProductPhoto);
fr.AddTable(Data);
}
public string[] c41 = new string[50]; // c41[0]:20時以降の勤務時間、c41[1]:土日祝の勤務時間
///--------------------------------------------------------------------------
/// <summary>
/// 給与計算用計算用受入データ作成クラスコンストラクタ</summary>
/// <param name="preFrm">
/// 親フォーム</param>
/// <param name="dts">
/// DataSet1</param>
/// <param name="hTbl">
/// 勤務票ヘッダDataTable</param>
/// <param name="mTbl">
/// 勤務票明細DataTable</param>
///--------------------------------------------------------------------------
public OCROutput(Form preFrm, DataSet1 dts)
{
_preForm = preFrm;
_dts = dts;
_hTbl = dts.勤務票ヘッダ;
_mTbl = dts.勤務票明細;
for (int i = 0; i < c41.Length; i++)
{
if (i != c41.Length - 1)
{
c41[i] = ",";
}
}
}
public MainWindow()
{
InitializeComponent();
//http://www.codeproject.com/KB/WPF/WPFDataGridExamples.aspx
// construct the dataset
DataSet1 dataset = new DataSet1();
// use a table adapter to populate the Customers table
Feuil1_TableAdapter adapter = new Feuil1_TableAdapter();
adapter.Fill(dataset._Feuil1_);
// use the Customer table as the DataContext for this Window
this.DataContext = dataset._Feuil1_.DefaultView;
}
protected void Page_Load(object sender, EventArgs e)
{
// Required code
this.ReportViewer1.LocalReport.ExecuteReportInCurrentAppDomain(System.Reflection.Assembly.GetExecutingAssembly().Evidence);
this.ReportViewer1.LocalReport.AddTrustedCodeModuleInCurrentAppDomain("Barcode, Version=1.0.5.40001, Culture=neutral, PublicKeyToken=6dc438ab78a525b3");
this.ReportViewer1.LocalReport.AddTrustedCodeModuleInCurrentAppDomain("System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a");
// Data load
DataSet1 dataSet = new DataSet1();
dataSet.ReadXml(Server.MapPath("~/App_Data/Products.xml"));
ReportDataSource dataSource = new ReportDataSource("DataSet1_Products", dataSet.Products);
this.ReportViewer1.LocalReport.DataSources.Add(dataSource);
this.ReportViewer1.LocalReport.Refresh();
}
private void Form1_Load(object sender, EventArgs e)
{
con.ConnectionString = " server=THENME-PC;integrated security=true;dataBase=store_system";
string sql = "SELECT Storeinvoice.Storeinvoice_no as PurchaseId, Storeinvoice.Storeinvoice_date as PurchaseDate,customercompany.cocuname as CompanyName,employee.empname as EmployeeName, item.item_name as ProductName,invoice_details.invoice_detailsExpirydate as ExpiryDate, invoice_details.invoice_detailsCost UnitCost, invoice_details.invoice_detailsqty Quantity, invoice_details.invoice_detailsqty * CONVERT(int, invoice_details.invoice_detailsCost) AS Total FROM item INNER JOIN invoice_details ON item.item_no = invoice_details.item_no INNER JOIN customercompany ON item.cucono = customercompany.cocuno INNER JOIN Storeinvoice ON invoice_details.Storeinvoice_no = Storeinvoice.Storeinvoice_no AND customercompany.cocuno = Storeinvoice.cocuno INNER JOIN employee ON Storeinvoice.empno = employee.empno where Storeinvoice.Storeinvoice_no= " + x;
DataSet1 ds = new DataSet1();
SqlDataAdapter dad = new SqlDataAdapter(sql, con);
dad.Fill(ds.Tables["DataTable1"]);
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(ds.Tables["DataTable1"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
public ProductPartsForm(DataSet1 data, DataRowView productRowView)
{
var productRow = (DataSet1.ProductRow)productRowView.Row;
_productID = productRow.ID;
_data = data;
InitializeComponent();
productBindingSource.DataSource = productRowView;
assignedPartBindingSource.DataSource = _data;
assignedPartBindingSource.DataMember = "Part";
assignedPartsListBox.DisplayMember = "Name";
unassignedPartBindingSource.DataSource = _data;
unassignedPartBindingSource.DataMember = "Part";
unassignedPartsListBox.DisplayMember = "Name";
}
protected void fillReports()
{
DataSet1 ds = new DataSet1();
ds = csfee.fncGetStudentDailyAllFeeCollectioReport(Int32.Parse(ddlyear.SelectedValue), ddlAdmission.SelectedValue, ddlclass.SelectedValue);
reportfilepath = Server.MapPath("CR_StudentWiseAllFeecollectionReport.rpt");
CrystalReportViewer1.EnableDatabaseLogonPrompt = false;
ReportDocument FeeDetails = new ReportDocument();
FeeDetails.Load(reportfilepath);
FeeDetails.SetDataSource(ds.Tables["StudentWiseAllFeeCollection"]);
CrystalReportViewer1.ReportSource = FeeDetails;
CrystalReportViewer1.DataBind();
CrystalReportViewer1.RefreshReport();
}
public Form_add_user()
{
form_opreator = new Form_operator();
user = new DataSet1TableAdapters.UserQuerry1TableAdapter();
dataNew = new DataSet1();
InitializeComponent();
Opacity = 0;
Timer timer = new Timer();
timer.Tick += new EventHandler((sender, e) =>
{
if ((Opacity += 0.08d) == 1) timer.Stop();
});
timer.Interval = 5;
timer.Start();
}
public MainWindow()
{
InitializeComponent();
a = new DataSet1();
a.DT_Num_Series.Rows.Clear();
dtSeries.ItemsSource = a.DT_Num_Series.AsDataView();
//_erpBS = new ErpBS();
//_erpBS.AbreEmpresaTrabalho(EnumTipoPlataforma.tpEmpresarial ,"CLONETVSD", "gmahota", "Accsys2011!");
//_documentoCompra = _erpBS.Comercial.Compras.Edita("000", "VGR", "2015", 1);
//linhaActual = 2;
}
public Info(DataSet1.recordDataRow row)
{
InitializeComponent();
this.Text = row.title + ' ' + row.first_name + ' ' + row.mid_name + ' ' + row.last_name;
this.relationText.Text = row.relation;
this.nameText.Text = this.Text;
this.nickText.Text = row.nickname;
this.sexText.Text = row.sex;
this.birthdateText.Text = row.birthdate;
this.noteText.Text = row.note;
this.photoPictureBox.Image = new Bitmap(row.photo);
this.photoPictureBox.ImageLocation = row.photo;
this.photoPictureBox.SizeMode=PictureBoxSizeMode.StretchImage;
this.pcityText.Text = row.pcity;
this.paddressText.Text = row.paddress;
this.pzipText.Text = row.pzip;
this.pstateText.Text = row.pstate;
this.scityText.Text = row.scity;
this.saddText.Text = row.sddress;
this.szipText.Text = row.szip;
this.sstateText.Text = row.sstate;
this.num1.Text = row.num1;
this.num2.Text = row.num2;
this.num3.Text = row.num3;
this.num4.Text = row.num4;
this.num5.Text = row.num5;
this.num6.Text = row.num6;
this.nnum1.Text = row.nnum1;
this.nnum2.Text = row.nnum2;
this.nnum3.Text = row.nnum3;
this.nnum4.Text = row.nnum4;
this.nnum5.Text = row.nnum5;
this.nnum6.Text = row.nnum6;
this.emailText.Text = row.email;
this.webText.Text = row.web;
this.wpositionText.Text = row.wposition;
this.companyText.Text = row.wcompany;
this.waddressText.Text = row.waddress;
this.wcityText.Text = row.wcity;
this.wzipText.Text = row.wzip;
this.wtelText.Text = row.wtelephone;
this.wemailText.Text = row.wemail;
this.wwebText.Text = row.wweb;
loadedRow = row;
}
private Tuple<int, int> AwardPoints(int winnerId, DataSet1.playerRow playerA, DataSet1.playerRow playerB)
{
List<Tuple<int, int>> pointsExpected = new List<Tuple<int, int>>();
List<Tuple<int, int>> pointsUnexpected = new List<Tuple<int, int>>();
pointsExpected.Add(new Tuple<int, int>(-1, 8));
pointsExpected.Add(new Tuple<int, int>(13, 7));
pointsExpected.Add(new Tuple<int, int>(38, 6));
pointsExpected.Add(new Tuple<int, int>(63, 5));
pointsExpected.Add(new Tuple<int, int>(88, 4));
pointsExpected.Add(new Tuple<int, int>(113, 3));
pointsExpected.Add(new Tuple<int, int>(138, 2));
pointsExpected.Add(new Tuple<int, int>(163, 2));
pointsExpected.Add(new Tuple<int, int>(188, 1));
pointsExpected.Add(new Tuple<int, int>(213, 1));
pointsExpected.Add(new Tuple<int, int>(238, 0));
pointsUnexpected.Add(new Tuple<int, int>(-1, 8));
pointsUnexpected.Add(new Tuple<int, int>(13, 10));
pointsUnexpected.Add(new Tuple<int, int>(38, 13));
pointsUnexpected.Add(new Tuple<int, int>(63, 16));
pointsUnexpected.Add(new Tuple<int, int>(88, 20));
pointsUnexpected.Add(new Tuple<int, int>(113, 25));
pointsUnexpected.Add(new Tuple<int, int>(138, 30));
pointsUnexpected.Add(new Tuple<int, int>(163, 35));
pointsUnexpected.Add(new Tuple<int, int>(188, 40));
pointsUnexpected.Add(new Tuple<int, int>(213, 45));
pointsUnexpected.Add(new Tuple<int, int>(238, 50));
int dif = Math.Abs(playerA.currentPoints - playerB.currentPoints);
for (int i = pointsExpected.Count-1; i > -1; i--)
{
if (dif > pointsExpected[i].Item1)
{
if (IsWinnerExpected(winnerId, playerA, playerB))
{
return pointsExpected[i];
}
else
return pointsUnexpected[i];
}
}
return new Tuple<int, int>(0, 0);
}
private void BindWithoutInSheetHeaders()
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Connects to database and fetches data.
db.oleDbDataAdapter1.Fill(dataSet11);
// Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
sheet.Cells.UnMerge(0, 0, 2, 11);
// Disables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = false;
// Data cells begin from row 0.
sheet.BindStartRow = 0;
// Unfreezes the header rows.
sheet.UnfreezePanes();
// Bind the sheet to the dataset.
sheet.DataBind();
}
finally
{
// Close database connection
db.oleDbConnection1.Close();
}
}
public void Init(frmCUEPlayer parent)
{
_config = parent.Config;
dataSet = parent.DataSet;
MdiParent = parent;
Show();
_icon_mgr = parent.IconMgr;
listViewTracks.SmallImageList = _icon_mgr.ImageList;
foreach (DataSet1.PlaylistRow row in dataSet.Playlist)
{
try
{
listViewTracks.Items.Add(ToItem(row));
}
catch (Exception ex)
{
Trace.WriteLine(ex.Message);
}
}
}
public object GetDataSource(NameValueCollection args, bool designTime)
{
if (designTime)
{
return new DataSet1();
}
else
{
var ds = new DataSet1();
var row0 = ds.DataTable1.NewDataTable1Row();
row0.DataColumn1 = "TEST 0";
ds.DataTable1.AddDataTable1Row(row0);
var row1 = ds.DataTable1.NewDataTable1Row();
row1.DataColumn1 = "TEST 1";
ds.DataTable1.AddDataTable1Row(row1);
return ds;
}
}
private void btnReport_Click(object sender, EventArgs e)
{
Int32 selectedRowCount = dgv1.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount<=0)
{
MessageBox.Show("Please select record first.");
return;
}
string StrCmd = "";
string EMPID = dgv1.Rows[dgv1.CurrentCell.RowIndex].Cells["dgv1EMPID"].Value.ToString();
if (rdo1.Checked == true)
{
StrCmd = "select EMPID,NAME,DATETIMEIN,DATETIMEOUT from InOutTimeTable where DateDiff('d',DATETIMEIN,'" + dtp1.Value + "')=0 and EMPID=" + EMPID;
}
else if (rdo2.Checked == true)
{
StrCmd = "select EMPID,NAME,DATETIMEIN,DATETIMEOUT from InOutTimeTable where DateDiff('m',DATETIMEIN,'" + dtp1.Value + "')=0 and EMPID=" + EMPID;
}
OleDbDataAdapter da = new OleDbDataAdapter(StrCmd, MyConn);
DataSet ds = new DataSet();
da.Fill(ds, "ReportTable");
DataTable dt = new DataTable();
dt = ds.Tables["ReportTable"];
DataRow dr;
dsx = new DataSet1();
foreach(DataRow _item in dt.Rows)
{
dr = dsx.ReportTable.NewRow();
dr["EMPID"] = _item[0];
dr["NAME"] = _item[1];
dr["DATETIMEIN"] = _item[2];
dr["DATETIMEOUT"] = _item[3];
TimeSpan span = (DateTime.Parse(_item[3].ToString()).Subtract(DateTime.Parse(_item[2].ToString())));
dr["HOUR"] = span.Hours.ToString() + ":" + span.Minutes.ToString();
dsx.ReportTable.Rows.Add(dr);
}
frmReportViewer ReportViewerForm = new frmReportViewer();
ReportViewerForm.Show();
}
public void CreafReportes(string nombreReporte, String sCadena, String sTitulo,DataTable dtabla)
{
string titulo = sTitulo;
string cadena = sCadena;
// Crea el documento del Reporte
CrystalDecisions.CrystalReports.Engine.ReportDocument reporte = creaReporte(nombreReporte);
DataSet1 dtSet = new DataSet1();
dtSet.Tables.Add(dtabla);
reporte.SetDataSource(dtSet.Tables[1]);
//===== Crea formulario cFReporte
System.Windows.Forms.Form cFReporte = new System.Windows.Forms.Form();
cFReporte.BackColor = Color.LightSteelBlue;
cFReporte.WindowState = FormWindowState.Maximized;
cFReporte.MaximizeBox = false;
cFReporte.MinimizeBox = false;
// Crea el Report Viewer
CrystalDecisions.Windows.Forms.CrystalReportViewer CRVrpt = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
CRVrpt.Size = new System.Drawing.Size(830, 501);
CRVrpt.Location = new System.Drawing.Point(0, 0);
CRVrpt.Dock = System.Windows.Forms.DockStyle.Fill;
CRVrpt.ShowCloseButton = true;
CRVrpt.ShowExportButton = true;
CRVrpt.ShowGotoPageButton = true;
CRVrpt.ShowPageNavigateButtons = true;
CRVrpt.ShowPrintButton = true;
CRVrpt.ShowRefreshButton = true;
CRVrpt.ShowZoomButton = true;
CRVrpt.ShowGroupTreeButton = true;
CRVrpt.DisplayGroupTree = true;
CRVrpt.DisplayStatusBar = true;
CRVrpt.DisplayToolbar = true;
CRVrpt.ReportSource = reporte;
cFReporte.Controls.Add(CRVrpt);
cFReporte.Show();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
catAdap.Fill(Category);
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataTable queriedProducts = result.CopyToDataTable<DataSet1.ProductsRow>();
queriedProducts.TableName = "queriedProducts";
DataSet1 ds = new DataSet1();
ds.Tables.Add(queriedProducts);
//DataView view = result.AsDataView<DataSet1.ProductsRow>();
//view.RowFilter = "CategoryID = 65985";
GridView1.DataSource = ds.Tables["queriedProducts"];
GridView1.DataBind();
}