#region 通用查询语句,根据查询结果返回对应的值; public void ResultThreeValue(int myFlag,string myDepartid) {
string strSQL=""; string strConst="Jcbz"; switch (myFlag) { case 1: strSQL="Select BIGCODE,BIGNAME,MEMO from CQSIYO.KIND_BIG where BIGCODE='"+myDepartid+"'"; break; case 2: strSQL ="Select max(Substr(rtrim(ltrim(jcdwbm )),1,2)) as robin from JCDW "+ " where rtrim(ltrim(jcdwbm))<>'"+strConst+"'"; break; default: strSQL=""; break; }
string strConn="Provider=msdaora;Data Source=robin;User Id=cqsiyo;Password=robinsoft;"; OleDbConnection conn=new OleDbConnection(strConn); if (conn.State==ConnectionState.Closed) { conn.Open(); } OleDbCommand cmd= new OleDbCommand(strSQL,conn); OleDbDataReader dr = cmd.ExecuteReader(); try { switch (myFlag) { case 1: if (dr.Read()) { myBigCode=dr["BIGCODE"].ToString(); myBigName=dr["BIGNAME"].ToString(); myMemo=dr["MEMO"].ToString();
是从表示层调用中间层计算的值吗:
直接让函数或方法返回这个值(return a ;),或把3个值放在一个结构里返回这个结构也可以
再就是中间层可以设计类的对象,把这个值设计成对象的属性,表示层得到对象属性也可如果是中间层调用表示层(aspx)的话
直接把值传进去就可以了
兄弟,这个贴子是我开的,问题已解决,现在解决办法贴出来,看您急得:)
1:定义区
#region 字段定义区
/// <summary>
/// 定义数据集
/// </summary>
//private DataSet ds;
/// <summary>
/// 定义内存表
/// </summary>
public string myBigCode,myBigName,myMemo;
#endregion2:获取三个或者多个值:
#region 通用查询语句,根据查询结果返回对应的值;
public void ResultThreeValue(int myFlag,string myDepartid)
{
string strSQL="";
string strConst="Jcbz";
switch (myFlag)
{
case 1:
strSQL="Select BIGCODE,BIGNAME,MEMO from CQSIYO.KIND_BIG where BIGCODE='"+myDepartid+"'";
break;
case 2:
strSQL ="Select max(Substr(rtrim(ltrim(jcdwbm )),1,2)) as robin from JCDW "+
" where rtrim(ltrim(jcdwbm))<>'"+strConst+"'";
break;
default:
strSQL="";
break;
}
string strConn="Provider=msdaora;Data Source=robin;User Id=cqsiyo;Password=robinsoft;";
OleDbConnection conn=new OleDbConnection(strConn);
if (conn.State==ConnectionState.Closed)
{
conn.Open();
}
OleDbCommand cmd= new OleDbCommand(strSQL,conn);
OleDbDataReader dr = cmd.ExecuteReader();
try
{
switch (myFlag)
{
case 1:
if (dr.Read())
{
myBigCode=dr["BIGCODE"].ToString();
myBigName=dr["BIGNAME"].ToString();
myMemo=dr["MEMO"].ToString();
}
break;
case 2:
break;
default:
break;
}
}
catch
{
}
finally
{
dr.Close();
cmd.Dispose();
this.conn.Close();
this.conn.Dispose();
}
}
#endregion3:定义实例:
#region 实例定义区
private robinsoft.dataaccess.connection.LoginStruct LoginStruct=new LoginStruct();
private robinsoft.dataaccess.connection.NoDataAccess NoDataAccess=new NoDataAccess(); #endregion
4:调用:
Textbox3.Text=LoginStruct.myBigCode;
Textbox1.Text=LoginStruct.myBigName;
Textbox2.Text=LoginStruct.myMemo;您明白了不,如果还不明白,我愿意帮您!又新一个您必须重视的问题,我又要开贴了。。希望您能参与,我和大家都很高兴!!!!
http://expert.csdn.net/Expert/topic/2894/2894221.xml?temp=.3888819