//更新客户记录
public bool updateCustomerData(Model_CustomerManager model)
{
OleDbParameter[] parameters = {
new OleDbParameter("@CustomerCompany", model.CustomerCompany),
new OleDbParameter("@CustomerContact", model.CustomerContact),
new OleDbParameter("@CustomerEmail", model.CustomerEmail),
new OleDbParameter("@CustomerPhone", model.CustomerPhone),
new OleDbParameter("@CustomerFax", model.CustomerFax),
new OleDbParameter("@CustomerUrl", model.CustomerUrl),
new OleDbParameter("@CustomerAddress", model.CustomerAddress),
new OleDbParameter("@CustomerNote", model.CustomerNote),
new OleDbParameter("@CustomerId", model.CustomerId), };
StringBuilder strSql = new StringBuilder();
strSql.Append("Update CustomerData Set ");
strSql.Append("company=@CustomerCompany,");
strSql.Append("contact=@CustomerContact,");
strSql.Append("email=@CustomerEmail,");
strSql.Append("phone=@CustomerPhone,");
strSql.Append("fax=@CustomerFax,");
strSql.Append("website=@CustomerUrl,");
strSql.Append("address=@CustomerAddress,");
strSql.Append("note=@CustomerNote");
strSql.Append(" where id=@CustomerId");
return DBhelper.ExecuteNonqueryBool(strSql.ToString(), parameters); //添加新客户记录
public bool addNewCustomer(Model_CustomerManager model, string dataTable)
{
OleDbParameter[] parameters = {
new OleDbParameter("@CustomerCompany", model.CustomerCompany),
new OleDbParameter("@CustomerContact", model.CustomerContact),
new OleDbParameter("@CustomerEmail", model.CustomerEmail),
new OleDbParameter("@CustomerPhone", model.CustomerPhone),
new OleDbParameter("@CustomerFax", model.CustomerFax),
new OleDbParameter("@CustomerUrl", model.CustomerUrl),
new OleDbParameter("@CustomerAddress", model.CustomerAddress),
new OleDbParameter("@CustomerNote", model.CustomerNote), }; return DBhelper.ExecuteNonqueryBool("insert into " + dataTable + " ( company,contact,email,phone,fax,website,address,note) values ( @CustomerCompany,@CustomerContact,@CustomerEmail,@CustomerPhone,@CustomerFax,@CustomerUrl,@CustomerAddress,@CustomerNote )", parameters);
}上面的的句子有错吗? 为什么都执行不了啊?看了半天看不出来.
public bool updateCustomerData(Model_CustomerManager model)
{
OleDbParameter[] parameters = {
new OleDbParameter("@CustomerCompany", model.CustomerCompany),
new OleDbParameter("@CustomerContact", model.CustomerContact),
new OleDbParameter("@CustomerEmail", model.CustomerEmail),
new OleDbParameter("@CustomerPhone", model.CustomerPhone),
new OleDbParameter("@CustomerFax", model.CustomerFax),
new OleDbParameter("@CustomerUrl", model.CustomerUrl),
new OleDbParameter("@CustomerAddress", model.CustomerAddress),
new OleDbParameter("@CustomerNote", model.CustomerNote),
new OleDbParameter("@CustomerId", model.CustomerId), };
StringBuilder strSql = new StringBuilder();
strSql.Append("Update CustomerData Set ");
strSql.Append("company=@CustomerCompany,");
strSql.Append("contact=@CustomerContact,");
strSql.Append("email=@CustomerEmail,");
strSql.Append("phone=@CustomerPhone,");
strSql.Append("fax=@CustomerFax,");
strSql.Append("website=@CustomerUrl,");
strSql.Append("address=@CustomerAddress,");
strSql.Append("note=@CustomerNote");
strSql.Append(" where id=@CustomerId");
return DBhelper.ExecuteNonqueryBool(strSql.ToString(), parameters); //添加新客户记录
public bool addNewCustomer(Model_CustomerManager model, string dataTable)
{
OleDbParameter[] parameters = {
new OleDbParameter("@CustomerCompany", model.CustomerCompany),
new OleDbParameter("@CustomerContact", model.CustomerContact),
new OleDbParameter("@CustomerEmail", model.CustomerEmail),
new OleDbParameter("@CustomerPhone", model.CustomerPhone),
new OleDbParameter("@CustomerFax", model.CustomerFax),
new OleDbParameter("@CustomerUrl", model.CustomerUrl),
new OleDbParameter("@CustomerAddress", model.CustomerAddress),
new OleDbParameter("@CustomerNote", model.CustomerNote), }; return DBhelper.ExecuteNonqueryBool("insert into " + dataTable + " ( company,contact,email,phone,fax,website,address,note) values ( @CustomerCompany,@CustomerContact,@CustomerEmail,@CustomerPhone,@CustomerFax,@CustomerUrl,@CustomerAddress,@CustomerNote )", parameters);
}上面的的句子有错吗? 为什么都执行不了啊?看了半天看不出来.
解决方案 »
- hai
- 命名空间system中不存在类型或命名空间名称NET,是否缺少程序集引用?
- 如何操作Excel的行copy命令
- 高手们来帮我解决一下自定义控件的问题
- 在textbox中输入的值按照0.000.000的格式.不知道怎么写?在线等.
- DataGridView绑定IList<T>实时更新问题
- 在循环中如何判断按钮是否按下
- 100分求助!C#程序实现数据库创建表,并从另一个数据库中倒数据!
- 如何在鼠标点击DataGrid时得到列标题?
- 简单问题!case如何使用啊?
- 将string numStr = "1234.56789";分别转换为int ,float , double,并输出结果
- listview居中
不加类型的参数吗??
OleDbParameter("@CustomerCompany", model.CustomerCompany)