/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XHD.Model.crm_contact_bill model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update crm_contact_bill set ");
strSql.Append("customer_id=@customer_id,");
strSql.Append("user_id=@user_id,");
strSql.Append("invoice_type=@invoice_type,");
strSql.Append("tax_company_name=@tax_company_name,");
strSql.Append("tax_company_add_tel=@tax_company_add_tel,");
strSql.Append("tax_tax_code=@tax_tax_code,");
strSql.Append("tax_bank_name=@tax_bank_name,");
strSql.Append("tax_bank_num=@tax_bank_num,");
strSql.Append("is_tax_for_billing=@is_tax_for_billing");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@invoice_type", MySqlDbType.Int32, 2),
new MySqlParameter("@tax_company_name", MySqlDbType.VarChar, 40),
new MySqlParameter("@tax_company_add_tel", MySqlDbType.VarChar, 120),
new MySqlParameter("@tax_tax_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@tax_bank_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@tax_bank_num", MySqlDbType.VarChar, 20),
new MySqlParameter("@is_tax_for_billing", MySqlDbType.Int32, 2),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.customer_id;
parameters[1].Value = model.user_id;
parameters[2].Value = model.invoice_type;
parameters[3].Value = model.tax_company_name;
parameters[4].Value = model.tax_company_add_tel;
parameters[5].Value = model.tax_tax_code;
parameters[6].Value = model.tax_bank_name;
parameters[7].Value = model.tax_bank_num;
parameters[8].Value = model.is_tax_for_billing;
parameters[9].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.crm_contact_bill DataRowToModel(DataRow row)
{
XHD.Model.crm_contact_bill model = new XHD.Model.crm_contact_bill();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["customer_id"] != null && row["customer_id"].ToString() != "")
{
model.customer_id = int.Parse(row["customer_id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["invoice_type"] != null && row["invoice_type"].ToString() != "")
{
model.invoice_type = int.Parse(row["invoice_type"].ToString());
}
if (row["tax_company_name"] != null)
{
model.tax_company_name = row["tax_company_name"].ToString();
}
if (row["tax_company_add_tel"] != null)
{
model.tax_company_add_tel = row["tax_company_add_tel"].ToString();
}
if (row["tax_tax_code"] != null)
{
model.tax_tax_code = row["tax_tax_code"].ToString();
}
if (row["tax_bank_name"] != null)
{
model.tax_bank_name = row["tax_bank_name"].ToString();
}
if (row["tax_bank_num"] != null)
{
model.tax_bank_num = row["tax_bank_num"].ToString();
}
if (row["is_tax_for_billing"] != null && row["is_tax_for_billing"].ToString() != "")
{
model.is_tax_for_billing = int.Parse(row["is_tax_for_billing"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XHD.Model.crm_contact_bill model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into crm_contact_bill(");
strSql.Append("id,customer_id,user_id,invoice_type,tax_company_name,tax_company_add_tel,tax_tax_code,tax_bank_name,tax_bank_num,is_tax_for_billing)");
strSql.Append(" values (");
strSql.Append("@id,@customer_id,@user_id,@invoice_type,@tax_company_name,@tax_company_add_tel,@tax_tax_code,@tax_bank_name,@tax_bank_num,@is_tax_for_billing)");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@invoice_type", MySqlDbType.Int32, 2),
new MySqlParameter("@tax_company_name", MySqlDbType.VarChar, 40),
new MySqlParameter("@tax_company_add_tel", MySqlDbType.VarChar, 120),
new MySqlParameter("@tax_tax_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@tax_bank_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@tax_bank_num", MySqlDbType.VarChar, 20),
new MySqlParameter("@is_tax_for_billing", MySqlDbType.Int32, 2)
};
parameters[0].Value = model.id;
parameters[1].Value = model.customer_id;
parameters[2].Value = model.user_id;
parameters[3].Value = model.invoice_type;
parameters[4].Value = model.tax_company_name;
parameters[5].Value = model.tax_company_add_tel;
parameters[6].Value = model.tax_tax_code;
parameters[7].Value = model.tax_bank_name;
parameters[8].Value = model.tax_bank_num;
parameters[9].Value = model.is_tax_for_billing;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.crm_contact_bill GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,customer_id,user_id,invoice_type,tax_company_name,tax_company_add_tel,tax_tax_code,tax_bank_name,tax_bank_num,is_tax_for_billing from crm_contact_bill ");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = id;
XHD.Model.crm_contact_bill model = new XHD.Model.crm_contact_bill();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
