附源代码(包括数据库)下载地址
http://www.lz.net.cn/WebForm2.rar
---欢迎讨论,共同学习!————
http://www.lz.net.cn/WebForm2.rar
---欢迎讨论,共同学习!————
解决方案 »
- asp.net没有时间控件吗?
- DEVexpress发布的问题(求助高手 貌似是什么GAC)
- asp.net 使用SMTP发送邮件,提示邮箱不可用,在线等。。。急。。。
- 急!如何做web安装程序包,以及升级程序的制作?
- 告诉大家几条内幕消息
- 弹出页面中的下载问题!
- 關於:Error 16:The type name 'CustomTextBox' does not exist in the type 'CustomControl.CustomControl'
- 如何用vbscript or javascript接受URL?file=office.xls中参数的file值?
- 类似这个论坛风格的源码哪里有下载啊?
- 小组联合开发,怎么样才能避免老是出现“你打开的项目已修改,你是否确定重载”
- 从提交form中获取数据的问题(在线求解)
- 关于Sql语句返回格式的问题!
吼吼
using System;
using System.Data;
using System.Data.SqlClient;
namespace BidData
{
/// <summary>
/// BaseAreaCityData 的摘要说明。
/// </summary>
public class BaseAreaCityData:DataSet
{
public const String CITY_TABLE_NAME = "t_bid_base_area_city";
public const String CITY_ID = "bac_CityId";
public const String NATION_ID = "ban_NationId";
public const String POVINCE_ID = "bap_PovinceId";
public const String CITY_NAME = "bac_CityName";
public const String REMARK = "bac_Re";
private DataTable _CityTable;
private SqlConnection conn = new Conn().GetConn(); public BaseAreaCityData()
{
//
// TODO: 在此处添加构造函数逻辑
//
BuildCityTable();
} public BaseAreaCityData(String ProvinceID)
{
BuildCityTable();
this.SelectCity(-1,Decimal.Parse(ProvinceID),"");
} private void BuildCityTable()
{
_CityTable = new DataTable(CITY_TABLE_NAME);
DataColumnCollection columns = _CityTable.Columns;
columns.Add(CITY_ID,typeof(Decimal));
columns.Add(NATION_ID,typeof(Decimal));
columns.Add(POVINCE_ID,typeof(Decimal));
columns.Add(CITY_NAME,typeof(String));
columns.Add(REMARK,typeof(String));
this.Tables.Add(_CityTable);
}
public int DeleteCity(Decimal CityId)
{
SqlCommand cmd = new SqlCommand("p_bid_base_area_city_delete",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@bac_CityId",SqlDbType.Decimal);
cmd.Parameters["@bac_CityId"].Value = CityId;
int intResult = 0;
try
{
intResult = cmd.ExecuteNonQuery();
}
catch
{
throw new Exception("删除存储过程执行错误");
}
return intResult;
}
public int GetAllCity()
{
String strSql = "select * from " + CITY_TABLE_NAME;
SqlDataAdapter sda = new SqlDataAdapter(strSql,conn);
sda.Fill(this,CITY_TABLE_NAME);
return this.Tables[CITY_TABLE_NAME].Rows.Count;
}
public int InsertCity(
Decimal NationId,
Decimal PovinceId,
String CityName,
String Re
)
{
SqlCommand cmd = new SqlCommand("p_bid_base_area_city_insert",conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameterCollection paramCompany = cmd.Parameters;
paramCompany.Add("@ban_NationId",SqlDbType.Decimal);
paramCompany["@ban_NationId"].Value = NationId;
paramCompany.Add("@bap_PovinceId",SqlDbType.Decimal);
paramCompany["@bap_PovinceId"].Value = PovinceId;
paramCompany.Add("@bac_CityName",SqlDbType.VarChar,60);
paramCompany["@bac_CityName"].Value = CityName;
paramCompany.Add("@bac_Re",SqlDbType.VarChar,200);
paramCompany["@bac_Re"].Value = Re;
int intResult = 0;
try
{
intResult = cmd.ExecuteNonQuery();
}
catch
{
throw new Exception("插入存储过程执行错误");
}
return intResult;
}
public int SelectCity(
Decimal CityID,
Decimal ProvinceID,
String CityName
)
{
SqlCommand cmd = new SqlCommand("p_bid_base_area_city_select",conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameterCollection paramCompany = cmd.Parameters;
paramCompany.Add("@bac_CityID",SqlDbType.Decimal);
paramCompany["@bac_CityID"].Value = CityID;
paramCompany.Add("@bap_PovinceId",SqlDbType.Decimal);
paramCompany["@bap_PovinceId"].Value = ProvinceID;
paramCompany.Add("@bac_CityName",SqlDbType.VarChar,60);
paramCompany["@bac_CityName"].Value = CityName;
SqlDataAdapter sda = new SqlDataAdapter("",conn);
sda.SelectCommand = cmd;
int intResult = 0;
try
{
sda.Fill(this,CITY_TABLE_NAME);
intResult = this.Tables[CITY_TABLE_NAME].Rows.Count;
}
catch
{
throw new Exception("查询存储过程执行错误");
}
return intResult;
}
public int UpdateCity(
Decimal CityId,
Decimal NationId,
Decimal PovinceId,
String CityName,
String Re
)
{
SqlCommand cmd = new SqlCommand("p_bid_base_area_city_update",conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameterCollection paramCompany = cmd.Parameters;
paramCompany.Add("@bac_CityId",SqlDbType.Decimal);
paramCompany["@bac_CityId"].Value = CityId;
paramCompany.Add("@ban_NationId",SqlDbType.Decimal);
paramCompany["@ban_NationId"].Value = NationId;
paramCompany.Add("@bap_PovinceId",SqlDbType.Decimal);
paramCompany["@bap_PovinceId"].Value = PovinceId;
paramCompany.Add("@bac_CityName",SqlDbType.VarChar,60);
paramCompany["@bac_CityName"].Value = CityName;
paramCompany.Add("@bac_Re",SqlDbType.VarChar,200);
paramCompany["@bac_Re"].Value = Re;
int intResult = 0;
try
{
intResult = cmd.ExecuteNonQuery();
}
catch
{
throw new Exception("更新存储过程执行错误");
}
return intResult;
} public DataTable CityTable
{
get
{
return _CityTable;
}
} }
}
在页面中,可以这么调用:
private void SaveCity()
{
Baseareacitydata City = New Baseareacitydata();
City.Updatecity(Decimal.Parse(Lsbcity.Selectedvalue),Decimal.Parse(Ddlnation.Selectedvalue),Decimal.Parse(Ddlprovince.Selectedvalue),Txtcityname.Text,Txtcityre.Text);
}
请问是什么原因,谢谢!
Products.aspx.cs(11): 找不到类型或命名空间名称“BusinessClass”(是否缺少 using 指令或程序集引用?)