public int insert_apoinfo(T_stuinfo ts)
        {
            string        sname   = ts.sname;
            string        sgender = ts.sgender;
            string        sphone  = ts.sphone;
            string        tname   = ts.tname;
            string        apotime = ts.apo_time;
            string        remark  = ts.remark;
            string        preiod  = ts.preiod;
            StringBuilder sb      = new StringBuilder();

            sb.Append("insert into T_apoinfo values(");
            sb.Append("@sname,@sphone,@tname,@sgender,@apotime,@remark,@preiod");
            sb.Append(")");
            SqlParameter[] paras =
            {
                new SqlParameter("@sname",   sname),
                new SqlParameter("@sphone",  sphone),
                new SqlParameter("@tname",   tname),
                new SqlParameter("@sgender", sgender),
                new SqlParameter("@apotime", apotime),
                new SqlParameter("@remark",  remark),
                new SqlParameter("@preiod",  preiod),
            };
            return(SqlHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, paras));
        }
Esempio n. 2
0
 public int insert_apoinfo(T_stuinfo ts)
 {
     return(ADal.insert_apoinfo(ts));
 }