string   strConn=ConfigurationSettings.AppSettings["strcon"];   

  SqlConnection   cn=new   SqlConnection(strConn);   

  cn.Open();   

    

  String   strSQL="insert   into   dat_jch(criqi,jcksdate,jcjsdate,jcnr,jcrenci,jczhidu,jcren,jclrdate)"+   

  "   values(@jcriqi,@jcksdate,@jcjsdate,@jcnr,@jcrenci,@jczhidu,@jcren,@jclrdate   );"+   

  "   select   @@IDENTITY   as   'Identity'";       

  SqlCommand   cm=new   SqlCommand(strSQL,cn);   

    

  cm.Parameters.Add(new   SqlParameter("@jcriqi",SqlDbType.SmallDateTime   ));   

  cm.Parameters.Add(new   SqlParameter("@jcksdate",SqlDbType.NVarChar,20   ));       

  cm.Parameters.Add(new   SqlParameter("@jcjsdate",SqlDbType.NVarChar   ,20));   

  cm.Parameters.Add(new   SqlParameter("@jcnr",SqlDbType.Char   ,500));   

  cm.Parameters.Add(new   SqlParameter("@jcrenci",SqlDbType.NVarChar   ,10   ));   

  cm.Parameters.Add(new   SqlParameter("@jczhidu",SqlDbType.NVarChar,50   ));   

  cm.Parameters.Add(new   SqlParameter("@jcren",SqlDbType.NVarChar,10   ));       

  cm.Parameters.Add(new   SqlParameter("@jclrdate",SqlDbType.SmallDateTime     ));       

  cm.Parameters["@jcriqi"].Value=Convert.ToDateTime(shijian.Text);   

  cm.Parameters["@jcksdate"].Value=wang.Text.Trim();   

  cm.Parameters["@jcjsdate"].Value=fan.Text.Trim();   

  cm.Parameters["@jcnr"].Value=neirong.Text.Trim();   

  cm.Parameters["@jcrenci"].Value=renci.Text   .Trim();   

  cm.Parameters["@jczhidu"].Value=zhidu.Text.Trim();   

  cm.Parameters["@jcren"].Value=Session["gonghao"].ToString();   

  cm.Parameters["@jclrdate"].Value=DateTime.Now   ;   

    

  try   

  {   

        idd=Convert.ToInt32(cm.ExecuteScalar());   

        message.Text="信息单成功保存！";   

    

  }   

  catch(SqlException)   

  {   

        message.Text="信息单保存失败！";   

  }