(请大家讨论)ERP\MES\SFCS\SLM\OA系统常用功能模块及代码
RT,谢谢。。。 --------------------编程问答-------------------- 冒泡接分太大了吧 --------------------编程问答-------------------- 不用谢. --------------------编程问答-------------------- (1)ViewState传值
//Page_001的方法1,给变量赋值
ViewState["nameID"]="0001";
//Page_001的方法2,读取数据
string NameID=ViewState["nameID"].ToString();
//同一页面中定义全局的DataSet******Begin
private DataSet Ds
{
get
{
if (ViewState["ds"] == null)
return new DataSet();
else
return (DataSet)ViewState["ds"];
}
set
{
ViewState["ds"] = value;
}
}
//显示数据
private void Data_Bind()
{
GetInfo();
gvInfo.DataSource = Ds;
if (Ds.Tables.Count > 0)
{
gvInfo.DataBind();
}
}
private bool GetInfo()
{
try
{
Ds = DataHelper.ExecuteDataset(CommandType.Text, which_SQL);
if (Ds != null && Ds.Tables[0].Rows.Count > 0)
return true;
else
return false;
}
}
protected void gvInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvInfo.PageIndex = e.NewPageIndex;
gvInfo.DataSource = Ds;
gvInfo.DataBind();
}
//同一页面中定义全局的DataSet******End
(2)通过URL传值
//Page_001给参数赋值
Response.Redirect("../Folder1/Page_002.aspx?userName=" + str_user);
//Page_002取参数值
this.userName.Text = Request.QueryString["userName"];
(3)Session传值
//Page_001的方法1,给参数赋值
Session["username"] = "zhouhuan";
Response.Redirect("Page_002.aspx");
//Page_001的方法2,接收参数值
string str_username = Session["username"].ToString();
//Page_002接收参数值
string str_username = Session["username"].ToString();
(4)******Cookie对象(无法取出值)*******
//存放信息
Response.Cookies["UserID"].Value="0001";
//读取信息
string UserID=Response.Cookies["UserID"].Value; --------------------编程问答-------------------- 这问题也太大了,大得没边了
我一般的处理方式是
建立需求、设计
生成数据表(数据表一定要设计合理)
通过CodeSmith生成数据实体
然后再处理界面
至于数据实体怎么与数据库之间的读写操作,是一个自己写好了N久的模板,说白了也就是通过反射模式生成相应的SQL语句来处理的 --------------------编程问答-------------------- //通过Java脚本进行页面传值
//在页面Page_01中给参数赋值
protected void btn_Update_Click(object sender, EventArgs e)
{
int i = 获取选中DataGridView的行号
if (i != -1)
{
str_Ket = gvInfo.Rows[i].Cells[1].Text;
this.Script("window.open('Page_02.aspx?operation=Update"
+ "&UserName=" + str_UserName
+ "','更新数据','location=0,resizable=1,height=300,width=700')");
}
else
{
//提示没有选择某条记录
}
}
在页面Page_02中取出数据,使用Request["UserName"]来取出数据; --------------------编程问答-------------------- ViewState传值Session传值 页面传值
看来lz还是有好方法的
这些都是系统瘫痪的最佳方法 --------------------编程问答-------------------- 关注 --------------------编程问答-------------------- public static OracleParameter CreateParameter(string name, OracleType dbType, ParameterDirection direction, object paramValue)
{
OracleParameter param = DataFactory.CreateParameter();
param.ParameterName = name;
param.OracleType = dbType;
param.Direction = direction;
if (!(direction == ParameterDirection.Output))
{
param.Value = paramValue;
}
return param;
}
public static OracleParameter CreateParameter(string name, OracleType dbType, int size, ParameterDirection direction, object paramValue)
{
OracleParameter param = DataFactory.CreateParameter();
param.ParameterName = name;
param.OracleType = dbType;
param.Size = size;
param.Direction = direction;
if (!(direction == ParameterDirection.Output))
{
param.Value = paramValue;
}
return param;
}
public static int ExecuteNonQuery(CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
using (IDbConnection cn = DataFactory.CreateConnection())
{
cn.ConnectionString = ConnStr;
cn.Open();
IDbCommand cmd = DataFactory.CreateCommand();
PrepareCommand(cn, null, cmd, commandType, commandText, commandParameters);
int retval;
try
{
retval = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Parameters.Clear();
cn.Close();
}
return retval;
}
}
public static object ExecuteScalar(CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
using (IDbConnection cn = DataFactory.CreateConnection())
{
cn.ConnectionString = ConnStr;
cn.Open();
IDbCommand cmd = DataFactory.CreateCommand();
PrepareCommand(cn, null, cmd, commandType, commandText, commandParameters);
object retval;
try
{
retval = cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Parameters.Clear();
cn.Close();
}
return retval;
}
}
public static IDataReader ExecuteReader(CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
using (IDbConnection cn = DataFactory.CreateConnection())
{
cn.ConnectionString = ConnStr;
cn.Open();
IDbCommand cmd = DataFactory.CreateCommand();
PrepareCommand(cn, null, cmd, commandType, commandText, commandParameters);
IDataReader dr;
try
{
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
throw ex;
}
return dr;
}
}
public static DataSet ExecuteDataset(CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
using (IDbConnection cn = DataFactory.CreateConnection())
{
cn.ConnectionString = ConnStr;
cn.Open();
IDbCommand cmd = DataFactory.CreateCommand();
PrepareCommand(cn, null, cmd, commandType, commandText, commandParameters);
IDbDataAdapter da = DataFactory.CreateDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
try
{
da.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Parameters.Clear();
cn.Close();
}
return ds;
}
}
public static DataTable ExecuteWithDataTable(CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
using (IDbConnection cn = DataFactory.CreateConnection())
{
cn.ConnectionString = ConnStr;
cn.Open();
IDbCommand cmd = DataFactory.CreateCommand();
PrepareCommand(cn, null, cmd, commandType, commandText, commandParameters);
IDbDataAdapter da = DataFactory.CreateDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
try
{
da.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Parameters.Clear();
cn.Close();
}
return ds.Tables[0];
}
}
private static void AttachParameters(IDbCommand command, OracleParameter[] commandParameters)
{
foreach (OracleParameter p in commandParameters)
{
if ((p.Direction == ParameterDirection.InputOutput) && (p.Value == null))
{
p.Value = DBNull.Value;
}
command.Parameters.Add(p);
}
}
private static void PrepareCommand(IDbConnection connection, IDbTransaction trans, IDbCommand command, CommandType commandType, string commandText, OracleParameter[] commandParameters)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.Connection = connection;
command.CommandText = commandText;
if (trans != null)
{
command.Transaction = trans;
}
command.CommandType = commandType;
if (commandParameters != null)
{
AttachParameters(command, commandParameters);
}
return;
}
--------------------编程问答-------------------- //数据从DataGridView导出到Excel
public void Report(DataSet ds, string fileName)
{
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.Charset = "";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment;filename=\"" + fileName + "\"");
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[0];
dg.DataBind();
dg.RenderControl(htw);
response.Write(sw.ToString());
response.End();
}
}
}
public void Export(DataSet ds, string fileName)
{
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.Charset = "";
HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");
string strfileName = HttpUtility.UrlEncode(fileName + ".xls", Encoding.GetEncoding("utf-8"));
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + strfileName);
using (System.IO.StringWriter sw = new System.IO.StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[0];
dg.DataBind();
dg.RenderControl(htw);
response.Write(sw.ToString());
response.End();
}
}
} --------------------编程问答-------------------- 学习了 --------------------编程问答-------------------- ding... --------------------编程问答-------------------- 这是什么东东呀?
补充:.NET技术 , ASP.NET