1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12using System.IO;
 13
 14public partial class Manager_Album : System.Web.UI.Page
 15...{
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!Page.IsPostBack)
 19        ...{
 20
 21            BindAlbum();
 22
 23        }
 24    }
 25    private void BindAlbum()
 26    ...{
 27
 28        AlbumDataList.DataSource = SqlHelper.ExcuteReadApdater("sys_SelectAlbum", CommandType.StoredProcedure, null);
 29        AlbumDataList.DataKeyField = "Id";
 30        AlbumDataList.DataBind();
 31
 32
 33    }
 34    protected string IsBool(string Isbool)
 35    ...{
 36
 37        string nId = string.Empty;
 38        if (Isbool.ToLower() == "true")
 39        ...{
 40
 41            nId = "1";
 42
 43        }
 44        else
 45        ...{
 46
 47            nId = "0";
 48
 49        }
 50        return nId;
 51
 52    }
 53    protected void AlbumDataList_CancelCommand(object source, DataListCommandEventArgs e)
 54    ...{
 55        AlbumDataList.EditItemIndex = -1;
 56        BindAlbum();
 57    }
 58    protected void AlbumDataList_DeleteCommand(object source, DataListCommandEventArgs e)
 59    ...{
 60        int nId = int.Parse(AlbumDataList.DataKeys[e.Item.ItemIndex].ToString());
 61        SqlParameter[] paras =...{ new SqlParameter("@Id", SqlDbType.Int, 4) };
 62        paras[0].Value = nId;
 63        SqlHelper.ExcuteNonQurey("DELETE FROM [Album] WHERE Id=@Id", CommandType.Text, paras);
 64        BindAlbum();
 65    }
 66    protected void AlbumDataList_EditCommand(object source, DataListCommandEventArgs e)
 67    ...{
 68        AlbumDataList.EditItemIndex = e.Item.ItemIndex;
 69        BindAlbum();
 70    }
 71    protected void AlbumDataList_UpdateCommand(object source, DataListCommandEventArgs e)
 72    ...{
 73        string txtName = ((TextBox)AlbumDataList.Items[e.Item.ItemIndex].FindControl("EditName")).Text.ToString();
 74        int txtSelect = int.Parse(((DropDownList)AlbumDataList.Items[e.Item.ItemIndex].FindControl("SelectVis")).SelectedValue.ToString());
 75        int nId = int.Parse(AlbumDataList.DataKeys[e.Item.ItemIndex].ToString());
 76        FileUpload fi = (FileUpload)AlbumDataList.Items[e.Item.ItemIndex].FindControl("EditImage");
 77        string ff = Path.GetFileName(fi.PostedFile.FileName);
 78        string fileName = string.Empty;
 79
 80        if (string.IsNullOrEmpty(fileName) || fileName.Length < 1)
 81        ...{
 82            SqlParameter[] paras =...{ new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Explain", SqlDbType.NVarChar, 30), new SqlParameter("@Vis", SqlDbType.Bit) };
 83            paras[0].Value = nId;
 84            paras[1].Value = txtName;
 85            paras[2].Value = txtSelect;
 86            SqlHelper.ExcuteNonQurey("UPDATE [Album] set Explain=@Explain,Vis=@Vis WHERE Id=@Id", CommandType.Text, paras);
 87            BindAlbum();
 88
 89        }
 90        else
 91        ...{
 92            fileName = GetMaxId() + ff.Substring(ff.LastIndexOf("."));
 93            string Imgpath = Server.MapPath("../Photo/") + fileName;
 94            fi.PostedFile.SaveAs(Imgpath);
 95            string sqlPath = "Photo\\" + fileName;
 96            SqlParameter[] paras =...{ new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Explain", SqlDbType.NVarChar, 30), new SqlParameter("@Vis", SqlDbType.Bit), new SqlParameter("@Image", SqlDbType.NVarChar, 80) };
 97            paras[0].Value = nId;
 98            paras[1].Value = txtName;
 99            paras[2].Value = txtSelect;
100            paras[3].Value = sqlPath;
101            SqlHelper.ExcuteNonQurey("UPDATE [Album] set Explain=@Explain,Vis=@Vis,Image=@Image WHERE Id=@Id", CommandType.Text, paras);
102
103
104        }
105        AlbumDataList.EditItemIndex = -1;
106        BindAlbum();
107    }
108    protected string GetMaxId() ...{
109
110        object obj = SqlHelper.ExcuteSclare("SelectAabum_MaxId", CommandType.StoredProcedure, null);
111        string getMaxId = string.Empty;
112        if (obj == null)
113        ...{
114
115            getMaxId = "00";
116
117        }
118        else
119        ...{
120
121            getMaxId = "00" + obj.ToString();
122
123        }
124        return getMaxId;
125    
126    }
127    protected void bntAd_Click(object sender, EventArgs e)
128    ...{
129        string txtName = AddName.Text.ToString();
130        string ff = Path.GetFileName(AddImage.PostedFile.FileName);
131        string file = GetMaxId() + ff.Substring(ff.LastIndexOf('.'));
132        int nVis = int.Parse(AddShow.SelectedValue.ToString());
133        if (file.Length < 1)
134        ...{
135
136            Response.Write("<script>alert('请上传图片或flash')</script>");
137
138        }
139        else
140        ...{
141
142            string txtPath = Server.MapPath("../Photo/") + file;
143            AddImage.PostedFile.SaveAs(txtPath);
144            string sqlPath = "Photo\\" + file;
145            SqlParameter[] paras =...{ new SqlParameter("@Explain", SqlDbType.NVarChar, 30), new SqlParameter("@Image", SqlDbType.NVarChar, 80), new SqlParameter("@Vis", SqlDbType.Bit) };
146            paras[0].Value = txtName;
147            paras[1].Value = sqlPath;
148            paras[2].Value = nVis;
149            SqlHelper.ExcuteNonQurey("INSERT INTO [Album](Explain,Image,Vis) VALUES(@Explain,@Image,@Vis)", CommandType.Text, paras);
150            BindAlbum();
151
152        }
153    }
154}
155