/// <summary>
/// 更新一条数据
/// </summary>
public bool Updatetax(QAMZN.Model.tb_user_tax model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_user_tax set ");
strSql.Append("receive_income=@receive_income,");
strSql.Append("is_usperson=@is_usperson,");
strSql.Append("company_name=@company_name,");
strSql.Append("nationality=@nationality,");
strSql.Append("owner_type=@owner_type,");
strSql.Append("address_id=@address_id,");
strSql.Append("mailing_address_id=@mailing_address_id,");
strSql.Append("is_esignature=@is_esignature,");
strSql.Append("user_id=@user_id,");
strSql.Append("createtime=@createtime,");
strSql.Append("signature=@signature");
strSql.Append(" where tax_id=@tax_id");
SqlParameter[] parameters =
{
new SqlParameter("@receive_income", SqlDbType.Int, 4),
new SqlParameter("@is_usperson", SqlDbType.Int, 4),
new SqlParameter("@company_name", SqlDbType.VarChar, 100),
new SqlParameter("@nationality", SqlDbType.VarChar, 100),
new SqlParameter("@owner_type", SqlDbType.Int, 4),
new SqlParameter("@address_id", SqlDbType.Int, 4),
new SqlParameter("@mailing_address_id", SqlDbType.Int, 4),
new SqlParameter("@is_esignature", SqlDbType.Int, 4),
new SqlParameter("@user_id", SqlDbType.Int, 4),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@signature", SqlDbType.VarChar, 100),
new SqlParameter("@tax_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.receive_income;
parameters[1].Value = model.is_usperson;
parameters[2].Value = model.company_name;
parameters[3].Value = model.nationality;
parameters[4].Value = model.owner_type;
parameters[5].Value = model.address_id;
parameters[6].Value = model.mailing_address_id;
parameters[7].Value = model.is_esignature;
parameters[8].Value = model.user_id;
parameters[9].Value = DateTime.Now;
parameters[10].Value = model.signature;
parameters[11].Value = model.tax_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取地址编号和法定公司名称
/// </summary>
/// <param name="userid"></param>
/// <param name="address_id"></param>
/// <param name="company_name"></param>
public void GetUerTaxInfo(int userid, ref int address_id, ref string company_name, ref int tax_id)
{
model = dal.GetUerTaxInfo(userid);
if (model != null)
{
address_id = (int)model.address_id;
company_name = model.company_name;
tax_id = model.tax_id;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public QAMZN.Model.tb_user_tax DataRowToModel(DataRow row)
{
QAMZN.Model.tb_user_tax model = new QAMZN.Model.tb_user_tax();
if (row != null)
{
if (row["tax_id"] != null && row["tax_id"].ToString() != "")
{
model.tax_id = int.Parse(row["tax_id"].ToString());
}
if (row["receive_income"] != null && row["receive_income"].ToString() != "")
{
model.receive_income = int.Parse(row["receive_income"].ToString());
}
if (row["is_usperson"] != null && row["is_usperson"].ToString() != "")
{
model.is_usperson = int.Parse(row["is_usperson"].ToString());
}
if (row["company_name"] != null)
{
model.company_name = row["company_name"].ToString();
}
if (row["nationality"] != null)
{
model.nationality = row["nationality"].ToString();
}
if (row["owner_type"] != null && row["owner_type"].ToString() != "")
{
model.owner_type = int.Parse(row["owner_type"].ToString());
}
if (row["address_id"] != null && row["address_id"].ToString() != "")
{
model.address_id = int.Parse(row["address_id"].ToString());
}
if (row["mailing_address_id"] != null && row["mailing_address_id"].ToString() != "")
{
model.mailing_address_id = int.Parse(row["mailing_address_id"].ToString());
}
if (row["is_esignature"] != null && row["is_esignature"].ToString() != "")
{
model.is_esignature = int.Parse(row["is_esignature"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["createtime"] != null && row["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(row["createtime"].ToString());
}
}
return(model);
}
/// <summary>
/// 初始化税务信息
/// </summary>
/// <param name="registered_address">永久地址ID</param>
/// /// <param name="mailing_address_id">邮寄地址ID</param>
/// <param name="strTax">字符串</param>
public void GetTaxInfo(int userid, ref string strTax, ref int?address_id, ref int?mailing_address_id)
{
model = dal.GetTaxInfo(userid);
if (model != null)
{
address_id = model.address_id;
mailing_address_id = model.mailing_address_id;
//tax_id,receive_income,is_usperson,company_name,nationality,owner_type,address_id,mailing_address_id,is_esignature,user_id
strTax = "\"tax_id\":\"" + model.tax_id + "\",\"receive_income\":\""
+ model.receive_income + "\",\"is_usperson\":\""
+ model.is_usperson + "\",\"company_name\":\""
+ model.company_name + "\",\"nationality\":\""
+ model.nationality + "\",\"owner_type\":\""
+ model.owner_type + "\",\"is_esignature\":\""
+ model.is_esignature + "\",\"signature\":\""
+ model.signature + "\"";
}
else
{
strTax = "";
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public QAMZN.Model.tb_user_tax GetModel(int tax_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 tax_id,receive_income,is_usperson,company_name,nationality,owner_type,address_id,mailing_address_id,is_esignature,user_id,createtime from tb_user_tax ");
strSql.Append(" where tax_id=@tax_id");
SqlParameter[] parameters =
{
new SqlParameter("@tax_id", SqlDbType.Int, 4)
};
parameters[0].Value = tax_id;
QAMZN.Model.tb_user_tax model = new QAMZN.Model.tb_user_tax();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
