public int update(Model.deliveryaddress deliveryaddress)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("update deliveryaddress set ");
strsql.AppendFormat(" company =N'{0}',", deliveryaddress.company);
strsql.AppendFormat(" provence =N'{0}',", deliveryaddress.provence);
strsql.AppendFormat(" address =N'{0}'", deliveryaddress.address);
strsql.AppendFormat(" where id={0}", deliveryaddress.id);
return(sql.ExecuteNonQuery(strsql.ToString()));
}
public int Add(Model.deliveryaddress deliveryaddress)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("insert into deliveryaddress values (");
strsql.AppendFormat("N'{0}',", deliveryaddress.company);
strsql.AppendFormat("N'{0}',", deliveryaddress.provence);
strsql.AppendFormat("N'{0}'", deliveryaddress.address);
strsql.Append(") select SCOPE_IDENTITY()");
return(Convert.ToInt32(sql.ExecuteSc(strsql.ToString())));
}
public Model.deliveryaddress getdeliveryaddress(Model.deliveryaddress deliveryaddress1)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select * from deliveryaddress where ");
strsql.AppendFormat("id='{0}'", deliveryaddress1.id);
DataTable dt = sql.ExecuteDataSet(strsql.ToString()).Tables[0];
if (dt.Rows.Count < 1)
{
return(null);
}
Model.deliveryaddress deliveryaddress = new Model.deliveryaddress();
deliveryaddress.id = deliveryaddress1.id;
deliveryaddress.company = dt.Rows[0]["company"].ToString();
deliveryaddress.provence = dt.Rows[0]["provence"].ToString();
deliveryaddress.address = dt.Rows[0]["address"].ToString();
return(deliveryaddress);
}
public int Add(Model.deliveryaddress deliveryaddress)
{
return(itu.Add(deliveryaddress));
}
public int update(Model.deliveryaddress deliveryaddress)
{
return(itu.update(deliveryaddress));
}
public Model.deliveryaddress getdeliveryaddress(Model.deliveryaddress deliveryaddress1)
{
return(itu.getdeliveryaddress(deliveryaddress1));
}
