1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.SqlClient;
 11using System.Runtime.Serialization;
 12using System.Runtime.Serialization.Formatters.Binary;
 13/**//// <summary>
 14/// DataVisit 的摘要说明
 15/// </summary>
 16public class DataVisit
 17...{
 18    public DataVisit()
 19    ...{
 20        //
 21        // TODO: 在此处添加构造函数逻辑
 22        //
 23    }
 24    public string name;
 25    public string URL;
 26    public string Director;
 27    public string Actor;
 28    public string Detail;
 29    public string time;
 30    public int Hit;
 31    public string Category;
 32    public string Region;
 33    public int playtime;
 34
 35
 36    //从数据库检验用户登录
 37    public bool Confirm(string UserName, string UserPwd)
 38    ...{
 39        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
 40        SqlCommand mycmd = new SqlCommand("Confirm",myconn);
 41        mycmd.CommandType = CommandType.StoredProcedure;
 42        
 43        SqlParameter UserNameparameter = new SqlParameter("@UserName",SqlDbType.VarChar,50);
 44        UserNameparameter.Value = UserName;
 45
 46        SqlParameter UserPwdparameter = new SqlParameter("@UserPwd",SqlDbType.VarChar,50);
 47        UserPwdparameter.Value = UserPwd;
 48
 49        mycmd.Parameters.Add(UserNameparameter);
 50        mycmd.Parameters.Add(UserPwdparameter);
 51  
 52        myconn.Open();
 53        
 54         SqlDataReader mydr = mycmd.ExecuteReader();
 55        if (mydr.Read())
 56        ...{
 57            myconn.Close();
 58            mydr.Close();
 59            mycmd.Dispose();
 60            return true;
 61        }
 62        else
 63        ...{
 64
 65            myconn.Close();
 66            mydr.Close();
 67            mycmd.Dispose();
 68            return false;
 69        }
 70        
 71        
 72    }
 73    //从数据库取出用户角色
 74    public string GetRoles(string UserName)
 75    ...{
 76        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
 77        SqlCommand mycmd = new SqlCommand("GetRoles",myconn);
 78        mycmd.CommandType = CommandType.StoredProcedure;
 79
 80        SqlParameter UserNameparameter = new SqlParameter("@UserName",SqlDbType.VarChar,50);
 81        UserNameparameter.Value = UserName;
 82        mycmd.Parameters.Add(UserNameparameter);
 83
 84        SqlParameter RoleNameparameter = new SqlParameter("@RoleName",SqlDbType.VarChar,50);
 85        RoleNameparameter.Direction = ParameterDirection.Output;
 86        mycmd.Parameters.Add(RoleNameparameter);
 87
 88        myconn.Open();
 89        SqlDataReader mydr = mycmd.ExecuteReader();
 90       
 91        mycmd.Dispose();
 92        myconn.Close();
 93        mydr.Close();
 94
 95        return RoleNameparameter.Value.ToString(); ;
 96
 97    }
 98    //从数据库中取出电影点击排行
 99    public SqlDataReader GetRanked()
100    ...{
101        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
102        SqlCommand mycmd = new SqlCommand("GetRanked",myconn);
103        mycmd.CommandType = CommandType.StoredProcedure;
104
105        myconn.Open();
106
107        SqlDataReader mydr = mycmd.ExecuteReader(CommandBehavior.CloseConnection);
108        //myconn.Close();
109        mycmd.Dispose();
110
111        return mydr;
112            
113     }
114   //从数据库取最近的出电影
115    public SqlDataReader GetNew()
116    ...{
117        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
118        SqlCommand mycmd = new SqlCommand("GetNew", myconn);
119        mycmd.CommandType = CommandType.StoredProcedure;
120
121        myconn.Open();
122
123        SqlDataReader mydr = mycmd.ExecuteReader(CommandBehavior.CloseConnection);
124        //myconn.Close();
125        mycmd.Dispose();
126
127        return mydr;
128    
129    }
130    //验证用户名
131    public bool CheckName(string Name)
132    ...{
133        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
134        SqlCommand mycmd = new SqlCommand("CheckName", myconn);
135        mycmd.CommandType = CommandType.StoredProcedure;
136
137        SqlParameter UserNameparameter = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
138        UserNameparameter.Value =Name;
139        mycmd.Parameters.Add(UserNameparameter);
140
141        myconn.Open();
142        SqlDataReader mydr = mycmd.ExecuteReader();
143        if (mydr.Read())
144        ...{
145            myconn.Close();
146            mydr.Close();
147            mycmd.Dispose();
148            return true;
149        }
150        else
151        ...{
152
153            myconn.Close();
154            mydr.Close();
155            mycmd.Dispose();
156            return false;
157        }
158    }
159    //注册用户
160    public bool Register(string txtname,string txtpwd,string txtemail,string txtsex,string txtxz,string txtphone,string txtqq)
161    ...{
162        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
163        SqlCommand mycmd = new SqlCommand("Register", myconn);
164        mycmd.CommandType = CommandType.StoredProcedure;
165
166        SqlParameter txtnameparameter = new SqlParameter("@txtname", SqlDbType.VarChar, 50);
167        txtnameparameter.Value = txtname;
168        mycmd.Parameters.Add(txtnameparameter);
169
170        SqlParameter txtpwdparameter = new SqlParameter("@txtpwd", SqlDbType.VarChar, 50);
171        txtpwdparameter.Value = txtpwd;
172        mycmd.Parameters.Add(txtpwdparameter);
173
174        SqlParameter txtsexparameter = new SqlParameter("@txtsex", SqlDbType.VarChar, 50);
175        txtsexparameter.Value = txtsex;
176        mycmd.Parameters.Add(txtsexparameter);
177
178        SqlParameter txtxzparameter = new SqlParameter("@txtxz", SqlDbType.VarChar, 50);
179        txtxzparameter.Value = txtxz;
180        mycmd.Parameters.Add(txtxzparameter);
181
182        SqlParameter txtemailparameter = new SqlParameter("@txtemail", SqlDbType.VarChar, 50);
183        txtemailparameter.Value = txtemail;
184        mycmd.Parameters.Add(txtemailparameter);
185
186        SqlParameter txtphoneparameter = new SqlParameter("@txtphone", SqlDbType.VarChar , 50);
187        txtphoneparameter.Value = txtphone;
188        mycmd.Parameters.Add(txtphoneparameter);
189
190        SqlParameter txtqqparameter = new SqlParameter("@txtqq", SqlDbType.VarChar , 50);
191        txtqqparameter.Value = txtqq;
192        mycmd.Parameters.Add(txtqqparameter);
193
194        myconn.Open();
195        SqlDataReader mydr = mycmd.ExecuteReader();
196        mycmd.Dispose();
197        mydr.Close();
198        myconn.Close();
199
200        return true;
201    }
202   
203   //电影列表
204    public DataTable getCategory(string category)
205    ...{
206        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ConnectionString);
207        SqlCommand mycmd = new SqlCommand("getCategory",myconn);
208        mycmd.CommandType = CommandType.StoredProcedure;
209
210        SqlParameter categoryparameter = new SqlParameter("@category",SqlDbType.VarChar,50);
211        categoryparameter.Value = category;
212        mycmd.Parameters.Add(categoryparameter);
213
214        SqlDataAdapter myda = new SqlDataAdapter();
215        myda.SelectCommand = mycmd;
216        
217        DataSet myds = new DataSet();
218        myda.Fill(myds);
219
220        myconn.Close();
221        mycmd.Dispose();
222        myda.Dispose();
223
224        
225        return myds.Tables[0];
226     
227    
228    }
229    //电影详细信息
230    public void FilmDetail(int FilmID)
231    ...{
232        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
233        SqlCommand mycmd = new SqlCommand("FilmDetail", myconn);
234        mycmd.CommandType = CommandType.StoredProcedure;
235
236        SqlParameter FilmIDparameter = new SqlParameter("@FilmID", SqlDbType.Int, 4);
237        FilmIDparameter.Value = FilmID;
238        mycmd.Parameters.Add(FilmIDparameter);
239
240        SqlParameter URLparameter = new SqlParameter("@URL",SqlDbType.VarChar,50);
241        URLparameter.Direction = ParameterDirection.Output;
242        mycmd.Parameters.Add(URLparameter);
243
244        SqlParameter nameparameter = new SqlParameter("@name", SqlDbType.VarChar, 50);
245        nameparameter.Direction = ParameterDirection.Output;
246        mycmd.Parameters.Add(nameparameter);
247
248        SqlParameter Directorparameter = new SqlParameter("@Director", SqlDbType.VarChar, 50);
249        Directorparameter.Direction = ParameterDirection.Output;
250        mycmd.Parameters.Add(Directorparameter);
251
252        SqlParameter Actorparameter = new SqlParameter("@Actor", SqlDbType.VarChar, 50);
253        Actorparameter.Direction = ParameterDirection.Output;
254        mycmd.Parameters.Add(Actorparameter);
255
256        SqlParameter Detailparameter = new SqlParameter("@Detail", SqlDbType.VarChar, 4000);
257        Detailparameter.Direction = ParameterDirection.Output;
258        mycmd.Parameters.Add(Detailparameter);
259
260        SqlParameter timeparameter = new SqlParameter("@time", SqlDbType.VarChar, 50);
261        timeparameter.Direction = ParameterDirection.Output;
262        mycmd.Parameters.Add(timeparameter);
263
264        SqlParameter Hitparameter = new SqlParameter("@Hit", SqlDbType.Int, 4);
265        Hitparameter.Direction = ParameterDirection.Output;
266        mycmd.Parameters.Add(Hitparameter);
267
268        SqlParameter Categoryparameter = new SqlParameter("@Category", SqlDbType.VarChar, 50);
269        Categoryparameter.Direction = ParameterDirection.Output;
270        mycmd.Parameters.Add(Categoryparameter);
271
272        SqlParameter Regionparameter = new SqlParameter("@Region", SqlDbType.VarChar, 50);
273        Regionparameter.Direction = ParameterDirection.Output;
274        mycmd.Parameters.Add(Regionparameter);
275
276        SqlParameter playtimeparameter = new SqlParameter("@playtime", SqlDbType.Int, 4);
277        playtimeparameter.Direction = ParameterDirection.Output;
278        mycmd.Parameters.Add(playtimeparameter);
279
280        myconn.Open();
281        mycmd.ExecuteNonQuery();
282
283
284        name = nameparameter.Value.ToString();
285        URL = URLparameter.Value.ToString();
286        Director =Directorparameter.Value.ToString();
287        Actor = Actorparameter.Value.ToString();
288        Detail = Detailparameter.Value.ToString();
289        time = timeparameter.Value.ToString();
290        Hit =Convert.ToInt32( Hitparameter.Value);
291        Category = Categoryparameter.Value.ToString();
292        Region = Regionparameter.Value.ToString();
293        playtime =Convert.ToInt32( playtimeparameter.Value);
294
295        myconn.Close();
296        mycmd.Dispose();
297    }
298    //获取电影地址
299    public string getURL(int filmid)
300    ...{
301        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ConnectionString);
302        SqlCommand mycmd = new SqlCommand("getURL", myconn);
303        mycmd.CommandType = CommandType.StoredProcedure;
304
305
306        SqlParameter playurlparameter = new SqlParameter("@playurl", SqlDbType.VarChar, 50);
307        playurlparameter.Direction=ParameterDirection.Output;
308        mycmd.Parameters.Add(playurlparameter);
309        
310        SqlParameter idparemeter = new SqlParameter("@filmid",SqlDbType.Int,4);
311        idparemeter.Value = filmid;
312        mycmd.Parameters.Add(idparemeter);
313
314        myconn.Open();
315        mycmd.ExecuteNonQuery();
316
317        myconn.Close();
318        mycmd.Dispose();
319
320        return playurlparameter.Value.ToString();
321    
322    }
323    //查询结果
324    public DataTable seachFilm(string FilmName,string ActorName,string Director,string timeOn)
325    ...{
326        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ConnectionString);
327        SqlCommand mycmd = new SqlCommand("getResult", myconn);
328        mycmd.CommandType = CommandType.StoredProcedure;
329
330        SqlParameter FilmNameparameter = new SqlParameter("@FilmName", SqlDbType.VarChar, 50);
331        FilmNameparameter.Value = FilmName;
332        mycmd.Parameters.Add(FilmNameparameter);
333        
334        SqlParameter ActorNameparameter = new SqlParameter("@ActorName", SqlDbType.VarChar, 50);
335        ActorNameparameter.Value = ActorName;
336        mycmd.Parameters.Add(ActorNameparameter);
337
338        SqlParameter Directorparameter = new SqlParameter("@Director", SqlDbType.VarChar, 50);
339        Directorparameter.Value = Director;
340        mycmd.Parameters.Add(Directorparameter);
341
342        SqlParameter timeOnparameter = new SqlParameter("@timeOn", SqlDbType.VarChar, 50);
343        timeOnparameter.Value =timeOn;
344        mycmd.Parameters.Add(timeOnparameter);
345
346        SqlDataAdapter myda = new SqlDataAdapter();
347        myda.SelectCommand = mycmd;
348
349        DataSet myds = new DataSet();
350        myda.Fill(myds);
351
352        myconn.Close();
353        mycmd.Dispose();
354        myda.Dispose();
355
356
357        return myds.Tables[0];
358    }
359    //修改用户信息
360    public void change(string name,string pwd,string email,string phone,string qq)
361    ...{
362        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
363        SqlCommand mycmd = new SqlCommand("change", myconn);
364        mycmd.CommandType = CommandType.StoredProcedure;
365
366        SqlParameter txtpwdparameter = new SqlParameter("@pwd", SqlDbType.VarChar, 50);
367        txtpwdparameter.Value = pwd;
368        mycmd.Parameters.Add(txtpwdparameter);
369
370        SqlParameter txtemailparameter = new SqlParameter("@email", SqlDbType.VarChar, 50);
371        txtemailparameter.Value = email;
372        mycmd.Parameters.Add(txtemailparameter);
373
374        SqlParameter txtphoneparameter = new SqlParameter("@phone", SqlDbType.VarChar, 50);
375        txtphoneparameter.Value = phone;
376        mycmd.Parameters.Add(txtphoneparameter);
377
378        SqlParameter txtqqparameter = new SqlParameter("@qq", SqlDbType.VarChar, 50);
379        txtqqparameter.Value = qq;
380        mycmd.Parameters.Add(txtqqparameter);
381
382        SqlParameter nameparameter = new SqlParameter("@name", SqlDbType.VarChar, 50);
383        nameparameter.Value = name;
384        mycmd.Parameters.Add(nameparameter);
385
386     
387
388        myconn.Open();
389        mycmd.ExecuteNonQuery();
390
391        myconn.Close();
392        mycmd.Dispose();
393
394    }
395    //获取用户收藏
396    public DataSet getfavor(string name)
397