static void Main(string[] args)
{
// Создание Таблицы DataTable с именем "Cars"
DataTable tablCars = new DataTable("Cars");
// Создание столбцов
DataColumn carsId = new DataColumn("Id", typeof(int));
DataColumn carsName = new DataColumn("Name", typeof(string));
DataColumn carsCountry = new DataColumn("Country", typeof(string));
DataColumn carsPrice = new DataColumn("Price", typeof(double));
tablCars.Columns.AddRange(new DataColumn[] { carsId, carsName, carsCountry, carsPrice });
// Создание строки с данными
DataRow newRow1 = tablCars.NewRow();
newRow1["Name"] = "BMW"; newRow1["Country"] = "Germany";
newRow1["Price"] = "50000";
tablCars.Rows.Add(newRow1);
DataRow newRow2 = tablCars.NewRow();
newRow2["Name"] = "Audi"; newRow2["Country"] = "Germany";
newRow2["Price"] = "37500";
tablCars.Rows.Add(newRow2);
// Сохранить ТАБЛИЦЫ tablCars в виде XML
tablCars.WriteXml("Cars.xml");
tablCars.WriteXmlSchema("CarsSchema.xsd");
// Создание Таблицы DataTable с именем "Drivers"
DataTable tablDrivers = new DataTable("Drivers");
// Создание столбцов
DataColumn drId = new DataColumn("Id", typeof(int));
DataColumn drName = new DataColumn("Name", typeof(string));
DataColumn drAge = new DataColumn("Age", typeof(string));
tablDrivers.Columns.AddRange(new DataColumn[] { drId, drName, drAge });
// Создание строки с данными
DataRow newRow3 = tablDrivers.NewRow();
newRow3["Name"] = "Ivan"; newRow3["Age"] = "33";
tablDrivers.Rows.Add(newRow3);
DataSet dataSet = new DataSet("AutoPark");
dataSet.Tables.AddRange(new DataTable[] { tablCars, tablDrivers});
// Сохранить DATASET в виде XML
dataSet.WriteXmlSchema("AutoParkSchema.xsd");
dataSet.WriteXml("AutoPark.xml");
// Очистить DataSet.
dataSet.Clear();
Console.WriteLine("XML успешно сформированы!");
Console.ReadKey();
}
/// <summary>
/// 根据sql查询数据
/// </summary>
/// <param name="xmlIndex">查询主索引 </param>
/// <param name="strWhere">筛选条件</param>
/// <returns></returns>
public int SearchInfo(string xmlIndex, string strWhere)
{
try
{
if (ds != null)
{
ds.Clear();//清空
}
else
{
ds = new System.Data.DataSet();
}
SearMan.GetSearchInfo(xmlIndex, ds, strWhere);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
this.fpSpread1_Sheet1.DataSource = ds.Tables[0];
}
}
LockFp();
return(0);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(-1);
}
}
void btnClose_Click(object sender, EventArgs e)
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doCloseFinancialperiod", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@period", SqlDbType.VarChar)).Value = cboMonth.SelectedValue;
_command.Parameters.Add(new SqlParameter("@years", SqlDbType.VarChar)).Value = cboYear.SelectedValue;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
Session["voter"] = TextBox2.Text;
Session["voter_nic"] = TextBox1.Text;
ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter("select * from reg where nic =" + TextBox1.Text + " and fam=" + TextBox2.Text, con);
SqlCommandBuilder cb = new SqlCommandBuilder(ad);
ds.Clear();
ad.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
Response.Redirect("login_voter.aspx");
Label1.Text="Invalid Username Or Password";
// Response.Write(" <script >alert ('Wrong') </script>");
}
else
{
//Response.Write(" <script >alert ('congrates') </script>");
Response.Redirect("voter_Home.aspx");
con.Close();
}
}
catch(Exception ex){
Label1.Text="Invalid Username Or Password";
}
}
void setloadOffice()
{
sessions = new SessionManager();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(String.Format("SELECT LTRIM(RTRIM(RevenueOfficeName)) RevenueOfficeName,RevenueOfficeID FROM Setting.RevenueOffice WHERE MerchantCode='{0}' ORDER BY LTRIM(RTRIM(RevenueOfficeName)) ASC ", sessions.MerchantCode.ToString()), connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
gridOffence.DataSource = responses.Tables[0];
gridOffence.DataBind();
}
}
static void Main(string[] args)
{
var connectionString = ConfigurationManager.ConnectionStrings["Nordwind"].ConnectionString;
var selectStatement = "SELECT * FROM Categories";
using (SqlConnection connection = new SqlConnection(connectionString)) {
using (SqlCommand command = new SqlCommand(selectStatement)) {
command.Connection = connection;
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
connection.Open();
adapter.Fill(ds, "Categories");
ds.WriteXml("ds.xml"); // Save this DataSet as XML
ds.WriteXmlSchema("ds.xsd");
ds.Clear();
ds.ReadXml("ds.xml");
DataTable categories = ds.Tables["Categories"];
foreach(DataRow item in categories.Rows)
{
Console.WriteLine("id: {0}, {1} {2}:",
item["CategoryID"],
item["CategoryName"],
item["Description"]);
}
Console.ReadLine();
}
}
}
public static string GetTaxAgent()
{
SessionManager sessions = null;
sessions = new SessionManager();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(String.Format("SELECT DISTINCT TaxAgentUtin,RTRIM(LTRIM(TaxAgentName)) TaxAgentName FROM vwTaxAgents WHERE MerchantCode='{0}' and TaxAgentName IS NOT NULL ORDER BY TaxAgentName ASC ", sessions.MerchantCode.ToString()), connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
return(JsonConvert.SerializeObject(responses));
}
//[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public static string GetOffices()
{
SessionManager sessions = null;
sessions = new SessionManager(); String daresult = null;
CollectionRanking bn = new CollectionRanking();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(String.Format("SELECT LTRIM(RTRIM(RevenueOfficeName)) RevenueOfficeName,RevenueOfficeID FROM Setting.RevenueOffice WHERE MerchantCode='{0}' ORDER BY LTRIM(RTRIM(RevenueOfficeName)) ASC ", sessions.MerchantCode.ToString()), connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
return(JsonConvert.SerializeObject(responses));
}
public DataSet GetAll(string empresaid, tb_cm_ordendecompradet BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCmOrdendecompradet_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc;
cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc;
cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
ds.Clear();
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
void setloadOffice()
{
sessions = new SessionManager();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(String.Format("SELECT DISTINCT TaxAgentUtin,RTRIM(LTRIM(TaxAgentName)) TaxAgentName FROM vwTaxAgents WHERE MerchantCode='{0}' and TaxAgentName IS NOT NULL ORDER BY TaxAgentName ASC ", sessions.MerchantCode.ToString()), connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
//if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
//{
// gridOffence.DataSource = responses.Tables[0];
// gridOffence.DataBind();
//}
}
// 2 methodes:
// - Lezen uit database
// - Uitvoeren ander command (update, insert, delete)
public static DataTable ExecuteSelect(string SQL)
{
// Aanmaken van dataset
// Hierin komt de uitvoer (=dynaset) van de query
DataSet DS = new DataSet();
// Aanmaken dataAdapter
// Deze zorgt voor de vertaling van SQL naar C#
// Denk maar aan een soort tolk
SqlDataAdapter DA;
// Het configureren van de dataAdapter
DA = new SqlDataAdapter(SQL, clStam.Connstr);
// Voordat je een dataset gaat gebruiken moet je deze leegmaken
DS.Clear();
// Gebruik de dataAdapter om de dataset te vullen
DA.Fill(DS);
// Pak uit de dataset de EERSTE tabel omdat de dataset leeg was, is dit het resultaat van de query
DataTable DT = DS.Tables[0];
// Geef de datatable terug
return DT;
}
public void AutoIncrementColumns()
{
execSQL("DROP TABLE IF EXISTS Test");
execSQL("CREATE TABLE Test (id int(10) unsigned NOT NULL auto_increment primary key)");
execSQL("INSERT INTO Test VALUES(NULL)");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
Assert.AreEqual(1, ds.Tables[0].Rows[0]["id"]);
DataRow row = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(row);
try
{
da.Update(ds);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
ds.Clear();
da.Fill(ds);
Assert.AreEqual(1, ds.Tables[0].Rows[0]["id"]);
Assert.AreEqual(2, ds.Tables[0].Rows[1]["id"]);
cb.Dispose();
}
public int GetSampleProgram_ID(string strSample_ID)
{
int nProgram_ID = -1;
int nCountDetections = 0;
string SQL_Statement = "Select Detection,Name,idsample_programs FROM sample_programs ";
DataSet ds_SamplePrograms = new DataSet();
ds_SamplePrograms.Clear();
ds_SamplePrograms = myHC.GetDataSetFromSQLCommand(SQL_Statement);
DataTable dt_SamplePrograms = null;
if (ds_SamplePrograms.Tables[0] != null)
{
dt_SamplePrograms = ds_SamplePrograms.Tables[0];
foreach (DataRow dr_SampleProgram in dt_SamplePrograms.Rows)
{
if (CheckDetection(dr_SampleProgram["Detection"].ToString(), strSample_ID))
{
nProgram_ID = (int)dr_SampleProgram["idsample_programs"];
nCountDetections++;
mySave.InsertRow((int)Definition.Message.D_MESSAGE, strSample_ID + " match to " + dr_SampleProgram["Detection"].ToString() + " --> Program " + dr_SampleProgram["Name"].ToString() + "");
}
}
}
if(nProgram_ID == -1)
{
nProgram_ID = GetDefaultProgram();
mySave.InsertRow((int)Definition.Message.D_ALARM, @"no match for " + strSample_ID + " found in program detection pool, got "
+ myHC.GetNameFromID((int)Definition.SQLTables.SAMPLE_PROGRAM,nProgram_ID) + " (id:" + nProgram_ID + ") as default");
}
// MessageBox.Show(nProgram_ID.ToString());
if (nCountDetections > 1) { mySave.InsertRow((int)Definition.Message.D_ALARM, "found more than one(" + nCountDetections + ") matches to " + strSample_ID + " in programm detection pool"); }
return nProgram_ID;
}
public void fnPopulatedgv1()
{
// Show default datagrid - Hap[pens to be a Donations file at the moment - Change CRH???
SqlConnection conDGV1;
SqlDataAdapter daDGV1;
DataSet dsdgv1 = new DataSet();
conDGV1 = new SqlConnection(VARtxtGAPConnection);
dsdgv1.Clear();
conDGV1.Open();
daDGV1 = new SqlDataAdapter("select * from vw_RECENT_BUILDS", conDGV1);
daDGV1.Fill(dsdgv1);
conDGV1.Close();
conDGV1.Dispose();
dgv1.DataSource = dsdgv1.Tables[0];
// Code to force seconds to be shown
// http://social.msdn.microsoft.com/Forums/en-US/2055d187-1d71-4771-8113-d590f62731b6/datagridviewcolumn-display-datetime-with-seconds-milliseconds-?forum=winforms
foreach (DataGridViewColumn dc in dgv1.Columns)
{
if (dc.ValueType == typeof(System.DateTime))
{
dc.DefaultCellStyle.Format = "dd/MM/yyyy HH:mm:ss";
}
}
// Resize columns in datagrid
dgv1.AutoResizeColumns();
}
void calReport()
{
var vrsearch = Session["Search"].ToString();
XtraRepTCCDetailsbyAll obj_Rpt = new XtraRepTCCDetailsbyAll();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM dbo.ViewTccDetails where Utin ='{0}' OR PayerName LIKE '{0}%' ", vrsearch);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
obj_Rpt.xrLabel10.Text = string.Format("By Individual Record Search");
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
public static DataSet SortDataSet(DataSet ds,DataView view)
{
ds.Clear();
DataRow dr;
foreach (DataRowView row in view)
{
dr = ds.Tables[0].NewRow();
dr["ID"] = row["ID"];
dr["NV_ID"] = row["NV_ID"];
dr["TEN_NV"] = row["TEN_NV"];
dr["NGAY_DAU_TUAN"] = row["NGAY_DAU_TUAN"];
dr["ST2"] = row["ST2"];
dr["CT2"] = row["CT2"];
dr["ST3"] = row["ST3"];
dr["CT3"] = row["CT3"];
dr["ST4"] = row["ST4"];
dr["CT4"] = row["CT4"];
dr["ST5"] = row["ST5"];
dr["CT5"] = row["CT5"];
dr["ST6"] = row["ST6"];
dr["CT6"] = row["CT6"];
dr["ST7"] = row["ST7"];
dr["CT7"] = row["CT7"];
if(ds.Tables[0].Select("NV_ID=" + HelpNumber.ParseInt64(row["NV_ID"])).Length==0)
ds.Tables[0].Rows.Add(dr);
}
return ds;
}
public void CargarDatos(ComboBox cmb, DataSet data, String str,String consulta)
{
try
{
Command.CommandText = consulta;
Adapter.SelectCommand = Command;
data.Clear();
Adapter.Fill(data, str);
cmb.Items.Clear();
foreach (DataRow r in data.Tables[0].Rows)
{
if (r[1].ToString() != "")
{
cmb.Items.Add(r[2].ToString() + " - " + r[1].ToString() + "," + r[0].ToString());
}
else
{
cmb.Items.Add(r[2].ToString() + " - " + r[0].ToString());
}
}
}
catch { }
}
DataSet dts()
{
sessions = new SessionManager();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
var stringstin = Session["STIN"].ToString();
string strquery = String.Format("SELECT * FROM ViewCertificateInformation WHERE MerchantCode='{0}' AND PayerUtin= '{1}'", sessions.MerchantCode.ToString(), stringstin.ToString());
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
}
return(responses);
}
private void UpdateMySQLData()
{
try
{
if (con == null)
{
con = new MySql.Data.MySqlClient.MySqlConnection(sqlstr);
con.Open();
}
if (adapter == null)
{
adapter = new MySql.Data.MySqlClient.MySqlDataAdapter("select * from QQHotList", con);
}
if (ds == null)
{
ds = new System.Data.DataSet();
}
ds.Clear();
adapter.Fill(ds, "QQHotList");
if (dt == null)
{
dt = ds.Tables["QQHotList"];
}
Mic_List.ItemsSource = dt.DefaultView;
con.Close();
}
catch
{
MessageBox.Show("歌单获取失败，请重新启动……");
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
System.Threading.Thread.Sleep(3000);
if (TextBox1.Text == "" && TextBox2.Text == "")
{
Label1.Text = "Invalid ID or Password";
}
else
{
Session["a"] = TextBox1.Text;
ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter("select * from adm_info where username ='******' and pass='******'", con);
SqlCommandBuilder cb = new SqlCommandBuilder(ad);
ds.Clear();
ad.Fill(ds);
if (TextBox2.Text == "" || ds.Tables[0].Rows.Count == 0)
{
Label1.Text = "Invalid ID or Password";
}
else
{
//Response.Write(" <script >alert ('congrates') </script>");
Response.Redirect("default.aspx");
con.Close();
}
Label1.Text = "Invalid ID or Password";
}
}
void loadRevenue()
{
//ViewRevenue
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT RevenueCode, RevenueName FROM ViewRevenue WHERE AgencyId ='{0}' ", ddlAgency.SelectedValue.ToString());
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
ddlRevenue.DataSource = responses.Tables[0];
ddlRevenue.DataValueField = "RevenueCode";
ddlRevenue.DataTextField = "RevenueName";
ddlRevenue.DataBind();
ddlRevenue.Items.Insert(0, new ListItem("--- Select Revenue Name ---", "0"));
}
}
void calReport()
{
var varyear = Session["TaxYear"].ToString();
XtraRepTccYearSummaryChild obj_Rpt = new XtraRepTccYearSummaryChild();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT RevenueOfficeId, RevenueOfficeName, COUNT( DISTINCT TccNo) Reccount, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 1 THEN TccNo END) AS DA, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 2 THEN TccNo END) AS PA, COUNT( DISTINCT CASE WHEN IncomeSourceClassifyId = 3 THEN TccNo END) AS PN, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 4 THEN TccNo END) AS ST, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 5 THEN TccNo END ) AS NR, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 6 THEN TccNo END ) AS UE, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 7 THEN TccNo END) AS DU FROM dbo.ViewTccDetails WHERE YEAR(IssuedDate)='{0}' AND AssessmentYear = YEAR(IssuedDate) - 1 GROUP BY RevenueOfficeId, RevenueOfficeName", varyear);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
obj_Rpt.xrLabel11.Text = string.Format("{0}", varyear);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
public void llenaGrid()
{
DataSet dsGrid = new DataSet();
dsGrid.Clear();
if (cbGrupo.SelectedValue != null)
{
int selectedValue = ((ComboBoxItem)cbGrupo.SelectedItem).intValue;
dsGrid = datamanager.ConsultaDatos("exec dbo.[segGrupoMiembro] " + selectedValue.ToString());
dataGrid.IsReadOnly = !permiteModificar;
dataGrid.ItemsSource = dsGrid.Tables[0].DefaultView;
dataGrid.Columns[2].Visibility = System.Windows.Visibility.Hidden;
dataGrid.Columns[3].Visibility = System.Windows.Visibility.Hidden;
dataGrid.Columns[4].Visibility = System.Windows.Visibility.Hidden;
dataGrid.Columns[0].Width = 250;
dataGrid.Columns[0].IsReadOnly = true;
dataGrid.Columns[0].Header = "Usuario";
dataGrid.Columns[1].Header = "Miembro";
datamanager.ConexionCerrar();
}
btnAceptar.IsEnabled = false;
btnAceptar_png.IsEnabled = false;
}
DataSet getuserrequest(string strrequest)
{
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("GetMerchantMailSetting", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@strul", SqlDbType.VarChar)).Value = strrequest;
_command.CommandTimeout = 0;
response.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(response);
connect.Close();
}
return(response);
}
public static string GetAgency()
{
SessionManager sessions = null;
sessions = new SessionManager(); String daresult = null;
CollectionRanking bn = new CollectionRanking();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(String.Format("SELECT AgencyCode,AgencyName FROM ViewAgency ORDER BY AgencyName ASC "), connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
return(JsonConvert.SerializeObject(responses));
}
void loadAssementyearto()
{
//ViewAgency
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT AssessmentYear FROM [dbo].[ViewAssessmentYear]");
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
ddlto.DataSource = responses.Tables[0];
ddlto.DataValueField = "AssessmentYear";
ddlto.DataTextField = "AssessmentYear";
ddlto.DataBind();
ddlto.Items.Insert(0, new ListItem("--- Select Year To ---", "0"));
}
}
void deleteRecord(string parameter2)
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doDeleteReconciliationPeriod", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@periodID", SqlDbType.Int)).Value = Convert.ToInt32(parameter2);
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
}
}
}
void calReport()
{
var varyear = Session["TaxYear"].ToString();
XtraRepAssessmentYearSummaryChild obj_Rpt = new XtraRepAssessmentYearSummaryChild();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT a.AssessmentYear, a.RevenueOfficeName,a.RevenueOfficeId, COUNT(DISTINCT a.AssessmentNo) AS Reccount, SUM(a.TaxPayable) TotalPayable, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 1 THEN a.AssessmentNo END ) AS DA, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 2 THEN a.AssessmentNo END) AS PA, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 3 THEN a.AssessmentNo END ) AS PN,COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 4 THEN a.AssessmentNo END ) AS ST, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 5 THEN a.AssessmentNo END ) AS NR, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 6 THEN a.AssessmentNo END) AS UE,COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 7 THEN a.AssessmentNo END) AS DU, COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 1 THEN a.TaxPayable END), 0) DAAmount,COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 2 THEN a.TaxPayable END),0) PAAmount,COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 3 THEN a.TaxPayable END ), 0) PNAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 4 THEN a.TaxPayable END ),0 ) STAmount, COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 5 THEN a.TaxPayable END),0) NRAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 6 THEN a.TaxPayable END),0) UEAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 7 THEN a.TaxPayable END),0) DUAmount FROM ViewAssessmentInfor a WHERE a.AssessmentYear = {0} GROUP BY a.AssessmentYear, a.RevenueOfficeName,a.RevenueOfficeId ORDER BY a.RevenueOfficeName asc", varyear);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
obj_Rpt.xrLabel11.Text = string.Format("{0}", varyear);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
void calReport()
{
var vastin = Session["UTIN"].ToString();
XtraRepPayerledge obj_Rpt = new XtraRepPayerledge();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM dbo.ViewPayerLedger where PayerUtin='{0}'", vastin);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
obj_Rpt.xrLabel10.Text = string.Format("As At: {0:dddd, d MMMM,yyyy} ", DateTime.Now);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
void loadgridview()
{
sessions = new SessionManager();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet(); string strquery = String.Empty;
strquery = String.Format("SELECT FirstName, LastName, Email, CreateDate FROM Login.[User] WHERE MerchantCode='{0}' AND FirstName IS NOT NULL ORDER BY FirstName ASC", sessions.MerchantCode.ToString());
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 01)
{
GridView1.DataSource = responses.Tables[0];
GridView1.DataBind();
}
}
public FrmArmsDisplay(System.Data.DataSet dst, bool IsShowDialog)
{
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
InitializeComponent();
dstpass.Clear();
dstpass = dst;
//temTable.Columns.Add("PaymentRefNumber", typeof(string));
//temTable.Columns.Add("EReceipts", typeof(string));
//temTable.Columns.Add("EReceiptsDate", typeof(DateTime));
//temTable.Columns.Add("Amount", typeof(decimal));
if (dstpass.Tables != null || dstpass.Tables[0].Rows.Count > 0)
{
gridControl1.DataSource = dstpass.Tables[1];
gridView1.BestFitColumns();
}
if (!this.IsShowDialog)
{
Init();
}
SplashScreenManager.CloseForm(false);
}
public DataSet LoadContacts(string xmlFilePath)
{
_xmlFilePath = xmlFilePath;
_contactsDataSet = new DataSet();
//_contactsDataView = new DataView();
_contactsDataSet.Clear();
if (File.Exists(_xmlFilePath))
{
_contactsDataSet.ReadXml(_xmlFilePath, XmlReadMode.ReadSchema);
//_contactsDataView = _contactsDataSet.Tables[0].DefaultView;
}
else
{
DataTable dtContacts = new DataTable("Contacts");
dtContacts.Columns.Add(new DataColumn("ContactNo", typeof(string)));
dtContacts.Columns.Add(new DataColumn("Identity", typeof(string)));
dtContacts.Columns.Add(new DataColumn("FriendlyName", typeof(string)));
dtContacts.Columns.Add(new DataColumn("Status", typeof(string)));
_contactsDataSet.Tables.Add(dtContacts);
//_contactsDataView = _contactsDataSet.Tables[0].DefaultView;
}
return _contactsDataSet;
}
void loadRevenueoffice()
{
//Revenue office
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format(" SELECT RevenueOfficeID,RTRIM(LTRIM(RevenueOfficeName)) RevenueOfficeName FROM Setting.RevenueOffice ORDER BY RevenueOfficeName asc");
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
ddlRevenue.DataSource = responses.Tables[0];
ddlRevenue.DataValueField = "RevenueOfficeID";
ddlRevenue.DataTextField = "RevenueOfficeName";
ddlRevenue.DataBind();
ddlRevenue.Items.Insert(0, new ListItem("--- Select Revenue Office ---", "0"));
}
}
public static void Copy()
{
DataSet DS = new DataSet();
string ConnectionString = "Data Source=" + CalibrationSettings.Default.ConnectionDir + "Users.db;Version=3;New=False;Compress=True;";
string LoadCommand = "SELECT * FROM users";
DS.Clear();
SQLiteConnection Connection = new SQLiteConnection(ConnectionString);
//SQLiteCommand Query = new SQLiteCommand(LoadCommand, Connection);
SQLiteDataAdapter DataAdaptor = new SQLiteDataAdapter(LoadCommand, Connection);
DataAdaptor.Fill(DS);
foreach (DataRow dRow in DS.Tables[0].Rows)
{
DataClasses.UserProfile CopyUser = new UserProfile();
CopyUser.Gender = dRow[0].ToString();
CopyUser.Name = dRow[2].ToString();
CopyUser.Surname = dRow[3].ToString();
CopyUser.Weight = Convert.ToInt32(dRow[5]);
CopyUser.Password = dRow[6].ToString() + "000";
if (dRow[1].ToString() == "255")
CopyUser.Name = "Richard";
CopyUser.Name = new String(CopyUser.Name.Where(x => x != ' ' && x != '\r' && x != '\n').ToArray());
CopyUser.EmailAddress = CopyUser.Name + dRow[1].ToString() + "@grucox.com";
AccessorUsers.RegisterNewUser(CopyUser);
}
}
/* Выполняем удаление выбранных элементов */
void removeInTable(String _tableName, String _value)
{
if(_tableName == "Фирмы") _deleteMySQL.SqlCommand = "DELETE FROM firms WHERE (firm_name = '" + _value + "' AND firm_delete = 1)";
if(_tableName == "ТМЦ") _deleteMySQL.SqlCommand = "DELETE FROM tmc WHERE (tmc_name = '" + _value + "' AND tmc_delete = 1)";
if(_tableName == "Склады") _deleteMySQL.SqlCommand = "DELETE FROM store WHERE (store_name = '" + _value + "' AND store_delete = 1)";
if(_tableName == "Ед.Изм") _deleteMySQL.SqlCommand = "DELETE FROM units WHERE (units_name = '" + _value + "' AND units_delete = 1)";
if(_tableName == "Вид налога") _deleteMySQL.SqlCommand = "DELETE FROM typeTax WHERE (typeTax_name = '" + _value + "' AND typeTax_delete = 1)";
if(_tableName == "Сотрудники") _deleteMySQL.SqlCommand = "DELETE FROM staff WHERE (staff_name = '" + _value + "' AND staff_delete = 1)";
if(_tableName == "План счетов") _deleteMySQL.SqlCommand = "DELETE FROM planAccounts WHERE (planAccounts_name = '" + _value + "' AND planAccounts_delete = 1)";
if(_tableName == "Документ") {
ClassMySQL_Full _removeDocMySQL = new ClassMySQL_Full();
DataSet _removeDocDataSet = new DataSet();
_removeDocMySQL.SelectSqlCommand = "SELECT * FROM journal WHERE (journal_number = '" + _value + "' AND journal_delete = 1)";
_removeDocDataSet.Clear();
_removeDocDataSet.DataSetName = "journal";
if(_removeDocMySQL.ExecuteFill(_removeDocDataSet, "journal")){
_deleteMySQL.SqlCommand = "DELETE FROM tabularSection WHERE (tabularSection_id_doc = '" + _removeDocDataSet.Tables["journal"].Rows[0]["journal_id_doc"].ToString() + "')";
if(_deleteMySQL.ExecuteNonQuery())
{
_deleteMySQL.SqlCommand = "DELETE FROM journal WHERE (journal_number = '" + _value + "' AND journal_delete = 1)";
if(_deleteMySQL.ExecuteNonQuery())
{
listBox1.Items.Add("[" + _tableName + "] " + _value + " - - - Запись удалена!");
}
}
}
}else{
if(_deleteMySQL.ExecuteNonQuery())
{
listBox1.Items.Add("[" + _tableName + "] " + _value + " - - - Запись удалена!");
}
}
}
public DataSet dgvselectioncommand()
{
DataSet ds = new DataSet();
try
{
ds.Clear();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sql, gl.oleconnection);
if (teacher != null && teacher != "")
dataAdapter.SelectCommand.Parameters.Add("teacher", OleDbType.VarChar, 50).Value = teacher;
if (infraction != null && infraction != "")
dataAdapter.SelectCommand.Parameters.Add("infraction", OleDbType.VarChar, 20).Value = infraction;
if (firstname != null && firstname != "")
{
dataAdapter.SelectCommand.Parameters.Add("firstname", OleDbType.VarChar, 20).Value = firstname;
dataAdapter.SelectCommand.Parameters.Add("lastname", OleDbType.VarChar, 20).Value = lastname;
dataAdapter.SelectCommand.Parameters.Add("studentid", OleDbType.VarChar, 20).Value = studentid;
}
if (learningcenter != "")
dataAdapter.SelectCommand.Parameters.Add("learningcenter", OleDbType.VarChar, 255).Value = learningcenter;
dataAdapter.SelectCommand.CommandType = CommandType.Text;
dataAdapter.Fill(ds);
}
catch (Exception) { }
return ds;
}
void calReport()
{
XtraRepSummaryLedger obj_Rpt = new XtraRepSummaryLedger();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName,COALESCE(SUM(TaxPayable), 0) Assessment, COALESCE(SUM(PaymentAmount), 0) Payment, COALESCE(SUM(TaxPayable), 0) - COALESCE(SUM(PaymentAmount), 0) Differences FROM dbo.ViewPayerLedger GROUP BY PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName ORDER BY RevenueOfficeName asc");
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
// obj_Rpt.xrLabel10.Text = string.Format("As At: {0:dddd, d MMMM,yyyy} ", DateTime.Now);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
static public bool IsValidUser(string strquery)
{
bool result = false;
SqlCommand _command;
SqlDataAdapter _adp;
System.Data.DataSet responses = new System.Data.DataSet();
using (SqlConnection connect = new SqlConnection(ConfigurationManager
.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
result = true;
}
return(result);
}
public DataSet extraerDatos(String NombreHoja, String RutaArchivo)
{
try
{
//Inicialización de las variables
OleDbConnection conexion = new OleDbConnection();
OleDbCommand comando = new OleDbCommand();
OleDbDataAdapter adaptador = new OleDbDataAdapter();
DataSet dsexcel = new DataSet();
String ExcelPath = "";
String data = "";
dsexcel.Clear();
data = NombreHoja;
ExcelPath = RutaArchivo.ToLower();
conexion.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelPath + "; Extended Properties= \"Excel 8.0;HDR=YES;IMEX=1\"";
conexion.Open();
comando.CommandText = "SELECT * FROM [" + data + "$] where valido=1";
comando.Connection = conexion;
adaptador.SelectCommand = comando;
adaptador.Fill(dsexcel);
conexion.Close();
return dsexcel;
}
catch (Exception)
{
return null;
}
}
private bool admin_checkOut(string loginID, string password)
{
bool login = false;
SqlConnection sqlconnection = new SqlConnection(conStr);
string comStr = string.Format("select Sys_NAME, Sys_PASSWORD from dboSys where Sys_IID = \'{0}\'" ,loginID);
dataSet = new DataSet();
dataSet.Clear();
dataSet = SqlCommondClass.GetDataSet(comStr, "dboSys", sqlconnection);
if (dataSet.Tables[0].Rows.Count == 0)
{
login = false;
return login;
}
if (dataSet.Tables[0].Rows[0][1].ToString().Trim().Equals(password.Trim()))
{
this.sysLogin = true;
this.loginName = dataSet.Tables[0].Rows[0][0].ToString().Trim();
login = true;
return login;
}
return login;
}
protected void Button1_Click(object sender, EventArgs e)
{
string sqlcheck = "select * from vote where nic=" + Session["voter_nic"].ToString();
ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter("select * from vote where nic =" + Session["voter_nic"], con);
SqlCommandBuilder cb = new SqlCommandBuilder(ad);
ds.Clear();
ad.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
Response.Redirect("vote_page.aspx");
}
else
{
// Response.Write(" <script >alert ('congrates') </script>");
Label8.Text = "You Already Casted Your Vote !";
// Response.Redirect("voter_home.aspx");
// Response.Redirect("vote_page.aspx");
// con.Close();
}
}
private void SbnDisapprove_Click(object sender, EventArgs e)
{
string value = string.Empty;
if (DialogResults.InputBox(@"Comments for Disapproving ", "Ministry Disapproval", ref value) == DialogResult.OK)
{
if (!string.IsNullOrWhiteSpace(value))
{
for (int i = 0; i < selection.SelectedCount; i++)
{
tableTrans.Rows.Add(new object[] { (selection.GetSelectedRow(i) as DataRowView)["Period"], (selection.GetSelectedRow(i) as DataRowView)["Narriation"], Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["BankAccountID"]), Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["SummaryID"]), Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["FinancialperiodID"]), (selection.GetSelectedRow(i) as DataRowView)["AgencyCode"], (selection.GetSelectedRow(i) as DataRowView)["RevenueCode"],
(selection.GetSelectedRow(i) as DataRowView)["Description"], (selection.GetSelectedRow(i) as DataRowView)["AgencyName"], Convert.ToDecimal((selection.GetSelectedRow(i) as DataRowView)["Amount"]) });
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("Reconciliation.DisapprovalMinistrySummary", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransactiondb", SqlDbType.Structured)).Value = tableTrans;
_command.Parameters.Add(new SqlParameter("@Userid", SqlDbType.VarChar)).Value = Program.UserID;
_command.Parameters.Add(new SqlParameter("@comment", SqlDbType.VarChar)).Value = value;
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
//FrmReportPosting report = new FrmReportPosting(ds.Tables[1], ds.Tables[2]);
//using (FrmReportPosting frmreport = new FrmReportPosting(ds))
}
}
}
}
else
{
Common.setMessageBox("Disapproval Comment is Empty", "Ministry Disapproval", 3);
return;
}
setReload();
}
}
private void recommend_songlist_Click(object sender, RoutedEventArgs e)
{
try
{
using (var sshClient = new SshClient("192.168.199.201", "hadoop", "hadoop"))
{
sshClient.Connect();
string command = "python /home/hadoop/PycharmProjects/untitled/recommend.py " + xmid.Text;
using (var cmd = sshClient.CreateCommand(command))
{
var res = cmd.Execute();
if (res == "107\n")
{
string rec_sql = "SELECT songname, singer, link FROM `" + xmid.Text + "_rec`";
con2 = null;
if (con2 == null)
{
con2 = new MySql.Data.MySqlClient.MySqlConnection(sqlstr);
con2.Open();
}
adapter2 = null;
if (adapter2 == null)
{
adapter2 = new MySql.Data.MySqlClient.MySqlDataAdapter(rec_sql, con2);
}
ds2 = null;
if (ds2 == null)
{
ds2 = new System.Data.DataSet();
}
ds2.Clear();
adapter2.Fill(ds2, "rec");
dt2 = null;
if (dt2 == null)
{
dt2 = ds2.Tables["rec"];
}
Music_Recommend.ItemsSource = dt2.DefaultView;
if (dt2.DefaultView.Count == 0)
{
MessageBox.Show("无推荐结果哦，试试今日推荐的音乐吧！");
todayRecomend();
}
con2.Close();
}
else
{
MessageBox.Show("无推荐结果哦，试试今日推荐的音乐吧！");
todayRecomend();
}
}
}
}
catch
{
MessageBox.Show("无推荐结果哦，试试今日推荐的音乐吧！");
todayRecomend();
}
}
public void read(string query1, string value1)
{
da = new SqlDataAdapter(query1 + value1, cn);
ds = new DataSet();
ds.Clear();
ds.Reset();
da.Fill(ds);
}
public DataSet SqlQueryOnce(string sql, SqlConnection Conn)
{
SqlDataAdapter adpt = new SqlDataAdapter(sql, Conn);
DataSet ds = new System.Data.DataSet();
ds.Clear();
adpt.Fill(ds);
return ds;
}
public FrmReclassifiedResult(System.Data.DataSet ds)
{
InitializeComponent();
dts2.Clear();
dts2 = ds;
Init();
}
private void show_oder_details_Click(object sender, EventArgs e)
{
String query = "SELECT * FROM [Order Details]";
dataSet.Clear();
dataAdapter = new OleDbDataAdapter(query, dbConnection);
dataAdapter.Fill(dataSet, "Order Details");
}
void GetPayRef()
{
string values = string.Empty;
lblSelect.Text = string.Empty;
int j = 0;
temTable.Clear();
for (int i = 0; i < selection.SelectedCount; i++)
{
temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["Payment Ref. Number"]), Program.UserID });
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("ArmsReceiptsMoved", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransaction", SqlDbType.Structured)).Value = temTable;
_command.CommandTimeout = 0;
System.Data.DataSet response = new System.Data.DataSet();
response.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(response);
connect.Close();
if (String.Compare(response.Tables[0].Rows[0]["returnCode"].ToString(), "00", false) == 0)
{
Common.setMessageBox(response.Tables[0].Rows[0]["returnmessage"].ToString(), Program.ApplicationName, 1);
if (response.Tables[1] != null || response.Tables[1].Rows.Count > 0)
{
using (FrmArmsDisplay display = new FrmArmsDisplay(response, true)
{
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog
})
{
display.ShowDialog();
}
}
}
else
{
Common.setMessageBox(response.Tables[0].Rows[0]["returnmessage"].ToString(), Program.ApplicationName, 1);
return;
}
}
}
public DataSet fetch(string query)
{
da = new SqlDataAdapter(query, con);
ds = new DataSet();
ds.Clear();
ds.Reset();
da.Fill(ds);
return ds;
}
void calReport()
{
var strrevenue = Session["Revenue"].ToString();
var startdate = Session["Startdate"].ToString();
var enddate = Session["Enddate"].ToString();
//var end= Session["Enddate1"].ToString();
var end = Convert.ToDateTime(Session["Enddate1"].ToString()).ToString("dd/MM/yyyy");
//var strat = Session["startdate1"].ToString();
var strat = Convert.ToDateTime(Session["startdate1"].ToString()).ToString("dd/MM/yyyy");
//DateTime dt = DateTime.ParseExact(startdate, "dd/mm/yyyy", CultureInfo.InvariantCulture);
//DateTime dt2 = DateTime.ParseExact(enddate, "dd/mm/yyyy", CultureInfo.InvariantCulture);
//Console.WriteLine(dt.ToString("yyyy-MM-dd"));
//var gb = dt.ToString("yyyy-MM-dd");
//var gb2 = dt2.ToString("yyyy-MM-dd");
//XtraRepPayment obj_Rpt = new XtraRepPayment();
XtraRepPayment2 obj_Rpt = new XtraRepPayment2();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM ViewPayment WHERE PaymentDate BETWEEN '{0}' AND '{1}' and RevenueCode ='{2}' ORDER BY PaymentDate ASC", startdate, enddate, strrevenue);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
obj_Rpt.xrLabel10.Text = string.Format("From {0:dd/MM/yyyy} To {1:dd/MM/yyyy}", strat, end);
obj_Rpt.xrLabel8.Text = Session["RevenueName"].ToString();
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
//var cachedReportSource = new CachedReportSourceWeb(new XtraRepPayment());
}
void Processwork()
{
if (selection.SelectedCount == 0)
{
Common.setMessageBox("No Selection made", Program.ApplicationName, 3);
return;
}
else
{
for (int i = 0; i < selection.SelectedCount; i++)
{
tableTrans.Rows.Add(new object[] { (selection.GetSelectedRow(i) as DataRowView)["Period"], (selection.GetSelectedRow(i) as DataRowView)["Narriation"], Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["BankAccountID"]), Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["SummaryID"]), Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["FinancialperiodID"]), (selection.GetSelectedRow(i) as DataRowView)["AgencyCode"], (selection.GetSelectedRow(i) as DataRowView)["RevenueCode"],
(selection.GetSelectedRow(i) as DataRowView)["Description"], (selection.GetSelectedRow(i) as DataRowView)["AgencyName"], Convert.ToDecimal((selection.GetSelectedRow(i) as DataRowView)["Amount"]) });
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doSummaryAGPosting", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransactiondb", SqlDbType.Structured)).Value = tableTrans;
_command.Parameters.Add(new SqlParameter("@Userid", SqlDbType.VarChar)).Value = Program.UserID;
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
//FrmReportPosting report = new FrmReportPosting(ds.Tables[1], ds.Tables[2]);
using (FrmReportPosting frmreport = new FrmReportPosting(ds))
{
frmreport.ShowDialog();
}
//FrmRequest_Load(null, null);
setReload();
}
}
}
}
}
void btnSelect_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cboYear.SelectedValue.ToString()))
{
Common.setEmptyField("Financial Year", Program.ApplicationName);
return;
}
else if (string.IsNullOrEmpty(cboMonth.SelectedValue.ToString()))
{
Common.setEmptyField("Financial Month", Program.ApplicationName);
return;
}
else
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("dogetCloseFinancialperiod", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@period", SqlDbType.VarChar)).Value = cboMonth.SelectedValue;
_command.Parameters.Add(new SqlParameter("@years", SqlDbType.VarChar)).Value = cboYear.SelectedValue;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
gridControl1.DataSource = ds.Tables[1];
gridView1.Columns["ClosingBalance"].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns["ClosingBalance"].DisplayFormat.FormatString = "n2";
gridView1.Columns["OpeningBalance"].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns["OpeningBalance"].DisplayFormat.FormatString = "n2";
gridView1.Columns["FinancialperiodID"].Visible = false;
gridView1.Columns["Months"].Visible = false;
gridView1.Columns["ClosingBalance"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView1.Columns["ClosingBalance"].SummaryItem.FieldName = "ClosingBalance";
gridView1.Columns["ClosingBalance"].SummaryItem.DisplayFormat = "Total = {0:n}";
//gridView1.BestFitColumns();
}
}
}
}
}
public DataSet UpdateDataGridView(string sqlCommand)
{
Cs.Open();
DataSet ds = new DataSet();
Da.SelectCommand = new SqlCommand(sqlCommand, Cs);
ds.Clear();
Da.Fill(ds);
Cs.Close();
return ds;
//dataGridView.DataSource = ds.Tables[0]; // to show
}
public string GetComTreeSource(string content)
{
ComBase.Logger("coontent:" + content);
dynamic data = JValue.Parse(content);
bool multiple = data.multiple;
string codeValue = data.codeValue;// UserID
string codeName = data.codeName;// CnName
string tableName = data.tableName;// FX_UserInfo
string whereStr = data.conditions;//
string sql = "";
//DataSet dataSet = Utility.Database.ExcuteDataSet(" select DPID as id, DPName as name from FX_Department ");
//return JsonConvert.SerializeObject( dataSet.Tables[0]);
DataSet dataSet = new DataSet();
dataSet.Clear();
sql = string.Format("select {0} from {1} where 1 = 1", codeValue + " as id," + codeName + " as name ", tableName);
if (!string.IsNullOrEmpty(whereStr))
{
whereStr = whereStr.Replace("$$", " ");
whereStr = whereStr.Replace("[", "'");
whereStr = whereStr.Replace("]", "'");
sql += whereStr;
}
dataSet = Utility.Database.ExcuteDataSet(sql);
//switch (tableName)
//{
// case "FX_UserInfo":
// dataSet.Clear();
// sb.AppendFormat("select {0} from {1}", codeValue + " as id," + codeName + " as name ", tableName);
// //List<FX_UserInfo> ddd1 = Utility.Database.QueryList<FX_UserInfo>(sb.ToString());
// dataSet = Utility.Database.ExcuteDataSet(sb.ToString());
// //List<FX_UserInfo> ddd1 = Utility.Database.QueryList<FX_UserInfo>(sb.ToString());
// return JsonConvert.SerializeObject( dataSet.Tables[0]);
// case "FX_Department":
// dataSet.Clear();
// sb.AppendFormat("select {0} from {1}", codeValue + " as id," + codeName + " as name ", tableName);
// dataSet = Utility.Database.ExcuteDataSet(sb.ToString());
// //List<GetDataModels> eeee = Utility.Database.QueryList<GetDataModels>(sb.ToString());
// return JsonConvert.SerializeObject( dataSet.Tables[0]);
// default:
// break;
//}
//var sql = " UserID, CnName";
//sb.AppendFormat("select {0} from {1}", codeValue + "," + codeName, tableName);
//var tablePartField = Utility.Database.GetTableList();
//var tableAllField = Utility.Database.GetAllFieldInfo(tableName);// 获取表所有字段
//List<GetDataModels> ddd = Utility.Database.QueryList<GetDataModels>(sb.ToString());
return JsonConvert.SerializeObject(dataSet.Tables[0]);
}
private void LlenaDetalle(string sAcabado)
{
DataViewManager dvmAcabado = new DataViewManager();
DataSet dsAcabado = new DataSet();
dsAcabado.Clear();
dsAcabado = SistEti.lpQueries.ObtenAcabadoBusqueda(sAcabado);
dvmAcabado = dsAcabado.DefaultViewManager;
dgvAcabados.DataSource = dvmAcabado.DataSet.Tables[0];
dgvAcabados.Refresh();
}
/*Возвращает значение выбранной константы */
public static String constantValue(String constName)
{
ClassMySQL_Full _constMySQL = new ClassMySQL_Full();
DataSet _constDataSet = new DataSet();
_constDataSet.Clear();
_constDataSet.DataSetName = "constants";
_constMySQL.SelectSqlCommand = "SElECT * FROM constants WHERE (const_name = '" + constName + "')";
if(_constMySQL.ExecuteFill(_constDataSet, "constants")){
DataTable table = _constDataSet.Tables["constants"];
return table.Rows[0]["const_value"].ToString();
}else return "";
}
public int ExecuteQuery(string Query, ref DataSet dataset)
{
connection.Open();
MySqlCommand command = new MySqlCommand(Query);
command.Connection = this.connection;
int res = command.ExecuteNonQuery();
adapter.SelectCommand = command;
dataset.Clear();
adapter.Fill(dataset);
connection.Close();
return res;
}
public void CargarDatos(DataSet data, String str,String consulta)
{
try
{
Command.CommandText = consulta;
Adapter.SelectCommand = Command;
data.Clear();
Adapter.Fill(data, str);
}
catch { }
}
public static void Main(string[] args)
{
WriteToEventLog("Calling AEPM Service...");
var dt = new DataTable();
var dset = new DataSet();
Guid = args[0];
//retrieve any records needing updating
try
{
using(var conn = new OleDbConnection(ConfigurationManager.AppSettings["AS400ConnectionStringDev"]))
{
string sql = GetUnprocessMasterRecsString();
var objDataAdapter = new OleDbDataAdapter();
var cmd = new OleDbCommand(sql, conn);
objDataAdapter.SelectCommand = cmd;
objDataAdapter.SelectCommand.CommandTimeout = 0;
dt.Clear();
dset.Clear();
objDataAdapter.Fill(dt);
objDataAdapter.Fill(dset, "currentSelections");
var cb = new OleDbCommandBuilder(objDataAdapter);
AddParameters(cb);
//update records to 'S' for submitted
for (int i = 0; i < dset.Tables["currentSelections"].Rows.Count; i++)
{
dset.Tables["currentSelections"].Rows[i]["G_RETRN"] = 'S';
}
objDataAdapter.Update(dset, "currentSelections");
//submit records asynch
for (int i = 0; i < dt.Rows.Count; i++)
{
TestAsync(dt, i);
}
}
}
catch (Exception ex)
{
WriteToEventLog(ex);
}
}
public void PrintRegExpsToFile(string keyword, string regexp_substring, int min_rating, int howmanyrows, string filename)
{
WebservicesSoapClient wssc = new WebservicesSoapClient();
System.Console.WriteLine(wssc.State);
DataSet ds = new DataSet();
ds = wssc.listRegExp(keyword, regexp_substring, min_rating, howmanyrows);
ds.WriteXml(filename, System.Data.XmlWriteMode.IgnoreSchema);
ds.Clear();
wssc.Abort();
wssc.Close();
}