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)); }
public int insert_apoinfo(T_stuinfo ts) { return(ADal.insert_apoinfo(ts)); }