public static DataTable GetHandoverLogByHandoverLogId(int handoverLogId)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
DataSet ds = new DataSet();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = @"SELECT WorkingTeamShiftLog.*,
StaffInfo.Name AS ChargeManName, ProductLine.Name AS ProductLineName,
WorkingTeam.Name AS WorkingTeamName
FROM WorkingTeam INNER JOIN
StaffInfo INNER JOIN
WorkingTeamShiftLog ON StaffInfo.ID = WorkingTeamShiftLog.ChargeManID INNER JOIN
ProductLine ON WorkingTeamShiftLog.ProductLineID = ProductLine.ID ON
WorkingTeam.ID = WorkingTeamShiftLog.WorkingTeamID
WHERE (WorkingTeamShiftLog.ID = @workingTeamShiftLogID)";
command.Parameters.Add(new SqlParameter("workingTeamShiftLogID", handoverLogId));
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
}
return ds.Tables[0];
}
public static void LerUsuarios_Desconectado()
{
DataSet ds = new DataSet();
using (var con = ObterConexao())
{
var cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Usuario";
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
}
foreach (DataTable table in ds.Tables)
{
foreach (DataColumn column in table.Columns)
{
foreach (DataRow row in table.Rows)
{
Console.WriteLine("{0}: {1}", column.ColumnName, row[column.ColumnName]);
}
}
}
Console.Read();
}
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
public void run()
{
Exception exp = null;
DataSet ds = new DataSet();
DataTable dtParent = GHTUtils.DataProvider.CreateParentDataTable();
DataTable dtChild = GHTUtils.DataProvider.CreateChildDataTable();
ds.Tables.Add(dtParent);
ds.Tables.Add(dtChild);
ForeignKeyConstraint fc = null;
fc = new ForeignKeyConstraint(dtParent.Columns[0],dtChild.Columns[0]);
try
{
BeginCase("default ");
Compare(fc.ConstraintName ,string.Empty );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
fc.ConstraintName = "myConstraint";
try
{
BeginCase("set/get ");
Compare(fc.ConstraintName ,"myConstraint" );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
}
public static string runDocno(string tablename, string fieldname, string doctype)
{
SqlConnection con = new SqlConnection(SysApp.DatabaseConfig.ServerConStr);
string sql = " select ";
sql += " case when max(substring(" + fieldname + ",4,6)) <> convert(varchar,getdate(),12) then ";
sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-0001' ";
sql += " when max(substring(" + fieldname + ",4,6)) = convert(varchar,getdate(),12) then ";
sql += " case ";
sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <10 then '" + doctype + "' + convert(varchar,getdate(),12) + '-000' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <100 then '" + doctype + "' + convert(varchar,getdate(),12) + '-00' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <1000 then '" + doctype + "' + convert(varchar,getdate(),12) + '-0' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " else ";
sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " end ";
sql += " else ";
sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-0001' ";
sql += " end ";
sql += " as " + fieldname;
sql += " from " + tablename;
sql += " where " + fieldname + " like '" + doctype + "%' ";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds, "runDocno");
string docno = ds.Tables["runDocno"].Rows[0][fieldname].ToString();
da = null;
return docno;
}
/// <summary>
/// 处理数据
/// </summary>
/// <param name="ds"></param>
public void HandleData(DataSet ds)
{
int count = ds.Tables[0].Rows.Count;
int current = AspNetPager.PageSize * (AspNetPager.CurrentPageIndex - 1) + 1;
dsPosts.Tables.Add("table");
dsPosts.Tables[0].Columns.AddRange(new DataColumn[] {
new DataColumn("ID"),
new DataColumn("PostTitle"),
new DataColumn("PosterID"),
new DataColumn("PostContent"),
new DataColumn("PostRecordTime"),
new DataColumn("PostReplyCount"),
new DataColumn("PosterType"),
new DataColumn("PostPlateID"),
new DataColumn("ViewTimes")
});
DataRow row;
for (int i = current - 1; (i < current + AspNetPager.PageSize - 1) && (i < count); i++)
{
row = ds.Tables[0].Rows[i];
dsPosts.Tables[0].Rows.Add(row["ID"], row["PostTitle"], row["PosterID"], row["PostContent"], row["PostRecordTime"],
row["PostReplyCount"], row["PosterType"], row["PostPlateID"], row["ViewTimes"]);
}
}
public bool InsertUpdateDelete(DataSet ds)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand commandInsert = db.GetStoredProcCommand("usp_TaxTypeInsert");
db.AddInParameter(commandInsert, "@CompanyId", DbType.Int32, "CompanyId", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@TaxTypeName", DbType.String, "TaxTypeName", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@Note", DbType.String, "Note", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@TaxPercentage", DbType.Decimal, "TaxPercentage", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@CreatedUser", DbType.Int32, "CreatedUser", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@StatusId", DbType.Int32, "StatusId", DataRowVersion.Current);
DbCommand commandUpdate = db.GetStoredProcCommand("usp_TaxTypeUpdate");
db.AddInParameter(commandUpdate, "@TaxTypeId", DbType.Int32, "TaxTypeId", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@TaxTypeName", DbType.String, "TaxTypeName", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@Note", DbType.String, "Note", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@TaxPercentage", DbType.Decimal, "TaxPercentage", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@UpdatedUser", DbType.Int32, "UpdatedUser", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@StatusId", DbType.Int32, "StatusId", DataRowVersion.Current);
DbCommand commandDelete = db.GetStoredProcCommand("usp_TaxTypeDelete");
db.AddInParameter(commandDelete, "@TaxTypeId", DbType.Int32, "TaxTypeId", DataRowVersion.Current);
db.UpdateDataSet(ds, ds.Tables[0].TableName, commandInsert, commandUpdate, commandDelete, UpdateBehavior.Transactional);
return true;
}
public static List<string> QueryAccessFomList(int userID, string conn)
{
try
{
List<string> list = new List<string>();
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("mode");
ds.Tables[0].Columns.Add("id");
ds.Tables[0].Rows.Add("2", userID);
DataTable dt = DbUserRes.QueryFormAuth(ds, conn);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string formName = dt.Rows[i]["NAME"].ToString();
if (!list.Contains(formName))
{
list.Add(formName);
}
}
}
return list;
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
ds.ReadXml(@"D:\Books.xml");
bookgrd.DataSource = ds.Tables[0];
bookgrd.DataBind();
IEnumerable<DataRow> tbl1row = ds.Tables[0].AsEnumerable();
ds1.ReadXml(@"D:\Books2.xml");
IEnumerable<DataRow> tbl2row = ds1.Tables[0].AsEnumerable();
GridView1.DataSource = ds1.Tables[0];
GridView1.DataBind();
var items = tbl2row.AsEnumerable().Select(r => r.Field<string>("id"))
.Except(tbl1row.AsEnumerable().Select(r => r.Field<string>("id")));
DataTable TableC = (from row in tbl2row.AsEnumerable()
join id in items
on row.Field<string>("id") equals id
select row).CopyToDataTable();
GridView2.DataSource = TableC;
GridView2.DataBind();
}
public DataSet FilterData(ArsonFilterModel filterData)
{
var connectionString = ConfigurationManager.ConnectionStrings["UCR_DataEntities"];
DataSet dsResult = new DataSet();
using (SqlConnection conn = new SqlConnection(connectionString.ConnectionString))
{
try
{
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = GenerateArsonORQuery(filterData);
command.CommandType = System.Data.CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
conn.Open();
adapter.Fill(dsResult);
conn.Close();
adapter.Dispose();
command.Dispose();
}
catch (Exception ex)
{
StorageClient.LogError(ex);
}
}
return dsResult;
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
int curRow = int.Parse(e.RowIndex.ToString());
string currentrow;
currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString();
SqlDataAdapter adp1 = new SqlDataAdapter("Select * from ResManagerToAdmin where ResID='" + currentrow + "'", con);
DataSet ds1 = new DataSet();
adp1.Fill(ds1);
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand("Update ResManagerToAdmin set RFinalView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd1.ExecuteNonQuery();
status = ds1.Tables[0].Rows[0]["RStatus"].ToString();
if (status == "Success")
{
ViewAdminResponses var = new ViewAdminResponses();
var.ShowDialog();
}
else
{
RecordNotFound rnf = new RecordNotFound();
rnf.ShowDialog();
}
}
private void button1_Click_1(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection(constring);
con1.Open();
SqlDataAdapter adp = new SqlDataAdapter("Select whoislogin from Registration", con1);
DataSet ds = new DataSet();
adp.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand("Update Registration set whoislogin='******'", con1);
cmd.ExecuteNonQuery();
}
SqlDataAdapter adp2 = new SqlDataAdapter("Select * from ResManagerToAdmin", con1);
DataSet ds2 = new DataSet();
adp2.Fill(ds2);
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
//adminview = ds.Tables[0].Rows[j]["RView"].ToString();
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + adminviewempty + "'", con1);
cmd.ExecuteNonQuery();
}
con1.Close();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
bool check;
Control.Control control= new Control.Control();
Entity.Entity entity = new Entity.Entity();
entity.setUsername(this.textBox1.Text);
entity.setPassword(this.textBox2.Text);
check = control.checkUsers(entity.getUsername(), entity.getPassword());
dt = control.getCustomer(entity.getUsername());
if (check)
{
check1 = true;
mainForm main = new mainForm();
main.ShowDialog();
this.textBox1.Text = "";
this.textBox2.Text = "";
}
else {
this.textBox1.Text = "";
this.textBox2.Text = "";
MessageBox.Show("密码错误或用户名不存在");
}
}
public void resetData()
{
DataSet dstmp = new DataSet();
//创建虚拟数据表
DataTable table = new DataTable("TAB_NM");
//获取列集合,添加列
DataColumnCollection columns = table.Columns;
columns.Add("教工号", typeof(String));
columns.Add("姓名", typeof(String));
columns.Add("基本工资", typeof(float));
columns.Add("津贴", typeof(float));
columns.Add("公积金", typeof(float));
columns.Add("生活费", typeof(float));
columns.Add("所得税", typeof(float));
List<Teacher> list = new TeacherDB().selectAll();
//Teacher mTeacher = new Teacher();
foreach (Teacher mTeacher in list)
{
//添加一行记录
DataRow row = table.NewRow();
row["教工号"] = mTeacher.Id;
row["姓名"] = mTeacher.Name;
row["基本工资"] = mTeacher.BaseSalary;
row["津贴"] = mTeacher.Allowance;
row["公积金"] = mTeacher.Fund;
row["生活费"] = mTeacher.Sanitary;
row["所得税"] = mTeacher.IncomeTax;
table.Rows.Add(row);
}
dstmp.Tables.Add(table); //把信息表放入DataSet中
dataGridView1.DataSource = dstmp.Tables["TAB_NM"];
}
public static DataSet ExecuteDataSet(CommandType cmdType, string strProcedureName, SqlParameter[] objParameters)
{
DataSet dset = new DataSet();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db1ConnectionString"].ToString());
con.Open();
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = cmdType;
cmd.CommandText = strProcedureName;
AttachParameters(cmd, objParameters);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(dset);
return dset;
}
catch (Exception ex)
{
return dset;
}
finally
{
con.Close();
}
}
private void ArrayBinding_Load(object sender, System.EventArgs e)
{
// Access database
System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm mainForm = (System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm)this.ParentForm;
// The XML document
string fileNameString = mainForm.applicationPath + "\\data\\data.xml";
string fileNameSchema = mainForm.applicationPath + "\\data\\data.xsd";
// Initializes a new instance of the DataSet class
DataSet custDS = new DataSet();
// Reads an XML schema into the DataSet.
custDS.ReadXmlSchema( fileNameSchema );
// Reads XML schema and data into the DataSet.
custDS.ReadXml( fileNameString );
// Initializes a new instance of the DataView class
DataView firstView = new DataView(custDS.Tables[0]);
Chart1.Series.Clear();
// Since the DataView implements and IEnumerable, pass the reader directly into
// the DataBindTable method with the name of the column used for the X value.
Chart1.DataBindTable(firstView, "Name");
// Set series appearance
Chart1.Series[0].ChartType = SeriesChartType.Bar;
Chart1.Series[0].Font = new Font("Trebuchet MS", 8);
Chart1.Series[0].Color = System.Drawing.Color.FromArgb(220, 224,64,10);
Chart1.Series[0].BorderWidth = 0;
}
public void LoadData()
{
ds = BWorkstation.Retrieves();
dgrWorkstation.AutoGenerateColumns = false;
dgrWorkstation.DataSource = ds.Tables[0].DefaultView;
GenSTT();
}
private void cartelera_Load(object sender, EventArgs e)
{
//frmCiudad ciudad = new frmCiudad();
String numeroSucursal = lblsucursal.Text;
string query = string.Format("select TRHORA.idSucursal,MAPELI.iidpelicula, MAPELI.bimagen FROM TRHORARIO TRHORA, MAPELICULA MAPELI WHERE TRHORA.iidpelicula=MAPELI.iidpelicula and TRHORA.idSucursal = '"+ numeroSucursal +"'");
MySqlCommand comando = new MySqlCommand(query, classCrearConexion.Conexion());
MySqlDataAdapter da = new MySqlDataAdapter(comando);
DataSet ds = new DataSet("MAPELICULA");
da.Fill(ds, "MAPELICULA");
byte[] datos = new byte[0];
DataRow dr = ds.Tables["MAPELICULA"].Rows[0];
datos = (byte[])dr["bimagen"];
System.IO.MemoryStream ms = new System.IO.MemoryStream(datos);
pb1.Image = System.Drawing.Bitmap.FromStream(ms);
/*pb1.Image = Properties.Resources.El_Destino_de_Júpite;
pb1.Refresh();
pb2.Image = Properties.Resources.FF2;
pb2.Refresh();
pb3.Image = Properties.Resources.In_to_the_Woods_En_el_Bosqu;
pb3.Refresh();
pb4.Image = Properties.Resources.Ombis_Alien_Invasion__2015_;
pb4.Refresh();
pb5.Image = Properties.Resources.peliculas_2015_15_e1422754101215;
pb5.Refresh();
pb6.Image = Properties.Resources.peliculas_2015_rapido_furioso_4;
pb6.Refresh();
pb7.Image = Properties.Resources.images;
pb7.Refresh();*/
}
public IList<Models.Auto> GetAllAutos()
{
DataSet ds = new DataSet();
myCommand = new SqlDataAdapter("Select * from Auto", myConnection);
ds = new DataSet();
myCommand.Fill(ds);
IList<Models.Auto> AutoList = new List<Models.Auto>();
foreach (DataRow item in ds.Tables[0].Rows)
{
AutoList.Add(new Auto
{
AutoNumber = item["AutoNumber"].ToString(),
AutoName = item["AutoName"].ToString()
});
}
ds.Dispose();
ds = null;
return AutoList;
}
public SquadForm(DbConnect postgreConnect, DataSet globalDS, int squadID = -1)
{
InitializeComponent();
cbColumn = new DataGridViewCheckBoxColumn();
cbColumn.HeaderText = "Является сотрудником отряда";
cbColumn.DataPropertyName = "is_in_squad";
cbColumn.FillWeight = 40;
cbColumn.ReadOnly = false;
dataSet1 = globalDS;
postgreConnection = postgreConnect;
squadSelectBS.DataSource = dataSet1.Tables["squad"];
listBox1.DataSource = dataSet1.Tables["squad"];
listBox1.DisplayMember = "name";
listBox1.ValueMember = "id";
initEnd = true;
if (listBox1.SelectedValue != null)
ChangeSelectedSquad(int.Parse(listBox1.SelectedValue.ToString()));
else
DeactivateAllButtons();
SetButtonPermissions();
if (squadID != -1)
listBox1.SelectedValue = squadID;
bindingNavigator2.BindingSource = selectionsDataBS;
bindingNavigator1.BindingSource = employeesAddBS;
dataGridView1.DataSource = selectionsDataBS;
}
public DataSet GetAll(string empresaid, tb_co_tabla01_mediopago BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla01Mediopago_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigoid", SqlDbType.Char, 3).Value = BE.codigoid;
cmd.Parameters.Add("@descripcion", SqlDbType.VarChar, 100).Value = BE.descripcion;
cmd.Parameters.Add("@sigla", SqlDbType.Char, 3).Value = BE.sigla;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
protected void load_price()
{
string price_name = null;
string article = null;
price_name = Request.QueryString["price_name"];
article = Request.QueryString["article"];
if (article != null)
{
if (price_name != null)
{
SqlConnection con = new SqlConnection(str);
string sql = "SELECT id, article, ROUND([price]*(SELECT course FROM Course_USD WHERE id = 1),2) AS [price] FROM " + price_name + " WHERE article=" + article + ";";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds, price_name);
DataRow dr;
dr = ds.Tables[price_name].Rows[0];
//Заполняем стоимость товара:
lblprice.Text = dr["price"].ToString();
}
else {Response.Redirect("Error.aspx");}
}
else {Response.Redirect("Error.aspx"); }
}
/// <summary>
/// 根据faterid 获取组织机构树
/// </summary>
/// <returns></returns>
public DataSet GetORGTreeByID(Dbconn conn, String strType)
{
DataSet ds = new DataSet();
String strSQL = "";
//获取条件值
string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);
string strPage = dsXML.Tables["LIST"].Rows[0]["Page"].ToString();
string strNum = dsXML.Tables["LIST"].Rows[0]["Num"].ToString();
string strCons = dsXML.Tables["LIST"].Rows[0]["Cons"].ToString();
string strOrderBy = dsXML.Tables["LIST"].Rows[0]["OrderBy"].ToString();
string[] strParam = new string[] { };
strSQL = @" SELECT [OZ1_OrgCode], [OZ1_OrgName], [OZ1_FatherId]
, [OZ1_OrgType], [OZ1_ID], [OZ1_CONO], [OZ1_DIVI], [OZ1_FatherId] As [OZ1_FatherIdT]
, [OZ1_CostCenterCode], [OZ1_DepartmentManager]
, [OZ1_MDeptCode], [OZ1_ShopCode], [OZ1_OrgEnable]
, [OZ1_CostCenterEnable], [OZ1_BusdepartmentEnable]
, [OZ1_ShopEnable], [OZ1_State], [OZ1_ModelType], [OZ1_BMMoney]
, [OZ1_Brand], [OZ1_Com], [OZ1_CostCenterCode1], [OZ1_BMPer]
, OZ1_Com1, OZ1_ComCode1, OZ1_ISBranch, OZ1_CostCenterCode2
FROM [F01_CERT].[OZ1_Organization]
WHERE 1=1 AND OZ1_OrgType <> '业务线' " + strCons + strOrderBy;
ds = conn.GetDataSet(strSQL);
return ds;
}
public void BindData()
{
DataSet searchList = new DataSet();
StringBuilder builder = new StringBuilder();
if (this.txtKeyword.Text.Trim() != "")
{
builder.Append(" NickName like '%" + this.txtKeyword.Text + "%' ");
}
if (!string.IsNullOrEmpty(this.txtBeginTime.Text.Trim()))
{
if (builder.Length > 0)
{
builder.Append(" and ");
}
builder.Append(" convert(date,User_dateCreate)>='" + this.txtBeginTime.Text.Trim() + "' ");
}
if (Globals.SafeInt(this.dropType.SelectedValue, -1) > -1)
{
if (builder.Length > 0)
{
builder.Append(" and ");
}
builder.Append(" Activity=" + this.dropType.SelectedValue + " ");
}
if (!string.IsNullOrEmpty(this.txtEndTime.Text.Trim()))
{
if (builder.Length > 0)
{
builder.Append(" and ");
}
builder.Append(" convert(date,User_dateCreate)<='" + this.txtEndTime.Text.Trim() + "' ");
}
searchList = this.user.GetSearchList("UU", builder.ToString());
this.gridView.DataSetSource = searchList;
}
public UserAction GetUserDetails(string UserName)
{
try
{
oDatabaseHandler = new DatabaseHandler();
DataSet oDataSet = new DataSet();
oDataSet = oDatabaseHandler.FillData("select U.UserId,U.RoleId,R.[Role] RoleName,R.[Create],R.Edit,R.[View],R.Assign,R.Finish from Users as U "
+ " inner join Roles R on R.RoleId=U.RoleId"
+ " where U.UserName='******'");
if (oDataSet != null && oDataSet.Tables != null && oDataSet.Tables.Count > 0 && oDataSet.Tables[0].Rows != null && oDataSet.Tables[0].Rows.Count > 0)
{
UserAction oUserDetails = new UserAction();
//oUserDetails.Cus = int.Parse(oDataSet.Tables[0].Rows[0]["UserId"].ToString());
oUserDetails.UserName = UserName;// oDataSet.Tables[0].Rows[0]["UserId"].ToString();
oUserDetails.RoleID = int.Parse(oDataSet.Tables[0].Rows[0]["RoleId"].ToString());
oUserDetails.RoleName = oDataSet.Tables[0].Rows[0]["RoleName"].ToString();
oUserDetails.Create = bool.Parse(oDataSet.Tables[0].Rows[0]["Create"].ToString());
oUserDetails.Edit = bool.Parse(oDataSet.Tables[0].Rows[0]["Edit"].ToString());
oUserDetails.View = bool.Parse(oDataSet.Tables[0].Rows[0]["View"].ToString());
oUserDetails.Assign = bool.Parse(oDataSet.Tables[0].Rows[0]["Assign"].ToString());
oUserDetails.Finish = bool.Parse(oDataSet.Tables[0].Rows[0]["Finish"].ToString());
return oUserDetails;
}
return null;
}
catch (Exception ex)
{
}
return null;
}
private void BindData()
{
SqlDataSource1.DataBind();
//string sqlquery = "SELECT * FROM [ISBEPI_DEV].[dbo].[HomeVisitorSiteVisitSurvey] WHERE Schd_ID = 16";
DataTable dt = new DataTable();
DataSourceSelectArguments args = new DataSourceSelectArguments();
DataView view = (DataView)SqlDataSource1.Select(args);
dt = view.ToTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
DataSet new_ds = FlipDataSet(ds); // Flip the DataSet
DataView my_DataView = new_ds.Tables[0].DefaultView;
this.DataGrid1.DataSource = my_DataView;
this.DataGrid1.DataBind();
DataTable dt2 = new DataTable();
DataSourceSelectArguments args2 = new DataSourceSelectArguments();
DataView view2 = (DataView)SqlDataSource2.Select(args2);
dt2 = view2.ToTable();
DataSet ds2 = new DataSet();
ds2.Tables.Add(dt2);
DataSet new_ds2 = FlipDataSet(ds2); // Flip the DataSet
DataView my_DataView2 = new_ds2.Tables[0].DefaultView;
this.DataGrid2.DataSource = my_DataView2;
this.DataGrid2.DataBind();
}
public DataSet FlipDataSet(DataSet my_DataSet)
{
DataSet ds = new DataSet();
DataTable table = new DataTable();
foreach (DataTable dt in my_DataSet.Tables)
{
for (int i = 0; i <= dt.Rows.Count; i++)
{
table.Columns.Add(Convert.ToString(i));
}
for (int k = 0; k < dt.Columns.Count; k++)
{
r = table.NewRow();
r[0] = dt.Columns[k].ToString();
for (int j = 1; j <= dt.Rows.Count; j++)
r[j] = dt.Rows[j - 1][k];
table.Rows.Add(r);
}
ds.Tables.Add(table);
}
return ds;
}
public DataSet GetAll(string empresaid, tb_tipimpto BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbTipimpto_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid;
cmd.Parameters.Add("@status", SqlDbType.Bit).Value = BE.status;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public void challanout()
{
DataTable dt = new DataTable("challandt");
dt = (DataTable)Session["challanout_dt"];
DataSet ds = new DataSet();
Viewer.Report.ChallanOutrpt crystalReport = new Report.ChallanOutrpt();
string st = HttpContext.Current.Server.MapPath("~/ChallanOutCrpt1.rpt");
// Label1.Text = st;
// Response.Write(string.Format("<script language='javascript' type='text/javascript'>alert( "+st+") </script>"));
crystalReport.Load(st);
if (ds.Tables.Contains("challandt") == true)
{
ds.Tables.Remove("challandt");
}
ds.Tables.Add(dt);
ds.WriteXmlSchema(HttpContext.Current.Server.MapPath("~/App_Data/Challanout.xml"));
crystalReport.SetDataSource(dt);
CrystalReportViewer1.ReportSource = crystalReport;
crystalReport.ExportToHttpResponse
(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "CHALLANOUTSHEET");
}
public void process(ServiceRequest request, ServiceResponse response)
{
List<Category> list = new List<Category>();
string sqlStr = "select * from category";
MySqlConnection conn = ConnectionManager.getInstance().getConnection();
conn.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(sqlStr, conn);
DataSet ds = new DataSet();
mda.Fill(ds,"table1");
conn.Close();
int count = ds.Tables["table1"].Rows.Count;
for (int i = 0; i < count; i++)
{
Category c = new Category();
c.categoryId = (int)ds.Tables["table1"].Rows[i][0];
c.categoryName = (string)ds.Tables["table1"].Rows[i][1];
list.Add(c);
}
GetCategoryResponse serviceResponse = new GetCategoryResponse();
serviceResponse.categories = list;
response.responseObj = serviceResponse;
response.returnCode = 0;
}
public static int SaveRecord(string sql)
{
const int rv = 0;
try
{
string connectionString = ConfigurationManager.ConnectionStrings["LA3Access"].ConnectionString;
using (var conn = new OleDbConnection(connectionString))
{
conn.Open();
var cmGetID = new OleDbCommand("SELECT @@IDENTITY", conn);
var comm = new OleDbCommand(sql, conn) { CommandType = CommandType.Text };
comm.ExecuteNonQuery();
var ds = new DataSet();
var adapt = new OleDbDataAdapter(cmGetID);
adapt.Fill(ds);
adapt.Dispose();
cmGetID.Dispose();
return int.Parse(ds.Tables[0].Rows[0][0].ToString());
}
}
catch (Exception)
{
}
return rv;
}
