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;
 11//¸ÃÔ´ÂëÏÂÔØ×Ôwww.51aspx.com(£µ£±£á£ó£ð£ø£®£ã£ï£í)
 12/**//// <summary>
 13/// SciResearchClass µÄժҪ˵Ã÷
 14/// </summary>
 15public class SciResearchClass
 16...{
 17    DBClass dbObj = new DBClass();
 18    public SciResearchClass()
 19    ...{
 20        //
 21        // TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
 22        //
 23    }
 24    /**//// <summary>
 25    /// ²éѯ½ÌʦµÄ¿ÆÑÐ×ÊÁÏ£¬½«ÆäÏÔʾÔÚ½çÃæÉÏ
 26    /// </summary>
 27    /// <param name="P_Int_type">±êÖ¾(1±íʾÔÚÑпÎÌâ,2±íʾ·¢±íÂÛÎÄ£¬3±íʾÂÛÖøÇé¿ö,4±íʾ»ñ½±Çé¿ö)</param>
 28    /// <returns>SqlCommand¶ÔÏó</returns>
 29    public SqlCommand GetASRCmd(int P_Int_type)
 30    ...{
 31        SqlConnection myConn = dbObj.GetConnection();
 32        SqlCommand myCmd = new SqlCommand("Proc_GetAllSRInfo", myConn);
 33        myCmd.CommandType = CommandType.StoredProcedure;
 34        //Ìí¼Ó²ÎÊý
 35        SqlParameter type = new SqlParameter("@type", SqlDbType.Int, 4);
 36        type.Value = P_Int_type;
 37        myCmd.Parameters.Add(type);
 38        //Ö´Ðйý³Ì
 39        myConn.Open();
 40        try
 41        ...{
 42            myCmd.ExecuteNonQuery();
 43        }
 44        catch
 45        ...{
 46            myCmd.Dispose();
 47            myConn.Close();
 48
 49        }
 50        myCmd.Dispose();
 51        myConn.Close();
 52        return myCmd;
 53
 54    }
 55    //=============================================================
 56    // ·½ ·¨ Ãû£º GetSSRCmd()
 57    // ¹¦ÄÜÃèÊö£º »ñÈ¡SqlCommand(ÒÔ½ÌÔ±µÄÉí·Ý½øÈ룬ÏÔʾ½ÌʦµÄ¿ÆÑÐ×ÊÁÏ)
 58    // ÊäÈë²ÎÊý£º ±êÖ¾(1±íʾÔÚÑпÎÌâ,2±íʾ·¢±íÂÛÎÄ£¬3±íʾÂÛÖøÇé¿ö,4±íʾ»ñ½±Çé¿ö)
 59    // ·µ »Ø Öµ£º ·µ»ØSqlCommand
 60    // ==============================================================
 61    public SqlCommand GetSSRCmd(int P_Int_type, int P_Int_owner)
 62    ...{
 63        SqlConnection myConn = dbObj.GetConnection();
 64        SqlCommand myCmd = new SqlCommand("Proc_GetSelfSRInfo", myConn);
 65        myCmd.CommandType = CommandType.StoredProcedure;
 66        //Ìí¼Ó²ÎÊý
 67        SqlParameter type = new SqlParameter("@type", SqlDbType.Int, 4);
 68        type.Value = P_Int_type;
 69        myCmd.Parameters.Add(type);
 70        //Ìí¼Ó²ÎÊý
 71        SqlParameter owner = new SqlParameter("@owner", SqlDbType.Int, 4);
 72        owner.Value = P_Int_owner;
 73        myCmd.Parameters.Add(owner);
 74        //Ö´Ðйý³Ì
 75        myConn.Open();
 76        try
 77        ...{
 78            myCmd.ExecuteNonQuery();
 79        }
 80        catch
 81        ...{
 82            myCmd.Dispose();
 83            myConn.Close();
 84
 85        }
 86        myCmd.Dispose();
 87        myConn.Close();
 88        return myCmd;
 89
 90    }
 91    /**//// <summary>
 92    /// ɾ³ý½ÌʦµÄ¿ÆѧÑо¿×ÊÁÏ
 93    /// </summary>
 94    /// <param name="P_Int_id">Ψһ±àºÅ</param>
 95    public void DeleteSRInfo(int P_Int_id)
 96    ...{
 97        SqlConnection myConn = dbObj.GetConnection();
 98        SqlCommand myCmd = new SqlCommand("Proc_DeleteSR", myConn);
 99        myCmd.CommandType = CommandType.StoredProcedure;
100        //Ìí¼Ó²ÎÊý
101        SqlParameter id = new SqlParameter("@id", SqlDbType.Int, 4);
102        id.Value = P_Int_id;
103        myCmd.Parameters.Add(id);
104        //Ö´Ðйý³Ì
105        myConn.Open();
106        try
107        ...{
108            myCmd.ExecuteNonQuery();
109        }
110        catch
111        ...{
112            myCmd.Dispose();
113            myConn.Close();
114
115        }
116        myCmd.Dispose();
117        myConn.Close();
118
119    }
120    //=============================================================
121    // ·½ ·¨ Ãû£º ReturnSRDs()
122    // ¹¦ÄÜÃèÊö£º ÔÚ¶Ô½ÌʦµÄ¿ÆÑÐÐÞ¸Äʱ£¬»ñÈ¡×ÊÁϵÄÊý¾Ý¼¯Dataset
123    // ÊäÈë²ÎÊý£º ×ÊÁϵÄΨһ±àºÅ
124    // ·µ »Ø Öµ£º ÎÞ
125    // ==============================================================
126    public DataSet ReturnSRDs(int P_Int_type, int P_Int_id, string P_Str_srcTable)
127    ...{
128        SqlConnection myConn = dbObj.GetConnection();
129        SqlCommand myCmd = new SqlCommand("Proc_GetUSRInfo", myConn);
130        myCmd.CommandType = CommandType.StoredProcedure;
131        //Ìí¼Ó²ÎÊý
132        SqlParameter type = new SqlParameter("@type", SqlDbType.Int, 4);
133        type.Value = P_Int_type;
134        myCmd.Parameters.Add(type);
135        //Ìí¼Ó²ÎÊý
136        SqlParameter id = new SqlParameter("@id", SqlDbType.Int, 4);
137        id.Value = P_Int_id;
138        myCmd.Parameters.Add(id);
139        //Ö´Ðйý³Ì
140        myConn.Open();
141        try
142        ...{
143            myCmd.ExecuteNonQuery();
144        }
145        catch
146        ...{
147            myCmd.Dispose();
148            myConn.Close();
149
150        }
151        SqlDataAdapter da = new SqlDataAdapter(myCmd);
152        DataSet ds = new DataSet();
153        da.Fill(ds, P_Str_srcTable);
154        myCmd.Dispose();
155        myConn.Close();
156        return ds;
157
158    }
159    /**//// <summary>
160    /// Ïò±ítb_researchÖÐÌí¼Ó½ÌʦµÄ¿ÆѧÑо¿×ÊÁÏ
161    /// </summary>
162    /// <param name="P_Str_name">ÏîÄ¿Ãû³Æ/ÂÛÎÄÌâÄ¿/ÂÛÖøÃû³Æ/»ñ½±Ãû³Æ</param>
163    /// <param name="P_Str_lessonName">·¢±í¿¯Îï/³ö°æÉç/»ñ½±ÏîÄ¿Ãû³Æ</param>
164    /// <param name="P_Str_author">×鳤/Ö÷±à</param>
165    /// <param name="P_Str_worker">ºÏ×÷Õß</param>
166    /// <param name="P_Str_Froming">ÏîÄ¿À´Ô´/Äê.¾í.ÆÚ.Ò³/±¸×¢</param>
167    /// <param name="P_Str_startendTime">ÆðÖ¹ÄêÔÂ/³ö°æʱ¼ä/»ñ½±Ê±¼ä</param>
168    /// <param name="P_Str_unit">×ÊÖú½ð·Ñ/ÊÚÓ赥λ</param>
169    /// <param name="P_Int_type">1(´ú±íÔÚÑпÎÌâ)2(´ú±í·¢±íÂÛÎÄ)3(ÂÛÖøÇé¿ö)4(»ñ½±Çé¿ö)</param>
170    /// <param name="P_Int_owner">Êý¾ÝËùÓÐÕߵıàºÅ</param>
171    /// <param name="P_Str_adder">Êý¾ÝÌí¼ÓÈË</param>
172    /// <param name="P_Str_changer">Êý¾ÝÐÞ¸ÄÈË</param>
173    /// <param name="P_Int_yearInfo">Êý¾Ý²Ù×÷Äê·Ý</param>
174    public void AddSRInfo(string P_Str_name, string P_Str_lessonName, string P_Str_author, string P_Str_worker, string P_Str_Froming, string P_Str_startendTime, string P_Str_unit, int P_Int_type, int P_Int_owner, string P_Str_adder, string P_Str_changer, int P_Int_yearInfo,int P_Int_adderId)
175    ...{
176        SqlConnection myConn = dbObj.GetConnection();
177        SqlCommand myCmd = new SqlCommand("Proc_AddSRI", myConn);
178        myCmd.CommandType = CommandType.StoredProcedure;
179        //Ìí¼Ó²ÎÊý
180        SqlParameter name = new SqlParameter("@name", SqlDbType.NVarChar, 50);
181        name.Value = P_Str_name;
182        myCmd.Parameters.Add(name);
183        //Ìí¼Ó²ÎÊý
184        SqlParameter lessonName = new SqlParameter("@lessonName", SqlDbType.NVarChar, 50);
185        lessonName.Value = P_Str_lessonName;
186        myCmd.Parameters.Add(lessonName);
187        //Ìí¼Ó²ÎÊý
188        SqlParameter author = new SqlParameter("@author", SqlDbType.NVarChar, 50);
189        author.Value = P_Str_author;
190        myCmd.Parameters.Add(author);
191        //Ìí¼Ó²ÎÊý
192        SqlParameter worker = new SqlParameter("@worker", SqlDbType.NVarChar, 50);
193        worker.Value = P_Str_worker;
194        myCmd.Parameters.Add(worker);
195        //Ìí¼Ó²ÎÊý
196        SqlParameter Froming = new SqlParameter("@Froming", SqlDbType.NText, 16);
197        Froming.Value = P_Str_Froming;
198        myCmd.Parameters.Add(Froming);
199        //Ìí¼Ó²ÎÊý
200        SqlParameter startendTime = new SqlParameter("@startendTime", SqlDbType.NVarChar, 50);
201        startendTime.Value = P_Str_startendTime;
202        myCmd.Parameters.Add(startendTime);
203        //Ìí¼Ó²ÎÊý
204        SqlParameter unit = new SqlParameter("@unit", SqlDbType.NVarChar, 50);
205        unit.Value = P_Str_unit;
206        myCmd.Parameters.Add(unit);
207        //Ìí¼Ó²ÎÊý
208        SqlParameter type = new SqlParameter("@type", SqlDbType.Int, 4);
209        type.Value = P_Int_type;
210        myCmd.Parameters.Add(type);
211        //Ìí¼Ó²ÎÊý
212        SqlParameter owner = new SqlParameter("@owner", SqlDbType.Int, 4);
213        owner.Value = P_Int_owner;
214        myCmd.Parameters.Add(owner);
215        //Ìí¼Ó²ÎÊý
216        SqlParameter adder = new SqlParameter("@adder", SqlDbType.NVarChar, 50);
217        adder.Value = P_Str_adder;
218        myCmd.Parameters.Add(adder);
219        //Ìí¼Ó²ÎÊý
220        SqlParameter changer = new SqlParameter("@changer", SqlDbType.NVarChar, 50);
221        changer.Value = P_Str_changer;
222        myCmd.Parameters.Add(changer);
223        //Ìí¼Ó²ÎÊý
224        SqlParameter yearInfo = new SqlParameter("@yearInfo", SqlDbType.Int, 4);
225        yearInfo.Value = P_Int_yearInfo;
226        myCmd.Parameters.Add(yearInfo);
227        //Ìí¼Ó²ÎÊý
228        SqlParameter adderId = new SqlParameter("@adderId", SqlDbType.Int, 4);
229        adderId.Value = P_Int_adderId;
230        myCmd.Parameters.Add(adderId);
231        //Ö´Ðйý³Ì
232        myConn.Open();
233        try
234        ...{
235            myCmd.ExecuteNonQuery();
236        }
237        catch
238        ...{
239            myCmd.Dispose();
240            myConn.Close();
241
242        }
243        myCmd.Dispose();
244        myConn.Close();
245
246    }
247    /**//// <summary>
248    /// ÔÚ±ítb_researchÖÐÐ޸ĽÌʦµÄ½ÌѧÑо¿×ÊÁÏ
249    /// </summary>
250    /// <param name="P_Int_id">Ψһ±àºÅ</param>
251    /// <param name="P_Str_name">ÏîÄ¿Ãû³Æ/ÂÛÎÄÌâÄ¿/ÂÛÖøÃû³Æ/»ñ½±Ãû³Æ</param>
252    /// <param name="P_Str_lessonName">·¢±í¿¯Îï/³ö°æÉç/»ñ½±ÏîÄ¿Ãû³Æ</param>
253    /// <param name="P_Str_author">×鳤/Ö÷±à</param>
254    /// <param name="P_Str_worker">ºÏ×÷Õß</param>
255    /// <param name="P_Str_Froming">ÏîÄ¿À´Ô´/Äê.¾í.ÆÚ.Ò³/±¸×¢</param>
256    /// <param name="P_Str_startendTime">ÆðÖ¹ÄêÔÂ/³ö°æʱ¼ä/»ñ½±Ê±¼ä</param>
257    /// <param name="P_Str_unit">×ÊÖú½ð·Ñ/ÊÚÓ赥λ</param>
258    /// <param name="P_Str_changer">Êý¾ÝÐÞ¸ÄÈË</param>
259    /// <param name="P_Int_yearInfo">Êý¾Ý²Ù×÷Äê·Ý</param>
260    public void UpdateSRInfo(int P_Int_id, string P_Str_name, string P_Str_lessonName, string P_Str_author, string P_Str_worker, string P_Str_Froming, string P_Str_startendTime, string P_Str_unit, string P_Str_changer, int P_Int_yearInfo,int P_Int_changerId)
261    ...{
262        SqlConnection myConn = dbObj.GetConnection();
263        SqlCommand myCmd = new SqlCommand("Proc_UpdateSR", myConn);
264        myCmd.CommandType = CommandType.StoredProcedure;
265        //Ìí¼Ó²ÎÊý
266        SqlParameter id = new SqlParameter("@id", SqlDbType.Int, 4);
267        id.Value = P_Int_id;
268        myCmd.Parameters.Add(id);
269        //Ìí¼Ó²ÎÊý
270        SqlParameter name = new SqlParameter("@name", SqlDbType.NVarChar, 50);
271        name.Value = P_Str_name;
272        myCmd.Parameters.Add(name);
273        //Ìí¼Ó²ÎÊý
274        SqlParameter lessonName = new SqlParameter("@lessonName", SqlDbType.NVarChar, 50);
275        lessonName.Value = P_Str_lessonName;
276        myCmd.Parameters.Add(lessonName);
277        //Ìí¼Ó²ÎÊý
278        SqlParameter author = new SqlParameter("@author", SqlDbType.NVarChar, 50);
279        author.Value = P_Str_author;
280        myCmd.Parameters.Add(author);
281        //Ìí¼Ó²ÎÊý
282        SqlParameter worker = new SqlParameter("@worker", SqlDbType.NVarChar, 50);
283        worker.Value = P_Str_worker;
284        myCmd.Parameters.Add(worker);
285        //Ìí¼Ó²ÎÊý
286        SqlParameter Froming = new SqlParameter("@Froming", SqlDbType.NText, 16);
287        Froming.Value = P_Str_Froming;
288        myCmd.Parameters.Add(Froming);
289        //Ìí¼Ó²ÎÊý
290        SqlParameter startendTime = new SqlParameter("@startendTime", SqlDbType.NVarChar, 50);
291        startendTime.Value = P_Str_startendTime;
292        myCmd.Parameters.Add(startendTime);
293        //Ìí¼Ó²ÎÊý
294        SqlParameter unit = new SqlParameter("@unit", SqlDbType.NVarChar, 50);
295        unit.Value = P_Str_unit;
296        myCmd.Parameters.Add(unit);
297        //Ìí¼Ó²ÎÊý
298        SqlParameter changer = new SqlParameter("@changer", SqlDbType.NVarChar, 50);
299        changer.Value = P_Str_changer;
300        myCmd.Parameters.Add(changer);
301        //Ìí¼Ó²ÎÊý
302        SqlParameter yearInfo = new SqlParameter("@yearInfo", SqlDbType.Int, 4);
303        yearInfo.Value = P_Int_yearInfo;
304        myCmd.Parameters.Add(yearInfo);
305        //Ìí¼Ó²ÎÊý
306        SqlParameter changerId = new SqlParameter("@changerId", SqlDbType.Int, 4);
307        changerId.Value = P_Int_changerId;
308        myCmd.Parameters.Add(changerId);
309        //Ö´Ðйý³Ì
310        myConn.Open();
311        try
312        ...{
313            myCmd.ExecuteNonQuery();
314        }
315        catch
316        ...{
317
318            myCmd.Dispose();
319            myConn.Close();
320
321        }
322        myCmd.Dispose();
323        myConn.Close();
324
325    }
326}
327