//365存入金额 //public string SaveTSFIn(string mJE, string mDate) //{ // SqlConnection conn = new SqlConnection(sql); // SqlCommand cmd = conn.CreateCommand(); // cmd.CommandText = string.Format("insert into tb_plan_detail (je,Svdate) values ({0},'{1}')",je,DateTime.Now.ToString("yyyy-MM-dd")); // conn.Open(); // int result = cmd.ExecuteNonQuery(); // //关闭数据库 // conn.Close(); // return ""; //} //存入金额 public string SaveIn(string je) { //SqlConnection conn = new SqlConnection(sql); //SqlCommand cmd = conn.CreateCommand(); //cmd.CommandText = string.Format("insert into tb_plan_detail (je,Svdate) values (@je,@Svdate)", je, ); //conn.Open(); //int result = cmd.ExecuteNonQuery(); string mSql = "insert into tb_plan_detail (je,Svdate,UserID) values (@je,@Svdate,@UserID)"; SqlParameter[] sp = new SqlParameter[3]; sp[0] = new SqlParameter("@je", je); sp[1] = new SqlParameter("@Svdate", DateTime.Now.ToString("yyyy-MM-dd")); sp[2] = new SqlParameter("@UserID", "MguliN"); return(sh.InsertNew(mSql, sp)); }