public bool insertNewNode(ProductsPhoto p)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ProductsID", SqlDbType.Int), new SqlParameter("@PhotoUrl", SqlDbType.NVarChar) };
parameters[0].Value = p.ProductsID;
parameters[1].Value = p.PhotoUrl;
SQLHelper.RunProcedure("p_ProductsPhoto_insertNewNode", parameters, out rowsAffected);
return(1 == rowsAffected);
}
public List <ProductsPhoto> getListByProductsID(int ProductsID)
{
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ProductsID", SqlDbType.Int) };
parameters[0].Value = ProductsID;
List <ProductsPhoto> list = new List <ProductsPhoto>();
SqlDataReader reader = SQLHelper.RunProcedure("p_ProductsPhoto_getByProductsID", parameters);
while (reader.Read())
{
ProductsPhoto item = new ProductsPhoto();
item.ID = reader.GetInt32(reader.GetOrdinal("ID"));
item.ProductsID = reader.GetInt32(reader.GetOrdinal("ProductsID"));
item.PhotoUrl = reader.GetString(reader.GetOrdinal("PhotoUrl"));
list.Add(item);
}
reader.Close();
return(list);
}
/// <summary>
/// 上传之后动作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Imageuploader2_Uploaded(object sender, EventArgs e)
{
string pid = PID.Text.ToString();
string purl = Imageuploader2.PicSavedName;
ProductsPhoto p = new ProductsPhoto();
p.ProductsID = int.Parse(pid);
p.PhotoUrl = purl;
if (Leyp.SQLServerDAL.Factory.getProductsPhotoDAL().insertNewNode(p))
{
Imageuploader2.DefaultPreviewImageURL = "";
Jscript.AjaxAlert(this, "上传成功！");
Response.Redirect("Products_Photo_Attach.aspx?action=view&ProductsID=" + PID.Text.ToString(), true);
return;
}
else
{
Jscript.AjaxAlert(this, "操作失败！");
return;
}
}
