/// <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); } }