GetSubject.doc

using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using property.model.SubjectInfo; using property.model.GetConnection; using System.Data; using System.Windows.Forms; namespace property.control.Subject { class GetSubject { SqlCommand cmd = null; SqlConnection con = null; DataSet ds = new DataSet(); SubInfo sub = new SubInfo(); GetConnection getCon = new GetConnection();//调用实体类联接数据库 #region //添加 public string subjectInsert(SubInfo sub) public string subjectInsert(SubInfo sub) { string P_str_result = null; try { P_str_result = this.FindID(sub.getsubId());//调用函数，检查编号是否存在重复 if (P_str_result == NO)// 不重复可用＝“OK”时重复 { con = getCon.GetCon(); cmd = new SqlCommand(); string P_str_insert = insert into tb_subjectInfo (subId,subGkb,subName,subMoney,subPage); P_str_insert+=values( + sub.getsubId() + , + sub.getsubGkb() + , + sub.getsubName() + ,+sub.getsubMoney()+, + sub.getsubPage() + ); cmd.CommandText = P_str_insert; cmd.Connection = con; int P_int_inst = cmd.ExecuteNonQuery(); if (P_int_inst == 1) { P_str_result = insetOk; }// end block if else { P_str_result = insetNo; }// end blcok if cmd.Connection.Close(); con.Close(); }// end blokc if return P_str_result; }// end block try catch (Exception e) { P_str_result = addError; return P_str_result; }// end blokc catch }//end block method subjectInsert #endreg